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

Home | ERP 6.0  | JHAP
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
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.0JHAP1333IS-M/AM: Order-Publishing-Media ItemAdvertising 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, POS_ART, PSTYV, VBTYP, WERBK_TYP, WERBK_KNZ, XAGENAUFTR, XEINTEILG, BRAN_PAM, STATUSK, VERMITTLER, VNR, BEDNR, PROSL, KAMPAGNE, WERBK_POS, WERBK_UPOS, WERBK_EINT, REF_AVM_NR, REF_POS_NR, SUC_AVM_NR, SUC_POS_NR, VORL_AVMNR, VORL_POSNR, CAMPAIGN, NOTIZKNZ, XRABATT, XMITZRAB, XBONUS, XMITZBON, 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, XUVFAKT, XUVGP, XUVPREIS, XUVABSCHL, XUVVZ, XUVKPV, XGENEINT, XGENGRPF, XRESERV, XRESBEST, XFAKTMIN1, XFAKTALL, XSPERR_BON, XKOMMFRGB, XNACHBEARB, XUVPK, XUVPK_ELEM, XUV_ADM_VAL, XUVPK_PREIS, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME, XSTORNIERT, STORNOGRND, XDELETED_LOGICAL, STAFO, SELDAT_VON, SELDAT_BIS, BSTNK, BSARK, BSTDK, BSTZD, IHREZ, BNAME, TELF1, TELFX, PARNR, ZUKOMM, PRDH_HERKUNFT, PRDH_PRODUKT, PACKAGE_ID, PK_REF_AVM_NR, PK_REF_POS_NR, PK_ELEMENT_ID, PK_PSTYV, PACKAGE_TYPE, PACKAGE_CATEGORY FROM JHAP
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')NoPOS_NR Allow NULL? 
4POS_ARTIS-M: Order-Publishing-Media - Item Typenvarchar20CHAR(N' ')YesTJH17AVMPOS_ART Allow NULL? 
5PSTYVIS-M: Item Category for Sales Documentnvarchar40CHAR(N' ')YesTJHAPPSTYV_PAM Allow NULL? 
6VBTYPIS-M/AM: Sales Document Categorychar10CHAR(N' ')YesISPVBTYP Allow NULL? 
7WERBK_TYPIS-M: Combination Sale Typenvarchar20CHAR(N' ')YesTJH91WKOMBI_TYP Allow NULL? 
8WERBK_KNZIS-M: Combination Sale Indicatornvarchar40NUMC(N'0000')YesWERBK_KNZ Allow NULL? 
9XAGENAUFTRIS-M: Agency order indicatorchar10CHAR(N' ')YesXAGENAUFTR Allow NULL? 
10XEINTEILGIS-M: Indicator for modification at subordinate ord. levelchar10CHAR(N' ')YesXEINTEILG Allow NULL? 
11BRAN_PAMIS-M/AM: Current Industry Sector Associated With Order Itemnvarchar100CHAR(N' ')YesTBRCBRAN_POS Allow NULL? 
12STATUSKIS-M: Statusnvarchar20CHAR(N' ')YesSTATUSK Allow NULL? 
13VERMITTLERIS-M: Sales Agent with ID Code for Screennvarchar100CHAR(N' ')Yes*VERMK Allow NULL? 
14VNRIS-M: Media Sales Agent Contract Numbernvarchar100CHAR(N' ')YesJJTVVJVMVVNR Allow NULL? 
15BEDNRIS-M: Number of Media Sales Agent Contract Requirementnvarchar60NUMC(N'000000')YesJJTVBVM_BEDNR Allow NULL? 
16PROSLIS-M/AM: Commission Key for Media Sales Agentnvarchar50CHAR(N' ')YesTJH23JPROVSCHL Allow NULL? 
17KAMPAGNEIS-M: Campaign (customer)nvarchar60CHAR(N' ')YesTJJKAMPKAMPAGNE Allow NULL? 
18WERBK_POSIS-M: Combination Sale Grouping Item Numbernvarchar30NUMC(N'000')YesJHAPWERBK_POS Allow NULL? 
19WERBK_UPOSIS-M: Combination Sale Grouping Sub-Itemnvarchar40NUMC(N'0000')YesWERBK_UPOS Allow NULL? 
20WERBK_EINTIS-M: Combination Sale Grouping for Schedule Line Numbernvarchar60NUMC(N'000000')YesJHAEWERBK_EINT Allow NULL? 
21REF_AVM_NRIS-M: Reference Order Number of Preceding Ordernvarchar100CHAR(N' ')YesJHAKREF_AVM_NR Allow NULL? 
22REF_POS_NRIS-M: Reference Item Number of Preceding Itemnvarchar30NUMC(N'000')YesJHAPREF_POS_NR Allow NULL? 
23SUC_AVM_NRIS-M: Order Number of Subsequent Documentnvarchar100CHAR(N' ')YesJHAKSUC_AVM_NR Allow NULL? 
24SUC_POS_NRIS-M: Item Number of Subsequent Itemnvarchar30NUMC(N'000')YesJHAPSUC_POS_NR Allow NULL? 
25VORL_AVMNRIS-M: Order Number of the Preceding Documentnvarchar100CHAR(N' ')YesJHAKVORL_AVMNR Allow NULL? 
26VORL_POSNRIS-M: Item number of the Preceding Itemnvarchar30NUMC(N'000')YesJHAPVORL_POSNR Allow NULL? 
27CAMPAIGNIS-M: Marketing Campaignvarbinary160RAWNoISM_MARKETING_CAMPAIGN
28NOTIZKNZIS-M: Indicates Whether Notes are Available for an OPM Objctchar10CHAR(N' ')YesNOTIZKNZ Allow NULL? 
29XRABATTIS-M: Assignment Qualifies for Discountchar10CHAR(N' ')YesXRABATT Allow NULL? 
30XMITZRABIS-M: Assignment Counts Towards Discount Fulfillmentchar10CHAR(N' ')YesXMITZRAB Allow NULL? 
31XBONUSIS-M: Assignment Qualifies for Bonuschar10CHAR(N' ')YesXBONUS Allow NULL? 
32XMITZBONIS-M: Assignment Counts Towards Bonus Fulfillmentchar10CHAR(N' ')YesXMITZBON Allow NULL? 
33RAB1_BETRIS-M/AM: Percentage discountdecimal73DEC((0))YesJRABPROZ
34RAB1_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
35RAB1_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
36RAB2_BETRIS-M/AM: Percentage discountdecimal73DEC((0))YesJRABPROZ
37RAB2_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
38RAB2_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
39RAB3_BETRIS-M/AM: Percentage discountdecimal73DEC((0))YesJRABPROZ
40RAB3_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
41RAB3_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
42RAB4_BETRIS-M/AM: Quantity-dependent discountdecimal112CURR((0))YesJRABMEIN
43RAB4_PEINIS-M: Price Unit (Surcharge Discount, Basic Price)decimal50DEC((0))YesPAMPEIN
44RAB4_MEINIS-M: Unit of Measure (Discount, Surcharge, Basic Price)nvarchar30UNIT(N' ')Yes*PAMMEIN Allow NULL? 
45RAB4_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
46RAB4_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
47RAB5_BETRIS-M/AM: Amount discountdecimal112CURR((0))YesJRABBETR
48RAB5_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
49RAB5_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
50RABE_BETRIS-M/AM: Amount discountdecimal112CURR((0))YesJRABBETR
51RABE_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
52RABE_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
53ZUS1_BETRIS-M/AM: Percentage Surchargedecimal73DEC((0))YesJZUSPROZ
54ZUS1_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
55ZUS1_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
56ZUS2_BETRIS-M/AM: Percentage Surchargedecimal73DEC((0))YesJZUSPROZ
57ZUS2_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
58ZUS2_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
59ZUS3_BETRIS-M/AM: Percentage Surchargedecimal73DEC((0))YesJZUSPROZ
60ZUS3_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
61ZUS3_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
62ZUS4_BETRIS-M/AM: Quantity-dependent surchargedecimal112CURR((0))YesJZUSMEIN
63ZUS4_PEINIS-M: Price Unit (Surcharge Discount, Basic Price)decimal50DEC((0))YesPAMPEIN
64ZUS4_MEINIS-M: Unit of Measure (Discount, Surcharge, Basic Price)nvarchar30UNIT(N' ')Yes*PAMMEIN Allow NULL? 
65ZUS4_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
66ZUS4_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
67ZUS5_BETRIS-M/AM: Amount Surchargedecimal112CURR((0))YesJZUSBETR
68ZUS5_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
69ZUS5_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
70ZUSE_BETRIS-M/AM: Amount Surchargedecimal112CURR((0))YesJZUSBETR
71ZUSE_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
72ZUSE_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
73FPRG_BETRIS-M/AM: Basic Pricedecimal112CURR((0))YesJGPRBETR
74FPRG_PEINIS-M: Price Unit (Surcharge Discount, Basic Price)decimal50DEC((0))YesPAMPEIN
75FPRG_MEINIS-M: Unit of Measure (Discount, Surcharge, Basic Price)nvarchar30UNIT(N' ')Yes*PAMMEIN Allow NULL? 
76FPRG_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
77FPRG_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
78FPR1_BETRIS-M/AM: Agreed pricedecimal112CURR((0))YesJVPRBETR
79FPR1_GRUNDIS-M: Reason for Entering Conditionsnvarchar20CHAR(N' ')YesJGRKOND Allow NULL? 
80FPR1_BKTYPIS-M: Condition Input Type in the Ordernvarchar20CHAR(N' ')YesBKTYP Allow NULL? 
81XRABZUIS-M: Discount/Surcharge Exists Indicatorchar10CHAR(N' ')YesXRABZU Allow NULL? 
82WAER_IPZASD Document Currencynvarchar50CUKY(N' ')Yes*WAERK Allow NULL? 
83XUZUO_LOECheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
84XUVFAKTIS-M: Billing is Incompletechar10CHAR(N' ')YesXUVFAKT Allow NULL? 
85XUVGPIS-M: Business Partner Is Incompletechar10CHAR(N' ')YesXUVGP Allow NULL? 
86XUVPREISIS-M: Incomplete with regard to pricingchar10CHAR(N' ')YesXUVPREIS Allow NULL? 
87XUVABSCHLIS-M: Contract Assignment is Incompletechar10CHAR(N' ')YesXUVABSCHL Allow NULL? 
88XUVVZIS-M: Sales Agent Assignment Incompletechar10CHAR(N' ')YesXUVVZ Allow NULL? 
89XUVKPVIS-M: Incomplete Manual Header/Item Sales Agent Assignmentchar10CHAR(N' ')YesXUVKPV Allow NULL? 
90XGENEINTIS-M: Schedule lines are not currentchar10CHAR(N' ')YesXGENEINT Allow NULL? 
91XGENGRPFIS-M: Billing Dataset Is Yet To Be Generatedchar10CHAR(N' ')YesXGENGRPF Allow NULL? 
92XRESERVIS-M: Reservation indicatorchar10CHAR(N' ')YesXRESERV Allow NULL? 
93XRESBESTIS-M: Reservation confirmedchar10CHAR(N' ')YesXRESBEST Allow NULL? 
94XFAKTMIN1IS-M: Partially Billed (At Least 1 Billing Dataset Billed)char10CHAR(N' ')YesXFAKTMIN1 Allow NULL? 
95XFAKTALLIS-M: Billing Performed For All Billing Datasetschar10CHAR(N' ')YesXFAKTALL Allow NULL? 
96XSPERR_BONIS-M: "Blocked for reasons of creditworthiness" indicatorchar10CHAR(N' ')YesXSPERR_BON Allow NULL? 
97XKOMMFRGBIS-M: Commercial release necessary but not performedchar10CHAR(N' ')YesXKOMMFRGB Allow NULL? 
98XNACHBEARBIS-M: Post-Editing Requiredchar10CHAR(N' ')YesXNACHBEARB Allow NULL? 
99XUVPKIncomplete with Regard to Packagechar10CHAR(N' ')YesISM_XUVPK Allow NULL? 
100XUVPK_ELEMIncomplete with Regard to Package Elementchar10CHAR(N' ')YesISM_XUVPK_ELEM Allow NULL? 
101XUV_ADM_VALIncomplete with Regard to Admissible Values (Package)char10CHAR(N' ')YesISM_XUV_ADM_VAL Allow NULL? 
102XUVPK_PREISIncomplete with Regard to Package Pricingchar10CHAR(N' ')YesISM_XUVPK_PREIS Allow NULL? 
103ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
104ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
105ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
106AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
107AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
108AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
109XSTORNIERTIS-M: Canceled Order Object Indicatorchar10CHAR(N' ')YesXSTORNIERT Allow NULL? 
110STORNOGRNDIS-M: Cancellation Reasonnvarchar30CHAR(N' ')YesTJHSTOGSTOGRD_PAM Allow NULL? 
111XDELETED_LOGICALIndicator: Order Object is Logically Deletedchar10CHAR(N' ')YesISM_XDELETED_LOGICAL Allow NULL? 
112STAFOIS-M: Update group for statistics updatenvarchar60CHAR(N' ')YesTMCBJHSTAFO Allow NULL? 
113SELDAT_VONIS-M: Start Date for Itemnvarchar80DATS(N'00000000')YesSELDAT_VON Allow NULL? 
114SELDAT_BISIS-M: End Date for Itemsnvarchar80DATS(N'00000000')YesSELDAT_BIS Allow NULL? 
115BSTNKCustomer purchase order numbernvarchar200CHAR(N' ')YesBSTNK Allow NULL? 
116BSARKCustomer purchase order typenvarchar40CHAR(N' ')YesT176BSARK Allow NULL? 
117BSTDKCustomer purchase order datenvarchar80DATS(N'00000000')YesBSTDK Allow NULL? 
118BSTZDPurchase order number supplementnvarchar40CHAR(N' ')YesBSTZD Allow NULL? 
119IHREZYour Referencenvarchar120CHAR(N' ')YesIHREZ Allow NULL? 
120BNAMEName of orderernvarchar350CHAR(N' ')YesBNAME_V Allow NULL? 
121TELF1Telephone Numbernvarchar160CHAR(N' ')YesTELF1_VP Allow NULL? 
122TELFXFax Numbernvarchar310CHAR(N' ')YesTELFX Allow NULL? 
123PARNRIS-M: Contact Personnvarchar100CHAR(N' ')Yes*ISM_CNTCT_PRSN Allow NULL? 
124ZUKOMMIS-M: Additional Communication Datanvarchar500CHAR(N' ')YesJZUKOMM Allow NULL? 
125PRDH_HERKUNFTIS-M/AM: Origin Keynvarchar20CHAR(N' ')YesISM_PRDH_HERKUNFT Allow NULL? 
126PRDH_PRODUKTIS-M/AM: Productnvarchar110CHAR(N' ')YesISM_PRDH_PROD Allow NULL? 
127PACKAGE_IDPackagenvarchar100CHAR(N' ')YesJJTPCISM_PACKAGE_ID Allow NULL? 
128PK_REF_AVM_NROrder Number for Package Reference Ordernvarchar100CHAR(N' ')Yes*ISM_PK_REF_AVM_NR Allow NULL? 
129PK_REF_POS_NRItem Number of Package Item to be Referencednvarchar30NUMC(N'000')Yes*ISM_PK_REF_POS_NR Allow NULL? 
130PK_ELEMENT_IDPackage Element IDnvarchar30NUMC(N'000')Yes*ISM_PK_ELEMENT_ID Allow NULL? 
131PK_PSTYVPackage Item Categorynvarchar40CHAR(N' ')YesTJHAPISM_PK_PSTVY Allow NULL? 
132PACKAGE_TYPEPackage Typenvarchar20NUMC(N'00')YesISM_PACKAGE_TYPE Allow NULL? 
133PACKAGE_CATEGORYPackage Categorynvarchar40CHAR(N' ')Yes*ISM_PACKAGE_CATEGORY Allow NULL? 
NamePrimaryUniqueTypeColumns
JHAP~0YesYesCLUSTEREDPOS_NR, AVM_NR, MANDT
JHAP~001NoNoNONCLUSTEREDSELDAT_VON, MANDT
JHAP~002NoNoNONCLUSTEREDSELDAT_BIS, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy