U_11024 SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




Table View field list including key, data, relationships and ABAP select examples

U_11024 is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The U_11024 table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include MATNR (Material Number), SPRAS (Language Key), MTART (Material Type), MBRSH (Industry sector).. 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 U_11024 table view 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
MANDTClient MANDTCLNT3T000MANDT
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
MBRSHIndustry sector MBRSHCHAR1T137MBRSHMTP
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
LVORMFlag Material for Deletion at Client Level LVOMACHAR1XFELD
LAEDADate of Last Change LAEDADATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
ERSDACreated On ERSDADATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
VPSTAMaintenance status of complete material VPSTACHAR15PSTAT
PSTATMaintenance status PSTAT_DCHAR15PSTAT
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
BREITWidth BREITQUAN13(3) MENG13
HOEHEHeight HOEHEQUAN13(3) MENG13
LAENGLength LAENGQUAN13(3) MENG13
MEABMUnit of Dimension for Length/Width/Height MEABMUNIT3T006CUNITMEINS
BRGEWGross Weight BRGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
VOLUMVolume VOLUMQUAN13(3) MENG13
VOLEHVolume unit VOLEHUNIT3T006CUNITMEINS
NTGEWNet Weight NTGEWQUAN13(3) MENG13
BISMTOld material number BISMTCHAR18BISMT
GROESSize/dimensions GROESCHAR32CHAR32
LABORLaboratory/design office LABORCHAR3T024LLABOR
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
NUMTPCategory of International Article Number (EAN) NUMTPCHAR2TNTPNUMTP
PRDHAProduct hierarchy PRODH_DCHAR18T179PRODHVPR
BEGRUAuthorization Group BEGRUCHAR4BEGRU
EXTWGExternal Material Group EXTWGCHAR18TWEWEXTWG
MSTAECross-Plant Material Status MSTAECHAR2T141MMSTA
MSTDEDate from which the cross-plant material status is valid MSTDEDATS8DATUM
KOSCHProduct allocation determination procedure KOSCHCHAR18T190SKOSCH
MAKTGMaterial description in upper case for matchcodes MAKTGCHAR40CHAR40
BBTYPAssortment List Type BBTYPCHAR1TWBBBBTYPWBB
SERVVService agreement for a retail material W_SERVVCHAR2TWSVW_SERVV
WMAABABC Indicator MAABCCHAR1TMABCMAABC
WEKGRPurchasing Group EKGRPCHAR3T024EKGRPEKG
WVRKMSales unit VRKMEUNIT3T006CUNITMEINS
WAUSMUnit of issue AUSMEUNIT3T006CUNITMEINS
WHERLCountry of origin of the material HERKLCHAR3T005LAND1LND
WHERRRegion of origin of material (non-preferential origin) HERKRCHAR3T005SREGIO
WLADGLoading Group LADGRCHAR4TLGRLADGR
SSTUFAssortment grade SSTUFCHAR2TWSSSSTUF
PFLKSExternal assortment priority PFLKSCHAR1TWSPPFLKS
LSTFLListing procedure for store or other assortment categories LSTFLCHAR2TWLVLSTFLWLV
LSTVZListing procedure for distr. center assortment categories LSTVZCHAR2TWLVLSTFL
LSTAKListing functions (assortments) are active LSTAKCHAR1LSTAK
LDVFLDate from which listed in the store LDVFLDATS8DATS
LDBFLDate to which listed in the store LDBFLDATS8DATS
LDVZLDate from which listed in the distribution center LDVZLDATS8DATS
LDBZLDate to which listed in the central warehouse/distr. center LDBZLDATS8DATS
VDVFLDate from which sold in the store VDVFLDATS8DATS
VDBFLDate to which sold in the store VDBFLDATS8DATS
VDVZLDate from which sold in the distribution center VDVZLDATS8DATS
VDBZLDate to which sold in the distribution center VDBZLDATS8DATS
WBKLAValuation Class BKLASCHAR4T025BKLAS
WSTAWCommodity Code/Import Code Number for Foreign Trade STAWNCHAR17T604STAWN
WPSTARetail maintenance status RPSTACHAR15PSTAT
WBWSPValuation margin BWSPADEC6(2) PRZ32V
WEXPMUnit of measure for commodity code (foreign trade) EXPMEUNIT3T006CUNITMEINS
KWDHTNo repeat key KWDHTCHAR1KWDHT
PRERFPrice required PRERFCHAR1XFELD
RBZULDiscount allowed RBZULCHAR1XFELD
SCAGRScales group SCAGRCHAR4TWWAGSCAGR
BWVORProcurement rule BWVORCHAR1T6WP1BWVOR
BWSCLSource of Supply BWSCLCHAR1TMBW1BQSCL
PLGTPPrice Band Category PLGTPCHAR2TWPTPLGTP
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY

Key field Non-key field



How do I retrieve data from SAP table U_11024 using ABAP code

The following ABAP code Example will allow you to do a basic selection on U_11024 to SELECT all data from the table
DATA: WA_U_11024 TYPE U_11024.

SELECT SINGLE *
FROM U_11024
INTO CORRESPONDING FIELDS OF WA_U_11024
WHERE...

How to access SAP table U_11024

Within an ECC or HANA version of SAP you can also view further information about U_11024 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!