	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

111 columns | ERP 6.0 | ITEM_ID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1RA/0SD010MI	Items for Class SD01 - Raw Data	13	ITEM_ID	Item ID of Source Document for Revenue Accouting Item	nvarchar	15	0
2	/1RA/0SD012MI	Items for Class SD01 - Processable	13	ITEM_ID	Item ID of Source Document for Revenue Accouting Item	nvarchar	15	0
3	/1RA/0SD014MI	Items for Class SD01 - Processed	13	ITEM_ID	Item ID of Source Document for Revenue Accouting Item	nvarchar	15	0
4	/1RA/0SD020MI	Items for Class SD02 - Raw Data	13	ITEM_ID	Item ID of Source Document for Revenue Accouting Item	nvarchar	15	0
5	/1RA/0SD022MI	Items for Class SD02 - Processable	13	ITEM_ID	Item ID of Source Document for Revenue Accouting Item	nvarchar	15	0
6	/1RA/0SD024MI	Items for Class SD02 - Processed	13	ITEM_ID	Item ID of Source Document for Revenue Accouting Item	nvarchar	15	0
7	/1RA/0SD030MI	Items for Class SD03 - Raw Data	13	ITEM_ID	Item ID of Source Document for Revenue Accouting Item	nvarchar	15	0
8	/1RA/0SD032MI	Items for Class SD03 - Processable	13	ITEM_ID	Item ID of Source Document for Revenue Accouting Item	nvarchar	15	0
9	/1RA/0SD034MI	Items for Class SD03 - Processed	13	ITEM_ID	Item ID of Source Document for Revenue Accouting Item	nvarchar	15	0
10	/CPD/C_CHKITEM_T	CPD: Customizing for Checklist Items Text	2	ITEM_ID	Milestone Checklist Item	nvarchar	12	0
11	/CPD/C_CHK_ITEMS	Define Checklist Items (Milestones)	2	ITEM_ID	Milestone Checklist Item	nvarchar	12	0
12	/CPD/C_CHK_MAP	Customizing for Milestone Checklist Mapping	4	ITEM_ID	Milestone Checklist Item	nvarchar	12	0
13	/CPD/D_MP_ITEM	Master Project Structure Elements	12	ITEM_ID	Item ID	nvarchar	40	0
14	/SLCE/IRT	IRT Relationships	4	ITEM_ID	GUID of a CRM Order Object	varbinary	16	0
15	CMCBD_TK_LINKS	BRF+ Workflow Task and Link Mapping Table	3	ITEM_ID	Work List: Item ID(GUID)	nvarchar	32	0
16	CMCBD_TK_USERS	BRF+ Workflow Task and User Mapping Table	3	ITEM_ID	Work List: Item ID(GUID)	nvarchar	32	0
17	CMCBD_WKLIST_NA	Work List: Alert/Notification Table	2	ITEM_ID	Work List: Item ID(GUID)	nvarchar	32	0
18	CMCBD_WKLIST_TK	Work List: Tasks Table	2	ITEM_ID	Work List: Item ID(GUID)	nvarchar	32	0
19	CMCBD_WKL_NA_MBX	Work List: Alert/Notification Mapping Table	3	ITEM_ID	Work List: Item ID(GUID)	nvarchar	32	0
20	GRACCHANGELOG	Data Change Log table	14	ITEM_ID	Item Id	nvarchar	90	0
21	GRACMENUAUTH	Auth mapping table for AC IA.	1	ITEM_ID	Menu Item ID	nvarchar	20	0
22	GRFNMENUAPPCOMP	Menu Authorization Entity Mapping	1	ITEM_ID	Menu Item ID	nvarchar	20	0
23	GRFNMENUAPPCOMPC	Menu Authorization Entity Mapping - Customer enhancement	2	ITEM_ID	Menu Item ID	nvarchar	20	0
24	GRFNMENUPFCG	PFCG Auth Mapping Table	1	ITEM_ID	Menu Item ID	nvarchar	20	0
25	GRRMOBITEMSW	Switch Configuration - Menu Items Visibility	2	ITEM_ID	Menu Item ID	nvarchar	20	0
26	RSDB2A_CONTROL	DB2 Accelerator: conrol center TOC	1	ITEM_ID		int	10	0
27	RSDB2A_CTRLTXT	DB2 Accelerator: language dependent texts	2	ITEM_ID		int	10	0
28	RSLSTWADM	StW / BW Workspace Assignment	5	ITEM_ID	SAP Jam: Item ID	nvarchar	22	0
29	TEXT_CTY_EXPOS	Commodity Price Exposure	5	ITEM_ID	Commodity Exposure Line Item ID	nvarchar	5	0
30	TEXT_POSF_DCS_PR	Exposure Position Flow DCS Pricing Data	6	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
31	TEXT_REXP_DCS_PR	Raw Exposure Item DCS Pricing Data	3	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
32	TEXT_REXP_FO_IDX	Index for Financial Object Raw Exposure (TC)	5	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
TOPAccounting Engine
33	/EACC/CONFIGS_LI	Configurations	5	ITEM_ID	Field Name	nvarchar	30	0
34	/EACC/GEN_PROGS	Generated Programs	13	ITEM_ID	Field Name	nvarchar	30	0
TOPAccounting Interface
35	GLE_ECS_BAL_ITEM	GL open items that are not in ECS	7	ITEM_ID	ID of Error Correction Item	varbinary	16	0
36	GLE_ECS_ITEM	ECS: Error Correction Items	2	ITEM_ID	ID of Error Correction Item	varbinary	16	0
37	GLE_ECS_ITEM_MSG	ECS: Error Messages for Error Correction Items	2	ITEM_ID	ID of Error Correction Item	varbinary	16	0
38	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	2	ITEM_ID	ID of Error Correction Item	varbinary	16	0
39	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	2	ITEM_ID	ID of Error Correction Item	varbinary	16	0
TOPBusiness Navigator
40	DF54S	Active nodes for a variant	4	ITEM_ID	Item ID	nvarchar	20	0
TOPClinical System
41	N2GL_ITEM	Pathways: Item of Treatment Pathway	3	ITEM_ID	Item ID	nvarchar	32	0
42	N2GL_TM_STEP	pathways Step of Patient Pathway	9	ITEM_ID	Item ID	nvarchar	32	0
43	N2HIT_LI_EN	HL: Findings Hit List: Assignment: Entry - Hit List	7	ITEM_ID	GUID in 'CHAR' Format in Uppercase	nvarchar	32	0
TOPControl Plan
44	DPR_CTRLPLAN_I	Control Plan: Characteristics Within Control Plan	3	ITEM_ID	Unique Characteristic ID in the Control Plan	nvarchar	15	0
45	QPCPD_ITEM	Item of Control Plan	3	ITEM_ID	External ID of Control Plan Item	nvarchar	8	0
TOPCross-Application Components
46	CFX_BI_MAP_ATTR	Mapping of cFolders Attribute IDs to the OS Fields	7	ITEM_ID	ID of Item in cFolders	nvarchar	255	0
TOPCustom Development Management Cockpit
47	CNVCDMC_BPCA	CDMC Table for BPCA interface with mapping and TBOM info	5	ITEM_ID	Unique ID - 32 characters	nvarchar	32	0
TOPEnd User Technology
48	RSLOCALITEMVIEW	User-Defined Data Views	5	ITEM_ID	Technical Name of an Item	nvarchar	30	0
49	RSLOCALITEMVIEW2	User-Defined Data Views	8	ITEM_ID	Technical Name of an Item	nvarchar	30	0
50	RSZWOBJXREF	Structure of the BW Objects in a Template	4	ITEM_ID	Technical Name of an Item	nvarchar	30	0
TOPFunds Management
51	IAOM_GTR_EXAT	Grantor: Account Assignment Manager External Characteristics	5	ITEM_ID	Item	nvarchar	10	0
TOPGovernance, Risk and Compliance
52	GRFNMENU	(Obsolete) Menu	3	ITEM_ID	Menu Item ID	nvarchar	20	0
53	GRFNMENUAUTH	Menu Authorization Entity Mapping	1	ITEM_ID	Menu Item ID	nvarchar	20	0
54	GRFNMENUAUTHC	Menu Authorization Entity Mapping - Cust enhance	2	ITEM_ID	Menu Item ID	nvarchar	20	0
55	GRFNMENUC	(Obsolete) Menu - Customer enhancement	4	ITEM_ID	Menu Item ID	nvarchar	20	0
56	GRFNMENUITEM	Menu Item	1	ITEM_ID	Menu Item ID	nvarchar	20	0
57	GRFNMENUITEMC	Menu Item - Customer enhancement	2	ITEM_ID	Menu Item ID	nvarchar	20	0
58	GRFNMENUITEMCT	Menu Item Text - Customer enhancement	2	ITEM_ID	Menu Item ID	nvarchar	20	0
59	GRFNMENUITEMT	Menu Item Text	1	ITEM_ID	Menu Item ID	nvarchar	20	0
TOPGRC Risk Management
60	/ORM/ORMTEVNTCLS	ILD Event Classification Data	4	ITEM_ID	ILD Attribute Value ID	nvarchar	10	0
61	/ORM/ORMTEVNTLCL	ILD Event Losses Classification Items	6	ITEM_ID	ILD Attribute Value ID	nvarchar	10	0
TOPJapan
62	PTJPFWS_ITEMDATA	(Obsolete) Request Item Data for Flexible Work Schedule JP	2	ITEM_ID	ID of Request Item	nvarchar	32	0
63	T7JPCP_DTFLSTR	Define Data File Structure	7	ITEM_ID	Item ID	nvarchar	30	0
64	TPTJPFWS_ITEMDAT	Request Item Data for Flexible Work Schedule JP	2	ITEM_ID	ID of Request Item	nvarchar	32	0
TOPManagement of Internal Controls
65	FOPCWFITEM	MIC: Workflow Items	2	ITEM_ID	Work Item	nvarchar	32	0
66	FOPCWFRECIP	MIC: Workflow Recipients	2	ITEM_ID	Work Item	nvarchar	32	0
TOPOwnership
67	GHO_OWNDOI_ITMCK	Ownership : Division of Interest details in item work table	2	ITEM_ID	Ownership UUID	nvarchar	32	0
68	GHO_OWN_DOI_ITMS	Ownership : Division of Interest details	2	ITEM_ID	Ownership UUID	nvarchar	32	0
69	GHO_OWN_DOI_SSM	Ownership Sliding Scale Maintenance	2	ITEM_ID	Ownership UUID	nvarchar	32	0
70	GHO_OWN_SM_ITMS	Ownership Scale Method Items	2	ITEM_ID	Ownership UUID	nvarchar	32	0
71	GHO_OWN_TRO_ITM	Transfer of Ownership Item Table	2	ITEM_ID	Ownership UUID	nvarchar	32	0
72	GHO_TRO_BG_ITMS	Temporary storage for Bearer group from transfer request	2	ITEM_ID	Ownership UUID	nvarchar	32	0
TOPPersonnel Time Events
73	TPTCOR_APL	Different Payment (Correction Scenario)	2	ITEM_ID	ID of Request Item	nvarchar	32	0
74	TPTCOR_CORE	Core Information (Correction Scenario)	2	ITEM_ID	ID of Request Item	nvarchar	32	0
75	TPTCOR_CUSTOMER	Customer (Correction Scenario)	2	ITEM_ID	ID of Request Item	nvarchar	32	0
76	TPTCOR_KOSTL	Cost Assignment (Correction Scenario)	2	ITEM_ID	ID of Request Item	nvarchar	32	0
77	TPTCOR_LOGISTIC	Logistics Orders (Correction Scenario)	2	ITEM_ID	ID of Request Item	nvarchar	32	0
TOPPersonnel Time Management
78	PTARQ_ATTS_INFO	Leave Request: Attendance Data	2	ITEM_ID	ID of Request Item	nvarchar	32	0
79	PTARQ_EXTRA_INFO	Leave Request: Additional Fields for Attendances/Absences	2	ITEM_ID	ID of Request Item	nvarchar	32	0
80	PTREQ_ATTABSDATA	Request Data for Attendances/Absences	2	ITEM_ID	ID of Request Item	nvarchar	32	0
TOPPricing
81	PRCD_SIM_ATTR	Pricing Document Attributes (Simulation)	3	ITEM_ID	Item Number	varbinary	16	0
82	PRCD_SIM_ITEM	Pricing Document Item (Simulation)	3	ITEM_ID	Item Number	varbinary	16	0
TOPProcess Controls
83	GRPCMENU	Menu	3	ITEM_ID	Menu Item ID	nvarchar	20	0
84	GRPCMENUC	Menu - Customer enhancement	4	ITEM_ID	Menu Item ID	nvarchar	20	0
85	GRPCMENUITEM	Menu Item	1	ITEM_ID	Menu Item ID	nvarchar	20	0
86	GRPCMENUITEMC	Menu Item - Customer enhancement	2	ITEM_ID	Menu Item ID	nvarchar	20	0
87	GRPCMENUITEMCT	Menu Item Text - Customer enhancement	2	ITEM_ID	Menu Item ID	nvarchar	20	0
88	GRPCMENUITEMT	Menu Item Text	1	ITEM_ID	Menu Item ID	nvarchar	20	0
89	GRPCMENUTASK	Menu Task mapping	2	ITEM_ID	Menu Item ID	nvarchar	20	0
90	GRPCMENUTASKC	Menu Task mapping - Customer enhancement	2	ITEM_ID	Menu Item ID	nvarchar	20	0
91	GRPCWFITEM	PC: Workflow Items	2	ITEM_ID	Work Item	nvarchar	32	0
92	GRPCWFRECIP	PC: Workflow Recipients	2	ITEM_ID	Work Item	nvarchar	32	0
TOPProcess Management
93	CMX_XSR_DB_ITEM	Standard Execution Step Repository: Items	2	ITEM_ID	XSteps: ID of a Repository Item	nvarchar	22	0
94	CMX_XSR_DB_ITEMT	Standard Execution Step Repository: Texts for Items	2	ITEM_ID	XSteps: ID of a Repository Item	nvarchar	22	0
95	CMX_XSR_DB_VERS	Standard Execution Step Repository: Versions	4	ITEM_ID	XSteps: ID of a Repository Item	nvarchar	22	0
TOPProcess Orchestration for Built-In Processes
96	POC_D_BA_LOG	Task Log Header	4	ITEM_ID	Item ID	nvarchar	10	0
97	POC_D_EVTQ	Event Processing Queue	4	ITEM_ID	Item ID	nvarchar	10	0
TOPResourcen Management
98	RMSAT_STD_PARA_I	RMS-ATL: Variable Item Table Parameter Standardization	4	ITEM_ID	Object ID for Standardization	nvarchar	32	0
TOPTransaction Manager
99	TEXT_ARCH_LOG	Archive trace log info	8	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
100	TEXT_POSF_PRICES	Exposure Position Flow Pricing Data	6	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
101	TEXT_POSITIONS	Exposure Positions	30	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
102	TEXT_POS_FLOW	Exposure Position Flows	29	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
103	TEXT_REXP_DLY	Raw Exposure Item Delivery Data	3	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
104	TEXT_REXP_ITEM	Raw Exposure Item	3	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
105	TEXT_REXP_PRICES	Raw Exposure Item Pricing Data	3	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
106	TEXT_REXP_SUBIT	Sub Raw Exposures (Split Items)	3	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
107	TEXT_TRANSACTION	Unmatched Exposure Business Transactions	29	ITEM_ID	Raw Exposure Line Item ID	nvarchar	5	0
TOPWithout Description
108	RSDMTA_DEPN_DET	Depending items detail table	3	ITEM_ID	Item ID	nvarchar	200	0
109	RSDMTA_ENUM_INFO	LIS table Information	2	ITEM_ID	Item ID	nvarchar	200	0
110	RSDMTA_LEAD_DET	Leading items detail table	3	ITEM_ID	Item ID	nvarchar	200	0
111	RSDMTA_LIS_DET	LIS detail table	3	ITEM_ID	Item ID	nvarchar	200	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

111 columns | ERP 6.0 | ITEM_ID