SAP table U_16829 (Generated Table for View)

SAP table U_16829 has 3 primary key fields being MANDT,MATNR,SPRAS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MATNR
SPRAS Language Key LANG 1 0 T002 SPRAS
MTART Material type CHAR 4 0 T134 MTART
MBRSH Industry Sector CHAR 1 0 T137 MBRSH
MATKL Material Group CHAR 9 0 T023 MATKL
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
LVORM Flag Material for Deletion at Client Level CHAR 1 0 LVOMA
LAEDA Date of Last Change DATS 8 0 LAEDA
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
ERSDA Created On DATS 8 0 ERSDA
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
VPSTA Maintenance status of complete material CHAR 15 0 VPSTA
PSTAT Maintenance status CHAR 15 0 PSTAT_D
MAKTX Material Description CHAR 40 0 MAKTX
BREIT Width QUAN 13 3 BREIT
HOEHE Height QUAN 13 3 HOEHE
LAENG Length QUAN 13 3 LAENG
MEABM Unit of Dimension for Length/Width/Height UNIT 3 0 T006 MEABM
BRGEW Gross weight QUAN 13 3 BRGEW
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 13 3 VOLUM
VOLEH Volume unit UNIT 3 0 T006 VOLEH
NTGEW Net weight QUAN 13 3 NTGEW
BISMT Old material number CHAR 40 0 BISMT
GROES Size/dimensions CHAR 32 0 GROES
LABOR Laboratory/design office CHAR 3 0 T024L LABOR
SPART Division CHAR 2 0 TSPA SPART
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
NUMTP Category of International Article Number (EAN) CHAR 2 0 TNTP NUMTP
PRDHA Product hierarchy CHAR 18 0 T179 PRODH_D
BEGRU Authorization Group CHAR 4 0 BEGRU
EXTWG External Material Group CHAR 18 0 TWEW EXTWG
MSTAE Cross-Plant Material Status CHAR 2 0 T141 MSTAE
MSTDE Date from which the cross-plant material status is valid DATS 8 0 MSTDE
KOSCH Product allocation determination procedure CHAR 18 0 T190S KOSCH
MAKTG Material Description in Uppercase for Matchcodes CHAR 40 0 MAKTG
BBTYP Assortment List Type CHAR 1 0 TWBB BBTYP
SERVV Service agreement for a retail material CHAR 2 0 TWSV W_SERVV
WMAAB ABC Indicator CHAR 1 0 TMABC MAABC
WEKGR Purchasing Group CHAR 3 0 T024 EKGRP
WVRKM Sales unit UNIT 3 0 T006 VRKME
WAUSM Unit of issue UNIT 3 0 T006 AUSME
WHERL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 T005 HERKL
WHERR Region of Origin of Material (Non-Preferential Origin) CHAR 3 0 T005S HERKR
WLADG Loading Group CHAR 4 0 TLGR LADGR
SSTUF Assortment grade CHAR 2 0 TWSS SSTUF
PFLKS External assortment priority CHAR 1 0 TWSP PFLKS
LSTFL Listing procedure for store or other assortment categories CHAR 2 0 TWLV LSTFL
LSTVZ Listing procedure for distr. center assortment categories CHAR 2 0 TWLV LSTVZ
LSTAK Listing functions (assortments) are active CHAR 1 0 LSTAK
Listing not active
X Listing active
LDVFL Date from which listed in the store DATS 8 0 LDVFL
LDBFL Date to which listed in the store DATS 8 0 LDBFL
LDVZL Date from which listed in the distribution center DATS 8 0 LDVZL
LDBZL Date to which listed in the central warehouse/distr. center DATS 8 0 LDBZL
VDVFL Date from which sold in the store DATS 8 0 VDVFL
VDBFL Date to which sold in the store DATS 8 0 VDBFL
VDVZL Date from which sold in the distribution center DATS 8 0 VDVZL
VDBZL Date to which sold in the distribution center DATS 8 0 VDBZL
WBKLA Valuation Class CHAR 4 0 T025 BKLAS
WSTAW Commodity Code CHAR 17 0 T604 STAWN
WPSTA Retail maintenance status CHAR 15 0 RPSTA
WBWSP Valuation margin DEC 6 2 BWSPA
WEXPM Unit of measure for commodity code (foreign trade) UNIT 3 0 T006 EXPME
KWDHT No repeat key CHAR 1 0 KWDHT
Repeat key may be used
1 No repeat key allowed
2 Repeat key must be used
PRERF Price required CHAR 1 0 PRERF
RBZUL Discount allowed CHAR 1 0 RBZUL
SCAGR Scales group CHAR 4 0 TWWAG SCAGR
BWVOR Procurement rule CHAR 1 0 T6WP1 BWVOR
BWSCL Source of Supply CHAR 1 0 TMBW1 BWSCL
PLGTP Price Band Category CHAR 2 0 TWPT PLGTP
ATTYP Material Category CHAR 2 0 ATTYP
Product
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material

