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.0TJHAP431IS-M/AM: Order-Publishing-Media: Item CategoriesAdvertising Management
SQL:  selectupdate insert create

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

SELECT MANDT, PSTYV, VBTYP, FK_REL, PR_REL, XABSCHLREL, XGE_GESCH, XERLOESREL, XPROV_REL, XVABEINTER, VASPEINTER, XNOFIND, XFORTSCHR, XPROD_REL, XPRODRELWS, XPRODRELSI, XPRODRELVT, XPRODRELOL, XDISPO_REL, XDSPREL_WS, XDSPREL_SI, XDSPREL_OL, XSIDMNG_V, XVTDMNG_V, XFAKEINTER, FASPEINTER, XMENGE_N, XBETRG_N, XMAL_N, XTEILGUTBE, PTYP_SEPAE, XUPOS_EDIT, FAKSP, SKTOF, XNOSIZE, KLIMP, CMGRA, CMPNT, XNOT_FOR_PTYP, RRREL, INS_SERIES_ACTIV, PK_PSTYV_DET, DEADLINE_RELV FROM TJHAP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PSTYVIS-M: Item Category for Sales Documentnvarchar40CHAR(N' ')NoPSTYV_PAM Allow NULL? 
3VBTYPIS-M/AM: Sales Document Categorychar10CHAR(N' ')YesISPVBTYP Allow NULL? 
4FK_RELIS-M: Relevance to Billingchar10CHAR(N' ')YesISP_FKREL Allow NULL? 
5PR_RELIS-M: Perform Pricingchar10CHAR(N' ')YesISM_PRSFD Allow NULL? 
6XABSCHLRELIS-M: Contract Relevancechar10CHAR(N' ')YesXABSCHLREL Allow NULL? 
7XGE_GESCHIS-M: Barter Deal Indicatorchar10CHAR(N' ')YesXGE_GESCH Allow NULL? 
8XERLOESRELIS-M: "Relevant for Revenue Distribution" Indicatorchar10CHAR(N' ')YesXERLOESREL Allow NULL? 
9XPROV_RELRelevant To Sales Agent Commission Assignment Indicatorchar10CHAR(N' ')YesXPROV_REL Allow NULL? 
10XVABEINTEROnly Calculate Commission Once All Schd.Lines Published Ind.char10CHAR(N' ')YesXVABEINTER Allow NULL? 
11VASPEINTERBlock Sales Agent Settlmnt, if Not All sched.Lines Publishednvarchar20CHAR(N' ')YesTVFSVASPEINTER Allow NULL? 
12XNOFINDIS-M/AM: Control Sales Agent Determination (Item Category)char10CHAR(N' ')YesJHTAPVFIND Allow NULL? 
13XFORTSCHRIS-M: Relevant for Contract Update Indicatorchar10CHAR(N' ')YesXFORTSCHR Allow NULL? 
14XPROD_RELIS-M: Ad is Relevant to Production Indicatorchar10CHAR(N' ')YesXPROD_REL Allow NULL? 
15XPRODRELWSIS-M: Relevance to production of commercial indicatorchar10CHAR(N' ')YesXPRODRELWS Allow NULL? 
16XPRODRELSIIS-M: AI Relevant to Production Indicatorchar10CHAR(N' ')YesXPRODRELSI Allow NULL? 
17XPRODRELVTIS-M/AM: Distribution item relevant to production indicatorchar10CHAR(N' ')NoXPRODRELVT Allow NULL? 
18XPRODRELOLIS-M/AM: Relevance of online item to productionchar10CHAR(N' ')NoXPRODRELOL Allow NULL? 
19XDISPO_RELIS-M: Planning-Relevant Ads Indicatorchar10CHAR(N' ')YesXDISPO_REL Allow NULL? 
20XDSPREL_WSIS-M: Commercial Planning Relevance Indicatorchar10CHAR(N' ')YesXDSPREL_WS Allow NULL? 
21XDSPREL_SIIS-M: Ad Insert Planning Relevance Indicatorchar10CHAR(N' ')YesXDSPREL_SI Allow NULL? 
22XDSPREL_OLIS-M: Online Planning Relevance Indicatorchar10CHAR(N' ')NoXDSPREL_OL Allow NULL? 
23XSIDMNG_VIS-M/AM: Leading Sign for Ad Insert Planningchar10CHAR(N' ')NoXSIDMNG_V Allow NULL? 
24XVTDMNG_VIS-M/AM: Leading Sign for Distribution Planningchar10CHAR(N' ')NoXVTDMNG_V Allow NULL? 
25XFAKEINTERIS-M: Only Billable if all Schedule Lines Publishedchar10CHAR(N' ')YesXFAKEINTER Allow NULL? 
26FASPEINTERIS-M: Billing Block if not all Schedule Lines Publishednvarchar20CHAR(N' ')YesTVFSFASPEINTER Allow NULL? 
27XMENGE_NIS-M/AM: Quantity Sign for Contract Updatechar10CHAR(N' ')YesXMENGE_N Allow NULL? 
28XBETRG_NIS-M: Value amount negatively indicatorchar10CHAR(N' ')YesXBETRG_N Allow NULL? 
29XMAL_NIS-M: Number Leading Sign for Contract Updatechar10CHAR(N' ')NoXMAL_N Allow NULL? 
30XTEILGUTBEIS-M: Partial Credit Memo For A Basic Booking Unit Indicatorchar10CHAR(N' ')NoXTEILGUTBE Allow NULL? 
31PTYP_SEPAEIS-M: Item category for separate agency commissionnvarchar40CHAR(N' ')YesTJHAPPTYP_SEPAE Allow NULL? 
32XUPOS_EDITIS-M: Sub-Items Can Be Maintained Indicatorchar10CHAR(N' ')YesXUPOS_EDIT Allow NULL? 
33FAKSPIS-M: Billing Blocknvarchar20CHAR(N' ')YesTVFSPAM_FAKSP Allow NULL? 
34SKTOFCash discount indicatorchar10CHAR(N' ')YesSKTOF Allow NULL? 
35XNOSIZEIS-M: Ad spec size is obsolete, only amount is relevant ind.char10CHAR(N' ')YesXNOSIZE Allow NULL? 
36KLIMPCheck credit limitchar10CHAR(N' ')NoKLIMP Allow NULL? 
37CMGRACredit group sales ordernvarchar20CHAR(N' ')NoT691DCMGRA Allow NULL? 
38CMPNTID: Item with active credit function / relevant for creditchar10CHAR(N' ')NoCMPNT Allow NULL? 
39XNOT_FOR_PTYPIS-M/AM: Do Not Use for Create with Item Category Indicatorchar10CHAR(N' ')NoXNOT_FOR_PTYP Allow NULL? 
40RRRELIS-M/AM: Revenue Recognition Categorychar10CHAR(N' ')NoISMRR_RELTYP Allow NULL? 
41INS_SERIES_ACTIVIS-M/AM: Series Creation Active Indicatorchar10CHAR(N' ')NoISM_INSERTION_SERIES_ACTIVE Allow NULL? 
42PK_PSTYV_DETType of Package Element Item Category Determinationchar10CHAR(N' ')YesISM_PK_PSTVY_DET Allow NULL? 
43DEADLINE_RELVRelevant for Deadlineschar10CHAR(N' ')Yes/NAM/XDEADLINE_RELEVANT Allow NULL? 
NamePrimaryUniqueTypeColumns
TJHAP~0YesYesCLUSTEREDMANDT, PSTYV