	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

82 columns | ERP 6.0 | USMD_MODEL

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/FLDQ/AD_DUP_FLD	Fields to use during duplicate check, per data model	1	USMD_MODEL	Data Model	nvarchar	2	0
2	/FLDQ/AD_DUP_MTC	Table to hold match code configuration for a data model	1	USMD_MODEL	Data Model	nvarchar	2	0
3	/FLDQ/AD_DUP_SVC	Map DS Services to a Data Model	1	USMD_MODEL	Data Model	nvarchar	2	0
4	/SMD/MD_____000N	SID-Tabelle fuer Data Model	3	USMD_MODEL	Data Model	nvarchar	2	0
5	/SMD/MD_____004I	SID-Tabelle fuer Entity Type	3	USMD_MODEL	Data Model	nvarchar	2	0
6	/SMD/MD_____004L	SID-Tabelle fuer Main Entity Type	3	USMD_MODEL	Data Model	nvarchar	2	0
7	/SMD/MD_____004U	SID-Tabelle fuer Entity Type	3	USMD_MODEL	Data Model	nvarchar	2	0
8	/SMD/MD_____004X	SID-Tabelle fuer Entity Type	3	USMD_MODEL	Data Model	nvarchar	2	0
9	/SMD/MD_____0050	SID-Tabelle fuer Entity Type	3	USMD_MODEL	Data Model	nvarchar	2	0
10	/SMD/MD_____00R5	SID-Tabelle fuer Entity Type	3	USMD_MODEL	Data Model	nvarchar	2	0
11	USMD0015T	Active Area: Text Table	2	USMD_MODEL	Data Model	nvarchar	2	0
12	USMD0070C	Status of an Entity Type	2	USMD_MODEL	Data Model	nvarchar	2	0
13	USMD0071C	Status of an Attribute	2	USMD_MODEL	Data Model	nvarchar	2	0
14	USMD0072C	Status of a Relationship	2	USMD_MODEL	Data Model	nvarchar	2	0
15	USMD2044	Search Apps: Assignment of Search Help - Model - Entity	2	USMD_MODEL	Data Model	nvarchar	2	0
TOPApplication Framework
16	USMD0015	Data Model: Reuse Active Areas	1	USMD_MODEL	Data Model	nvarchar	2	0
17	USMD0016	Prefix for Temporary Keys	2	USMD_MODEL	Data Model	nvarchar	2	0
18	USMD001C	Data Model: Check Table	1	USMD_MODEL	Data Model	nvarchar	2	0
19	USMD001T	Data Model: Text Table	2	USMD_MODEL	Data Model	nvarchar	2	0
20	USMD0020	Data Model: Entity Types	1	USMD_MODEL	Data Model	nvarchar	2	0
21	USMD0020T	Data Model: Entity Types, Descriptive Text	2	USMD_MODEL	Data Model	nvarchar	2	0
22	USMD0021	Data Model: Permitted External Entity Types in Hierarchies	1	USMD_MODEL	Data Model	nvarchar	2	0
23	USMD0022	Data Model: Attributes of Ent.Types w/Generated Persistence	1	USMD_MODEL	Data Model	nvarchar	2	0
24	USMD0022T	Data Model: Attributes of Ent.Types w/Gen.Persistence, Descr	2	USMD_MODEL	Data Model	nvarchar	2	0
25	USMD0023	Data Model: Relationships of Entity Types	1	USMD_MODEL	Data Model	nvarchar	2	0
26	USMD0023T	Data Model: Relationships of Entity Types, Descriptive Texts	2	USMD_MODEL	Data Model	nvarchar	2	0
27	USMD0024	Data Model: Hierarchy Attributes	1	USMD_MODEL	Data Model	nvarchar	2	0
28	USMD0025	Data Model: Relationships for Deriving Hierarchy Attributes	1	USMD_MODEL	Data Model	nvarchar	2	0
29	USMD0026	Data Model: Foreign Key Definition	1	USMD_MODEL	Data Model	nvarchar	2	0
30	USMD0030	Authorizations for Entities of a Data Model	2	USMD_MODEL	Data Model	nvarchar	2	0
31	USMD0031	Authorization-Relevant Attributes	2	USMD_MODEL	Data Model	nvarchar	2	0
32	USMD003C	Authorizations per Data Model	2	USMD_MODEL	Data Model	nvarchar	2	0
33	USMD003P	Authorization Relevance for Primary Persistence	2	USMD_MODEL	Data Model	nvarchar	2	0
34	USMD0041	Packages for Generated Structures on Model Level	1	USMD_MODEL	Data Model	nvarchar	2	0
35	USMD0043	Packages for Customer Includes (CI)	1	USMD_MODEL	Data Model	nvarchar	2	0
36	USMD004C	Generated Structures	1	USMD_MODEL	Data Model	nvarchar	2	0
37	USMD004M	Assignment of SMT Mappings to Entity Types	1	USMD_MODEL	Data Model	nvarchar	2	0
38	USMD0050	Business Object Type for Entity Types	1	USMD_MODEL	Data Model	nvarchar	2	0
39	USMD0051	Entity Type to Be Used for Business Object Type	2	USMD_MODEL	Data Model	nvarchar	2	0
40	USMD0060	UI Properties for Modeled Fields	1	USMD_MODEL	Data Model	nvarchar	2	0
41	USMD0061	UI Properties of Entity Types (Technical Entity Type)	1	USMD_MODEL	Data Model	nvarchar	2	0
42	USMD0070	Obsolete - Do Not Use	1	USMD_MODEL	Data Model	nvarchar	2	0
43	USMD0071	Obsolete - Do Not Use	1	USMD_MODEL	Data Model	nvarchar	2	0
44	USMD0072	Obsolete - Do Not Use	1	USMD_MODEL	Data Model	nvarchar	2	0
45	USMD010C	Type of Edition	3	USMD_MODEL	Data Model	nvarchar	2	0
46	USMD110C	Type of Change Request	4	USMD_MODEL	Data Model	nvarchar	2	0
47	USMD140C	Single Processing: Forms	2	USMD_MODEL	Data Model	nvarchar	2	0
48	USMD160C	Business Activity: Definition	2	USMD_MODEL	Data Model	nvarchar	2	0
49	USMD2041	Search Apps: Assignment of Search Type - Search Help	2	USMD_MODEL	Data Model	nvarchar	2	0
50	USMD2041T	Search Apps: Assignment of Search Type - Search Help TextTbl	2	USMD_MODEL	Data Model	nvarchar	2	0
51	USMD2042	Search Apps: Assignment of Search Type - Model - Entity	2	USMD_MODEL	Data Model	nvarchar	2	0
52	USMD600C	Data Transfer / Variant: Check Table	2	USMD_MODEL	Data Model	nvarchar	2	0
53	USMD600T	Data Transfer: Texts	3	USMD_MODEL	Data Model	nvarchar	2	0
54	USMD6010	Data Transfer: Technical Settings	2	USMD_MODEL	Data Model	nvarchar	2	0
55	USMD6011	Data Transfer: Internal Structure	2	USMD_MODEL	Data Model	nvarchar	2	0
56	USMD6100	Mapping for Distribution Service	3	USMD_MODEL	Data Model	nvarchar	2	0
57	USMD6110	Download Parameters for Distribution Service	3	USMD_MODEL	Data Model	nvarchar	2	0
58	USMD620C	Master Data Packages	3	USMD_MODEL	Data Model	nvarchar	2	0
59	USMD680C	Master Data of Named Selection Condition	2	USMD_MODEL	Data Model	nvarchar	2	0
60	USMD680G	Selection Condition	4	USMD_MODEL	Data Model	nvarchar	2	0
61	USMD680T	Selection Condition Texts	3	USMD_MODEL	Data Model	nvarchar	2	0
62	USMD6900	SMT Mapping - Cluster Table	3	USMD_MODEL	Data Model	nvarchar	2	0
63	USMD_CR_BLOCK	Blocking of Change Requests After Activation of Data Model	2	USMD_MODEL	Data Model	nvarchar	2	0
64	USMD_ENQ_HRYNODE	FIN-MDM: Enqueue/Dequeue Table for Hierarchy Nodes	2	USMD_MODEL	Data Model	nvarchar	2	0
TOPData Quality
65	USMD_DUPCHK_MOD	Duplicate Check Mode For Particular Data Model	2	USMD_MODEL	Data Model	nvarchar	2	0
TOPData Replication Framework
66	DRFC_APPL	Replication Model	4	USMD_MODEL	Data Model	nvarchar	2	0
67	DRFC_ENTT_SMT	Assignment of SMT Mapping to Outbound Implementation	2	USMD_MODEL	Data Model	nvarchar	2	0
68	DRFC_FOBJ_ENTT	Assign Main Entity Type to Filter Object	2	USMD_MODEL	Data Model	nvarchar	2	0
TOPDesign Time
69	MDG_DT_JOB_DET	Job details of running activation	1	USMD_MODEL	Data Model	nvarchar	2	0
TOPMDG Business Partner Central Part
70	MDG_BS_BP_ACCESS	Access Class assignment	1	USMD_MODEL	Data Model	nvarchar	2	0
71	MDG_BS_BP_HNDLR	Additional handler processed by access class	1	USMD_MODEL	Data Model	nvarchar	2	0
TOPMDG for Financials
72	USMDZ6001C	Key Mapping Data Model	2	USMD_MODEL	Data Model	nvarchar	2	0
73	USMDZ60020C	Key Mapping Entity Types	2	USMD_MODEL	Data Model	nvarchar	2	0
74	USMDZ6201C	Key Mapping Distribution Packages	2	USMD_MODEL	Data Model	nvarchar	2	0
75	USMDZ6300C	Key Mapping System	2	USMD_MODEL	Data Model	nvarchar	2	0
76	USMDZ6E201C	Key Mapping Parent Entity Types	2	USMD_MODEL	Data Model	nvarchar	2	0
77	USMDZ7DMSCTRLC	Control of Data Model Message Class for Validation	2	USMD_MODEL	Data Model	nvarchar	2	0
78	USMDZ7MSGCTRLC	Control of Message Number for Validation	2	USMD_MODEL	Data Model	nvarchar	2	0
TOPMDG Material
79	MDG_BS_MAT_MAP	Obsolete table (can't be deleted in EhP mode)!!	1	USMD_MODEL	Data Model	nvarchar	2	0
TOPReplication Interface Framework
80	MDG_OIF_ENT_PROJ	Entity Projection Table for Outbound Interface Model	2	USMD_MODEL	Data Model	nvarchar	2	0
81	MDG_OIF_ENT_PR_A	Entity Projection Attributes Table	2	USMD_MODEL	Data Model	nvarchar	2	0
82	MDG_OIF_ENT_PR_T	Entity Projection Text Table for Outbound Inteface Generator	2	USMD_MODEL	Data Model	nvarchar	2	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

82 columns | ERP 6.0 | USMD_MODEL