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

Home | ERP 6.0  | USMD0020
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Cross-Application Components :: Master Data Governance :: Application Framework
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0USMD0020281Data Model: Entity TypesApplication Framework
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT USMD_MODEL, USMD_OBJSTAT, USMD_ENTITY, USAGE_TYPE, KEY_HANDLING, USMD_VAL_ENTITY, ROLLNAME, HRY, USMD_VAL_HRY, F_MULTI_LANGU, TXTLG_LEN, TXTMI_LEN, TXTSH_LEN, F_HAS_ATTACHMENT, F_HAS_SET, USMD_SEARCH_HLP, USMD_FLD_TXTSH, USMD_FLD_TXTMI, USMD_FLD_TXTLG, TMP_KEY_NROBJ, PP_DOMAIN, ENTITY_DELETION, USMD_APPL, DISABLED, TAB_SOURCE, FLD_SOURCE, TAB_XFIELD, GENERATED FROM USMD0020
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1USMD_MODELData Modelnvarchar20CHAR(N' ')NoUSMD001CUSMD_MODEL Allow NULL? 
2USMD_OBJSTATActivation Statuschar10CHAR(N' ')NoUSMD001CUSMD_OBJSTAT Allow NULL? 
3USMD_ENTITYEntity Typenvarchar90CHAR(N' ')NoUSMD_ENTITY Allow NULL? 
4USAGE_TYPEStorage and Use Typechar10CHAR(N' ')YesUSMD_USAGE_TYPE Allow NULL? 
5KEY_HANDLINGType of Key Assignmentchar10CHAR(N' ')YesUSMD_KEY_HANDLING Allow NULL? 
6USMD_VAL_ENTITYValidity Concept for Entity Typechar10CHAR(N' ')YesUSMD_VALIDITY_ENTITY_TYPE Allow NULL? 
7ROLLNAMEData Element (Entity Type)nvarchar300CHAR(N' ')Yes*USMD_ROLLNAME_ENT Allow NULL? 
8HRYHierarchieschar10CHAR(N' ')YesUSMD_HRY Allow NULL? 
9USMD_VAL_HRYValidity Concept for Hierarchychar10CHAR(N' ')YesUSMD_VALIDITY_HRY Allow NULL? 
10F_MULTI_LANGULanguage-Dependent Textschar10CHAR(N' ')YesUSMD_MULTI_LANGU Allow NULL? 
11TXTLG_LENLong Text: Lengthnvarchar20NUMC(N'00')YesUSMD_TXTLG_LEN Allow NULL? 
12TXTMI_LENMedium Text: Lengthnvarchar20NUMC(N'00')YesUSMD_TXTMI_LEN Allow NULL? 
13TXTSH_LENShort Text: Lengthnvarchar20NUMC(N'00')YesUSMD_TXTSH_LEN Allow NULL? 
14F_HAS_ATTACHMENTAttachments (Indicator)char10CHAR(N' ')YesUSMD_HAS_ATTACHMENT Allow NULL? 
15F_HAS_SETSets Indicatorchar10CHAR(N' ')YesUSMD_HAS_SET Allow NULL? 
16USMD_SEARCH_HLPSearch Helpnvarchar300CHAR(N' ')Yes*USMD_SEARCH_HLP Allow NULL? 
17USMD_FLD_TXTSHShort Text: Source Fieldnvarchar300CHAR(N' ')Yes*USMD_FLD_TXTSH Allow NULL? 
18USMD_FLD_TXTMIMedium Text: Source Fieldnvarchar300CHAR(N' ')Yes*USMD_FLD_TXTMI Allow NULL? 
19USMD_FLD_TXTLGLong Text: Source Fieldnvarchar300CHAR(N' ')Yes*USMD_FLD_TXTLG Allow NULL? 
20TMP_KEY_NROBJName of number range objectnvarchar100CHAR(N' ')YesTNRONROBJ Allow NULL? 
21PP_DOMAINActive Areanvarchar100CHAR(N' ')Yes*USMD_PP_DOMAIN Allow NULL? 
22ENTITY_DELETIONDeletion of Entitieschar10CHAR(N' ')YesUSMD_ENTITY_DELETION Allow NULL? 
23USMD_APPLApplicationnvarchar100CHAR(N' ')YesUSMD_APPL Allow NULL? 
24DISABLEDStandard Delivery Statuschar10CHAR(N' ')YesUSMD_SWITCH_DEFAULT Allow NULL? 
25TAB_SOURCEABAP Dictionary Structure/Tablenvarchar300CHAR(N' ')YesDD02LUSMD_TAB_SOURCE Allow NULL? 
26FLD_SOURCESource Fieldnvarchar300CHAR(N' ')YesDD03LUSMD_FLD_SOURCE Allow NULL? 
27TAB_XFIELDABAP Dictionary Structure for X-Fieldsnvarchar300CHAR(N' ')YesDD02LUSMD_TAB_XFIELD Allow NULL? 
28GENERATEDGenerated Elementchar10CHAR(N' ')YesUSMD_GENERATED Allow NULL? 
NamePrimaryUniqueTypeColumns
USMD0020~0YesYesCLUSTEREDUSMD_MODEL, USMD_OBJSTAT, USMD_ENTITY

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy