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

47 columns | Print definition?ERP 6.0  | MSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FAGLFLEXT_DIFDelta Table: G/L Totals43MSLQuantitydecimal233
2ZSAWAActual line item table28MSLQuantitydecimal153
3ZSEMBPSAActual line item table24MSLQuantitydecimal153
4ZSPLITAIsteinzelposten-Tabelle28MSLMengedecimal153
5ZZ001AActual Line Item Table35MSLQuantitydecimal153
6ZZLINEAActual line item table31MSLQuantitydecimal153
7ZZSL01AActual line item table37MSLQuantitydecimal153
8ZZSPECAActual line item table29MSLQuantitydecimal153
TOPBasic Functions
9FILCAFI-LC: Actual journal entry table with 2 object tables37MSLQuantitydecimal153
10GGREFAExample for Global FI-SL Line Items (Actual)30MSLQuantitydecimal153
11GLFUNCAActual Line Items Table for Cost of Sales Accounting29MSLQuantitydecimal153
12GLFUNCURollup line item tables with function area for IDES29MSLQuantitydecimal153
13GLREFAExample for Local FI-SL Line Items (Actual)28MSLQuantitydecimal153
14GLREFUExample for FI-SL Rollup Line Items (Actual)29MSLQuantitydecimal153
15GLSO1FI-SL Line Item Table with Objects for GLTO137MSLQuantitydecimal153
16GLSO2FI-SL Table with Objects, Structure corresponds to GLS245MSLQuantitydecimal153
17GLSO3FI-SL LI Table with Objects for GLTO337MSLQuantitydecimal173
TOPCollectionsDisbursements
18GLISDEAActual Line Item Tables for Insurance (DE)41MSLQuantitydecimal153
19GRISDEAActual Line Item Table for Insurance (DE) - Rollup41MSLQuantitydecimal153
TOPConsolidation
20ECMCASAP Cons.: Journal Entry Table (Actual)38MSLQuantitydecimal173
TOPCost Element Accounting
21COFISActual line items for reconciliation ledger41MSLQuantitydecimal153
TOPFinancial Services Localization
22/CEEIS/RUAActual line item table39MSLQuantitydecimal153
TOPFlexible Real Estate Management
23VIPRLEDTAGRAIsteinzelposten-Tabelle20MSLMengedecimal173
TOPFund Accounting
24FMGLFLEXAGeneral Ledger: Actual Line Items32MSLQuantitydecimal233
25PSGLFLEXAGeneral Ledger: Actual Line Items36MSLQuantitydecimal233
TOPGeneral Ledger Accounting
26FAGLFLEXAGeneral Ledger: Actual Line Items34MSLQuantitydecimal233
27FAGLSKFGeneral Ledger: Statistical Key Figures (Current Values)18MSLQuantitydecimal233
28FAGLSKF_PNGeneral Ledger; Statistical Key Figures (Source Document)20MSLQuantitydecimal233
29GLFLEXAFlexible general ledger: Actual line items33MSLQuantitydecimal233
TOPGrantee Management
30GMAVCAActual line item table29MSLQuantitydecimal153
31GMIAActual Line Item Table27MSLQuantitydecimal153
TOPJoint Venture und Production Sharing Accounting
32JVGLFLEXAGeneral Ledger: Actual Line Items36MSLQuantitydecimal233
33JVPSC01AActual line item table40MSLQuantitydecimal153
34JVSO1JV LI Table with Objects for JVTO138MSLQuantitydecimal153
35T8PSA_PREPOSTPreliminary Posting25MSLQuantitydecimal153
TOPLocalization
36J_3RFTAXRATax Accounting: Actual line item table41MSLQuantitydecimal153
37J_3RFTAXRVATax Accounting: Actual line item table41MSLQuantitydecimal153
TOPProfit Center Accounting
38GLPCAEC-PCA: Actual Line Items33MSLQuantitydecimal153
TOPRegulatory reporting for insurance companies
39ISSRFLDEAActual line item table62MSLQuantitydecimal173
TOPRemaining Beverage - Obsolete Objects
40/BEV3/CHFIAActual line item table26MSLQuantitydecimal153
41/BEV3/CHVGRAActual line item table28MSLQuantitydecimal153
TOPRetail Ledger
42PCRRETAILAActual line item table27MSLQuantitydecimal153
TOPSpecial Purpose Ledger
43/CCIS/PBU18APBU18: Actual line item table41MSLQuantitydecimal153
44/CCIS/PROFTAXAActual Line Items Table for General Ledger44MSLQuantitydecimal233
TOPTariffs, Duties and Permits
45OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger42MSLQuantitydecimal153
46OIHSLATDP (excise duty) special ledger actual line item table47MSLQuantitydecimal153
TOPTransfer to Financial Accounting
47TRACTSLAActual Line Item Table20MSLQuantitydecimal153