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

218 columns | Print definition?ERP 6.0  | RRCTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/GL4ACalculation Version Assignment3RRCTYRecord Typenvarchar10
2/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items169RRCTYnvarchar10
3/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.11RRCTYnvarchar10
4/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs12RRCTYnvarchar10
5/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)12RRCTYnvarchar10
6FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT20RRCTYRecord Typenvarchar10
7FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT22RRCTYRecord Typenvarchar10
8FAGLFLEXT_BAKGeneral Ledger: Totals20RRCTYRecord Typenvarchar10
9FAGLFLEXT_DIFDelta Table: G/L Totals20RRCTYRecord Typenvarchar10
10GLPCA_CTProfit Center Documents110RRCTYRecord Typenvarchar10
11GLPCA_T_CTProfit Center Documents126RRCTYRecord Typenvarchar10
12GLPOS_N_CTNew General Ledger: Line Item with Currency Type221RRCTYRecord Typenvarchar10
13GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type221RRCTYRecord Typenvarchar10
14GLT0_BAKG/L Account Master Record Transaction Figures3RRCTYRecord Typenvarchar10
15GLT0_DIFDelta Table: G/L Account Master Transaction Figures3RRCTYRecord Typenvarchar10
16T8PSA_RUII_HISTPSA Rollup II History (for produc split by volume)3RRCTYRecord Typenvarchar10
17ZSAWAActual line item table4RRCTYRecord Typenvarchar10
18ZSAWPPlan line items table4RRCTYRecord Typenvarchar10
19ZSAWTSummary table3RRCTYRecord Typenvarchar10
20ZSEMBPSAActual line item table4RRCTYRecord Typenvarchar10
21ZSEMBPSPPlan line items table4RRCTYRecord Typenvarchar10
22ZSEMBPSTSummary table3RRCTYRecord Typenvarchar10
23ZSPLITAIsteinzelposten-Tabelle4RRCTYSatzartnvarchar10
24ZSPLITPPlaneinzelposten-Tabelle4RRCTYSatzartnvarchar10
25ZSPLITTSummentabelle3RRCTYSatzartnvarchar10
26ZZ001AActual Line Item Table4RRCTYRecord Typenvarchar10
27ZZ001PPlan Line Items Table4RRCTYRecord Typenvarchar10
28ZZ001TSummary Table3RRCTYRecord Typenvarchar10
29ZZLINEAActual line item table4RRCTYRecord Typenvarchar10
30ZZLINEPPlan line items table4RRCTYRecord Typenvarchar10
31ZZLINETSummary table3RRCTYRecord Typenvarchar10
32ZZSL01AActual line item table4RRCTYRecord Typenvarchar10
33ZZSL01PPlan line items table4RRCTYRecord Typenvarchar10
34ZZSL01TSummary table3RRCTYRecord Typenvarchar10
35ZZSPECAActual line item table4RRCTYRecord Typenvarchar10
36ZZSPECPPlan line item table4RRCTYRecord Typenvarchar10
37ZZSPECTSummary table3RRCTYRecord Typenvarchar10
TOPAvailability Control
38FMAVCAActual line item table4RRCTYRecord Typenvarchar10
39FMAVCPPlan line items table4RRCTYRecord Typenvarchar10
40FMAVCTAVC Summary Table (BCS)3RRCTYRecord Typenvarchar10
TOPBasic Functions
41FILCAFI-LC: Actual journal entry table with 2 object tables4RRCTYRecord Typenvarchar10
42FILCPFI-LC: Plan line items for object table4RRCTYRecord Typenvarchar10
43FILCTFI-LC: Global totals table with 2 object tables3RRCTYRecord Typenvarchar10
44GGREFAExample for Global FI-SL Line Items (Actual)4RRCTYRecord Typenvarchar10
45GGREFPExample for Global FI-SL Line Items (Plan)4RRCTYRecord Typenvarchar10
46GGREFTExample for Global FI-SL Summary Table3RRCTYRecord Typenvarchar10
47GLFUNCAActual Line Items Table for Cost of Sales Accounting4RRCTYRecord Typenvarchar10
48GLFUNCPPlan Line Items Table for Cost of Sales Accounting4RRCTYRecord Typenvarchar10
49GLFUNCTTotals Table for Cost of Sales Accounting3RRCTYRecord Typenvarchar10
50GLFUNCURollup line item tables with function area for IDES4RRCTYRecord Typenvarchar10
51GLFUNCVRollup plan line items table with function area for IDES4RRCTYRecord Typenvarchar10
52GLIDXAIndex to Find FI-SL Documents Based on AWKEY10RRCTYRecord Typenvarchar10
53GLP0Local Logical General Ledger Plan Line Items3RRCTYRecord Typenvarchar10
54GLPO1Plan Line Items for Object Table3RRCTYRecord Typenvarchar10
55GLPO2Plan Line Items for Object Table Global3RRCTYRecord Typenvarchar10
56GLPO3Plan Line Items for Object Table3RRCTYRecord Typenvarchar10
57GLREFAExample for Local FI-SL Line Items (Actual)4RRCTYRecord Typenvarchar10
58GLREFPExample for Local FI-SL Line Items (Plan)4RRCTYRecord Typenvarchar10
59GLREFTExample for Local FI-SL Summary Table3RRCTYRecord Typenvarchar10
60GLREFUExample for FI-SL Rollup Line Items (Actual)4RRCTYRecord Typenvarchar10
61GLREFVExample for Rollup FI-SL Line Items (Plan)4RRCTYRecord Typenvarchar10
62GLSO1FI-SL Line Item Table with Objects for GLTO13RRCTYRecord Typenvarchar10
63GLSO2FI-SL Table with Objects, Structure corresponds to GLS23RRCTYRecord Typenvarchar10
64GLSO3FI-SL LI Table with Objects for GLTO33RRCTYRecord Typenvarchar10
65GLT0G/L account master record transaction figures3RRCTYRecord Typenvarchar10
66GLT3Summary Data Preparations for Consolidation3RRCTYRecord Typenvarchar10
67GLTO1FI-SL Table with Objects, Structure Corresponds to GLT13RRCTYRecord Typenvarchar10
68GLTO2FI-SL Table with Objects, Structure Corresponds to GLT23RRCTYRecord Typenvarchar10
69GLTO3FISL Table with Objects, Amounts and Quantities in Format P93RRCTYRecord Typenvarchar10
70SMFISLSpec. FI-SL Data in Monitor (See Schedman_specific_fisl)6RRCTYRecord Typenvarchar10
71T001CValid Posting Periods for Global Companies2RRCTYRecord Typenvarchar10
72T807RFI-SL Rollup: History of Executions7RRCTYRecord Typenvarchar10
73T863WValuations3RRCTYRecord Typenvarchar10
74T863YINDX datasets7RRCTYRecord Typenvarchar10
TOPBudgeting
75FMBDAActual line item table4RRCTYRecord Typenvarchar10
76FMBDPFM Budget change line items table4RRCTYRecord Typenvarchar10
77FMBDTFM budget totals table3RRCTYRecord Typenvarchar10
78FMRBAActual line item table4RRCTYRecord Typenvarchar10
79FMRBPPlan line items table4RRCTYRecord Typenvarchar10
80FMRBTSummary table3RRCTYRecord Typenvarchar10
TOPCollectionsDisbursements
81GLISDEAActual Line Item Tables for Insurance (DE)4RRCTYRecord Typenvarchar10
82GLISDEPPlan Line Item Table for Insurance (DE)4RRCTYRecord Typenvarchar10
83GLISDETSummary Table for Insurance (DE)3RRCTYRecord Typenvarchar10
84GRISDEAActual Line Item Table for Insurance (DE) - Rollup4RRCTYRecord Typenvarchar10
85GRISDEPPlan Line Item Table for Insurance (DE) - Rollup4RRCTYRecord Typenvarchar10
86GRISDETSummary Table for Insurance (DE) - Rollup3RRCTYRecord Typenvarchar10
TOPConsolidation
87ECMCASAP Cons.: Journal Entry Table (Actual)4RRCTYRecord Typenvarchar10
88ECMCTSAP Cons.: Totals Table3RRCTYRecord Typenvarchar10
TOPCost Element Accounting
89COFIPSingle plan items for reconciliation ledger4RRCTYRecord Typenvarchar10
90COFISActual line items for reconciliation ledger4RRCTYRecord Typenvarchar10
91COFITTotals Records for Reconciliation Ledger3RRCTYRecord Typenvarchar10
TOPData Retention Tool
92TXW_S_GLT0Retrieve archived GLT0 data3RRCTYRecord Typenvarchar10
TOPFinancial Accounting
93AC400T001BP02 Schulung AC400 Periodenwechselstichtage2RRCTYSatzartnvarchar10
94FBICRC001AICRC: Open Items GL Accounts: Documents4RRCTYRecord Typenvarchar10
95FBICRC001PNot in use4RRCTYRecord Typenvarchar10
96FBICRC001TICRC: Open Items GL Accounts: Totals3RRCTYRecord Typenvarchar10
97FBICRC002AICRC: GL Accounts: Documents4RRCTYRecord Typenvarchar10
98FBICRC002PNot in use4RRCTYRecord Typenvarchar10
99FBICRC002TICRC: GL Accounts: Totals3RRCTYRecord Typenvarchar10
100FBICRC003AICRC: Open Items Customers/Vendors: Documents4RRCTYRecord Typenvarchar10
101FBICRC003PNot in use4RRCTYRecord Typenvarchar10
102FBICRC003TICRC: Open Items Customers/Vendors: Totals3RRCTYRecord Typenvarchar10
103FERC_R0Execution history6RRCTYRecord typenvarchar10
104T001BPermitted Posting Periods2RRCTYRecord Typenvarchar10
TOPFinancial Services Localization
105/CEEIS/RUAActual line item table4RRCTYRecord Typenvarchar10
106/CEEIS/RUPPlan line items table4RRCTYRecord Typenvarchar10
107/CEEIS/RUTTotals Table3RRCTYRecord Typenvarchar10
TOPFlexible Real Estate Management
108VIPRLEDTAGRAIsteinzelposten-Tabelle4RRCTYSatzartnvarchar10
109VIPRLEDTAGRPPlaneinzelposten-Tabelle4RRCTYSatzartnvarchar10
110VIPRLEDTAGRTSummentabelle Ledger 7A Mandate3RRCTYSatzartnvarchar10
TOPFund Accounting
111FMCCAVCAActual line item table4RRCTYRecord Typenvarchar10
112FMCCAVCPPlan line items table4RRCTYRecord Typenvarchar10
113FMCCAVCTTotals Table3RRCTYRecord Typenvarchar10
114FMGLFLEX01General ledger: Technical fields3RRCTYRecord Typenvarchar10
115FMGLFLEXAGeneral Ledger: Actual Line Items12RRCTYRecord Typenvarchar10
116FMGLFLEXPGeneral Ledger: Plan Line Items14RRCTYRecord Typenvarchar10
117FMGLFLEXTGeneral Ledger Public Sector: Total20RRCTYRecord Typenvarchar10
118PSGLFLEX01General ledger: Technical fields3RRCTYRecord Typenvarchar10
119PSGLFLEXAGeneral Ledger: Actual Line Items12RRCTYRecord Typenvarchar10
120PSGLFLEXPGeneral Ledger: Plan Line Items14RRCTYRecord Typenvarchar10
121PSGLFLEXTGeneral Ledger Public Sector: Total20RRCTYRecord Typenvarchar10
122T001B_PSAccount Assignment Objects in General Ledger2RRCTYRecord Typenvarchar10
123T001B_PS_PERPermitted Posting Periods for Account Assignment Objects2RRCTYRecord Typenvarchar10
TOPFunds Management
124FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 6004RRCTYRecord Typenvarchar10
125FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 6004RRCTYRecord Typenvarchar10
126FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 6004RRCTYRecord Typenvarchar10
127FMFG_SAV_GLIDXASaved GLIDXA data for docs excluded from SL Repost for 60010RRCTYRecord Typenvarchar10
128FMIAActual Line Item Table for Funds Management4RRCTYRecord Typenvarchar10
129FMIPPlan Line Items Table for Funds Management4RRCTYRecord Typenvarchar10
130FMITTotals Table for Funds Management3RRCTYRecord Typenvarchar10
131FMSPLITAActual line item table4RRCTYRecord Typenvarchar10
132FMSPLITPPlan line items table4RRCTYRecord Typenvarchar10
133FMSPLITTSummary table3RRCTYRecord Typenvarchar10
134FMUSFGAActual line item table for US Federal Government.4RRCTYRecord Typenvarchar10
135FMUSFGFACTS1A4Actual line item table4RRCTYRecord Typenvarchar10
136FMUSFGFACTS1PPlan line items table4RRCTYRecord Typenvarchar10
137FMUSFGFACTS1TSummary table3RRCTYRecord Typenvarchar10
138FMUSFGFACTS2AActual line item table4RRCTYRecord Typenvarchar10
139FMUSFGFACTS2PPlan line items table4RRCTYRecord Typenvarchar10
140FMUSFGFACTS2TSummary table3RRCTYRecord Typenvarchar10
141FMUSFGPPlan line items table4RRCTYRecord Typenvarchar10
142FMUSFGTSummary table for US Federal Government3RRCTYRecord Typenvarchar10
TOPGeneral Ledger Accounting
143FAGLFLEX01General ledger: Technical fields3RRCTYRecord Typenvarchar10
144FAGLFLEXAGeneral Ledger: Actual Line Items12RRCTYRecord Typenvarchar10
145FAGLFLEXPGeneral Ledger: Plan Line Items14RRCTYRecord Typenvarchar10
146FAGLFLEXTGeneral Ledger: Totals20RRCTYRecord Typenvarchar10
147FAGLSKFGeneral Ledger: Statistical Key Figures (Current Values)16RRCTYRecord Typenvarchar10
148FAGLSKF_PNGeneral Ledger; Statistical Key Figures (Source Document)18RRCTYRecord Typenvarchar10
149FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records13RRCTYRecord Typenvarchar10
150FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis11RRCTYRecord Typenvarchar10
151GLFLEX01General ledger: Technical fields2RRCTYRecord Typenvarchar10
152GLFLEXAFlexible general ledger: Actual line items10RRCTYRecord Typenvarchar10
153GLFLEXPFlexible G/L: Plan line items10RRCTYRecord Typenvarchar10
154GLFLEXTFlexible G/L: Totals16RRCTYRecord Typenvarchar10
TOPGeneral Ledger Reorganization
155FAGL_R_PER_TRACKReorganization: Log of Changed Posting Periods4RRCTYRecord Typenvarchar10
TOPGrantee Management
156GMAVCAActual line item table4RRCTYRecord Typenvarchar10
157GMAVCPPlan line items table4RRCTYRecord Typenvarchar10
158GMAVCTSummary table3RRCTYRecord Typenvarchar10
159GMIAActual Line Item Table4RRCTYRecord Typenvarchar10
160GMIPPlan line items table4RRCTYRecord Typenvarchar10
161GMITSummary table3RRCTYRecord Typenvarchar10
TOPJoint Venture und Production Sharing Accounting
162JVGLFLEX01General ledger: Technical fields3RRCTYRecord Typenvarchar10
163JVGLFLEXAGeneral Ledger: Actual Line Items12RRCTYRecord Typenvarchar10
164JVGLFLEXPGeneral Ledger: Plan Line Items14RRCTYRecord Typenvarchar10
165JVGLFLEXTGeneral Ledger: Totals20RRCTYRecord Typenvarchar10
166JVPO1JVA: Plan Line Items4RRCTYRecord Typenvarchar10
167JVPSC01AActual line item table4RRCTYRecord Typenvarchar10
168JVPSC01PPlan line item table4RRCTYRecord Typenvarchar10
169JVPSC01TSummary table3RRCTYRecord Typenvarchar10
170JVSO1JV LI Table with Objects for JVTO14RRCTYRecord Typenvarchar10
171JVSO2JV Billing FI-SL Line Item4RRCTYRecord Typenvarchar10
172JVT1JV Summary Table3RRCTYRecord Typenvarchar10
173JVTO1JV Summary Table with Objects3RRCTYRecord Typenvarchar10
174JVTO2JV Billing FI-SL Summary Table3RRCTYRecord Typenvarchar10
175PSAHDPSA Document Header19RRCTYRecord Typenvarchar10
176T8JTPMJoint Venture Production Month Summary Data2RRCTYRecord Typenvarchar10
177T8PSA_COST_ADJPSA Cost Adjustment6RRCTYRecord Typenvarchar10
178T8PSA_INPUTVolume Input3RRCTYRecord Typenvarchar10
179T8PSA_PREPOSTPreliminary Posting2RRCTYRecord Typenvarchar10
180T8PSA_STOCK_ADJPSA Stock Adjustment6RRCTYRecord Typenvarchar10
TOPLocalization
181J_3RFTAXRATax Accounting: Actual line item table4RRCTYRecord Typenvarchar10
182J_3RFTAXRPTax Accounting: Plan line item table4RRCTYRecord Typenvarchar10
183J_3RFTAXRTTax Accounting: Summary table3RRCTYRecord Typenvarchar10
184J_3RFTAXRVATax Accounting: Actual line item table4RRCTYRecord Typenvarchar10
185J_3RFTAXRVPTax Accounting: Plan line item table4RRCTYRecord Typenvarchar10
186J_3RFTAXRVTTax Accounting: Summary table3RRCTYRecord Typenvarchar10
TOPProfit Center Accounting
187GLPCAEC-PCA: Actual Line Items4RRCTYRecord Typenvarchar10
188GLPCPEC-PCA: Plan Line Items4RRCTYRecord Typenvarchar10
189GLPCTEC-PCA: Totals Table3RRCTYRecord Typenvarchar10
190T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material3RRCTYRecord Typenvarchar10
TOPProfitability Analysis
191GLTPCProfit Center Accounting3RRCTYRecord Typenvarchar10
TOPRegulatory reporting for insurance companies
192ISSRFLDEAActual line item table4RRCTYRecord Typenvarchar10
193ISSRFLDEPPlan line items table4RRCTYRecord Typenvarchar10
194ISSRFLDETSummary table3RRCTYRecord Typenvarchar10
TOPRemaining Beverage - Obsolete Objects
195/BEV3/CHFIAActual line item table4RRCTYRecord Typenvarchar10
196/BEV3/CHFIPPlan Line Items Table4RRCTYRecord Typenvarchar10
197/BEV3/CHFITTotals table3RRCTYRecord Typenvarchar10
198/BEV3/CHVGRAActual line item table4RRCTYRecord Typenvarchar10
199/BEV3/CHVGRPPlan Line Items Table4RRCTYRecord Typenvarchar10
200/BEV3/CHVGRTTotals table3RRCTYRecord Typenvarchar10
TOPRetail Ledger
201PCRRETAILAActual line item table4RRCTYRecord Typenvarchar10
202PCRRETAILPPlan line items table4RRCTYRecord Typenvarchar10
203PCRRETAILTTotals Table3RRCTYRecord Typenvarchar10
TOPSpecial Purpose Ledger
204/CCIS/PBU18APBU18: Actual line item table4RRCTYRecord Typenvarchar10
205/CCIS/PBU18PPBU18: Plan line item table4RRCTYRecord Typenvarchar10
206/CCIS/PBU18TPBU18: Summary table x3RRCTYRecord Typenvarchar10
207/CCIS/PROFTAX01Object Table Number:013RRCTYRecord Typenvarchar10
208/CCIS/PROFTAXAActual Line Items Table for General Ledger12RRCTYRecord Typenvarchar10
209/CCIS/PROFTAXPPlan Line Items Table for General Ledger14RRCTYRecord Typenvarchar10
210/CCIS/PROFTAXTTotals Table for General Ledger20RRCTYRecord Typenvarchar10
TOPTariffs, Duties and Permits
211OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger4RRCTYRecord Typenvarchar10
212OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger4RRCTYRecord Typenvarchar10
213OIHEDTSummary table, IS-OIL Excise Duty Special Ledger3RRCTYRecord Typenvarchar10
214OIHSLATDP (excise duty) special ledger actual line item table4RRCTYRecord Typenvarchar10
215OIHSLTTDP (excise duty) special ledger summary table3RRCTYRecord Typenvarchar10
TOPTransfer to Financial Accounting
216TRACTSLAActual Line Item Table4RRCTYRecord Typenvarchar10
217TRACTSLPPlan Line Items Table4RRCTYRecord Typenvarchar10
218TRACTSLTTotals Table3RRCTYRecord Typenvarchar10