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.0TJHVBER481IS-M/AM: General Settings for Specific Sales AreasAdvertising Management
SQL:  selectupdate insert create

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

SELECT MANDT, VKORG, VTWEG, SPART, XGP_ZAHLW, TERM_TYP, PERFK_DEF, OFFSET_DEF, ISPEINH_PR, HOEHE_DEH, AZART_RECH, XIKOHI_EXP, XHIDE_SVO, XALLIKO_SV, XNOFLTR_BE, XDELCOL_GB, SI_ABRMNGE, SI_SHIPP_CHECK, VT_ABRMNGE, VT_SHIPP_CHECK, XKONKAUSAZ, XKONKAUSDI, XKONKAUSSI, XKONKAUSWS, XKONKAUSVT, XVZ_GLEICH, XVZ_PBAS, XVZ_BETRAG, BE_POPUP, CHTYPE_AVM, OFF_WVL, XAAZUL_OUT, XPRDIAL_AZ, XVALUE_CHK, BB_LADEN, XVFND_FAKT_EE, KOVAR_BLGHNW, WKTYP_BLGHNW, KOVAR_TRGANZ, WKTYP_TRGANZ, AVM_MOTHLP, BRANCHE_POPUP, BRANCHE_GRPFKT, XREKLBEARB_USR, ERSTER_WOCHENTAG, SPLIT_MSG_TYPE, XPRGRP_ADV, XSRTWD_ADSP_LEV FROM TJHVBER
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VKORGSales Organizationnvarchar40CHAR(N' ')NoTVTAVKORG Allow NULL? 
3VTWEGDistribution Channelnvarchar20CHAR(N' ')NoTVTAVTWEG Allow NULL? 
4SPARTDivisionnvarchar20CHAR(N' ')NoTVTASPART Allow NULL? 
5XGP_ZAHLWIS-M: Only Payment Methods From BP Master Data Permittedchar10CHAR(N' ')YesXGP_ZAHLW Allow NULL? 
6TERM_TYPIS-M: Default Value for Date Category in Order Itemchar10CHAR(N' ')YesTJH55TERMTYP_DF Allow NULL? 
7PERFK_DEFIS-M: Default Billing Schedules (Calendar Ident.)nvarchar20CHAR(N' ')YesTFACDJPERFK_DEF Allow NULL? 
8OFFSET_DEFIS-M: Default Offset in Days for Advance Paymentnvarchar20NUMC(N'00')YesOFFSET_DEF Allow NULL? 
9ISPEINH_PRUnit of Measure for Ad Dimensions (Qty-Dependent Prices)nvarchar30UNIT(N' ')YesTJH51ISPEINH_PR Allow NULL? 
10HOEHE_DEHIS-M/AM: Default Setting for Height Unit of Measurenvarchar30UNIT(N' ')NoTJH61HOEHE_DEH Allow NULL? 
11AZART_RECHIS-M: Default Setting for Calculation Ad Typenvarchar20CHAR(N' ')YesTJH79AZ_RECHDEF Allow NULL? 
12XIKOHI_EXPIS-M: Ind. Present cont.comp.hierarchy in exploded formchar10CHAR(N' ')YesXIKOHI_EXP Allow NULL? 
13XHIDE_SVOIS-M: Give Preference to Cont.Comps in Ad Section Indicatorchar10CHAR(N' ')YesXHIDE_SVO Allow NULL? 
14XALLIKO_SVIS-M: No Plausibility Check for Special Publicationchar10CHAR(N' ')NoXALLIKO_SV Allow NULL? 
15XNOFLTR_BEIS-M/AM: Indicator Do not filter dates for additional BUschar10CHAR(N' ')NoXNOFLTR_BE Allow NULL? 
16XDELCOL_GBDeduct Gutter Bleed Column for Calculation of Technical Sizechar10CHAR(N' ')NoXDELCOL_GB Allow NULL? 
17SI_ABRMNGEIS-M: Ad insert quantity for settlementchar10CHAR(N' ')YesISM_SI_ABRMNGE Allow NULL? 
18SI_SHIPP_CHECKIS-M/AM: Check M/SD Shipping Preps when Creating AI Itemnvarchar20CHAR(N' ')NoJSI_SHIPP_CHECK Allow NULL? 
19VT_ABRMNGEIS-M/AM: Distribution quantity for settlementchar10CHAR(N' ')NoISM_VT_ABRMNGE Allow NULL? 
20VT_SHIPP_CHECKIS-M/AM: Check M/SD shipping preps when creating DT itemnvarchar20CHAR(N' ')NoJVT_SHIPP_CHECK Allow NULL? 
21XKONKAUSAZIS-M: Competitor Exclusion Active for Ad Items?char10CHAR(N' ')YesXKONKAUSAZ Allow NULL? 
22XKONKAUSDIIS-M: Competitor Exclusion Active for Service Item?char10CHAR(N' ')YesXKONKAUSDI Allow NULL? 
23XKONKAUSSIIS-M: Competitor Exclusion Active for AI Item?char10CHAR(N' ')YesXKONKAUSSI Allow NULL? 
24XKONKAUSWSIS-M: Competitor Exclusion Active for Commercial Item?char10CHAR(N' ')YesXKONKAUSWS Allow NULL? 
25XKONKAUSVTIS-M/AM: Competitor Exclusion is Active for DT Itemchar10CHAR(N' ')NoXKONKAUSVT Allow NULL? 
26XVZ_GLEICHIS-M: Equal Distribution Of Sales Agent Commissionchar10CHAR(N' ')YesXVZ_GLEICH Allow NULL? 
27XVZ_PBASDivide Commission Basis For Sales Agent Commission Indicatorchar10CHAR(N' ')YesXVZ_PBAS Allow NULL? 
28XVZ_BETRAGIS-M: Amount for Sales Agent Commission Division Indicatorchar10CHAR(N' ')YesXVZ_BETRAG Allow NULL? 
29BE_POPUPIS-M/AM: Control Voucher Copy Recipient Selectionchar10CHAR(N' ')YesBE_POPUP Allow NULL? 
30CHTYPE_AVMIS-M/AM: Order Change Typenvarchar20CHAR(N' ')NoTJHCHTYPE_AVMCHTYPE_AVM Allow NULL? 
31OFF_WVLIS-M: Responses resubmission date (days after publ.date)nvarchar20NUMC(N'00')YesOFF_WVL Allow NULL? 
32XAAZUL_OUTIS-M: Deactivate ad type admissibility checkchar10CHAR(N' ')NoXAAZUL_OUT Allow NULL? 
33XPRDIAL_AZIS-M: Pricing Dialog in Display Mode Only Indicatorchar10CHAR(N' ')YesXPRDIAL_AZ Allow NULL? 
34XVALUE_CHKIS-M: Check Value of Credit and Debit Memoschar10CHAR(N' ')NoXVALUE_CHK Allow NULL? 
35BB_LADENIS-M: Indicator Load Requirement Elementschar10CHAR(N' ')YesBB_LADEN Allow NULL? 
36XVFND_FAKT_EEIS-M: Sales Agent Determination for Billed Billing Datasetschar10CHAR(N' ')NoXVFND_FAKT_EE Allow NULL? 
37KOVAR_BLGHNWIS-M/AM: Copying Variants for Insert Notenvarchar40CHAR(N' ')NoTJHAKOKOVAR_BLGHNW Allow NULL? 
38WKTYP_BLGHNWIS-M/AM: Combination Sale Type for Insert Notenvarchar20CHAR(N' ')NoTJH91WKTYP_BLGHNW Allow NULL? 
39KOVAR_TRGANZIS-M: Copying Variant for Carrier Adnvarchar40CHAR(N' ')NoTJHAKOKOVAR_TRGANZ Allow NULL? 
40WKTYP_TRGANZIS-M/AM: Combination Sale Type for Carrying Adnvarchar20CHAR(N' ')NoTJH91WKTYP_TRGANZ Allow NULL? 
41AVM_MOTHLPIS-M: Select Ad Spec Number in the Orderchar10CHAR(N' ')NoAVM_MOTHLP Allow NULL? 
42BRANCHE_POPUPIS-M/AM: Industry Sector Dialog Box Required Indicatorchar10CHAR(N' ')YesBRANCHE_POPUP Allow NULL? 
43BRANCHE_GRPFKTIS-M/AM: Item Industry Sector Indicator for Billing Datasetchar10CHAR(N' ')YesBRANCHE_GRPFKT Allow NULL? 
44XREKLBEARB_USRIS-M/AM: Complaint Processor Must Be User Indicatorchar10CHAR(N' ')NoXREKLBEARB_USR Allow NULL? 
45ERSTER_WOCHENTAGIS-M: First Day of the Weekchar10NUMC(N'0')NoISM_ERSTER_WOCHENTAG Allow NULL? 
46SPLIT_MSG_TYPEMessage Type for Ad Size Checkchar10CHAR(N' ')Yes/NAM/SPLIT_MSG_TYPE Allow NULL? 
47XPRGRP_ADVPull Price Group from Advertiserchar10CHAR(N' ')Yes/NAM/ISM_XPRGRP_ADV Allow NULL? 
48XSRTWD_ADSP_LEVStore Sortword at Ad Spec Levelchar10CHAR(N' ')Yes/NAM/ISM_XSRTWD_ADSP_LEV Allow NULL? 
NamePrimaryUniqueTypeColumns
TJHVBER~0YesYesCLUSTEREDMANDT, VKORG, VTWEG, SPART