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

63 columns | Print definition?ERP 6.0  | MODID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/CRB_BCRPBALRBD: Define Derivation of Risk Provision Positions (ECF)4MODIDRBD: Component ID Source Systemnvarchar100
2/IBS/CRB_ECKONRBD: Acc. Assignment Ref. for Man. Contract Management ECF3MODIDRBD: Component ID Source Systemnvarchar100
3/IBS/CRB_ECKON_TRBD: Acc. Assignmt Ref. for Man. Contract Management - Texts4MODIDRBD: Component ID Source Systemnvarchar100
4/IBS/CRB_ECLIB_PRBD: Supplying Acc. Unit for Manual Contract Management3MODIDRBD: Component ID Source Systemnvarchar100
5/IBS/CRB_ECLIB_TRBD: Suppl. Acc. Unit for Man. Contract Management - Texts4MODIDRBD: Component ID Source Systemnvarchar100
6/IBS/CRB_ECMODRBD ECF: Source Systems for Manual Contract Management3MODIDRBD: Component ID Source Systemnvarchar100
7/IBS/CRB_ECMOD_TRBD: Component ID for Manual Contract Mgmt - Text Table4MODIDRBD: Component ID Source Systemnvarchar100
8/IBS/CRB_ECMPRODRBD: Define Product Types for Manual Contract Mgmt (ECF)2MODIDRBD: Component ID Source Systemnvarchar100
9/IBS/CRB_M_DISCRBD: Define General Discount Rates (ECF)4MODIDRBD: Component ID Source Systemnvarchar100
10/IBS/CRB_ZAMNTRBD Assignment of Source System Amounts to RBD Flow Types3MODIDRBD: Component ID Source Systemnvarchar100
11/IBS/CRB_ZPROC_EECF Cust: Assignment of Processing Type to Processing Cat.3MODIDRBD: Component ID Source Systemnvarchar100
12/IBS/TRB_ECF_HDRBD ECF - Value Adjustment Header Data7MODIDRBD: Component ID Source Systemnvarchar100
13/IBS/TRB_ECH_HDRBD ECF - Value Adjustment History - Header Data8MODIDRBD: Component ID Source Systemnvarchar100
14/IBS/TRB_ECI_BALRBD ECF - Positions Import Table2MODIDRBD: Component ID Source Systemnvarchar100
15/IBS/TRB_ECI_BVCRBD ECF - Book Value Components Import Table2MODIDRBD: Component ID Source Systemnvarchar100
16/IBS/TRB_ECI_CFRBD ECF - Cash Flow Import Table2MODIDRBD: Component ID Source Systemnvarchar100
17/IBS/TRB_ECI_CORBD ECF - Import Table for Collateral2MODIDRBD: Component ID Source Systemnvarchar100
18/IBS/TRB_ECI_HDRBD ECF - Import Table Header Data2MODIDRBD: Component ID Source Systemnvarchar100
19/IBS/TRB_ECM_BALRBD ECF: Manual Contract Management - Positions2MODIDRBD: Component ID Source Systemnvarchar100
20/IBS/TRB_ECM_BVCRBD ECF: Manual Contract Management - Book Value Components2MODIDRBD: Component ID Source Systemnvarchar100
21/IBS/TRB_ECM_HDRBD ECF: Manual Contract Management - Header Data2MODIDRBD: Component ID Source Systemnvarchar100
22/IBS/TRB_KTO_PRPRBD Account. Master Data18MODIDRBD: Component ID Source Systemnvarchar100
23T5JOM36 Agreement: Overtime Work Limit Modifier2MODIDAgreement IDnvarchar30
TOPBusiness Consolidation
24UCL2030Change Log: Number of Modified Records2MODIDSequence Number - Logging of Modificationsnvarchar60
25UCL2031Change Log: Selections2MODIDSequence Number - Logging of Modificationsnvarchar60
26UCL203CChange Log2MODIDSequence Number - Logging of Modificationsnvarchar60
TOPLoans Management
27VDRISKCLASSRisk Classification for Individual Value Adjustment7MODIDSource Sysytem Component ID for RBDnvarchar100
TOPPatient Management
28NATMIS-H/IS-H*MED: Time Slot Modification2MODIDIS-H/IS-H*MED: Modification IDnvarchar100
TOPValue Adjustment
29/IBS/CRB_CF_ZULRBD: Permitted Cashflow Categories for RBD Account Dialog4MODIDRBD: Component ID Source Systemnvarchar100
30/IBS/CRB_GATERBD: Assignment of RBD Gate to RBD Flow Types2MODIDRBD: Component ID Source Systemnvarchar100
31/IBS/CRB_IASBEWERBD Relevant Legacy System Flows IAS / IFRS Gate Fill2MODIDRBD: Component ID Source Systemnvarchar100
32/IBS/CRB_KLS_PRBD: Obsolete RBD Class3MODIDRBD: Component ID Source Systemnvarchar100
33/IBS/CRB_MODID_PRBD Component ID Source System2MODIDRBD: Component ID Source Systemnvarchar100
34/IBS/CRB_MODID_TRBD Component ID Source System (Texts)3MODIDRBD: Component ID Source Systemnvarchar100
35/IBS/CRB_RBAARBD Loss Flow Types2MODIDRBD: Component ID Source Systemnvarchar100
36/IBS/CRB_RFCXTRARBD RFC Table for Extractors for External Systems3MODIDRBD: Component ID Source Systemnvarchar100
37/IBS/CRB_RS_PROPRBD: Definition Usage Probability Provisions5MODIDRBD: Component ID Source Systemnvarchar100
38/IBS/CRB_ZBEVWWRBD:Assignmt FT Line Item Sce Syst. Crcy Chge (Capital Only)2MODIDRBD: Component ID Source Systemnvarchar100
39/IBS/CRB_ZGPAPRBD Permitted SAP BP Roles for Aggregation Level Partners2MODIDRBD: Component ID Source Systemnvarchar100
40/IBS/CRB_ZGPDAVSRBD Assignment BP Role to Product Type Source System2MODIDRBD: Component ID Source Systemnvarchar100
41/IBS/CRB_ZKRBWRBD Assignment Capital Source System RBD Flow Type2MODIDRBD: Component ID Source Systemnvarchar100
42/IBS/CRB_ZMRRBD Assignment Component ID Source System to RBD Area2MODIDRBD: Component ID Source Systemnvarchar100
43/IBS/CRB_ZPVRPRBD Assignment Product Type Source Syst. to RBD Product Type3MODIDRBD: Component ID Source Systemnvarchar100
44/IBS/CRB_ZRBWARBD RBD Flow Type Determination2MODIDRBD: Component ID Source Systemnvarchar100
45/IBS/CRB_ZRLIBRBD Assignment RBD Area to Accounting Unit Source System2MODIDRBD: Component ID Source Systemnvarchar100
46/IBS/CRB_ZVSKRBD: Assignment Source System to RBD Class2MODIDRBD: Component ID Source Systemnvarchar100
47/IBS/TRB_GUIDGATRBD: GUID Table RBDGATE Key Fields2MODIDRBD: Component ID Source Systemnvarchar100
48/IBS/TRB_GUIDKVVRBD: GUID Table Key fields of Contract4MODIDRBD: Component ID Source Systemnvarchar100
49/IBS/TRB_IASCOLRBD IAS-GATE Collateral Data2MODIDRBD: Component ID Source Systemnvarchar100
50/IBS/TRB_IASGHDRBD IAS-GATE Header Data2MODIDRBD: Component ID Source Systemnvarchar100
51/IBS/TRB_IASGPORBD IAS-GATE Position Data2MODIDRBD: Component ID Source Systemnvarchar100
52/IBS/TRB_KTORBD Account. Master Data18MODIDRBD: Component ID Source Systemnvarchar100
53/IBS/TRB_KVVRBD Assignment RBD Account - Contract Source System4MODIDRBD: Component ID Source Systemnvarchar100
54/IBS/TRB_RBDGATERBD: Universal Data Basis/Worklist2MODIDRBD: Component ID Source Systemnvarchar100
55/IBS/TRB_RBDLOSSRBD Loss Source System2MODIDRBD: Component ID Source Systemnvarchar100
56/IBS/TRB_SHEETHRBD IAS - Header Data of Valuation Sheet7MODIDRBD: Component ID Source Systemnvarchar100
57/IBS/TRB_SHISTHRBD IAS - History Header Data Valuation Sheet8MODIDRBD: Component ID Source Systemnvarchar100
58/IBS/TRB_TTY_BALRBD RBD Balances per Flow Type2MODIDRBD: Component ID Source Systemnvarchar100
59/IBS/TRB_UERBD RBD Individual Documents7MODIDRBD: Component ID Source Systemnvarchar100
60/IBS/TRB_UE_HISTRBD RBD History of Individual Documents8MODIDRBD: Component ID Source Systemnvarchar100
61/IBS/TRB_UIRBD: RBD Record Data Table (Actual)53MODIDRBD: Component ID Source Systemnvarchar100
62/IBS/TRB_UPRBD RBD Record Data Table (PLANNED)47MODIDRBD: Component ID Source Systemnvarchar100
63/IBS/TRB_VS_SALDRBD Individual Document Table2MODIDRBD: Component ID Source Systemnvarchar100