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

66 columns | Print definition?ERP 6.0  | USMD_ENTITY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1MD/MD______01J0F Sets, Higher-level Entity Types BDCSE3USMD_ENTITYEntity Typenvarchar90
2/1MD/MD______0210F Sets BDCSET3USMD_ENTITYEntity Typenvarchar90
3/1MD/MD______0310G Sets, Higher-level Entity Types BDCSE3USMD_ENTITYEntity Typenvarchar90
4/1MD/MD______0410G Sets BDCSET3USMD_ENTITYEntity Typenvarchar90
5/FLDQ/AD_DUP_FLDFields to use during duplicate check, per data model2USMD_ENTITYEntity Typenvarchar90
6/FLDQ/AD_DUP_MTCTable to hold match code configuration for a data model2USMD_ENTITYEntity Typenvarchar90
7/SMD/MD_____004ISID-Tabelle fuer Entity Type5USMD_ENTITYEntity Typenvarchar90
8/SMD/MD_____004LSID-Tabelle fuer Main Entity Type5USMD_ENTITYEntity Typenvarchar90
9/SMD/MD_____004USID-Tabelle fuer Entity Type5USMD_ENTITYEntity Typenvarchar90
10/SMD/MD_____004XSID-Tabelle fuer Entity Type5USMD_ENTITYEntity Typenvarchar90
11/SMD/MD_____0050SID-Tabelle fuer Entity Type5USMD_ENTITYEntity Typenvarchar90
12/SMD/MD_____00R5SID-Tabelle fuer Entity Type5USMD_ENTITYEntity Typenvarchar90
13USMD0070CStatus of an Entity Type3USMD_ENTITYEntity Typenvarchar90
14USMD0071CStatus of an Attribute3USMD_ENTITYEntity Typenvarchar90
15USMD1103Entity Types per Main Entity per Change Request4USMD_ENTITYEntity Typenvarchar90
16USMD1217Change Request: Entity List3USMD_ENTITYEntity Typenvarchar90
17USMD1221Change Request Block List3USMD_ENTITYEntity Typenvarchar90
18USMD2044Search Apps: Assignment of Search Help - Model - Entity4USMD_ENTITYEntity Typenvarchar90
TOPApplication Framework
19USMD0016Prefix for Temporary Keys3USMD_ENTITYEntity Typenvarchar90
20USMD0020Data Model: Entity Types3USMD_ENTITYEntity Typenvarchar90
21USMD0020TData Model: Entity Types, Descriptive Text4USMD_ENTITYEntity Typenvarchar90
22USMD0021Data Model: Permitted External Entity Types in Hierarchies3USMD_ENTITYEntity Typenvarchar90
23USMD0022Data Model: Attributes of Ent.Types w/Generated Persistence3USMD_ENTITYEntity Typenvarchar90
24USMD0022TData Model: Attributes of Ent.Types w/Gen.Persistence, Descr4USMD_ENTITYEntity Typenvarchar90
25USMD0024Data Model: Hierarchy Attributes3USMD_ENTITYEntity Typenvarchar90
26USMD0025Data Model: Relationships for Deriving Hierarchy Attributes3USMD_ENTITYEntity Typenvarchar90
27USMD0030Authorizations for Entities of a Data Model3USMD_ENTITYEntity Typenvarchar90
28USMD0031Authorization-Relevant Attributes3USMD_ENTITYEntity Typenvarchar90
29USMD004CGenerated Structures2USMD_ENTITYEntity Typenvarchar90
30USMD004MAssignment of SMT Mappings to Entity Types2USMD_ENTITYEntity Typenvarchar90
31USMD0050Business Object Type for Entity Types3USMD_ENTITYEntity Typenvarchar90
32USMD0051Entity Type to Be Used for Business Object Type3USMD_ENTITYEntity Typenvarchar90
33USMD0060UI Properties for Modeled Fields2USMD_ENTITYEntity Typenvarchar90
34USMD0061UI Properties of Entity Types (Technical Entity Type)2USMD_ENTITYEntity Typenvarchar90
35USMD0070Obsolete - Do Not Use3USMD_ENTITYEntity Typenvarchar90
36USMD0071Obsolete - Do Not Use3USMD_ENTITYEntity Typenvarchar90
37USMD0080Relevancy of Entity Types per Change Request Type and WFS4USMD_ENTITYEntity Typenvarchar90
38USMD0081Relevancy of Attributes per Change Request Type, ET and WFS4USMD_ENTITYEntity Typenvarchar90
39USMD0101Type of Edition3USMD_ENTITYEntity Typenvarchar90
40USMD1101Entity Types per Change Request3USMD_ENTITYEntity Typenvarchar90
41USMD1213Change Request: Objects3USMD_ENTITYEntity Typenvarchar90
42USMD1214Change Request: Objects (Hierarchy Parent Nodes)3USMD_ENTITYEntity Typenvarchar90
43USMD140CSingle Processing: Forms4USMD_ENTITYEntity Typenvarchar90
44USMD2042Search Apps: Assignment of Search Type - Model - Entity3USMD_ENTITYEntity Typenvarchar90
45USMD600CData Transfer / Variant: Check Table4USMD_ENTITYEntity Typenvarchar90
46USMD6100Mapping for Distribution Service4USMD_ENTITYEntity Typenvarchar90
47USMD6201Master Data Packages: Related Entity Types2USMD_ENTITYEntity Typenvarchar90
48USMD680CMaster Data of Named Selection Condition3USMD_ENTITYEntity Typenvarchar90
49USMD680GSelection Condition5USMD_ENTITYEntity Typenvarchar90
50USMD680TSelection Condition Texts4USMD_ENTITYEntity Typenvarchar90
51USMD_ENQ_HRYNODEFIN-MDM: Enqueue/Dequeue Table for Hierarchy Nodes3USMD_ENTITYEntity Typenvarchar90
TOPData Quality
52MDG_DQ_MATCH_DCMatch profile for duplicate check configuration4USMD_ENTITYEntity Typenvarchar90
53USMD_DUPCHK_MODDuplicate Check Mode For Particular Data Model3USMD_ENTITYEntity Typenvarchar90
TOPData Replication Framework
54DRFC_ENTT_SMTAssignment of SMT Mapping to Outbound Implementation3USMD_ENTITYEntity Typenvarchar90
55DRFC_FOBJ_ENTTAssign Main Entity Type to Filter Object3USMD_ENTITYEntity Typenvarchar90
TOPMDG Business Partner Central Part
56MDG_BS_BP_CHECKWorkflow Step Check Eliminations4USMD_ENTITYEntity Typenvarchar90
TOPMDG for Financials
57USMDA42010CFMDM Processor Determination Depends on Entity Type4USMD_ENTITYEntity Typenvarchar90
58USMDZ42010CFMDM Processor Determination Depends on Entity Type4USMD_ENTITYEntity Typenvarchar90
59USMDZ60020CKey Mapping Entity Types4USMD_ENTITYEntity Typenvarchar90
60USMDZ6201CKey Mapping Distribution Packages4USMD_ENTITYEntity Typenvarchar90
61USMDZ6300CKey Mapping System4USMD_ENTITYEntity Typenvarchar90
62USMDZ6E201CKey Mapping Parent Entity Types4USMD_ENTITYEntity Typenvarchar90
TOPMDG Material
63MDG_BS_MAT_MAPObsolete table (can't be deleted in EhP mode)!!2USMD_ENTITYEntity Typenvarchar90
TOPReplication Interface Framework
64MDG_OIF_ENT_PROJEntity Projection Table for Outbound Interface Model3USMD_ENTITYEntity Typenvarchar90
65MDG_OIF_ENT_PR_AEntity Projection Attributes Table3USMD_ENTITYEntity Typenvarchar90
66MDG_OIF_ENT_PR_TEntity Projection Text Table for Outbound Inteface Generator3USMD_ENTITYEntity Typenvarchar90