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
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.0JHAREV11021IS-M/AM: Order Revenue Recognition Key Date ValuesAdvertising Management
SQL:  selectupdate insert create

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

SELECT MANDT, COUNT_JHFREV1, EOBPO, EVBWTYP, EVBWKEY, BW_STICHTAG, KWERT_EV, SAKN1_EV, SAKN2_EV, KTOPL, REF_BELID, REF_POSID, REF_BELTYP, REF_WAERS, UVEVB, EVOBJ, PFOBJ, BDJPOPER, AUFNR, KOSTL, PAOBJNR, KOKRS, PERIV, STORNO_KZ, AVM_NR, GPAG, POS_ART, UR_BELEINH, BELEGEINH, VKORG, VTWEG, SPART, VKBUR, REGULIERER, INSERENT, XFAKT_EE, BER_TERMIN, VBTYP, AUART, AUGRU, VKGRP, GSBER, AVM_HRKNFT, VERMITTLER, POS_NR, BRAN_PAM, KAMPAGNE, INHK_TECH1, INHK_TLEV1, INHK_TECH2, INHK_KFM, AZART_PLAZ, KONKAUS, PRODH, SI_TYP, MATNR, DIENTYP, DIEN_BE, DIEN_IKO, XTECH_MIN1, XTECH_EE, GPNR_RECH, PSTYV, BER_HEFT, VAVARTYP, IHKOMP, SEITE_FSP, SEITE_FORM, SFSP_ABR, WERBK_TYP, AZART_GEST, AZART_FORM, AZART_FARB, AZART_SOND, XSTORNIERT, STORNOGRND, INHK_KLEV1, BNAME, GRUPPABRNR, BOOK_OL, SELDAT_VON, SELDAT_BIS, WERBK_KNZ, WS_TIMESLC, WS_BLOCK, WS_STELLE, FORMAT_ONL, XAEPROV, IKO_STAT, BEGRP_STAT, TERM_TYP, STGVB_PAM, ERFDATE, AENDATE, CAMPAIGN, CAMPAIGN_PSP, REF_VBELN, REF_POSNR, RRREL, PACKAGE_ID, PK_REF_AVM_NR, PK_REF_POS_NR FROM JHAREV1
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2COUNT_JHFREV1IS-M/AM: Counter for Order Key Date Logicnvarchar180NUMC(N'000000000000000000')NoCOUNT_JHFREV1 Allow NULL? 
3EOBPOIS-M/AM: Revenue Object Document Itemnvarchar60NUMC(N'000000')Yes*EOBPO Allow NULL? 
4EVBWTYPIS-M/AM: Valuation Category in Revenue Distributionchar10CHAR(N' ')Yes*EVBWTYP Allow NULL? 
5EVBWKEYIS-M/AM: Variable Valuation Key for Revenue Distributionnvarchar200CHAR(N' ')YesEVBWKEY Allow NULL? 
6BW_STICHTAGIS-M/AM: Key Date For BW Key Date Logicnvarchar80DATS(N'00000000')YesBW_STICHTAG Allow NULL? 
7KWERT_EVIS-M/AM: Condition Value in Revenue Distributiondecimal152CURR((0))YesEVKWERT_EV
8SAKN1_EVIS-M: Actual P&L Accountnvarchar100CHAR(N' ')Yes*ISM_SAKN2 Allow NULL? 
9SAKN2_EVInterim Account for Revenue Accrualnvarchar100CHAR(N' ')Yes*SAKN1 Allow NULL? 
10KTOPLChart of Accountsnvarchar40CHAR(N' ')YesT004KTOPL Allow NULL? 
11REF_BELIDIS-M/AM: Doc.Number of Rev.Distributed Document Objectnvarchar100CHAR(N' ')YesEOREF_BELID Allow NULL? 
12REF_POSIDIS-M: Item Number of Revenue Distributed Document Objectnvarchar60NUMC(N'000000')YesEOREF_POSID Allow NULL? 
13REF_BELTYPIS-M: Document Category for which Revenue Dist.is Performedchar10CHAR(N' ')Yes*EOBELTYP Allow NULL? 
14REF_WAERSSD Document Currencynvarchar50CUKY(N' ')Yes*WAERK Allow NULL? 
15UVEVBIS-M: Incompleteness Status for Revenue Object Documentchar10CHAR(N' ')Yes*JH_UVEVB Allow NULL? 
16EVOBJIS-M/AM: Revenue Objectnvarchar100CHAR(N' ')YesEVOBJ Allow NULL? 
17PFOBJIS-M/AM: Partner Objectnvarchar100CHAR(N' ')Yes*PFOBJ Allow NULL? 
18BDJPOPERIS-M: Posting Year and Posting Period Format YYYYMMM)nvarchar70NUMC(N'0000000')YesEV_BDJPOPER Allow NULL? 
19AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
20KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
21PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
22KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
23PERIVFiscal Year Variantnvarchar20CHAR(N' ')Yes*PERIV Allow NULL? 
24STORNO_KZIS-M: Reversal BW (0Recordmode)char10CHAR(N' ')YesXSTORNO_KZ Allow NULL? 
25AVM_NRIS-M/AM: Sales Document Numbernvarchar100CHAR(N' ')Yes*AVM_NR Allow NULL? 
26GPAGIS-M: Business Partner Keynvarchar100CHAR(N' ')Yes*GPNR Allow NULL? 
27POS_ARTIS-M: Order-Publishing-Media - Item Typenvarchar20CHAR(N' ')Yes*AVMPOS_ART Allow NULL? 
28UR_BELEINHIS-M: Initial Booking Unit for the OPM Itemnvarchar100CHAR(N' ')Yes*UR_BELEINH Allow NULL? 
29BELEGEINHIS-M/AM: Booking Unitnvarchar100CHAR(N' ')Yes*BELEGEINH Allow NULL? 
30VKORGSales Organizationnvarchar40CHAR(N' ')Yes*VKORG Allow NULL? 
31VTWEGDistribution Channelnvarchar20CHAR(N' ')Yes*VTWEG Allow NULL? 
32SPARTDivisionnvarchar20CHAR(N' ')Yes*SPART Allow NULL? 
33VKBURSales Officenvarchar40CHAR(N' ')Yes*VKBUR Allow NULL? 
34REGULIERERIS-M: Payernvarchar100CHAR(N' ')Yes*REGULIERER Allow NULL? 
35INSERENTIS-M: Advertisernvarchar100CHAR(N' ')Yes*INSERENT Allow NULL? 
36XFAKT_EEIS-M: Billed Indicatorchar10CHAR(N' ')YesXFAKT_EE Allow NULL? 
37BER_TERMINIS-M: Date Services were Created for Settlement Purposesnvarchar80DATS(N'00000000')YesBER_TERMIN Allow NULL? 
38VBTYPSD document categorychar10CHAR(N' ')YesVBTYP Allow NULL? 
39AUARTIS-M: Sales Document Typenvarchar40CHAR(N' ')Yes*AUART_PAM Allow NULL? 
40AUGRUOrder reason (reason for the business transaction)nvarchar30CHAR(N' ')Yes*AUGRU Allow NULL? 
41VKGRPSales Groupnvarchar30CHAR(N' ')Yes*VKGRP Allow NULL? 
42GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
43AVM_HRKNFTIS-M/AM: Order Originchar10CHAR(N' ')YesAVM_HRKNFT Allow NULL? 
44VERMITTLERIS-M: Sales Agent with ID Code for Screennvarchar100CHAR(N' ')Yes*VERMK Allow NULL? 
45POS_NRIS-M: Order Item Numbernvarchar30NUMC(N'000')Yes*POS_NR Allow NULL? 
46BRAN_PAMIS-M/AM: Current Industry Sector Associated With Order Itemnvarchar100CHAR(N' ')Yes*BRAN_POS Allow NULL? 
47KAMPAGNEIS-M: Campaign (customer)nvarchar60CHAR(N' ')Yes*KAMPAGNE Allow NULL? 
48INHK_TECH1IS-M: Technical Content Component (Positioning View)nvarchar80CHAR(N' ')Yes*INHK_TECH1 Allow NULL? 
49INHK_TLEV1IS-M: Level 1 content component in the hierarchynvarchar80CHAR(N' ')Yes*INHK_LEV1 Allow NULL? 
50INHK_TECH2IS-M: Special Publication Content Componentnvarchar80CHAR(N' ')Yes*INHK_SOVER Allow NULL? 
51INHK_KFMIS-M: Business Content Componentnvarchar80CHAR(N' ')Yes*INHK_KFM Allow NULL? 
52AZART_PLAZIS-M: Ad Type with Regard to General Positioningnvarchar40CHAR(N' ')Yes*AZART_PLAZ Allow NULL? 
53KONKAUSIS-M: Competitor exclusionnvarchar20CHAR(N' ')Yes*KONKAUS Allow NULL? 
54PRODHIS-M/AM: Product Hierarchynvarchar180CHAR(N' ')Yes*J_PRODH Allow NULL? 
55SI_TYPIS-M: Ad Insert Typenvarchar20CHAR(N' ')Yes*SITYP Allow NULL? 
56MATNRIS-M: Service material numbernvarchar180CHAR(N' ')Yes*MATNR_DIEN Allow NULL? 
57DIENTYPIS-M: Service Typenvarchar40CHAR(N' ')Yes*DIENTYP Allow NULL? 
58DIEN_BEIS-M: Service: Assigned Booking Unitnvarchar100CHAR(N' ')Yes*DIEN_BE Allow NULL? 
59DIEN_IKOIS-M: Service: Assigned Content Componentnvarchar80CHAR(N' ')Yes*DIEN_IKO Allow NULL? 
60XTECH_MIN1IS-M: Tech.process.started (for at least 1 schedule line)char10CHAR(N' ')YesXTECH_MIN1 Allow NULL? 
61XTECH_EEIS-M: Tech.Complete (All Schedule Lines Fully Processed)char10CHAR(N' ')YesXTECH_EE Allow NULL? 
62GPNR_RECHIS-M: Business Partner - Bill-To Partynvarchar100CHAR(N' ')Yes*GPNR_RECH Allow NULL? 
63PSTYVIS-M: Item Category for Sales Documentnvarchar40CHAR(N' ')Yes*PSTYV_PAM Allow NULL? 
64BER_HEFTIS-M: Service Creation Copy Number for Settlementnvarchar140CHAR(N' ')YesISM_BER_HEFT Allow NULL? 
65VAVARTYPActual issue variant typenvarchar20CHAR(N' ')Yes*VAVARTYPTA Allow NULL? 
66IHKOMPIS-M: Content component from price hierarchynvarchar80CHAR(N' ')Yes*INHK_PRICE Allow NULL? 
67SEITE_FSPIS-M: Page/column formatnvarchar40CHAR(N' ')Yes*SEITE_FSP Allow NULL? 
68SEITE_FORMIS-M: Page Formatnvarchar20CHAR(N' ')Yes*SEITE_FORM Allow NULL? 
69SFSP_ABRIS-M: Column Format for Settlementnvarchar40CHAR(N' ')Yes*SFSP_ABR Allow NULL? 
70WERBK_TYPIS-M: Advertising Combination Typenvarchar20CHAR(N' ')Yes*WERBK_TYP Allow NULL? 
71AZART_GESTIS-M: Design Ad Typenvarchar40CHAR(N' ')Yes*AZART_GEST Allow NULL? 
72AZART_FORMIS-M: Shape Ad Typenvarchar40CHAR(N' ')Yes*AZART_FORM Allow NULL? 
73AZART_FARBIS-M: Color Scheme Ad Typenvarchar40CHAR(N' ')Yes*AZART_FARB Allow NULL? 
74AZART_SONDIS-M: Ad Type - Special Handling Typenvarchar20CHAR(N' ')Yes*AZART_SOND Allow NULL? 
75XSTORNIERTIS-M: Canceled Order Object Indicatorchar10CHAR(N' ')YesXSTORNIERT Allow NULL? 
76STORNOGRNDIS-M: Cancellation Reasonnvarchar30CHAR(N' ')Yes*STOGRD_PAM Allow NULL? 
77INHK_KLEV1IS-M: Content component level 1 of hierarchy JSBWnvarchar80CHAR(N' ')Yes*JSBW_LEV1 Allow NULL? 
78BNAMEIS-M: Name of Ordering Party JSBWnvarchar320CHAR(N' ')YesJSBW_B_V Allow NULL? 
79GRUPPABRNRIS-M/AM: Billing Datasetnvarchar30NUMC(N'000')Yes*GRUPPABRNR Allow NULL? 
80BOOK_OLIS-M/AM: Booking Type for Online Advertisingnvarchar40CHAR(N' ')Yes*ISM_BOOK_OL Allow NULL? 
81SELDAT_VONIS-M: Start Date for Itemnvarchar80DATS(N'00000000')YesSELDAT_VON Allow NULL? 
82SELDAT_BISIS-M: End Date for Itemsnvarchar80DATS(N'00000000')YesSELDAT_BIS Allow NULL? 
83WERBK_KNZIS-M: Combination Sale Indicatornvarchar40NUMC(N'0000')YesWERBK_KNZ Allow NULL? 
84WS_TIMESLCIS-M: Commercial Time Slicenvarchar20CHAR(N' ')Yes*WS_TIMESLC Allow NULL? 
85WS_BLOCKIS-M: Commercial Clusternvarchar20CHAR(N' ')Yes*WS_BLOCK Allow NULL? 
86WS_STELLEIS-M: Position (Sequence) Within a Commercial Clusternvarchar30NUMC(N'000')YesWS_STELLE Allow NULL? 
87FORMAT_ONLIS-M/AM: Format Proposal (Online)nvarchar40CHAR(N' ')Yes*FORMAT_ONL Allow NULL? 
88XAEPROVIS-M: Agency Commission Credit Memo Indicatorchar10CHAR(N' ')YesXAEPROV Allow NULL? 
89IKO_STATIS-M: Statistical content componentnvarchar80CHAR(N' ')Yes*IKO_STAT Allow NULL? 
90BEGRP_STATIS-M: BU Grouping for Statisticsnvarchar40CHAR(N' ')Yes*BEGRP_STAT Allow NULL? 
91TERM_TYPIS-M/AM: Date Category Copy Number/Publication Datechar10CHAR(N' ')Yes*TERMINTYP Allow NULL? 
92STGVB_PAMIS-M: Statistics Group for Sales Documentsnvarchar20CHAR(N' ')Yes*STGVB_PAM Allow NULL? 
93ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
94AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
95CAMPAIGNIS-M: Marketing Campaignvarbinary160RAWYesISM_MARKETING_CAMPAIGN
96CAMPAIGN_PSPWork Breakdown Structure Element (WBS Element)nvarchar240CHAR(N' ')YesPS_POSID Allow NULL? 
97REF_VBELNIS-M/AM: Billing Documentnvarchar100CHAR(N' ')Yes*JJBELNR Allow NULL? 
98REF_POSNRIS-M/AM: Item (number) in settlement documentnvarchar60NUMC(N'000000')Yes*JJPOSNR Allow NULL? 
99RRRELIS-M/AM: Revenue Recognition Categorychar10CHAR(N' ')YesISMRR_RELTYP Allow NULL? 
100PACKAGE_IDPackagenvarchar100CHAR(N' ')YesJJTPCISM_PACKAGE_ID Allow NULL? 
101PK_REF_AVM_NROrder Number for Package Reference Ordernvarchar100CHAR(N' ')Yes*ISM_PK_REF_AVM_NR Allow NULL? 
102PK_REF_POS_NRItem Number of Package Item to be Referencednvarchar30NUMC(N'000')Yes*ISM_PK_REF_POS_NR Allow NULL? 
NamePrimaryUniqueTypeColumns
JHAREV1~0YesYesCLUSTEREDCOUNT_JHFREV1, MANDT