SPAR_NTAB SAP (Parameter Storage: Nametab) Structure details

Dictionary Type: Structure
Description: Parameter Storage: Nametab




ABAP Code to SELECT data from SPAR_NTAB
Related tables to SPAR_NTAB
Access table SPAR_NTAB




Structure field list including key, data, relationships and ABAP select examples

SPAR_NTAB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Parameter Storage: Nametab" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_SPAR_NTAB TYPE SPAR_NTAB.

The SPAR_NTAB table consists of various fields, each holding specific information or linking keys about Parameter Storage: Nametab data available in SAP. These include OBJNAME (Name of Dictionary Type), OBJTYPE (Table category), REFOBJECT (Name of Dictionary Type), FUSER (Created by).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP SPAR_NTAB structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
OBJNAMEName of Dictionary Type TYPENAMECHAR30OBJECTNAMEDTYPDD_TYPES
OBJTYPETable category TABCLASSCHAR8TABCLASS
REFOBJECTName of Dictionary Type TYPENAMECHAR30OBJECTNAMEDTYPDD_TYPES
FUSERCreated by HIER_FUSERCHAR12HIER_USER
FDATECreated on HIER_FDATEDATS8SYDATS
FTIMECreated at HIER_FTIMETIMS6SYTIME
FRELEASERelease of SAP System SYSAPRLCHAR4SYCHAR04
LUSERLast changed by HIER_LUSERCHAR12HIER_USER
LDATELast Changed On HIER_LDATEDATS8SYDATS
LTIMETime of Last Change HIER_LTIMETIMS6SYTIME
LRELEASERelease of SAP System SYSAPRLCHAR4SYCHAR04
OBJDFIES 0
TABNAMETable Name TABNAMECHAR30AS4TABDTB
FIELDNAMEField Name FIELDNAMECHAR30FDNAMEDFD
LANGULanguage Key DDLANGUAGELANG1ISOLASPRAS
POSITIONPosition of the field in the table TABFDPOSNUMC4AS4POS
OFFSETOffset of a field DOFFSETNUMC6DOFFSET
DOMNAMEDomain name DOMNAMECHAR30DOMNAMEDD_DOMA
ROLLNAMEData element (semantic domain) ROLLNAMECHAR30ROLLNAMEROLDD_DTEL
CHECKTABLETable Name TABNAMECHAR30AS4TABDTB
LENGLength (No. of Characters) DDLENGNUMC6DDLENG
INTLENInternal Length in Bytes INTLENNUMC6DDLENG
OUTPUTLENOutput Length OUTPUTLENNUMC6DDLENG
DECIMALSNumber of Decimal Places DECIMALSNUMC6DDLENG
DATATYPEABAP/4 Dictionary: Screen data type for Screen Painter DYNPTYPECHAR4DATATYPE
INTTYPEABAP data type (C,D,N,...) INTTYPECHAR1INTTYPE
REFTABLETable for reference field REFTABLECHAR30AS4TAB
REFFIELDReference field for currency and qty fields REFFIELDCHAR30FDNAME
PRECFIELDName of included table PRECFIELDCHAR30FDNAME
AUTHORIDAuthorization class AUTHORIDCHAR3AUTHORID
MEMORYIDSet/Get parameter ID MEMORYIDCHAR20MEMORYID
LOGFLAGIndicator for writing change documents LOGFLAGCHAR1AS4FLAG
MASKTemplate (not used) AS4MASKCHAR20AS4MASK
MASKLENTemplate length (not used) MASKLENNUMC4MASKLEN
CONVEXITConversion Routine CONVEXITCHAR5CONVEXIT
HEADLENMaximum length of heading HEADLENNUMC2SCRLEN
SCRLEN1Max. length for short field label SCRLEN_SNUMC2SCRLEN
SCRLEN2Max. length for medium field label SCRLEN_MNUMC2SCRLEN
SCRLEN3Max. length for long field label SCRLEN_LNUMC2SCRLEN
FIELDTEXTShort Description of Repository Objects AS4TEXTCHAR60AS4TEXT
REPTEXTHeading REPTEXTCHAR55REPTEXT
SCRTEXT_SShort Field Label SCRTEXT_SCHAR10SCRTEXT_S
SCRTEXT_MMedium Field Label SCRTEXT_MCHAR20SCRTEXT_M
SCRTEXT_LLong Field Label SCRTEXT_LCHAR40SCRTEXT_L
KEYFLAGIdentifies a key field of a table KEYFLAGCHAR1KEYFLAG
LOWERCASELowercase letters allowed/not allowed LOWERCASECHAR1AS4FLAG
MACFlag if search help is attached to the field DDSHATTACHCHAR1DDBOOL
GENKEYFlag (X or Blank) AS4FLAGCHAR1AS4FLAG
NOFORKEYFlag (X or Blank) AS4FLAGCHAR1AS4FLAG
VALEXIExistence of fixed values VALEXICHAR1AS4FLAG
NOAUTHCHFlag (X or Blank) AS4FLAGCHAR1AS4FLAG
SIGNFlag for sign in numerical fields SIGNFLAGCHAR1AS4FLAG
DYNPFLDFlag: field to be displayed on the screen DYNPROFLDCHAR1AS4FLAG
F4AVAILABLDoes the field have an input help DDF4AVAILCHAR1DDBOOL
COMPTYPEDD: Component Type COMPTYPECHAR1COMPTYPE
LFIELDNAMEField name FNAM_____4CHAR132DYNFNAM
LTRFLDDISBasic write direction has been defined LTR (left-to-right) DDLTRFLDDICHAR1DDBOOL
BIDICTRLCDD: No Filtering of BIDI Formatting Characters DDBIDICTRLCHAR1DDBOOL
OUTPUTSTYLEDD: Output Style (Output Style) for Decfloat Types OUTPUTSTYLENUMC2OUTPUTSTYLE
NOHISTORYDD: Flag for Deactivating Input History in Screen Field DDNOHISTORYCHAR1DDBOOL
AMPMFORMATDD: Indicator whether AM/PM time format is required DDAMPMFORMATCHAR1DDAMPMFORMAT

Key field Non-key field



How do I retrieve data from SAP structure SPAR_NTAB using ABAP code?

As SPAR_NTAB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SPAR_NTAB as there is no data to select.

How to access SAP table SPAR_NTAB

Within an ECC or HANA version of SAP you can also view further information about SPAR_NTAB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!