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

51 columns | Print definition?ERP 6.0  | KSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT39KSLTotal of transactions of the period in group currencydecimal232
2FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT45KSLTotal of transactions of the period in group currencydecimal232
3FAGLFLEXT_DIFDelta Table: G/L Totals41KSLValue in Group Currencydecimal232
4GLT0_DIFDelta Table: G/L Account Master Transaction Figures14KSLTotal transactions in the period in group currency (curr 3)decimal152
5T8PSA_RUII_HISTPSA Rollup II History (for produc split by volume)19KSLValue in group currencydecimal172
6ZSAWAActual line item table27KSLValue in group currencydecimal172
7ZSEMBPSAActual line item table23KSLValue in group currencydecimal172
8ZSPLITAIsteinzelposten-Tabelle27KSLWert in Konzernwährungdecimal172
9ZZ001AActual Line Item Table34KSLValue in group currencydecimal172
10ZZLINEAActual line item table30KSLValue in group currencydecimal172
11ZZSL01AActual line item table36KSLValue in group currencydecimal172
12ZZSPECAActual line item table28KSLValue in group currencydecimal172
TOPAvailability Control
13FMAVCAActual line item table29KSLValue in group currencydecimal172
TOPBasic Functions
14FILCAFI-LC: Actual journal entry table with 2 object tables36KSLValue in group currencydecimal172
15GGREFAExample for Global FI-SL Line Items (Actual)29KSLValue in group currencydecimal172
16GLFUNCAActual Line Items Table for Cost of Sales Accounting28KSLValue in group currencydecimal172
17GLFUNCURollup line item tables with function area for IDES28KSLValue in group currencydecimal172
18GLREFAExample for Local FI-SL Line Items (Actual)27KSLValue in group currencydecimal172
19GLREFUExample for FI-SL Rollup Line Items (Actual)28KSLValue in group currencydecimal172
20GLSO1FI-SL Line Item Table with Objects for GLTO136KSLValue in group currencydecimal172
21GLSO2FI-SL Table with Objects, Structure corresponds to GLS244KSLValue in group currencydecimal172
22GLSO3FI-SL LI Table with Objects for GLTO336KSLValue in group currencydecimal172
TOPBudgeting
23FMBDAActual line item table30KSLValue in group currencydecimal172
24FMRBAActual line item table28KSLValue in group currencydecimal172
TOPCollectionsDisbursements
25GLISDEAActual Line Item Tables for Insurance (DE)40KSLValue in group currencydecimal172
26GRISDEAActual Line Item Table for Insurance (DE) - Rollup40KSLValue in group currencydecimal172
TOPConsolidation
27ECMCASAP Cons.: Journal Entry Table (Actual)37KSLValue in group currencydecimal172
TOPCost Element Accounting
28COFISActual line items for reconciliation ledger40KSLValue in group currencydecimal172
TOPFinancial Services Localization
29/CEEIS/RUAActual line item table38KSLValue in group currencydecimal172
TOPFlexible Real Estate Management
30VIPRLEDTAGRAIsteinzelposten-Tabelle19KSLWert in Konzernwährungdecimal172
TOPFund Accounting
31FMCCAVCAActual line item table26KSLValue in group currencydecimal172
32FMGLFLEXAGeneral Ledger: Actual Line Items30KSLValue in Group Currencydecimal232
33PSGLFLEXAGeneral Ledger: Actual Line Items34KSLValue in Group Currencydecimal232
TOPGeneral Ledger Accounting
34FAGLFLEXAGeneral Ledger: Actual Line Items32KSLValue in Group Currencydecimal232
35FAGL_RSNAPSHOTReorganization: Snapshot17KSLValue in Group Currencydecimal232
36GLFLEXAFlexible general ledger: Actual line items31KSLValue in Group Currencydecimal232
TOPGrantee Management
37GMAVCAActual line item table28KSLValue in group currencydecimal172
TOPJoint Venture und Production Sharing Accounting
38JVGLFLEXAGeneral Ledger: Actual Line Items34KSLValue in Group Currencydecimal232
39JVPSC01AActual line item table39KSLValue in group currencydecimal172
40JVSO1JV LI Table with Objects for JVTO137KSLValue in group currencydecimal172
41JVSO2JV Billing FI-SL Line Item23KSLValue in group currencydecimal172
TOPProfit Center Accounting
42GLPCAEC-PCA: Actual Line Items32KSLAmount in profit center local currencydecimal152
TOPRegulatory reporting for insurance companies
43ISSRFLDEAActual line item table61KSLValue in group currencydecimal172
TOPRemaining Beverage - Obsolete Objects
44/BEV3/CHFIAActual line item table25KSLValue in group currencydecimal172
45/BEV3/CHVGRAActual line item table27KSLValue in group currencydecimal172
TOPRetail Ledger
46PCRRETAILAActual line item table26KSLValue in group currencydecimal172
TOPSpecial Purpose Ledger
47/CCIS/PBU18APBU18: Actual line item table40KSLValue in group currencydecimal172
48/CCIS/PROFTAXAActual Line Items Table for General Ledger42KSLValue in Group Currencydecimal232
TOPTariffs, Duties and Permits
49OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger41KSLValue in group currencydecimal172
50OIHSLATDP (excise duty) special ledger actual line item table46KSLValue in group currencydecimal172
TOPTransfer to Financial Accounting
51TRACTSLAActual Line Item Table19KSLValue in group currencydecimal172