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

73 columns | Print definition?ERP 6.0  | LEDNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/XXBPDJF15 FI DUMMY4LEDNRnvarchar40
2AUAWSettlement Document: Accounts for WIP Settlement7LEDNRLedger for Controlling objectsnvarchar20
3CNVTDMS_05_COEPCollected Header Object Numbers for TDMS_Time-CO-OBJNR3LEDNRLEDNR f0r CNVTDMS_05_*nvarchar20
TOPAccounting
4RPSCOProject info database: Costs, revenues, finances3LEDNRBudget/Planning Ledgernvarchar40
TOPActual Payments and Forecast
5COFPDocument Lines (project cash management)63LEDNRBudget/Planning Ledgernvarchar40
TOPBasic Functions
6T872Equity Holdings Adjustments2LEDNRLedgernvarchar20
7T873Hidden reserves2LEDNRLedgernvarchar20
8T874Elimination of hidden reserves2LEDNRLedgernvarchar20
TOPBudgeting
9FMKF_TERM_RBKey Figures - FM Terms7LEDNRKey Figures - Ledgernvarchar20
TOPCost Center Accounting
10COSPRCO Objekt: Enhancement to COSP for Dependency Planning2LEDNRLedger for Controlling objectsnvarchar20
11TKSR1HSummarization log (header)5LEDNRLedger for Controlling objectsnvarchar20
TOPCost Object
12COEPBCO Object: Line Items Variance/Period-Based Results Analysis14LEDNRLedger for Controlling objectsnvarchar20
13COSBCO Object: Total Variances/Results Analyses2LEDNRLedger for Controlling objectsnvarchar20
14TKKABPosting Rules for Results Analysis Data4LEDNRLedger for Controlling objectsnvarchar20
TOPCosting
15COERSales Order Value Revenue2LEDNRLedger for Controlling objectsnvarchar20
TOPFunds Management
16BPDGTotal Values Entry Document4LEDNRBudget/Planning Ledgernvarchar40
17BPDJAnnual Values Entry Document4LEDNRBudget/Planning Ledgernvarchar40
18BPDPPeriod Values Entry Document4LEDNRBudget/Planning Ledgernvarchar40
19BPEGLine Item Overall Values Controlling Obj.8LEDNRBudget/Planning Ledgernvarchar40
20BPEJLine Item Annual Values Controlling Obj.9LEDNRBudget/Planning Ledgernvarchar40
21BPEPLine Item Period Values Controlling Obj.37LEDNRBudget/Planning Ledgernvarchar40
22BPGETotals Record for Total Value Controlling obj.2LEDNRBudget/Planning Ledgernvarchar40
23BPGVPrel.entry, overall4LEDNRBudget/Planning Ledgernvarchar40
24BPJATotals Record for Annual Total Controlling Obj.2LEDNRBudget/Planning Ledgernvarchar40
25BPJVPrel.entry - annual values4LEDNRBudget/Planning Ledgernvarchar40
26BPPETotals Record for Period Values Controlling Obj.2LEDNRBudget/Planning Ledgernvarchar40
27FCABKFI-CA: Document Header2LEDNRBudget/Planning Ledgernvarchar40
28FCABPFI-CA: Document Item2LEDNRBudget/Planning Ledgernvarchar40
29FMBEFI-FM Cash Levels2LEDNRBudget/Planning Ledgernvarchar40
30FMCFSITR-FM Selected Open Commitments2LEDNRBudget/Planning Ledgernvarchar40
31FMEPFI-FM Line Items2LEDNRBudget/Planning Ledgernvarchar40
32FMREFActive availability ctrl: Cross commitments reference table11LEDNRBudget/Planning Ledgernvarchar40
33FMSUFI-FM Totals Records2LEDNRBudget/Planning Ledgernvarchar40
34TBP0LBudget/Planning Ledger4LEDNRBudget/Planning Ledgernvarchar40
TOPInformation System, iViews
35COOI_PIBW CO-OM: Commitment Management: Deleted Line Items9LEDNRLedger for Controlling objectsnvarchar20
TOPLocal Currency Changeover
36EWUCOKException table for TWAER conversion3LEDNRLedger for Controlling objectsnvarchar20
TOPLocalization
37VIXCFRBUDGETBudget Seasonality Data5LEDNRLedger for Controlling objectsnvarchar20
TOPOrders for Projects
38COSPPTransfer of the Order in the COSP Table to the Project2LEDNRLedger for Controlling objectsnvarchar20
39COSSPTransfer of the Order COSS Table to the Project2LEDNRLedger for Controlling objectsnvarchar20
40FMSPCopy FMSU table order to project2LEDNRBudget/Planning Ledgernvarchar40
TOPOverhead Cost Controlling
41COEJCO Object: Line Items (by Fiscal Year)166LEDNRLedger for Controlling objectsnvarchar20
42COEJLCO Object: Line Items for Activity Types (by Fiscal Year)106LEDNRLedger for Controlling objectsnvarchar20
43COEJRCO Object: Line Items for Stat. Key Figures (by Fiscal Year)41LEDNRLedger for Controlling objectsnvarchar20
44COEJTCO Object: Line Items for Prices (by Fiscal Year)102LEDNRLedger for Controlling objectsnvarchar20
45COEPCO Object: Line Items (by Period)16LEDNRLedger for Controlling objectsnvarchar20
46COEPLCO Object: Line Items for Activity Types (by Period)16LEDNRLedger for Controlling objectsnvarchar20
47COEPRCO Object: Line Items for Stat. Key Figs (by Period)11LEDNRLedger for Controlling objectsnvarchar20
48COEPTCO Object: Line Items for Prices (by Period)12LEDNRLedger for Controlling objectsnvarchar20
49COKLCO Object: Control Data for Activity Types2LEDNRLedger for Controlling objectsnvarchar20
50COKPCO Object: Control Data for Primary Planning2LEDNRLedger for Controlling objectsnvarchar20
51COKRCO Object: Control Data for Statistical Key Figures2LEDNRLedger for Controlling objectsnvarchar20
52COKSCO Object: Control Data for Secondary Planning2LEDNRLedger for Controlling objectsnvarchar20
53COSLCO Object: Activity Type Totals2LEDNRLedger for Controlling objectsnvarchar20
54COSPCO Object: Cost Totals for External Postings2LEDNRLedger for Controlling objectsnvarchar20
55COSRCO Object: Statistical Key Figure Totals2LEDNRLedger for Controlling objectsnvarchar20
56COSSCO Object: Cost Totals for Internal Postings2LEDNRLedger for Controlling objectsnvarchar20
57COSTCO Object: Price Totals2LEDNRLedger for Controlling objectsnvarchar20
58COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis18LEDNRLedger for Controlling objectsnvarchar20
TOPOverhead Cost Orders
59COOICommitments Management: Line Items9LEDNRLedger for Controlling objectsnvarchar20
60COSBDCO Object: Total of variances/accruals, of which settled2LEDNRLedger for Controlling objectsnvarchar20
61COSLDCO Object: Activity Type Totals - of Which Settled2LEDNRLedger for Controlling objectsnvarchar20
62COSPDCO Object: Settled Primary Cost Totals2LEDNRLedger for Controlling objectsnvarchar20
63COSSDCO Object: Settled Secondary Cost Totals2LEDNRLedger for Controlling objectsnvarchar20
TOPPegging, Grouping, and Distribution
64DIS_TOBJS_FMSUDistribution: Objects distributed to per Group WBS (Cash)2LEDNRLedger for Controlling objectsnvarchar20
TOPProduct Cost Planning
65CKHSHeader: Unit Costing (Control + Totals)2LEDNRLedger for Controlling objectsnvarchar20
66CKHTTexts for CKHS2LEDNRLedger for Controlling objectsnvarchar20
67CKIPUnit Costing: Period Costs Line Item2LEDNRLedger for Controlling objectsnvarchar20
68CKISItems Unit Costing/Itemization Product Costing2LEDNRLedger for Controlling objectsnvarchar20
69CKITTexts for CKIS2LEDNRLedger for Controlling objectsnvarchar20
TOPProfitability Analysis
70CECOEJCO-PA Account Based Line Items168LEDNRLedger for Controlling objectsnvarchar20
71CECOEPCO-PA Account Based Line Items18LEDNRLedger for Controlling objectsnvarchar20
TOPReport Selection for Product Costing
72CKBOBKKB: Object Record (Fixed Database Portion)2LEDNRLedger for Controlling objectsnvarchar20
TOPSimulation
73VSRPSCO_CNVersion: Cumulation table for project reporting4LEDNRBudget/Planning Ledgernvarchar40