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

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1CN/CBPSAP001	Vendor/product	4	PRODUCT	Internal Unique ID of Product	varbinary	16	0
2	/1CN/CBPSAP118	Product	3	PRODUCT	Internal Unique ID of Product	varbinary	16	0
3	/1CN/CPNSAP00001	Business Partner/Product (GUID)	4	PRODUCT	Internal Unique ID of Product	varbinary	16	0
4	/1CN/CPTSAP00004	Business Partner/Product GUID	4	PRODUCT	Internal Unique ID of Product	varbinary	16	0
5	/1CN/CPTSAP00005	Business Partner/Product Group/Product GUID	5	PRODUCT	Internal Unique ID of Product	varbinary	16	0
6	/IXOS/DC_EX_LCP	(J_8AGTD74) Link customer/product	3	PRODUCT	Product number	nvarchar	10	0
7	/IXOS/DC_EX_PROD	(J_8AGTD72) Products	2	PRODUCT	Product number	nvarchar	10	0
8	/OPT/VIM_LIC_MB	Multi-Backend connection during counting	5	PRODUCT	Character Field Length = 10	nvarchar	10	0
9	/OPT/X040	Document Type Roles	3	PRODUCT	Product Code	nvarchar	3	0
10	/OPT/Y040	Document Type Roles	3	PRODUCT	Product Code	nvarchar	3	0
11	/OPT/Z040	Document Type Roles	3	PRODUCT	Product Code	nvarchar	3	0
12	/SAPPSSRM/MQ_DOC	IBU PS: "Maximum Quantity per Period" Documents in Periods	11	PRODUCT	Internal Unique ID of Product	varbinary	16	0
13	/SAPPSSRM/SOS	Index-Table con. 'Governm. Proc.'-specific sources of supply	8	PRODUCT	Product GUID	varbinary	16	0
14	/SAPSRM/SOCO_SET	Settings for search in Sourcing Cockpit	7	PRODUCT	Product ID	nvarchar	40	0
15	BBPC_PRES_UNPL	Templates for Items in the Confirmation	8	PRODUCT	Character field, length 32	nvarchar	32	0
16	BBPD_PD_INDEX	Index Table for Fast Access to Contracts and AVLs	8	PRODUCT	Product GUID	varbinary	16	0
17	BBP_PDHSB	RFx	12	PRODUCT	Internal Unique ID of Product	varbinary	16	0
18	BBP_PDIAD_V	Business transaction item	12	PRODUCT	Internal Unique ID of Product	varbinary	16	0
19	EHPRCD_PBB_GEN	General Workflow information	18	PRODUCT	Select Boolean	nvarchar	1	0
20	LXE_CSN_PROD_LD	Assignment of Product - Product Version - Language Depth	1	PRODUCT	PPMS Product	nvarchar	30	0
21	REQLINE	Administrative Line Data: Requirement Coverage Request	27	PRODUCT	Internal Unique ID of Product	varbinary	16	0
22	REQLINEMA	Temporary Line Data: Requirement Coverage Request(MRO Lines)	72	PRODUCT	Internal Unique ID of Product	varbinary	16	0
23	REQLINESR	Temporary Line Data: Requirement Coverage Request (Services)	74	PRODUCT	Internal Unique ID of Product	varbinary	16	0
24	RSPLS_USAGE_LOG	Usage log for BPC unified	2	PRODUCT	Planning Product	nvarchar	1	0
25	SRMSOCO_DRFT_ITM	Draft Items for FIORI SOCO	8	PRODUCT	Product GUID	varbinary	16	0
26	ZPH_RESS_STATUS	Status table for resources (Logbook)	7	PRODUCT	Material Number	nvarchar	18	0
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
27	CRM_TCKCOMP4PROD	TCK Checkman for Solutions: Product's Components	1	PRODUCT	Product ID	nvarchar	30	0
28	CRM_TCKPRODUCTS	TCK Checkman for Solutions: Products of Solutions	1	PRODUCT	Product ID	nvarchar	30	0
29	CRM_TCKSOLPROD	TCK Checkman for Solutions: Products	2	PRODUCT	Product ID	nvarchar	30	0
30	CRM_TCKSYSTEMS	TCK Checkman for Solutions: R/3 Systems	3	PRODUCT	Product ID	nvarchar	30	0
TOPCalculations
31	CMS_BCM_CGP_RES	Coverage gap calculated results-BCM	7	PRODUCT	Product of Receivable	nvarchar	12	0
32	CMS_BCM_RBL_CGP	CMS BCM: Receivables Coverage Gap	7	PRODUCT	Product of Receivable	nvarchar	12	0
TOPCollateral Management System
33	CMS_RBL_SYNC	RBL Sync Data	5	PRODUCT	Product of Receivable	nvarchar	12	0
34	TCMS_IFL_MPROD	CMS-CML product linking	2	PRODUCT	Product of Receivable	nvarchar	12	0
TOPCustomizing Tools Techniques
35	TCTM_LPVAL	Validity Limits and Product Priorities	3	PRODUCT	Software Product No. (Generically Created in CST)	nvarchar	20	0
36	TCTM_PPV	Product and Product Version Values for Physical Objects	3	PRODUCT	Software Product No. (Generically Created in CST)	nvarchar	20	0
TOPDirectory
37	LDAPPROP1	Proposals for Mapping SAP Fields to LDAP Attributes	2	PRODUCT	Product Name of the LDAP Server	nvarchar	4	0
38	LDAPPROP2	Proposals for Mapping SAP Fields to LDAP Attributes	2	PRODUCT	Product Name of the LDAP Server	nvarchar	4	0
39	LDAPPROP3	Proposals for Mapping SAP Fields to LDAP Attributes	2	PRODUCT	Product Name of the LDAP Server	nvarchar	4	0
40	LDAPPROP4	Proposals for Mapping SAP Fields to LDAP Attributes	2	PRODUCT	Product Name of the LDAP Server	nvarchar	4	0
41	LDAPPROP5	Proposals for Mapping SAP Fields to LDAP Attributes	2	PRODUCT	Product Name of the LDAP Server	nvarchar	4	0
42	LDAPPROP6	Mapping SAP Fields to LDAP Attributes - Synchronization	2	PRODUCT	Product Name of the LDAP Server	nvarchar	4	0
43	LDAPSERVER	LDAP Server	10	PRODUCT	Product Name of the LDAP Server	nvarchar	4	0
TOPeCATT Extended Computer Aided Test Tool
44	TZRR_SUT	TestZone Result Repository: System under Test Information	32	PRODUCT		nvarchar	30	0
TOPExchange Infrastructure
45	SXMS_AE_AUDITCNF	XI: Adapter Runtime Data	3	PRODUCT	Product Name	nvarchar	40	0
TOPFinancial Accounting
46	/OPT/VIM_BL_ROLE	Document Type Roles	3	PRODUCT	Product Code	nvarchar	3	0
TOPGeneral Application Functions
47	CRMD_ORDERADM_I	Business Transaction Item	12	PRODUCT	Internal Unique ID of Product	varbinary	16	0
TOPIntegration Customer Relationship Management
48	ESALES_PRODAVAIL	Availability of a Product	2	PRODUCT	Utility product	nvarchar	18	0
49	ESALES_PRODSTYPE	Allocation of Products to Set Types	2	PRODUCT	Utility product	nvarchar	18	0
50	ESALES_PRODUCTT	Utility Product Texts	3	PRODUCT	Utility product	nvarchar	18	0
51	ESALES_PSFIELDS	Field Properties for Set Type Attributes for each Product	2	PRODUCT	Utility product	nvarchar	18	0
52	ESALES_UTILPROD	Utility products	2	PRODUCT	Utility product	nvarchar	18	0
TOPLease Accounting
53	LAE_CRM_ITEMS	LAE: Contract Items	28	PRODUCT	Material Number	nvarchar	18	0
TOPLoans Management
54	TDPRODPROFILE	Field Catalog - Assignment of Profiles to Products	6	PRODUCT	Internal Product Name	nvarchar	18	0
TOPLocalization
55	J_3RFTAXRO	Tax Accounting: Object table	14	PRODUCT	Product type	nvarchar	18	0
56	J_3RFTAXRVO	Tax Accounting: Object table	17	PRODUCT	Product type	nvarchar	18	0
TOPMaintenance Orders
57	/MRSS/D_DEM_INFO	Informative Fields for Demand Items	4	PRODUCT	Product Name Entered	nvarchar	54	0
58	/MRSS/D_DEM_TOOL	Data for Tool Items	3	PRODUCT	GUID in CHAR32 format	nvarchar	32	0
TOPMaster Data
59	ECRM_PROD_TEMPL	Master Data Template for CRM Products (Technical Objects)	2	PRODUCT	CRM Product	nvarchar	40	0
60	EPDPROD	IS-U Master Data Generator: Master Data Template	14	PRODUCT	Utility Product	nvarchar	18	0
TOPMedia Product Sales and Distribution
61	JKSDCONTRACTSTAT	Statistics per Product/Contract	4	PRODUCT	Media Product	nvarchar	18	0
62	JKSDISSUESTAT	Statistical Values for a Media Issue	4	PRODUCT	Media Product	nvarchar	18	0
63	JKSELOCKNIP	Lock Table for JKSENIP	3	PRODUCT	Media Product	nvarchar	18	0
64	JKSENIP	IS-M: Shipping Schedule	5	PRODUCT	Media Product	nvarchar	18	0
65	JKSESCHED	IS-M: Media Schedule Lines	5	PRODUCT	Media Product	nvarchar	18	0
66	JPSEPRODCOMP	IS-M: Subscription Mix Type Definition	2	PRODUCT	Media Product	nvarchar	18	0
67	JPTSTARTER	IS-M: Assgt of Basic Edition to Media Prod. for Goods Issue	2	PRODUCT	IS-M: Media Product	nvarchar	18	0
68	JPTSTARTERPRICE	IS-M: Assgt of Basic Edition to Media Product for Pricing	3	PRODUCT	IS-M: Media Product	nvarchar	18	0
69	JVSDGROUPPROD	IS-M: Media Products Assigned to a Group	3	PRODUCT	Media Product	nvarchar	18	0
70	JVSDSHPPLISSOPT	Shipping Dates for a Media Issue for Optimized Contracts	5	PRODUCT	Media Product	nvarchar	18	0
71	JVSDTRSPPLANCONT	IS-M: Transportation Plan - Contracts in Truck Route	11	PRODUCT	Media Product	nvarchar	18	0
72	JVSDWLORD	Shipping Dates for Gen. of Sales Orders from Qty Planning	7	PRODUCT	Media Product	nvarchar	18	0
73	JVSDWLTRSPLCONTR	Alternative Shipping Dates for Sales Orders from Qty Planng	10	PRODUCT	Media Product	nvarchar	18	0
74	JVSDWLTRSPLISSUE	Shipping Dates for Media Issue	5	PRODUCT	Media Product	nvarchar	18	0
TOPNetWeaver Business Content
75	BIZC_CPROV_SOLMA	Connection Table: l Content Provider - SolMan	1	PRODUCT	Product and Main Instance on Configuration Tab	nvarchar	40	0
76	TBIZC_CPROV_SOLM	Text Table Connection Product - Content Provider	2	PRODUCT	Product and Main Instance on Configuration Tab	nvarchar	40	0
TOPNetwork Objects
77	GHO_IFLOT_PLAN	Function location extension table	3	PRODUCT	Medium	nvarchar	6	0
TOPPackage Tools
78	AKB_LOGBOOK	Obsolete: BCB Logbook	3	PRODUCT	Obsolete: Software Product ID	nvarchar	20	0
79	AKB_PRODUCT_COMP	Obsolete: Product Composition	1	PRODUCT	Obsolete: Software Product ID	nvarchar	20	0
80	AKB_STATISTICS	Obsolete: BCB Statistics	1	PRODUCT	Obsolete: Software Product ID	nvarchar	20	0
81	AKB_USAGE_INFO	Obsolete: Temporary BCB Data Storage	2	PRODUCT	Obsolete: Software Product ID	nvarchar	20	0
82	AKB_USAGE_INFO2	Obsolete: Temporary BCB Data Storage	2	PRODUCT	Obsolete: Software Product ID	nvarchar	20	0
TOPPayment Item
83	TBKKG3_TERM	Transaction Type Customizing for Term Objects	3	PRODUCT	Internal Product ID	nvarchar	18	0
84	TBKK_BKS	Control of Bank Control Key	3	PRODUCT	Internal Product ID	nvarchar	18	0
TOPPension fund Netherlands
85	T5NP1	Vastleggen van de relatie tussen werkgever en het product	6	PRODUCT	Object-ID	nvarchar	2	0
TOPPricing
86	PRCD_SIM_ITEM	Pricing Document Item (Simulation)	11	PRODUCT	Product GUID (Key for Quantity Conversions)	varbinary	16	0
TOPReceivable
87	CMS_RBL	Receivable Details	8	PRODUCT	Product of Receivable	nvarchar	12	0
TOPResourcen Management
88	RMXTT_TRIAL_HD	Trial: Header Data	6	PRODUCT	Material Number	nvarchar	18	0
89	RMXTT_TRIAL_MR	Trial: Assigned Master Recipes	4	PRODUCT	Material Number	nvarchar	18	0
TOPRevenue
90	OIUH_CDEX_PROD	Mapping Product code with CDEX Product Code	1	PRODUCT	Product Code	nvarchar	3	0
91	OIUH_PTR_REP_LOG	Production, Tax and Royalty Reporting Execution Log	17	PRODUCT	Product Code for Reporting	nvarchar	1	0
TOPSAP NetWeaver Mobile - Use subcomponents
92	MEREP_TEST_CUST	MI Test Tool - Customize Tables with Values	3	PRODUCT	General Flag	nvarchar	1	0
TOPSocial Services and Social Security
93	PSSCD_SXPITEM	SXP Item Data	28	PRODUCT	Internal Unique ID of Product	varbinary	16	0
TOPSpecial Purpose Ledger
94	/CCIS/PBU18O	PBU18: Object table	13	PRODUCT	Product type	nvarchar	18	0
TOPTariffs, Duties and Permits
95	OIH_J1B_APR	Brazil tax: Acquisition price table	4	PRODUCT	Material Number	nvarchar	18	0
96	OIH_J1B_ZFD	Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus	3	PRODUCT	Material Number	nvarchar	18	0
97	OIH_J_1BTXCI2	Tax calc.: Complement of ICMS rules INSIDE CALCULATION	5	PRODUCT	Material Number	nvarchar	18	0
TOPTest Organizer
98	TNODE02_A	Test case attributes: Management	54	PRODUCT	Product	nvarchar	20	0
99	TWB_PRODUCT	Product and Product Release	1	PRODUCT	Product	nvarchar	20	0
100	TWB_RMP	Work Breakdown Structure Elements (WBS Elements)	1	PRODUCT	Product	nvarchar	20	0
101	TWB_RMPT	Work Breakdown Structure Elements (WBS Elements)	2	PRODUCT	Product	nvarchar	20	0
TOPTraders and Schedulers Workbench
102	OIJ_EL_CP_PROD	Charter contracts: products and product groups	6	PRODUCT	Charter contract: product number	nvarchar	18	0
103	OIJ_EL_LAYT_INF	Laytime terms	8	PRODUCT	Product number	nvarchar	18	0
TOPTransport Management System
104	LISPROD	LIS: Calculated Product Versions	6	PRODUCT	LIS: Product Name	nvarchar	30	0
TOPWorkbench Utilities
105	RLB_DB_SC	Reuse Library: Statistics	5	PRODUCT	Reuse Library: Reuse Product Internal ID	nvarchar	32	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 | PRODUCT