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

50 columns | Print definition?ERP 6.0  | RAIC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data9RAICRevenue Accounting Item Classnvarchar40
2/1RA/0SD012MIItems for Class SD01 - Processable9RAICRevenue Accounting Item Classnvarchar40
3/1RA/0SD014MIItems for Class SD01 - Processed9RAICRevenue Accounting Item Classnvarchar40
4/1RA/0SD020MIItems for Class SD02 - Raw Data9RAICRevenue Accounting Item Classnvarchar40
5/1RA/0SD022MIItems for Class SD02 - Processable9RAICRevenue Accounting Item Classnvarchar40
6/1RA/0SD024MIItems for Class SD02 - Processed9RAICRevenue Accounting Item Classnvarchar40
7/1RA/0SD030MIItems for Class SD03 - Raw Data9RAICRevenue Accounting Item Classnvarchar40
8/1RA/0SD032MIItems for Class SD03 - Processable9RAICRevenue Accounting Item Classnvarchar40
9/1RA/0SD034MIItems for Class SD03 - Processed9RAICRevenue Accounting Item Classnvarchar40
10FARR_C_BRF_APPLAssign BRFplus to Revenue Accounting Item Classes2RAICRevenue Accounting Item Classnvarchar40
11FARR_C_BRF_STRCTMaintain BRFplus Function Structure1RAICRevenue Accounting Item Classnvarchar40
12FARR_C_RAI01Revenue Accounting Item Classes1RAICRevenue Accounting Item Classnvarchar40
13FARR_C_RAI01EUpload Rule for Revenue Accounting Item Classes2RAICRevenue Accounting Item Classnvarchar40
14FARR_C_RAI01TRevenue Accounting Item Classes (Texts)2RAICRevenue Accounting Item Classnvarchar40
15FARR_C_RAI51CActive Interface Components for Revenue Accounting Item Clas1RAICRevenue Accounting Item Classnvarchar40
16FARR_C_RAI52Fields of a Revenue Accounting Item Class1RAICRevenue Accounting Item Classnvarchar40
17FARR_C_RAI52EChangeable Fields of a Revenue Accounting Item Class2RAICRevenue Accounting Item Classnvarchar40
18FARR_C_RAI54Indexes of Tables of Revenue Accounting Items1RAICRevenue Accounting Item Classnvarchar40
19FARR_C_RAI54FFields of Indexes of Tables of Revenue Accounting Item1RAICRevenue Accounting Item Classnvarchar40
20FARR_C_RAI54TTexts of Indexes for RAI Tables2RAICRevenue Accounting Item Classnvarchar40
21FARR_C_RAIC_SAPRevenue accounting item class names used by SAP1RAICRevenue Accounting Item Classnvarchar40
22FARR_D_PP_UNITSUnit Related Parameters for Parallel Processing2RAICRevenue Accounting Item Classnvarchar40
23FARR_D_RAI2_PROCAcct. principles RAI2 was successfully processed for10RAICRevenue Accounting Item Classnvarchar40
24FARR_D_RAIC01RAI Class Configuration Version (Table FARR_C_RAI01)1RAICRevenue Accounting Item Classnvarchar40
25FARR_D_RAIC01TRAI Class Configuration Version (Table FARR_C_RAI01T)2RAICRevenue Accounting Item Classnvarchar40
26FARR_D_RAIC51CConfiguration Version RAI Class (FARR_C_RAI51C)1RAICRevenue Accounting Item Classnvarchar40
27FARR_D_RAIC52Configuration Version RAI Class (FARR_C_RAI52)1RAICRevenue Accounting Item Classnvarchar40
28FARR_D_RAIC54RAI Class Configuration Version (Table FARR_C_RAI54)1RAICRevenue Accounting Item Classnvarchar40
29FARR_D_RAIC54FRAI Class Configuration Version (Table FARR_C_RAI54F)1RAICRevenue Accounting Item Classnvarchar40
30FARR_D_RAIC54TRAI Class Configuration Version (Table FARR_C_RAI54T)2RAICRevenue Accounting Item Classnvarchar40
31FARR_D_RAIG01RAI Class Generation Version (Table FARR_C_RAI01)1RAICRevenue Accounting Item Classnvarchar40
32FARR_D_RAIG01TRAI Class Generation Version (Table FARR_C_RAI01T)2RAICRevenue Accounting Item Classnvarchar40
33FARR_D_RAIG51CGeneration Version RAI Class (FARR_C_RAI51C)1RAICRevenue Accounting Item Classnvarchar40
34FARR_D_RAIG52Generation Version RAI Class (FARR_C_RAI52)1RAICRevenue Accounting Item Classnvarchar40
35FARR_D_RAIG54RAI Class Generation Version (Table FARR_C_RAI54)1RAICRevenue Accounting Item Classnvarchar40
36FARR_D_RAIG54FRAI Class Generation Version (Table FARR_C_RAI54F)1RAICRevenue Accounting Item Classnvarchar40
37FARR_D_RAIG54TRAI Class Generation Version (Table FARR_C_RAI54T)2RAICRevenue Accounting Item Classnvarchar40
38FARR_D_RAIW01Revenue Accounting Item Classes (Working Versions)1RAICRevenue Accounting Item Classnvarchar40
39FARR_D_RAIW01TRevenue Accounting Item Classes (Texts)2RAICRevenue Accounting Item Classnvarchar40
40FARR_D_RAIW51CWorking Version Configuration RAI Class (FARR_C_RAI51C)1RAICRevenue Accounting Item Classnvarchar40
41FARR_D_RAIW52Working Version Configuration RAI Class (FARR_C_RAI52)1RAICRevenue Accounting Item Classnvarchar40
42FARR_D_RAIW54RAI Class Working Version (Table FARR_C_RAI54)1RAICRevenue Accounting Item Classnvarchar40
43FARR_D_RAIW54FRAI Class Working Version (Table FARR_C_RAI54F)1RAICRevenue Accounting Item Classnvarchar40
44FARR_D_RAIW54TRAI Class Working Version (Table FARR_C_RAI54T)2RAICRevenue Accounting Item Classnvarchar40
45FARR_D_RAI_CHChange Sequence of Changed Items2RAICRevenue Accounting Item Classnvarchar40
46FARR_D_RAI_GENGeneration Info for Revenue Accounting Item Class1RAICRevenue Accounting Item Classnvarchar40
47FARR_D_RAI_GENHGeneration Info for a Revenue Accounting Item Class (Hist)1RAICRevenue Accounting Item Classnvarchar40
48FARR_D_RAI_GENOBGenerated Objects for a Revenue Accounting Item Class1RAICRevenue Accounting Item Classnvarchar40
49FARR_D_RAI_LOGLog of Data Storage of RAIC Items2RAICRevenue Accounting Item Classnvarchar40
50FARR_S_BRF_STRCTMaintains the BRF+ structure used in funtcions (OBSOLETE)1RAICRevenue Accounting Item Classnvarchar40