	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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

113 columns | ERP 6.0 | HIER_ID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	CMCBC_CBAREA	Cash Budgeting Area	3	HIER_ID	Organizational Hierarchy ID	nvarchar	8	0
2	CMCBD_LQH_ATTR	Liquidity Item Hierarchy Attributes (Header) Runtime	4	HIER_ID	Liquidity Hierarchy	nvarchar	32	0
3	CMCBD_LQH_HIER	Liquidity Item Hierarchy Relationship(Runtime)	5	HIER_ID	Liquidity Hierarchy	nvarchar	32	0
4	CMCBD_LQH_TEXT	Liquidity Item Hierarchy Text(Runtime)	5	HIER_ID	Liquidity Hierarchy	nvarchar	32	0
5	CMCBD_ORG_HIER	Organizational Hierarchy	2	HIER_ID	Organizational Hierarchy ID	nvarchar	8	0
6	CMCBD_ORG_POS	Organizational Hierarchy Position	2	HIER_ID	Organizational Hierarchy ID	nvarchar	8	0
7	CMCBD_ORG_QUERY	Organizational Hierarchy Query Assignment	2	HIER_ID	Organizational Hierarchy ID	nvarchar	8	0
8	CMCBD_ORG_RS	Organizational Hierarchy Relationship	2	HIER_ID	Organizational Hierarchy ID	nvarchar	8	0
9	CMCBD_ORG_UNIT	Organizational Unit	2	HIER_ID	Organizational Hierarchy ID	nvarchar	8	0
10	CMCBD_ORG_USER	Organizational Hierarchy User	2	HIER_ID	Organizational Hierarchy ID	nvarchar	8	0
11	CMCB_LQH_ATTR	Liquidity Item Hierarchy Attributes (Header) Runtime	2	HIER_ID	Liquidity Hierarchy	nvarchar	32	0
12	CMCB_LQH_HIER	Liquidity Item Hierarchy Relationship(Runtime)	2	HIER_ID	Liquidity Hierarchy	nvarchar	32	0
13	CMCB_LQH_TEXT	Liquidity Item Hierarchy Text(Runtime)	2	HIER_ID	Liquidity Hierarchy	nvarchar	32	0
14	FCLM_LQH_ATTR	Liquidity Item Hierarchy Attributes (Header)	2	HIER_ID	Hierarchy ID	nvarchar	32	0
15	FCLM_LQH_HIER	Liquidity Item Hierarchy Relationship	2	HIER_ID	Hierarchy ID	nvarchar	32	0
16	FCLM_LQH_TEXT	Liquidity Item Hierarchy Text	2	HIER_ID	Hierarchy ID	nvarchar	32	0
TOPAssortment
17	WRFT_APC_AKF	Operational APC: Active Key Figures	3	HIER_ID	Hierarchy	nvarchar	2	0
18	WRFT_APC_CDT	Operational APC: Relevant Article Hierarchy Level	2	HIER_ID	Hierarchy	nvarchar	2	0
19	WRFT_APC_CDTX	Planning Node / Hierarchy Level Exceptions	3	HIER_ID	Hierarchy	nvarchar	2	0
20	WRFT_APC_CHAR	Operational APC: Characteristics Position on Screen	3	HIER_ID	Hierarchy	nvarchar	2	0
21	WRFT_APC_LAYOUT	Operational APC: Screen Structure Definition	3	HIER_ID	Hierarchy	nvarchar	2	0
22	WRFT_APC_TABSTRP	Operational APC: Active Tab Pages on Screen	3	HIER_ID	Hierarchy	nvarchar	2	0
23	WRF_APC_IBID	Purchasing List Inbound Interface Detailed Totals	2	HIER_ID	Hierarchy	nvarchar	2	0
24	WRF_APC_IBIT	Purchasing List Inbound Interface Totals	2	HIER_ID	Hierarchy	nvarchar	2	0
25	WRF_APC_MPA	Markdown Profile Assignment	8	HIER_ID	Hierarchy	nvarchar	2	0
26	WRF_APC_PABD	Planned Article Basic Data	10	HIER_ID	Hierarchy ID	nvarchar	2	0
27	WRF_APC_PACDT	Planned Article Assignment into CDT	3	HIER_ID	Hierarchy	nvarchar	2	0
28	WRF_APC_PLH	Purchasing List Header Data	3	HIER_ID	Hierarchy	nvarchar	2	0
29	WRF_APC_SELQS	Operational APC: Select Quota Scales per Hierarchy Node	2	HIER_ID	Hierarchy	nvarchar	2	0
30	WRF_ROCAT	Assignment of Rollout Groups to Categories	2	HIER_ID	Hierarchy	nvarchar	2	0
TOPAssortment Maintenance
31	WRS1	Assortment	19	HIER_ID	Hierarchy	nvarchar	2	0
TOPElectronic Data Interchange
32	PRICAT_K003	PRICAT: Catalog item basic data	77	HIER_ID	Hierarchy	nvarchar	2	0
TOPLogistics Basic Data
33	CMMD_CDT1	Category	5	HIER_ID	Hierarchy ID	nvarchar	2	0
34	CMMD_CDT2	Master Data Subcategory	4	HIER_ID	Hierarchy ID	nvarchar	2	0
35	CMMD_CDT3	Master Data Segment	4	HIER_ID	Hierarchy ID	nvarchar	2	0
36	CMMD_CDT4	Master Data Subsegment	4	HIER_ID	Hierarchy ID	nvarchar	2	0
37	CMMD_CDT5	Master Data Sub-Subsegment	4	HIER_ID	Hierarchy ID	nvarchar	2	0
38	CMMD_CDT6	Master Data Product Group	4	HIER_ID	Hierarchy ID	nvarchar	2	0
39	CMMD_CDT7	Master Data Brand	4	HIER_ID	Hierarchy ID	nvarchar	2	0
40	CMMD_SKU	CDT-SKU Assignment Table	3	HIER_ID	Hierarchy ID	nvarchar	2	0
41	FRE_ARTHIER_SKU	Article Hierarchy Article assignments	2	HIER_ID	Hierarchy	nvarchar	2	0
42	FRE_ARTHIER_STRU	Article Hierarchy Structure	2	HIER_ID	Hierarchy	nvarchar	2	0
43	MATGRP_HIER	Article Hierarchy Properties	2	HIER_ID	Hierarchy ID	nvarchar	2	0
44	MATGRP_HIERT	Article Hierarchy Description	2	HIER_ID	Hierarchy ID	nvarchar	2	0
45	MATGRP_SKU	Article Assignments Table	2	HIER_ID	Hierarchy ID	nvarchar	2	0
46	MATGRP_STRUC	Category Structure	2	HIER_ID	Hierarchy ID	nvarchar	2	0
47	MATGRP_STRUCT	Language-Dependent Name of a Hierarchy Node	2	HIER_ID	Hierarchy ID	nvarchar	2	0
48	WCMP	Category Management: Project	3	HIER_ID	Hierarchy ID	nvarchar	2	0
49	WRF_CMMD_CDT1	Category	5	HIER_ID	Hierarchy	nvarchar	2	0
50	WRF_CMMD_CDT2	Subcategory	4	HIER_ID	Hierarchy	nvarchar	2	0
51	WRF_CMMD_CDT3	Segment	4	HIER_ID	Hierarchy	nvarchar	2	0
52	WRF_CMMD_CDT4	Subsegment	4	HIER_ID	Hierarchy	nvarchar	2	0
53	WRF_CMMD_CDT5	Sub-Subsegment	4	HIER_ID	Hierarchy	nvarchar	2	0
54	WRF_CMMD_CDT6	Product Group	4	HIER_ID	Hierarchy	nvarchar	2	0
55	WRF_CMMD_CDT7	Brand	4	HIER_ID	Hierarchy	nvarchar	2	0
56	WRF_CMMD_SKU	CDT-SKU Assignment Table	3	HIER_ID	Hierarchy	nvarchar	2	0
57	WRF_MATGRP_HIER	Article Hierarchy Properties	2	HIER_ID	Hierarchy	nvarchar	2	0
58	WRF_MATGRP_HIERT	Article Hierarchy Description	2	HIER_ID	Hierarchy	nvarchar	2	0
59	WRF_MATGRP_MD1	Hierarchy Level 1 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
60	WRF_MATGRP_MD10	Hierarchy Level 10 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
61	WRF_MATGRP_MD10T	Hierarchy Level 10 Texts	4	HIER_ID	Hierarchy	nvarchar	2	0
62	WRF_MATGRP_MD1T	Hierarchy Level 1 Texts	4	HIER_ID	Hierarchy	nvarchar	2	0
63	WRF_MATGRP_MD2	Hierarchy Level 2 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
64	WRF_MATGRP_MD2T	Hierarchy Level 2 Texts	4	HIER_ID	Hierarchy	nvarchar	2	0
65	WRF_MATGRP_MD3	Hierarchy Level 3 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
66	WRF_MATGRP_MD3T	Hierarchy Level 3 Texts	4	HIER_ID	Hierarchy	nvarchar	2	0
67	WRF_MATGRP_MD4	Hierarchy Level 4 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
68	WRF_MATGRP_MD4T	Hierarchy Level 4 Texts	4	HIER_ID	Hierarchy	nvarchar	2	0
69	WRF_MATGRP_MD5	Hierarchy Level 5 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
70	WRF_MATGRP_MD5T	Hierarchy Level 5 Texts	4	HIER_ID	Hierarchy	nvarchar	2	0
71	WRF_MATGRP_MD6	Hierarchy Level 6 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
72	WRF_MATGRP_MD6T	Hierarchy Level 6 Texts	4	HIER_ID	Hierarchy	nvarchar	2	0
73	WRF_MATGRP_MD7	Hierarchy Level 7 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
74	WRF_MATGRP_MD7T	Hierarchy Level 7 Texts	4	HIER_ID	Hierarchy	nvarchar	2	0
75	WRF_MATGRP_MD8	Hierarchy Level 8 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
76	WRF_MATGRP_MD8T	Hierarchy Level 8 Texts	4	HIER_ID	Hierarchy	nvarchar	2	0
77	WRF_MATGRP_MD9	Hierarchy Level 9 - Time-Dependent	3	HIER_ID	Hierarchy	nvarchar	2	0
78	WRF_MATGRP_MD9T	Texts - Hierarchy Level 9	4	HIER_ID	Hierarchy	nvarchar	2	0
79	WRF_MATGRP_PROD	Hierarchy-Product Assignment Table	3	HIER_ID	Hierarchy	nvarchar	2	0
80	WRF_MATGRP_SKU	Article Assignments Table	2	HIER_ID	Hierarchy	nvarchar	2	0
81	WRF_MATGRP_STRCT	Language-Dependent Name of a Hierarchy Node	2	HIER_ID	Hierarchy	nvarchar	2	0
82	WRF_MATGRP_STRUC	Category Structure	2	HIER_ID	Hierarchy	nvarchar	2	0
TOPMaterial Master
83	WRF_HIER_ID	Hierarchy Table	3	HIER_ID	Hierarchy ID	nvarchar	2	0
84	WRF_HIER_ID_T	Hierarchy Text	3	HIER_ID	Hierarchy ID	nvarchar	2	0
85	WRF_HIER_NODEBOX	Node Container	3	HIER_ID	Hierarchy ID	nvarchar	2	0
86	WRF_HIER_NODES	Hierarchy Node	3	HIER_ID	Hierarchy ID	nvarchar	2	0
87	WRF_HIER_NODES_T	Node Texts	3	HIER_ID	Hierarchy ID	nvarchar	2	0
88	WRF_HIER_OBJ	Objects of a Hierarchy	3	HIER_ID	Hierarchy ID	nvarchar	2	0
89	WRF_HIER_OBJBOX	Object Container	3	HIER_ID	Hierarchy ID	nvarchar	2	0
90	WRF_HIER_OBJ_T	Object Descriptions	3	HIER_ID	Hierarchy ID	nvarchar	2	0
TOPMerchandise and Assortment Planning
91	S212	CatMan: Hohe Ebene	8	HIER_ID	Hiërarchie-ID	nvarchar	2	0
92	S212BIW1	S212BIW1 * CatMan: High Level	3	HIER_ID	Hierarchy ID	nvarchar	2	0
93	S212BIW2	S212BIW2 * CatMan: High Level	3	HIER_ID	Hierarchy ID	nvarchar	2	0
94	S212E	S212 - Strukturinformationen	3	HIER_ID	Hiërarchie-ID	nvarchar	2	0
95	S214	CatMan: Indizees für ROP	8	HIER_ID	Hiërarchie-ID	nvarchar	2	0
96	S214BIW1	S214BIW1 * CatMan: Indexes for Space Management Program	3	HIER_ID	Hierarchy ID	nvarchar	2	0
97	S214BIW2	S214BIW2 * CatMan: Indexes for Space Management Program	3	HIER_ID	Hierarchy ID	nvarchar	2	0
98	S214E	S214 - Strukturinformationen	3	HIER_ID	Hiërarchie-ID	nvarchar	2	0
99	S219	CatMan: Feine Ebene	8	HIER_ID	Hiërarchie-ID	nvarchar	2	0
100	S219BIW1	S219BIW1 * CatMan: Fine Level	3	HIER_ID	Hierarchy ID	nvarchar	2	0
101	S219BIW2	S219BIW2 * CatMan: Detailed Level	3	HIER_ID	Hierarchy ID	nvarchar	2	0
102	S219E	S219 - Strukturinformationen	3	HIER_ID	Hiërarchie-ID	nvarchar	2	0
TOPPrice Planning Workbench
103	WRF_PPW_PPDART	PPD Material Item	26	HIER_ID	Hierarchy	nvarchar	2	0
TOPPromotion
104	WAKH	Promotion Header Data, IS-R	97	HIER_ID	Hierarchy	nvarchar	2	0
105	WAKR	Promotion Discounts	16	HIER_ID	Hierarchy	nvarchar	2	0
TOPPurchasing
106	WRF_POHF_POL	Order list	39	HIER_ID	Hierarchy	nvarchar	2	0
TOPRetail Demand Management
107	DMF_D_ARTHIER	Transfer Status of Material Hierarchy	3	HIER_ID	Hierarchy	nvarchar	2	0
TOPRetail Pricing
108	WRF_WPPGRHIER	Assignment of Price Point Group to Mat. Hierarchy Node	2	HIER_ID	Hierarchy	nvarchar	2	0
TOPWeb Service Tools - ABAP
109	ERCLASS_LOCAL	UDDI local system Classifications, client dependent	11	HIER_ID	Natural Number	int	10	0
110	ERCLASS_NONSAP	UDDI Classifications SAP, transportable, client independent	15	HIER_ID	Natural Number	int	10	0
111	ERCLASS_SAP	UDDI Classifications SAP, transportable, client independent	15	HIER_ID	Natural Number	int	10	0
112	SCGCLASSIFICATON	OLD: Consumer group classifications	10	HIER_ID	Natural Number	int	10	0
113	SCGR_CLASS	Consumer group classifications	12	HIER_ID	Natural Number	int	10	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

113 columns | ERP 6.0 | HIER_ID