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

177 columns | Print definition?ERP 6.0  | DRCRK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FAGLFLEXT_BAKGeneral Ledger: Totals12DRCRKDebit/Credit Indicatornvarchar10
2FAGLFLEXT_DIFDelta Table: G/L Totals12DRCRKDebit/Credit Indicatornvarchar10
3GLPCA_CTProfit Center Documents66DRCRKDebit/Credit Indicatornvarchar10
4GLPCA_T_CTProfit Center Documents82DRCRKDebit/Credit Indicatornvarchar10
5GLT0_BAKG/L Account Master Record Transaction Figures10DRCRKDebit/Credit Indicatornvarchar10
6GLT0_DIFDelta Table: G/L Account Master Transaction Figures10DRCRKDebit/Credit Indicatornvarchar10
7ZSAWAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
8ZSAWPPlan line items table9DRCRKDebit/Credit Indicatornvarchar10
9ZSAWTSummary table11DRCRKDebit/Credit Indicatornvarchar10
10ZSEMBPSAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
11ZSEMBPSPPlan line items table9DRCRKDebit/Credit Indicatornvarchar10
12ZSEMBPSTSummary table11DRCRKDebit/Credit Indicatornvarchar10
13ZSPLITAIsteinzelposten-Tabelle9DRCRKSoll-/Haben-Kennzeichennvarchar10
14ZSPLITPPlaneinzelposten-Tabelle9DRCRKSoll-/Haben-Kennzeichennvarchar10
15ZSPLITTSummentabelle11DRCRKSoll-/Haben-Kennzeichennvarchar10
16ZZ001AActual Line Item Table9DRCRKDebit/Credit Indicatornvarchar10
17ZZ001PPlan Line Items Table9DRCRKDebit/Credit Indicatornvarchar10
18ZZ001TSummary Table11DRCRKDebit/Credit Indicatornvarchar10
19ZZLINEAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
20ZZLINEPPlan line items table9DRCRKDebit/Credit Indicatornvarchar10
21ZZLINETSummary table11DRCRKDebit/Credit Indicatornvarchar10
22ZZSL01AActual line item table9DRCRKDebit/Credit Indicatornvarchar10
23ZZSL01PPlan line items table9DRCRKDebit/Credit Indicatornvarchar10
24ZZSL01TSummary table11DRCRKDebit/Credit Indicatornvarchar10
25ZZSPECAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
26ZZSPECPPlan line item table9DRCRKDebit/Credit Indicatornvarchar10
27ZZSPECTSummary table10DRCRKDebit/Credit Indicatornvarchar10
TOPAvailability Control
28FMAVCAActual line item table8DRCRKDebit/Credit Indicatornvarchar10
29FMAVCPPlan line items table8DRCRKDebit/Credit Indicatornvarchar10
30FMAVCTAVC Summary Table (BCS)10DRCRKDebit/Credit Indicatornvarchar10
TOPBasic Functions
31FILCAFI-LC: Actual journal entry table with 2 object tables9DRCRKDebit/Credit Indicatornvarchar10
32FILCPFI-LC: Plan line items for object table9DRCRKDebit/Credit Indicatornvarchar10
33FILCTFI-LC: Global totals table with 2 object tables11DRCRKDebit/Credit Indicatornvarchar10
34GGREFAExample for Global FI-SL Line Items (Actual)9DRCRKDebit/Credit Indicatornvarchar10
35GGREFPExample for Global FI-SL Line Items (Plan)9DRCRKDebit/Credit Indicatornvarchar10
36GGREFTExample for Global FI-SL Summary Table11DRCRKDebit/Credit Indicatornvarchar10
37GLFUNCAActual Line Items Table for Cost of Sales Accounting9DRCRKDebit/Credit Indicatornvarchar10
38GLFUNCPPlan Line Items Table for Cost of Sales Accounting9DRCRKDebit/Credit Indicatornvarchar10
39GLFUNCTTotals Table for Cost of Sales Accounting11DRCRKDebit/Credit Indicatornvarchar10
40GLFUNCURollup line item tables with function area for IDES9DRCRKDebit/Credit Indicatornvarchar10
41GLFUNCVRollup plan line items table with function area for IDES9DRCRKDebit/Credit Indicatornvarchar10
42GLP0Local Logical General Ledger Plan Line Items10DRCRKDebit/Credit Indicatornvarchar10
43GLPO1Plan Line Items for Object Table11DRCRKDebit/Credit Indicatornvarchar10
44GLPO2Plan Line Items for Object Table Global11DRCRKDebit/Credit Indicatornvarchar10
45GLPO3Plan Line Items for Object Table11DRCRKDebit/Credit Indicatornvarchar10
46GLREFAExample for Local FI-SL Line Items (Actual)9DRCRKDebit/Credit Indicatornvarchar10
47GLREFPExample for Local FI-SL Line Items (Plan)9DRCRKDebit/Credit Indicatornvarchar10
48GLREFTExample for Local FI-SL Summary Table11DRCRKDebit/Credit Indicatornvarchar10
49GLREFUExample for FI-SL Rollup Line Items (Actual)9DRCRKDebit/Credit Indicatornvarchar10
50GLREFVExample for Rollup FI-SL Line Items (Plan)9DRCRKDebit/Credit Indicatornvarchar10
51GLSO1FI-SL Line Item Table with Objects for GLTO111DRCRKDebit/Credit Indicatornvarchar10
52GLSO2FI-SL Table with Objects, Structure corresponds to GLS211DRCRKDebit/Credit Indicatornvarchar10
53GLSO3FI-SL LI Table with Objects for GLTO311DRCRKDebit/Credit Indicatornvarchar10
54GLT0G/L account master record transaction figures10DRCRKDebit/Credit Indicatornvarchar10
55GLT3Summary Data Preparations for Consolidation15DRCRKDebit/Credit Indicatornvarchar10
56GLTO1FI-SL Table with Objects, Structure Corresponds to GLT111DRCRKDebit/Credit Indicatornvarchar10
57GLTO2FI-SL Table with Objects, Structure Corresponds to GLT211DRCRKDebit/Credit Indicatornvarchar10
58GLTO3FISL Table with Objects, Amounts and Quantities in Format P911DRCRKDebit/Credit Indicatornvarchar10
TOPBudgeting
59FMBDAActual line item table8DRCRKDebit/Credit Indicatornvarchar10
60FMBDPFM Budget change line items table8DRCRKDebit/Credit Indicatornvarchar10
61FMBDTFM budget totals table10DRCRKDebit/Credit Indicatornvarchar10
62FMRBAActual line item table8DRCRKDebit/Credit Indicatornvarchar10
63FMRBPPlan line items table8DRCRKDebit/Credit Indicatornvarchar10
64FMRBTSummary table10DRCRKDebit/Credit Indicatornvarchar10
TOPCollectionsDisbursements
65GLISDEAActual Line Item Tables for Insurance (DE)9DRCRKDebit/Credit Indicatornvarchar10
66GLISDEPPlan Line Item Table for Insurance (DE)9DRCRKDebit/Credit Indicatornvarchar10
67GLISDETSummary Table for Insurance (DE)11DRCRKDebit/Credit Indicatornvarchar10
68GRISDEAActual Line Item Table for Insurance (DE) - Rollup9DRCRKDebit/Credit Indicatornvarchar10
69GRISDEPPlan Line Item Table for Insurance (DE) - Rollup9DRCRKDebit/Credit Indicatornvarchar10
70GRISDETSummary Table for Insurance (DE) - Rollup11DRCRKDebit/Credit Indicatornvarchar10
TOPConsolidation
71ECMCASAP Cons.: Journal Entry Table (Actual)9DRCRKDebit/Credit Indicatornvarchar10
72ECMCTSAP Cons.: Totals Table11DRCRKDebit/Credit Indicatornvarchar10
TOPContract Accounts Receivable and Payable
73EBRLIVICMSRegistro de Apuração do ICMS: List control additional acct7DRCRKRegistro de Apuração do IPI/ICMS: Indicator only deb./cred.nvarchar10
TOPCost Element Accounting
74COFIPSingle plan items for reconciliation ledger9DRCRKDebit/Credit Indicatornvarchar10
75COFISActual line items for reconciliation ledger9DRCRKDebit/Credit Indicatornvarchar10
76COFITTotals Records for Reconciliation Ledger11DRCRKDebit/Credit Indicatornvarchar10
TOPData Retention Tool
77TXW_S_GLT0Retrieve archived GLT0 data10DRCRKDebit/Credit Indicatornvarchar10
TOPFinancial Accounting
78FBICRC001AICRC: Open Items GL Accounts: Documents8DRCRKDebit/Credit Indicatornvarchar10
79FBICRC001PNot in use8DRCRKDebit/Credit Indicatornvarchar10
80FBICRC001TICRC: Open Items GL Accounts: Totals10DRCRKDebit/Credit Indicatornvarchar10
81FBICRC002AICRC: GL Accounts: Documents8DRCRKDebit/Credit Indicatornvarchar10
82FBICRC002PNot in use8DRCRKDebit/Credit Indicatornvarchar10
83FBICRC002TICRC: GL Accounts: Totals10DRCRKDebit/Credit Indicatornvarchar10
84FBICRC003AICRC: Open Items Customers/Vendors: Documents8DRCRKDebit/Credit Indicatornvarchar10
85FBICRC003PNot in use8DRCRKDebit/Credit Indicatornvarchar10
86FBICRC003TICRC: Open Items Customers/Vendors: Totals10DRCRKDebit/Credit Indicatornvarchar10
TOPFinancial Services Localization
87/CEEIS/RUAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
88/CEEIS/RUPPlan line items table9DRCRKDebit/Credit Indicatornvarchar10
89/CEEIS/RUTTotals Table11DRCRKDebit/Credit Indicatornvarchar10
TOPFlexible Real Estate Management
90VIPRLEDTAGRAIsteinzelposten-Tabelle9DRCRKSoll-/Haben-Kennzeichennvarchar10
91VIPRLEDTAGRPPlaneinzelposten-Tabelle9DRCRKSoll-/Haben-Kennzeichennvarchar10
92VIPRLEDTAGRTSummentabelle Ledger 7A Mandate10DRCRKSoll-/Haben-Kennzeichennvarchar10
TOPFund Accounting
93FMCCAVCAActual line item table8DRCRKDebit/Credit Indicatornvarchar10
94FMCCAVCPPlan line items table8DRCRKDebit/Credit Indicatornvarchar10
95FMCCAVCRESERVECCAVC aux table for reserved items15DRCRKDebit/Credit Indicatornvarchar10
96FMCCAVCTTotals Table10DRCRKDebit/Credit Indicatornvarchar10
97FMGLFLEXAGeneral Ledger: Actual Line Items34DRCRKDebit/Credit Indicatornvarchar10
98FMGLFLEXPGeneral Ledger: Plan Line Items115DRCRKDebit/Credit Indicatornvarchar10
99FMGLFLEXTGeneral Ledger Public Sector: Total12DRCRKDebit/Credit Indicatornvarchar10
100PSGLFLEXAGeneral Ledger: Actual Line Items38DRCRKDebit/Credit Indicatornvarchar10
101PSGLFLEXPGeneral Ledger: Plan Line Items119DRCRKDebit/Credit Indicatornvarchar10
102PSGLFLEXTGeneral Ledger Public Sector: Total12DRCRKDebit/Credit Indicatornvarchar10
TOPFunds Management
103FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 6008DRCRKDebit/Credit Indicatornvarchar10
104FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 6008DRCRKDebit/Credit Indicatornvarchar10
105FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 6008DRCRKDebit/Credit Indicatornvarchar10
106FMSPLITAActual line item table8DRCRKDebit/Credit Indicatornvarchar10
107FMSPLITPPlan line items table8DRCRKDebit/Credit Indicatornvarchar10
108FMSPLITTSummary table10DRCRKDebit/Credit Indicatornvarchar10
109FMUSFGAActual line item table for US Federal Government.8DRCRKDebit/Credit Indicatornvarchar10
110FMUSFGFACTS1A4Actual line item table8DRCRKDebit/Credit Indicatornvarchar10
111FMUSFGFACTS1PPlan line items table8DRCRKDebit/Credit Indicatornvarchar10
112FMUSFGFACTS1TSummary table10DRCRKDebit/Credit Indicatornvarchar10
113FMUSFGFACTS2AActual line item table8DRCRKDebit/Credit Indicatornvarchar10
114FMUSFGFACTS2PPlan line items table8DRCRKDebit/Credit Indicatornvarchar10
115FMUSFGFACTS2TSummary table10DRCRKDebit/Credit Indicatornvarchar10
116FMUSFGPPlan line items table8DRCRKDebit/Credit Indicatornvarchar10
117FMUSFGTSummary table for US Federal Government10DRCRKDebit/Credit Indicatornvarchar10
TOPGeneral Ledger Accounting
118FAGLFLEXAGeneral Ledger: Actual Line Items36DRCRKDebit/Credit Indicatornvarchar10
119FAGLFLEXPGeneral Ledger: Plan Line Items117DRCRKDebit/Credit Indicatornvarchar10
120FAGLFLEXTGeneral Ledger: Totals12DRCRKDebit/Credit Indicatornvarchar10
121GLFLEXAFlexible general ledger: Actual line items8DRCRKDebit/Credit Indicatornvarchar10
122GLFLEXPFlexible G/L: Plan line items9DRCRKDebit/Credit Indicatornvarchar10
123GLFLEXTFlexible G/L: Totals12DRCRKDebit/Credit Indicatornvarchar10
TOPGrantee Management
124GMAVCAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
125GMAVCPPlan line items table9DRCRKDebit/Credit Indicatornvarchar10
126GMAVCTSummary table11DRCRKDebit/Credit Indicatornvarchar10
TOPJoint Venture und Production Sharing Accounting
127JVGLFLEXAGeneral Ledger: Actual Line Items38DRCRKDebit/Credit Indicatornvarchar10
128JVGLFLEXPGeneral Ledger: Plan Line Items119DRCRKDebit/Credit Indicatornvarchar10
129JVGLFLEXTGeneral Ledger: Totals12DRCRKDebit/Credit Indicatornvarchar10
130JVPO1JVA: Plan Line Items9DRCRKDebit/Credit Indicatornvarchar10
131JVPSC01AActual line item table9DRCRKDebit/Credit Indicatornvarchar10
132JVPSC01PPlan line item table9DRCRKDebit/Credit Indicatornvarchar10
133JVPSC01TSummary table11DRCRKDebit/Credit Indicatornvarchar10
134JVSO1JV LI Table with Objects for JVTO19DRCRKDebit/Credit Indicatornvarchar10
135JVSO2JV Billing FI-SL Line Item8DRCRKDebit/Credit Indicatornvarchar10
136JVTO1JV Summary Table with Objects11DRCRKDebit/Credit Indicatornvarchar10
137JVTO2JV Billing FI-SL Summary Table9DRCRKDebit/Credit Indicatornvarchar10
138T8JTPMJoint Venture Production Month Summary Data10DRCRKDebit/Credit Indicatornvarchar10
TOPLocalization
139J_1BLB08Registro de Apuração do IPI: List control additional accts7DRCRKRegistro de Apuração do IPI/ICMS: Indicator only deb./cred.nvarchar10
140J_1BLB09Registro de Apuração do ICMS: List control additional acct7DRCRKRegistro de Apuração do IPI/ICMS: Indicator only deb./cred.nvarchar10
141J_3RFTAXRATax Accounting: Actual line item table9DRCRKDebit/Credit Indicatornvarchar10
142J_3RFTAXRPTax Accounting: Plan line item table9DRCRKDebit/Credit Indicatornvarchar10
143J_3RFTAXRTTax Accounting: Summary table10DRCRKDebit/Credit Indicatornvarchar10
144J_3RFTAXRVATax Accounting: Actual line item table9DRCRKDebit/Credit Indicatornvarchar10
145J_3RFTAXRVPTax Accounting: Plan line item table9DRCRKDebit/Credit Indicatornvarchar10
146J_3RFTAXRVTTax Accounting: Summary table10DRCRKDebit/Credit Indicatornvarchar10
TOPProfit Center Accounting
147GLPCAEC-PCA: Actual Line Items9DRCRKDebit/Credit Indicatornvarchar10
148GLPCPEC-PCA: Plan Line Items9DRCRKDebit/Credit Indicatornvarchar10
149GLPCTEC-PCA: Totals Table11DRCRKDebit/Credit Indicatornvarchar10
150T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material11DRCRKDebit/Credit Indicatornvarchar10
TOPProfitability Analysis
151GLTPCProfit Center Accounting13DRCRKDebit/Credit Indicatornvarchar10
TOPRegulatory reporting for insurance companies
152ISSRFLDEAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
153ISSRFLDEPPlan line items table9DRCRKDebit/Credit Indicatornvarchar10
154ISSRFLDETSummary table11DRCRKDebit/Credit Indicatornvarchar10
TOPRemaining Beverage - Obsolete Objects
155/BEV3/CHFIAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
156/BEV3/CHFIPPlan Line Items Table9DRCRKDebit/Credit Indicatornvarchar10
157/BEV3/CHFITTotals table11DRCRKDebit/Credit Indicatornvarchar10
158/BEV3/CHVGRAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
159/BEV3/CHVGRPPlan Line Items Table9DRCRKDebit/Credit Indicatornvarchar10
160/BEV3/CHVGRTTotals table11DRCRKDebit/Credit Indicatornvarchar10
TOPRetail Ledger
161PCRRETAILAActual line item table9DRCRKDebit/Credit Indicatornvarchar10
162PCRRETAILPPlan line items table9DRCRKDebit/Credit Indicatornvarchar10
163PCRRETAILTTotals Table11DRCRKDebit/Credit Indicatornvarchar10
TOPSpecial Purpose Ledger
164/CCIS/PBU18APBU18: Actual line item table9DRCRKDebit/Credit Indicatornvarchar10
165/CCIS/PBU18PPBU18: Plan line item table9DRCRKDebit/Credit Indicatornvarchar10
166/CCIS/PBU18TPBU18: Summary table x11DRCRKDebit/Credit Indicatornvarchar10
167/CCIS/PROFTAXAActual Line Items Table for General Ledger46DRCRKDebit/Credit Indicatornvarchar10
168/CCIS/PROFTAXPPlan Line Items Table for General Ledger127DRCRKDebit/Credit Indicatornvarchar10
169/CCIS/PROFTAXTTotals Table for General Ledger12DRCRKDebit/Credit Indicatornvarchar10
TOPTariffs, Duties and Permits
170OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger9DRCRKDebit/Credit Indicatornvarchar10
171OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger9DRCRKDebit/Credit Indicatornvarchar10
172OIHEDTSummary table, IS-OIL Excise Duty Special Ledger11DRCRKDebit/Credit Indicatornvarchar10
173OIHSLATDP (excise duty) special ledger actual line item table9DRCRKDebit/Credit Indicatornvarchar10
174OIHSLTTDP (excise duty) special ledger summary table10DRCRKDebit/Credit Indicatornvarchar10
TOPTransfer to Financial Accounting
175TRACTSLAActual Line Item Table9DRCRKDebit/Credit Indicatornvarchar10
176TRACTSLPPlan Line Items Table9DRCRKDebit/Credit Indicatornvarchar10
177TRACTSLTTotals Table11DRCRKDebit/Credit Indicatornvarchar10