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

104 columns | Print definition?ERP 6.0  | TWAER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/F15F15 Belege (Kopfdaten)37TWAERTransaktionswährungnvarchar50
2/SAPF15/F15HF15 Belege (Kopfdaten Historie)38TWAERTransaktionswährungnvarchar50
3/SAPF15/XXBPDJF15 FI DUMMY8TWAERnvarchar50
4AUASSettlement Document: Totals Segment9TWAERTransaction Currencynvarchar50
5AUATSettlement Document: Totals Segment Per Period10TWAERTransaction Currencynvarchar50
6AUAWSettlement Document: Accounts for WIP Settlement14TWAERTransaction Currencynvarchar50
7CMCBD_BGT_CLAIMBudget claims based on suggest level14TWAERTransaction Currencynvarchar50
8CNV_20100_COESDuplicate COES keys (target values)14TWAERTransaction Currencynvarchar50
9FKKSK_VATLEDFI-CA Slovakia: VAT Ledger Exported Data22TWAERTransaction Currencynvarchar50
10FLQITEMMMPARK_FCLiquidity Calculation - Forecast Line Items for MM Documents13TWAERTransaction Currencynvarchar50
11FLQITEMPARK_FCLiquidity Calculation - Forecast Line Items for FI Documents14TWAERTransaction Currencynvarchar50
TOPAccounting
12RPSCOProject info database: Costs, revenues, finances12TWAERTransaction Currencynvarchar50
13RPSQTProject info database: quantities11TWAERTransaction Currencynvarchar50
TOPActual Payments and Forecast
14COFPDocument Lines (project cash management)5TWAERTransaction Currencynvarchar50
TOPBasic Functions
15FDS2CM&F Line Items in SD Documents (fromr Release 4.0)14TWAERTransaction Currencynvarchar50
16FLQITEMC1_FCLiquidity Calculation: Forecast from Securities8TWAERTransaction Currencynvarchar50
TOPBudgeting and Availability Control
17FMKOBPLocal Authority Funds Management Additional Data9TWAERTransaction Currencynvarchar50
TOPCollectionsDisbursements
18VVKKTAXREPTax Reporting ITA: Data for Tax Report21TWAERTransaction Currencynvarchar50
TOPContract Accounts Receivable and Payable
19DFKKITVATMVAT monthly report for Italy: history table6TWAERTransaction Currencynvarchar50
20DFKKITVATQVAT quarterly report for Italy: history table6TWAERTransaction Currencynvarchar50
21DFKKREP06Tax Report Data (Invoicing Time or Triggered)19TWAERTransaction Currencynvarchar50
22DFKKREP06_STax Report Data - Shadow Table for Posting Date19TWAERTransaction Currencynvarchar50
23DFKKREP07Tax Report Data (Clearing Time)25TWAERTransaction Currencynvarchar50
24DFKKREP07_TTax Report Data (Additional Data for Transfer Posting)12TWAERTransaction Currencynvarchar50
25DFKKREV06Report for Tax on Sales/Purchases (bill. time or triggered)15TWAERTransaction Currencynvarchar50
26DFKKREV07Report on Tax on Sales/Purchases (clearing time)21TWAERTransaction Currencynvarchar50
TOPCost Center Accounting
27COSPRCO Objekt: Enhancement to COSP for Dependency Planning13TWAERTransaction Currencynvarchar50
TOPCost Object
28COEPBCO Object: Line Items Variance/Period-Based Results Analysis27TWAERTransaction Currencynvarchar50
29COSBCO Object: Total Variances/Results Analyses14TWAERTransaction Currencynvarchar50
TOPCosting
30COERSales Order Value Revenue10TWAERTransaction Currencynvarchar50
31COESCO Object: Sales Order Value Line Items13TWAERTransaction Currencynvarchar50
TOPData Retention Tool
32TXW_S_COEPRetrieve COEP from archive42TWAERTransaction Currencynvarchar50
TOPExpense-Related Billing
33PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines6TWAERTransaction Currencynvarchar50
TOPFlexible Real Estate Management
34VIAKHO13WEG-Verwaltung: Umlage Eigentümerabrechnung29TWAERTransaktionswährungnvarchar50
TOPFunds Management
35BPDGTotal Values Entry Document8TWAERTransaction Currencynvarchar50
36BPDJAnnual Values Entry Document8TWAERTransaction Currencynvarchar50
37BPDPPeriod Values Entry Document8TWAERTransaction Currencynvarchar50
38BPEGLine Item Overall Values Controlling Obj.16TWAERTransaction Currencynvarchar50
39BPEJLine Item Annual Values Controlling Obj.18TWAERTransaction Currencynvarchar50
40BPEPLine Item Period Values Controlling Obj.46TWAERTransaction Currencynvarchar50
41BPGETotals Record for Total Value Controlling obj.10TWAERTransaction Currencynvarchar50
42BPGVPrel.entry, overall12TWAERTransaction Currencynvarchar50
43BPJATotals Record for Annual Total Controlling Obj.11TWAERTransaction Currencynvarchar50
44BPJVPrel.entry - annual values13TWAERTransaction Currencynvarchar50
45BPPETotals Record for Period Values Controlling Obj.11TWAERTransaction Currencynvarchar50
46FCABPFI-CA: Document Item6TWAERTransaction Currencynvarchar50
47FMBEFI-FM Cash Levels9TWAERTransaction Currencynvarchar50
48FMCFBPAKSFM-FYC: Budget/Planning Updates (Interim Storage)29TWAERTransaction Currencynvarchar50
49FMCFSITR-FM Selected Open Commitments10TWAERTransaction Currencynvarchar50
50FMCFSIFFI-FM: Selected Open Documents from FI Update9TWAERTransaction Currencynvarchar50
51FMCFSIF_TRSelected Open FI Documents (Settlement)9TWAERTransaction Currencynvarchar50
52FMCFSIOFI-FM: Selected Open Commitment Documents16TWAERTransaction Currencynvarchar50
53FMCFSIO_TRFI-FM: Selected Open Commitment Documents16TWAERTransaction Currencynvarchar50
54FMEPFI-FM Line Items10TWAERTransaction Currencynvarchar50
55FMICOITFM/CO integration: Line item6TWAERTransaction Currencynvarchar50
56FMIFIITFI Line Item Table in Funds Management30TWAERTransaction Currencynvarchar50
57FMIOICommitment Documents Funds Management36TWAERTransaction Currencynvarchar50
58FMREFActive availability ctrl: Cross commitments reference table12TWAERTransaction Currencynvarchar50
59FMSUFI-FM Totals Records10TWAERTransaction Currencynvarchar50
60FMUDBSEGAddtl Info on Revenues Increasing Budget for Recovery Order22TWAERTransaction Currencynvarchar50
61FMUDBSEGHAddtl Info on Revenues Increasing Budget for Recovery Order20TWAERTransaction Currencynvarchar50
62FMUDKBLPAddtl Info re Revenues Increasing Budget for Fcst of Revenue20TWAERTransaction Currencynvarchar50
63FMUDKBLPHAddtl Info re Revenues Increasing Budget for Fcst of Revenue25TWAERTransaction Currencynvarchar50
TOPInformation System, iViews
64COOI_PIBW CO-OM: Commitment Management: Deleted Line Items23TWAERTransaction Currencynvarchar50
TOPLocalization
65ITFM_D_RESIDUALSITFM: Residuals: EFD Residuals data Table17TWAERTransaction Currencynvarchar50
66VIXCFRBUDGETBudget Seasonality Data13TWAERTransaction Currencynvarchar50
TOPOrders for Projects
67COSPPTransfer of the Order in the COSP Table to the Project14TWAERTransaction Currencynvarchar50
68COSSPTransfer of the Order COSS Table to the Project14TWAERTransaction Currencynvarchar50
69FMSPCopy FMSU table order to project11TWAERTransaction Currencynvarchar50
TOPOverhead Cost Controlling
70COEJCO Object: Line Items (by Fiscal Year)180TWAERTransaction Currencynvarchar50
71COEPCO Object: Line Items (by Period)30TWAERTransaction Currencynvarchar50
72COKPCO Object: Control Data for Primary Planning13TWAERTransaction Currencynvarchar50
73COKSCO Object: Control Data for Secondary Planning13TWAERTransaction Currencynvarchar50
74COSPCO Object: Cost Totals for External Postings13TWAERTransaction Currencynvarchar50
75COSSCO Object: Cost Totals for Internal Postings13TWAERTransaction Currencynvarchar50
76COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis32TWAERTransaction Currencynvarchar50
TOPOverhead Cost Orders
77COOICommitments Management: Line Items23TWAERTransaction Currencynvarchar50
78COSBDCO Object: Total of variances/accruals, of which settled14TWAERTransaction Currencynvarchar50
79COSPDCO Object: Settled Primary Cost Totals13TWAERTransaction Currencynvarchar50
80COSSDCO Object: Settled Secondary Cost Totals13TWAERTransaction Currencynvarchar50
TOPPegging, Grouping, and Distribution
81DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)12TWAERTransaction Currencynvarchar50
82DIS_TOBJS_COSSDistribution: Objects distributed to per Group WBS (Cost)12TWAERTransaction Currencynvarchar50
83DIS_TOBJS_FMSUDistribution: Objects distributed to per Group WBS (Cash)11TWAERTransaction Currencynvarchar50
TOPProduct Cost Planning
84CKHSHeader: Unit Costing (Control + Totals)72TWAERItem Foreign Currencynvarchar50
85CKTC_CBEWCosting Master Data - Attributes7TWAERCurrency Keynvarchar50
TOPProfitability Analysis
86CECOEJCO-PA Account Based Line Items182TWAERTransaction Currencynvarchar50
87CECOEPCO-PA Account Based Line Items32TWAERTransaction Currencynvarchar50
TOPReal Estate Management
88IVBPLine Item (Settlement: Service Charge Collector) (Obsolete)21TWAERTransaction Currencynvarchar50
89VIAK13Apportionment Result for List Evaluation (SCSettlement)28TWAERTransaction Currencynvarchar50
TOPRevenues and Earnings
90AD01DLIDynamic items (DI)5TWAERTransaction Currencynvarchar50
TOPSimulation
91VSRPSCO_CNVersion: Cumulation table for project reporting13TWAERTransaction Currencynvarchar50
TOPTreasury
92FLQITEMBSLiquidity Calculation - Line Items for Bank Statement Docs15TWAERTransaction Currencynvarchar50
93FLQITEMD1_FCLiquidity Calculation: Forecast Line Items from Loans11TWAERTransaction Currencynvarchar50
94FLQITEMFILiquidity Calculation - Line Items for Other FI Documents13TWAERTransaction Currencynvarchar50
95FLQITEMFI_FCLiquidity Calculation - Forecast Line Items for FI Documents13TWAERTransaction Currencynvarchar50
96FLQITEMFI_TPLiquidity Calculation: Actual Line Items at Top Level15TWAERTransaction Currencynvarchar50
97FLQITEMMALiquidity Calculation - Line Items for Manual Transfers9TWAERTransaction Currencynvarchar50
98FLQITEMPO_FCLiquidity Calculation - Forecast Line Items for MM POs13TWAERTransaction Currencynvarchar50
99FLQITEMPR_FCLiquidity Calc. Forecast - Line Items, Purchase Requisitions10TWAERTransaction Currencynvarchar50
100FLQITEMSO_FCLiquidity Calculation-Forecast Line Items from Sales Orders9TWAERTransaction Currencynvarchar50
101FLQITEMT1_FCLiquidity Calculation: Forecast Line Items from TR Trans.12TWAERTransaction Currencynvarchar50
102FLQSUMLiquidity Calculation - Totals Records4TWAERTransaction Currencynvarchar50
103FLQSUM_FCLiquidity Calculation - Forecast Totals Records9TWAERTransaction Currencynvarchar50
104FLQSUM_TPLiquidity Calculation: Totals Records at Top Level4TWAERTransaction Currencynvarchar50