	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

105 columns | ERP 6.0 | VALUATION_AREA

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	BCKTRLIT_AD_TRAN	Accrual/Deferral Business Transactions Backup	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
2	IDCFM_FRCR_PDVA	Capitalization Reserve - Product Type	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
3	IDCFM_FRCR_PFVA	Capitalization Reserve - Portfolio	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
4	IDCFM_HU_REPO	REPO: HU GAAP Activation	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
5	TRGC_OP_VAL_AREA	Define alternative paying valuation area	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
6	TRLT_BUSTRANS_BW	Treasury Ledger Business Transactions for BW Extraction	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
TOPAnalyzer
7	AFWKF_KB0	Key Figure Definition: Attribution of NPV Basis	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
8	AFWKF_KB0_H	Key Fig. Definition: Attributes for NPV Basis (Attrib.Table)	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
TOPBack Office
9	PINC_PI_TRL	Customizing Table for Generating Sub-Ledger Position Indic.	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
TOPFinancial Services
10	BWFS_CFM_SELEC	Selection Table for TR-TM Position Management	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
TOPInformation System
11	FTI_BI_REP_ODS	Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
TOPPortfolio Analyzer
12	PFAIM_UMATCH_TRL	Assignment of Flow Types to PA Flow Types	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
TOPSingle Transaction Costing
13	JBT_VAL_AR_ACT	Activate TRM Valuation Area in SEM PA	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
TOPTransaction Management
14	TCHT_HD_SFGDT	SFGDT Representation of Instruments	6	VALUATION_AREA	Valuation Area	nvarchar	3	0
15	THXT_HINST	Hedge Instrument	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
16	THXT_HITEM	Hedge Item DB table	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
17	THXT_HREL	Hedging Relationship	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
18	TRIGC_IGI_PC	IGT - Product Cats of the Parallel Valn Areas to be Included	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
19	TRIGC_IGI_PT	IGT - ProdCat / ProdType in Valn Areas to be Included	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
TOPTransaction Manager
20	DIFC_DIFF_ASSIGN	Factors	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
21	DIFC_LOT_ASSIGN	Factors	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
22	DIFT_POS_IDENT	Persistent Flow Selectors	6	VALUATION_AREA	Valuation Area	nvarchar	3	0
23	IDCFM_BST_CFMA	Customizing for Balance Sheet Transfer with VA (obsolete)	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
24	IDCFM_BST_CFMAV	Customizing for Balance Sheet Transfer with VA (obsolete)	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
25	IDCFM_BST_CUSA	Customizing for Balance Sheet Transfer for Brazil (obsolete)	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
26	IDCFM_BST_CUSAV	Customizing for Balance Sheet Transfer for Brazil (obsolete)	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
27	IDCFM_BST_HIST	History table for balance sheet transfer for Brazil	21	VALUATION_AREA	Valuation Area	nvarchar	3	0
28	IDCFM_DATA_SEC	Valuation-Area-Independent Data for Securities	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
29	IDCFM_FRAM_DICPT	Assign Product Types for Alternate Position Mngt. Procedure	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
30	IDCFM_FRAM_DICRI	Assignment of Alternative Position Management Procedure	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
31	IDCFM_FRCR_CDD	Capitalization Reserve - Differentiation Criteria	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
32	IDCFM_FRIM_DATA	Impairment Main Data	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
33	IDCFM_FRIM_DEXP	Impairment: BAdI Example Values: Expected & Expert Values	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
34	IDCFM_RF_SAVA	Separate Additional Valuation Area	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
35	POGT_POS_GUARD	Lock Objects	20	VALUATION_AREA	Valuation Area	nvarchar	3	0
36	SLDC_DIST_ASYNC	Business Transactions for Asynchronous Distribution	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
37	SLDS_POST_ASYNC	Business Transactions for Asynchronous Posting	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
38	SLDT_FLOW	Subledger Distributor Transactions	9	VALUATION_AREA	Valuation Area	nvarchar	3	0
39	SLDT_TRANSACTION	Subledger Distributor Business Transactions	8	VALUATION_AREA	Valuation Area	nvarchar	3	0
40	THAEXT_EXP_HDG	E-HA: Relationship Table Exposure - Hedged Item	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
41	THMC_HEDGE_PROC	Config Para for Hedge	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
42	THMHRT_HR	Hedge Relationship	7	VALUATION_AREA	Valuation Area	nvarchar	3	0
43	THMT_HEDGE_ITEM	Hedged Item	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
44	TPM_MIG_LOT_MIXD	CFM: (Mig) ID Nos. by Coll. Pos. Man -> Corrspnd. PA by Lot	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
45	TRADT_LOCK	TR: Accrual/Deferral: TRL Position Lock	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
46	TRDTT_DATA_ADMIN	Legacy Data Transfer Admin. Entries Business Transactions	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
47	TRDTT_IGTDATA_SE	Intragroup Transaction (IGT) Data for Securities	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
48	TRDTT_POS_ADMIN	Legacy Data Transfer Admin. Entries Subledger Positions	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
49	TRDTT_POS_SEC	Position Information for Securities	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
50	TRDTT_VADATA_FUT	Valuation-Area-Dependent Data for Futures	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
51	TRDTT_VADATA_OTC	Valuation-Area-Dependent Data for MM, FX, OTC Derivatives.	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
52	TRDTT_VADATA_SEC	Valuation-Area-Dependent Data for Securities	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
53	TRDT_FLOW	Persistent distributor flows	7	VALUATION_AREA	Valuation Area	nvarchar	3	0
54	TRDT_INIT_BT	TRL Initialization: Transfer Business Transactions	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
55	TRDT_INIT_FIX	TRL Initialization: Fix/Post Business Transactions	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
56	TRDT_TRDBUSTRANS	Treasury: Persistent distributor business transaction	8	VALUATION_AREA	Valuation Area	nvarchar	3	0
57	TRGC_DERIV_ASSGN	Treasury: Assignment of Derivation Categories	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
58	TRGC_DER_ONLINE	Control Derived Business Transactions	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
59	TRGC_PC_EXCL	Product Cats of the Parallel Valn Areas to be Excluded	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
60	TRGC_PG_EXCL	Product Groups to be Excluded in the Parallel Val. Areas	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
61	TRGC_PL_ASSIGN	Assign Profit/Loss Types to Update Type and Valuation Area	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
62	TRGC_PM_PROC_ASS	Assignment of Position Management Procedure	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
63	TRGC_PT_EXCL	Product Types to be Excluded in the Parallel Val. Areas	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
64	TRGC_TAC_VA	Assignment of Accounting Code to Valuation Area	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
65	TRGC_VALCLS_MAP	Treasury: Asst of Gen. ValnCl. to ValnCl. for each Valn Area	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
66	TRGC_VAL_AREA	Valuation Areas	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
67	TRGC_VAL_CLASS	Treasury: Valuation Class	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
68	TRGC_VAL_CLASS_T	Treasury: Valuation Class (Text)	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
69	TRGT_INIT	Initialization of Parallel Valuation Areas	6	VALUATION_AREA	Valuation Area	nvarchar	3	0
70	TRGT_MIG_BTACT	Data Table for Flows	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
71	TRGT_TRANS_REVAL	Table with Revaluation Structures for Transfer to TR Ledger	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
72	TRLIC_AD	TR: Customizing: Accrual/Deferral	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
73	TRLIC_AD_EX1	TR: Accrual/Deferral: Further Update Types	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
74	TRLIC_AD_HEAD	Customizing Accrual/Deferral: Differentiation	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
75	TRLIT_AD_TRANS	Accrual/Deferral Business Transactions (Documentation avail)	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
76	TRLT_TRANS_DEL	Deleted TRL Transactions (BW Only)	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
77	TRQT_BUSTRANS	Treasury: Business Transactions	12	VALUATION_AREA	Valuation Area	nvarchar	3	0
78	TRXT_TRANSACTION	TRM Tax Transactions	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
79	TRXT_WT_ASSIGN	TRM Withholding Tax Information Assignment	11	VALUATION_AREA	Valuation Area	nvarchar	3	0
TOPTransfer to Financial Accounting
80	TLVT_MANUAL_VAL	Book Values for Manual Valuation of Positions	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
81	TLVT_VAL_TRANS	Treasury: Valuation Business Transactions	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
82	TRACC_ACCASSREF1	OLD: TR: Account Assignment Ref. Allocation Old->New	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
83	TRACC_ACCSYMBREP	Acct Determination: Replacement of Acct Symbols by G/L Accts	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
84	TRACC_DFT_REL	Posting Relevant Update Types	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
85	TRACC_MIG_ACCDET	Table for Migration of Account Determination	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
86	TRACC_POST_REL	Exclude Product Types from Posting	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
87	TRACT_DOCUMENT	Treasury: Accounting Adaptor Document	6	VALUATION_AREA	Valuation Area	nvarchar	3	0
88	TRAC_ACCASSREF	OLD: Valuation Area-Dependent Account Assignment Refs	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
89	TRAC_ACCASSREF_T	OLD: Text Table for Account Assignment References	2	VALUATION_AREA	Valuation Area	nvarchar	3	0
90	TRAC_ACCSYMBREP1	OLD: Prelim. Solution for Acct Det.: Acct Symbol Replacement	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
91	TRAC_ACCSYMBREP2	OLD: Prelim. Solut.: Replace Acct Symbols per Acct Ass.Ref.	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
92	TRAC_DFTRULE2	Treasury: Assgmt of Update Type to Post. Specs per Valn Area	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
93	TRILT_DTRANS	Derived Business Transactions in the Income Ledger	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
94	TRLAC_DFT_PMC	Assignment of Update Type to Position Change Category Value	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
95	TRLT_BACKUPVORAB	Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol.	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
96	TRLT_DERIVTRANS	Derived Business Transactions	10	VALUATION_AREA	Valuation Area	nvarchar	3	0
97	TRLT_INIT_IGT_SE	Initialization Values for Intragroup Transactions	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
98	TRLT_INIT_POS	Admin. Table: (Obsolete as from Support Package 01)	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
99	TRLT_INIT_TRANS	List of Initializing Business Transactions	3	VALUATION_AREA	Valuation Area	nvarchar	3	0
100	TRLT_INIT_VAL_FU	Initialization Values for TRL Futures Positions	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
101	TRLT_INIT_VAL_LO	Initialization Values for TRL Positions: Loans	4	VALUATION_AREA	Valuation Area	nvarchar	3	0
102	TRLT_INIT_VAL_SE	Initialization Values for TRL Positions: Securities	5	VALUATION_AREA	Valuation Area	nvarchar	3	0
103	TRLT_TRANSACTION	Treasury Ledger Business Transactions	11	VALUATION_AREA	Valuation Area	nvarchar	3	0
104	TRPRT_PAYMENTS	Persistent Data for Payment Requests	7	VALUATION_AREA	Valuation Area	nvarchar	3	0
105	VALT_SP_VAL_SEC	Security Prices and NPV for Special Valuation	2	VALUATION_AREA	Valuation Area	nvarchar	3	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

105 columns | ERP 6.0 | VALUATION_AREA