| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 3 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 4 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTW | VTWEG | Allow NULL? |
| 5 | LVORM | Ind.: Flag material for deletion at distribution chain level | char | 1 | 0 | CHAR | (N' ') | Yes | | LVOVK | Allow NULL? |
| 6 | VERSG | Material statistics group | char | 1 | 0 | CHAR | (N' ') | Yes | TVSM | STGMA | Allow NULL? |
| 7 | BONUS | Volume rebate group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVBO | BONUS | Allow NULL? |
| 8 | PROVG | Commission group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVPR | PROVG | Allow NULL? |
| 9 | SKTOF | Cash discount indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SKTOF | Allow NULL? |
| 10 | VMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVMS | VMSTA | Allow NULL? |
| 11 | VMSTD | Date from which distr.-chain-spec. material status is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VMSTD | Allow NULL? |
| 12 | AUMNG | Minimum order quantity in base unit of measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MINAU | |
| 13 | LFMNG | Minimum delivery quantity in delivery note processing | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MINLF | |
| 14 | EFMNG | Minimum make-to-order quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MINEF | |
| 15 | SCMNG | Delivery unit | decimal | 13 | 3 | QUAN | ((0)) | Yes | | SCHRT | |
| 16 | SCHME | Unit of measure of delivery unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | SCHME | Allow NULL? |
| 17 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 18 | MTPOS | Item category group from material master | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TPTM | MTPOS | Allow NULL? |
| 19 | DWERK | Delivering Plant (Own or External) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKWZ | DWERK_EXT | Allow NULL? |
| 20 | PRODH | Product hierarchy | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | T179 | PRODH_D | Allow NULL? |
| 21 | PMATN | Pricing Reference Material | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | PMATN | Allow NULL? |
| 22 | KONDM | Material Pricing Group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T178 | KONDM | Allow NULL? |
| 23 | KTGRM | Account assignment group for this material | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVKM | KTGRM | Allow NULL? |
| 24 | MVGR1 | Material group 1 | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TVM1 | MVGR1 | Allow NULL? |
| 25 | MVGR2 | Material group 2 | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TVM2 | MVGR2 | Allow NULL? |
| 26 | MVGR3 | Material group 3 | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TVM3 | MVGR3 | Allow NULL? |
| 27 | MVGR4 | Material group 4 | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TVM4 | MVGR4 | Allow NULL? |
| 28 | MVGR5 | Material group 5 | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TVM5 | MVGR5 | Allow NULL? |
| 29 | SSTUF | Assortment grade | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWSS | SSTUF | Allow NULL? |
| 30 | PFLKS | External assortment priority | char | 1 | 0 | CHAR | (N' ') | Yes | TWSP | PFLKS | Allow NULL? |
| 31 | LSTFL | Listing procedure for store or other assortment categories | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWLV | LSTFL | Allow NULL? |
| 32 | LSTVZ | Listing procedure for distr. center assortment categories | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWLV | LSTVZ | Allow NULL? |
| 33 | LSTAK | Listing functions (assortments) are active | char | 1 | 0 | CHAR | (N' ') | Yes | | LSTAK | Allow NULL? |
| 34 | LDVFL | Date from which listed in the store | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LDVFL | Allow NULL? |
| 35 | LDBFL | Date to which listed in the store | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LDBFL | Allow NULL? |
| 36 | LDVZL | Date from which listed in the distribution center | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LDVZL | Allow NULL? |
| 37 | LDBZL | Date to which listed in the central warehouse/distr. center | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LDBZL | Allow NULL? |
| 38 | VDVFL | Date from which sold in the store | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VDVFL | Allow NULL? |
| 39 | VDBFL | Date to which sold in the store | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VDBFL | Allow NULL? |
| 40 | VDVZL | Date from which sold in the distribution center | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VDVZL | Allow NULL? |
| 41 | VDBZL | Date to which sold in the distribution center | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VDBZL | Allow NULL? |
| 42 | PRAT1 | ID for product attribute 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT1 | Allow NULL? |
| 43 | PRAT2 | ID for product attribute 2 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT2 | Allow NULL? |
| 44 | PRAT3 | ID for product attribute 3 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT3 | Allow NULL? |
| 45 | PRAT4 | ID for product attribute 4 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT4 | Allow NULL? |
| 46 | PRAT5 | ID for product attribute 5 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT5 | Allow NULL? |
| 47 | PRAT6 | ID for product attribute 6 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT6 | Allow NULL? |
| 48 | PRAT7 | ID for product attribute 7 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT7 | Allow NULL? |
| 49 | PRAT8 | ID for product attribute 8 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT8 | Allow NULL? |
| 50 | PRAT9 | ID for product attribute 9 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT9 | Allow NULL? |
| 51 | PRATA | ID for product attribute 10 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRATA | Allow NULL? |
| 52 | RDPRF | Rounding Profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | RDPR | RDPRF | Allow NULL? |
| 53 | MEGRU | Unit of Measure Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TWMEG | MEGRU | Allow NULL? |
| 54 | LFMAX | Maximum delivery quantity in store order processing | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MAXLF | |
| 55 | RJART | Flag rackjobber material | char | 1 | 0 | CHAR | (N' ') | Yes | | RJART | Allow NULL? |
| 56 | PBIND | Indicator for price fixing | char | 1 | 0 | CHAR | (N' ') | Yes | | PBIND | Allow NULL? |
| 57 | VAVME | Variable Sales Unit Not Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | VAVME | Allow NULL? |
| 58 | MATKC | Competition characterization of a material | char | 1 | 0 | CHAR | (N' ') | Yes | | MATKC | Allow NULL? |
| 59 | PVMSO | Material sorting in product proposal | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PVMSO | Allow NULL? |
| 60 | /BEV1/EMLGRP | Empties Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /BEV1/EMGRP | /BEV1/EMLGGRP | Allow NULL? |
| 61 | /BEV1/EMDRCKSPL | Print Column Empties Returns Block | char | 1 | 0 | NUMC | (N'0') | Yes | | /BEV1/EMPRTCOL | Allow NULL? |
| 62 | /BEV1/RPBEZME | Base Unit of Measure for Statistics Totals List/Planning | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /BEV1/RPBEZME | Allow NULL? |
| 63 | /BEV1/RPSNS | No Allocation to Totals Field (Do not Total) | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RPSNS | Allow NULL? |
| 64 | /BEV1/RPSFA | Assignment to Totals Field Category 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RPSFA | Allow NULL? |
| 65 | /BEV1/RPSKI | Assignment to Totals Field Category 2 | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RPSKI | Allow NULL? |
| 66 | /BEV1/RPSCO | Assignment to Totals Field Category 3 | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RPSCO | Allow NULL? |
| 67 | /BEV1/RPSSO | Assignment to Totals Field Category 4 | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/RPSSO | Allow NULL? |
| 68 | PLGTP | Price Band Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWPT | WRF_PLGTP | Allow NULL? |
