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

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

75 columns | Print definition?ERP 6.0  | TSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT37TSLBalance carried forward in transaction currencydecimal232
2FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT39TSLBalance carried forward in transaction currencydecimal232
3FAGLFLEXT_DIFDelta Table: G/L Totals39TSLValue in Transaction Currencydecimal232
4GLT0_DIFDelta Table: G/L Account Master Transaction Figures12TSLTotal transactions of the period in transaction currencydecimal152
5PYD_D_ALPayroll Data Source Framework: Action Log4TSLUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
6PYD_D_ALIPayroll Data Source Framework: Action Log Item4TSLUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
7PYD_D_DAE_TRACEPYDS: Scheduling Use Case Processing Trace2TSLUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
8T8PSA_RUII_HISTPSA Rollup II History (for produc split by volume)17TSLValue in Transaction Currencydecimal172
9ZSAWAActual line item table25TSLValue in Transaction Currencydecimal172
10ZSEMBPSAActual line item table21TSLValue in Transaction Currencydecimal172
11ZSPLITAIsteinzelposten-Tabelle25TSLWert in Transaktionswährungdecimal172
12ZZ001AActual Line Item Table32TSLValue in Transaction Currencydecimal172
13ZZLINEAActual line item table28TSLValue in Transaction Currencydecimal172
14ZZSL01AActual line item table34TSLValue in Transaction Currencydecimal172
15ZZSPECAActual line item table26TSLValue in Transaction Currencydecimal172
TOPAvailability Control
16FMAVCAActual line item table27TSLValue in Transaction Currencydecimal172
TOPBasic Functions
17FILCAFI-LC: Actual journal entry table with 2 object tables34TSLValue in Transaction Currencydecimal172
18GGREFAExample for Global FI-SL Line Items (Actual)27TSLValue in Transaction Currencydecimal172
19GLFUNCAActual Line Items Table for Cost of Sales Accounting26TSLValue in Transaction Currencydecimal172
20GLFUNCURollup line item tables with function area for IDES26TSLValue in Transaction Currencydecimal172
21GLREFAExample for Local FI-SL Line Items (Actual)25TSLValue in Transaction Currencydecimal172
22GLREFUExample for FI-SL Rollup Line Items (Actual)26TSLValue in Transaction Currencydecimal172
23GLSO1FI-SL Line Item Table with Objects for GLTO134TSLValue in Transaction Currencydecimal172
24GLSO2FI-SL Table with Objects, Structure corresponds to GLS242TSLValue in Transaction Currencydecimal172
25GLSO3FI-SL LI Table with Objects for GLTO334TSLValue in Transaction Currencydecimal172
TOPBudgeting
26FMBDAActual line item table28TSLValue in Transaction Currencydecimal172
27FMRBAActual line item table26TSLValue in Transaction Currencydecimal172
TOPCollectionsDisbursements
28GLISDEAActual Line Item Tables for Insurance (DE)38TSLValue in Transaction Currencydecimal172
29GRISDEAActual Line Item Table for Insurance (DE) - Rollup38TSLValue in Transaction Currencydecimal172
TOPConsolidation
30ECMCASAP Cons.: Journal Entry Table (Actual)35TSLValue in Transaction Currencydecimal172
TOPCost Element Accounting
31COFISActual line items for reconciliation ledger38TSLValue in Controlling Area Currencydecimal172
TOPData Retention Tool
32TXW_S_COFIRetrieve COFIS from archive20TSLAmount in transaction currencynvarchar190
TOPData Staging
33RSREQDPTIDNote TID for Request and Data Package3TSLUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPFinancial Accounting
34FBICRC001AICRC: Open Items GL Accounts: Documents20TSLValue in Transaction Currencydecimal172
35FBICRC002AICRC: GL Accounts: Documents20TSLValue in Transaction Currencydecimal172
36FBICRC003AICRC: Open Items Customers/Vendors: Documents21TSLValue in Transaction Currencydecimal172
TOPFinancial Services Localization
37/CEEIS/RUAActual line item table36TSLValue in Transaction Currencydecimal172
TOPFlexible Real Estate Management
38VIPRLEDTAGRAIsteinzelposten-Tabelle17TSLWert in Transaktionswährungdecimal172
TOPFund Accounting
39FMCCAVCAActual line item table24TSLValue in Transaction Currencydecimal172
40FMCCAVCRESERVECCAVC aux table for reserved items24TSLValue in Transaction Currencydecimal232
41FMGLFLEXAGeneral Ledger: Actual Line Items28TSLValue in Transaction Currencydecimal232
42PSGLFLEXAGeneral Ledger: Actual Line Items32TSLValue in Transaction Currencydecimal232
TOPFunds Management
43FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60030TSLValue in Transaction Currencydecimal172
44FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60034TSLValue in Transaction Currencydecimal172
45FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60030TSLValue in Transaction Currencydecimal172
46FMIAActual Line Item Table for Funds Management31TSLValue in Transaction Currencydecimal172
47FMSPLITAActual line item table32TSLValue in Transaction Currencydecimal172
48FMUSFGAActual line item table for US Federal Government.30TSLValue in Transaction Currencydecimal172
49FMUSFGFACTS1A4Actual line item table30TSLValue in Transaction Currencydecimal172
50FMUSFGFACTS2AActual line item table34TSLValue in Transaction Currencydecimal172
TOPGeneral Ledger Accounting
51FAGLFLEXAGeneral Ledger: Actual Line Items30TSLValue in Transaction Currencydecimal232
52FAGL_RSNAPSHOTReorganization: Snapshot15TSLValue in Transaction Currencydecimal232
53GLFLEXAFlexible general ledger: Actual line items29TSLValue in Transaction Currencydecimal232
TOPGrantee Management
54GMAVCAActual line item table26TSLValue in Transaction Currencydecimal172
55GMIAActual Line Item Table25TSLValue in Transaction Currencydecimal172
TOPJoint Venture und Production Sharing Accounting
56JVGLFLEXAGeneral Ledger: Actual Line Items32TSLValue in Transaction Currencydecimal232
57JVPSC01AActual line item table37TSLValue in Transaction Currencydecimal172
58JVSO1JV LI Table with Objects for JVTO135TSLValue in Transaction Currencydecimal172
59JVSO2JV Billing FI-SL Line Item21TSLValue in Transaction Currencydecimal172
60T8PSA_COST_ADJPSA Cost Adjustment24TSLValue in Transaction Currencydecimal172
61T8PSA_PREPOSTPreliminary Posting24TSLValue in Transaction Currencydecimal172
TOPLocalization
62J_3RFTAXRATax Accounting: Actual line item table39TSLValue in Transaction Currencydecimal172
63J_3RFTAXRVATax Accounting: Actual line item table39TSLValue in Transaction Currencydecimal172
TOPProfit Center Accounting
64GLPCAEC-PCA: Actual Line Items30TSLAmount in transaction currencydecimal152
TOPRegulatory reporting for insurance companies
65ISSRFLDEAActual line item table59TSLValue in Transaction Currencydecimal172
66ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle18TSLBestandsverändernder Betrag in Transaktionswährungdecimal172
TOPRemaining Beverage - Obsolete Objects
67/BEV3/CHFIAActual line item table23TSLValue in Transaction Currencydecimal172
68/BEV3/CHVGRAActual line item table25TSLValue in Transaction Currencydecimal172
TOPRetail Ledger
69PCRRETAILAActual line item table24TSLValue in Transaction Currencydecimal172
TOPSpecial Purpose Ledger
70/CCIS/PBU18APBU18: Actual line item table38TSLValue in Transaction Currencydecimal172
71/CCIS/PROFTAXAActual Line Items Table for General Ledger40TSLValue in Transaction Currencydecimal232
TOPTariffs, Duties and Permits
72OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger39TSLValue in Transaction Currencydecimal172
73OIHSLATDP (excise duty) special ledger actual line item table44TSLValue in Transaction Currencydecimal172
TOPTransfer to Financial Accounting
74TRACTSLAActual Line Item Table17TSLValue in Transaction Currencydecimal172
TOPWeb Service and SOAP - ABAP
75SRT_TRACEKEYSTrace Keys4TSLUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217