| 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 | VERSION | Version Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | CIFMDVR | MDCI_VERSION | Allow NULL? |
| 3 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 4 | BERID | MRP Area | nvarchar | 10 | 0 | CHAR | (N' ') | No | MDLV | BERID | Allow NULL? |
| 5 | WERKS | MRP area: Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKDP | Allow NULL? |
| 6 | DISPR | Material: MRP profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | MDIP | DISPR | Allow NULL? |
| 7 | DISMM | MRP Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T438A | DISMM | Allow NULL? |
| 8 | DISPO | MRP Controller (Materials Planner) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024D | DISPO | Allow NULL? |
| 9 | DISGR | MRP Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T438M | DISGR | Allow NULL? |
| 10 | MINBE | Reorder Point | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MINBE | |
| 11 | LFRHY | Planning cycle | nvarchar | 3 | 0 | CHAR | (N' ') | No | T439G | LFRHY | Allow NULL? |
| 12 | FXHOR | Planning time fence | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FXHOR | Allow NULL? |
| 13 | DISLS | Lot size (materials planning) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T439A | DISLS | Allow NULL? |
| 14 | RDPRF | Rounding Profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | RDPR | RDPRF | Allow NULL? |
| 15 | BSTRF | Rounding value for purchase order quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTRF | |
| 16 | BSTMI | Minimum Lot Size | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTMI | |
| 17 | BSTMA | Maximum Lot Size | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTMA | |
| 18 | MABST | Maximum stock level | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MABST | |
| 19 | TAKZT | Takt time | decimal | 3 | 0 | DEC | ((0)) | Yes | | TAKZT | |
| 20 | AUSSS | Assembly scrap in percent | decimal | 5 | 2 | DEC | ((0)) | Yes | | AUSSS | |
| 21 | SOBSL | Special procurement type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T460A | SOBSL | Allow NULL? |
| 22 | LGPRO | Issue Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | MDLG | LGPRO | Allow NULL? |
| 23 | LGFSB | Default storage location for external procurement | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | MDLG | LGFSB | Allow NULL? |
| 24 | MRPPP | PPC planning calendar | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T439G | MRPPP | Allow NULL? |
| 25 | EISBE | Safety Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | EISBE | |
| 26 | RWPRO | Range of coverage profile | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T438R | RWPRO | Allow NULL? |
| 27 | SHZET | Safety time (in workdays) | nvarchar | 2 | 0 | NUMC | (N'00') | No | | SHZET | Allow NULL? |
| 28 | BSTFE | Fixed lot size | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTFE | |
| 29 | LOSFX | Ordering costs | decimal | 11 | 2 | CURR | ((0)) | Yes | | LOSFX | |
| 30 | LAGPR | Storage costs indicator | char | 1 | 0 | CHAR | (N' ') | Yes | T439L | LAGPR | Allow NULL? |
| 31 | LGRAD | Service level | decimal | 3 | 1 | DEC | ((0)) | Yes | | LGRAD | |
| 32 | PROPR | Forecast profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PROPR | Allow NULL? |
| 33 | VRBMT | Reference material for consumption | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | VRBMT | Allow NULL? |
| 34 | VRBDB | Reference MRP area - consumption | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VRBDB | Allow NULL? |
| 35 | VRBDT | To date of the material to be copied for consumption | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VRBDT | Allow NULL? |
| 36 | VRBFK | Multiplier for reference material for consumption | decimal | 4 | 2 | DEC | ((0)) | Yes | | VRBFK | |
| 37 | LOEKZ | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | LVORM | Allow NULL? |
| 38 | SHPRO | Period Profile for Safety Time | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | SHPRO | Allow NULL? |
| 39 | AHDIS | MRP relevancy for dependent requirements | char | 1 | 0 | CHAR | (N' ') | Yes | | AHDIS | Allow NULL? |
| 40 | AUTRU | Reset Forecast Model Automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | AUTRU | Allow NULL? |
| 41 | PSTAT | Maintenance status | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | PSTAT_D | Allow NULL? |
| 42 | KZKFK | Indicator: take correction factors into account | char | 1 | 0 | CHAR | (N' ') | Yes | | KZKFK | Allow NULL? |
| 43 | SHFLG | Safety time indicator (with or without safety time) | char | 1 | 0 | CHAR | (N' ') | Yes | | SHFLG | Allow NULL? |
| 44 | APOKZ | Indicator: Is material relevant for APO | char | 1 | 0 | CHAR | (N' ') | Yes | | APOKZ | Allow NULL? |
