| 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 | VBELV | Preceding sales and distribution document | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | VBELN_VON | Allow NULL? |
| 3 | POSNV | Preceding item of an SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | VBUP | POSNR_VON | Allow NULL? |
| 4 | VBELN | Subsequent sales and distribution document | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | VBELN_NACH | Allow NULL? |
| 5 | POSNN | Subsequent item of an SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | VBUP | POSNR_NACH | Allow NULL? |
| 6 | VBTYP_N | Document category of subsequent document | char | 1 | 0 | CHAR | (N' ') | No | | VBTYP_N | Allow NULL? |
| 7 | RFMNG | Referenced quantity in base unit of measure | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RFMNG | |
| 8 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 9 | RFWRT | Reference value | decimal | 15 | 2 | CURR | ((0)) | Yes | | RFWRT | |
| 10 | WAERS | Statistics currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS_V | Allow NULL? |
| 11 | VBTYP_V | Document category of preceding SD document | char | 1 | 0 | CHAR | (N' ') | Yes | | VBTYP_V | Allow NULL? |
| 12 | PLMIN | Quantity is calculated positively, negatively or not at all | char | 1 | 0 | CHAR | (N' ') | Yes | | PLMIN | Allow NULL? |
| 13 | TAQUI | ID: MM-WM transfer order confirmed | char | 1 | 0 | CHAR | (N' ') | Yes | | TAQUI | Allow NULL? |
| 14 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 15 | ERZET | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZET | Allow NULL? |
| 16 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 17 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T156 | BWART | Allow NULL? |
| 18 | BDART | Requirement type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BDART | Allow NULL? |
| 19 | PLART | Planning type | char | 1 | 0 | CHAR | (N' ') | Yes | * | PLART | Allow NULL? |
| 20 | STUFE | Level of the document flow record | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | STUFE_VBFA | Allow NULL? |
| 21 | LGNUM | Warehouse Number / Warehouse Complex | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T300 | LGNUM | Allow NULL? |
| 22 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 23 | FKTYP | Billing category | char | 1 | 0 | CHAR | (N' ') | Yes | | FKTYP | Allow NULL? |
| 24 | BRGEW | Gross weight | decimal | 15 | 3 | QUAN | ((0)) | Yes | | BRGEW_15 | |
| 25 | GEWEI | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | GEWEI | Allow NULL? |
| 26 | VOLUM | Volume | decimal | 15 | 3 | QUAN | ((0)) | Yes | | VOLUM_15 | |
| 27 | VOLEH | Volume unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | VOLEH | Allow NULL? |
| 28 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | FPLA | FPLNR | Allow NULL? |
| 29 | FPLTR | Item for billing plan/invoice plan/payment cards | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | FPLTR | Allow NULL? |
| 30 | RFMNG_FLO | Referenced quantity in sales unit (float) | float | 15 | 16 | FLTP | ((0)) | Yes | | RFMNG_FLTV | |
| 31 | RFMNG_FLT | Referenced quantity in base unit of measure (float) | float | 15 | 16 | FLTP | ((0)) | Yes | | RFMNG_FLT | |
| 32 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 33 | ABGES | Guaranteed (factor between 0 and 1) | float | 15 | 16 | FLTP | ((0)) | Yes | | ABGES_CM | |
| 34 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | SOBKZ | Allow NULL? |
| 35 | SONUM | Special Stock Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | LVS_SONUM | Allow NULL? |
| 36 | KZBEF | Indicator Inventory Management active | char | 1 | 0 | CHAR | (N' ') | Yes | | LVS_KZBEF | Allow NULL? |
| 37 | NTGEW | Net Weight | decimal | 13 | 3 | QUAN | ((0)) | Yes | | NTGEW | |
