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

30 columns | Print definition?ERP 6.0  | FIN_COMPANY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAccounting Engine
1FINACHDAccounting Document Header5FIN_COMPANYCompanynvarchar220
TOPFinancials
2ACCSYSTEM01Settings for Company on Accounting System3FIN_COMPANYCompanynvarchar220
3ACCSYSTEM02Number Range Object for Accounting System and Company3FIN_COMPANYCompanynvarchar220
4FINGLACCTCOMP0CG/L Account on Accounting System/Company Level3FIN_COMPANYCompanynvarchar220
5FINORDUE0CFIN Objects for Receivables/Payables7FIN_COMPANYCompanynvarchar220
6FINXCOMPANY0CLocal Values for FIN_COMPANY (Not Used in Live System)2FIN_COMPANYCompanynvarchar220
7FINXCOMPANY0TLocal Texts for FIN_COMPANY (Not Used in Live System)3FIN_COMPANYCompanynvarchar220
8FINXLOCATION0CLocal Values for FIN_LOCATION (Not Used in Live System)4FIN_COMPANYCompanynvarchar220
9FINXPRODUCT01Local Values for FIN_PRODUCT (Not Used in Live System)4FIN_COMPANYCompanynvarchar220
TOPInventory Accounting
10CFIFA0CFIN Objects for Fixed Assets3FIN_COMPANYCompanynvarchar220
11CFIOCONSI0CFIN Objects for Consignment8FIN_COMPANYCompanynvarchar220
12CFIOGMVMT0CFIN Objects for Material Documents (GR-Based IV)8FIN_COMPANYCompanynvarchar220
13CFIORGEN0CFIN Objects for Internal Orders5FIN_COMPANYCompanynvarchar220
14CFIORMNF0CFIN Objects for Manufacturing Orders4FIN_COMPANYCompanynvarchar220
15CFIORMNT0CFIN Objects for Maintenance Orders4FIN_COMPANYCompanynvarchar220
16CFIORNTA0CFIN Objects for Network Items5FIN_COMPANYCompanynvarchar220
17CFIORNTW0CFIN Objects for Networks4FIN_COMPANYCompanynvarchar220
18CFIORPURITM0CFIN Objects for Purchase Order Items9FIN_COMPANYCompanynvarchar220
19CFIORQMM0CFIN Objects for QM Orders4FIN_COMPANYCompanynvarchar220
20CFIORSRV0CFIN Objects for Service Orders4FIN_COMPANYCompanynvarchar220
21CFIORWBS0CFIN Objects for WBS Elements4FIN_COMPANYCompanynvarchar220
22CFIOSENTR0CFIN Objects for Services9FIN_COMPANYCompanynvarchar220
23CFIPVLOCPRD0CProduct Depending on Company/Location3FIN_COMPANYCompanynvarchar220
24CFIPVLOCPRDBTC0CProduct Depending on Company/Location/Batch3FIN_COMPANYCompanynvarchar220
25FAIBSV01Incoming/Outgoing Invoices9FIN_COMPANYCompanynvarchar220
26FAIBSV01CRule for Balance Sheet Valuation4FIN_COMPANYCompanynvarchar220
27FAIBSV02Valuated Receipts7FIN_COMPANYCompanynvarchar220
28FAIBSV03Logistical Goods Movements7FIN_COMPANYCompanynvarchar220
29UAINV_DYNRELACTActivation of Dynamic Price Release2FIN_COMPANYCompany Codenvarchar40
30UAI_ABGRIR_ACTIVActivation of Transaction-Based GR/IR Clearing3FIN_COMPANYCompany Codenvarchar40