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

133 columns | Print definition?ERP 6.0  | WRTTP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/XXBPDJF15 FI DUMMY6WRTTPnvarchar20
2AUAWSettlement Document: Accounts for WIP Settlement9WRTTPValue Typenvarchar20
3CNV_20100_COESDuplicate COES keys (target values)8WRTTPnvarchar20
TOPAccounting
4RPSCOProject info database: Costs, revenues, finances4WRTTPValue Typenvarchar20
5RPSQTProject info database: quantities3WRTTPValue Typenvarchar20
TOPActual Payments and Forecast
6COFPDocument Lines (project cash management)9WRTTPValue Typenvarchar20
TOPAvailability Control
7FMAVCUPDFILTVAVC Filter Settings for Posting Data: Excluded Value Types5WRTTPValue Typenvarchar20
TOPBudgeting
8BUWRTTPMapping rules for migration from FBS to BCS - Field WRTTP1WRTTPValue Typenvarchar20
9FMKF_TERM_RBKey Figures - FM Terms8WRTTPKey Figures - Value Typenvarchar20
TOPBudgeting and Availability Control
10FMFCTRMVStore Bgt vals. returned before moving funds ctr.5WRTTPValue Typenvarchar20
11FMKOBPLocal Authority Funds Management Additional Data4WRTTPValue Typenvarchar20
TOPCost Center Accounting
12COSPRCO Objekt: Enhancement to COSP for Dependency Planning5WRTTPValue Typenvarchar20
13TKSR3Summarization - value type3WRTTPValue Typenvarchar20
14TKSR3HSummarization log - value types5WRTTPValue typenvarchar20
TOPCost Element Accounting
15COFIO2Transaction-dependent fields for reconciliation ledger6WRTTPValue Typenvarchar20
16COFIPSingle plan items for reconciliation ledger37WRTTPValue Typenvarchar20
17COFISActual line items for reconciliation ledger37WRTTPValue Typenvarchar20
18COFITTotals Records for Reconciliation Ledger36WRTTPValue Typenvarchar20
TOPCost Object
19COEPBCO Object: Line Items Variance/Period-Based Results Analysis17WRTTPValue Typenvarchar20
20COSBCO Object: Total Variances/Results Analyses5WRTTPValue Typenvarchar20
TOPCosting
21COERSales Order Value Revenue5WRTTPValue Typenvarchar20
22COESCO Object: Sales Order Value Line Items7WRTTPValue Typenvarchar20
TOPData Collection
23CF003Projects34WRTTPValue type in order cost segmentnvarchar10
TOPExpense-Related Billing
24PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines15WRTTPValue Typenvarchar20
TOPFunctions for U.S. Federal Government
25FMFG_UO_OBL_FMVTSO Adjustmnt Prog: Value Types to include in Obligations2WRTTPUnfilled Orders: Value Typenvarchar20
TOPFunds Management
26BPCGControlling Object, by Year5WRTTPValue Typenvarchar20
27BPCJControlling Object, by Year5WRTTPValue Typenvarchar20
28BPCKControlling objects, activated objects5WRTTPValue Typenvarchar20
29BPDGTotal Values Entry Document6WRTTPValue Typenvarchar20
30BPDJAnnual Values Entry Document6WRTTPValue Typenvarchar20
31BPDPPeriod Values Entry Document6WRTTPValue Typenvarchar20
32BPEGLine Item Overall Values Controlling Obj.12WRTTPValue Typenvarchar20
33BPEJLine Item Annual Values Controlling Obj.13WRTTPValue Typenvarchar20
34BPEPLine Item Period Values Controlling Obj.41WRTTPValue Typenvarchar20
35BPGETotals Record for Total Value Controlling obj.6WRTTPValue Typenvarchar20
36BPGVPrel.entry, overall8WRTTPValue Typenvarchar20
37BPHICross-hierarchy Data Controlling obj.3WRTTPValue Typenvarchar20
38BPIGBudget Object Index (Overall Budget)5WRTTPValue Typenvarchar20
39BPIJBudget Object Index (Annual Budget)5WRTTPValue Typenvarchar20
40BPJATotals Record for Annual Total Controlling Obj.6WRTTPValue Typenvarchar20
41BPJVPrel.entry - annual values8WRTTPValue Typenvarchar20
42BPPETotals Record for Period Values Controlling Obj.6WRTTPValue Typenvarchar20
43BPTRObject Data Controlling Obj.5WRTTPValue Typenvarchar20
44BPTXBudgeting Text5WRTTPValue Typenvarchar20
45FCABKFI-CA: Document Header7WRTTPValue Typenvarchar20
46FCABPFI-CA: Document Item10WRTTPValue Typenvarchar20
47FM01DFBudget Type: Assignment to Cover Eligibility5WRTTPValue Typenvarchar20
48FM2BLACTCFM2BL - Activation of Commitment/Actual Value Types4WRTTPValue Typenvarchar20
49FMAC2FM to FI - GL Account Assignment3WRTTPGeneric entry for FM value typesnvarchar20
50FMBEFI-FM Cash Levels6WRTTPValue Typenvarchar20
51FMCCFDFiscal Year Change Documents (FM)34WRTTPValue Typenvarchar20
52FMCCFLOTCommitment Carryforward of Held Documents (Approval Proc.)20WRTTPValue Typenvarchar20
53FMCFC1FYC Commitment Control5WRTTPValue Typenvarchar20
54FMCFC1RFYC Commtiment Control (Carryforward Parameter)4WRTTPFM Cmmt Carryfwd:Vlue Catgs of Docs that can be Carried Frwdnvarchar20
55FMCFSITR-FM Selected Open Commitments19WRTTPValue Typenvarchar20
56FMCFSIFFI-FM: Selected Open Documents from FI Update16WRTTPValue Typenvarchar20
57FMCFSIF_TRSelected Open FI Documents (Settlement)16WRTTPValue Typenvarchar20
58FMCFSIOFI-FM: Selected Open Commitment Documents19WRTTPValue Typenvarchar20
59FMCFSIO_TRFI-FM: Selected Open Commitment Documents19WRTTPValue Typenvarchar20
60FMCHA1Work List for Reassignment Tool13WRTTPValue Typenvarchar20
61FMCNAIFM Line Items with Active CCN Logic8WRTTPValue Typenvarchar20
62FMCOPICO-FM: Plan Data Transfer - Annual/Overall Values15WRTTPValue Typenvarchar20
63FMEPFI-FM Line Items7WRTTPValue Typenvarchar20
64FMICOITFM/CO integration: Line item5WRTTPValue Typenvarchar20
65FMIFIITFI Line Item Table in Funds Management26WRTTPValue Typenvarchar20
66FMIOObject Table for Funds Management11WRTTPValue Typenvarchar20
67FMIOICommitment Documents Funds Management32WRTTPValue Typenvarchar20
68FMREFActive availability ctrl: Cross commitments reference table6WRTTPValue Typenvarchar20
69FMSUFI-FM Totals Records7WRTTPValue Typenvarchar20
70FMUP01Update Control with Value Type Dependency2WRTTPValue Typenvarchar20
71FMUP02Customizbare Felder zum Fortschreibungsprofil3WRTTPValue Typenvarchar20
72TBP1CBudget/Plan Profile4WRTTPValue Typenvarchar20
73TBP1TBudget / Plan Profile Texts5WRTTPValue Typenvarchar20
74TBP3ABudget / plan versions from rel.3.04WRTTPValue Typenvarchar20
75TBP3BTexts for planning / budgeting versions5WRTTPValue Typenvarchar20
76TBPFDCost Budget Availability Control: Tolerance Limits3WRTTPValue Typenvarchar20
77TBPFEFM Availability Control: Tolerance Limits5WRTTPValue Typenvarchar20
78TBPFPVCommitment Types: Control4WRTTPCommitment value typenvarchar20
TOPInformation System
79BIWTCSH_CVTexts: Payment Characteristics2WRTTPValue Typenvarchar20
80BIW_CSH_CVConversion Table for Payments2WRTTPValue Typenvarchar20
TOPInformation system
81FMKF_REPTERMKey Figure Terms for Reporting Because of New Budget Tables6WRTTPKey Figures - Value Typenvarchar20
TOPInformation System, iViews
82COOI_PIBW CO-OM: Commitment Management: Deleted Line Items17WRTTPValue Typenvarchar20
TOPLocal Currency Changeover
83EWUCOKException table for TWAER conversion6WRTTPValue Typenvarchar20
TOPLocalization
84VIXCFRBUDGETBudget Seasonality Data3WRTTPValue Typenvarchar20
TOPMaintenance History
85/OLC/PMCO_OPOLC: PMCO for operations5WRTTPValue Typenvarchar20
86PMCOCost structure of maintenance order5WRTTPValue Typenvarchar20
87PMCO3Plan version: Estimated costs for maintenance orders4WRTTPValue Typenvarchar20
88PMCO_OPCost structure of maintenance order5WRTTPValue Typenvarchar20
TOPMaintenance Orders
89PMCOQTQuantity structure for the maintenance order5WRTTPValue Typenvarchar20
90PMCOQT_OPQuantity structure for the maintenance order5WRTTPValue Typenvarchar20
TOPMaster Data Distribution
91/ISDFPS/FMWRTTPValue Types1WRTTPVersion Number Componentnvarchar20
92/ISDFPS/FMWRTTPHValue Types1WRTTPVersion Number Componentnvarchar20
TOPOrders for Projects
93COSPPTransfer of the Order in the COSP Table to the Project5WRTTPValue Typenvarchar20
94COSSPTransfer of the Order COSS Table to the Project5WRTTPValue Typenvarchar20
95FMSPCopy FMSU table order to project7WRTTPValue Typenvarchar20
TOPOverhead Cost Controlling
96COEJCO Object: Line Items (by Fiscal Year)169WRTTPValue Typenvarchar20
97COEJLCO Object: Line Items for Activity Types (by Fiscal Year)109WRTTPValue Typenvarchar20
98COEJRCO Object: Line Items for Stat. Key Figures (by Fiscal Year)44WRTTPValue Typenvarchar20
99COEJTCO Object: Line Items for Prices (by Fiscal Year)105WRTTPValue Typenvarchar20
100COEPCO Object: Line Items (by Period)19WRTTPValue Typenvarchar20
101COEPLCO Object: Line Items for Activity Types (by Period)19WRTTPValue Typenvarchar20
102COEPRCO Object: Line Items for Stat. Key Figs (by Period)14WRTTPValue Typenvarchar20
103COEPTCO Object: Line Items for Prices (by Period)15WRTTPValue Typenvarchar20
104COKPCO Object: Control Data for Primary Planning5WRTTPValue Typenvarchar20
105COKRCO Object: Control Data for Statistical Key Figures5WRTTPValue Typenvarchar20
106COKSCO Object: Control Data for Secondary Planning5WRTTPValue Typenvarchar20
107COSLCO Object: Activity Type Totals5WRTTPValue Typenvarchar20
108COSPCO Object: Cost Totals for External Postings5WRTTPValue Typenvarchar20
109COSRCO Object: Statistical Key Figure Totals5WRTTPValue Typenvarchar20
110COSSCO Object: Cost Totals for Internal Postings5WRTTPValue Typenvarchar20
111COSTCO Object: Price Totals5WRTTPValue Typenvarchar20
112COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis21WRTTPValue Typenvarchar20
TOPOverhead Cost Orders
113AUAKDocument Header for Settlement33WRTTPValue Typenvarchar20
114COOICommitments Management: Line Items17WRTTPValue Typenvarchar20
115COSBDCO Object: Total of variances/accruals, of which settled5WRTTPValue Typenvarchar20
116COSLDCO Object: Activity Type Totals - of Which Settled5WRTTPValue Typenvarchar20
117COSPDCO Object: Settled Primary Cost Totals5WRTTPValue Typenvarchar20
118COSSDCO Object: Settled Secondary Cost Totals5WRTTPValue Typenvarchar20
TOPPegging, Grouping, and Distribution
119DIS_TOBJSDistribution: cost objects posted to per group5WRTTPValue Typenvarchar20
120DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)7WRTTPValue Typenvarchar20
121DIS_TOBJS_COSSDistribution: Objects distributed to per Group WBS (Cost)6WRTTPValue Typenvarchar20
122DIS_TOBJS_FMSUDistribution: Objects distributed to per Group WBS (Cash)8WRTTPValue Typenvarchar20
TOPPersonnel Management
123/BKC/S21_A_WRTTPClone and Test - AC - Planned Value Types2WRTTPValue Typenvarchar20
TOPProfitability Analysis
124CECOEJCO-PA Account Based Line Items171WRTTPValue Typenvarchar20
125CECOEPCO-PA Account Based Line Items21WRTTPValue Typenvarchar20
TOPProfitability Analysis Basic Functions
126K840001Summarization level KT: 800 KK 01 KKROBJ 00000121WRTTPValue Typenvarchar20
127K840003Summarization level KT: 800 KK 01 KKROBJ 00000216WRTTPValue Typenvarchar20
128K840005Summarization level KT: 800 KK 01 KKROBJ 00000323WRTTPValue Typenvarchar20
129K840007Summarization level KT: 800 KK 01 KKROBJ 00000418WRTTPValue Typenvarchar20
130K840009Summarization level KT: 800 KK 01 KKROBJ 00000524WRTTPValue Typenvarchar20
131K840011Summarization level KT: 800 KK 01 KKROBJ 00000619WRTTPValue Typenvarchar20
TOPRevenues and Earnings
132AD01DLIDynamic items (DI)14WRTTPValue Typenvarchar20
TOPSimulation
133VSRPSCO_CNVersion: Cumulation table for project reporting5WRTTPValue Typenvarchar20