U_16829 foreign key relationships

Table Field Check Table Check Field
0 U_16829 BBTYP TWBB Assortment list type MANDT
1 U_16829 BWSCL TMBW1 Source of Supply Keys MANDT
1 U_16829 BWSCL TMBW1 Source of Supply Keys BWSCL
0 U_16829 BWVOR T6WP1 Check table, supply source entry MANDT
1 U_16829 EXTWG TWEW External Material Groups MANDT
0 U_16829 GEWEI T006 Units of Measurement MANDT
0 U_16829 GEWEI T006 Units of Measurement MSEHI
1 U_16829 KOSCH T190S Product Allocation: Definition Procedure MANDT
1 U_16829 KOSCH T190S Product Allocation: Definition Procedure KOSCH
0 U_16829 LABOR T024L Laboratory/office for material MANDT
1 U_16829 LSTFL TWLV Listing procedure, assortments MANDT
1 U_16829 LSTFL TWLV Listing procedure, assortments LSTFL
0 U_16829 LSTVZ TWLV Listing procedure, assortments MANDT
0 U_16829 LSTVZ TWLV Listing procedure, assortments LSTFL
1 U_16829 MANDT T000 Clients MANDT
0 U_16829 MATKL T023 Material Groups MATKL
1 U_16829 MBRSH T137 Industries for materials MANDT
0 U_16829 MEABM T006 Units of Measurement MANDT
1 U_16829 MEINS T006 Units of Measurement MANDT
1 U_16829 MEINS T006 Units of Measurement MSEHI
0 U_16829 MSTAE T141 Material Status from Materials Management/PPC View MANDT
0 U_16829 MSTAE T141 Material Status from Materials Management/PPC View MMSTA
1 U_16829 MTART T134 Material Types MANDT
1 U_16829 MTART T134 Material Types MTART
0 U_16829 NUMTP TNTP International Article Number (EAN) Categories MANDT
0 U_16829 NUMTP TNTP International Article Number (EAN) Categories NUMTP
1 U_16829 PFLKS TWSP Assortment priorities IS-R MANDT
0 U_16829 PLGTP TWPT Price band categories MANDT
0 U_16829 PLGTP TWPT Price band categories PLGTP
1 U_16829 PRDHA T179 Materials: Product Hierarchies PRODH
0 U_16829 SCAGR TWWAG Scales group MANDT
0 U_16829 SCAGR TWWAG Scales group SCAGR
1 U_16829 SERVV TWSV Service agreement IS-R MANDT
1 U_16829 SERVV TWSV Service agreement IS-R SERVV
0 U_16829 SPART TSPA Organizational Unit: Sales Divisions MANDT
0 U_16829 SPART TSPA Organizational Unit: Sales Divisions SPART
1 U_16829 SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 U_16829 SSTUF TWSS Assortment grade IS-R MANDT
0 U_16829 SSTUF TWSS Assortment grade IS-R SSTUF
1 U_16829 VOLEH T006 Units of Measurement MANDT
1 U_16829 VOLEH T006 Units of Measurement MSEHI
0 U_16829 WAUSM T006 Units of Measurement MANDT
0 U_16829 WAUSM T006 Units of Measurement MSEHI
1 U_16829 WBKLA T025 Valuation Classes MANDT
1 U_16829 WBKLA T025 Valuation Classes BKLAS
0 U_16829 WEKGR T024 Purchasing Groups EKGRP
1 U_16829 WEXPM T006 Units of Measurement MANDT
1 U_16829 WEXPM T006 Units of Measurement MSEHI
0 U_16829 WHERL T005 Countries MANDT
0 U_16829 WHERL T005 Countries LAND1
1 U_16829 WHERR T005S Taxes: Region (Province) Key LAND1
0 U_16829 WLADG TLGR Routes: Loading Groups LADGR
1 U_16829 WMAAB TMABC Values Table for the ABC Indicator for Materials MANDT
0 U_16829 WSTAW T604 Foreign Trade: Commodity Code / Import Code Number LAND1
0 U_16829 WSTAW T604 Foreign Trade: Commodity Code / Import Code Number STAWN
1 U_16829 WVRKM T006 Units of Measurement MANDT
1 U_16829 WVRKM T006 Units of Measurement MSEHI