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

28 columns | Print definition?ERP 6.0  | BUSA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZSAWOObject table 19BUSABusiness Areanvarchar40
2ZSPLITOObjekttabelle 19BUSAGeschäftsbereichnvarchar40
3ZZ001OObject Table 19BUSABusiness Areanvarchar40
4ZZLINEOObject table 19BUSABusiness Areanvarchar40
5ZZSPECOObject table 19BUSABusiness Areanvarchar40
TOPBasic Functions
6FILCOFI-LC: Acct assign.fields (Object-TrPartner) for table FILCT9BUSABusiness Areanvarchar40
7GGREFOExample for Global Object Table 1 (Object/Partner)10BUSABusiness Areanvarchar40
8GLFUNCOObject Table 1 for Cost of Sales Accounting9BUSABusiness Areanvarchar40
9GLOO1Object Table for FI-SL Table GLTO14BUSABusiness Areanvarchar40
10GLOO2Object Table for GLT02: Global5BUSABusiness Areanvarchar40
11GLOO3Object Table for FI-SL Table GLTO34BUSABusiness Areanvarchar40
12GLREFOExample for Local Object Table 1 (Object/Partner)9BUSABusiness Areanvarchar40
TOPCollectionsDisbursements
13GLISDEOObject Table 1 for Insurance (DE)9BUSABusiness Areanvarchar40
14GRISDEOObject Table 1 for Insurance (DE) - Rollup9BUSABusiness Areanvarchar40
TOPCost Element Accounting
15COFIO1Object Table for Reconciliation Ledger COFIT12BUSABusiness Areanvarchar40
TOPFinancial Services Localization
16/CEEIS/RUOObject table 19BUSABusiness Areanvarchar40
TOPFunds Management
17FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60030BUSABusiness Areanvarchar40
18FMSPLITOObject table 19BUSABusiness Areanvarchar40
19FMUSFGFACTS1OObject table 118BUSABusiness Areanvarchar40
20FMUSFGFACTS2AActual line item table30BUSABusiness Areanvarchar40
21FMUSFGFACTS2CObject table 25BUSABusiness Areanvarchar40
22FMUSFGFACTS2PPlan line items table30BUSABusiness Areanvarchar40
23FMUSFGFACTS2TSummary table29BUSABusiness Areanvarchar40
24FMUSFGOObject table 1 for US Federal Government9BUSABusiness Areanvarchar40
TOPJoint Venture und Production Sharing Accounting
25JVOO1Object Table for FI-SL Table JVTO111BUSABusiness Areanvarchar40
26JVPSC01OObject table 113BUSABusiness Areanvarchar40
TOPTariffs, Duties and Permits
27OIHEDOObject table 1, IS-OIL Excise Duty Special Ledger16BUSABusiness Areanvarchar40
28OIHSLOTDP (excise duty) special ledger object table15BUSABusiness Areanvarchar40