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

29 columns | Print definition?ERP 6.0  | USAGE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XPPM/EVA_C_CFLDPPM CS EVA: Mapping Custom Fields to Usage Types4USAGE_TYPEUsage Definition for custom fieldsnvarchar20
2DLP_LOGPOINTS_XTFurther logpoint attributes (FOR SAP-INTERNAL USE ONLY)7USAGE_TYPEnvarchar10
3DOTM_CONDBOSC-TM: Connections5USAGE_TYPEDBOS Cockpit: Connection Usage Typenvarchar30
4GRFNUIVARIANTUI Variant3USAGE_TYPEUsage Typenvarchar20
5TFIN_XML_DATAXML Data Storage: Financials2USAGE_TYPEUsage Type of XML Structure (See Allowed Values)nvarchar40
6TFIN_XML_TABNAMEXML Data Storage: Control of Tables to Be Downloaded1USAGE_TYPEUsage Type of XML Structure (See Allowed Values)nvarchar40
TOPAdvertising Management
7TJJPCCKPackage Check/Search Strategy: Define Access Sequence2USAGE_TYPEUsage of Check Strategynvarchar20
8TJJPCCKAPackage Check/Search Strategy: Attribute Definition2USAGE_TYPEUsage of Check Strategynvarchar20
9TJJPCCKEPackage Check/Search Strategy: Packages Used2USAGE_TYPEUsage of Check Strategynvarchar20
10TJJPCCKTPackage Check/Search Strategy: Texts3USAGE_TYPEUsage of Check Strategynvarchar20
TOPApplication Framework
11USMD0020Data Model: Entity Types4USAGE_TYPEStorage and Use Typenvarchar10
TOPCross-Application Components
12LWM_CC_BRNDTBranding images for citizen connect2USAGE_TYPEUsage Type for Branding Imagesnvarchar100
13LWM_CC_BRND_STRBranding image string2USAGE_TYPEUsage Type for Branding Imagesnvarchar100
TOPDefense Forces and Public Security
14/ISDFPS/EQUIPDREquipment Distribution - Further Procg in PDR on Dismantling5USAGE_TYPESingle-Character Indicatornvarchar10
TOPEnd User Technology
15RSKPI_ATTR_USAGEValid Attributes for Each Usage Type of KPI Infrastructure1USAGE_TYPEUsage Type of KPI Infrastructurenvarchar100
TOPMaintenance Notifications
16IBDUPostprocessing of PM/SM Objects2USAGE_TYPEUsage of Entrynvarchar10
TOPNetWeaver Enterprise Search
17ESH_OM_AOTYPUObject Type Usages10USAGE_TYPEUsage Typenvarchar10
18ESH_OM_COTYPUObject Type Usages10USAGE_TYPEUsage Typenvarchar10
19ESH_OM_IOTYPUObject Type Usages10USAGE_TYPEUsage Typenvarchar10
TOPPersonnel Time Management
20TPT_GUI_CLNT_LAYGUI Layout: Definition for Client-Dependent Customizing3USAGE_TYPEOBSOLETE: Layout Usage Typenvarchar30
21TPT_GUI_LAYOUTSGUI Layout: Definition2USAGE_TYPEOBSOLETE: Layout Usage Typenvarchar30
22TPT_UIA_CLNT_LAYUIA Layout: Client-Dependent Customizing3USAGE_TYPEOBSOLETE: Layout Usage Typenvarchar30
23TPT_UIA_LAYOUTSUIA Layout2USAGE_TYPEOBSOLETE: Layout Usage Typenvarchar30
TOPReal Estate
24CMS_RE_OBJ_SPCSpace Details to describe a real estate object6USAGE_TYPEUsage Typenvarchar60
25TCMS_RE_U_TYPCustomizing table for Object usage2USAGE_TYPEUsage Typenvarchar60
26TCMS_RE_U_TYP_TObject usage(Text table)2USAGE_TYPEUsage Typenvarchar60
TOPRevenue
27OIUH_DD_CONFIGDD names per program with Open Mode (I/O) for QSAM files6USAGE_TYPEFile Usage Typenvarchar10
TOPWeb Dynpro ABAP
28WDY_CFG_CMP_WULWhere-Used List for Component Configurations9USAGE_TYPEType of Usagenvarchar10
TOPWeb Screen Tools - ABAP
29WDY_COMPO_USAGEWeb Dynpro : Component Usages8USAGE_TYPEWeb Dynpro: Class Name of Web Dynpro Metadata Objectnvarchar300