| 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 | USMDKMMMATERIAL | Technical Key | int | 10 | 0 | INT4 | ((0)) | No | /1MD/MD______06H | USMD_TECH_KEY | Allow NULL? |
| 3 | /1MD/MMVKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | VKORG | Allow NULL? |
| 4 | /1MD/MMVTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | VTWEG | Allow NULL? |
| 5 | USMD_ACTIVE | Active/Inactive Data Record | char | 1 | 0 | CHAR | (N' ') | No | | USMD_ACTIVE | Allow NULL? |
| 6 | /1MD/MMWRKSALES | Delivering Plant (Own or External) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DWERK_EXT | Allow NULL? |
| 7 | /1MD/MMMEGSALES | Unit of Measure Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | MEGRU | Allow NULL? |
| 8 | /1MD/MMRDPSALES | Rounding Profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RDPRF | Allow NULL? |
| 9 | USMD_O_MVKESALES | Obsolete Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | USMD_OBSOLETE | Allow NULL? |
| 10 | /1MD/MMAUMNG | Minimum order quantity in base unit of measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MINAU | |
| 11 | /1MD/MMEFMNG | Minimum make-to-order quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MINEF | |
| 12 | /1MD/MMLFMNG | Minimum delivery quantity in delivery note processing | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MINLF | |
| 13 | /1MD/MMMVKELVORM | Ind.: Flag material for deletion at distribution chain level | char | 1 | 0 | CHAR | (N' ') | Yes | | LVOVK | Allow NULL? |
| 14 | /1MD/MMPRAT1 | ID for product attribute 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT1 | Allow NULL? |
| 15 | /1MD/MMPRAT2 | ID for product attribute 2 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT2 | Allow NULL? |
| 16 | /1MD/MMPRAT3 | ID for product attribute 3 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT3 | Allow NULL? |
| 17 | /1MD/MMPRAT4 | ID for product attribute 4 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT4 | Allow NULL? |
| 18 | /1MD/MMPRAT5 | ID for product attribute 5 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT5 | Allow NULL? |
| 19 | /1MD/MMPRAT6 | ID for product attribute 6 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT6 | Allow NULL? |
| 20 | /1MD/MMPRAT7 | ID for product attribute 7 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT7 | Allow NULL? |
| 21 | /1MD/MMPRAT8 | ID for product attribute 8 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT8 | Allow NULL? |
| 22 | /1MD/MMPRAT9 | ID for product attribute 9 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRAT9 | Allow NULL? |
| 23 | /1MD/MMPRATA | ID for product attribute 10 | char | 1 | 0 | CHAR | (N' ') | Yes | | PRATA | Allow NULL? |
| 24 | /1MD/MMSCHME | Unit of measure of delivery unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | SCHME | Allow NULL? |
| 25 | /1MD/MMSCMNG | Minimum Quantity for Splitting Quota | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SCMNG | |
| 26 | /1MD/MMSKTOF | Cash discount indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SKTOF | Allow NULL? |
| 27 | /1MD/MMVAVME | Variable Sales Unit Not Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | VAVME | Allow NULL? |
| 28 | /1MD/MMVMSTA | Distribution-chain-specific material status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VMSTA | Allow NULL? |
| 29 | /1MD/MMVMSTD | Date from which distr.-chain-spec. material status is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VMSTD | Allow NULL? |
| 30 | /1MD/MMVRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | VRKME | Allow NULL? |
