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_EC_PLBA461RBD: Decision Template ECF - Amounts
SQL:  selectupdate insert create

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

SELECT MANDT, RBDID, RBDNR, GAAP_FLAG, HWAERS, BOOK_VAL, RS_BASIS, LAST_FJ, WBBBUV, WBBBUV_RS, SAP_I, SCL_I, SUS_I, SUN_I, SDW_I, SAP_I_RS, SCL_I_RS, SUS_I_RS, SUN_I_RS, SDW_I_RS, SAP_P, SCL_P, SUS_P, SUN_P, SDW_P, SAP_P_RS, SCL_P_RS, SUS_P_RS, SUN_P_RS, SDW_P_RS, SRK_I, SUG_I, SIN_I, SUW_I, SRK_I_RS, SUG_I_RS, SIN_I_RS, SUW_I_RS, SRK_P, SUG_P, SIN_P, SUW_P, SRK_P_RS, SUG_P_RS, SIN_P_RS, SUW_P_RS FROM /IBS/TRB_EC_PLBA
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? 
4GAAP_FLAGRBD: GAAPnvarchar20CHAR(N' ')No/IBS/E_RGAAP Allow NULL? 
5HWAERSRBD: Local Currencynvarchar50CUKY(N' ')No*/IBS/E_HWAERS Allow NULL? 
6BOOK_VALRBD: Book Value for Srce System Contract in Contract Currncydecimal232CURR((0))No/IBS/E_OBETRV
7RS_BASISRBD: Open Contingent Liability in Contract Currencydecimal232CURR((0))No/IBS/E_RS_BASIS
8LAST_FJRBD: Date of Last Fiscal Yearnvarchar80DATS(N'00000000')No/IBS/E_LAST_FJ Allow NULL? 
9WBBBUVRBD: Value Adjustment Position Previous Periodsdecimal232CURR((0))No/IBS/E_WBBBUV
10WBBBUV_RSRBD: Provision Balance Previous Periodsdecimal232CURR((0))No/IBS/E_RSB_VJ
11SAP_IRBD: Total Appropriationdecimal232CURR((0))No/IBS/E_SZUFU
12SCL_IRBD: Total Clearingdecimal232CURR((0))No/IBS/E_SAUFL
13SUS_IRBD: Total Usagedecimal232CURR((0))No/IBS/E_SVERB
14SUN_IRBD: Total Unwindingdecimal232CURR((0))No/IBS/E_SUNWI
15SDW_IRBD: Total of Direct Write-Offsdecimal232CURR((0))No/IBS/E_SDIRE
16SAP_I_RSRBD: Total Appropriation (Provision)decimal232CURR((0))No/IBS/E_SZUFU_RS
17SCL_I_RSRBD: Total Write-Off (Provision)decimal232CURR((0))No/IBS/E_SAUFL_RS
18SUS_I_RSRBD: Total Usage (Provision)decimal232CURR((0))No/IBS/E_SVERB_RS
19SUN_I_RSRBD: Total Unwinding (Provision)decimal232CURR((0))No/IBS/E_SUNWI_RS
20SDW_I_RSRBD: Total Direct Write-Off (Provision)decimal232CURR((0))No/IBS/E_SDIRE_RS
21SAP_PRBD: Total Appropriationdecimal232CURR((0))No/IBS/E_SZUFU
22SCL_PRBD: Total Clearingdecimal232CURR((0))No/IBS/E_SAUFL
23SUS_PRBD: Total Usagedecimal232CURR((0))No/IBS/E_SVERB
24SUN_PRBD: Total Unwindingdecimal232CURR((0))No/IBS/E_SUNWI
25SDW_PRBD: Total of Direct Write-Offsdecimal232CURR((0))No/IBS/E_SDIRE
26SAP_P_RSRBD: Total Appropriation (Provision)decimal232CURR((0))No/IBS/E_SZUFU_RS
27SCL_P_RSRBD: Total Write-Off (Provision)decimal232CURR((0))No/IBS/E_SAUFL_RS
28SUS_P_RSRBD: Total Usage (Provision)decimal232CURR((0))No/IBS/E_SVERB_RS
29SUN_P_RSRBD: Total Unwinding (Provision)decimal232CURR((0))No/IBS/E_SUNWI_RS
30SDW_P_RSRBD: Total Direct Write-Off (Provision)decimal232CURR((0))No/IBS/E_SDIRE_RS
31SRK_IRBD: Total Resetdecimal232CURR((0))Yes/IBS/E_SRUCKN
32SUG_IRBD: Total Reclassificationdecimal232CURR((0))Yes/IBS/E_SUGLDR
33SIN_IRBD: Total Initializationdecimal232CURR((0))Yes/IBS/E_SINI
34SUW_IRBD: Total Reallocationdecimal232CURR((0))Yes/IBS/E_SUMW
35SRK_I_RSRBD: Total Reset for Provisiondecimal232CURR((0))Yes/IBS/E_SRUCKN_RS
36SUG_I_RSRBD: Total Reclassification of Provisiondecimal232CURR((0))Yes/IBS/E_SUGLDR_RS
37SIN_I_RSRBD: Total Initialization for Provisiondecimal232CURR((0))Yes/IBS/E_SINI_RS
38SUW_I_RSRBD: Total Reallocation of Provisiondecimal232CURR((0))Yes/IBS/E_SUMW_RS
39SRK_PRBD: Total Resetdecimal232CURR((0))Yes/IBS/E_SRUCKN
40SUG_PRBD: Total Reclassificationdecimal232CURR((0))Yes/IBS/E_SUGLDR
41SIN_PRBD: Total Initializationdecimal232CURR((0))Yes/IBS/E_SINI
42SUW_PRBD: Total Reallocationdecimal232CURR((0))Yes/IBS/E_SUMW
43SRK_P_RSRBD: Total Reset for Provisiondecimal232CURR((0))Yes/IBS/E_SRUCKN_RS
44SUG_P_RSRBD: Total Reclassification of Provisiondecimal232CURR((0))Yes/IBS/E_SUGLDR_RS
45SIN_P_RSRBD: Total Initialization for Provisiondecimal232CURR((0))Yes/IBS/E_SINI_RS
46SUW_P_RSRBD: Total Reallocation of Provisiondecimal232CURR((0))Yes/IBS/E_SUMW_RS
NamePrimaryUniqueTypeColumns
/IBS/TRB_EC_PLBA~0YesYesCLUSTEREDGAAP_FLAG, RBDNR, RBDID, MANDT