| 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 | PROFID | Profile for Order Report | nvarchar | 12 | 0 | CHAR | (N' ') | No | | PROFID_ORD_REP | Allow NULL? |
| 3 | AENAM | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PS_AENAM | Allow NULL? |
| 4 | PROTECT | Indicator: Protected entry | char | 1 | 0 | CHAR | (N' ') | Yes | | MP_PROTECT | Allow NULL? |
| 5 | HIER_LEVEL | Number of hierarchy levels | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | HIERAR_LEVEL | Allow NULL? |
| 6 | KZKAU | Indicator: Read elements assigned to production order | char | 1 | 0 | CHAR | (N' ') | Yes | | KZKAU | Allow NULL? |
| 7 | ADOBJ | Indicator: Elements outside product structure | char | 1 | 0 | CHAR | (N' ') | Yes | | ADOBJ_DT | Allow NULL? |
| 8 | EXCMRPLOGIC | Indicator: MRP Exceptions | char | 1 | 0 | CHAR | (N' ') | Yes | | EXCMRPLOGIC | Allow NULL? |
| 9 | AVAILDATELOGIC | Availability check according to receipt date | char | 1 | 0 | CHAR | (N' ') | Yes | | DATELOGIC | Allow NULL? |
| 10 | AVAILATPLOGIC | Availability check according to ATP logic | char | 1 | 0 | CHAR | (N' ') | Yes | | ATPLOGIC | Allow NULL? |
| 11 | AVAILSSTOCK | Indicator for Availability Check: With/Without Safety Stock | char | 1 | 0 | CHAR | (N' ') | Yes | | SSTOCK | Allow NULL? |
| 12 | EXCQUANTITY | Indicator: Quantity Exceptions | char | 1 | 0 | CHAR | (N' ') | Yes | | EXCQUANTITY | Allow NULL? |
| 13 | PR_MENDIF | Exception when above percent. operation quantity difference | decimal | 5 | 2 | DEC | ((0)) | Yes | | PR_MENDIF | |
| 14 | EXCDATE | Indicator: Exception Messages for Schedule Deviations | char | 1 | 0 | CHAR | (N' ') | Yes | | EXCDATE | Allow NULL? |
| 15 | TATVZ | Exception when above extent of actual delay | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TATVZ | Allow NULL? |
| 16 | MEIVT | Time unit for the actual delay | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEIVT | Allow NULL? |
| 17 | ERWVZ | Exception depending on size of expected delay in order | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ERWVZ | Allow NULL? |
| 18 | MEIVE | Time unit for the expected delay | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEIVE | Allow NULL? |
| 19 | ADDMATERIAL | Display Additional Material Data in Order Report | char | 1 | 0 | CHAR | (N' ') | Yes | | ADDMATERIAL | Allow NULL? |
| 20 | REORDER | Display Consumption-Based Materials in the Order Report | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_REORDER | Allow NULL? |
| 21 | BULKMAT | Display Bulk Material in Order Report | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_BULK | Allow NULL? |
| 22 | COBYPRODUCT | Display Co- and By-Products in Order Report | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_COBYPRODUCT | Allow NULL? |
| 23 | ADDELEMENT | Display Additional Receipt Data in the Order Report | char | 1 | 0 | CHAR | (N' ') | Yes | | ADDELEMENT | Allow NULL? |
| 24 | PIPELINE | Display Pipeline Material in Order Report | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_PIPELINE | Allow NULL? |
| 25 | USEBUFFER | Read Order Report from Buffer | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_MEM_ORDREP | Allow NULL? |
| 26 | MLDELAY | Indicator: Calculation and Display of Multilevel Delay | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_ML_DELAY | Allow NULL? |
| 27 | MLAPPROACH | Optimistic/Pessimistic Calculation of Multilevel Delay | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_ML_APPROACH | Allow NULL? |
| 28 | MLOPER | Calculation of Multilevel Delay at Operation Level | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_ML_OPER | Allow NULL? |
| 29 | SLDELAY | Activate Calculation of Actual and Expected Delay | char | 1 | 0 | CHAR | (N' ') | Yes | | MD_SL_DELAY | Allow NULL? |
| 30 | MLGREEN | Threshold Value for Green Icon (Delay Non-Critical) | decimal | 2 | 0 | DEC | ((0)) | Yes | | MD_ML_GREEN | |
| 31 | MLYELLOW | Threshold Value Yellow Icon (Delay Critical) | decimal | 2 | 0 | DEC | ((0)) | Yes | | MD_ML_YELLOW | |
| 32 | MLRED | Threshold Value Red Icon (Delay Highly Critical) | decimal | 2 | 0 | DEC | ((0)) | Yes | | MD_ML_RED | |
