	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 | KEYDATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/CFMFND/MDCRLOCK	Dummytabelle für Sperrobjekt	3	KEYDATE	Stichtag für das Inkrafttretten der Änderung	nvarchar	8	0
2	CMM_MTM_PO	MtM per Purchase Order	61	KEYDATE	Maturity Key Date	nvarchar	8	0
3	CMM_MTM_SO	MtM per Sales Order	58	KEYDATE	Maturity Key Date	nvarchar	8	0
4	JBRDBCOMBEWEG	RM: DB Table BEWEG Extended Category of Primary Transaction	27	KEYDATE	Maturity Key Date	nvarchar	8	0
5	JBRHCOMBEWEG	hRM: Version Table BEWEG for Extended Cat. of Primary Trans.	28	KEYDATE	Maturity Key Date	nvarchar	8	0
6	JBRSVCOMBEWEG	RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets	28	KEYDATE	Maturity Key Date	nvarchar	8	0
7	PIQDB_DE_STATHDR	Header Table for Statistical Reporting Germany	11	KEYDATE	Field of type DATS	nvarchar	8	0
8	RDBRA_LZB_PERIOD	RA RDB: Periods of a maturity band	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
9	RDBRA_NSUM_CFAR	RA: Final Results for Cash Flow at Risk	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
10	RDBRA_NSUM_CFP	RA: Final Results Positions (Delta/Gamma) of Cashflows	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
11	RDBRA_NSUM_CFPL	RA: Final Results for P&L Distributions of Cashflows	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
12	RDBRA_REC_CF	RA RDB: Single Records for Cashflows in Eval. Currency	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
13	RDBRA_REC_CFP	RA RDB: Single Records for Delta/Gamma of Cashflows	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
14	RDBRA_REC_CFPL	RA RDB: Single Records for Key Figure Cat. P&L for Cashflows	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
15	RDBRA_RNDM_WALK	RA RDB: Random Walks	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
16	RDBRA_SUM_CF	RA RDB: Final Results for Cashflows in Evaluation Currency	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
17	RSBPCW_LCK_DIM	BPC Work Status - Lock Dimension Table	11	KEYDATE	Field of type DATS	nvarchar	8	0
18	TBAC_DCS_FWD_KD	Key Dates of Derivative Contracts for Forwards	3	KEYDATE	Maturity Key Date	nvarchar	8	0
19	TBAC_DCS_FWD_KDP	Period table for commodity forward index	3	KEYDATE	Maturity Key Date	nvarchar	8	0
20	TBAC_DCS_FWD_KDT	Text Table for key date	3	KEYDATE	Maturity Key Date	nvarchar	8	0
21	TBAC_DCS_KD	Key Dates of Derivative Contracts	3	KEYDATE	Maturity Key Date	nvarchar	8	0
22	TBAC_DCS_KDT	Text Table for key date	3	KEYDATE	Maturity Key Date	nvarchar	8	0
23	TBAC_DCS_KD_PRDS	DCS Periods	3	KEYDATE	Maturity Key Date	nvarchar	8	0
24	TBAT_PRICEQUOT	Derivative Contract Specification: Price Quotations	4	KEYDATE	Maturity Key Date	nvarchar	8	0
25	TBAT_PRICEQUOT_F	Derivative Contract Specification: Price Quotations Futures	4	KEYDATE	Maturity Key Date	nvarchar	8	0
26	TBAT_PRICEQUOT_O	Derivative Contract Specification: Price Quotations Options	4	KEYDATE	Maturity Key Date	nvarchar	8	0
27	TBAT_PRICE_FWD	Derivative Contract Specification: Commodity Forward Prices	4	KEYDATE	Maturity Key Date	nvarchar	8	0
28	TEXT_CTY_EXPOS	Commodity Price Exposure	22	KEYDATE	Maturity Key Date	nvarchar	8	0
29	TEXT_POSF_DCS_PR	Exposure Position Flow DCS Pricing Data	7	KEYDATE	Maturity Key Date	nvarchar	8	0
30	TEXT_REXP_DCS_PR	Raw Exposure Item DCS Pricing Data	11	KEYDATE	Maturity Key Date	nvarchar	8	0
31	THAEXT_TRAN_DCSP	Commodity exposure DCS pricing data	12	KEYDATE	Maturity Key Date	nvarchar	8	0
32	TLRT_THM_RES_H	Threshold Result Header Data	5	KEYDATE	Key Date for Calculation of Notional Amounts	nvarchar	8	0
33	PIQDBAUDR0	Audits	13	KEYDATE	Key Date	nvarchar	8	0
TOPAnalyzer
34	AFWGO_CALCADMIN	Management of Analysis Runs for Each Eval. Proc. 2	2	KEYDATE	Evaluation Date	nvarchar	8	0
35	AFWGO_FO_REWORK	Management of Financial Objects to be Postprocessed Per EP1	2	KEYDATE	Evaluation Date	nvarchar	8	0
36	AFWGO_LOADADMIN	Management of Single Records Procedures per Date	2	KEYDATE	Evaluation Date	nvarchar	8	0
37	AFWGO_LOGHISTORY	History of Application Logs in Single Records Procedure	2	KEYDATE	Evaluation Date	nvarchar	8	0
38	RDBAA_REC_CCYPOS	"Generic" Single Record Items with Currency	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
39	RDBAA_REC_HEADER	Single Record Header for Accounting Analyzer	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
40	RDBAA_SUM_CURR	Final Results for Additive Key Figures in Currency: TRM-AA	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
41	RDBAA_SUM_GEN	Final Results for Additive Generic Key Figures: TRM-AA	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
42	RDB_I9REC	RDB: Single Record Characteristics (Generation Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
43	RDB_KFCREC_TEM	Single Record Item Table for Key Fig. Category (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
44	RDB_NSUM_CURR	Final Results for Non-Add. Key Figures in Crcy (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
45	RDB_NSUM_GEN	Final Results for Non-Add. Generic Key Figures (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
46	RDB_REC_CHAR	RDB: Single Record Characteristics (Generation Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
47	RDB_REC_CURRPOS	Currently Not Used	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
48	RDB_REC_CURRPOS1	Single Record Items: Generic Key Figs with Crcy (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
49	RDB_REC_GENPOS	Currently Not Used	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
50	RDB_REC_GENPOS1	Single Record Items: Generic Key Figs w/o Crcy (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
51	RDB_REC_HEADER	Single Record Header (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
52	RDB_REC_QUAN1	Single Record Items: Quantity Generic Key Figs (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
53	RDB_SUM_CURR	Final Results: Additive Key Figures in Currency (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
54	RDB_SUM_GEN	Final Results: Additive Generic Key Figures (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
55	RDB_SUM_NSUM_TEM	Specific Final Results (Template)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
TOPBilling in Contract Accounts Receivable and Payable
56	TFK8026	Billing Cycle	9	KEYDATE	Key Date	nvarchar	8	0
TOPCanada
57	T5K8C	Transfer ext. payroll results into Canadian specific tables	8	KEYDATE	Date	nvarchar	8	0
58	T5U8C	Transfer external payroll results (USA)	8	KEYDATE	Date	nvarchar	8	0
TOPCommodity Pricing Engine
59	CPED_TERMGRPOUT	CPE Term - Changed Grouping and General Term Result	46	KEYDATE	Maturity Key Date	nvarchar	8	0
60	CPED_TERMINPUT	CPE Term - Changed Input for General Data	37	KEYDATE	Maturity Key Date	nvarchar	8	0
61	CPED_TERMOUT	CPE Term - General Result	37	KEYDATE	Maturity Key Date	nvarchar	8	0
TOPContract Billing
62	TE303	Pressure-Temperature Ratio for Joule-Thomson Effect	3	KEYDATE	Date from which time slice is valid	nvarchar	8	0
TOPCustomer Service
63	TE809	Parameter Groups for Mass Changes to MRU	3	KEYDATE	Key Date for Selection According to Time-Related Validity	nvarchar	8	0
TOPEnd User Technology
64	RSZELTPROP	Element properties (settings)	10	KEYDATE	Dim: Field for a Characteristic Value Shorter Than 60 Char.	nvarchar	60	0
TOPInformation System
65	FTI_MARKET_VALS	Reporting: Buffer Table for Market Values - Position Crcy	8	KEYDATE	Key Date	nvarchar	8	0
66	FTI_MARKET_VALST	Reporting: Buffer Table for Market Values - Evaluation Crcy	8	KEYDATE	Key Date	nvarchar	8	0
TOPIntercompany Data Exchange
67	ECROSSREFNO	Reference Number for IDoc	4	KEYDATE	End of billing period	nvarchar	8	0
TOPLoans Management
68	VDCHK_GROSS_NET	Storage of data for report RFVD_GROSS_TO_NET	6	KEYDATE	Accrual/deferral key date	nvarchar	8	0
TOPMarket Risk Analysis
69	I791TRM	Treasury Standard	2	KEYDATE	Stichtag in Ergebnisdatenbanken	nvarchar	8	0
TOPMarket Risk Analyzer
70	RDBRA_NSUM_CURR	CFM-RA: Final Results for Non-Additive Key Figures in Crcy	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
71	RDBRA_NSUM_GEN	CFM-RA: Final Results for Non-Additive Generic Key Figures	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
72	RDBRA_NSUM_TBG	RA: Final Results for P&L Distributions	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
73	RDBRA_NSUM_TBP	RA: Final Results Positions (Delta/Gamma)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
74	RDBRA_NSUM_TVK	RA: Final Results for Value at Risk	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
75	RDBRA_REC_CURPOS	RA RDB: Single Record Position Table in Currency (Generic)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
76	RDBRA_REC_GENALT	RA RDB: Single Record Position Table (Generic)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
77	RDBRA_REC_GENPOS	RA RDB: Single Record Position Table (Generic)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
78	RDBRA_REC_HEADER	RA RDB: Single Record Header Table	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
79	RDBRA_REC_QUAN	RA RDB: Single Record Position Table for Quantity (Generic)	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
80	RDBRA_REC_TBE	RA RDB: Single Records for Key Figure Category BE	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
81	RDBRA_REC_TBG	RA RDB: Single Records for Key Figure Category P&L	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
82	RDBRA_REC_TBK	RA RDB: Single Records for Key Figure Category BK0	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
83	RDBRA_REC_TBP	RA RDB: Single Records for Key Figure Category Delta/Gamma	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
84	RDBRA_SUM_CURR	CFM-RA: Final Results for Additive Key Figures in Currency	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
85	RDBRA_SUM_GEN	CFM-RA: Final Results for Additive Generic Key Figures	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
86	RDBRA_SUM_TBE	RA RDB: Final Results for Key Figure Category BE	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
87	RDBRA_TBG	RA RDB: Single Records for Key Figure Category P&L	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
TOPOrganizational Flexibility
88	/ISDFPS/T77OS_EX	EA-DFPS: Structure Search	7	KEYDATE	Structure Set Up on Current Date	nvarchar	1	0
TOPOrganizational Management
89	T77OS	Structure Search	6	KEYDATE	Structure Set Up on Current Date	nvarchar	1	0
90	T77OS_EXT	Structure search	6	KEYDATE	Structure Set Up on Current Date	nvarchar	1	0
TOPPayroll General Parts
91	T558C	Payroll Account Transfer: Old Wage Types	6	KEYDATE	Date	nvarchar	8	0
TOPPortfolio Analyzer
92	RDBPA_NSUM_CURR	Final Results for Non-Additive Key Figures in Crcy: TRM-PA	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
93	RDBPA_NSUM_GEN	Final Results for Non-Additive Generic Key Figures: TRM-PA	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
94	RDBPA_NSUM_GEN_R	Final Results for Ratio BM Key Figures: TRM-PA	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
95	RDBPA_REC_CCYPOS	"Generic" Single Record Items with Currency	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
96	RDBPA_REC_FLW	Key Figure Values FLW: Single Record Items with Currency	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
97	RDBPA_REC_HEADER	Single Record Header	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
98	RDBPA_SUM_CURR	Final Results for Additive Key Figures in Currency: TRM-PA	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
99	RDBPA_SUM_FLW	Key Figure Values FLW: Totals Records with Currency	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
100	RDBPA_SUM_FLWCC	Key Figure Values FLW: Totals Records w/o Currency	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
101	RDBPA_SUM_GEN	Final Results for Additive Generic Key Figures: TRM-PA	2	KEYDATE	Key Date in Results Databases	nvarchar	8	0
TOPTransaction Manager
102	TRGT_TRANS_REVAL	Table with Revaluation Structures for Transfer to TR Ledger	48	KEYDATE	System Date	nvarchar	8	0
TOPTransfer to Financial Accounting
103	TLVT_VAL_TRANS	Treasury: Valuation Business Transactions	5	KEYDATE	Key Date for Valuation	nvarchar	8	0
TOPTreasury
104	VTIDERI	Master Data Listed Options and Futures	52	KEYDATE	Maturity Key Date	nvarchar	8	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 | KEYDATE