| 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 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 3 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 4 | VERID | Production Version | nvarchar | 4 | 0 | CHAR | (N' ') | No | | VERID | Allow NULL? |
| 5 | BDATU | Run-time end: production version | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BDATM | Allow NULL? |
| 6 | ADATU | Valid-from date of production version | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ADATM | Allow NULL? |
| 7 | STLAL | Alternative BOM | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | STALT | Allow NULL? |
| 8 | STLAN | BOM Usage | char | 1 | 0 | CHAR | (N' ') | Yes | T416 | STLAN | Allow NULL? |
| 9 | PLNTY | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | TCA01 | PLNTY | Allow NULL? |
| 10 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 11 | ALNAL | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 12 | BESKZ | Procurement Type | char | 1 | 0 | CHAR | (N' ') | Yes | | BESKZ | Allow NULL? |
| 13 | SOBSL | Special procurement type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T460A | SOBSL | Allow NULL? |
| 14 | LOSGR | Lot Size for Product Costing | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CK_LOSGR | |
| 15 | MDV01 | Production line for repetitive manufacturing | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SA_LINE1 | Allow NULL? |
| 16 | MDV02 | Planning identification | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T437P | MDV | Allow NULL? |
| 17 | TEXT1 | Short text on the production version | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | VERS_TEXT | Allow NULL? |
| 18 | EWAHR | Usage Probability with Version Control | decimal | 3 | 0 | DEC | ((0)) | Yes | | CK_EWAHR | |
| 19 | VERTO | Distribution key for quantity produced | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T437V | SA_VERTO | Allow NULL? |
| 20 | SERKZ | Repetitive manufacturing allowed for version | char | 1 | 0 | CHAR | (N' ') | Yes | | SA_VERSI | Allow NULL? |
| 21 | BSTMI | Lower value of the lot-size interval | decimal | 13 | 3 | QUAN | ((0)) | Yes | | SA_LOSVN | |
| 22 | BSTMA | Upper value of the lot-size interval | decimal | 13 | 3 | QUAN | ((0)) | Yes | | SA_LOSBS | |
| 23 | RGEKZ | Indicator: backflush for RS header | char | 1 | 0 | CHAR | (N' ') | Yes | | SA_RGEKZ | Allow NULL? |
| 24 | ALORT | Receiving storage location for repetitive manufacturing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | ALORT | Allow NULL? |
| 25 | PLTYG | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | TCA01 | PLNTY | Allow NULL? |
| 26 | PLNNG | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 27 | ALNAG | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 28 | PLTYM | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | TCA01 | PLNTY | Allow NULL? |
| 29 | PLNNM | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 30 | ALNAM | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 31 | CSPLT | Apportionment Structure | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | MAKV | CSPLIT | Allow NULL? |
| 32 | MATKO | Other material for which BOM and task list are maintained | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MKAL_MATKO | Allow NULL? |
| 33 | ELPRO | Proposed issue storage location for components | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | SA_ELPRO | Allow NULL? |
| 34 | PRVBE | Default supply area for components | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SA_PRVBE | Allow NULL? |
| 35 | PRFG_F | Check status of production version | char | 1 | 0 | CHAR | (N' ') | Yes | | PRFG_F | Allow NULL? |
| 36 | PRDAT | Date of last check of production version | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MKPRDAT | Allow NULL? |
| 37 | MKSP | Production version is locked | char | 1 | 0 | CHAR | (N' ') | Yes | | MKSP | Allow NULL? |
| 38 | PRFG_R | Rate-based planning - Check status of production version | char | 1 | 0 | CHAR | (N' ') | Yes | | PRFG_R | Allow NULL? |
| 39 | PRFG_G | Preliminary planning - Check status of production version | char | 1 | 0 | CHAR | (N' ') | Yes | | PRFG_G | Allow NULL? |
| 40 | PRFG_S | BOM - check status of production version | char | 1 | 0 | CHAR | (N' ') | Yes | | PRFG_S | Allow NULL? |
| 41 | UCMAT | Reference Material for Original Batches | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | VBOB_OB_RFMAT | Allow NULL? |
| 42 | PPEGUID | Internal Identification for PVS Objects | varbinary | 16 | 0 | RAW | | Yes | | PVS_GUID | |
