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

123 columns | Print definition?ERP 6.0  | RPMAX

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNFM_FMBLExtension table for table FMBL (localization PSM China)6RPMAXPeriodnvarchar30
2CNFM_FMHBLExtension table for table FMHBL (localization PSM China)6RPMAXPeriodnvarchar30
3FAGLFLEXT_BAKGeneral Ledger: Totals13RPMAXPeriodnvarchar30
4FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields6RPMAXPeriodnvarchar30
5GLT0_BAKG/L Account Master Record Transaction Figures11RPMAXPeriodnvarchar30
6ZSAWPPlan line items table10RPMAXPeriodnvarchar30
7ZSAWTSummary table12RPMAXPeriodnvarchar30
8ZSEMBPSPPlan line items table10RPMAXPeriodnvarchar30
9ZSEMBPSTSummary table12RPMAXPeriodnvarchar30
10ZSPLITPPlaneinzelposten-Tabelle10RPMAXPeriodenvarchar30
11ZSPLITTSummentabelle12RPMAXPeriodenvarchar30
12ZZ001PPlan Line Items Table10RPMAXPeriodnvarchar30
13ZZ001TSummary Table12RPMAXPeriodnvarchar30
14ZZLINEPPlan line items table10RPMAXPeriodnvarchar30
15ZZLINETSummary table12RPMAXPeriodnvarchar30
16ZZSL01PPlan line items table10RPMAXPeriodnvarchar30
17ZZSL01TSummary table12RPMAXPeriodnvarchar30
18ZZSPECPPlan line item table10RPMAXPeriodnvarchar30
19ZZSPECTSummary table11RPMAXPeriodnvarchar30
TOPAvailability Control
20FMAVCPPlan line items table9RPMAXPeriodnvarchar30
21FMAVCTAVC Summary Table (BCS)11RPMAXPeriodnvarchar30
TOPBasic Functions
22FILCPFI-LC: Plan line items for object table10RPMAXPeriodnvarchar30
23FILCTFI-LC: Global totals table with 2 object tables12RPMAXPeriodnvarchar30
24GGREFPExample for Global FI-SL Line Items (Plan)10RPMAXPeriodnvarchar30
25GGREFTExample for Global FI-SL Summary Table12RPMAXPeriodnvarchar30
26GLFUNCPPlan Line Items Table for Cost of Sales Accounting10RPMAXPeriodnvarchar30
27GLFUNCTTotals Table for Cost of Sales Accounting12RPMAXPeriodnvarchar30
28GLFUNCVRollup plan line items table with function area for IDES10RPMAXPeriodnvarchar30
29GLP0Local Logical General Ledger Plan Line Items11RPMAXPeriodnvarchar30
30GLPO1Plan Line Items for Object Table12RPMAXPeriodnvarchar30
31GLPO2Plan Line Items for Object Table Global12RPMAXPeriodnvarchar30
32GLPO3Plan Line Items for Object Table12RPMAXPeriodnvarchar30
33GLREFPExample for Local FI-SL Line Items (Plan)10RPMAXPeriodnvarchar30
34GLREFTExample for Local FI-SL Summary Table12RPMAXPeriodnvarchar30
35GLREFVExample for Rollup FI-SL Line Items (Plan)10RPMAXPeriodnvarchar30
36GLT0G/L account master record transaction figures11RPMAXPeriodnvarchar30
37GLT3Summary Data Preparations for Consolidation16RPMAXPeriodnvarchar30
38GLTO1FI-SL Table with Objects, Structure Corresponds to GLT112RPMAXPeriodnvarchar30
39GLTO2FI-SL Table with Objects, Structure Corresponds to GLT212RPMAXPeriodnvarchar30
40GLTO3FISL Table with Objects, Amounts and Quantities in Format P912RPMAXPeriodnvarchar30
TOPBudgeting
41FMBDPFM Budget change line items table9RPMAXPeriodnvarchar30
42FMBDTFM budget totals table11RPMAXPeriodnvarchar30
43FMBLFunds management budget document lines (entry documents)6RPMAXPeriodnvarchar30
44FMCY_COPIFor CO plan data transfer14RPMAXPeriodnvarchar30
45FMHBLFunds management budget document lines (held documents)6RPMAXPeriodnvarchar30
46FMPEP_VARIANTLSession variants (line part) for transaction FMPEP6RPMAXPeriodnvarchar30
47FMRBPPlan line items table9RPMAXPeriodnvarchar30
48FMRBTSummary table11RPMAXPeriodnvarchar30
TOPCollectionsDisbursements
49GLISDEPPlan Line Item Table for Insurance (DE)10RPMAXPeriodnvarchar30
50GLISDETSummary Table for Insurance (DE)12RPMAXPeriodnvarchar30
51GRISDEPPlan Line Item Table for Insurance (DE) - Rollup10RPMAXPeriodnvarchar30
52GRISDETSummary Table for Insurance (DE) - Rollup12RPMAXPeriodnvarchar30
TOPConsolidation
53ECMCTSAP Cons.: Totals Table12RPMAXPeriodnvarchar30
TOPCost Element Accounting
54COFIPSingle plan items for reconciliation ledger10RPMAXPeriodnvarchar30
55COFITTotals Records for Reconciliation Ledger12RPMAXPeriodnvarchar30
TOPData Retention Tool
56TXW_S_GLT0Retrieve archived GLT0 data11RPMAXPeriodnvarchar30
TOPFinancial Accounting
57FBICRC001PNot in use9RPMAXPeriodnvarchar30
58FBICRC001TICRC: Open Items GL Accounts: Totals11RPMAXPeriodnvarchar30
59FBICRC002PNot in use9RPMAXPeriodnvarchar30
60FBICRC002TICRC: GL Accounts: Totals11RPMAXPeriodnvarchar30
61FBICRC003PNot in use9RPMAXPeriodnvarchar30
62FBICRC003TICRC: Open Items Customers/Vendors: Totals11RPMAXPeriodnvarchar30
TOPFinancial Services Localization
63/CEEIS/RUPPlan line items table10RPMAXPeriodnvarchar30
64/CEEIS/RUTTotals Table12RPMAXPeriodnvarchar30
TOPFlexible Real Estate Management
65VIPRLEDTAGRPPlaneinzelposten-Tabelle10RPMAXPeriodenvarchar30
66VIPRLEDTAGRTSummentabelle Ledger 7A Mandate11RPMAXPeriodenvarchar30
TOPFund Accounting
67FMCCAVCPPlan line items table9RPMAXPeriodnvarchar30
68FMCCAVCTTotals Table11RPMAXPeriodnvarchar30
69FMGLFLEXPGeneral Ledger: Plan Line Items8RPMAXPeriodnvarchar30
70FMGLFLEXTGeneral Ledger Public Sector: Total13RPMAXPeriodnvarchar30
71PSGLFLEXPGeneral Ledger: Plan Line Items8RPMAXPeriodnvarchar30
72PSGLFLEXTGeneral Ledger Public Sector: Total13RPMAXPeriodnvarchar30
TOPFunds Management
73FMIPPlan Line Items Table for Funds Management8RPMAXPeriodnvarchar30
74FMITTotals Table for Funds Management10RPMAXPeriodnvarchar30
75FMSPLITPPlan line items table9RPMAXPeriodnvarchar30
76FMSPLITTSummary table11RPMAXPeriodnvarchar30
77FMUSFGFACTS1PPlan line items table9RPMAXPeriodnvarchar30
78FMUSFGFACTS1TSummary table11RPMAXPeriodnvarchar30
79FMUSFGFACTS2PPlan line items table9RPMAXPeriodnvarchar30
80FMUSFGFACTS2TSummary table11RPMAXPeriodnvarchar30
81FMUSFGPPlan line items table9RPMAXPeriodnvarchar30
82FMUSFGTSummary table for US Federal Government11RPMAXPeriodnvarchar30
TOPGeneral Ledger Accounting
83FAGLFLEXPGeneral Ledger: Plan Line Items8RPMAXPeriodnvarchar30
84FAGLFLEXTGeneral Ledger: Totals13RPMAXPeriodnvarchar30
85GLFLEXPFlexible G/L: Plan line items8RPMAXPeriodnvarchar30
86GLFLEXTFlexible G/L: Totals13RPMAXPeriodnvarchar30
TOPGrantee Management
87GMAVCPPlan line items table10RPMAXPeriodnvarchar30
88GMAVCTSummary table12RPMAXPeriodnvarchar30
89GMIPPlan line items table9RPMAXPeriodnvarchar30
90GMITSummary table11RPMAXPeriodnvarchar30
TOPJoint Venture und Production Sharing Accounting
91JVGLFLEXPGeneral Ledger: Plan Line Items8RPMAXPeriodnvarchar30
92JVGLFLEXTGeneral Ledger: Totals13RPMAXPeriodnvarchar30
93JVPO1JVA: Plan Line Items10RPMAXPeriodnvarchar30
94JVPSC01PPlan line item table10RPMAXPeriodnvarchar30
95JVPSC01TSummary table12RPMAXPeriodnvarchar30
96JVT1JV Summary Table16RPMAXPeriodnvarchar30
97JVTO1JV Summary Table with Objects12RPMAXPeriodnvarchar30
98JVTO2JV Billing FI-SL Summary Table10RPMAXPeriodnvarchar30
TOPLocalization
99J_3RFTAXRPTax Accounting: Plan line item table10RPMAXPeriodnvarchar30
100J_3RFTAXRTTax Accounting: Summary table11RPMAXPeriodnvarchar30
101J_3RFTAXRVPTax Accounting: Plan line item table10RPMAXPeriodnvarchar30
102J_3RFTAXRVTTax Accounting: Summary table11RPMAXPeriodnvarchar30
TOPProfit Center Accounting
103GLPCPEC-PCA: Plan Line Items10RPMAXPeriodnvarchar30
104GLPCTEC-PCA: Totals Table12RPMAXPeriodnvarchar30
105T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material12RPMAXPeriodnvarchar30
TOPProfitability Analysis
106GLTPCProfit Center Accounting14RPMAXPeriodnvarchar30
TOPRegulatory reporting for insurance companies
107ISSRFLDEPPlan line items table10RPMAXPeriodnvarchar30
108ISSRFLDETSummary table12RPMAXPeriodnvarchar30
TOPRemaining Beverage - Obsolete Objects
109/BEV3/CHFIPPlan Line Items Table10RPMAXPeriodnvarchar30
110/BEV3/CHFITTotals table12RPMAXPeriodnvarchar30
111/BEV3/CHVGRPPlan Line Items Table10RPMAXPeriodnvarchar30
112/BEV3/CHVGRTTotals table12RPMAXPeriodnvarchar30
TOPRetail Ledger
113PCRRETAILPPlan line items table10RPMAXPeriodnvarchar30
114PCRRETAILTTotals Table12RPMAXPeriodnvarchar30
TOPSpecial Purpose Ledger
115/CCIS/PBU18PPBU18: Plan line item table10RPMAXPeriodnvarchar30
116/CCIS/PBU18TPBU18: Summary table x12RPMAXPeriodnvarchar30
117/CCIS/PROFTAXPPlan Line Items Table for General Ledger8RPMAXPeriodnvarchar30
118/CCIS/PROFTAXTTotals Table for General Ledger13RPMAXPeriodnvarchar30
TOPTariffs, Duties and Permits
119OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger10RPMAXPeriodnvarchar30
120OIHEDTSummary table, IS-OIL Excise Duty Special Ledger12RPMAXPeriodnvarchar30
121OIHSLTTDP (excise duty) special ledger summary table11RPMAXPeriodnvarchar30
TOPTransfer to Financial Accounting
122TRACTSLPPlan Line Items Table10RPMAXPeriodnvarchar30
123TRACTSLTTotals Table12RPMAXPeriodnvarchar30