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

187 columns | Print definition?ERP 6.0  | RBUKRS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances14RBUKRSnvarchar40
2/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.15RBUKRSnvarchar40
3/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs17RBUKRSnvarchar40
4/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)17RBUKRSnvarchar40
5/SAPF15/FMITF15 Summentabelle Haushaltsmanagement2RBUKRSBuchungskreisnvarchar40
6/SAPF15/FMITBF15 Summentabelle Haushaltsmanagement (Belegnummer)2RBUKRSBuchungskreisnvarchar40
7CNV_20200_RLDNRCompany code - ledger (for new general ledger)3RBUKRSCompany Codenvarchar40
8FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT4RBUKRSCompany Codenvarchar40
9FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT6RBUKRSCompany Codenvarchar40
10FAGLFLEXT_BAKGeneral Ledger: Totals25RBUKRSCompany Codenvarchar40
11FAGLFLEXT_DIFDelta Table: G/L Totals25RBUKRSCompany Codenvarchar40
12FAGL_ORG_INFC_CTClass. General Ledger: Configuration Information (Crcy Type)2RBUKRSCompany Codenvarchar40
13FAGL_ORG_INFO_CTNew General Ledger: Configuration Information (Crcy Type)2RBUKRSCompany Codenvarchar40
14GLPCA_CTProfit Center Documents98RBUKRSCompany Codenvarchar40
15GLPCA_T_CTProfit Center Documents114RBUKRSCompany Codenvarchar40
16T8PSA_RUII_HISTPSA Rollup II History (for produc split by volume)5RBUKRSCompany Codenvarchar40
17ZSAWAActual line item table14RBUKRSCompany Codenvarchar40
18ZSAWPPlan line items table14RBUKRSCompany Codenvarchar40
19ZSAWTSummary table13RBUKRSCompany Codenvarchar40
20ZSEMBPSAActual line item table14RBUKRSCompany Codenvarchar40
21ZSEMBPSPPlan line items table14RBUKRSCompany Codenvarchar40
22ZSEMBPSTSummary table13RBUKRSCompany Codenvarchar40
23ZSPLITAIsteinzelposten-Tabelle14RBUKRSBuchungskreisnvarchar40
24ZSPLITPPlaneinzelposten-Tabelle14RBUKRSBuchungskreisnvarchar40
25ZSPLITTSummentabelle13RBUKRSBuchungskreisnvarchar40
26ZZ001AActual Line Item Table14RBUKRSCompany Codenvarchar40
27ZZ001PPlan Line Items Table14RBUKRSCompany Codenvarchar40
28ZZ001TSummary Table13RBUKRSCompany Codenvarchar40
29ZZLINEAActual line item table14RBUKRSCompany Codenvarchar40
30ZZLINEPPlan line items table14RBUKRSCompany Codenvarchar40
31ZZLINETSummary table13RBUKRSCompany Codenvarchar40
32ZZSL01AActual line item table14RBUKRSCompany Codenvarchar40
33ZZSL01PPlan line items table14RBUKRSCompany Codenvarchar40
34ZZSL01TSummary table13RBUKRSCompany Codenvarchar40
35ZZSPECAActual line item table14RBUKRSCompany Codenvarchar40
36ZZSPECPPlan line item table14RBUKRSCompany Codenvarchar40
37ZZSPECTSummary table12RBUKRSCompany Codenvarchar40
TOPBasic Functions
38ARC_IDX_ITArchive index table for FI-SL line items5RBUKRSCompany Codenvarchar40
39GLFUNCAActual Line Items Table for Cost of Sales Accounting14RBUKRSCompany Codenvarchar40
40GLFUNCPPlan Line Items Table for Cost of Sales Accounting14RBUKRSCompany Codenvarchar40
41GLFUNCTTotals Table for Cost of Sales Accounting13RBUKRSCompany Codenvarchar40
42GLFUNCURollup line item tables with function area for IDES14RBUKRSCompany Codenvarchar40
43GLFUNCVRollup plan line items table with function area for IDES14RBUKRSCompany Codenvarchar40
44GLPO1Plan Line Items for Object Table16RBUKRSCompany Codenvarchar40
45GLPO3Plan Line Items for Object Table16RBUKRSCompany Codenvarchar40
46GLREFAExample for Local FI-SL Line Items (Actual)14RBUKRSCompany Codenvarchar40
47GLREFPExample for Local FI-SL Line Items (Plan)14RBUKRSCompany Codenvarchar40
48GLREFTExample for Local FI-SL Summary Table13RBUKRSCompany Codenvarchar40
49GLREFUExample for FI-SL Rollup Line Items (Actual)14RBUKRSCompany Codenvarchar40
50GLREFVExample for Rollup FI-SL Line Items (Plan)14RBUKRSCompany Codenvarchar40
51GLSO1FI-SL Line Item Table with Objects for GLTO116RBUKRSCompany Codenvarchar40
52GLSO3FI-SL LI Table with Objects for GLTO316RBUKRSCompany Codenvarchar40
53GLTO1FI-SL Table with Objects, Structure Corresponds to GLT113RBUKRSCompany Codenvarchar40
54GLTO3FISL Table with Objects, Amounts and Quantities in Format P913RBUKRSCompany Codenvarchar40
TOPCollectionsDisbursements
55GLISDEAActual Line Item Tables for Insurance (DE)14RBUKRSCompany Codenvarchar40
56GLISDEPPlan Line Item Table for Insurance (DE)14RBUKRSCompany Codenvarchar40
57GLISDETSummary Table for Insurance (DE)13RBUKRSCompany Codenvarchar40
58GRISDEAActual Line Item Table for Insurance (DE) - Rollup14RBUKRSCompany Codenvarchar40
59GRISDEPPlan Line Item Table for Insurance (DE) - Rollup14RBUKRSCompany Codenvarchar40
60GRISDETSummary Table for Insurance (DE) - Rollup13RBUKRSCompany Codenvarchar40
TOPCost Element Accounting
61COFIPSingle plan items for reconciliation ledger14RBUKRSCompany Codenvarchar40
62COFISActual line items for reconciliation ledger14RBUKRSCompany Codenvarchar40
63COFITTotals Records for Reconciliation Ledger13RBUKRSCompany Codenvarchar40
TOPData Retention Tool
64TXW_S_COFIRetrieve COFIS from archive10RBUKRSCompany Codenvarchar40
TOPFinancial Services Localization
65/CEEIS/RUAActual line item table14RBUKRSCompany Codenvarchar40
66/CEEIS/RUPPlan line items table14RBUKRSCompany Codenvarchar40
67/CEEIS/RUTTotals Table13RBUKRSCompany Codenvarchar40
TOPFlexible Real Estate Management
68VIPRLEDTAGRAIsteinzelposten-Tabelle14RBUKRSBuchungskreisnvarchar40
69VIPRLEDTAGRPPlaneinzelposten-Tabelle14RBUKRSBuchungskreisnvarchar40
70VIPRLEDTAGRTSummentabelle Ledger 7A Mandate12RBUKRSBuchungskreisnvarchar40
TOPFund Accounting
71FMCCAVCAActual line item table13RBUKRSCompany Codenvarchar40
72FMCCAVCPPlan line items table13RBUKRSCompany Codenvarchar40
73FMCCAVCTTotals Table12RBUKRSCompany Codenvarchar40
74FMGLFLEX03General ledger: SAP additional account assignment2RBUKRSCompany Codenvarchar40
75FMGLFLEXAGeneral Ledger: Actual Line Items5RBUKRSCompany Codenvarchar40
76FMGLFLEXPGeneral Ledger: Plan Line Items5RBUKRSCompany Codenvarchar40
77FMGLFLEXTGeneral Ledger Public Sector: Total25RBUKRSCompany Codenvarchar40
78PSGLFLEX03General ledger: SAP additional account assignment2RBUKRSCompany Codenvarchar40
79PSGLFLEXAGeneral Ledger: Actual Line Items5RBUKRSCompany Codenvarchar40
80PSGLFLEXPGeneral Ledger: Plan Line Items5RBUKRSCompany Codenvarchar40
81PSGLFLEXTGeneral Ledger Public Sector: Total27RBUKRSCompany Codenvarchar40
TOPFunds Management
82FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60013RBUKRSCompany Codenvarchar40
83FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60013RBUKRSCompany Codenvarchar40
84FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60013RBUKRSCompany Codenvarchar40
85FMIAActual Line Item Table for Funds Management12RBUKRSCompany Codenvarchar40
86FMIPPlan Line Items Table for Funds Management12RBUKRSCompany Codenvarchar40
87FMITTotals Table for Funds Management11RBUKRSCompany Codenvarchar40
88FMSPLITAActual line item table13RBUKRSCompany Codenvarchar40
89FMSPLITPPlan line items table13RBUKRSCompany Codenvarchar40
90FMSPLITTSummary table12RBUKRSCompany Codenvarchar40
91FMUSFGAActual line item table for US Federal Government.13RBUKRSCompany Codenvarchar40
92FMUSFGFACTS1A4Actual line item table13RBUKRSCompany Codenvarchar40
93FMUSFGFACTS1PPlan line items table13RBUKRSCompany Codenvarchar40
94FMUSFGFACTS1TSummary table12RBUKRSCompany Codenvarchar40
95FMUSFGFACTS2AActual line item table13RBUKRSCompany Codenvarchar40
96FMUSFGFACTS2PPlan line items table13RBUKRSCompany Codenvarchar40
97FMUSFGFACTS2TSummary table12RBUKRSCompany Codenvarchar40
98FMUSFGPPlan line items table13RBUKRSCompany Codenvarchar40
99FMUSFGTSummary table for US Federal Government12RBUKRSCompany Codenvarchar40
100KBLEDocument Item Processing: Manual Document Entry18RBUKRSCompany Codenvarchar40
TOPGeneral Ledger Accounting
101FAGLFLEX03General ledger: SAP additional account assignment2RBUKRSCompany Codenvarchar40
102FAGLFLEXAGeneral Ledger: Actual Line Items5RBUKRSCompany Codenvarchar40
103FAGLFLEXPGeneral Ledger: Plan Line Items5RBUKRSCompany Codenvarchar40
104FAGLFLEXTGeneral Ledger: Totals25RBUKRSCompany Codenvarchar40
105FAGLSKFGeneral Ledger: Statistical Key Figures (Current Values)5RBUKRSCompany Codenvarchar40
106FAGLSKF_PNGeneral Ledger; Statistical Key Figures (Source Document)7RBUKRSCompany Codenvarchar40
107FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items50RBUKRSCompany Codenvarchar40
108FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records18RBUKRSCompany Codenvarchar40
109FAGL_CARRY_FORWLast Balance Carryforward per Company Code/Ledger2RBUKRSCompany Codenvarchar40
110FAGL_EXTRDocuments for Summary Document Transfer7RBUKRSCompany Codenvarchar40
111FAGL_EXTR_HISTTransfer History for Summary Documents4RBUKRSCompany Codenvarchar40
112FAGL_MIG_TOTALSLog Table for Building Balances in New G/L3RBUKRSCompany Codenvarchar40
113FAGL_ORG_INFOGeneral Ledger: Configuration Information2RBUKRSCompany Codenvarchar40
114FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis16RBUKRSCompany Codenvarchar40
115GLFLEX00General ledger: Organizational units3RBUKRSCompany Codenvarchar40
116GLFLEXAFlexible general ledger: Actual line items5RBUKRSCompany Codenvarchar40
117GLFLEXPFlexible G/L: Plan line items5RBUKRSCompany Codenvarchar40
118GLFLEXTFlexible G/L: Totals15RBUKRSCompany Codenvarchar40
119T882GCompany code - ledger assignment2RBUKRSCompany Codenvarchar40
TOPGrantee Management
120GMAVCAActual line item table14RBUKRSCompany Codenvarchar40
121GMAVCPPlan line items table14RBUKRSCompany Codenvarchar40
122GMAVCTSummary table13RBUKRSCompany Codenvarchar40
123GMIAActual Line Item Table13RBUKRSCompany Codenvarchar40
124GMIPPlan line items table13RBUKRSCompany Codenvarchar40
125GMITSummary table12RBUKRSCompany Codenvarchar40
TOPJoint Venture und Production Sharing Accounting
126ARC_IDB_ITArchive-Indextable for JV_BILLING5RBUKRSCompany Codenvarchar40
127ARC_IDJ_ITArchive-Indextable for JV_OBJECT5RBUKRSCompany Codenvarchar40
128JVGLFLEX03General ledger: SAP additional account assignment2RBUKRSCompany Codenvarchar40
129JVGLFLEXAGeneral Ledger: Actual Line Items5RBUKRSCompany Codenvarchar40
130JVGLFLEXPGeneral Ledger: Plan Line Items5RBUKRSCompany Codenvarchar40
131JVGLFLEXTGeneral Ledger: Totals25RBUKRSCompany Codenvarchar40
132JVPO1JVA: Plan Line Items14RBUKRSCompany Codenvarchar40
133JVPSC01AActual line item table14RBUKRSCompany Codenvarchar40
134JVPSC01PPlan line item table14RBUKRSCompany Codenvarchar40
135JVPSC01TSummary table13RBUKRSCompany Codenvarchar40
136JVSO1JV LI Table with Objects for JVTO114RBUKRSCompany Codenvarchar40
137JVSO2JV Billing FI-SL Line Item13RBUKRSCompany Codenvarchar40
138JVTO1JV Summary Table with Objects13RBUKRSCompany Codenvarchar40
139JVTO2JV Billing FI-SL Summary Table11RBUKRSCompany Codenvarchar40
140T8JIXJV index table5RBUKRSCompany Codenvarchar40
141T8JTPMJoint Venture Production Month Summary Data13RBUKRSCompany Codenvarchar40
142T8JXCCross company account determination2RBUKRSCompany for JV cross company postings from COnvarchar40
143T8JXCPCross company account determination2RBUKRSCompany code for CO/FI reconciliation postings in JVnvarchar40
144T8J_JVECJVA equity change document relationship2RBUKRSCompany Codenvarchar40
145T8PSA_COST_ADJPSA Cost Adjustment8RBUKRSCompany Codenvarchar40
146T8PSA_PREPOSTPreliminary Posting4RBUKRSCompany Codenvarchar40
TOPLocalization
147J_3RFTAXRATax Accounting: Actual line item table14RBUKRSCompany Codenvarchar40
148J_3RFTAXRPTax Accounting: Plan line item table14RBUKRSCompany Codenvarchar40
149J_3RFTAXRTTax Accounting: Summary table12RBUKRSCompany Codenvarchar40
150J_3RFTAXRVATax Accounting: Actual line item table14RBUKRSCompany Codenvarchar40
151J_3RFTAXRVPTax Accounting: Plan line item table14RBUKRSCompany Codenvarchar40
152J_3RFTAXRVTTax Accounting: Summary table12RBUKRSCompany Codenvarchar40
TOPProfit Center Accounting
153ARC_IPC_ITArchive index table for FI-SL line items5RBUKRSCompany Codenvarchar40
154GLPCAEC-PCA: Actual Line Items14RBUKRSCompany Codenvarchar40
155GLPCPEC-PCA: Plan Line Items14RBUKRSCompany Codenvarchar40
156GLPCTEC-PCA: Totals Table13RBUKRSCompany Codenvarchar40
157T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material15RBUKRSCompany Codenvarchar40
158T8A_ALLOCPostprocessing of Allocations for BS Accts in Profit Centers5RBUKRSCompany Codenvarchar40
TOPRegulatory reporting for insurance companies
159ISSRFLDEAActual line item table14RBUKRSCompany Codenvarchar40
160ISSRFLDEPPlan line items table14RBUKRSCompany Codenvarchar40
161ISSRFLDETSummary table13RBUKRSCompany Codenvarchar40
TOPRemaining Beverage - Obsolete Objects
162/BEV3/CHFIAActual line item table14RBUKRSCompany Codenvarchar40
163/BEV3/CHFIPPlan Line Items Table14RBUKRSCompany Codenvarchar40
164/BEV3/CHFITTotals table13RBUKRSCompany Codenvarchar40
165/BEV3/CHVGRAActual line item table14RBUKRSCompany Codenvarchar40
166/BEV3/CHVGRPPlan Line Items Table14RBUKRSCompany Codenvarchar40
167/BEV3/CHVGRTTotals table13RBUKRSCompany Codenvarchar40
TOPRetail Ledger
168PCRRETAILAActual line item table14RBUKRSCompany Codenvarchar40
169PCRRETAILPPlan line items table14RBUKRSCompany Codenvarchar40
170PCRRETAILTTotals Table13RBUKRSCompany Codenvarchar40
TOPSpecial Purpose Ledger
171/CCIS/PBU18APBU18: Actual line item table14RBUKRSCompany Codenvarchar40
172/CCIS/PBU18PPBU18: Plan line item table14RBUKRSCompany Codenvarchar40
173/CCIS/PBU18TPBU18: Summary table x13RBUKRSCompany Codenvarchar40
174/CCIS/PROFTAX03Object Table Number:032RBUKRSCompany Codenvarchar40
175/CCIS/PROFTAXAActual Line Items Table for General Ledger5RBUKRSCompany Codenvarchar40
176/CCIS/PROFTAXPPlan Line Items Table for General Ledger5RBUKRSCompany Codenvarchar40
177/CCIS/PROFTAXTTotals Table for General Ledger25RBUKRSCompany Codenvarchar40
TOPTariffs, Duties and Permits
178OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger14RBUKRSCompany Codenvarchar40
179OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger14RBUKRSCompany Codenvarchar40
180OIHEDTSummary table, IS-OIL Excise Duty Special Ledger13RBUKRSCompany Codenvarchar40
181OIHSLATDP (excise duty) special ledger actual line item table14RBUKRSCompany Codenvarchar40
182OIHSLTTDP (excise duty) special ledger summary table12RBUKRSCompany Codenvarchar40
TOPTransaction Data Pool
183JBDKKONSAP Banking: Business Partner Account10RBUKRSReference Company Codenvarchar40
TOPTransfer Postings
184J_1AAWAYBLWay Bills for asset movements15RBUKRSReceiver company codenvarchar40
TOPTransfer to Financial Accounting
185TRACTSLAActual Line Item Table14RBUKRSCompany Codenvarchar40
186TRACTSLPPlan Line Items Table14RBUKRSCompany Codenvarchar40
187TRACTSLTTotals Table13RBUKRSCompany Codenvarchar40