SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

65 columns | Print definition?ERP 6.0  | HSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT38HSLBalance carried forward in local currencydecimal232
2FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT42HSLBalance carried forward in local currencydecimal232
3FAGLFLEXT_DIFDelta Table: G/L Totals40HSLValue in Local Currencydecimal232
4GLT0_DIFDelta Table: G/L Account Master Transaction Figures13HSLTotal transactions in the period in local currency (curr 2)decimal152
5T8PSA_RUII_HISTPSA Rollup II History (for produc split by volume)18HSLValue in local currencydecimal172
6ZSAWAActual line item table26HSLValue in local currencydecimal172
7ZSEMBPSAActual line item table22HSLValue in local currencydecimal172
8ZSPLITAIsteinzelposten-Tabelle26HSLWert in Hauswährungdecimal172
9ZZ001AActual Line Item Table33HSLValue in local currencydecimal172
10ZZLINEAActual line item table29HSLValue in local currencydecimal172
11ZZSL01AActual line item table35HSLValue in local currencydecimal172
12ZZSPECAActual line item table27HSLValue in local currencydecimal172
TOPAvailability Control
13FMAVCAActual line item table28HSLValue in local currencydecimal172
TOPBasic Functions
14FILCAFI-LC: Actual journal entry table with 2 object tables35HSLValue in local currencydecimal172
15GGREFAExample for Global FI-SL Line Items (Actual)28HSLValue in local currencydecimal172
16GLFUNCAActual Line Items Table for Cost of Sales Accounting27HSLValue in local currencydecimal172
17GLFUNCURollup line item tables with function area for IDES27HSLValue in local currencydecimal172
18GLREFAExample for Local FI-SL Line Items (Actual)26HSLValue in local currencydecimal172
19GLREFUExample for FI-SL Rollup Line Items (Actual)27HSLValue in local currencydecimal172
20GLSO1FI-SL Line Item Table with Objects for GLTO135HSLValue in local currencydecimal172
21GLSO2FI-SL Table with Objects, Structure corresponds to GLS243HSLValue in local currencydecimal172
22GLSO3FI-SL LI Table with Objects for GLTO335HSLValue in local currencydecimal172
TOPBudgeting
23FMBDAActual line item table29HSLValue in local currencydecimal172
24FMRBAActual line item table27HSLValue in local currencydecimal172
TOPCollectionsDisbursements
25GLISDEAActual Line Item Tables for Insurance (DE)39HSLValue in local currencydecimal172
26GRISDEAActual Line Item Table for Insurance (DE) - Rollup39HSLValue in local currencydecimal172
TOPConsolidation
27ECMCASAP Cons.: Journal Entry Table (Actual)36HSLValue in local currencydecimal172
TOPCost Element Accounting
28COFISActual line items for reconciliation ledger39HSLValue in local currencydecimal172
TOPData Retention Tool
29TXW_S_COFIRetrieve COFIS from archive21HSLAmount in local currencynvarchar190
TOPFinancial Services Localization
30/CEEIS/RUAActual line item table37HSLValue in local currencydecimal172
TOPFlexible Real Estate Management
31VIPRLEDTAGRAIsteinzelposten-Tabelle18HSLWert in Hauswährungdecimal172
TOPFund Accounting
32FMCCAVCAActual line item table25HSLValue in local currencydecimal172
33FMCCAVCRESERVECCAVC aux table for reserved items25HSLValue in Transaction Currencydecimal232
34FMGLFLEXAGeneral Ledger: Actual Line Items29HSLValue in Local Currencydecimal232
35PSGLFLEXAGeneral Ledger: Actual Line Items33HSLValue in Local Currencydecimal232
TOPFunds Management
36FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60031HSLValue in local currencydecimal172
37FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60035HSLValue in local currencydecimal172
38FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60031HSLValue in local currencydecimal172
39FMIAActual Line Item Table for Funds Management32HSLValue in local currencydecimal172
40FMSPLITAActual line item table33HSLValue in local currencydecimal172
41FMUSFGAActual line item table for US Federal Government.31HSLValue in local currencydecimal172
42FMUSFGFACTS1A4Actual line item table31HSLValue in local currencydecimal172
43FMUSFGFACTS2AActual line item table35HSLValue in local currencydecimal172
TOPGeneral Ledger Accounting
44FAGLFLEXAGeneral Ledger: Actual Line Items31HSLValue in Local Currencydecimal232
45FAGL_RSNAPSHOTReorganization: Snapshot16HSLValue in Local Currencydecimal232
46GLFLEXAFlexible general ledger: Actual line items30HSLValue in Local Currencydecimal232
TOPGrantee Management
47GMAVCAActual line item table27HSLValue in local currencydecimal172
48GMIAActual Line Item Table26HSLValue in local currencydecimal172
TOPJoint Venture und Production Sharing Accounting
49JVGLFLEXAGeneral Ledger: Actual Line Items33HSLValue in Local Currencydecimal232
50JVPSC01AActual line item table38HSLValue in local currencydecimal172
51JVSO1JV LI Table with Objects for JVTO136HSLValue in local currencydecimal172
52JVSO2JV Billing FI-SL Line Item22HSLValue in local currencydecimal172
TOPLocalization
53J_3RFTAXRATax Accounting: Actual line item table40HSLValue in local currencydecimal172
54J_3RFTAXRVATax Accounting: Actual line item table40HSLValue in local currencydecimal172
TOPProfit Center Accounting
55GLPCAEC-PCA: Actual Line Items31HSLAmount in company code currencydecimal152
TOPRegulatory reporting for insurance companies
56ISSRFLDEAActual line item table60HSLValue in local currencydecimal172
57ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle20HSLImporto di modifica posizione in divisa internadecimal172
TOPRemaining Beverage - Obsolete Objects
58/BEV3/CHFIAActual line item table24HSLValue in local currencydecimal172
59/BEV3/CHVGRAActual line item table26HSLValue in local currencydecimal172
TOPRetail Ledger
60PCRRETAILAActual line item table25HSLValue in local currencydecimal172
TOPSpecial Purpose Ledger
61/CCIS/PBU18APBU18: Actual line item table39HSLValue in local currencydecimal172
62/CCIS/PROFTAXAActual Line Items Table for General Ledger41HSLValue in Local Currencydecimal232
TOPTariffs, Duties and Permits
63OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger40HSLValue in local currencydecimal172
64OIHSLATDP (excise duty) special ledger actual line item table45HSLValue in local currencydecimal172
TOPTransfer to Financial Accounting
65TRACTSLAActual Line Item Table18HSLValue in local currencydecimal172