SAP Table U_16829
Generated Table for View
U_16829 (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link U_16829 to other SAP tables.
Source: U_16829 (Generated Table for View)
U_16829 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||
| MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||||||||||||||||||||
| SPRAS | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||||||||||||||||||
| MTART | Material Type | MTART | T134 | CHAR | 4 | 0 | ||||||||||||||||||||||||
| MBRSH | Industry sector | MBRSH | T137 | CHAR | 1 | 0 | ||||||||||||||||||||||||
| MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||||||||||||||||||||||||
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||
| LVORM | Flag Material for Deletion at Client Level | LVOMA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| LAEDA | Date of Last Change | LAEDA | DATS | 8 | 0 | |||||||||||||||||||||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||||||||||||||||||
| ERSDA | Created On | ERSDA | DATS | 8 | 0 | |||||||||||||||||||||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||||||||||||||
| VPSTA | Maintenance status of complete material | VPSTA | CHAR | 15 | 0 | |||||||||||||||||||||||||
| PSTAT | Maintenance status | PSTAT_D | CHAR | 15 | 0 | |||||||||||||||||||||||||
| MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | 0 | |||||||||||||||||||||||||
| BREIT | Width | BREIT | QUAN | 13 | 3 | |||||||||||||||||||||||||
| HOEHE | Height | HOEHE | QUAN | 13 | 3 | |||||||||||||||||||||||||
| LAENG | Length | LAENG | QUAN | 13 | 3 | |||||||||||||||||||||||||
| MEABM | Unit of Dimension for Length/Width/Height | MEABM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||
| BRGEW | Gross Weight | BRGEW | QUAN | 13 | 3 | |||||||||||||||||||||||||
| GEWEI | Weight Unit | GEWEI | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||
| VOLUM | Volume | VOLUM | QUAN | 13 | 3 | |||||||||||||||||||||||||
| VOLEH | Volume unit | VOLEH | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||
| NTGEW | Net Weight | NTGEW | QUAN | 13 | 3 | |||||||||||||||||||||||||
| BISMT | Old material number | BISMT | CHAR | 18 | 0 | |||||||||||||||||||||||||
| GROES | Size/dimensions | GROES | CHAR | 32 | 0 | |||||||||||||||||||||||||
| LABOR | Laboratory/design office | LABOR | T024L | CHAR | 3 | 0 | ||||||||||||||||||||||||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||||||||||||||||||||
| EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | 0 | |||||||||||||||||||||||||
| NUMTP | Category of International Article Number (EAN) | NUMTP | TNTP | CHAR | 2 | 0 | ||||||||||||||||||||||||
| PRDHA | Product hierarchy | PRODH_D | T179 | CHAR | 18 | 0 | ||||||||||||||||||||||||
| BEGRU | Authorization Group | BEGRU | CHAR | 4 | 0 | |||||||||||||||||||||||||
| EXTWG | External Material Group | EXTWG | TWEW | CHAR | 18 | 0 | ||||||||||||||||||||||||
| MSTAE | Cross-Plant Material Status | MSTAE | T141 | CHAR | 2 | 0 | ||||||||||||||||||||||||
| MSTDE | Date from which the cross-plant material status is valid | MSTDE | DATS | 8 | 0 | |||||||||||||||||||||||||
| KOSCH | Product allocation determination procedure | KOSCH | T190S | CHAR | 18 | 0 | ||||||||||||||||||||||||
| MAKTG | Material description in upper case for matchcodes | MAKTG | CHAR | 40 | 0 | |||||||||||||||||||||||||
| BBTYP | Assortment List Type | BBTYP | TWBB | CHAR | 1 | 0 | ||||||||||||||||||||||||
| SERVV | Service agreement for a retail material | W_SERVV | TWSV | CHAR | 2 | 0 | ||||||||||||||||||||||||
| WMAAB | ABC Indicator | MAABC | TMABC | CHAR | 1 | 0 | ||||||||||||||||||||||||
| WEKGR | Purchasing Group | EKGRP | T024 | CHAR | 3 | 0 | ||||||||||||||||||||||||
| WVRKM | Sales unit | VRKME | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||
| WAUSM | Unit of issue | AUSME | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||
| WHERL | Country of origin of the material | HERKL | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||||
| WHERR | Region of origin of material (non-preferential origin) | HERKR | T005S | CHAR | 3 | 0 | ||||||||||||||||||||||||
| WLADG | Loading Group | LADGR | TLGR | CHAR | 4 | 0 | ||||||||||||||||||||||||
| SSTUF | Assortment grade | SSTUF | TWSS | CHAR | 2 | 0 | ||||||||||||||||||||||||
| PFLKS | External assortment priority | PFLKS | TWSP | CHAR | 1 | 0 | ||||||||||||||||||||||||
| LSTFL | Listing procedure for store or other assortment categories | LSTFL | TWLV | CHAR | 2 | 0 | ||||||||||||||||||||||||
| LSTVZ | Listing procedure for distr. center assortment categories | LSTVZ | TWLV | CHAR | 2 | 0 | ||||||||||||||||||||||||
| LSTAK | Listing functions (assortments) are active | LSTAK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| LDVFL | Date from which listed in the store | LDVFL | DATS | 8 | 0 | |||||||||||||||||||||||||
| LDBFL | Date to which listed in the store | LDBFL | DATS | 8 | 0 | |||||||||||||||||||||||||
| LDVZL | Date from which listed in the distribution center | LDVZL | DATS | 8 | 0 | |||||||||||||||||||||||||
| LDBZL | Date to which listed in the central warehouse/distr. center | LDBZL | DATS | 8 | 0 | |||||||||||||||||||||||||
| VDVFL | Date from which sold in the store | VDVFL | DATS | 8 | 0 | |||||||||||||||||||||||||
| VDBFL | Date to which sold in the store | VDBFL | DATS | 8 | 0 | |||||||||||||||||||||||||
| VDVZL | Date from which sold in the distribution center | VDVZL | DATS | 8 | 0 | |||||||||||||||||||||||||
| VDBZL | Date to which sold in the distribution center | VDBZL | DATS | 8 | 0 | |||||||||||||||||||||||||
| WBKLA | Valuation Class | BKLAS | T025 | CHAR | 4 | 0 | ||||||||||||||||||||||||
| WSTAW | Commodity Code/Import Code Number for Foreign Trade | STAWN | T604 | CHAR | 17 | 0 | ||||||||||||||||||||||||
| WPSTA | Retail maintenance status | RPSTA | CHAR | 15 | 0 | |||||||||||||||||||||||||
| WBWSP | Valuation margin | BWSPA | DEC | 6 | 2 | |||||||||||||||||||||||||
| WEXPM | Unit of measure for commodity code (foreign trade) | EXPME | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||
| KWDHT | No repeat key | KWDHT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| PRERF | Price required | PRERF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| RBZUL | Discount allowed | RBZUL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| SCAGR | Scales group | SCAGR | TWWAG | CHAR | 4 | 0 | ||||||||||||||||||||||||
| BWVOR | Procurement rule | BWVOR | T6WP1 | CHAR | 1 | 0 | ||||||||||||||||||||||||
| BWSCL | Source of Supply | BWSCL | TMBW1 | CHAR | 1 | 0 | ||||||||||||||||||||||||
| PLGTP | Price Band Category | PLGTP | TWPT | CHAR | 2 | 0 | ||||||||||||||||||||||||
| ATTYP | Material Category | ATTYP | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||
U_16829 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| U_16829 | BBTYP | SY | MANDT | TWBB | Assortment list type | MANDT |
| U_16829 | BBTYP | U_16829 | BBTYP | TWBB | Assortment list type | BBTYP |
| U_16829 | BWSCL | U_16829 | BWSCL | TMBW1 | Source of Supply Keys | BWSCL |
| U_16829 | BWSCL | SY | MANDT | TMBW1 | Source of Supply Keys | MANDT |
| U_16829 | BWVOR | U_16829 | BWVOR | T6WP1 | Check table, supply source entry | BWVOR |
| U_16829 | BWVOR | SYST | MANDT | T6WP1 | Check table, supply source entry | MANDT |
| U_16829 | EXTWG | U_16829 | EXTWG | TWEW | External Material Groups | EXTWG |
| U_16829 | EXTWG | U_16829 | MANDT | TWEW | External Material Groups | MANDT |
| U_16829 | GEWEI | U_16829 | MANDT | T006 | Units of Measurement | MANDT |
| U_16829 | GEWEI | U_16829 | GEWEI | T006 | Units of Measurement | MSEHI |
| U_16829 | KOSCH | SYST | MANDT | T190S | Product Allocation: Definition Procedure | MANDT |
| U_16829 | KOSCH | U_16829 | KOSCH | T190S | Product Allocation: Definition Procedure | KOSCH |
| U_16829 | LABOR | U_16829 | LABOR | T024L | Laboratory/office for material | LABOR |
| U_16829 | LABOR | U_16829 | MANDT | T024L | Laboratory/office for material | MANDT |
| U_16829 | LSTFL | SY | MANDT | TWLV | Listing procedure, assortments | MANDT |
| U_16829 | LSTFL | U_16829 | LSTFL | TWLV | Listing procedure, assortments | LSTFL |
| U_16829 | LSTVZ | SY | MANDT | TWLV | Listing procedure, assortments | MANDT |
| U_16829 | LSTVZ | U_16829 | LSTVZ | TWLV | Listing procedure, assortments | LSTFL |
| U_16829 | MANDT | U_16829 | MANDT | T000 | Clients | MANDT |
| U_16829 | MATKL | U_16829 | MANDT | T023 | Material Groups | MANDT |
| U_16829 | MATKL | U_16829 | MATKL | T023 | Material Groups | MATKL |
| U_16829 | MBRSH | U_16829 | MBRSH | T137 | Industries for materials | MBRSH |
| U_16829 | MBRSH | U_16829 | MANDT | T137 | Industries for materials | MANDT |
| U_16829 | MEABM | U_16829 | MANDT | T006 | Units of Measurement | MANDT |
| U_16829 | MEABM | U_16829 | MEABM | T006 | Units of Measurement | MSEHI |
| U_16829 | MEINS | U_16829 | MANDT | T006 | Units of Measurement | MANDT |
| U_16829 | MEINS | U_16829 | MEINS | T006 | Units of Measurement | MSEHI |
| U_16829 | MSTAE | SY | MANDT | T141 | Material Status from Materials Management/PPC View | MANDT |
| U_16829 | MSTAE | U_16829 | MSTAE | T141 | Material Status from Materials Management/PPC View | MMSTA |
| U_16829 | MTART | U_16829 | MTART | T134 | Material Types | MTART |
| U_16829 | MTART | U_16829 | MANDT | T134 | Material Types | MANDT |
| U_16829 | NUMTP | U_16829 | MANDT | TNTP | International Article Number (EAN) Categories | MANDT |
| U_16829 | NUMTP | U_16829 | NUMTP | TNTP | International Article Number (EAN) Categories | NUMTP |
| U_16829 | PFLKS | U_16829 | PFLKS | TWSP | Assortment priorities IS-R | PFLKS |
| U_16829 | PFLKS | SY | MANDT | TWSP | Assortment priorities IS-R | MANDT |
| U_16829 | PLGTP | U_16829 | PLGTP | TWPT | Price band categories | PLGTP |
| U_16829 | PLGTP | SY | MANDT | TWPT | Price band categories | MANDT |
| U_16829 | PRDHA | U_16829 | MANDT | T179 | Materials: Product Hierarchies | MANDT |
| U_16829 | PRDHA | U_16829 | PRDHA | T179 | Materials: Product Hierarchies | PRODH |
| U_16829 | SCAGR | U_16829 | SCAGR | TWWAG | Scales group | SCAGR |
| U_16829 | SCAGR | U_16829 | MANDT | TWWAG | Scales group | MANDT |
| U_16829 | SERVV | SY | MANDT | TWSV | Service agreement IS-R | MANDT |
| U_16829 | SERVV | U_16829 | SERVV | TWSV | Service agreement IS-R | SERVV |
| U_16829 | SPART | U_16829 | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| U_16829 | SPART | U_16829 | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| U_16829 | SPRAS | U_16829 | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
| U_16829 | SSTUF | SY | MANDT | TWSS | Assortment grade IS-R | MANDT |
| U_16829 | SSTUF | U_16829 | SSTUF | TWSS | Assortment grade IS-R | SSTUF |
| U_16829 | VOLEH | U_16829 | VOLEH | T006 | Units of Measurement | MSEHI |
| U_16829 | VOLEH | U_16829 | MANDT | T006 | Units of Measurement | MANDT |
| U_16829 | WAUSM | U_16829 | WAUSM | T006 | Units of Measurement | MSEHI |
| U_16829 | WAUSM | SY | MANDT | T006 | Units of Measurement | MANDT |
| U_16829 | WBKLA | SY | MANDT | T025 | Valuation Classes | MANDT |
| U_16829 | WBKLA | U_16829 | WBKLA | T025 | Valuation Classes | BKLAS |
| U_16829 | WEKGR | U_16829 | WEKGR | T024 | Purchasing Groups | EKGRP |
| U_16829 | WEKGR | SY | MANDT | T024 | Purchasing Groups | MANDT |
| U_16829 | WEXPM | SY | MANDT | T006 | Units of Measurement | MANDT |
| U_16829 | WEXPM | U_16829 | WEXPM | T006 | Units of Measurement | MSEHI |
| U_16829 | WHERL | U_16829 | WHERL | T005 | Countries | LAND1 |
| U_16829 | WHERL | SY | MANDT | T005 | Countries | MANDT |
| U_16829 | WHERR | U_16829 | WHERR | T005S | Taxes: Region (Province) Key | BLAND |
| U_16829 | WHERR | SY | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| U_16829 | WHERR | U_16829 | WHERL | T005S | Taxes: Region (Province) Key | LAND1 |
| U_16829 | WLADG | SY | MANDT | TLGR | Routes: Loading Groups | MANDT |
| U_16829 | WLADG | U_16829 | WLADG | TLGR | Routes: Loading Groups | LADGR |
| U_16829 | WMAAB | SYST | MANDT | TMABC | Values Table for the ABC Indicator for Materials | MANDT |
| U_16829 | WMAAB | U_16829 | WMAAB | TMABC | Values Table for the ABC Indicator for Materials | MAABC |
| U_16829 | WSTAW | T130S | LAND1 | T604 | Foreign Trade: Commodity Code / Import Code Number | LAND1 |
| U_16829 | WSTAW | U_16829 | WSTAW | T604 | Foreign Trade: Commodity Code / Import Code Number | STAWN |
| U_16829 | WSTAW | SY | MANDT | T604 | Foreign Trade: Commodity Code / Import Code Number | MANDT |
| U_16829 | WVRKM | U_16829 | WVRKM | T006 | Units of Measurement | MSEHI |
| U_16829 | WVRKM | SY | MANDT | T006 | Units of Measurement | MANDT |
