| 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 | AUFNR | Run schedule header number | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SA_AUFNR | Allow NULL? |
| 3 | AUART | Production type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SA_AUART | Allow NULL? |
| 4 | REFNR | Reference order | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SA_REFNR | Allow NULL? |
| 5 | ERNAM | Created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SA_ERNAM | Allow NULL? |
| 6 | ERDAT | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SA_ERDAT | Allow NULL? |
| 7 | AENAM | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SA_AENAM | Allow NULL? |
| 8 | AEDAT | Change Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SA_AEDAT | Allow NULL? |
| 9 | KTEXT | Description of Run Schedule Header | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SA_KTEXT | Allow NULL? |
| 10 | MATNR | Material number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | SA_MATNR | Allow NULL? |
| 11 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 12 | PHAS0 | Indicator for blocking run schedule header | char | 1 | 0 | CHAR | (N' ') | Yes | | SA_PHAS0 | Allow NULL? |
| 13 | LOEKZ | Deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SA_LOEKZ | Allow NULL? |
| 14 | GAMNG | Total run schedule header quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | SA_GAMNG | |
| 15 | GASMG | Total scrap quantity in the order | decimal | 13 | 3 | QUAN | ((0)) | Yes | | GASMG | |
| 16 | TLMNG | Partial lot quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | TLMNG | |
| 17 | GMEIN | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 18 | DISLS | Lot size (materials planning) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T439A | DISLS | Allow NULL? |
| 19 | BSTMI | Lower value of the lot-size interval | decimal | 13 | 3 | QUAN | ((0)) | Yes | | SA_LOSVN | |
| 20 | BSTMA | Upper value of the lot-size interval | decimal | 13 | 3 | QUAN | ((0)) | Yes | | SA_LOSBS | |
| 21 | BSTFE | Fixed lot size | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTFE | |
| 22 | BSTRF | Rounding value for purchase order quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTRF | |
| 23 | DISPO | MRP controller of the run schedule header | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024D | SA_DISPO | Allow NULL? |
| 24 | VERID | Production Version | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | MKAL | VERID | Allow NULL? |
| 25 | STDAY | Start of the validity period of the RS header | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STDAY | Allow NULL? |
| 26 | ENDAY | End of validity period of the RS header | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDAY | Allow NULL? |
| 27 | VERTO | Distribution key for quantity produced | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T437V | SA_VERTO | Allow NULL? |
| 28 | PLRST | Planning calendar identification | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T439G | SA_MRPPP | Allow NULL? |
| 29 | MDV01 | Production line | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T437P | MDV01 | Allow NULL? |
| 30 | MDV02 | Planning identification 2 | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T437P | MDV02 | Allow NULL? |
| 31 | STLAL | Alternative BOM | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | STALT | Allow NULL? |
| 32 | STLAN | BOM Usage | char | 1 | 0 | CHAR | (N' ') | Yes | T416 | STLAN | Allow NULL? |
| 33 | PLNTY | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | TCA01 | PLNTY | Allow NULL? |
| 34 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 35 | APLAL | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 36 | PERIO | Time bucket | char | 1 | 0 | CHAR | (N' ') | Yes | | SA_PERIO | Allow NULL? |
| 37 | RGEKZ | Indicator: backflush for RS header | char | 1 | 0 | CHAR | (N' ') | Yes | | SA_RGEKZ | Allow NULL? |
| 38 | PKOSA | Cost collector for production process PROCNR | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | PKOSA_D | Allow NULL? |
| 39 | ALORT | Receiving storage location for repetitive manufacturing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | ALORT | Allow NULL? |
| 40 | RSNUM | Number of Reservation/Dependent Requirement | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | RSNUM | Allow NULL? |
| 41 | PLTYG | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | TCA01 | PLNTY | Allow NULL? |
| 42 | PLNNG | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 43 | ALNAG | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 44 | PLTYM | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | TCA01 | PLNTY | Allow NULL? |
| 45 | PLNNM | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 46 | ALNAM | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 47 | QPLOS | Inspection Lot Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | QALS | QPLOS | Allow NULL? |
