	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

104 columns | ERP 6.0 | TWAER

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SAPF15/F15	F15 Belege (Kopfdaten)	37	TWAER	Transaktionswährung	nvarchar	5	0
2	/SAPF15/F15H	F15 Belege (Kopfdaten Historie)	38	TWAER	Transaktionswährung	nvarchar	5	0
3	/SAPF15/XXBPDJ	F15 FI DUMMY	8	TWAER		nvarchar	5	0
4	AUAS	Settlement Document: Totals Segment	9	TWAER	Transaction Currency	nvarchar	5	0
5	AUAT	Settlement Document: Totals Segment Per Period	10	TWAER	Transaction Currency	nvarchar	5	0
6	AUAW	Settlement Document: Accounts for WIP Settlement	14	TWAER	Transaction Currency	nvarchar	5	0
7	CMCBD_BGT_CLAIM	Budget claims based on suggest level	14	TWAER	Transaction Currency	nvarchar	5	0
8	CNV_20100_COES	Duplicate COES keys (target values)	14	TWAER	Transaction Currency	nvarchar	5	0
9	FKKSK_VATLED	FI-CA Slovakia: VAT Ledger Exported Data	22	TWAER	Transaction Currency	nvarchar	5	0
10	FLQITEMMMPARK_FC	Liquidity Calculation - Forecast Line Items for MM Documents	13	TWAER	Transaction Currency	nvarchar	5	0
11	FLQITEMPARK_FC	Liquidity Calculation - Forecast Line Items for FI Documents	14	TWAER	Transaction Currency	nvarchar	5	0
TOPAccounting
12	RPSCO	Project info database: Costs, revenues, finances	12	TWAER	Transaction Currency	nvarchar	5	0
13	RPSQT	Project info database: quantities	11	TWAER	Transaction Currency	nvarchar	5	0
TOPActual Payments and Forecast
14	COFP	Document Lines (project cash management)	5	TWAER	Transaction Currency	nvarchar	5	0
TOPBasic Functions
15	FDS2	CM&F Line Items in SD Documents (fromr Release 4.0)	14	TWAER	Transaction Currency	nvarchar	5	0
16	FLQITEMC1_FC	Liquidity Calculation: Forecast from Securities	8	TWAER	Transaction Currency	nvarchar	5	0
TOPBudgeting and Availability Control
17	FMKOBP	Local Authority Funds Management Additional Data	9	TWAER	Transaction Currency	nvarchar	5	0
TOPCollectionsDisbursements
18	VVKKTAXREP	Tax Reporting ITA: Data for Tax Report	21	TWAER	Transaction Currency	nvarchar	5	0
TOPContract Accounts Receivable and Payable
19	DFKKITVATM	VAT monthly report for Italy: history table	6	TWAER	Transaction Currency	nvarchar	5	0
20	DFKKITVATQ	VAT quarterly report for Italy: history table	6	TWAER	Transaction Currency	nvarchar	5	0
21	DFKKREP06	Tax Report Data (Invoicing Time or Triggered)	19	TWAER	Transaction Currency	nvarchar	5	0
22	DFKKREP06_S	Tax Report Data - Shadow Table for Posting Date	19	TWAER	Transaction Currency	nvarchar	5	0
23	DFKKREP07	Tax Report Data (Clearing Time)	25	TWAER	Transaction Currency	nvarchar	5	0
24	DFKKREP07_T	Tax Report Data (Additional Data for Transfer Posting)	12	TWAER	Transaction Currency	nvarchar	5	0
25	DFKKREV06	Report for Tax on Sales/Purchases (bill. time or triggered)	15	TWAER	Transaction Currency	nvarchar	5	0
26	DFKKREV07	Report on Tax on Sales/Purchases (clearing time)	21	TWAER	Transaction Currency	nvarchar	5	0
TOPCost Center Accounting
27	COSPR	CO Objekt: Enhancement to COSP for Dependency Planning	13	TWAER	Transaction Currency	nvarchar	5	0
TOPCost Object
28	COEPB	CO Object: Line Items Variance/Period-Based Results Analysis	27	TWAER	Transaction Currency	nvarchar	5	0
29	COSB	CO Object: Total Variances/Results Analyses	14	TWAER	Transaction Currency	nvarchar	5	0
TOPCosting
30	COER	Sales Order Value Revenue	10	TWAER	Transaction Currency	nvarchar	5	0
31	COES	CO Object: Sales Order Value Line Items	13	TWAER	Transaction Currency	nvarchar	5	0
TOPData Retention Tool
32	TXW_S_COEP	Retrieve COEP from archive	42	TWAER	Transaction Currency	nvarchar	5	0
TOPExpense-Related Billing
33	PRSD_DMRP_ACC_CH	Engagement Mgmt: Accrual Characteristics for DMR Lines	6	TWAER	Transaction Currency	nvarchar	5	0
TOPFlexible Real Estate Management
34	VIAKHO13	WEG-Verwaltung: Umlage Eigentümerabrechnung	29	TWAER	Transaktionswährung	nvarchar	5	0
TOPFunds Management
35	BPDG	Total Values Entry Document	8	TWAER	Transaction Currency	nvarchar	5	0
36	BPDJ	Annual Values Entry Document	8	TWAER	Transaction Currency	nvarchar	5	0
37	BPDP	Period Values Entry Document	8	TWAER	Transaction Currency	nvarchar	5	0
38	BPEG	Line Item Overall Values Controlling Obj.	16	TWAER	Transaction Currency	nvarchar	5	0
39	BPEJ	Line Item Annual Values Controlling Obj.	18	TWAER	Transaction Currency	nvarchar	5	0
40	BPEP	Line Item Period Values Controlling Obj.	46	TWAER	Transaction Currency	nvarchar	5	0
41	BPGE	Totals Record for Total Value Controlling obj.	10	TWAER	Transaction Currency	nvarchar	5	0
42	BPGV	Prel.entry, overall	12	TWAER	Transaction Currency	nvarchar	5	0
43	BPJA	Totals Record for Annual Total Controlling Obj.	11	TWAER	Transaction Currency	nvarchar	5	0
44	BPJV	Prel.entry - annual values	13	TWAER	Transaction Currency	nvarchar	5	0
45	BPPE	Totals Record for Period Values Controlling Obj.	11	TWAER	Transaction Currency	nvarchar	5	0
46	FCABP	FI-CA: Document Item	6	TWAER	Transaction Currency	nvarchar	5	0
47	FMBE	FI-FM Cash Levels	9	TWAER	Transaction Currency	nvarchar	5	0
48	FMCFBPAKS	FM-FYC: Budget/Planning Updates (Interim Storage)	29	TWAER	Transaction Currency	nvarchar	5	0
49	FMCFSI	TR-FM Selected Open Commitments	10	TWAER	Transaction Currency	nvarchar	5	0
50	FMCFSIF	FI-FM: Selected Open Documents from FI Update	9	TWAER	Transaction Currency	nvarchar	5	0
51	FMCFSIF_TR	Selected Open FI Documents (Settlement)	9	TWAER	Transaction Currency	nvarchar	5	0
52	FMCFSIO	FI-FM: Selected Open Commitment Documents	16	TWAER	Transaction Currency	nvarchar	5	0
53	FMCFSIO_TR	FI-FM: Selected Open Commitment Documents	16	TWAER	Transaction Currency	nvarchar	5	0
54	FMEP	FI-FM Line Items	10	TWAER	Transaction Currency	nvarchar	5	0
55	FMICOIT	FM/CO integration: Line item	6	TWAER	Transaction Currency	nvarchar	5	0
56	FMIFIIT	FI Line Item Table in Funds Management	30	TWAER	Transaction Currency	nvarchar	5	0
57	FMIOI	Commitment Documents Funds Management	36	TWAER	Transaction Currency	nvarchar	5	0
58	FMREF	Active availability ctrl: Cross commitments reference table	12	TWAER	Transaction Currency	nvarchar	5	0
59	FMSU	FI-FM Totals Records	10	TWAER	Transaction Currency	nvarchar	5	0
60	FMUDBSEG	Addtl Info on Revenues Increasing Budget for Recovery Order	22	TWAER	Transaction Currency	nvarchar	5	0
61	FMUDBSEGH	Addtl Info on Revenues Increasing Budget for Recovery Order	20	TWAER	Transaction Currency	nvarchar	5	0
62	FMUDKBLP	Addtl Info re Revenues Increasing Budget for Fcst of Revenue	20	TWAER	Transaction Currency	nvarchar	5	0
63	FMUDKBLPH	Addtl Info re Revenues Increasing Budget for Fcst of Revenue	25	TWAER	Transaction Currency	nvarchar	5	0
TOPInformation System, iViews
64	COOI_PI	BW CO-OM: Commitment Management: Deleted Line Items	23	TWAER	Transaction Currency	nvarchar	5	0
TOPLocalization
65	ITFM_D_RESIDUALS	ITFM: Residuals: EFD Residuals data Table	17	TWAER	Transaction Currency	nvarchar	5	0
66	VIXCFRBUDGET	Budget Seasonality Data	13	TWAER	Transaction Currency	nvarchar	5	0
TOPOrders for Projects
67	COSPP	Transfer of the Order in the COSP Table to the Project	14	TWAER	Transaction Currency	nvarchar	5	0
68	COSSP	Transfer of the Order COSS Table to the Project	14	TWAER	Transaction Currency	nvarchar	5	0
69	FMSP	Copy FMSU table order to project	11	TWAER	Transaction Currency	nvarchar	5	0
TOPOverhead Cost Controlling
70	COEJ	CO Object: Line Items (by Fiscal Year)	180	TWAER	Transaction Currency	nvarchar	5	0
71	COEP	CO Object: Line Items (by Period)	30	TWAER	Transaction Currency	nvarchar	5	0
72	COKP	CO Object: Control Data for Primary Planning	13	TWAER	Transaction Currency	nvarchar	5	0
73	COKS	CO Object: Control Data for Secondary Planning	13	TWAER	Transaction Currency	nvarchar	5	0
74	COSP	CO Object: Cost Totals for External Postings	13	TWAER	Transaction Currency	nvarchar	5	0
75	COSS	CO Object: Cost Totals for Internal Postings	13	TWAER	Transaction Currency	nvarchar	5	0
76	COVP_DELTA_LOG	Log of COVP Delta Queue for Error Analysis	32	TWAER	Transaction Currency	nvarchar	5	0
TOPOverhead Cost Orders
77	COOI	Commitments Management: Line Items	23	TWAER	Transaction Currency	nvarchar	5	0
78	COSBD	CO Object: Total of variances/accruals, of which settled	14	TWAER	Transaction Currency	nvarchar	5	0
79	COSPD	CO Object: Settled Primary Cost Totals	13	TWAER	Transaction Currency	nvarchar	5	0
80	COSSD	CO Object: Settled Secondary Cost Totals	13	TWAER	Transaction Currency	nvarchar	5	0
TOPPegging, Grouping, and Distribution
81	DIS_TOBJS_COSP	Distribution: Objects distributed to per Group WBS (Cost)	12	TWAER	Transaction Currency	nvarchar	5	0
82	DIS_TOBJS_COSS	Distribution: Objects distributed to per Group WBS (Cost)	12	TWAER	Transaction Currency	nvarchar	5	0
83	DIS_TOBJS_FMSU	Distribution: Objects distributed to per Group WBS (Cash)	11	TWAER	Transaction Currency	nvarchar	5	0
TOPProduct Cost Planning
84	CKHS	Header: Unit Costing (Control + Totals)	72	TWAER	Item Foreign Currency	nvarchar	5	0
85	CKTC_CBEW	Costing Master Data - Attributes	7	TWAER	Currency Key	nvarchar	5	0
TOPProfitability Analysis
86	CECOEJ	CO-PA Account Based Line Items	182	TWAER	Transaction Currency	nvarchar	5	0
87	CECOEP	CO-PA Account Based Line Items	32	TWAER	Transaction Currency	nvarchar	5	0
TOPReal Estate Management
88	IVBP	Line Item (Settlement: Service Charge Collector) (Obsolete)	21	TWAER	Transaction Currency	nvarchar	5	0
89	VIAK13	Apportionment Result for List Evaluation (SCSettlement)	28	TWAER	Transaction Currency	nvarchar	5	0
TOPRevenues and Earnings
90	AD01DLI	Dynamic items (DI)	5	TWAER	Transaction Currency	nvarchar	5	0
TOPSimulation
91	VSRPSCO_CN	Version: Cumulation table for project reporting	13	TWAER	Transaction Currency	nvarchar	5	0
TOPTreasury
92	FLQITEMBS	Liquidity Calculation - Line Items for Bank Statement Docs	15	TWAER	Transaction Currency	nvarchar	5	0
93	FLQITEMD1_FC	Liquidity Calculation: Forecast Line Items from Loans	11	TWAER	Transaction Currency	nvarchar	5	0
94	FLQITEMFI	Liquidity Calculation - Line Items for Other FI Documents	13	TWAER	Transaction Currency	nvarchar	5	0
95	FLQITEMFI_FC	Liquidity Calculation - Forecast Line Items for FI Documents	13	TWAER	Transaction Currency	nvarchar	5	0
96	FLQITEMFI_TP	Liquidity Calculation: Actual Line Items at Top Level	15	TWAER	Transaction Currency	nvarchar	5	0
97	FLQITEMMA	Liquidity Calculation - Line Items for Manual Transfers	9	TWAER	Transaction Currency	nvarchar	5	0
98	FLQITEMPO_FC	Liquidity Calculation - Forecast Line Items for MM POs	13	TWAER	Transaction Currency	nvarchar	5	0
99	FLQITEMPR_FC	Liquidity Calc. Forecast - Line Items, Purchase Requisitions	10	TWAER	Transaction Currency	nvarchar	5	0
100	FLQITEMSO_FC	Liquidity Calculation-Forecast Line Items from Sales Orders	9	TWAER	Transaction Currency	nvarchar	5	0
101	FLQITEMT1_FC	Liquidity Calculation: Forecast Line Items from TR Trans.	12	TWAER	Transaction Currency	nvarchar	5	0
102	FLQSUM	Liquidity Calculation - Totals Records	4	TWAER	Transaction Currency	nvarchar	5	0
103	FLQSUM_FC	Liquidity Calculation - Forecast Totals Records	9	TWAER	Transaction Currency	nvarchar	5	0
104	FLQSUM_TP	Liquidity Calculation: Totals Records at Top Level	4	TWAER	Transaction Currency	nvarchar	5	0

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

104 columns | ERP 6.0 | TWAER