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

106 columns | Print definition?ERP 6.0  | RFAREA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/6111_CONVConvert Financial Key/Functional Area to Form 6111 Code3RFAREAFunctional Areanvarchar160
2/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances17RFAREAnvarchar160
3/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.18RFAREAnvarchar160
4/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs20RFAREAnvarchar160
5/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)20RFAREAnvarchar160
6FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT26RFAREAFunctional Areanvarchar160
7FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT28RFAREAFunctional Areanvarchar160
8FAGLFLEXT_BAKGeneral Ledger: Totals28RFAREAFunctional Areanvarchar160
9FAGLFLEXT_DIFDelta Table: G/L Totals28RFAREAFunctional Areanvarchar160
10GLPCA_CTProfit Center Documents105RFAREAFunctional Areanvarchar160
11GLPCA_T_CTProfit Center Documents121RFAREAFunctional Areanvarchar160
12ZSAWAActual line item table18RFAREAFunctional Areanvarchar160
13ZSAWPPlan line items table18RFAREAFunctional Areanvarchar160
14ZSAWTSummary table17RFAREAFunctional Areanvarchar160
15ZSPLITAIsteinzelposten-Tabelle17RFAREAFunktionsbereichnvarchar160
16ZSPLITPPlaneinzelposten-Tabelle17RFAREAFunktionsbereichnvarchar160
17ZSPLITTSummentabelle16RFAREAFunktionsbereichnvarchar160
18ZZ001AActual Line Item Table18RFAREAFunctional Areanvarchar160
19ZZ001PPlan Line Items Table18RFAREAFunctional Areanvarchar160
20ZZ001TSummary Table17RFAREAFunctional Areanvarchar160
21ZZLINEAActual line item table17RFAREAFunctional Areanvarchar160
22ZZLINEPPlan line items table17RFAREAFunctional Areanvarchar160
23ZZLINETSummary table16RFAREAFunctional Areanvarchar160
24ZZSPECAActual line item table17RFAREAFunctional Areanvarchar160
25ZZSPECPPlan line item table17RFAREAFunctional Areanvarchar160
26ZZSPECTSummary table15RFAREAFunctional Areanvarchar160
TOPBasic Functions
27GGREFAExample for Global FI-SL Line Items (Actual)19RFAREAFunctional Areanvarchar160
28GGREFPExample for Global FI-SL Line Items (Plan)19RFAREAFunctional Areanvarchar160
29GGREFTExample for Global FI-SL Summary Table18RFAREAFunctional Areanvarchar160
30GLFUNCAActual Line Items Table for Cost of Sales Accounting17RFAREAFunctional Areanvarchar160
31GLFUNCPPlan Line Items Table for Cost of Sales Accounting17RFAREAFunctional Areanvarchar160
32GLFUNCTTotals Table for Cost of Sales Accounting16RFAREAFunctional Areanvarchar160
33GLFUNCURollup line item tables with function area for IDES17RFAREAFunctional Areanvarchar160
34GLFUNCVRollup plan line items table with function area for IDES17RFAREAFunctional Areanvarchar160
35GLREFAExample for Local FI-SL Line Items (Actual)18RFAREAFunctional Areanvarchar160
36GLREFPExample for Local FI-SL Line Items (Plan)18RFAREAFunctional Areanvarchar160
37GLREFTExample for Local FI-SL Summary Table17RFAREAFunctional Areanvarchar160
38GLREFUExample for FI-SL Rollup Line Items (Actual)18RFAREAFunctional Areanvarchar160
39GLREFVExample for Rollup FI-SL Line Items (Plan)18RFAREAFunctional Areanvarchar160
TOPCost Element Accounting
40COFIPSingle plan items for reconciliation ledger20RFAREAFunctional Areanvarchar160
41COFISActual line items for reconciliation ledger20RFAREAFunctional Areanvarchar160
42COFITTotals Records for Reconciliation Ledger19RFAREAFunctional Areanvarchar160
TOPData Retention Tool
43TXW_S_COFIRetrieve COFIS from archive13RFAREAFunctional Areanvarchar160
TOPFinancial Services Localization
44/CEEIS/RUAActual line item table18RFAREAFunctional Areanvarchar160
45/CEEIS/RUPPlan line items table18RFAREAFunctional Areanvarchar160
46/CEEIS/RUTTotals Table17RFAREAFunctional Areanvarchar160
TOPFund Accounting
47FMCCAVCAActual line item table18RFAREAFunctional Areanvarchar160
48FMCCAVCPPlan line items table18RFAREAFunctional Areanvarchar160
49FMCCAVCTTotals Table17RFAREAFunctional Areanvarchar160
50FMGLFLEX07General Ledger: Reserve Table 14RFAREAFunctional Areanvarchar160
51FMGLFLEXAGeneral Ledger: Actual Line Items27RFAREAFunctional Areanvarchar160
52FMGLFLEXPGeneral Ledger: Plan Line Items29RFAREAFunctional Areanvarchar160
53FMGLFLEXTGeneral Ledger Public Sector: Total36RFAREAFunctional Areanvarchar160
54PSGLFLEX07General Ledger: Reserve Table 14RFAREAFunctional Areanvarchar160
55PSGLFLEXAGeneral Ledger: Actual Line Items30RFAREAFunctional Areanvarchar160
56PSGLFLEXPGeneral Ledger: Plan Line Items32RFAREAFunctional Areanvarchar160
57PSGLFLEXTGeneral Ledger Public Sector: Total39RFAREAFunctional Areanvarchar160
TOPFunds Management
58FMCCFDFiscal Year Change Documents (FM)32RFAREAReceiver Functional Area (Fiscal Year Change FM)nvarchar160
59FMCCFLOTCommitment Carryforward of Held Documents (Approval Proc.)27RFAREAReceiver Functional Area (Fiscal Year Change FM)nvarchar160
60FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60026RFAREAFunctional Areanvarchar160
61FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60019RFAREAFunctional Areanvarchar160
62FMIAActual Line Item Table for Funds Management26RFAREAFunctional Areanvarchar160
63FMIPPlan Line Items Table for Funds Management25RFAREAFunctional Areanvarchar160
64FMITTotals Table for Funds Management24RFAREAFunctional Areanvarchar160
65FMRPRELAssignment of Expenditure Objects to Revenue Cover Pool6RFAREAFunctional Areanvarchar160
66FMSPLITAActual line item table18RFAREAFunctional Areanvarchar160
67FMSPLITPPlan line items table18RFAREAFunctional Areanvarchar160
68FMSPLITTSummary table17RFAREAFunctional Areanvarchar160
69FMUDBSEGHAddtl Info on Revenues Increasing Budget for Recovery Order9RFAREAFunctional Areanvarchar160
70FMUDBSEGPPart.Payt Item for Customer Invoice of a Rev. Incr. the Bgt15RFAREAFunctional Areanvarchar160
71FMUDKBLPHAddtl Info re Revenues Increasing Budget for Fcst of Revenue7RFAREAFunctional Areanvarchar160
72FMUDKBLPPItem Revenues Increasing Budget for Forecast of Revenue10RFAREAFunctional Areanvarchar160
73FMUDRELAssignment of Expenditure Objs.to Revenue Objs Incr.Budget9RFAREAFunctional Areanvarchar160
74FMUDRELCAssignment of Expenditure Objs.to Revenue Objs Incr.Budget9RFAREAFunctional Areanvarchar160
75FMUSFGAActual line item table for US Federal Government.19RFAREAFunctional Areanvarchar160
76FMUSFGFACTS1A4Actual line item table26RFAREAFunctional Areanvarchar160
77FMUSFGFACTS1PPlan line items table26RFAREAFunctional Areanvarchar160
78FMUSFGFACTS1TSummary table25RFAREAFunctional Areanvarchar160
79FMUSFGPPlan line items table19RFAREAFunctional Areanvarchar160
80FMUSFGTSummary table for US Federal Government18RFAREAFunctional Areanvarchar160
TOPGeneral Ledger Accounting
81FAGLFLEX03General ledger: SAP additional account assignment5RFAREAFunctional Areanvarchar160
82FAGLFLEXAGeneral Ledger: Actual Line Items19RFAREAFunctional Areanvarchar160
83FAGLFLEXPGeneral Ledger: Plan Line Items21RFAREAFunctional Areanvarchar160
84FAGLFLEXTGeneral Ledger: Totals28RFAREAFunctional Areanvarchar160
85FAGLSKFGeneral Ledger: Statistical Key Figures (Current Values)8RFAREAFunctional Areanvarchar160
86FAGLSKF_PNGeneral Ledger; Statistical Key Figures (Source Document)10RFAREAFunctional Areanvarchar160
87FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records21RFAREAFunctional Areanvarchar160
88FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis19RFAREAFunctional Areanvarchar160
89GLFLEX03General ledger: SAP additional account assignment4RFAREAFunctional Areanvarchar160
90GLFLEXAFlexible general ledger: Actual line items15RFAREAFunctional Areanvarchar160
91GLFLEXPFlexible G/L: Plan line items15RFAREAFunctional Areanvarchar160
92GLFLEXTFlexible G/L: Totals21RFAREAFunctional Areanvarchar160
TOPJoint Venture und Production Sharing Accounting
93JVGLFLEX03General ledger: SAP additional account assignment5RFAREAFunctional Areanvarchar160
94JVGLFLEXAGeneral Ledger: Actual Line Items19RFAREAFunctional Areanvarchar160
95JVGLFLEXPGeneral Ledger: Plan Line Items21RFAREAFunctional Areanvarchar160
96JVGLFLEXTGeneral Ledger: Totals28RFAREAFunctional Areanvarchar160
TOPProfit Center Accounting
97GLPCAEC-PCA: Actual Line Items17RFAREAFunctional Areanvarchar160
98GLPCPEC-PCA: Plan Line Items17RFAREAFunctional Areanvarchar160
99GLPCTEC-PCA: Totals Table16RFAREAFunctional Areanvarchar160
100T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material18RFAREAFunctional Areanvarchar160
TOPRetail Ledger
101PCRRETAILAActual line item table18RFAREAFunctional Areanvarchar160
102PCRRETAILPPlan line items table18RFAREAFunctional Areanvarchar160
103PCRRETAILTTotals Table17RFAREAFunctional Areanvarchar160
TOPTariffs, Duties and Permits
104OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger25RFAREAFunctional Areanvarchar160
105OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger25RFAREAFunctional Areanvarchar160
106OIHEDTSummary table, IS-OIL Excise Duty Special Ledger24RFAREAFunctional Areanvarchar160