	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

106 columns | ERP 6.0 | SALES_ORG

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1RA/0SD010MI	Items for Class SD01 - Raw Data	45	SALES_ORG	Sales Organization (Compatible with SD, CRM, ...)	nvarchar	20	0
2	/1RA/0SD012MI	Items for Class SD01 - Processable	46	SALES_ORG	Sales Organization (Compatible with SD, CRM, ...)	nvarchar	20	0
3	/1RA/0SD014MI	Items for Class SD01 - Processed	45	SALES_ORG	Sales Organization (Compatible with SD, CRM, ...)	nvarchar	20	0
4	/MRE/C_PRT_SET	Mobile Retail Print Settings	2	SALES_ORG	Sales organization - CRM	nvarchar	14	0
5	/MRE/RSC_S0_DETA	Sales Organization Details	2	SALES_ORG	Sales Organization	nvarchar	4	0
6	/MRE/RSC_S0_TRAN	Sales Order Transaction Details	2	SALES_ORG	Sales Organization	nvarchar	4	0
7	/MRE/RSC_SAL_ORG	Sales Organization	2	SALES_ORG	Sales Organization	nvarchar	4	0
8	/MRE/RSC_SA_TRGT	Sales Area Specific Target	2	SALES_ORG	Sales Organization	nvarchar	4	0
9	/MRE/RSC_SOR_FLP	Mobile Retail Mapping Object Filter Profile To Sales Org	2	SALES_ORG	Sales Organization	nvarchar	4	0
10	/MRE/SAREA_TRGT	Sales Area Specific Target	2	SALES_ORG	Sales Organization	nvarchar	4	0
11	/MRE/SORG_ATTR	Customizing table for sales organization attributes	2	SALES_ORG	Sales Organization	nvarchar	4	0
12	/MRSS/M_AUT_ASGN	Mirror for Control table for automatic assignment creation	9	SALES_ORG	Sales Organization	nvarchar	4	0
13	/MRSS/M_CAP_PLAN	MRS: capacitive planning Mirror Table	7	SALES_ORG	Sales Organization	nvarchar	4	0
14	/MRSS/M_DEF_DUR	MRS Mirror: work of operation(default value for integration)	7	SALES_ORG	Sales Organization	nvarchar	4	0
15	/MRSS/M_MAPNPOS	Mirror for Code Groups for Notification Items	6	SALES_ORG	Sales Organization	nvarchar	4	0
16	/MRSS/M_MAPTASK	Mirror for Mapping of R/3 task	6	SALES_ORG	Sales Organization	nvarchar	4	0
17	/MRSS/M_PREV_DEL	Mirror for Prevent Deletion of Operations	5	SALES_ORG	Sales Organization	nvarchar	4	0
18	/MRSS/M_R3_AFD	Mirror for Assignment follows Demand (ERP Addon)	7	SALES_ORG	Sales Organization	nvarchar	4	0
19	/MRSS/M_RSG_AA	Mirror for Allow Abstract Assignment	8	SALES_ORG	Sales Organization	nvarchar	4	0
20	/MRSS/M_RSG_CTRL	MRS: Mirror for resource planning relevance of operations	6	SALES_ORG	Sales Organization	nvarchar	4	0
21	/MRSS/M_RSG_SA	Mirror for extended assignments	8	SALES_ORG	Sales Organization	nvarchar	4	0
22	/MRSS/M_RSG_STEF	Control Keys for Production Resources/Tools in Resource Plng	7	SALES_ORG	Sales Organization	nvarchar	4	0
23	/MRSS/M_RSG_ST_V	Mirror for Control-Key Default Values for PRT	6	SALES_ORG	Sales Organization	nvarchar	4	0
24	/MRSS/M_SUPERVSR	Mirror for Site Supervisor Indicator	6	SALES_ORG	Sales Organization	nvarchar	4	0
25	/MRSS/M_TRV_TIME	Mirror for Customizing for travel times	9	SALES_ORG	Sales Organization	nvarchar	4	0
26	/XLSO/ADVERTISE	Advertisements	3	SALES_ORG	Sales Organization	nvarchar	4	0
27	/XLSO/FLEXI_CAT	Flexible catalog with sales area details	4	SALES_ORG	Sales Organization	nvarchar	4	0
28	/XLSO/RECOM_LRNR	Recommendation for Learner	3	SALES_ORG	Sales Organization	nvarchar	4	0
29	/XLSO/RECOM_PROD	Recommendation for Product	3	SALES_ORG	Sales Organization	nvarchar	4	0
30	EHPRCD_CMP_POS	Campaign Position	10	SALES_ORG	Sales Organization	nvarchar	4	0
31	FARR_D_CHECK_IC	Transparent Table for the Data Consistency Check Selection	4	SALES_ORG	Sales Organization (Compatible with SD, CRM, ...)	nvarchar	20	0
32	FARR_D_CONTRACT	Contract	23	SALES_ORG	Sales Organization (Compatible with SD, CRM, ...)	nvarchar	20	0
33	FARR_D_POB	Performance Obligation	8	SALES_ORG	Sales Organization (Compatible with SD, CRM, ...)	nvarchar	20	0
34	FIEUD_SDINV_H	SAFT: Invoices from SD module(Header)	10	SALES_ORG	Sales Organization	nvarchar	4	0
35	ZATPCUSTSITE	ATP Check: Customer Site Mapping	4	SALES_ORG	Sales Organization	nvarchar	4	0
36	ZMAT_SLS1	Sales Area DAta	3	SALES_ORG	Sales Organization	nvarchar	4	0
TOPAgency Business Global Trade
37	TMPRX_DEF	AB: Default Data for eSOA Services	4	SALES_ORG	Sales Organization	nvarchar	4	0
38	TMZR_PRX_GRP	AB: Mapping Group for eSOA-Services	6	SALES_ORG	Sales Organization	nvarchar	4	0
TOPCapacity and Resource Planning
39	/MRSS/C_MAPNPOS	Code Groups for Notification Items	4	SALES_ORG	Sales Organization	nvarchar	4	0
40	/MRSS/C_MAPTASK	Mapping of R/3 task	4	SALES_ORG	Sales Organization	nvarchar	4	0
41	/MRSS/C_MOB_STAT	Assignment of Abstract Status to Plants (Mobile Integration)	3	SALES_ORG	Sales Organization	nvarchar	4	0
42	/MRSS/C_RCT_NPRV	Determination of MRS relevance	3	SALES_ORG	Sales Organization	nvarchar	4	0
43	/MRSS/C_SUPERVSR	Site Supervisor Indicator	4	SALES_ORG	Sales Organization	nvarchar	4	0
44	/MRSS/C_TRV_TIME	Customizing for travel times	7	SALES_ORG	Sales Organization	nvarchar	4	0
TOPDistributor-Reseller-Management
45	/SAPHT/DRMBUDL	Bill Up Due List	16	SALES_ORG	Sales Organization	nvarchar	4	0
46	/SAPHT/DRMCRFCST	Reference customers for EC creation during EC aliasing	4	SALES_ORG	Sales Organization	nvarchar	4	0
47	/SAPHT/DRMCSADRV	DRM: Sales Area derivation	4	SALES_ORG	Sales Organization	nvarchar	4	0
48	/SAPHT/DRMHEAD	DRM FIFO Header	11	SALES_ORG	Sales Organization	nvarchar	4	0
49	/SAPHT/DRMINVSUM	DRM Inventory Summary	8	SALES_ORG	Sales Organization	nvarchar	4	0
50	/SAPHT/DRMIUSR	DRM Internet User Management Table	5	SALES_ORG	Sales Organization	nvarchar	4	0
51	/SAPHT/DRMPPDL	Price Protection Due List	8	SALES_ORG	Sales Organization	nvarchar	4	0
52	/SAPHT/DRMPR_DEF	Default Profile for the Tracking Partner	2	SALES_ORG	Sales Organization	nvarchar	4	0
53	/SAPHT/DRMR3XN	DRM relevant ERP Transactions	44	SALES_ORG	Sales Organization	nvarchar	4	0
54	/SAPHT/DRMSDDL	Ship and Debit Due List	8	SALES_ORG	Sales Organization	nvarchar	4	0
55	/SAPHT/DRMSTAG	DRM Staging Area	8	SALES_ORG	Sales Organization	nvarchar	4	0
56	/SAPHT/DRM_CLOSE	DRM CLOSING TABLE	4	SALES_ORG	Sales Organization	nvarchar	4	0
57	/SAPHT/DRM_PHONE	DRM Phone Table	4	SALES_ORG	Sales Organization	nvarchar	4	0
58	KOTW002	Sales org./Distr. chl/Division/Material	4	SALES_ORG	Sales Organization	nvarchar	4	0
59	S496	DRM: MS Side Business Metrics	5	SALES_ORG	Sales Organization	nvarchar	4	0
60	S496E	S496 - Structural information	5	SALES_ORG	Sales Organization	nvarchar	4	0
61	S497	DRM: DR Side Business Metrics	5	SALES_ORG	Sales Organization	nvarchar	4	0
62	S497E	S497 - Structural information	5	SALES_ORG	Sales Organization	nvarchar	4	0
TOPDSD Connector
63	/DSD/ME_CND_TYPE	Condition types manual discount	2	SALES_ORG	Sales Organization	nvarchar	4	0
64	/DSD/ME_CND_T_T	Condition types manual discount	2	SALES_ORG	Sales Organization	nvarchar	4	0
65	/DSD/ME_CUST_HD	DSD CN: Customer Details	14	SALES_ORG	DSD Connector: Sales Organization	nvarchar	4	0
66	/DSD/ME_CUST_SA	DSD CN: Sales area dependent customer master data	3	SALES_ORG	Sales Organization	nvarchar	4	0
67	/DSD/ME_MAT_SOR	DSD CN: Material Sales Organization Data	3	SALES_ORG	DSD Connector: Sales Organization	nvarchar	4	0
TOPEnvironment, Health and Safety
68	/TDAG/RCSA_CAPOS	Campaign position data	7	SALES_ORG	Sales Organization	nvarchar	4	0
TOPFunds Management
69	FMFGRODEF	Define Reimbursable Orders	2	SALES_ORG	Sales Organization	nvarchar	4	0
TOPGlobal Trade
70	TWCBPROXYDEFAULT	Default Data for Proxy Call	5	SALES_ORG	Sales Organization	nvarchar	4	0
TOPGrantor Management
71	GTRFIBILL_H	Header of Grantor FI AP/AR Billing Doc	14	SALES_ORG	Sales Organization (CRM)	nvarchar	14	0
TOPIntegration Customer Relationship Management
72	ECRMSALSERVDATA	Customizing Table for CRM Organization Data	5	SALES_ORG	CRM Sales Organization: Description of Department	nvarchar	12	0
73	ESALES_PRODSALES	Profiles of the sales transaction	7	SALES_ORG	Sales Organization	nvarchar	4	0
74	ESALES_SALESAREA	Alternative Sales Areas for Profile	3	SALES_ORG	Sales Organization	nvarchar	4	0
TOPLogistics - General
75	CMDET_S06667	Individual Records for Updating External Credit Data	13	SALES_ORG	Sales Organization	nvarchar	4	0
TOPMaintenance Orders
76	/MRSS/C_AUT_ASGN	Control table for automatic assignment creation	7	SALES_ORG	Sales Organization	nvarchar	4	0
77	/MRSS/C_CAP_DATE	Capacitive Assignment - Dates	5	SALES_ORG	Sales Organization	nvarchar	4	0
78	/MRSS/C_CAP_PLAN	MRS: capacitive planning	5	SALES_ORG	Sales Organization	nvarchar	4	0
79	/MRSS/C_DEF_DUR	MRS: work of operation (default value for integration)	5	SALES_ORG	Sales Organization	nvarchar	4	0
80	/MRSS/C_OPT_FIL	Demand Filter Definition for Optimization	8	SALES_ORG	Sales Org	nvarchar	4	0
81	/MRSS/C_PREV_DEL	Prevent Deletion of Operations	3	SALES_ORG	Sales Organization	nvarchar	4	0
82	/MRSS/C_R3_AFD	Assignment follows Demand (ERP Addon)	5	SALES_ORG	Sales Organization	nvarchar	4	0
83	/MRSS/C_RAP_ASG	Degree of Coverage of Demands	3	SALES_ORG	Sales Organization	nvarchar	4	0
84	/MRSS/C_RAP_PAR	Parameters for PS Integration	4	SALES_ORG	Sales Organization	nvarchar	4	0
85	/MRSS/C_RAP_PV	Settings for Process Variants	4	SALES_ORG	Sales Organization	nvarchar	4	0
86	/MRSS/C_RSG_AA	Allow Abstract Assignment	6	SALES_ORG	Sales Organization	nvarchar	4	0
87	/MRSS/C_RSG_CTRL	MRS: resource planning relevance of operations	4	SALES_ORG	Sales Organization	nvarchar	4	0
88	/MRSS/C_RSG_SA	Extended assignments	6	SALES_ORG	Sales Organization	nvarchar	4	0
89	/MRSS/C_RSG_STEF	Control Keys for Production Resources/Tools in Resource Plng	5	SALES_ORG	Sales Organization	nvarchar	4	0
90	/MRSS/C_RSG_ST_V	Control-Key Default Values for Production Resources & Tools	4	SALES_ORG	Sales Organization	nvarchar	4	0
91	/MRSS/D_DEM_INFO	Informative Fields for Demand Items	12	SALES_ORG	Sales Org	nvarchar	4	0
TOPMerchandise and Assortment Planning
92	TWISPS_NOPROMO1	Parameters for Promotions Created in MAP	9	SALES_ORG	Sales Organization: Promotion Header	nvarchar	4	0
TOPPeriodical Sales and Distribution
93	JITCIRCBOOK	IS-M/SD: Circulation Book with Delivery Quantities	22	SALES_ORG	Sales Organization	nvarchar	4	0
TOPReusable Components of Business Suite Foundation
94	/BOBF/DM_CST_HDR	Customer Header	5	SALES_ORG	Sales Organization	nvarchar	10	0
95	/BOBF/DM_SORD_RT	Sales Order Header	6	SALES_ORG	Sales Organization	nvarchar	10	0
96	/BOFU/DB_CUST_1	Test Customer Header	4	SALES_ORG		nvarchar	10	0
97	/BOFU/DDMOCUST_H	Demo Customer Header	5	SALES_ORG	Sales Organization	nvarchar	10	0
98	/BOFU/DDMOSORDHD	Sales Order Header	6	SALES_ORG	Sales Organization	nvarchar	10	0
99	/BOFU/DTSTCUST_H	Test Customer Header	4	SALES_ORG	Sales Organization	nvarchar	10	0
100	/BOFU/DTSTSORDHD	Sales Order Header	5	SALES_ORG	Sales Organization	nvarchar	10	0
101	/BOFU/SO_BUPA_RT	Sales Order Business Partner Root Table	5	SALES_ORG		nvarchar	10	0
TOPStructures
102	PSLA_CONFIG_TBL	Configuration of Commercial Project Inception	4	SALES_ORG	Sales Organization	nvarchar	4	0
TOPSupply Chain Management
103	TCM_SLS_ORG_MAP	Mapping TCM Organizational unit to sales organisation	5	SALES_ORG	Sales Organization	nvarchar	4	0
TOPVisit Control
104	/DSD/VC_TSTR	DSD: Customer / Calendar Type / Time Stream ID	3	SALES_ORG	Sales Organization	nvarchar	4	0
105	/DSD/VC_VLH	DSD: Visit List - Header Data	26	SALES_ORG	Sales Organization	nvarchar	4	0
106	/DSD/VC_VPH	DSD: Visit Schedule - Header Data	33	SALES_ORG	Sales Organization	nvarchar	4	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

106 columns | ERP 6.0 | SALES_ORG