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
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
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

209 columns | Print definition?ERP 6.0  | RTCUR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances8RTCURnvarchar50
2/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.8RTCURnvarchar50
3/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs8RTCURnvarchar50
4/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)8RTCURnvarchar50
5FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT17RTCURCurrency Keynvarchar50
6FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT19RTCURCurrency Keynvarchar50
7FAGLFLEXT_BAKGeneral Ledger: Totals16RTCURCurrency Keynvarchar50
8FAGLFLEXT_DIFDelta Table: G/L Totals16RTCURCurrency Keynvarchar50
9GLPCA_CTProfit Center Documents112RTCURCurrency Keynvarchar50
10GLPCA_T_CTProfit Center Documents128RTCURCurrency Keynvarchar50
11GLPOS_N_CTNew General Ledger: Line Item with Currency Type223RTCURCurrency Keynvarchar50
12GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type223RTCURCurrency Keynvarchar50
13GLT0_BAKG/L Account Master Record Transaction Figures9RTCURCurrency Keynvarchar50
14GLT0_DIFDelta Table: G/L Account Master Transaction Figures9RTCURCurrency Keynvarchar50
15T8PSA_RUII_HISTPSA Rollup II History (for produc split by volume)16RTCURCurrency Keynvarchar50
16TSTGCConsolidation test data12RTCURCurrency Keynvarchar50
17ZSAWAActual line item table7RTCURCurrency Keynvarchar50
18ZSAWPPlan line items table7RTCURCurrency Keynvarchar50
19ZSAWTSummary table9RTCURCurrency Keynvarchar50
20ZSEMBPSAActual line item table7RTCURCurrency Keynvarchar50
21ZSEMBPSPPlan line items table7RTCURCurrency Keynvarchar50
22ZSEMBPSTSummary table9RTCURCurrency Keynvarchar50
23ZSPLITAIsteinzelposten-Tabelle7RTCURWährungsschlüsselnvarchar50
24ZSPLITPPlaneinzelposten-Tabelle7RTCURWährungsschlüsselnvarchar50
25ZSPLITTSummentabelle9RTCURWährungsschlüsselnvarchar50
26ZZ001AActual Line Item Table7RTCURCurrency Keynvarchar50
27ZZ001PPlan Line Items Table7RTCURCurrency Keynvarchar50
28ZZ001TSummary Table9RTCURCurrency Keynvarchar50
29ZZLINEAActual line item table7RTCURCurrency Keynvarchar50
30ZZLINEPPlan line items table7RTCURCurrency Keynvarchar50
31ZZLINETSummary table9RTCURCurrency Keynvarchar50
32ZZSL01AActual line item table7RTCURCurrency Keynvarchar50
33ZZSL01PPlan line items table7RTCURCurrency Keynvarchar50
34ZZSL01TSummary table9RTCURCurrency Keynvarchar50
35ZZSPECAActual line item table7RTCURCurrency Keynvarchar50
36ZZSPECPPlan line item table7RTCURCurrency Keynvarchar50
37ZZSPECTSummary table8RTCURCurrency Keynvarchar50
TOPAvailability Control
38FMAVCAActual line item table7RTCURCurrency Keynvarchar50
39FMAVCPPlan line items table7RTCURCurrency Keynvarchar50
40FMAVCTAVC Summary Table (BCS)9RTCURCurrency Keynvarchar50
TOPBasic Functions
41FILCAFI-LC: Actual journal entry table with 2 object tables7RTCURCurrency Keynvarchar50
42FILCPFI-LC: Plan line items for object table7RTCURCurrency Keynvarchar50
43FILCTFI-LC: Global totals table with 2 object tables9RTCURCurrency Keynvarchar50
44GGREFAExample for Global FI-SL Line Items (Actual)7RTCURCurrency Keynvarchar50
45GGREFPExample for Global FI-SL Line Items (Plan)7RTCURCurrency Keynvarchar50
46GGREFTExample for Global FI-SL Summary Table9RTCURCurrency Keynvarchar50
47GLFUNCAActual Line Items Table for Cost of Sales Accounting7RTCURCurrency Keynvarchar50
48GLFUNCPPlan Line Items Table for Cost of Sales Accounting7RTCURCurrency Keynvarchar50
49GLFUNCTTotals Table for Cost of Sales Accounting9RTCURCurrency Keynvarchar50
50GLFUNCURollup line item tables with function area for IDES7RTCURCurrency Keynvarchar50
51GLFUNCVRollup plan line items table with function area for IDES7RTCURCurrency Keynvarchar50
52GLP0Local Logical General Ledger Plan Line Items9RTCURCurrency Keynvarchar50
53GLPO1Plan Line Items for Object Table9RTCURCurrency Keynvarchar50
54GLPO2Plan Line Items for Object Table Global9RTCURCurrency Keynvarchar50
55GLPO3Plan Line Items for Object Table9RTCURCurrency Keynvarchar50
56GLREFAExample for Local FI-SL Line Items (Actual)7RTCURCurrency Keynvarchar50
57GLREFPExample for Local FI-SL Line Items (Plan)7RTCURCurrency Keynvarchar50
58GLREFTExample for Local FI-SL Summary Table9RTCURCurrency Keynvarchar50
59GLREFUExample for FI-SL Rollup Line Items (Actual)7RTCURCurrency Keynvarchar50
60GLREFVExample for Rollup FI-SL Line Items (Plan)7RTCURCurrency Keynvarchar50
61GLSO1FI-SL Line Item Table with Objects for GLTO19RTCURCurrency Keynvarchar50
62GLSO2FI-SL Table with Objects, Structure corresponds to GLS29RTCURCurrency Keynvarchar50
63GLSO3FI-SL LI Table with Objects for GLTO39RTCURCurrency Keynvarchar50
64GLT0G/L account master record transaction figures9RTCURCurrency Keynvarchar50
65GLT3Summary Data Preparations for Consolidation14RTCURCurrency Keynvarchar50
66GLTO1FI-SL Table with Objects, Structure Corresponds to GLT19RTCURCurrency Keynvarchar50
67GLTO2FI-SL Table with Objects, Structure Corresponds to GLT29RTCURCurrency Keynvarchar50
68GLTO3FISL Table with Objects, Amounts and Quantities in Format P99RTCURCurrency Keynvarchar50
TOPBudgeting
69FMBDAActual line item table7RTCURCurrency Keynvarchar50
70FMBDPFM Budget change line items table7RTCURCurrency Keynvarchar50
71FMBDTFM budget totals table9RTCURCurrency Keynvarchar50
72FMCY_COPIFor CO plan data transfer15RTCURCurrency Keynvarchar50
73FMRBAActual line item table7RTCURCurrency Keynvarchar50
74FMRBPPlan line items table7RTCURCurrency Keynvarchar50
75FMRBTSummary table9RTCURCurrency Keynvarchar50
TOPCollectionsDisbursements
76GLISDEAActual Line Item Tables for Insurance (DE)7RTCURCurrency Keynvarchar50
77GLISDEPPlan Line Item Table for Insurance (DE)7RTCURCurrency Keynvarchar50
78GLISDETSummary Table for Insurance (DE)9RTCURCurrency Keynvarchar50
79GRISDEAActual Line Item Table for Insurance (DE) - Rollup7RTCURCurrency Keynvarchar50
80GRISDEPPlan Line Item Table for Insurance (DE) - Rollup7RTCURCurrency Keynvarchar50
81GRISDETSummary Table for Insurance (DE) - Rollup9RTCURCurrency Keynvarchar50
TOPConsolidation
82ECMCASAP Cons.: Journal Entry Table (Actual)7RTCURCurrency Keynvarchar50
83ECMCTSAP Cons.: Totals Table9RTCURCurrency Keynvarchar50
TOPCost Element Accounting
84COFIPSingle plan items for reconciliation ledger7RTCURCurrency Key for Amounts in Controlling Area Currencynvarchar50
85COFISActual line items for reconciliation ledger7RTCURCurrency Key for Amounts in Controlling Area Currencynvarchar50
86COFITTotals Records for Reconciliation Ledger9RTCURCurrency Key for Amounts in Controlling Area Currencynvarchar50
TOPData Retention Tool
87TXW_S_COFIRetrieve COFIS from archive19RTCURCurrency Key for Amounts in Controlling Area Currencynvarchar50
88TXW_S_GLT0Retrieve archived GLT0 data9RTCURCurrency Keynvarchar50
TOPFinancial Accounting
89FBICRC001AICRC: Open Items GL Accounts: Documents7RTCURCurrency Keynvarchar50
90FBICRC001PNot in use7RTCURCurrency Keynvarchar50
91FBICRC001TICRC: Open Items GL Accounts: Totals9RTCURCurrency Keynvarchar50
92FBICRC002AICRC: GL Accounts: Documents7RTCURCurrency Keynvarchar50
93FBICRC002PNot in use7RTCURCurrency Keynvarchar50
94FBICRC002TICRC: GL Accounts: Totals9RTCURCurrency Keynvarchar50
95FBICRC003AICRC: Open Items Customers/Vendors: Documents7RTCURCurrency Keynvarchar50
96FBICRC003PNot in use7RTCURCurrency Keynvarchar50
97FBICRC003TICRC: Open Items Customers/Vendors: Totals9RTCURCurrency Keynvarchar50
TOPFinancial Services Localization
98/CEEIS/RUAActual line item table7RTCURCurrency Keynvarchar50
99/CEEIS/RUPPlan line items table7RTCURCurrency Keynvarchar50
100/CEEIS/RUTTotals Table9RTCURCurrency Keynvarchar50
TOPFlexible Real Estate Management
101VIPRLEDTAGRAIsteinzelposten-Tabelle7RTCURWährungsschlüsselnvarchar50
102VIPRLEDTAGRPPlaneinzelposten-Tabelle7RTCURWährungsschlüsselnvarchar50
103VIPRLEDTAGRTSummentabelle Ledger 7A Mandate8RTCURWährungsschlüsselnvarchar50
TOPFund Accounting
104FMCCAVCAActual line item table7RTCURCurrency Keynvarchar50
105FMCCAVCPPlan line items table7RTCURCurrency Keynvarchar50
106FMCCAVCTTotals Table9RTCURCurrency Keynvarchar50
107FMGLFLEX00General ledger: Transaction attributes4RTCURCurrency Keynvarchar50
108FMGLFLEXAGeneral Ledger: Actual Line Items9RTCURCurrency Keynvarchar50
109FMGLFLEXPGeneral Ledger: Plan Line Items11RTCURCurrency Keynvarchar50
110FMGLFLEXTGeneral Ledger Public Sector: Total16RTCURCurrency Keynvarchar50
111PSGLFLEX00General ledger: Transaction attributes4RTCURCurrency Keynvarchar50
112PSGLFLEXAGeneral Ledger: Actual Line Items9RTCURCurrency Keynvarchar50
113PSGLFLEXPGeneral Ledger: Plan Line Items11RTCURCurrency Keynvarchar50
114PSGLFLEXTGeneral Ledger Public Sector: Total16RTCURCurrency Keynvarchar50
TOPFunds Management
115FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 6007RTCURCurrency Keynvarchar50
116FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 6007RTCURCurrency Keynvarchar50
117FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 6007RTCURCurrency Keynvarchar50
118FMIAActual Line Item Table for Funds Management7RTCURCurrency Keynvarchar50
119FMIPPlan Line Items Table for Funds Management7RTCURCurrency Keynvarchar50
120FMITTotals Table for Funds Management9RTCURCurrency Keynvarchar50
121FMSPLITAActual line item table7RTCURCurrency Keynvarchar50
122FMSPLITPPlan line items table7RTCURCurrency Keynvarchar50
123FMSPLITTSummary table9RTCURCurrency Keynvarchar50
124FMUSFGAActual line item table for US Federal Government.7RTCURCurrency Keynvarchar50
125FMUSFGFACTS1A4Actual line item table7RTCURCurrency Keynvarchar50
126FMUSFGFACTS1PPlan line items table7RTCURCurrency Keynvarchar50
127FMUSFGFACTS1TSummary table9RTCURCurrency Keynvarchar50
128FMUSFGFACTS2AActual line item table7RTCURCurrency Keynvarchar50
129FMUSFGFACTS2PPlan line items table7RTCURCurrency Keynvarchar50
130FMUSFGFACTS2TSummary table9RTCURCurrency Keynvarchar50
131FMUSFGPPlan line items table7RTCURCurrency Keynvarchar50
132FMUSFGTSummary table for US Federal Government9RTCURCurrency Keynvarchar50
TOPGeneral Ledger Accounting
133FAGLFLEX00General ledger: Transaction attributes4RTCURCurrency Keynvarchar50
134FAGLFLEXAGeneral Ledger: Actual Line Items9RTCURCurrency Keynvarchar50
135FAGLFLEXPGeneral Ledger: Plan Line Items11RTCURCurrency Keynvarchar50
136FAGLFLEXTGeneral Ledger: Totals16RTCURCurrency Keynvarchar50
137FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records9RTCURCurrency Keynvarchar50
138FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis7RTCURCurrency Keynvarchar50
139FAGL_RSNAPSHOTReorganization: Snapshot7RTCURCurrency Keynvarchar50
140GLFLEX07General ledger: Transaction attributes4RTCURCurrency Keynvarchar50
141GLFLEXAFlexible general ledger: Actual line items26RTCURCurrency Keynvarchar50
142GLFLEXPFlexible G/L: Plan line items26RTCURCurrency Keynvarchar50
143GLFLEXTFlexible G/L: Totals32RTCURCurrency Keynvarchar50
TOPGrantee Management
144GMAVCAActual line item table7RTCURCurrency Keynvarchar50
145GMAVCPPlan line items table7RTCURCurrency Keynvarchar50
146GMAVCTSummary table9RTCURCurrency Keynvarchar50
147GMIAActual Line Item Table7RTCURCurrency Keynvarchar50
148GMIPPlan line items table7RTCURCurrency Keynvarchar50
149GMITSummary table9RTCURCurrency Keynvarchar50
TOPJoint Venture und Production Sharing Accounting
150JVGLFLEX00General ledger: Transaction attributes4RTCURCurrency Keynvarchar50
151JVGLFLEXAGeneral Ledger: Actual Line Items9RTCURCurrency Keynvarchar50
152JVGLFLEXPGeneral Ledger: Plan Line Items11RTCURCurrency Keynvarchar50
153JVGLFLEXTGeneral Ledger: Totals16RTCURCurrency Keynvarchar50
154JVPO1JVA: Plan Line Items7RTCURCurrency Keynvarchar50
155JVPSC01AActual line item table7RTCURCurrency Keynvarchar50
156JVPSC01PPlan line item table7RTCURCurrency Keynvarchar50
157JVPSC01TSummary table9RTCURCurrency Keynvarchar50
158JVSO1JV LI Table with Objects for JVTO17RTCURCurrency Keynvarchar50
159JVSO2JV Billing FI-SL Line Item7RTCURCurrency Keynvarchar50
160JVT1JV Summary Table14RTCURCurrency Keynvarchar50
161JVTO1JV Summary Table with Objects9RTCURCurrency Keynvarchar50
162JVTO2JV Billing FI-SL Summary Table8RTCURCurrency Keynvarchar50
163T8JTPMJoint Venture Production Month Summary Data8RTCURCurrency Keynvarchar50
164T8PSA_COST_ADJPSA Cost Adjustment23RTCURCurrency Keynvarchar50
165T8PSA_CURR_TYPEPSA Currency and Exchange Rate Types5RTCURCurrency Keynvarchar50
166T8PSA_PREPOSTPreliminary Posting8RTCURCurrency Keynvarchar50
167T8PSA_TERMTerminal Master Data4RTCURCurrency Keynvarchar50
TOPLocal Currency Changeover
168EWUFI_BALEMU conversion: Logging transaction figures change9RTCURCurrency Keynvarchar50
169EWUFI_BALPEMU conversion: Logging transaction figures change10RTCURCurrency Keynvarchar50
TOPLocalization
170J_3RFTAXRATax Accounting: Actual line item table7RTCURCurrency Keynvarchar50
171J_3RFTAXRPTax Accounting: Plan line item table7RTCURCurrency Keynvarchar50
172J_3RFTAXRTTax Accounting: Summary table8RTCURCurrency Keynvarchar50
173J_3RFTAXRVATax Accounting: Actual line item table7RTCURCurrency Keynvarchar50
174J_3RFTAXRVPTax Accounting: Plan line item table7RTCURCurrency Keynvarchar50
175J_3RFTAXRVTTax Accounting: Summary table8RTCURCurrency Keynvarchar50
TOPProfit Center Accounting
176GLPCAEC-PCA: Actual Line Items7RTCURCurrency Keynvarchar50
177GLPCPEC-PCA: Plan Line Items7RTCURCurrency Keynvarchar50
178GLPCTEC-PCA: Totals Table9RTCURCurrency Keynvarchar50
179T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material9RTCURCurrency Keynvarchar50
TOPProfitability Analysis
180GLTPCProfit Center Accounting11RTCURCurrency Keynvarchar50
TOPRegulatory reporting for insurance companies
181ISSRFLDEAActual line item table7RTCURCurrency Keynvarchar50
182ISSRFLDEPPlan line items table7RTCURCurrency Keynvarchar50
183ISSRFLDETSummary table9RTCURCurrency Keynvarchar50
TOPRemaining Beverage - Obsolete Objects
184/BEV3/CHFIAActual line item table7RTCURCurrency Keynvarchar50
185/BEV3/CHFIPPlan Line Items Table7RTCURCurrency Keynvarchar50
186/BEV3/CHFITTotals table9RTCURCurrency Keynvarchar50
187/BEV3/CHVGRAActual line item table7RTCURCurrency Keynvarchar50
188/BEV3/CHVGRPPlan Line Items Table7RTCURCurrency Keynvarchar50
189/BEV3/CHVGRTTotals table9RTCURCurrency Keynvarchar50
TOPRetail Ledger
190PCRRETAILAActual line item table7RTCURCurrency Keynvarchar50
191PCRRETAILPPlan line items table7RTCURCurrency Keynvarchar50
192PCRRETAILTTotals Table9RTCURCurrency Keynvarchar50
TOPSets
193T800SFI-SL Set Table (before Release 4.0)15RTCURCurrency Keynvarchar50
TOPSpecial Purpose Ledger
194/CCIS/PBU18APBU18: Actual line item table7RTCURCurrency Keynvarchar50
195/CCIS/PBU18PPBU18: Plan line item table7RTCURCurrency Keynvarchar50
196/CCIS/PBU18TPBU18: Summary table x9RTCURCurrency Keynvarchar50
197/CCIS/PROFTAX00Object Table Number:004RTCURCurrency Keynvarchar50
198/CCIS/PROFTAXAActual Line Items Table for General Ledger9RTCURCurrency Keynvarchar50
199/CCIS/PROFTAXPPlan Line Items Table for General Ledger11RTCURCurrency Keynvarchar50
200/CCIS/PROFTAXTTotals Table for General Ledger16RTCURCurrency Keynvarchar50
TOPTariffs, Duties and Permits
201OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger7RTCURCurrency Keynvarchar50
202OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger7RTCURCurrency Keynvarchar50
203OIHEDTSummary table, IS-OIL Excise Duty Special Ledger9RTCURCurrency Keynvarchar50
204OIHSLATDP (excise duty) special ledger actual line item table7RTCURCurrency Keynvarchar50
205OIHSLTTDP (excise duty) special ledger summary table8RTCURCurrency Keynvarchar50
TOPTechnical Application Support
206CNV_20425_BALEMU conversion: Logging transaction figures change6RTCURCurrency Keynvarchar50
TOPTransfer to Financial Accounting
207TRACTSLAActual Line Item Table7RTCURCurrency Keynvarchar50
208TRACTSLPPlan Line Items Table7RTCURCurrency Keynvarchar50
209TRACTSLTTotals Table9RTCURCurrency Keynvarchar50