| 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 | CHARG | Batch Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CHARG_D | Allow NULL? |
| 4 | LVORM | Deletion Flag for All Data in a Batch | char | 1 | 0 | CHAR | (N' ') | Yes | | LVOC1 | Allow NULL? |
| 5 | ERSDA | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERSDA | Allow NULL? |
| 6 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ERNAM | Allow NULL? |
| 7 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AENAM | Allow NULL? |
| 8 | LAEDA | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | LAEDA | Allow NULL? |
| 9 | VERAB | Availability date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | VERAB | Allow NULL? |
| 10 | VFDAT | Shelf Life Expiration or Best-Before Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | VFDAT | Allow NULL? |
| 11 | ZUSCH | Batch status key | char | 1 | 0 | CHAR | (N' ') | No | * | DZUSCH | Allow NULL? |
| 12 | ZUSTD | Batch in Restricted-Use Stock | char | 1 | 0 | CHAR | (N' ') | No | | DZUSTD | Allow NULL? |
| 13 | ZAEDT | Date of last status change | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DZAEDT | Allow NULL? |
| 14 | LIFNR | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | ELIFN | Allow NULL? |
| 15 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | CHAR | (N' ') | No | | LICHN | Allow NULL? |
| 16 | VLCHA | Original batch number (deactivated) | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VLCHN | Allow NULL? |
| 17 | VLWRK | Original plant (deactivated) | nvarchar | 4 | 0 | CHAR | (N' ') | No | MARC | VLWRK | Allow NULL? |
| 18 | VLMAT | Original material (deactivated) | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | VLMAT | Allow NULL? |
| 19 | CHAME | Unit of issue for batch (deactivated) | nvarchar | 3 | 0 | UNIT | (N' ') | No | * | CHAME | Allow NULL? |
| 20 | LWEDT | Date of last goods receipt | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | LWEDT | Allow NULL? |
| 21 | FVDT1 | Date for unrestricted use | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FVDAT | Allow NULL? |
| 22 | FVDT2 | Date for unrestricted use | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FVDAT | Allow NULL? |
| 23 | FVDT3 | Date for unrestricted use | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FVDAT | Allow NULL? |
| 24 | FVDT4 | Date for unrestricted use | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FVDAT | Allow NULL? |
| 25 | FVDT5 | Date for unrestricted use | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FVDAT | Allow NULL? |
| 26 | FVDT6 | Date for unrestricted use | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FVDAT | Allow NULL? |
| 27 | HERKL | Country of origin of the material | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005 | HERKL | Allow NULL? |
| 28 | HERKR | Region of origin of material (non-preferential origin) | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005S | HERKR | Allow NULL? |
| 29 | MTVER | Export/import material group | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVFM | MTVER | Allow NULL? |
| 30 | QNDAT | Next Inspection Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | QNPDAT | Allow NULL? |
| 31 | HSDAT | Date of Manufacture | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | HSDAT | Allow NULL? |
| 32 | CUOBJ_BM | Internal object no.: Batch classification | nvarchar | 18 | 0 | NUMC | (N'000000000000000000') | Yes | | CUOBJ_BM | Allow NULL? |
| 33 | DEACT_BM | Batch is no longer active | char | 1 | 0 | CHAR | (N' ') | Yes | | DEACT_BM | Allow NULL? |
| 34 | BATCH_TYPE | Type of Batch | char | 1 | 0 | CHAR | (N' ') | Yes | | BATCH_TYPE | Allow NULL? |
| 35 | SGT_SCAT | Stock Segment | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SGT_SCAT | Allow NULL? |
