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

97 columns | Print definition?ERP 6.0  | NODE_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/D_DAG_ASGDemand Agr. Graph for Demand that is planned3NODE_GUIDGUIDvarbinary160
2/MRSS/D_DAG_DEMDemand Agr. Graph for Total and Attribute specific Demand3NODE_GUIDGUIDvarbinary160
3/MRSS/D_DAG_MOBOBSOLETE DB Table - NOT IN USE3NODE_GUIDGUIDvarbinary160
4/MRSS/D_DAG_PASDemand Agr. Graph for Preparation/Warp-up of Assignments3NODE_GUIDGUIDvarbinary160
5/MRSS/D_DAG_PDEDemand Agr. Graph for expected Prep/Warp-up of unpl. Dem.3NODE_GUIDGUIDvarbinary160
6/MRSS/D_DAG_RSBDemand Agr. Graph for virtual Reserve Base(non existing Dem)3NODE_GUIDGUIDvarbinary160
7/MRSS/D_DAG_RSVDemand Agr. Graph for virtual Reservation (non existing Dem)3NODE_GUIDGUIDvarbinary160
8/MRSS/D_DAG_TASDemand Agr. Graph for Travel Times of Assignments3NODE_GUIDGUIDvarbinary160
9/MRSS/D_DAG_TDEDemand Agr. Graph for expected Travel Times of unpl. Dem.3NODE_GUIDGUIDvarbinary160
10/MRSS/D_DAG_TRVOBSOLETE DB Table - NOT IN USE3NODE_GUIDGUIDvarbinary160
11/MRSS/D_DAG_UNADemand Agr. Graph for Demand that is not planned yet3NODE_GUIDGUIDvarbinary160
12/MRSS/D_PN_HIERPlanning Node - Hierarchical Relationships3NODE_GUIDGUIDvarbinary160
13BBP_CT_LOADSTRUCStructure of Product Catalogs or Classification Schemas4NODE_GUIDGUID for General Nodevarbinary160
14ESH_OM_AOTYPNLObject Types: Nodes: Layout Templates4NODE_GUIDNode GUIDnvarchar320
15ESH_OM_AOTYPNRPObject Types: Nodes: Related Perspectives4NODE_GUIDNode GUIDnvarchar320
16ESH_OM_COTYPNLObject Types: Nodes: Layout Templates4NODE_GUIDNode GUIDnvarchar320
17ESH_OM_COTYPNRPObject Types: Nodes: Related Perspectives4NODE_GUIDNode GUIDnvarchar320
18ESH_OM_IOTYPNLObject Types: Nodes: Layout Templates4NODE_GUIDNode GUIDnvarchar320
19ESH_OM_IOTYPNRPObject Types: Nodes: Related Perspectives4NODE_GUIDNode GUIDnvarchar320
TOPGroup Hierarchy
20BUT_HIER_NODEBusiness Partner Hierarchy Group2NODE_GUIDGUID of Hierarchy Nodevarbinary160
21BUT_HIER_NODE_BPBusiness Partner Hierarchy Group - Bus. Partner Assignment7NODE_GUIDGUID of Hierarchy Nodevarbinary160
22BUT_HIER_NODE_DBusiness Partner Hierarchy Group - Description3NODE_GUIDGUID of Hierarchy Nodevarbinary160
23BUT_HIER_NODE_DUBusiness Partner Hierarchy Group - Description3NODE_GUIDGUID of Hierarchy Nodevarbinary160
24BUT_HIER_STRUCTBusiness Partner Hierarchy Group - Hierarchy Relationship3NODE_GUIDGUID of Hierarchy Nodevarbinary160
TOPLogistics - General
25CRMC_CO_HIERCRM-CO Interface: Hierarchy Node Table3NODE_GUIDUUID in X form (binary)varbinary160
26CRMC_CO_HIER_DCRM-CO Interface: Description of Hierarchy Nodes3NODE_GUIDUUID in X form (binary)varbinary160
27CRMC_CO_HIER_IDCRM-CO Interface: COPA-ID Hierarchy Nodes2NODE_GUIDUUID in X form (binary)varbinary160
TOPMaintenance Orders
28/MRSS/D_PN_CAPACapacity Rule Definition for Planning Nodes3NODE_GUIDGUIDvarbinary160
29/MRSS/D_PN_HDPlanning Node - Header Data2NODE_GUIDGUIDvarbinary160
30/MRSS/D_PN_HD_TNode - Language dependent Texts2NODE_GUIDGUIDvarbinary160
TOPNetWeaver Enterprise Search
31ESH_OM_ADPRVDFLData Providers: Filters6NODE_GUIDNode GUIDnvarchar320
32ESH_OM_AOTYPNObject Types: Nodes3NODE_GUIDNode GUIDnvarchar320
33ESH_OM_AOTYPNAObject Types: Nodes: Operational Data Providers4NODE_GUIDNode GUIDnvarchar320
34ESH_OM_AOTYPNBNObject Types: Nodes: Backend Navigations4NODE_GUIDNode GUIDnvarchar320
35ESH_OM_AOTYPNCObject Types: Nodes: Authority Checks4NODE_GUIDNode GUIDnvarchar320
36ESH_OM_AOTYPNCCObject Types: Nodes: Assignment of Authorization Checks4NODE_GUIDNode GUIDnvarchar320
37ESH_OM_AOTYPNCCLObject Types: Nodes: Logical Conjunctions of Auth. Checks4NODE_GUIDNode GUIDnvarchar320
38ESH_OM_AOTYPNFObject Types: Nodes: Node Fields4NODE_GUIDNode GUIDnvarchar320
39ESH_OM_AOTYPNGFObject Types: Nodes: Node Attribute Groups4NODE_GUIDNode GUIDnvarchar320
40ESH_OM_AOTYPNPObject Types: Nodes: Members of Node4NODE_GUIDNode GUIDnvarchar320
41ESH_OM_AOTYPNQObject Types: Nodes: Requests4NODE_GUIDNode GUIDnvarchar320
42ESH_OM_AOTYPNQNObject Types: Nodes: Requests: Queries: Nodes5NODE_GUIDNode GUIDnvarchar320
43ESH_OM_AOTYPNRFObject Types: Nodes: Response Fields4NODE_GUIDNode GUIDnvarchar320
44ESH_OM_AOTYPNRGObject Types: Nodes: Response Attribute Groups4NODE_GUIDNode GUIDnvarchar320
45ESH_OM_AOTYPNROAssignment of Roles to Nodes4NODE_GUIDNode GUIDnvarchar320
46ESH_OM_AOTYPNRRObject Types: Nodes: Related Requests4NODE_GUIDNode GUIDnvarchar320
47ESH_OM_AOTYPNTObject Types: Nodes: Descriptions3NODE_GUIDNode GUIDnvarchar320
48ESH_OM_AOTYPQNObject Types: Queries: Nodes5NODE_GUIDNode GUIDnvarchar320
49ESH_OM_CDPRVDFLData Providers: Filters6NODE_GUIDNode GUIDnvarchar320
50ESH_OM_COTYPNObject Types: Nodes3NODE_GUIDNode GUIDnvarchar320
51ESH_OM_COTYPNAObject Types: Nodes: Operational Data Providers4NODE_GUIDNode GUIDnvarchar320
52ESH_OM_COTYPNBNObject Types: Nodes: Backend Navigations4NODE_GUIDNode GUIDnvarchar320
53ESH_OM_COTYPNCObject Types: Nodes: Authority Checks4NODE_GUIDNode GUIDnvarchar320
54ESH_OM_COTYPNCCObject Types: Nodes: Assignment of Authorization Checks4NODE_GUIDNode GUIDnvarchar320
55ESH_OM_COTYPNCCLObject Types: Nodes: Logical Conjunctions of Auth. Checks4NODE_GUIDNode GUIDnvarchar320
56ESH_OM_COTYPNFObject Types: Nodes: Node Fields4NODE_GUIDNode GUIDnvarchar320
57ESH_OM_COTYPNGFObject Types: Nodes: Node Attribute Groups4NODE_GUIDNode GUIDnvarchar320
58ESH_OM_COTYPNQObject Types: Nodes: Requests4NODE_GUIDNode GUIDnvarchar320
59ESH_OM_COTYPNQNObject Types: Nodes: Requests: Queries: Nodes5NODE_GUIDNode GUIDnvarchar320
60ESH_OM_COTYPNRFObject Types: Nodes: Response Fields4NODE_GUIDNode GUIDnvarchar320
61ESH_OM_COTYPNRGObject Types: Nodes: Response Attribute Groups4NODE_GUIDNode GUIDnvarchar320
62ESH_OM_COTYPNROAssignment of Roles to Nodes4NODE_GUIDNode GUIDnvarchar320
63ESH_OM_COTYPNRRObject Types: Nodes: Related Requests4NODE_GUIDNode GUIDnvarchar320
64ESH_OM_COTYPNTObject Types: Nodes: Descriptions3NODE_GUIDNode GUIDnvarchar320
65ESH_OM_COTYPQNObject Types: Queries: Nodes5NODE_GUIDNode GUIDnvarchar320
66ESH_OM_IDPRVDFLData Providers: Filters6NODE_GUIDNode GUIDnvarchar320
67ESH_OM_IOTYPNObject Types: Nodes3NODE_GUIDNode GUIDnvarchar320
68ESH_OM_IOTYPNAObject Types: Nodes: Operational Data Providers4NODE_GUIDNode GUIDnvarchar320
69ESH_OM_IOTYPNBNObject Types: Nodes: Backend Navigations4NODE_GUIDNode GUIDnvarchar320
70ESH_OM_IOTYPNCObject Types: Nodes: Authority Checks4NODE_GUIDNode GUIDnvarchar320
71ESH_OM_IOTYPNCCObject Types: Nodes: Assignment of Authorization Checks4NODE_GUIDNode GUIDnvarchar320
72ESH_OM_IOTYPNCCLObject Types: Nodes: Logical Conjunctions of Auth. Checks4NODE_GUIDNode GUIDnvarchar320
73ESH_OM_IOTYPNFObject Types: Nodes: Node Fields4NODE_GUIDNode GUIDnvarchar320
74ESH_OM_IOTYPNGFObject Types: Nodes: Node Attribute Groups4NODE_GUIDNode GUIDnvarchar320
75ESH_OM_IOTYPNPObject Types: Nodes: Members of Node4NODE_GUIDNode GUIDnvarchar320
76ESH_OM_IOTYPNQObject Types: Nodes: Requests4NODE_GUIDNode GUIDnvarchar320
77ESH_OM_IOTYPNQNObject Types: Nodes: Requests: Queries: Nodes5NODE_GUIDNode GUIDnvarchar320
78ESH_OM_IOTYPNRFObject Types: Nodes: Response Fields4NODE_GUIDNode GUIDnvarchar320
79ESH_OM_IOTYPNRGObject Types: Nodes: Response Attribute Groups4NODE_GUIDNode GUIDnvarchar320
80ESH_OM_IOTYPNROAssignment of Roles to Nodes4NODE_GUIDNode GUIDnvarchar320
81ESH_OM_IOTYPNRRObject Types: Nodes: Related Requests4NODE_GUIDNode GUIDnvarchar320
82ESH_OM_IOTYPNTObject Types: Nodes: Descriptions3NODE_GUIDNode GUIDnvarchar320
83ESH_OM_IOTYPQNObject Types: Queries: Nodes5NODE_GUIDNode GUIDnvarchar320
84ESH_OM_SDPRVDFLData Providers: Filters6NODE_GUIDNode GUIDnvarchar320
85ESH_OM_SOTYPNObject Types: Nodes3NODE_GUIDNode GUIDnvarchar320
86ESH_OM_SOTYPNBNObject Types: Nodes: Backend Navigations4NODE_GUIDNode GUIDnvarchar320
87ESH_OM_SOTYPNCObject Types: Nodes: Authority Checks4NODE_GUIDNode GUIDnvarchar320
88ESH_OM_SOTYPNFObject Types: Nodes: Node Fields4NODE_GUIDNode GUIDnvarchar320
89ESH_OM_SOTYPNQObject Types: Nodes: Requests4NODE_GUIDNode GUIDnvarchar320
90ESH_OM_SOTYPNQNObject Types: Nodes: Requests: Queries: Nodes5NODE_GUIDNode GUIDnvarchar320
91ESH_OM_SOTYPNRFObject Types: Nodes: Response Fields4NODE_GUIDNode GUIDnvarchar320
92ESH_OM_SOTYPNROAssignment of Roles to Nodes4NODE_GUIDNode GUIDnvarchar320
93ESH_OM_SOTYPNRRObject Types: Nodes: Related Requests4NODE_GUIDNode GUIDnvarchar320
94ESH_OM_SOTYPNTObject Types: Nodes: Descriptions3NODE_GUIDNode GUIDnvarchar320
95ESH_OM_SOTYPQNObject Types: Queries: Nodes5NODE_GUIDNode GUIDnvarchar320
TOPQuestion Answer Database
96QADB_SCOPEScope from ASAP QADB2NODE_GUIDUnique ID - 32 charactersnvarchar320
TOPTest Organizer
97TWBMAN_RECO_FAVTWBM: Favorites4NODE_GUIDUnique ID - 32 charactersnvarchar320