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
1ERP EHP76.0/IBS/TRB_PLCHNG2331RBD Decision Template: Provision Requirement
SQL:  selectupdate insert create

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

SELECT MANDT, RBDID, RBDNR, VERTV, CURRENCY, RS_BASIS, RS_PROP, RS_PROP_DR, RS_PASSV, RS_BESTAND, RS_BESTAND_UN, RS_BESTAND_VJ, RS_BESTAND_UN_VJ, RS_BEDARF, RS_BEDARF_UN, RS_AE_BESTAND_VJ, RS_BEDARF_AJ, RS_BEDARF_VJ, RS_SUM_IA_ERWA, RS_SUM_IA_ABGE, RS_SUM_CF_ERWA, RS_SUM_CF_ABGE, RS_SUM_SICH_AB, RS_SUM_I_UNW, RS_SUM_I_UNW_MEM, RS_SUM_UNW, RS_SUM_UNW_MEM, RS_SHEETNR_REF, RS_OP_CH_UNW, RS_BEST_UMB_AB, RS_BEST_UMB_ZU, RS_INIT, RS_INIT_VJ FROM /IBS/TRB_PLCHNG2
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2RBDIDRBD: RBD ID (RBD Area)nvarchar40CHAR(N' ')No*/IBS/E_RBDID Allow NULL? 
3RBDNRRBD: Account Numbernvarchar130CHAR(N' ')No/IBS/E_RBDNR Allow NULL? 
4VERTVRBD: Contract Number Source Systemnvarchar1000CHAR(N' ')No/IBS/E_VERTV Allow NULL? 
5CURRENCYRBD: Local Currencynvarchar50CUKY(N' ')No*/IBS/E_HWAERS Allow NULL? 
6RS_BASISRBD: Open Contingent Liability in Contract Currencydecimal232CURR((0))Yes/IBS/E_RS_BASIS
7RS_PROPRBD: Probability of Risk Provision Usagedecimal52DEC((0))Yes/IBS/E_RS_PROP
8RS_PROP_DRRBD: Usage Amount Contingent Liabilitydecimal52DEC((0))Yes/IBS/E_RS_PROP_DR
9RS_PASSVRBD: Indicator Prohibition of Liability Recognition (Reset)char10CHAR(N' ')Yes/IBS/E_RS_PASSV Allow NULL? 
10RS_BESTANDRBD: Provision Balance Current Perioddecimal232CURR((0))Yes/IBS/E_RSB_AJ
11RS_BESTAND_UNRBD: Position Unwinding Current Period (Reset)decimal232CURR((0))Yes/IBS/E_RSB_UN_AJ
12RS_BESTAND_VJRBD: Provision Balance Previous Periodsdecimal232CURR((0))Yes/IBS/E_RSB_VJ
13RS_BESTAND_UN_VJRBD: Position Unwinding Previous Periods (Reset)decimal232CURR((0))Yes/IBS/E_RSB_UN_VJ
14RS_BEDARFRBD: Provision Requirementdecimal232CURR((0))Yes/IBS/E_RS_BD
15RS_BEDARF_UNRBD: Unwinding Requirements (Provision)decimal232CURR((0))Yes/IBS/E_RS_BDU
16RS_AE_BESTAND_VJRBD: Change Balance Provision Previous Periodsdecimal232CURR((0))Yes/IBS/E_RS_AEB_VJ
17RS_BEDARF_AJRBD: Change Requirement Provision Current Perioddecimal232CURR((0))Yes/IBS/E_RS_BD_AJ
18RS_BEDARF_VJRBD: Change Requirement Provision Previous Periodsdecimal232CURR((0))Yes/IBS/E_RS_BD_VJ
19RS_SUM_IA_ERWARBD: Defined Utilization (Total)decimal232CURR((0))Yes/IBS/E_RS_IA_ERW
20RS_SUM_IA_ABGERBD: NPV of Expected Utilizationdecimal232CURR((0))Yes/IBS/E_RS_SUMIAA
21RS_SUM_CF_ERWARBD: Total Cash Flow Expectation (Reset)decimal232CURR((0))Yes/IBS/E_RS_SUMCFE
22RS_SUM_CF_ABGERBD: NPV of Expected Cash Flows (Provision)decimal232CURR((0))Yes/IBS/E_RS_SUMCFA
23RS_SUM_SICH_ABRBD: NPV of Expected Collateral Revenues (Reset)decimal232CURR((0))Yes/IBS/E_RS_SUMCOA
24RS_SUM_I_UNWRBD: Unwinding Amountdecimal232CURR((0))Yes/IBS/E_BETUN
25RS_SUM_I_UNW_MEMRBD: Unwinding Amountdecimal232CURR((0))Yes/IBS/E_BETUN
26RS_SUM_UNWRBD: Unwinding Amountdecimal232CURR((0))Yes/IBS/E_BETUN
27RS_SUM_UNW_MEMRBD: Unwinding Amountdecimal232CURR((0))Yes/IBS/E_BETUN
28RS_SHEETNR_REFRBD: Fair Value Sheet Referencenvarchar100NUMC(N'0000000000')Yes/IBS/E_SHEETNR_REF Allow NULL? 
29RS_OP_CH_UNWRBD: Open Position Change Provisiondecimal232CURR((0))Yes/IBS/E_RS_OPCHUNW
30RS_BEST_UMB_ABRBD: Balance Sheet Transfer - Retirement - Provisiondecimal232CURR((0))Yes/IBS/E_RS_B_UMAB
31RS_BEST_UMB_ZURBD: Balance Sheet Transfer - Acquisition - Provisiondecimal232CURR((0))Yes/IBS/E_RS_B_UMZU
32RS_INITRBD: Initialization (Provision) for Current Perioddecimal232CURR((0))Yes/IBS/E_RAE_INIT_RS
33RS_INIT_VJRBD: Initialization of Provision (Previous Periods)decimal232CURR((0))Yes/IBS/E_RAE_INIT_RS_VJ
NamePrimaryUniqueTypeColumns
/IBS/TRB_PLCHNG2~0YesYesCLUSTEREDVERTV, RBDNR, RBDID, MANDT