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

34 columns | Print definition?ERP 6.0  | O_APPL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFinancial Conditions
1FICOB_AMT_FCNTROBSOLETE DONT USE1O_APPLApplicationnvarchar60
2FICOB_APPLApplication1O_APPLApplicationnvarchar60
3FICOB_APPL_CONDApplication Assignment - Condition Category1O_APPLApplicationnvarchar60
4FICOB_APPL_LISTApplication Assignment - Condition Group Category1O_APPLApplicationnvarchar60
5FICOB_APPL_TTexts on Application2O_APPLApplicationnvarchar60
6FICOB_CALCCATGCalculation Category1O_APPLApplicationnvarchar60
7FICOB_CALCCATG_TTexts for Calculation Category2O_APPLApplicationnvarchar60
8FICOB_COND_FIEOBSOLETE DONT USE1O_APPLApplicationnvarchar60
9FICOB_DATE_FCNTROBSOLETE DONT USE1O_APPLApplicationnvarchar60
10FICOB_FCTRL_AMTField for Assignment of Amount Category1O_APPLApplicationnvarchar60
11FICOB_FCTRL_CONDCondition Header Assignment - Field1O_APPLApplicationnvarchar60
12FICOB_FCTRL_DATEDate Category Assignment - Field1O_APPLApplicationnvarchar60
13FICOB_FOREIGNData from External Applications1O_APPLApplicationnvarchar60
14FICOC_BASEREFTexts of Base References2O_APPLApplicationnvarchar60
15FICOC_BASEREF_TTexts of Base References3O_APPLApplicationnvarchar60
16FICOC_CONDCondition Type2O_APPLApplicationnvarchar60
17FICOC_COND_AMTAssignment Condition Type - Amount Category2O_APPLApplicationnvarchar60
18FICOC_COND_BDTDefine Condition Type - BDT2O_APPLApplicationnvarchar60
19FICOC_COND_DATEAssignment Condition Type - Deadline Category2O_APPLApplicationnvarchar60
20FICOC_COND_DIFFAssignment Condition Type - Differentiation2O_APPLApplicationnvarchar60
21FICOC_COND_FMODField Modifications for Condition Types2O_APPLApplicationnvarchar60
22FICOC_COND_GUIDCondition Type: Assignment of GUID2O_APPLApplicationnvarchar60
23FICOC_COND_OPRTRAssignment of Condition Category to Formula Operator3O_APPLApplicationnvarchar60
24FICOC_COND_TTexts for Condition Type3O_APPLApplicationnvarchar60
25FICOC_COND_USERCondition Type: User Information2O_APPLApplicationnvarchar60
26FICOC_FOREIGNData from External Applications2O_APPLApplicationnvarchar60
27FICOC_LISTCondition Group Type (List Type)2O_APPLApplicationnvarchar60
28FICOC_LIST_CONDAssignment Conditon Group Type (List Type) - Condition Type2O_APPLApplicationnvarchar60
29FICOC_LIST_TTexts for Condition Group Type (List Type)2O_APPLApplicationnvarchar60
30FICOC_PCALCREFInterest Penalty Calculation Method2O_APPLApplicationnvarchar60
31FICOC_PCALCREF_TText for Interest Penalty Calculation Method3O_APPLApplicationnvarchar60
32FICOT_CONDIConditions (Unbuffered)6O_APPLApplicationnvarchar60
33FICOT_CONDI_BUFFConditions (Buffered)6O_APPLApplicationnvarchar60
34FICOT_LISTCondition List4O_APPLApplicationnvarchar60