| 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 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVTA | VKORG | Allow NULL? |
| 3 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTA | VTWEG | Allow NULL? |
| 4 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTA | SPART | Allow NULL? |
| 5 | XGP_ZAHLW | IS-M: Only Payment Methods From BP Master Data Permitted | char | 1 | 0 | CHAR | (N' ') | Yes | | XGP_ZAHLW | Allow NULL? |
| 6 | TERM_TYP | IS-M: Default Value for Date Category in Order Item | char | 1 | 0 | CHAR | (N' ') | Yes | TJH55 | TERMTYP_DF | Allow NULL? |
| 7 | PERFK_DEF | IS-M: Default Billing Schedules (Calendar Ident.) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | JPERFK_DEF | Allow NULL? |
| 8 | OFFSET_DEF | IS-M: Default Offset in Days for Advance Payment | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | OFFSET_DEF | Allow NULL? |
| 9 | ISPEINH_PR | Unit of Measure for Ad Dimensions (Qty-Dependent Prices) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | TJH51 | ISPEINH_PR | Allow NULL? |
| 10 | HOEHE_DEH | IS-M/AM: Default Setting for Height Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | No | TJH61 | HOEHE_DEH | Allow NULL? |
| 11 | AZART_RECH | IS-M: Default Setting for Calculation Ad Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJH79 | AZ_RECHDEF | Allow NULL? |
| 12 | XIKOHI_EXP | IS-M: Ind. Present cont.comp.hierarchy in exploded form | char | 1 | 0 | CHAR | (N' ') | Yes | | XIKOHI_EXP | Allow NULL? |
| 13 | XHIDE_SVO | IS-M: Give Preference to Cont.Comps in Ad Section Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XHIDE_SVO | Allow NULL? |
| 14 | XALLIKO_SV | IS-M: No Plausibility Check for Special Publication | char | 1 | 0 | CHAR | (N' ') | No | | XALLIKO_SV | Allow NULL? |
| 15 | XNOFLTR_BE | IS-M/AM: Indicator Do not filter dates for additional BUs | char | 1 | 0 | CHAR | (N' ') | No | | XNOFLTR_BE | Allow NULL? |
| 16 | XDELCOL_GB | Deduct Gutter Bleed Column for Calculation of Technical Size | char | 1 | 0 | CHAR | (N' ') | No | | XDELCOL_GB | Allow NULL? |
| 17 | SI_ABRMNGE | IS-M: Ad insert quantity for settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_SI_ABRMNGE | Allow NULL? |
| 18 | SI_SHIPP_CHECK | IS-M/AM: Check M/SD Shipping Preps when Creating AI Item | nvarchar | 2 | 0 | CHAR | (N' ') | No | | JSI_SHIPP_CHECK | Allow NULL? |
| 19 | VT_ABRMNGE | IS-M/AM: Distribution quantity for settlement | char | 1 | 0 | CHAR | (N' ') | No | | ISM_VT_ABRMNGE | Allow NULL? |
| 20 | VT_SHIPP_CHECK | IS-M/AM: Check M/SD shipping preps when creating DT item | nvarchar | 2 | 0 | CHAR | (N' ') | No | | JVT_SHIPP_CHECK | Allow NULL? |
| 21 | XKONKAUSAZ | IS-M: Competitor Exclusion Active for Ad Items? | char | 1 | 0 | CHAR | (N' ') | Yes | | XKONKAUSAZ | Allow NULL? |
| 22 | XKONKAUSDI | IS-M: Competitor Exclusion Active for Service Item? | char | 1 | 0 | CHAR | (N' ') | Yes | | XKONKAUSDI | Allow NULL? |
| 23 | XKONKAUSSI | IS-M: Competitor Exclusion Active for AI Item? | char | 1 | 0 | CHAR | (N' ') | Yes | | XKONKAUSSI | Allow NULL? |
| 24 | XKONKAUSWS | IS-M: Competitor Exclusion Active for Commercial Item? | char | 1 | 0 | CHAR | (N' ') | Yes | | XKONKAUSWS | Allow NULL? |
| 25 | XKONKAUSVT | IS-M/AM: Competitor Exclusion is Active for DT Item | char | 1 | 0 | CHAR | (N' ') | No | | XKONKAUSVT | Allow NULL? |
| 26 | XVZ_GLEICH | IS-M: Equal Distribution Of Sales Agent Commission | char | 1 | 0 | CHAR | (N' ') | Yes | | XVZ_GLEICH | Allow NULL? |
| 27 | XVZ_PBAS | Divide Commission Basis For Sales Agent Commission Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XVZ_PBAS | Allow NULL? |
| 28 | XVZ_BETRAG | IS-M: Amount for Sales Agent Commission Division Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XVZ_BETRAG | Allow NULL? |
| 29 | BE_POPUP | IS-M/AM: Control Voucher Copy Recipient Selection | char | 1 | 0 | CHAR | (N' ') | Yes | | BE_POPUP | Allow NULL? |
| 30 | CHTYPE_AVM | IS-M/AM: Order Change Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJHCHTYPE_AVM | CHTYPE_AVM | Allow NULL? |
| 31 | OFF_WVL | IS-M: Responses resubmission date (days after publ.date) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | OFF_WVL | Allow NULL? |
| 32 | XAAZUL_OUT | IS-M: Deactivate ad type admissibility check | char | 1 | 0 | CHAR | (N' ') | No | | XAAZUL_OUT | Allow NULL? |
| 33 | XPRDIAL_AZ | IS-M: Pricing Dialog in Display Mode Only Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XPRDIAL_AZ | Allow NULL? |
| 34 | XVALUE_CHK | IS-M: Check Value of Credit and Debit Memos | char | 1 | 0 | CHAR | (N' ') | No | | XVALUE_CHK | Allow NULL? |
| 35 | BB_LADEN | IS-M: Indicator Load Requirement Elements | char | 1 | 0 | CHAR | (N' ') | Yes | | BB_LADEN | Allow NULL? |
| 36 | XVFND_FAKT_EE | IS-M: Sales Agent Determination for Billed Billing Datasets | char | 1 | 0 | CHAR | (N' ') | No | | XVFND_FAKT_EE | Allow NULL? |
| 37 | KOVAR_BLGHNW | IS-M/AM: Copying Variants for Insert Note | nvarchar | 4 | 0 | CHAR | (N' ') | No | TJHAKO | KOVAR_BLGHNW | Allow NULL? |
| 38 | WKTYP_BLGHNW | IS-M/AM: Combination Sale Type for Insert Note | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJH91 | WKTYP_BLGHNW | Allow NULL? |
| 39 | KOVAR_TRGANZ | IS-M: Copying Variant for Carrier Ad | nvarchar | 4 | 0 | CHAR | (N' ') | No | TJHAKO | KOVAR_TRGANZ | Allow NULL? |
| 40 | WKTYP_TRGANZ | IS-M/AM: Combination Sale Type for Carrying Ad | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJH91 | WKTYP_TRGANZ | Allow NULL? |
| 41 | AVM_MOTHLP | IS-M: Select Ad Spec Number in the Order | char | 1 | 0 | CHAR | (N' ') | No | | AVM_MOTHLP | Allow NULL? |
| 42 | BRANCHE_POPUP | IS-M/AM: Industry Sector Dialog Box Required Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | BRANCHE_POPUP | Allow NULL? |
| 43 | BRANCHE_GRPFKT | IS-M/AM: Item Industry Sector Indicator for Billing Dataset | char | 1 | 0 | CHAR | (N' ') | Yes | | BRANCHE_GRPFKT | Allow NULL? |
| 44 | XREKLBEARB_USR | IS-M/AM: Complaint Processor Must Be User Indicator | char | 1 | 0 | CHAR | (N' ') | No | | XREKLBEARB_USR | Allow NULL? |
| 45 | ERSTER_WOCHENTAG | IS-M: First Day of the Week | char | 1 | 0 | NUMC | (N'0') | No | | ISM_ERSTER_WOCHENTAG | Allow NULL? |
| 46 | SPLIT_MSG_TYPE | Message Type for Ad Size Check | char | 1 | 0 | CHAR | (N' ') | Yes | | /NAM/SPLIT_MSG_TYPE | Allow NULL? |
| 47 | XPRGRP_ADV | Pull Price Group from Advertiser | char | 1 | 0 | CHAR | (N' ') | Yes | | /NAM/ISM_XPRGRP_ADV | Allow NULL? |
| 48 | XSRTWD_ADSP_LEV | Store Sortword at Ad Spec Level | char | 1 | 0 | CHAR | (N' ') | Yes | | /NAM/ISM_XSRTWD_ADSP_LEV | Allow NULL? |
