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.0JHTVAARI381IS-M/AM: Contract Settlement Payer/Advertiser RecordAdvertising Management
SQL:  selectupdate insert create

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

SELECT MANDT, VTNR, ABRGNR, REGULIERER, INSERENT, TRENNUNG, VKORG, VTWEG, SPART, ABS_TYP, ABINHNR, AB_BRUTTO, AB_WEINH, ABRMM, ABRME, EINH1, EINH2, PR_BASIS, ABRECHK, ABR_STATUS, STORNOGRD, FAKSP, DATEAAFS, RAB_IST, RAB_SOLL, BON_IST, BON_SOLL, ABETR_IST, ABETR_SOLL, GL_BETRAG, SFKRBMO, SFKRBMM, SFKRBME, SFKBOMO, SFKBOMM, SFKBOME, JHABRDAT, AAB_BEARB FROM JHTVAARI
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VTNRIS-M: Contract Numbernvarchar60NUMC(N'000000')NoJHTVAABKABS_VTNR Allow NULL? 
3ABRGNRIS-M/AM: Contract Settlement Numbernvarchar40NUMC(N'0000')NoJHTVAABKABRGNR Allow NULL? 
4REGULIERERIS-M: Payernvarchar100CHAR(N' ')NoJJVDB_MKREGULIERER Allow NULL? 
5INSERENTIS-M: Advertisernvarchar100CHAR(N' ')NoJJVDB_MK_FKINSERENT Allow NULL? 
6TRENNUNGIS-M/AM: Split Criteria for Payer/Advertiser Recordsnvarchar100CHAR(N' ')NoJH_TRENNUNG Allow NULL? 
7VKORGSales Organizationnvarchar40CHAR(N' ')NoTVKOVKORG Allow NULL? 
8VTWEGDistribution Channelnvarchar20CHAR(N' ')NoTVTWVTWEG Allow NULL? 
9SPARTDivisionnvarchar20CHAR(N' ')NoTSPASPART Allow NULL? 
10ABS_TYPIS-M/AM: Contract Categorychar10CHAR(N' ')YesTJH11ABS_TYP Allow NULL? 
11ABINHNRIS-M/AM: Number of Contract Holdernvarchar100CHAR(N' ')YesJGTGPNRABINHNR Allow NULL? 
12AB_BRUTTOIS-M: Contract Grossdecimal152CURR((0))YesAB_BRUTTO
13AB_WEINHIS-M: Currency Key for Contractnvarchar50CUKY(N' ')YesTCURCAB_WEINH Allow NULL? 
14ABRMMIS-M: Quantity (mm, Pages, Seconds)decimal123QUAN((0))YesABRMM
15ABRMEIS-M: Numberdecimal50DEC((0))YesABRME
16EINH1IS-M: Contract Units of Measurementnvarchar30UNIT(N' ')Yes*AB_MEINH Allow NULL? 
17EINH2IS-M: Contract Units of Measurementnvarchar30UNIT(N' ')Yes*AB_MEINH Allow NULL? 
18PR_BASISIS-M: Basis for scale access (number/quantity)char10CHAR(N' ')YesPR_BASIS Allow NULL? 
19ABRECHKIS-M: Settlement Typechar10CHAR(N' ')YesTJH15ABRECHK Allow NULL? 
20ABR_STATUSIS-M: Contract Settlement Statuschar10CHAR(N' ')YesABR_STATUS Allow NULL? 
21STORNOGRDIS-M: Cancellation Reasonnvarchar30CHAR(N' ')YesTJHSTOGSTOGRD_PAM Allow NULL? 
22FAKSPBlocknvarchar20CHAR(N' ')YesTVFSFAKSP Allow NULL? 
23DATEAAFSIS-M/AM: Billing Block Date for Contract Settlementnvarchar80DATS(N'00000000')YesDATEAAFS Allow NULL? 
24RAB_ISTIS-M: Contract Discount Granted to Datedecimal132CURR((0))YesRAB_IST
25RAB_SOLLIS-M: Current Contract Discountdecimal132CURR((0))YesRAB_SOLL
26BON_ISTIS-M: Contract Bonus Granted to Datedecimal132CURR((0))YesBON_IST
27BON_SOLLIS-M/AM: Current Contract Bonusdecimal132CURR((0))YesBON_SOLL
28ABETR_ISTIS-M: Contract Settlement Amount Paid to Datedecimal152CURR((0))YesABETR_IST
29ABETR_SOLLIS-M: Current Contract Settlement Amountdecimal152CURR((0))YesABETR_SOLL
30GL_BETRAGIS-M: Credit/Debit Memo Amount for Contract Settlementdecimal152CURR((0))YesGL_BETRAG
31SFKRBMOTotal sales vol.all acc.assignments qualifying for discountdecimal152CURR((0))YesSRBMO
32SFKRBMMIS-M: Total qty all acc.assignments qualifying for discountdecimal123QUAN((0))YesSRBMM
33SFKRBMEIS-M: Total No.All Acc.Assignments Qualifying for Discountdecimal50DEC((0))YesSRBME
34SFKBOMOIS-M: Total sales vol.all accept.assignments qual.for bonusdecimal152CURR((0))YesSBOMO
35SFKBOMMIS-M: Total quantity of all accpt.assignments qual.for bonusdecimal123QUAN((0))YesSBOMM
36SFKBOMEIS-M: Total Number All Acc.Assignments Qualifying for Bonusdecimal50DEC((0))YesSBOME
37JHABRDATIS-M: Contract Settlement Datenvarchar80DATS(N'00000000')YesJHABRDAT Allow NULL? 
38AAB_BEARBIS-M: Contract Settlement Processed Bynvarchar120CHAR(N' ')YesUSR02AAB_BEARB Allow NULL? 
NamePrimaryUniqueTypeColumns
JHTVAARI~0YesYesCLUSTEREDSPART, VTWEG, VKORG, TRENNUNG, INSERENT, REGULIERER, ABRGNR, VTNR, MANDT