SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

82 columns | Print definition?ERP 6.0  | USMD_MODEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_DUP_FLDFields to use during duplicate check, per data model1USMD_MODELData Modelnvarchar20
2/FLDQ/AD_DUP_MTCTable to hold match code configuration for a data model1USMD_MODELData Modelnvarchar20
3/FLDQ/AD_DUP_SVCMap DS Services to a Data Model1USMD_MODELData Modelnvarchar20
4/SMD/MD_____000NSID-Tabelle fuer Data Model3USMD_MODELData Modelnvarchar20
5/SMD/MD_____004ISID-Tabelle fuer Entity Type3USMD_MODELData Modelnvarchar20
6/SMD/MD_____004LSID-Tabelle fuer Main Entity Type3USMD_MODELData Modelnvarchar20
7/SMD/MD_____004USID-Tabelle fuer Entity Type3USMD_MODELData Modelnvarchar20
8/SMD/MD_____004XSID-Tabelle fuer Entity Type3USMD_MODELData Modelnvarchar20
9/SMD/MD_____0050SID-Tabelle fuer Entity Type3USMD_MODELData Modelnvarchar20
10/SMD/MD_____00R5SID-Tabelle fuer Entity Type3USMD_MODELData Modelnvarchar20
11USMD0015TActive Area: Text Table2USMD_MODELData Modelnvarchar20
12USMD0070CStatus of an Entity Type2USMD_MODELData Modelnvarchar20
13USMD0071CStatus of an Attribute2USMD_MODELData Modelnvarchar20
14USMD0072CStatus of a Relationship2USMD_MODELData Modelnvarchar20
15USMD2044Search Apps: Assignment of Search Help - Model - Entity2USMD_MODELData Modelnvarchar20
TOPApplication Framework
16USMD0015Data Model: Reuse Active Areas1USMD_MODELData Modelnvarchar20
17USMD0016Prefix for Temporary Keys2USMD_MODELData Modelnvarchar20
18USMD001CData Model: Check Table1USMD_MODELData Modelnvarchar20
19USMD001TData Model: Text Table2USMD_MODELData Modelnvarchar20
20USMD0020Data Model: Entity Types1USMD_MODELData Modelnvarchar20
21USMD0020TData Model: Entity Types, Descriptive Text2USMD_MODELData Modelnvarchar20
22USMD0021Data Model: Permitted External Entity Types in Hierarchies1USMD_MODELData Modelnvarchar20
23USMD0022Data Model: Attributes of Ent.Types w/Generated Persistence1USMD_MODELData Modelnvarchar20
24USMD0022TData Model: Attributes of Ent.Types w/Gen.Persistence, Descr2USMD_MODELData Modelnvarchar20
25USMD0023Data Model: Relationships of Entity Types1USMD_MODELData Modelnvarchar20
26USMD0023TData Model: Relationships of Entity Types, Descriptive Texts2USMD_MODELData Modelnvarchar20
27USMD0024Data Model: Hierarchy Attributes1USMD_MODELData Modelnvarchar20
28USMD0025Data Model: Relationships for Deriving Hierarchy Attributes1USMD_MODELData Modelnvarchar20
29USMD0026Data Model: Foreign Key Definition1USMD_MODELData Modelnvarchar20
30USMD0030Authorizations for Entities of a Data Model2USMD_MODELData Modelnvarchar20
31USMD0031Authorization-Relevant Attributes2USMD_MODELData Modelnvarchar20
32USMD003CAuthorizations per Data Model2USMD_MODELData Modelnvarchar20
33USMD003PAuthorization Relevance for Primary Persistence2USMD_MODELData Modelnvarchar20
34USMD0041Packages for Generated Structures on Model Level1USMD_MODELData Modelnvarchar20
35USMD0043Packages for Customer Includes (CI)1USMD_MODELData Modelnvarchar20
36USMD004CGenerated Structures1USMD_MODELData Modelnvarchar20
37USMD004MAssignment of SMT Mappings to Entity Types1USMD_MODELData Modelnvarchar20
38USMD0050Business Object Type for Entity Types1USMD_MODELData Modelnvarchar20
39USMD0051Entity Type to Be Used for Business Object Type2USMD_MODELData Modelnvarchar20
40USMD0060UI Properties for Modeled Fields1USMD_MODELData Modelnvarchar20
41USMD0061UI Properties of Entity Types (Technical Entity Type)1USMD_MODELData Modelnvarchar20
42USMD0070Obsolete - Do Not Use1USMD_MODELData Modelnvarchar20
43USMD0071Obsolete - Do Not Use1USMD_MODELData Modelnvarchar20
44USMD0072Obsolete - Do Not Use1USMD_MODELData Modelnvarchar20
45USMD010CType of Edition3USMD_MODELData Modelnvarchar20
46USMD110CType of Change Request4USMD_MODELData Modelnvarchar20
47USMD140CSingle Processing: Forms2USMD_MODELData Modelnvarchar20
48USMD160CBusiness Activity: Definition2USMD_MODELData Modelnvarchar20
49USMD2041Search Apps: Assignment of Search Type - Search Help2USMD_MODELData Modelnvarchar20
50USMD2041TSearch Apps: Assignment of Search Type - Search Help TextTbl2USMD_MODELData Modelnvarchar20
51USMD2042Search Apps: Assignment of Search Type - Model - Entity2USMD_MODELData Modelnvarchar20
52USMD600CData Transfer / Variant: Check Table2USMD_MODELData Modelnvarchar20
53USMD600TData Transfer: Texts3USMD_MODELData Modelnvarchar20
54USMD6010Data Transfer: Technical Settings2USMD_MODELData Modelnvarchar20
55USMD6011Data Transfer: Internal Structure2USMD_MODELData Modelnvarchar20
56USMD6100Mapping for Distribution Service3USMD_MODELData Modelnvarchar20
57USMD6110Download Parameters for Distribution Service3USMD_MODELData Modelnvarchar20
58USMD620CMaster Data Packages3USMD_MODELData Modelnvarchar20
59USMD680CMaster Data of Named Selection Condition2USMD_MODELData Modelnvarchar20
60USMD680GSelection Condition4USMD_MODELData Modelnvarchar20
61USMD680TSelection Condition Texts3USMD_MODELData Modelnvarchar20
62USMD6900SMT Mapping - Cluster Table3USMD_MODELData Modelnvarchar20
63USMD_CR_BLOCKBlocking of Change Requests After Activation of Data Model2USMD_MODELData Modelnvarchar20
64USMD_ENQ_HRYNODEFIN-MDM: Enqueue/Dequeue Table for Hierarchy Nodes2USMD_MODELData Modelnvarchar20
TOPData Quality
65USMD_DUPCHK_MODDuplicate Check Mode For Particular Data Model2USMD_MODELData Modelnvarchar20
TOPData Replication Framework
66DRFC_APPLReplication Model4USMD_MODELData Modelnvarchar20
67DRFC_ENTT_SMTAssignment of SMT Mapping to Outbound Implementation2USMD_MODELData Modelnvarchar20
68DRFC_FOBJ_ENTTAssign Main Entity Type to Filter Object2USMD_MODELData Modelnvarchar20
TOPDesign Time
69MDG_DT_JOB_DETJob details of running activation1USMD_MODELData Modelnvarchar20
TOPMDG Business Partner Central Part
70MDG_BS_BP_ACCESSAccess Class assignment1USMD_MODELData Modelnvarchar20
71MDG_BS_BP_HNDLRAdditional handler processed by access class1USMD_MODELData Modelnvarchar20
TOPMDG for Financials
72USMDZ6001CKey Mapping Data Model2USMD_MODELData Modelnvarchar20
73USMDZ60020CKey Mapping Entity Types2USMD_MODELData Modelnvarchar20
74USMDZ6201CKey Mapping Distribution Packages2USMD_MODELData Modelnvarchar20
75USMDZ6300CKey Mapping System2USMD_MODELData Modelnvarchar20
76USMDZ6E201CKey Mapping Parent Entity Types2USMD_MODELData Modelnvarchar20
77USMDZ7DMSCTRLCControl of Data Model Message Class for Validation2USMD_MODELData Modelnvarchar20
78USMDZ7MSGCTRLCControl of Message Number for Validation2USMD_MODELData Modelnvarchar20
TOPMDG Material
79MDG_BS_MAT_MAPObsolete table (can't be deleted in EhP mode)!!1USMD_MODELData Modelnvarchar20
TOPReplication Interface Framework
80MDG_OIF_ENT_PROJEntity Projection Table for Outbound Interface Model2USMD_MODELData Modelnvarchar20
81MDG_OIF_ENT_PR_AEntity Projection Attributes Table2USMD_MODELData Modelnvarchar20
82MDG_OIF_ENT_PR_TEntity Projection Text Table for Outbound Inteface Generator2USMD_MODELData Modelnvarchar20