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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

70 columns | Print definition?ERP 6.0  | RBDID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/CRB_BCRPBALRBD: Define Derivation of Risk Provision Positions (ECF)2RBDIDRBD: RBD ID (RBD Area)nvarchar40
2/IBS/CRB_CONBVCRBD: Assignment of Bk Val. Component to Risk Prov.Pos. (ECF)2RBDIDRBD: RBD ID (RBD Area)nvarchar40
3/IBS/CRB_CTRLMANRBD: Function Control ECF Valuation Sheet2RBDIDRBD: RBD ID (RBD Area)nvarchar40
4/IBS/CRB_ECFGAAPRBD: GAAP Assignment (ECF)2RBDIDRBD: RBD ID (RBD Area)nvarchar40
5/IBS/CRB_ECFGLBRBD: General Settings ECF2RBDIDRBD: RBD ID (RBD Area)nvarchar40
6/IBS/CRB_ECKONRBD: Acc. Assignment Ref. for Man. Contract Management ECF2RBDIDRBD: RBD ID (RBD Area)nvarchar40
7/IBS/CRB_ECKON_TRBD: Acc. Assignmt Ref. for Man. Contract Management - Texts3RBDIDRBD: RBD ID (RBD Area)nvarchar40
8/IBS/CRB_ECLCTRLRBD: Define Loss Processing for ECF Logic2RBDIDRBD: RBD ID (RBD Area)nvarchar40
9/IBS/CRB_ECLIB_PRBD: Supplying Acc. Unit for Manual Contract Management2RBDIDRBD: RBD ID (RBD Area)nvarchar40
10/IBS/CRB_ECLIB_TRBD: Suppl. Acc. Unit for Man. Contract Management - Texts3RBDIDRBD: RBD ID (RBD Area)nvarchar40
11/IBS/CRB_ECMODRBD ECF: Source Systems for Manual Contract Management2RBDIDRBD: RBD ID (RBD Area)nvarchar40
12/IBS/CRB_ECMOD_TRBD: Component ID for Manual Contract Mgmt - Text Table3RBDIDRBD: RBD ID (RBD Area)nvarchar40
13/IBS/CRB_FCONRBD: Field Control at Row Level (ECF)2RBDIDRBD: RBD ID (RBD Area)nvarchar40
14/IBS/CRB_FUPDATERBD Resubmission Date2RBDIDRBD: RBD ID (RBD Area)nvarchar40
15/IBS/CRB_M_DISCRBD: Define General Discount Rates (ECF)2RBDIDRBD: RBD ID (RBD Area)nvarchar40
16/IBS/CRB_RELSTATRBD: Definition of Status in Release Process2RBDIDRBD: RBD ID (RBD Area)nvarchar40
17/IBS/CRB_RELST_TRBD: Definition of Status in Release Process Text Table3RBDIDRBD: RBD ID (RBD Area)nvarchar40
18/IBS/CRB_RSTACHGRBD: Definition of Status Change with Authorization2RBDIDRBD: RBD ID (RBD Area)nvarchar40
19/IBS/CRB_TREVENTECF: Transaction Events2RBDIDRBD: RBD ID (RBD Area)nvarchar40
20/IBS/CRB_ZAMNTRBD Assignment of Source System Amounts to RBD Flow Types2RBDIDRBD: RBD ID (RBD Area)nvarchar40
21/IBS/CRB_ZBWARVBRBD: Assignment of Source System Flow to RiskProv.Pos.(ECF)2RBDIDRBD: RBD ID (RBD Area)nvarchar40
22/IBS/CRB_ZPROC_EECF Cust: Assignment of Processing Type to Processing Cat.2RBDIDRBD: RBD ID (RBD Area)nvarchar40
23/IBS/CRB_ZSICRVBRBD: Assignment of Collateral Type to Risk Prov. Position2RBDIDRBD: RBD ID (RBD Area)nvarchar40
24/IBS/TRB_ECF_HDRBD ECF - Value Adjustment Header Data3RBDIDRBD: RBD ID (RBD Area)nvarchar40
25/IBS/TRB_ECH_HDRBD ECF - Value Adjustment History - Header Data4RBDIDRBD: RBD ID (RBD Area)nvarchar40
26/IBS/TRB_EC_PLBARBD: Decision Template ECF - Amounts2RBDIDRBD: RBD ID (RBD Area)nvarchar40
27/IBS/TRB_EC_PLCRBD: IVA Requirement ECF2RBDIDRBD: RBD ID (RBD Area)nvarchar40
28/IBS/TRB_EC_PLC2RBD Decision Template: Provision Requirement2RBDIDRBD: RBD ID (RBD Area)nvarchar40
29/IBS/TRB_EC_PRPSRBD: Decision Template ECF2RBDIDRBD: RBD ID (RBD Area)nvarchar40
30/IBS/TRB_HG_PLCHRBD Decision Template GCC2RBDIDRBD: RBD ID (RBD Area)nvarchar40
31/IBS/TRB_HG_PROPRBD: Decision Template GCC2RBDIDRBD: RBD ID (RBD Area)nvarchar40
32/IBS/TRB_IA_PLCHRBD Decision Template GCC2RBDIDRBD: RBD ID (RBD Area)nvarchar40
33/IBS/TRB_IA_PROPRBD: Decision Template IAS2RBDIDRBD: RBD ID (RBD Area)nvarchar40
34/IBS/TRB_KTO_PRPRBD Account. Master Data2RBDIDRBD: RBD ID (RBD Area)nvarchar40
35/IBS/TRB_PLCHANGRBD: IVA Requirement2RBDIDRBD: RBD ID (RBD Area)nvarchar40
36/IBS/TRB_PLCHNG2RBD Decision Template: Provision Requirement2RBDIDRBD: RBD ID (RBD Area)nvarchar40
37/IBS/TRB_PROPRESRBD: Decision Template2RBDIDRBD: RBD ID (RBD Area)nvarchar40
38/IBS/TRB_RELSTATRBD: Status History - Principle of Treble Control4RBDIDRBD: RBD ID (RBD Area)nvarchar40
TOPLoans Management
39VDRISKCLASSRisk Classification for Individual Value Adjustment8RBDIDRBD ID (RBD Area)nvarchar40
TOPValue Adjustment
40/IBS/CRB_ARBBESTRBD: Assignment of Conditions for Planned Record Creation2RBDIDRBD: RBD ID (RBD Area)nvarchar40
41/IBS/CRB_CF_ZULRBD: Permitted Cashflow Categories for RBD Account Dialog3RBDIDRBD: RBD ID (RBD Area)nvarchar40
42/IBS/CRB_FPERIODRBD: Define Settlement Period Change2RBDIDRBD: RBD ID (RBD Area)nvarchar40
43/IBS/CRB_FVARISKRBD Valuation Basis for Flat-Rate Value Adjustment Procedure2RBDIDRBD: RBD ID (RBD Area)nvarchar40
44/IBS/CRB_KTOFIRBD Account Determination for RBD Flow Types2RBDIDRBD: RBD ID (RBD Area)nvarchar40
45/IBS/CRB_PERIORBD Define Time Periods for Valuation Areas3RBDIDRBD: RBD ID (RBD Area)nvarchar40
46/IBS/CRB_PRIOTYPRBD: Priority (Ranking Order) of RBD Flow Types2RBDIDRBD: RBD ID (RBD Area)nvarchar40
47/IBS/CRB_PWVKKRBD Valuation Basis for Flat-Rate Value Adjustment Procedure2RBDIDRBD: RBD ID (RBD Area)nvarchar40
48/IBS/CRB_RANKTYPRBD: Rank of RBD Flow Types for Value Adjustment Creation2RBDIDRBD: RBD ID (RBD Area)nvarchar40
49/IBS/CRB_RBD_PRBD RBD Area2RBDIDRBD: RBD ID (RBD Area)nvarchar40
50/IBS/CRB_RBD_TRBD RBD Area (Texts)3RBDIDRBD: RBD ID (RBD Area)nvarchar40
51/IBS/CRB_RFCXTRARBD RFC Table for Extractors for External Systems2RBDIDRBD: RBD ID (RBD Area)nvarchar40
52/IBS/CRB_RS_PROPRBD: Definition Usage Probability Provisions3RBDIDRBD: RBD ID (RBD Area)nvarchar40
53/IBS/CRB_ZARRBD Assign Aggregation Level SVA to RBD Area2RBDIDRBD: RBD ID (RBD Area)nvarchar40
54/IBS/CRB_ZBRRBD Assignment Valuation Methods to RBD Area2RBDIDRBD: RBD ID (RBD Area)nvarchar40
55/IBS/CRB_ZMRRBD Assignment Component ID Source System to RBD Area3RBDIDRBD: RBD ID (RBD Area)nvarchar40
56/IBS/CRB_ZPROCCAAssignment of Processing Type to Processing Category2RBDIDRBD: RBD ID (RBD Area)nvarchar40
57/IBS/CRB_ZPVRPRBD Assignment Product Type Source Syst. to RBD Product Type2RBDIDRBD: RBD ID (RBD Area)nvarchar40
58/IBS/CRB_ZRLIBRBD Assignment RBD Area to Accounting Unit Source System4RBDIDRBD: RBD ID (RBD Area)nvarchar40
59/IBS/TRB_GUIDKTORBD: GUID Account Identification2RBDIDRBD: RBD ID (RBD Area)nvarchar40
60/IBS/TRB_GUIDKVVRBD: GUID Table Key fields of Contract2RBDIDRBD: RBD ID (RBD Area)nvarchar40
61/IBS/TRB_KTORBD Account. Master Data2RBDIDRBD: RBD ID (RBD Area)nvarchar40
62/IBS/TRB_KTODATERBD Account Key Date for Valuation Method2RBDIDRBD: RBD ID (RBD Area)nvarchar40
63/IBS/TRB_KVVRBD Assignment RBD Account - Contract Source System2RBDIDRBD: RBD ID (RBD Area)nvarchar40
64/IBS/TRB_SHEETHRBD IAS - Header Data of Valuation Sheet3RBDIDRBD: RBD ID (RBD Area)nvarchar40
65/IBS/TRB_SHISTHRBD IAS - History Header Data Valuation Sheet4RBDIDRBD: RBD ID (RBD Area)nvarchar40
66/IBS/TRB_TTY_BALRBD RBD Balances per Flow Type10RBDIDRBD: RBD ID (RBD Area)nvarchar40
67/IBS/TRB_UERBD RBD Individual Documents4RBDIDRBD: RBD ID (RBD Area)nvarchar40
68/IBS/TRB_UE_HISTRBD RBD History of Individual Documents5RBDIDRBD: RBD ID (RBD Area)nvarchar40
69/IBS/TRB_UIRBD: RBD Record Data Table (Actual)3RBDIDRBD: RBD ID (RBD Area)nvarchar40
70/IBS/TRB_UPRBD RBD Record Data Table (PLANNED)4RBDIDRBD: RBD ID (RBD Area)nvarchar40