| 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/MMWERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | WERKS_D | Allow NULL? |
| 4 | USMD_ACTIVE | Active/Inactive Data Record | char | 1 | 0 | CHAR | (N' ') | No | | USMD_ACTIVE | Allow NULL? |
| 5 | /1MD/MMGEWMARCPA | Weighting group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | GEWGR | Allow NULL? |
| 6 | USMD_O_MARCFRPAR | Obsolete Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | USMD_OBSOLETE | Allow NULL? |
| 7 | /1MD/MMALPHA | Basic value smoothing using alpha factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | ALPHA | |
| 8 | /1MD/MMANZPR | Number of forecast periods | decimal | 3 | 0 | DEC | ((0)) | Yes | | ANZPR | |
| 9 | /1MD/MMBETA1 | Trend value smoothing using the beta factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | BETA1 | |
| 10 | /1MD/MMDELTA | MAD (mean absolute deviation) smoothing using delta factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | DELTA | |
| 11 | /1MD/MMFIMON | Fixed periods | decimal | 3 | 0 | DEC | ((0)) | Yes | | FIMON | |
| 12 | /1MD/MMGAMMA | Seasonal index smoothing using gamma factor | decimal | 3 | 2 | DEC | ((0)) | Yes | | GAMMA | |
| 13 | /1MD/MMKZINI | Initialization indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZINI | Allow NULL? |
| 14 | /1MD/MMKZPAR | Indicator for parameter optimization | char | 1 | 0 | CHAR | (N' ') | Yes | | KZPAR | Allow NULL? |
| 15 | /1MD/MMMODAV | Model selection procedure | char | 1 | 0 | CHAR | (N' ') | Yes | | MODAV | Allow NULL? |
| 16 | /1MD/MMMODAW | Model Selection Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | MODAW | Allow NULL? |
| 17 | /1MD/MMOPGRA | Optimization level | char | 1 | 0 | CHAR | (N' ') | Yes | | OPGRA | Allow NULL? |
| 18 | /1MD/MMPERAN | Number of historical periods | decimal | 3 | 0 | DEC | ((0)) | Yes | | PERAN | |
| 19 | /1MD/MMPERIN | Number of periods for initialization | decimal | 3 | 0 | DEC | ((0)) | Yes | | PERIN | |
| 20 | /1MD/MMPERIO | Number of periods per seasonal cycle | decimal | 3 | 0 | DEC | ((0)) | Yes | | PERIO | |
| 21 | /1MD/MMPRDAT | Date of last forecast | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRDAT | Allow NULL? |
| 22 | /1MD/MMPRMOD | Forecast model | char | 1 | 0 | CHAR | (N' ') | Yes | | PRMOD | Allow NULL? |
| 23 | /1MD/MMSIGGR | Tracking limit | decimal | 5 | 3 | DEC | ((0)) | Yes | | SIGGR | |
