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

46 columns | Print definition?ERP 6.0  | STAGR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000220000PSA for 0CO_OM_OPA_4 T90CLNT090 Orders: Statist. KFs9STAGRnvarchar60
2GLPCA_CTProfit Center Documents120STAGRStatistical key figurenvarchar60
3GLPCA_T_CTProfit Center Documents136STAGRStatistical key figurenvarchar60
4P2RA_STPayroll Result: Tax (Austria)13STAGRTax Calculation Procedurenvarchar10
5P2RH_ADOStructure of table ADO8STAGRTax calculation methodnvarchar10
6T5A2DTax Procedure and Reasons for Tax Exemption2STAGRTax Calculation Procedurenvarchar10
7T5A2TTax Procedure (A)2STAGRTax Calculation Procedurenvarchar10
8T5A2TTTax Procedure (A) Translation2STAGRTax Calculation Procedurenvarchar10
TOPActual Revenues and Forecast
9TEBCOCO/SD Interface: Product Number Determination from CO7STAGRKey conversion CO/SD: statistical key figurenvarchar60
TOPAdd-Ons for Billing
10AD04KSUAAssessment preprocessor: assign CostElem to StKeyFigures3STAGRStatistical key figurenvarchar60
TOPAustria
11PA0042HR Master Record: Infotype 0042 (Fiscal Data - Austria)32STAGRTax Calculation Procedurenvarchar10
TOPBasic Data
12TN30KHCO: Assign IS-H Key Figures to CO Statistical Key Figures5STAGRIS-HCO: Statistical key figure of Controllingnvarchar60
TOPBusiness Package for Manager Self-Service FI
13FCOM_KFPRICEKey Figure Prices3STAGRStatistical key figurenvarchar60
TOPCollectionsDisbursements
14GLISDEAActual Line Item Tables for Insurance (DE)28STAGRStatistical key figurenvarchar60
15GLISDECObject Table 2 for Insurance (DE)7STAGRStatistical key figurenvarchar60
16GLISDEPPlan Line Item Table for Insurance (DE)28STAGRStatistical key figurenvarchar60
17GLISDETSummary Table for Insurance (DE)27STAGRStatistical key figurenvarchar60
18GRISDEAActual Line Item Table for Insurance (DE) - Rollup28STAGRStatistical key figurenvarchar60
19GRISDECObject Table 2 for Insurance (DE) - Rollup7STAGRStatistical key figurenvarchar60
20GRISDEPPlan Line Item Table for Insurance (DE) - Rollup28STAGRStatistical key figurenvarchar60
21GRISDETSummary Table for Insurance (DE) - Rollup27STAGRStatistical key figurenvarchar60
TOPControlling
22COPPP_ITMCO Postprocessing List - Items26STAGRStatistical key figurenvarchar60
23TKA03Statistical key figures3STAGRStatistical key figurenvarchar60
TOPExpense-Related Billing
24PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines13STAGRStatistical key figurenvarchar60
TOPGeneral Ledger Accounting
25FAGLSKFGeneral Ledger: Statistical Key Figures (Current Values)2STAGRStatistical key figurenvarchar60
26FAGLSKF_PNGeneral Ledger; Statistical Key Figures (Source Document)2STAGRStatistical key figurenvarchar60
TOPOverhead Cost Controlling
27COEJRCO Object: Line Items for Stat. Key Figures (by Fiscal Year)46STAGRStatistical key figurenvarchar60
28COEPRCO Object: Line Items for Stat. Key Figs (by Period)16STAGRStatistical key figurenvarchar60
29COKRCO Object: Control Data for Statistical Key Figures7STAGRStatistical key figurenvarchar60
30COSRCO Object: Statistical Key Figure Totals7STAGRStatistical key figurenvarchar60
31TKT03Stat. key figure texts4STAGRStatistical key figurenvarchar60
TOPPayroll
32PA0163Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.)24STAGRAdószámítási eljárásnvarchar10
TOPProfit Center Accounting
33GLPCAEC-PCA: Actual Line Items91STAGRStatistical key figurenvarchar60
34GLPCCEC-PCA: Transaction Attributes13STAGRStatistical key figurenvarchar60
35GLPCPEC-PCA: Plan Line Items144STAGRStatistical key figurenvarchar60
36GLPCTEC-PCA: Totals Table101STAGRStatistical key figurenvarchar60
TOPProgress Analysis
37EVMTMeasurement methods PS EV9STAGRStatistical key figurenvarchar60
38EVSKStatistical key figures for progress4STAGRStatistical key figurenvarchar60
TOPReal Estate Management
39TIVSKZ2UEConversion of Statistical Key Figures for Apportionment Unit3STAGRStatistical key figurenvarchar60
TOPRetail Ledger
40PCRRETAILAActual line item table23STAGRStatistical key figurenvarchar60
41PCRRETAILCObject Table 25STAGRStatistical key figurenvarchar60
42PCRRETAILPPlan line items table23STAGRStatistical key figurenvarchar60
43PCRRETAILTTotals Table22STAGRStatistical key figurenvarchar60
TOPRevenues and Earnings
44AD01DLIDynamic items (DI)12STAGRStatistical key figurenvarchar60
TOPStructures
45PSSKF_DEFAU_TABDefault SKF for the the Project Parameters9STAGRStatistical key figurenvarchar60
46PSSKF_RATES_TABSave the SKF rates for the calculation of the work duration.4STAGRStatistical key figurenvarchar60