SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: SAP Media :: Advertising Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JHAGA2573IS-M/AM: Order-Publishing-Media Billing DatasetAdvertising Management
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, AVM_NR, POS_NR, GRUPPABRNR, BELEGEINH, UR_BELEINH, INSERENT, REGULIERER, GPNR_RECH, MOTIV, GFMANUAEND, GF_STATUS, PSTYV, AB_BRUTTO, KB_BRUTTO, AB_BR_WAEH, RAB1_BETR, RAB1_GRUND, RAB1_BKTYP, RAB2_BETR, RAB2_GRUND, RAB2_BKTYP, RAB3_BETR, RAB3_GRUND, RAB3_BKTYP, RAB4_BETR, RAB4_PEIN, RAB4_MEIN, RAB4_GRUND, RAB4_BKTYP, RAB5_BETR, RAB5_GRUND, RAB5_BKTYP, RABE_BETR, RABE_GRUND, RABE_BKTYP, ZUS1_BETR, ZUS1_GRUND, ZUS1_BKTYP, ZUS2_BETR, ZUS2_GRUND, ZUS2_BKTYP, ZUS3_BETR, ZUS3_GRUND, ZUS3_BKTYP, ZUS4_BETR, ZUS4_PEIN, ZUS4_MEIN, ZUS4_GRUND, ZUS4_BKTYP, ZUS5_BETR, ZUS5_GRUND, ZUS5_BKTYP, ZUSE_BETR, ZUSE_GRUND, ZUSE_BKTYP, FPRG_BETR, FPRG_PEIN, FPRG_MEIN, FPRG_GRUND, FPRG_BKTYP, FPR1_BETR, FPR1_GRUND, FPR1_BKTYP, XRABZU, WAER_IPZA, XUZUO_LOE, WAERG, FAKSPP, XSEPFKKOPF, ZTERM, VALDT, VALTG, PERFK, FAKDATUM, VORAUSKNZ, VORAUSRCH, XRECHN, XKFMAEND, KONDA, XORTSPREIS, KALKS, KUKARR_K, KARENZ, KARENZ_ME, KDGRP, KURST, PLTYP, ZLSCH, AE, TAXM1, TAXM2, TAXM3, TAXM4, TAXM5, TAXM6, TAXM7, TAXM8, TAXM9, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, XAB_AUS, ACT_ABSCHL, ABSCHL_NR, ABSCHL_POS, XRABATT, XMITZRAB, XBONUS, XMITZBON, XMANUELL, AB_RABATT, AB_PREIS, AKTBONUS, ACT_ABSCH2, ABSCHL_NR2, ABSCHL_PO2, XRABATT2, XMITZRAB2, XBONUS2, XMITZBON2, XMANUELL2, AB_RABATT2, AB_PREIS2, AKTBONUS2, ACT_ABSCH3, ABSCHL_NR3, ABSCHL_PO3, XRABATT3, XMITZRAB3, XBONUS3, XMITZBON3, XMANUELL3, AB_RABATT3, AB_PREIS3, AKTBONUS3, PREIS_OM, PREIS_IM, PREIS_AVM1, PREIS_AVM2, MWST_BETR, XPREISAEND, SKTOF, NETWFP, MWSBFP, BER_TERMIN, BER_TERMIN_BIS, BER_HEFT, TERM_TYP, VAVARTYP, OFFSET_FAK, OFFSET_VZ, XKARENZ, PRSDT, STRUK_HTYP, STRUK_HVAR, PREIS_HTYP, PREIS_HVAR, IHKOMP, SEITE_FSP, SEITE_FORM, SMM_SFSP, SFSP_ABR, SMM_ABR, FACT_ABR, WERBK_TYP, WERBK_KNZ, ABS_MAL, AZART_AREA, BREITE, BREITE_EH, HOEHE, HOEHE_EH, ZUS_MENGE, ZUS_BERECH, MGLME, LAGME, AZART_GEST, AZART_FORM, AZART_FARB, AZART_SOND, FKART, KALSM, DRERZ, PVA, BLGMENGE, DISPMENGE, VRTMENGE, BERMENGE, POSTMENGE, SI_TYP, SIGEWICHT, SIGEW_ME, SI_GEWKL, SI_SEITEN, SI_SEKL, WS_TIMESLC, WS_BLOCK, WS_STELLE, XUNITERROR, XAEPROV, ZW_GRABRNR, JAEPRBASIS, ANZ_ANFS, ANZ_WNFS, XFAKT_EE, XPROVMIN1, XPROVALL, XUVVZ, XERL_EE, XABS_EE, XPREIS_EE, XCCAUTNOTW, XCMP_FAILED, MERKMAL0, MERKMAL1, MERKMAL2, MERKMAL3, MERKMAL4, MERKMAL5, MERKMAL6, MERKMAL7, MERKMAL8, MERKMAL9, XSTORNIERT, STORNOGRND, REF_VBELN, REF_POSNR, XFCNCL, STAFO, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, CMPRE_FLT, FORMAT_ONL, RRREL, RRSTA, PACKAGE_ID, PK_REF_AVM_NR, PK_REF_POS_NR, PK_ELEMENT_ID, PK_PSTYV, PREIS_AVM3, PREIS_AVM4, PREIS_AVM5, PREIS_AVM6, PREIS_AVM7, PREIS_AVM8, XPK_PREIS_EE, X_SL_CONTCOMP_CH, MIN_MAX_AD_SIZE FROM JHAGA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AVM_NRIS-M/AM: Sales Document Numbernvarchar100CHAR(N' ')NoJHAKAVM_NR Allow NULL? 
3POS_NRIS-M: Order Item Numbernvarchar30NUMC(N'000')NoJHAPPOS_NR Allow NULL? 
4GRUPPABRNRIS-M/AM: Billing Datasetnvarchar30NUMC(N'000')NoGRUPPABRNR Allow NULL? 
5BELEGEINHIS-M: Basic Booking Unitnvarchar100CHAR(N' ')YesJJTBEBE_BASIS Allow NULL? 
6UR_BELEINHIS-M: Initial Booking Unit for the OPM Itemnvarchar100CHAR(N' ')YesJJTBEUR_BELEINH Allow NULL? 
7INSERENTIS-M: Advertisernvarchar100CHAR(N' ')YesJHAISZINSERENT Allow NULL? 
8REGULIERERIS-M: Payer Business Partnernvarchar100CHAR(N' ')NoJGTGPNRGPNR_RG Allow NULL? 
9GPNR_RECHIS-M: Business Partner - Bill-To Partynvarchar100CHAR(N' ')NoJGTGPNRGPNR_RECH Allow NULL? 
10MOTIVIS-M: Ad Spec Number (Ad)nvarchar60NUMC(N'000000')YesJHAMOTMOTIV_NR Allow NULL? 
11GFMANUAENDIS-M: Billing Dataset Changed Manuallychar10CHAR(N' ')YesGFMANUAEND Allow NULL? 
12GF_STATUSIS-M: Billing Dataset Statusnvarchar20CHAR(N' ')YesGF_STATUS Allow NULL? 
13PSTYVIS-M: Item Category for Sales Documentnvarchar40CHAR(N' ')YesTJHAPPSTYV_PAM Allow NULL? 
14AB_BRUTTOIS-M: Contract Grossdecimal152CURR((0))YesAB_BRUTTO
15KB_BRUTTOIS-M: Contract Grossdecimal152CURR((0))YesAB_BRUTTO
16AB_BR_WAEHIS-M: Gross Contract Currencynvarchar50CUKY(N' ')YesTCURCAB_BR_WAEH Allow NULL? 
17RAB1_BETRIS-M/AM: Percentage discountdecimal73DEC((0))YesJRABPROZ
18RAB1_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
19RAB1_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
20RAB2_BETRIS-M/AM: Percentage discountdecimal73DEC((0))YesJRABPROZ
21RAB2_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
22RAB2_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
23RAB3_BETRIS-M/AM: Percentage discountdecimal73DEC((0))YesJRABPROZ
24RAB3_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
25RAB3_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
26RAB4_BETRIS-M/AM: Quantity-dependent discountdecimal112CURR((0))YesJRABMEIN
27RAB4_PEINIS-M: Price Unit (Surcharge Discount, Basic Price)decimal50DEC((0))YesPAMPEIN
28RAB4_MEINIS-M: Unit of Measure (Discount, Surcharge, Basic Price)nvarchar30UNIT(N' ')Yes*PAMMEIN Allow NULL? 
29RAB4_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
30RAB4_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
31RAB5_BETRIS-M/AM: Amount discountdecimal112CURR((0))YesJRABBETR
32RAB5_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
33RAB5_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
34RABE_BETRIS-M/AM: Amount discountdecimal112CURR((0))YesJRABBETR
35RABE_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
36RABE_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
37ZUS1_BETRIS-M/AM: Percentage Surchargedecimal73DEC((0))YesJZUSPROZ
38ZUS1_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
39ZUS1_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
40ZUS2_BETRIS-M/AM: Percentage Surchargedecimal73DEC((0))YesJZUSPROZ
41ZUS2_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
42ZUS2_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
43ZUS3_BETRIS-M/AM: Percentage Surchargedecimal73DEC((0))YesJZUSPROZ
44ZUS3_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
45ZUS3_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
46ZUS4_BETRIS-M/AM: Quantity-dependent surchargedecimal112CURR((0))YesJZUSMEIN
47ZUS4_PEINIS-M: Price Unit (Surcharge Discount, Basic Price)decimal50DEC((0))YesPAMPEIN
48ZUS4_MEINIS-M: Unit of Measure (Discount, Surcharge, Basic Price)nvarchar30UNIT(N' ')Yes*PAMMEIN Allow NULL? 
49ZUS4_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
50ZUS4_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
51ZUS5_BETRIS-M/AM: Amount Surchargedecimal112CURR((0))YesJZUSBETR
52ZUS5_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
53ZUS5_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
54ZUSE_BETRIS-M/AM: Amount Surchargedecimal112CURR((0))YesJZUSBETR
55ZUSE_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
56ZUSE_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
57FPRG_BETRIS-M/AM: Basic Pricedecimal112CURR((0))YesJGPRBETR
58FPRG_PEINIS-M: Price Unit (Surcharge Discount, Basic Price)decimal50DEC((0))YesPAMPEIN
59FPRG_MEINIS-M: Unit of Measure (Discount, Surcharge, Basic Price)nvarchar30UNIT(N' ')Yes*PAMMEIN Allow NULL? 
60FPRG_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
61FPRG_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
62FPR1_BETRIS-M/AM: Agreed pricedecimal112CURR((0))YesJVPRBETR
63FPR1_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
64FPR1_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
65XRABZUIS-M: Discount/Surcharge Exists Indicatorchar10CHAR(N' ')YesXRABZU Allow NULL? 
66WAER_IPZASD Document Currencynvarchar50CUKY(N' ')Yes*WAERK Allow NULL? 
67XUZUO_LOECheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
68WAERGSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
69FAKSPPIS-M: Billing Blocknvarchar20CHAR(N' ')YesTVFSPAM_FAKSP Allow NULL? 
70XSEPFKKOPFSeparate billing document for sales orderchar10CHAR(N' ')YesXSEPFKKOPF Allow NULL? 
71ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
72VALDTFixed value datenvarchar80DATS(N'00000000')YesVALDT Allow NULL? 
73VALTGAdditional value daysnvarchar20NUMC(N'00')YesVALTG Allow NULL? 
74PERFKInvoice dates (calendar identification)nvarchar20CHAR(N' ')YesTFACDPERFK Allow NULL? 
75FAKDATUMIS-M: Planned Billing/Settlement Datenvarchar80DATS(N'00000000')YesJHFKTER Allow NULL? 
76VORAUSKNZIS-M: Indicates Whether Advance Billing Requiredchar10CHAR(N' ')YesVORAUSKNZ Allow NULL? 
77VORAUSRCHIS-M: "Advance billing required" indicatorchar10CHAR(N' ')YesVORAUSRCH Allow NULL? 
78XRECHNIS-M: Invoice Requested Indicatorchar10CHAR(N' ')YesXRECHN Allow NULL? 
79XKFMAENDIS-M: Business Data was Changed Manually Indicatorchar10CHAR(N' ')YesXKFMAEND Allow NULL? 
80KONDAPrice group (customer)nvarchar20CHAR(N' ')YesT188KONDA Allow NULL? 
81XORTSPREISIS-M/AM: Local Customer Indicatorchar10CHAR(N' ')YesXORTSPREIS Allow NULL? 
82KALKSPricing procedure assigned to this customerchar10CHAR(N' ')YesTVKDKALKS Allow NULL? 
83KUKARR_KIS-M: Customer Profilenvarchar20CHAR(N' ')YesTJJ95JKUKARR Allow NULL? 
84KARENZIS-M: Grace Period for Price Changesnvarchar40NUMC(N'0000')YesJKARENZ Allow NULL? 
85KARENZ_MEBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
86KDGRPCustomer groupnvarchar20CHAR(N' ')YesT151KDGRP Allow NULL? 
87KURSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
88PLTYPPrice list typenvarchar20CHAR(N' ')YesT189PLTYP Allow NULL? 
89ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZSCHZW_BSEG Allow NULL? 
90AEIS-M: Agency Commission Entitlementchar10CHAR(N' ')YesAGEN_AE Allow NULL? 
91TAXM1Tax classification materialchar10CHAR(N' ')Yes*TAXM1 Allow NULL? 
92TAXM2Tax classification 2 for materialchar10CHAR(N' ')Yes*TAXM2 Allow NULL? 
93TAXM3Tax classification 3 for materialchar10CHAR(N' ')Yes*TAXM3 Allow NULL? 
94TAXM4Tax Classification 4 Materialchar10CHAR(N' ')Yes*TAXM4 Allow NULL? 
95TAXM5Tax classification 5 for materialchar10CHAR(N' ')Yes*TAXM5 Allow NULL? 
96TAXM6Tax classification 6 for materialchar10CHAR(N' ')Yes*TAXM6 Allow NULL? 
97TAXM7Tax classification 7 for materialchar10CHAR(N' ')Yes*TAXM7 Allow NULL? 
98TAXM8Tax Classification 8 Materialchar10CHAR(N' ')Yes*TAXM8 Allow NULL? 
99TAXM9Tax Classification 9 Materialchar10CHAR(N' ')Yes*TAXM9 Allow NULL? 
100ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
101ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
102ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
103AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
104AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
105AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
106XAB_AUSIS-M: Contract Exclusion Requirement Applies Yes/Nochar10CHAR(N' ')YesXAB_AUS Allow NULL? 
107ACT_ABSCHLIS-M: Contract Numbernvarchar60NUMC(N'000000')YesJHTVKOABS_VTNR Allow NULL? 
108ABSCHL_NRIS-M: Contract Numbernvarchar60NUMC(N'000000')YesJHTVABRUFABS_VTNR Allow NULL? 
109ABSCHL_POSIS-M: Contract, Item Numbernvarchar40NUMC(N'0000')YesJHTVABRUFABS_POSNR Allow NULL? 
110XRABATTIS-M: Assignment Qualifies for Discountchar10CHAR(N' ')YesXRABATT Allow NULL? 
111XMITZRABIS-M: Assignment Counts Towards Discount Fulfillmentchar10CHAR(N' ')YesXMITZRAB Allow NULL? 
112XBONUSIS-M: Assignment Qualifies for Bonuschar10CHAR(N' ')YesXBONUS Allow NULL? 
113XMITZBONIS-M: Assignment Counts Towards Bonus Fulfillmentchar10CHAR(N' ')YesXMITZBON Allow NULL? 
114XMANUELLIS-M: Contract Assignments Changed Manually Indicatorchar10CHAR(N' ')YesXMANUELL1 Allow NULL? 
115AB_RABATTIS-M: Current Valid Contract Discount Ratedecimal52DEC((0))YesAB_RABATT
116AB_PREISIS-M: Current Valid Price from Contractdecimal152CURR((0))YesAB_PREIS
117AKTBONUSIS-M/AM: Current Valid Contract Bonusdecimal52DEC((0))YesAKTBONUS
118ACT_ABSCH2IS-M: Contract Numbernvarchar60NUMC(N'000000')YesJHTVKOABS_VTNR Allow NULL? 
119ABSCHL_NR2IS-M: Contract Numbernvarchar60NUMC(N'000000')YesJHTVABRUFABS_VTNR Allow NULL? 
120ABSCHL_PO2IS-M: Contract, Item Numbernvarchar40NUMC(N'0000')YesJHTVABRUFABS_POSNR Allow NULL? 
121XRABATT2IS-M: Assignment Qualifies for Discountchar10CHAR(N' ')YesXRABATT Allow NULL? 
122XMITZRAB2IS-M: Assignment Counts Towards Discount Fulfillmentchar10CHAR(N' ')YesXMITZRAB Allow NULL? 
123XBONUS2IS-M: Assignment Qualifies for Bonuschar10CHAR(N' ')YesXBONUS Allow NULL? 
124XMITZBON2IS-M: Assignment Counts Towards Bonus Fulfillmentchar10CHAR(N' ')YesXMITZBON Allow NULL? 
125XMANUELL2IS-M: Manual post-editing has taken placechar10CHAR(N' ')YesXMANUELL Allow NULL? 
126AB_RABATT2IS-M: Current Valid Contract Discount Ratedecimal52DEC((0))YesAB_RABATT
127AB_PREIS2IS-M: Current Valid Price from Contractdecimal152CURR((0))YesAB_PREIS
128AKTBONUS2IS-M/AM: Current Valid Contract Bonusdecimal52DEC((0))YesAKTBONUS
129ACT_ABSCH3IS-M: Contract Numbernvarchar60NUMC(N'000000')YesJHTVKOABS_VTNR Allow NULL? 
130ABSCHL_NR3IS-M: Contract Numbernvarchar60NUMC(N'000000')YesJHTVABRUFABS_VTNR Allow NULL? 
131ABSCHL_PO3IS-M: Contract, Item Numbernvarchar40NUMC(N'0000')YesJHTVABRUFABS_POSNR Allow NULL? 
132XRABATT3IS-M: Assignment Qualifies for Discountchar10CHAR(N' ')YesXRABATT Allow NULL? 
133XMITZRAB3IS-M: Assignment Counts Towards Discount Fulfillmentchar10CHAR(N' ')YesXMITZRAB Allow NULL? 
134XBONUS3IS-M: Assignment Qualifies for Bonuschar10CHAR(N' ')YesXBONUS Allow NULL? 
135XMITZBON3IS-M: Assignment Counts Towards Bonus Fulfillmentchar10CHAR(N' ')YesXMITZBON Allow NULL? 
136XMANUELL3IS-M: Manual post-editing has taken placechar10CHAR(N' ')YesXMANUELL Allow NULL? 
137AB_RABATT3IS-M: Current Valid Contract Discount Ratedecimal52DEC((0))YesAB_RABATT
138AB_PREIS3IS-M: Current Valid Price from Contractdecimal152CURR((0))YesAB_PREIS
139AKTBONUS3IS-M/AM: Current Valid Contract Bonusdecimal52DEC((0))YesAKTBONUS
140PREIS_OMIS-M: Price excluding VATdecimal152CURR((0))YesPREIS_OM
141PREIS_IMIS-M: Price including VATdecimal152CURR((0))YesPREIS_IM
142PREIS_AVM1IS-M: Price Field 1 in the Orderdecimal152CURR((0))YesPREIS_AVM1
143PREIS_AVM2IS-M: Price Field 2 in the Orderdecimal152CURR((0))YesPREIS_AVM2
144MWST_BETRIS-M: Value-Added Tax Amountdecimal132CURR((0))YesGRMWSTBETR
145XPREISAENDIS-M: Price Was Changed Indicatorchar10CHAR(N' ')YesXPREISAEND Allow NULL? 
146SKTOFCash discount indicatorchar10CHAR(N' ')YesSKTOF Allow NULL? 
147NETWFPNet value of the billing item in document currencydecimal152CURR((0))YesNETWR_FP
148MWSBFPIS-M: Tax Amount for Billing Item in Document Currencydecimal132CURR((0))YesMWSBFP
149BER_TERMINIS-M: Date Services were Created for Settlement Purposesnvarchar80DATS(N'00000000')YesBER_TERMIN Allow NULL? 
150BER_TERMIN_BISIS-M: End Date for Service Creation in Terms of Settlementnvarchar80DATS(N'00000000')YesBER_TERMIN_BIS Allow NULL? 
151BER_HEFTIS-M: Service Creation Copy Number for Settlementnvarchar140CHAR(N' ')YesISM_BER_HEFT Allow NULL? 
152TERM_TYPIS-M/AM: Date Category Copy Number/Publication Datechar10CHAR(N' ')YesTJH55TERMINTYP Allow NULL? 
153VAVARTYPActual issue variant typenvarchar20CHAR(N' ')YesTJD05VAVARTYPTA Allow NULL? 
154OFFSET_FAKIS-M: Offset in days for billing datenvarchar20NUMC(N'00')YesOFFSET_FAK Allow NULL? 
155OFFSET_VZIS-M: Billing offset signchar10CHAR(N' ')YesOFFSET_VZ Allow NULL? 
156XKARENZIS-M: Use Grace Period Yes / Nochar10CHAR(N' ')YesXKARENZ Allow NULL? 
157PRSDTDate for pricing and exchange ratenvarchar80DATS(N'00000000')YesPRSDT Allow NULL? 
158STRUK_HTYPIS-M: Content Component Hierarchy Typenvarchar20CHAR(N' ')YesTJJ51IKO_HIETYP Allow NULL? 
159STRUK_HVARIS-M: Content Component Structural Hierarchy Variantnvarchar60CHAR(N' ')YesTJJ55STRUK_HVAR Allow NULL? 
160PREIS_HTYPIS-M: Content Component Hierarchy Typenvarchar20CHAR(N' ')YesTJJ51IKO_HIETYP Allow NULL? 
161PREIS_HVARIS-M: Content Component Hierarchy Variant for Pricingnvarchar60CHAR(N' ')YesTJJ55PREIS_HVAR Allow NULL? 
162IHKOMPIS-M: Content component from price hierarchynvarchar80CHAR(N' ')YesJJTIKOINHK_PRICE Allow NULL? 
163SEITE_FSPIS-M: Page/column formatnvarchar40CHAR(N' ')YesTJJ47SEITE_FSP Allow NULL? 
164SEITE_FORMIS-M: Page Formatnvarchar20CHAR(N' ')YesTJJ01SEITE_FORM Allow NULL? 
165SMM_SFSPIS-M: Size in column mmdecimal133DEC((0))YesMENGE_SMM
166SFSP_ABRIS-M: Column Format for Settlementnvarchar40CHAR(N' ')YesTJJ47SFSP_ABR Allow NULL? 
167SMM_ABRIS-M: Size in column mmdecimal133DEC((0))YesMENGE_SMM
168FACT_ABRIS-M: Conversion Factor for Settlementdecimal43DEC((0))YesFACT_ABR
169WERBK_TYPIS-M: Advertising Combination Typenvarchar20CHAR(N' ')YesTJH91WERBK_TYP Allow NULL? 
170WERBK_KNZIS-M: Combination Sale Indicatornvarchar40NUMC(N'0000')NoWERBK_KNZ Allow NULL? 
171ABS_MALIS-M: Number for Contract Standingdecimal50DEC((0))NoJHRSMAL
172AZART_AREAIS-M/AM: Fixed Format Proposal /Ad Dimensionsnvarchar40CHAR(N' ')YesTJJ13AZART_AREA Allow NULL? 
173BREITEIS-M: Ad Spec Width for Settlementdecimal73QUAN((0))YesBREITE_VER
174BREITE_EHIS-M/AM: Unit of Measure for Widthnvarchar30UNIT(N' ')YesTJH57BREITE_SEH Allow NULL? 
175HOEHEIS-M: Clearable Height for Ad Specdecimal73QUAN((0))YesHOEHE_VER
176HOEHE_EHIS-M: Unit of Measure for Heightnvarchar30UNIT(N' ')YesTJH61ISPEINH_H Allow NULL? 
177ZUS_MENGEIS-M: Number of Additional Ad Spec Calculation Unitsdecimal73QUAN((0))YesBER_MENGE
178ZUS_BERECHIS-M: Additional Unit of Measure for Settlementnvarchar30UNIT(N' ')YesTJH57MEINH_ZUS Allow NULL? 
179MGLMEQuantitydecimal133QUAN((0))YesMENGE_D
180LAGMEBase Unit of Measurenvarchar30UNIT(N' ')YesT006LAGME Allow NULL? 
181AZART_GESTIS-M: Design Ad Typenvarchar40CHAR(N' ')YesTJJ19AZART_GEST Allow NULL? 
182AZART_FORMIS-M: Shape Ad Typenvarchar40CHAR(N' ')YesTJJ17AZART_FORM Allow NULL? 
183AZART_FARBIS-M: Color Scheme Ad Typenvarchar40CHAR(N' ')YesTJJ11AZART_FARB Allow NULL? 
184AZART_SONDIS-M: Ad Type - Special Handling Typenvarchar20CHAR(N' ')YesTJJ49AZART_SOND Allow NULL? 
185FKARTIS-M/AM: Billing/Settlement Document Typenvarchar40CHAR(N' ')YesTJH05FKART_PAM Allow NULL? 
186KALSMSales and Distribution: Pricing Procedure in Pricingnvarchar60CHAR(N' ')Yes*KALSMASD Allow NULL? 
187DRERZPublicationnvarchar80CHAR(N' ')YesJDTDRERDRERZ Allow NULL? 
188PVAEditionnvarchar80CHAR(N' ')YesJDTPVAPVA Allow NULL? 
189BLGMENGEIS-M: Order Quantity for Insertiondecimal90DEC((0))YesBLGMENGE
190DISPMENGEIS-M: Planning Quantity of Carrying Issuedecimal90DEC((0))YesDISPMENGE
191VRTMENGEIS-M/AM: Actual Quantity for Distributiondecimal90DEC((0))NoVRTMGI_PAM
192BERMENGEIS-M: Calculation Quantity (Ad Insert)decimal90DEC((0))YesBERMENGE
193POSTMENGEIS-M: Postal Circulation Quantitydecimal90DEC((0))NoPOSTMENGE
194SI_TYPIS-M: Ad Insert Typenvarchar20CHAR(N' ')NoTJH29SITYP Allow NULL? 
195SIGEWICHTActual Issue Weightdecimal93QUAN((0))NoVAGEWIST
196SIGEW_MEUnit of weight for actual issue weightnvarchar30UNIT(N' ')NoT006MEINHVAGEI Allow NULL? 
197SI_GEWKLIS-M: Ad inserts weight price groupnvarchar40CHAR(N' ')NoTJHGEWKLISM_SI_GEWKL Allow NULL? 
198SI_SEITENNumber of Pages in Issuenvarchar80NUMC(N'00000000')NoANZSEITEN Allow NULL? 
199SI_SEKLIS-M: Price Group for Ad Insert Pagesnvarchar40CHAR(N' ')NoTJHSEKLISM_SI_SEKL Allow NULL? 
200WS_TIMESLCIS-M: Commercial Time Slicenvarchar20CHAR(N' ')YesTJJW1WS_TIMESLC Allow NULL? 
201WS_BLOCKIS-M: Commercial Clusternvarchar20CHAR(N' ')YesTJJW3WS_BLOCK Allow NULL? 
202WS_STELLEIS-M: Position (Sequence) Within a Commercial Clusternvarchar30NUMC(N'000')YesWS_STELLE Allow NULL? 
203XUNITERRORIS-M: Quantity Conversion Error Indicatorchar10CHAR(N' ')YesXUNITERROR Allow NULL? 
204XAEPROVIS-M: Agency Commission Credit Memo Indicatorchar10CHAR(N' ')YesXAEPROV Allow NULL? 
205ZW_GRABRNRIS-M: Twinned Billing Dataset for Separate Agency Commissionnvarchar30NUMC(N'000')YesJHAGAISM_TWIN_BILLING_DATASET_NO Allow NULL? 
206JAEPRBASISIS-M: Agency commission basisdecimal132CURR((0))YesJAEPRBASIS
207ANZ_ANFSIS-M: No.of Placements Qual.for Disc.Due to Pub.in Other BUsnvarchar30NUMC(N'000')YesANZ_ANFS Allow NULL? 
208ANZ_WNFSIS-M: No.of Placements Qual.For Dis.Due to Publc.On Oth.Daysnvarchar30NUMC(N'000')YesANZ_WNFS Allow NULL? 
209XFAKT_EEIS-M: Billed Indicatorchar10CHAR(N' ')YesXFAKT_EE Allow NULL? 
210XPROVMIN1Partial Commission (At Least 1 Sales Agent Assignment Comm.)char10CHAR(N' ')YesXPROVMIN1 Allow NULL? 
211XPROVALLCommission Calculated For All Sales Agent Assignments Ind.char10CHAR(N' ')YesXPROVALL Allow NULL? 
212XUVVZIS-M: Sales Agent Assignment Incompletechar10CHAR(N' ')YesXUVVZ Allow NULL? 
213XERL_EEIS-M: Revenue Distribution Performedchar10CHAR(N' ')YesXERL_EE Allow NULL? 
214XABS_EEIS-M: Contract Final Settlement Performedchar10CHAR(N' ')YesXABS_EE Allow NULL? 
215XPREIS_EEIS-M: Pricing completedchar10CHAR(N' ')YesXPREIS_EE Allow NULL? 
216XCCAUTNOTWIS-M/AM: Payment card authorization requiredchar10CHAR(N' ')NoXCCAUTNOTW Allow NULL? 
217XCMP_FAILEDIS-M/AM: Credit check failedchar10CHAR(N' ')NoXCMP_FAILED Allow NULL? 
218MERKMAL0IS-M: Characteristic 9 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK0_GA Allow NULL? 
219MERKMAL1IS-M: Characteristic 1 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK1_GA Allow NULL? 
220MERKMAL2IS-M: Characteristic 2 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK2_GA Allow NULL? 
221MERKMAL3IS-M: Characteristic 3 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK3_GA Allow NULL? 
222MERKMAL4IS-M: Characteristic 4 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK4_GA Allow NULL? 
223MERKMAL5IS-M: Characteristic 5 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK5_GA Allow NULL? 
224MERKMAL6IS-M: Characteristic 6 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK6_GA Allow NULL? 
225MERKMAL7IS-M: Characteristic 7 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK7_GA Allow NULL? 
226MERKMAL8IS-M: Characteristic 8 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK8_GA Allow NULL? 
227MERKMAL9IS-M: Characteristic 9 for Individual Use (Billing Dataset)char10CHAR(N' ')YesMERK9_GA Allow NULL? 
228XSTORNIERTIS-M: Canceled Order Object Indicatorchar10CHAR(N' ')YesXSTORNIERT Allow NULL? 
229STORNOGRNDIS-M: Cancellation Reasonnvarchar30CHAR(N' ')YesTJHSTOGSTOGRD_PAM Allow NULL? 
230REF_VBELNIS-M/AM: Billing Documentnvarchar100CHAR(N' ')YesJHTFKJJBELNR Allow NULL? 
231REF_POSNRIS-M/AM: Item (number) in settlement documentnvarchar60NUMC(N'000000')YesJHTFPJJPOSNR Allow NULL? 
232XFCNCLIS-M/AM: Reversal Indicator for Billing Itemchar10CHAR(N' ')NoJH_XCNCL Allow NULL? 
233STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')YesTMCBSTAFO Allow NULL? 
234KZWI1Subtotal 1 from pricing procedure for conditiondecimal132CURR((0))YesKZWI1
235KZWI2Subtotal 2 from pricing procedure for conditiondecimal132CURR((0))YesKZWI2
236KZWI3Subtotal 3 from pricing procedure for conditiondecimal132CURR((0))YesKZWI3
237KZWI4Subtotal 4 from pricing procedure for conditiondecimal132CURR((0))YesKZWI4
238KZWI5Subtotal 5 from pricing procedure for conditiondecimal132CURR((0))YesKZWI5
239KZWI6Subtotal 6 from pricing procedure for conditiondecimal132CURR((0))YesKZWI6
240CMPRE_FLTItem credit pricefloat1516FLTP((0))NoCMPRE_FLT
241FORMAT_ONLIS-M/AM: Format Proposal (Online)nvarchar40CHAR(N' ')No*FORMAT_ONL Allow NULL? 
242RRRELIS-M/AM: Revenue Recognition Categorychar10CHAR(N' ')YesISMRR_RELTYP Allow NULL? 
243RRSTAchar10(N' ')Yes Allow NULL? 
244PACKAGE_IDPackagenvarchar100CHAR(N' ')YesJJTPCISM_PACKAGE_ID Allow NULL? 
245PK_REF_AVM_NROrder Number for Package Reference Ordernvarchar100CHAR(N' ')Yes*ISM_PK_REF_AVM_NR Allow NULL? 
246PK_REF_POS_NRItem Number of Package Item to be Referencednvarchar30NUMC(N'000')Yes*ISM_PK_REF_POS_NR Allow NULL? 
247PK_ELEMENT_IDPackage Element IDnvarchar30NUMC(N'000')Yes*ISM_PK_ELEMENT_ID Allow NULL? 
248PK_PSTYVPackage Item Categorynvarchar40CHAR(N' ')YesTJHAPISM_PK_PSTVY Allow NULL? 
249PREIS_AVM3IS-M: Price Field 3 in the Orderdecimal152CURR((0))YesISM_PREIS_AVM3
250PREIS_AVM4IS-M: Price Field 4 in the Orderdecimal152CURR((0))YesISM_PREIS_AVM4
251PREIS_AVM5IS-M: Price Field 5 in the Orderdecimal152CURR((0))YesISM_PREIS_AVM5
252PREIS_AVM6IS-M: Price Field 6 in the Orderdecimal152CURR((0))YesISM_PREIS_AVM6
253PREIS_AVM7IS-M: Price Field 7 in the Orderdecimal152CURR((0))YesISM_PREIS_AVM7
254PREIS_AVM8IS-M: Price Field 8 in the Orderdecimal152CURR((0))YesISM_PREIS_AVM8
255XPK_PREIS_EEPackage Pricing Performedchar10CHAR(N' ')YesISM_XPK_PREIS_EE Allow NULL? 
256X_SL_CONTCOMP_CHPublication Change: Content Component for Sched.Line Changedchar10CHAR(N' ')YesISM_PUB_CHAN_SL_CONTCOMP_CHNGD Allow NULL? 
257MIN_MAX_AD_SIZEMin Max Ad Sizedecimal133QUAN((0))Yes/NAM/MIN_MAX_AD_SIZE
NamePrimaryUniqueTypeColumns
JHAGA~0YesYesCLUSTEREDGRUPPABRNR, POS_NR, AVM_NR, MANDT
JHAGA~INSNoNoNONCLUSTEREDINSERENT, MANDT
JHAGA~REGNoNoNONCLUSTEREDREGULIERER, MANDT