| 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 | AVM_NR | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | JHAK | AVM_NR | Allow NULL? |
| 3 | POS_NR | IS-M: Order Item Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | JHAP | POS_NR | Allow NULL? |
| 4 | GRUPPABRNR | IS-M/AM: Billing Dataset | nvarchar | 3 | 0 | NUMC | (N'000') | No | | GRUPPABRNR | Allow NULL? |
| 5 | BELEGEINH | IS-M: Basic Booking Unit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JJTBE | BE_BASIS | Allow NULL? |
| 6 | UR_BELEINH | IS-M: Initial Booking Unit for the OPM Item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JJTBE | UR_BELEINH | Allow NULL? |
| 7 | INSERENT | IS-M: Advertiser | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JHAISZ | INSERENT | Allow NULL? |
| 8 | REGULIERER | IS-M: Payer Business Partner | nvarchar | 10 | 0 | CHAR | (N' ') | No | JGTGPNR | GPNR_RG | Allow NULL? |
| 9 | GPNR_RECH | IS-M: Business Partner - Bill-To Party | nvarchar | 10 | 0 | CHAR | (N' ') | No | JGTGPNR | GPNR_RECH | Allow NULL? |
| 10 | MOTIV | IS-M: Ad Spec Number (Ad) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHAMOT | MOTIV_NR | Allow NULL? |
| 11 | GFMANUAEND | IS-M: Billing Dataset Changed Manually | char | 1 | 0 | CHAR | (N' ') | Yes | | GFMANUAEND | Allow NULL? |
| 12 | GF_STATUS | IS-M: Billing Dataset Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | GF_STATUS | Allow NULL? |
| 13 | PSTYV | IS-M: Item Category for Sales Document | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJHAP | PSTYV_PAM | Allow NULL? |
| 14 | AB_BRUTTO | IS-M: Contract Gross | decimal | 15 | 2 | CURR | ((0)) | Yes | | AB_BRUTTO | |
| 15 | KB_BRUTTO | IS-M: Contract Gross | decimal | 15 | 2 | CURR | ((0)) | Yes | | AB_BRUTTO | |
| 16 | AB_BR_WAEH | IS-M: Gross Contract Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | AB_BR_WAEH | Allow NULL? |
| 17 | RAB1_BETR | IS-M/AM: Percentage discount | decimal | 7 | 3 | DEC | ((0)) | Yes | | JRABPROZ | |
| 18 | RAB1_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 19 | RAB1_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 20 | RAB2_BETR | IS-M/AM: Percentage discount | decimal | 7 | 3 | DEC | ((0)) | Yes | | JRABPROZ | |
| 21 | RAB2_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 22 | RAB2_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 23 | RAB3_BETR | IS-M/AM: Percentage discount | decimal | 7 | 3 | DEC | ((0)) | Yes | | JRABPROZ | |
| 24 | RAB3_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 25 | RAB3_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 26 | RAB4_BETR | IS-M/AM: Quantity-dependent discount | decimal | 11 | 2 | CURR | ((0)) | Yes | | JRABMEIN | |
| 27 | RAB4_PEIN | IS-M: Price Unit (Surcharge Discount, Basic Price) | decimal | 5 | 0 | DEC | ((0)) | Yes | | PAMPEIN | |
| 28 | RAB4_MEIN | IS-M: Unit of Measure (Discount, Surcharge, Basic Price) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | PAMMEIN | Allow NULL? |
| 29 | RAB4_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 30 | RAB4_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 31 | RAB5_BETR | IS-M/AM: Amount discount | decimal | 11 | 2 | CURR | ((0)) | Yes | | JRABBETR | |
| 32 | RAB5_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 33 | RAB5_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 34 | RABE_BETR | IS-M/AM: Amount discount | decimal | 11 | 2 | CURR | ((0)) | Yes | | JRABBETR | |
| 35 | RABE_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 36 | RABE_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 37 | ZUS1_BETR | IS-M/AM: Percentage Surcharge | decimal | 7 | 3 | DEC | ((0)) | Yes | | JZUSPROZ | |
| 38 | ZUS1_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 39 | ZUS1_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 40 | ZUS2_BETR | IS-M/AM: Percentage Surcharge | decimal | 7 | 3 | DEC | ((0)) | Yes | | JZUSPROZ | |
| 41 | ZUS2_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 42 | ZUS2_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 43 | ZUS3_BETR | IS-M/AM: Percentage Surcharge | decimal | 7 | 3 | DEC | ((0)) | Yes | | JZUSPROZ | |
| 44 | ZUS3_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 45 | ZUS3_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 46 | ZUS4_BETR | IS-M/AM: Quantity-dependent surcharge | decimal | 11 | 2 | CURR | ((0)) | Yes | | JZUSMEIN | |
| 47 | ZUS4_PEIN | IS-M: Price Unit (Surcharge Discount, Basic Price) | decimal | 5 | 0 | DEC | ((0)) | Yes | | PAMPEIN | |
| 48 | ZUS4_MEIN | IS-M: Unit of Measure (Discount, Surcharge, Basic Price) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | PAMMEIN | Allow NULL? |
| 49 | ZUS4_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 50 | ZUS4_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 51 | ZUS5_BETR | IS-M/AM: Amount Surcharge | decimal | 11 | 2 | CURR | ((0)) | Yes | | JZUSBETR | |
| 52 | ZUS5_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 53 | ZUS5_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 54 | ZUSE_BETR | IS-M/AM: Amount Surcharge | decimal | 11 | 2 | CURR | ((0)) | Yes | | JZUSBETR | |
| 55 | ZUSE_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 56 | ZUSE_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 57 | FPRG_BETR | IS-M/AM: Basic Price | decimal | 11 | 2 | CURR | ((0)) | Yes | | JGPRBETR | |
| 58 | FPRG_PEIN | IS-M: Price Unit (Surcharge Discount, Basic Price) | decimal | 5 | 0 | DEC | ((0)) | Yes | | PAMPEIN | |
| 59 | FPRG_MEIN | IS-M: Unit of Measure (Discount, Surcharge, Basic Price) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | PAMMEIN | Allow NULL? |
| 60 | FPRG_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 61 | FPRG_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 62 | FPR1_BETR | IS-M/AM: Agreed price | decimal | 11 | 2 | CURR | ((0)) | Yes | | JVPRBETR | |
| 63 | FPR1_GRUND | IS-M: Reason for Entering Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | JGRKOND | Allow NULL? |
| 64 | FPR1_BKTYP | IS-M: Condition Input Type in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKTYP | Allow NULL? |
| 65 | XRABZU | IS-M: Discount/Surcharge Exists Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XRABZU | Allow NULL? |
| 66 | WAER_IPZA | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERK | Allow NULL? |
| 67 | XUZUO_LOE | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |
| 68 | WAERG | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERK | Allow NULL? |
| 69 | FAKSPP | IS-M: Billing Block | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVFS | PAM_FAKSP | Allow NULL? |
| 70 | XSEPFKKOPF | Separate billing document for sales order | char | 1 | 0 | CHAR | (N' ') | Yes | | XSEPFKKOPF | Allow NULL? |
| 71 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 72 | VALDT | Fixed value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALDT | Allow NULL? |
| 73 | VALTG | Additional value days | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | VALTG | Allow NULL? |
| 74 | PERFK | Invoice dates (calendar identification) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | PERFK | Allow NULL? |
| 75 | FAKDATUM | IS-M: Planned Billing/Settlement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JHFKTER | Allow NULL? |
| 76 | VORAUSKNZ | IS-M: Indicates Whether Advance Billing Required | char | 1 | 0 | CHAR | (N' ') | Yes | | VORAUSKNZ | Allow NULL? |
| 77 | VORAUSRCH | IS-M: "Advance billing required" indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VORAUSRCH | Allow NULL? |
| 78 | XRECHN | IS-M: Invoice Requested Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XRECHN | Allow NULL? |
| 79 | XKFMAEND | IS-M: Business Data was Changed Manually Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XKFMAEND | Allow NULL? |
| 80 | KONDA | Price group (customer) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T188 | KONDA | Allow NULL? |
| 81 | XORTSPREIS | IS-M/AM: Local Customer Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XORTSPREIS | Allow NULL? |
| 82 | KALKS | Pricing procedure assigned to this customer | char | 1 | 0 | CHAR | (N' ') | Yes | TVKD | KALKS | Allow NULL? |
| 83 | KUKARR_K | IS-M: Customer Profile | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ95 | JKUKARR | Allow NULL? |
| 84 | KARENZ | IS-M: Grace Period for Price Changes | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | JKARENZ | Allow NULL? |
| 85 | KARENZ_ME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 86 | KDGRP | Customer group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T151 | KDGRP | Allow NULL? |
| 87 | KURST | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | KURST | Allow NULL? |
| 88 | PLTYP | Price list type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T189 | PLTYP | Allow NULL? |
| 89 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | SCHZW_BSEG | Allow NULL? |
| 90 | AE | IS-M: Agency Commission Entitlement | char | 1 | 0 | CHAR | (N' ') | Yes | | AGEN_AE | Allow NULL? |
| 91 | TAXM1 | Tax classification material | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXM1 | Allow NULL? |
| 92 | TAXM2 | Tax classification 2 for material | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXM2 | Allow NULL? |
| 93 | TAXM3 | Tax classification 3 for material | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXM3 | Allow NULL? |
| 94 | TAXM4 | Tax Classification 4 Material | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXM4 | Allow NULL? |
| 95 | TAXM5 | Tax classification 5 for material | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXM5 | Allow NULL? |
| 96 | TAXM6 | Tax classification 6 for material | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXM6 | Allow NULL? |
| 97 | TAXM7 | Tax classification 7 for material | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXM7 | Allow NULL? |
| 98 | TAXM8 | Tax Classification 8 Material | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXM8 | Allow NULL? |
| 99 | TAXM9 | Tax Classification 9 Material | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXM9 | Allow NULL? |
| 100 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 101 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 102 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 103 | AENUSER | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENUSER | Allow NULL? |
| 104 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDATE | Allow NULL? |
| 105 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AENTIME | Allow NULL? |
| 106 | XAB_AUS | IS-M: Contract Exclusion Requirement Applies Yes/No | char | 1 | 0 | CHAR | (N' ') | Yes | | XAB_AUS | Allow NULL? |
| 107 | ACT_ABSCHL | IS-M: Contract Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTVKO | ABS_VTNR | Allow NULL? |
| 108 | ABSCHL_NR | IS-M: Contract Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTVABRUF | ABS_VTNR | Allow NULL? |
| 109 | ABSCHL_POS | IS-M: Contract, Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JHTVABRUF | ABS_POSNR | Allow NULL? |
| 110 | XRABATT | IS-M: Assignment Qualifies for Discount | char | 1 | 0 | CHAR | (N' ') | Yes | | XRABATT | Allow NULL? |
| 111 | XMITZRAB | IS-M: Assignment Counts Towards Discount Fulfillment | char | 1 | 0 | CHAR | (N' ') | Yes | | XMITZRAB | Allow NULL? |
| 112 | XBONUS | IS-M: Assignment Qualifies for Bonus | char | 1 | 0 | CHAR | (N' ') | Yes | | XBONUS | Allow NULL? |
| 113 | XMITZBON | IS-M: Assignment Counts Towards Bonus Fulfillment | char | 1 | 0 | CHAR | (N' ') | Yes | | XMITZBON | Allow NULL? |
| 114 | XMANUELL | IS-M: Contract Assignments Changed Manually Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XMANUELL1 | Allow NULL? |
| 115 | AB_RABATT | IS-M: Current Valid Contract Discount Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | AB_RABATT | |
| 116 | AB_PREIS | IS-M: Current Valid Price from Contract | decimal | 15 | 2 | CURR | ((0)) | Yes | | AB_PREIS | |
| 117 | AKTBONUS | IS-M/AM: Current Valid Contract Bonus | decimal | 5 | 2 | DEC | ((0)) | Yes | | AKTBONUS | |
| 118 | ACT_ABSCH2 | IS-M: Contract Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTVKO | ABS_VTNR | Allow NULL? |
| 119 | ABSCHL_NR2 | IS-M: Contract Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTVABRUF | ABS_VTNR | Allow NULL? |
| 120 | ABSCHL_PO2 | IS-M: Contract, Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JHTVABRUF | ABS_POSNR | Allow NULL? |
| 121 | XRABATT2 | IS-M: Assignment Qualifies for Discount | char | 1 | 0 | CHAR | (N' ') | Yes | | XRABATT | Allow NULL? |
| 122 | XMITZRAB2 | IS-M: Assignment Counts Towards Discount Fulfillment | char | 1 | 0 | CHAR | (N' ') | Yes | | XMITZRAB | Allow NULL? |
| 123 | XBONUS2 | IS-M: Assignment Qualifies for Bonus | char | 1 | 0 | CHAR | (N' ') | Yes | | XBONUS | Allow NULL? |
| 124 | XMITZBON2 | IS-M: Assignment Counts Towards Bonus Fulfillment | char | 1 | 0 | CHAR | (N' ') | Yes | | XMITZBON | Allow NULL? |
| 125 | XMANUELL2 | IS-M: Manual post-editing has taken place | char | 1 | 0 | CHAR | (N' ') | Yes | | XMANUELL | Allow NULL? |
| 126 | AB_RABATT2 | IS-M: Current Valid Contract Discount Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | AB_RABATT | |
| 127 | AB_PREIS2 | IS-M: Current Valid Price from Contract | decimal | 15 | 2 | CURR | ((0)) | Yes | | AB_PREIS | |
| 128 | AKTBONUS2 | IS-M/AM: Current Valid Contract Bonus | decimal | 5 | 2 | DEC | ((0)) | Yes | | AKTBONUS | |
| 129 | ACT_ABSCH3 | IS-M: Contract Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTVKO | ABS_VTNR | Allow NULL? |
| 130 | ABSCHL_NR3 | IS-M: Contract Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTVABRUF | ABS_VTNR | Allow NULL? |
| 131 | ABSCHL_PO3 | IS-M: Contract, Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | JHTVABRUF | ABS_POSNR | Allow NULL? |
| 132 | XRABATT3 | IS-M: Assignment Qualifies for Discount | char | 1 | 0 | CHAR | (N' ') | Yes | | XRABATT | Allow NULL? |
| 133 | XMITZRAB3 | IS-M: Assignment Counts Towards Discount Fulfillment | char | 1 | 0 | CHAR | (N' ') | Yes | | XMITZRAB | Allow NULL? |
| 134 | XBONUS3 | IS-M: Assignment Qualifies for Bonus | char | 1 | 0 | CHAR | (N' ') | Yes | | XBONUS | Allow NULL? |
| 135 | XMITZBON3 | IS-M: Assignment Counts Towards Bonus Fulfillment | char | 1 | 0 | CHAR | (N' ') | Yes | | XMITZBON | Allow NULL? |
| 136 | XMANUELL3 | IS-M: Manual post-editing has taken place | char | 1 | 0 | CHAR | (N' ') | Yes | | XMANUELL | Allow NULL? |
| 137 | AB_RABATT3 | IS-M: Current Valid Contract Discount Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | AB_RABATT | |
| 138 | AB_PREIS3 | IS-M: Current Valid Price from Contract | decimal | 15 | 2 | CURR | ((0)) | Yes | | AB_PREIS | |
| 139 | AKTBONUS3 | IS-M/AM: Current Valid Contract Bonus | decimal | 5 | 2 | DEC | ((0)) | Yes | | AKTBONUS | |
| 140 | PREIS_OM | IS-M: Price excluding VAT | decimal | 15 | 2 | CURR | ((0)) | Yes | | PREIS_OM | |
| 141 | PREIS_IM | IS-M: Price including VAT | decimal | 15 | 2 | CURR | ((0)) | Yes | | PREIS_IM | |
| 142 | PREIS_AVM1 | IS-M: Price Field 1 in the Order | decimal | 15 | 2 | CURR | ((0)) | Yes | | PREIS_AVM1 | |
| 143 | PREIS_AVM2 | IS-M: Price Field 2 in the Order | decimal | 15 | 2 | CURR | ((0)) | Yes | | PREIS_AVM2 | |
| 144 | MWST_BETR | IS-M: Value-Added Tax Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | GRMWSTBETR | |
| 145 | XPREISAEND | IS-M: Price Was Changed Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XPREISAEND | Allow NULL? |
| 146 | SKTOF | Cash discount indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SKTOF | Allow NULL? |
| 147 | NETWFP | Net value of the billing item in document currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | NETWR_FP | |
| 148 | MWSBFP | IS-M: Tax Amount for Billing Item in Document Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | MWSBFP | |
| 149 | BER_TERMIN | IS-M: Date Services were Created for Settlement Purposes | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BER_TERMIN | Allow NULL? |
| 150 | BER_TERMIN_BIS | IS-M: End Date for Service Creation in Terms of Settlement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BER_TERMIN_BIS | Allow NULL? |
| 151 | BER_HEFT | IS-M: Service Creation Copy Number for Settlement | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | ISM_BER_HEFT | Allow NULL? |
| 152 | TERM_TYP | IS-M/AM: Date Category Copy Number/Publication Date | char | 1 | 0 | CHAR | (N' ') | Yes | TJH55 | TERMINTYP | Allow NULL? |
| 153 | VAVARTYP | Actual issue variant type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJD05 | VAVARTYPTA | Allow NULL? |
| 154 | OFFSET_FAK | IS-M: Offset in days for billing date | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | OFFSET_FAK | Allow NULL? |
| 155 | OFFSET_VZ | IS-M: Billing offset sign | char | 1 | 0 | CHAR | (N' ') | Yes | | OFFSET_VZ | Allow NULL? |
| 156 | XKARENZ | IS-M: Use Grace Period Yes / No | char | 1 | 0 | CHAR | (N' ') | Yes | | XKARENZ | Allow NULL? |
| 157 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRSDT | Allow NULL? |
| 158 | STRUK_HTYP | IS-M: Content Component Hierarchy Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ51 | IKO_HIETYP | Allow NULL? |
| 159 | STRUK_HVAR | IS-M: Content Component Structural Hierarchy Variant | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TJJ55 | STRUK_HVAR | Allow NULL? |
| 160 | PREIS_HTYP | IS-M: Content Component Hierarchy Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ51 | IKO_HIETYP | Allow NULL? |
| 161 | PREIS_HVAR | IS-M: Content Component Hierarchy Variant for Pricing | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TJJ55 | PREIS_HVAR | Allow NULL? |
| 162 | IHKOMP | IS-M: Content component from price hierarchy | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JJTIKO | INHK_PRICE | Allow NULL? |
| 163 | SEITE_FSP | IS-M: Page/column format | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ47 | SEITE_FSP | Allow NULL? |
| 164 | SEITE_FORM | IS-M: Page Format | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ01 | SEITE_FORM | Allow NULL? |
| 165 | SMM_SFSP | IS-M: Size in column mm | decimal | 13 | 3 | DEC | ((0)) | Yes | | MENGE_SMM | |
| 166 | SFSP_ABR | IS-M: Column Format for Settlement | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ47 | SFSP_ABR | Allow NULL? |
| 167 | SMM_ABR | IS-M: Size in column mm | decimal | 13 | 3 | DEC | ((0)) | Yes | | MENGE_SMM | |
| 168 | FACT_ABR | IS-M: Conversion Factor for Settlement | decimal | 4 | 3 | DEC | ((0)) | Yes | | FACT_ABR | |
| 169 | WERBK_TYP | IS-M: Advertising Combination Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJH91 | WERBK_TYP | Allow NULL? |
| 170 | WERBK_KNZ | IS-M: Combination Sale Indicator | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | WERBK_KNZ | Allow NULL? |
| 171 | ABS_MAL | IS-M: Number for Contract Standing | decimal | 5 | 0 | DEC | ((0)) | No | | JHRSMAL | |
| 172 | AZART_AREA | IS-M/AM: Fixed Format Proposal /Ad Dimensions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ13 | AZART_AREA | Allow NULL? |
| 173 | BREITE | IS-M: Ad Spec Width for Settlement | decimal | 7 | 3 | QUAN | ((0)) | Yes | | BREITE_VER | |
| 174 | BREITE_EH | IS-M/AM: Unit of Measure for Width | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | TJH57 | BREITE_SEH | Allow NULL? |
| 175 | HOEHE | IS-M: Clearable Height for Ad Spec | decimal | 7 | 3 | QUAN | ((0)) | Yes | | HOEHE_VER | |
| 176 | HOEHE_EH | IS-M: Unit of Measure for Height | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | TJH61 | ISPEINH_H | Allow NULL? |
| 177 | ZUS_MENGE | IS-M: Number of Additional Ad Spec Calculation Units | decimal | 7 | 3 | QUAN | ((0)) | Yes | | BER_MENGE | |
| 178 | ZUS_BERECH | IS-M: Additional Unit of Measure for Settlement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | TJH57 | MEINH_ZUS | Allow NULL? |
| 179 | MGLME | Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MENGE_D | |
| 180 | LAGME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | LAGME | Allow NULL? |
| 181 | AZART_GEST | IS-M: Design Ad Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ19 | AZART_GEST | Allow NULL? |
| 182 | AZART_FORM | IS-M: Shape Ad Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ17 | AZART_FORM | Allow NULL? |
| 183 | AZART_FARB | IS-M: Color Scheme Ad Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJJ11 | AZART_FARB | Allow NULL? |
| 184 | AZART_SOND | IS-M: Ad Type - Special Handling Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ49 | AZART_SOND | Allow NULL? |
| 185 | FKART | IS-M/AM: Billing/Settlement Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJH05 | FKART_PAM | Allow NULL? |
| 186 | KALSM | Sales and Distribution: Pricing Procedure in Pricing | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSMASD | Allow NULL? |
| 187 | DRERZ | Publication | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JDTDRER | DRERZ | Allow NULL? |
| 188 | PVA | Edition | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | JDTPVA | PVA | Allow NULL? |
| 189 | BLGMENGE | IS-M: Order Quantity for Insertion | decimal | 9 | 0 | DEC | ((0)) | Yes | | BLGMENGE | |
| 190 | DISPMENGE | IS-M: Planning Quantity of Carrying Issue | decimal | 9 | 0 | DEC | ((0)) | Yes | | DISPMENGE | |
| 191 | VRTMENGE | IS-M/AM: Actual Quantity for Distribution | decimal | 9 | 0 | DEC | ((0)) | No | | VRTMGI_PAM | |
| 192 | BERMENGE | IS-M: Calculation Quantity (Ad Insert) | decimal | 9 | 0 | DEC | ((0)) | Yes | | BERMENGE | |
| 193 | POSTMENGE | IS-M: Postal Circulation Quantity | decimal | 9 | 0 | DEC | ((0)) | No | | POSTMENGE | |
| 194 | SI_TYP | IS-M: Ad Insert Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJH29 | SITYP | Allow NULL? |
| 195 | SIGEWICHT | Actual Issue Weight | decimal | 9 | 3 | QUAN | ((0)) | No | | VAGEWIST | |
| 196 | SIGEW_ME | Unit of weight for actual issue weight | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | MEINHVAGEI | Allow NULL? |
| 197 | SI_GEWKL | IS-M: Ad inserts weight price group | nvarchar | 4 | 0 | CHAR | (N' ') | No | TJHGEWKL | ISM_SI_GEWKL | Allow NULL? |
| 198 | SI_SEITEN | Number of Pages in Issue | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | ANZSEITEN | Allow NULL? |
| 199 | SI_SEKL | IS-M: Price Group for Ad Insert Pages | nvarchar | 4 | 0 | CHAR | (N' ') | No | TJHSEKL | ISM_SI_SEKL | Allow NULL? |
| 200 | WS_TIMESLC | IS-M: Commercial Time Slice | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJW1 | WS_TIMESLC | Allow NULL? |
| 201 | WS_BLOCK | IS-M: Commercial Cluster | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJW3 | WS_BLOCK | Allow NULL? |
| 202 | WS_STELLE | IS-M: Position (Sequence) Within a Commercial Cluster | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | WS_STELLE | Allow NULL? |
| 203 | XUNITERROR | IS-M: Quantity Conversion Error Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XUNITERROR | Allow NULL? |
| 204 | XAEPROV | IS-M: Agency Commission Credit Memo Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XAEPROV | Allow NULL? |
| 205 | ZW_GRABRNR | IS-M: Twinned Billing Dataset for Separate Agency Commission | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | JHAGA | ISM_TWIN_BILLING_DATASET_NO | Allow NULL? |
| 206 | JAEPRBASIS | IS-M: Agency commission basis | decimal | 13 | 2 | CURR | ((0)) | Yes | | JAEPRBASIS | |
| 207 | ANZ_ANFS | IS-M: No.of Placements Qual.for Disc.Due to Pub.in Other BUs | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ANZ_ANFS | Allow NULL? |
| 208 | ANZ_WNFS | IS-M: No.of Placements Qual.For Dis.Due to Publc.On Oth.Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ANZ_WNFS | Allow NULL? |
| 209 | XFAKT_EE | IS-M: Billed Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XFAKT_EE | Allow NULL? |
| 210 | XPROVMIN1 | Partial Commission (At Least 1 Sales Agent Assignment Comm.) | char | 1 | 0 | CHAR | (N' ') | Yes | | XPROVMIN1 | Allow NULL? |
| 211 | XPROVALL | Commission Calculated For All Sales Agent Assignments Ind. | char | 1 | 0 | CHAR | (N' ') | Yes | | XPROVALL | Allow NULL? |
| 212 | XUVVZ | IS-M: Sales Agent Assignment Incomplete | char | 1 | 0 | CHAR | (N' ') | Yes | | XUVVZ | Allow NULL? |
| 213 | XERL_EE | IS-M: Revenue Distribution Performed | char | 1 | 0 | CHAR | (N' ') | Yes | | XERL_EE | Allow NULL? |
| 214 | XABS_EE | IS-M: Contract Final Settlement Performed | char | 1 | 0 | CHAR | (N' ') | Yes | | XABS_EE | Allow NULL? |
| 215 | XPREIS_EE | IS-M: Pricing completed | char | 1 | 0 | CHAR | (N' ') | Yes | | XPREIS_EE | Allow NULL? |
| 216 | XCCAUTNOTW | IS-M/AM: Payment card authorization required | char | 1 | 0 | CHAR | (N' ') | No | | XCCAUTNOTW | Allow NULL? |
| 217 | XCMP_FAILED | IS-M/AM: Credit check failed | char | 1 | 0 | CHAR | (N' ') | No | | XCMP_FAILED | Allow NULL? |
| 218 | MERKMAL0 | IS-M: Characteristic 9 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK0_GA | Allow NULL? |
| 219 | MERKMAL1 | IS-M: Characteristic 1 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK1_GA | Allow NULL? |
| 220 | MERKMAL2 | IS-M: Characteristic 2 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK2_GA | Allow NULL? |
| 221 | MERKMAL3 | IS-M: Characteristic 3 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK3_GA | Allow NULL? |
| 222 | MERKMAL4 | IS-M: Characteristic 4 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK4_GA | Allow NULL? |
| 223 | MERKMAL5 | IS-M: Characteristic 5 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK5_GA | Allow NULL? |
| 224 | MERKMAL6 | IS-M: Characteristic 6 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK6_GA | Allow NULL? |
| 225 | MERKMAL7 | IS-M: Characteristic 7 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK7_GA | Allow NULL? |
| 226 | MERKMAL8 | IS-M: Characteristic 8 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK8_GA | Allow NULL? |
| 227 | MERKMAL9 | IS-M: Characteristic 9 for Individual Use (Billing Dataset) | char | 1 | 0 | CHAR | (N' ') | Yes | | MERK9_GA | Allow NULL? |
| 228 | XSTORNIERT | IS-M: Canceled Order Object Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XSTORNIERT | Allow NULL? |
| 229 | STORNOGRND | IS-M: Cancellation Reason | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TJHSTOG | STOGRD_PAM | Allow NULL? |
| 230 | REF_VBELN | IS-M/AM: Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JHTFK | JJBELNR | Allow NULL? |
| 231 | REF_POSNR | IS-M/AM: Item (number) in settlement document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | JHTFP | JJPOSNR | Allow NULL? |
| 232 | XFCNCL | IS-M/AM: Reversal Indicator for Billing Item | char | 1 | 0 | CHAR | (N' ') | No | | JH_XCNCL | Allow NULL? |
| 233 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TMCB | STAFO | Allow NULL? |
| 234 | KZWI1 | Subtotal 1 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI1 | |
| 235 | KZWI2 | Subtotal 2 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI2 | |
| 236 | KZWI3 | Subtotal 3 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI3 | |
| 237 | KZWI4 | Subtotal 4 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI4 | |
| 238 | KZWI5 | Subtotal 5 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI5 | |
| 239 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI6 | |
| 240 | CMPRE_FLT | Item credit price | float | 15 | 16 | FLTP | ((0)) | No | | CMPRE_FLT | |
| 241 | FORMAT_ONL | IS-M/AM: Format Proposal (Online) | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | FORMAT_ONL | Allow NULL? |
| 242 | RRREL | IS-M/AM: Revenue Recognition Category | char | 1 | 0 | CHAR | (N' ') | Yes | | ISMRR_RELTYP | Allow NULL? |
| 243 | RRSTA | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 244 | PACKAGE_ID | Package | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JJTPC | ISM_PACKAGE_ID | Allow NULL? |
| 245 | PK_REF_AVM_NR | Order Number for Package Reference Order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISM_PK_REF_AVM_NR | Allow NULL? |
| 246 | PK_REF_POS_NR | Item Number of Package Item to be Referenced | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | ISM_PK_REF_POS_NR | Allow NULL? |
| 247 | PK_ELEMENT_ID | Package Element ID | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | ISM_PK_ELEMENT_ID | Allow NULL? |
| 248 | PK_PSTYV | Package Item Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJHAP | ISM_PK_PSTVY | Allow NULL? |
| 249 | PREIS_AVM3 | IS-M: Price Field 3 in the Order | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISM_PREIS_AVM3 | |
| 250 | PREIS_AVM4 | IS-M: Price Field 4 in the Order | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISM_PREIS_AVM4 | |
| 251 | PREIS_AVM5 | IS-M: Price Field 5 in the Order | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISM_PREIS_AVM5 | |
| 252 | PREIS_AVM6 | IS-M: Price Field 6 in the Order | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISM_PREIS_AVM6 | |
| 253 | PREIS_AVM7 | IS-M: Price Field 7 in the Order | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISM_PREIS_AVM7 | |
| 254 | PREIS_AVM8 | IS-M: Price Field 8 in the Order | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISM_PREIS_AVM8 | |
| 255 | XPK_PREIS_EE | Package Pricing Performed | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_XPK_PREIS_EE | Allow NULL? |
| 256 | X_SL_CONTCOMP_CH | Publication Change: Content Component for Sched.Line Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_PUB_CHAN_SL_CONTCOMP_CHNGD | Allow NULL? |
| 257 | MIN_MAX_AD_SIZE | Min Max Ad Size | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /NAM/MIN_MAX_AD_SIZE | |