| 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 | BEZIRK | Carrier Route | nvarchar | 10 | 0 | CHAR | (N' ') | No | JVTBEZIRK | BEZIRK | Allow NULL? |
| 3 | XVRTBEZIRK | Ad pre-print zone | char | 1 | 0 | CHAR | (N' ') | No | | XVRTBEZIRK | Allow NULL? |
| 4 | XTITBEZIRK | Carrier route | char | 1 | 0 | CHAR | (N' ') | No | | XTITBEZIRK | Allow NULL? |
| 5 | XBLGBEZIRK | Insert zone | char | 1 | 0 | CHAR | (N' ') | No | | XBLGBEZIRK | Allow NULL? |
| 6 | XFRDBEZIRK | Indicator: Carrier route with third party home delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | XFRDBEZIRK | Allow NULL? |
| 7 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 8 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 9 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 10 | AENUSER | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENUSER | Allow NULL? |
| 11 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDATE | Allow NULL? |
| 12 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AENTIME | Allow NULL? |
| 13 | XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM_ISP | Allow NULL? |
| 14 | XLOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEKZ_ISP | Allow NULL? |
| 15 | XSPERRE | General Block for Order Management | char | 1 | 0 | CHAR | (N' ') | Yes | | XSPERRE | Allow NULL? |
| 16 | XRECHERCH | Sale only if research performed | char | 1 | 0 | CHAR | (N' ') | Yes | | XRECHERCH | Allow NULL? |
| 17 | XVORKAS | Sale only with advance payment | char | 1 | 0 | CHAR | (N' ') | Yes | | XVORKAS | Allow NULL? |
| 18 | XEZBZG | No single purchases allowed in order processing | char | 1 | 0 | CHAR | (N' ') | Yes | | XEZBZG | Allow NULL? |
| 19 | XZUSATZZUS | IS-M: Insert delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | XZUSATZZUS | Allow NULL? |
| 20 | FAHRKM | Distance (for Home Delivery Settlement) | decimal | 9 | 3 | QUAN | ((0)) | Yes | | FAHRKM | |
| 21 | EINHFAHRKM | Unit (km/m) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | EINHFAHRKM | Allow NULL? |
| 22 | ZAHLSHLSSL | IS-M: Number of Keys in Carrier Route (for Home Del. Sett.) | decimal | 3 | 0 | QUAN | ((0)) | Yes | | ISPSHLSSL | |
| 23 | EINHSHLSSL | IS-M: Unit for Number of Keys | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | EINHSHLSSL | Allow NULL? |
| 24 | TRAGEZEITK | Distribution time category (for home delivery settlement) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV15 | TRAGEZEITK | Allow NULL? |
| 25 | FAHRKMKAT | Distance Traveled: Category (for Home Delivery Settlement) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV13 | FAHRKMKAT | Allow NULL? |
| 26 | WEGLANGKAT | IS-M: Path length category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV35 | WEGLANGKAT | Allow NULL? |
| 27 | TOPOLOGIEK | Topography category (for home delivery settlement) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV11 | TOPOLOGIEK | Allow NULL? |
| 28 | BEZKATE1 | Carrier Route Flat Rate Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV23 | BEZKATE1 | Allow NULL? |
| 29 | BEZKATE2 | IS-M: Carrier Route Category 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV25 | BEZKATE2 | Allow NULL? |
| 30 | BEZKATE3 | IS-M: Carrier Route Category 3 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV27 | BEZKATE3 | Allow NULL? |
| 31 | BEZKATE4 | IS-M: Carrier Route Category 4 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV29 | BEZKATE4 | Allow NULL? |
| 32 | BEZKATE5 | IS-M: Carrier Route Category 5 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV31 | BEZKATE5 | Allow NULL? |
| 33 | SCHLGLDKAT | IS-M: Key compensation category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJV33 | SCHLGLDKAT | Allow NULL? |
| 34 | PROSPOTNTL | IS-M: Planned circulation quantity for ad pre-prints | decimal | 11 | 0 | DEC | ((0)) | Yes | | PROSPOTNTL | |
| 35 | TITLPOTNTL | IS-M: Planned customer circulation quantity for title | decimal | 11 | 0 | DEC | ((0)) | Yes | | TITLPOTNTL | |
| 36 | XLAUFLIST | IS-M: Generate carrier round sequence during release | char | 1 | 0 | CHAR | (N' ') | Yes | | XLAUFLIST | Allow NULL? |
| 37 | XAKTUELL | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 38 | WEGLANG | Path length for home delivery or distribution | decimal | 9 | 3 | QUAN | ((0)) | Yes | | WEGLANG | |
| 39 | MEIWLANG | Unit of measurement for path length | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINWLAENG | Allow NULL? |
| 40 | TRAGEZEIT | IS-M: Distribution time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TRAGEZEIT | Allow NULL? |
| 41 | ZUSZSTLLZ | Additional home delivery time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | JZUSZSTLLZ | Allow NULL? |
| 42 | ZSTLLZNABO | Delivery time including delivery to non-subscribers | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | JZSTLZNABO | Allow NULL? |
| 43 | XKONSIST | Indicator: Consistency of carrier route structure | char | 1 | 0 | CHAR | (N' ') | Yes | | XKONSIST | Allow NULL? |
| 44 | WEGLANGABO | Path length for parallel delivery to non-subscribers | decimal | 9 | 3 | QUAN | ((0)) | Yes | | WEGLANGABO | |
| 45 | MEIWLANGAB | Unit of measurement for path length | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINWLAENG | Allow NULL? |
| 46 | BEABSTELLE | Main Unloading Point for Carrier Route (Default) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JRTBEABST | BEABLSTH | Allow NULL? |
| 47 | BEWERTUNG | IS-M: Valuation of carrier route for home del.settlement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | JZBEWERT | Allow NULL? |
| 48 | XSCRIPT | SAPscript comment recorded | char | 1 | 0 | CHAR | (N' ') | Yes | | XSCRIPT | Allow NULL? |
| 49 | ZUSTELLER | IS-M: Carrier | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JGTGPNR | JZUSTELLER | Allow NULL? |
| 50 | ZSGLSSCHFT | IS-M/SD: Service Company to Which Carrier Belongs | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JGTGPNR | VSGZUSTLR | Allow NULL? |
| 51 | GPINKASSO | IS-M: Field Collector | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JGTGPNR | GPINKASSO | Allow NULL? |
| 52 | VSGINKASSO | Service company for field collector (optional) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JGTGPNR | VSGINKB | Allow NULL? |
| 53 | GPRECH | IS-M: Researcher | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JGTGPNR | GPRECH | Allow NULL? |
| 54 | VSGRCHEUR | Researcher's Service Company | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JGTGPNR | VSGRCHEUR | Allow NULL? |
