| 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 | LFNGNR | IS-M: Sequence Number for Delivery | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | | LFNGNR | Allow NULL? |
| 3 | NACHLFNGNR | Sequence number of subsequent delivery | nvarchar | 2 | 0 | NUMC | (N'00') | No | | NACHLFNGNR | Allow NULL? |
| 4 | LFNGART | Type of Delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | LFNGART | Allow NULL? |
| 5 | VAUSGB | Issue | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JDTVAUSGB | VAUSGB | Allow NULL? |
| 6 | BEILGAUSST | Insert Mix for Carrying Issue in Delivery | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | JVTBLGAUS | BEILGAUSST | Allow NULL? |
| 7 | ANZEIGENAUSST | Ad Mix in Carrying Issue for a Delivery | nvarchar | 3 | 0 | NUMC | (N'000') | No | JVTANZAUS | ANZEIGENAUSST | Allow NULL? |
| 8 | BEZUGSTYP | Mix Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | JDTBEZTYP | BEZUGSTYP_JE_PVA | Allow NULL? |
| 9 | DRERZTAT | Actual Publication Delivered | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JDTDRER | DRERZTAT | Allow NULL? |
| 10 | PVATAT | Actual edition delivered | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JDTPVA | PVATAT | Allow NULL? |
| 11 | MEDIAISSUE | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 12 | BEZIRKTAT | Actual Carrier Route | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JVTBEZIRK | BEZIRKTAT | Allow NULL? |
| 13 | GEOEINTAT | Actual Geographical Unit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JSTGEOEINH | GEOEINTAT | Allow NULL? |
| 14 | BEABLST | IS-M: Unloading Point | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JRTBEABST | BEABLST | Allow NULL? |
| 15 | VSAUSSTART | Shipping outsorting type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV09 | VSAUSSTART | Allow NULL? |
| 16 | LFBNRAUF | Order-related viability set | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | JVTLIEFBAR | LFBNRAUF | Allow NULL? |
| 17 | LFBNRVBR | Distribution viability set | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | JVTLIEFBAR | LFBNRVBR | Allow NULL? |
| 18 | LFARTTAT | Actual delivery type (usually DT for dist.viability set) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV01 | LFARTTAT | Allow NULL? |
| 19 | MBZART | Combination type of edition combined in mix type definition | char | 1 | 0 | NUMC | (N'0') | Yes | | MITBEZART | Allow NULL? |
| 20 | KNDGRUPPE | IS-M: Customer Group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T151 | KNDGRUPPE | Allow NULL? |
| 21 | AUARTGRP | IS-M/SD: Sales document type grouping | char | 1 | 0 | CHAR | (N' ') | Yes | | JAUARTGRP | Allow NULL? |
| 22 | ERSCHDAT | Publication Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERSCHDAT | Allow NULL? |
| 23 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VRSNDDATUM | Allow NULL? |
| 24 | VRSNDZTRGL | IS-M: Time offset rule | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | VRSNDZTRGL | Allow NULL? |
| 25 | SPLIT | IS-M: Issue mix | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | JVASPLIT | Allow NULL? |
| 26 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 27 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWEG | Allow NULL? |
| 28 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T024E | EKORG | Allow NULL? |
| 29 | DRUCKEREI | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | JWERK | Allow NULL? |
| 30 | LFARTLOG | Logistical delivery type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV01 | LFARTLOG | Allow NULL? |
| 31 | LFMENGE | Edition delivery quantity | decimal | 9 | 0 | DEC | ((0)) | Yes | | LIEFRMENGE | |
| 32 | BEZRUNDTAT | Actual Delivery Round | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JVTRUNDE | BEZRUNDTAT | Allow NULL? |
| 33 | RESMNGPLAN | Planned reserve quantity per delivery | decimal | 9 | 0 | DEC | ((0)) | Yes | | RESMNGPLAN | |
| 34 | WRBMNGPLAN | Planned quantity for promotional copies in a delivery | decimal | 9 | 0 | DEC | ((0)) | Yes | | WRBMNGPLAN | |
| 35 | NORMMNGIZU | Actual Quantity of Standard Units in a Carrier's Delivery | decimal | 9 | 0 | DEC | ((0)) | Yes | | NORMMNGIZU | |
| 36 | NORMMNGIZG | Actual Qty Standard Units in a Home Del. Company's Delivery | decimal | 9 | 0 | DEC | ((0)) | Yes | | NORMMNGIZG | |
| 37 | WRBMNGIZU | Actual Quantity of Prom. Copies in a Carrier's Delivery | decimal | 9 | 0 | DEC | ((0)) | Yes | | WRBMNGIZU | |
| 38 | WRBMNGIZG | Actual Quantity of Prom. Copies in a Del. Company's Delivery | decimal | 9 | 0 | DEC | ((0)) | Yes | | WRBMNGIZG | |
| 39 | XZUABRCHNG | Indicator: Carrier Home Delivery Settlement Archived | char | 1 | 0 | CHAR | (N' ') | Yes | | XZUABGRCHN | Allow NULL? |
| 40 | XZGABRCHNG | Indicator: SC Home Delivery Settlement Archived | char | 1 | 0 | CHAR | (N' ') | Yes | | XZGABGRCHN | Allow NULL? |
| 41 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TMCB | STAFO | Allow NULL? |
| 42 | XLISFORTS | Indicator: LIS update performed | char | 1 | 0 | CHAR | (N' ') | Yes | | XJLISFORTS | Allow NULL? |
| 43 | XIVWFORTS | Indicator: Delivery data updated in circulation book | char | 1 | 0 | CHAR | (N' ') | Yes | | XIVWFORTS | Allow NULL? |
| 44 | XINCLABHOL | Indicator: Includes pickup | char | 1 | 0 | CHAR | (N' ') | Yes | | XINCLABHOL | Allow NULL? |
| 45 | XVERSVORLF | Initial shipping run carried out for inserts | char | 1 | 0 | CHAR | (N' ') | Yes | | XVERSVORLF | Allow NULL? |
| 46 | XLFTSFORTS | Daily delivery statistics updated | char | 1 | 0 | CHAR | (N' ') | Yes | | XLFTSFORTS | Allow NULL? |
| 47 | XFKBASLIEF | IS-M: Billing based on delivery | char | 1 | 0 | CHAR | (N' ') | No | | XFKBASLIEF | Allow NULL? |
| 48 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 49 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 50 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 51 | ERFPROG | Program Used to Create Object | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | ERFPROG | Allow NULL? |
| 52 | AENUSER | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENUSER | Allow NULL? |
| 53 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDATE | Allow NULL? |
| 54 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AENTIME | Allow NULL? |
| 55 | AENPROG | Program that Made Last Change | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | AENPROG | Allow NULL? |
| 56 | XAMORTN_FIN | IS-M/SD: Amortization completed | char | 1 | 0 | CHAR | (N' ') | No | | XAMORTN_FIN | Allow NULL? |
| 57 | XAMORTN_START | IS-M/SD: Amortization begun for delivery | char | 1 | 0 | CHAR | (N' ') | No | | XAMORTN_START | Allow NULL? |
| 58 | BEILGAUSST_FIX | IS-M/SD: Insert Mix Fixed | char | 1 | 0 | CHAR | (N' ') | Yes | | JBEILGAUSST_FIX | Allow NULL? |
| 59 | XAMORTN_NO | IS-M/SD: Do Not Execute Amortization for Delivery | char | 1 | 0 | CHAR | (N' ') | No | | XAMORTN_NOT_RELEVANT | Allow NULL? |
