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

44 columns | Print definition?ERP 6.0  | TYPE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWFND/I_MED_CTCGeneric Cluster Caching for Meta Data (Language-Dependent)4TYPE_IDcache object name / id for cluster tablenvarchar400
2/XFT/DDS_SRMC00Customizing: Super Document Type2TYPE_IDType IDnvarchar320
3/XFT/DDS_SRMC00TCustomizing: Super Document Type3TYPE_IDType IDnvarchar320
4/XFT/DDS_SRMC01Customizing: Mime Type Dependant Activities2TYPE_IDType IDnvarchar320
5/XFT/SOP_C076Cust.: Cycle Type - Node Element Type2TYPE_IDCycle Type IDnvarchar320
6/XFT/SRMCREC75Cust.: Cycle Type - Node Element Type: Direct display2TYPE_IDCycle Type IDnvarchar320
7/XFT/SRMCREC76Cust.: Cycle Type - Node Element Type2TYPE_IDCycle Type IDnvarchar320
8/XFT/SRMCYCLEC1Cust: Type2TYPE_IDCycle Type IDnvarchar320
9/XFT/SRMCYCLEC1TCust: Type3TYPE_IDCycle Type IDnvarchar320
10/XFT/SRMCYCLEC3Cust: Type Agent Group2TYPE_IDCycle Type IDnvarchar320
11/XFT/SRMCYCLEC5Cust: Type Agent Group Decision Profile Agent Type2TYPE_IDCycle Type IDnvarchar320
12/XFT/SRMCYCLECHTCust: Context Menu Create Text for Agent3TYPE_IDCycle Type IDnvarchar320
13/XFT/SRMDDSC01Cust. type definition (valuation of connection parameters)2TYPE_IDTypenvarchar320
14/XFT/SRMDDSC01TCust. type definition (valuation of connection parameters)3TYPE_IDTypenvarchar320
15/XFT/SRMDDSC02Cust. Drag File System: Mime Types - Node Types2TYPE_IDTypenvarchar320
16/XFT/SRMDDSC03Cust. Drag File System: Excluded Resource Patterns2TYPE_IDTypenvarchar320
17/XFT/SRMDDSC04Cust. Drag File System: Node Types - Node Properties2TYPE_IDTypenvarchar320
18/XFT/SRMDDSC10Cust. type definition (valuation of connection parameters)2TYPE_IDTypenvarchar320
19/XFT/SRMDDSC10TCust. type definition (valuation of connection parameters)3TYPE_IDTypenvarchar320
20/XFT/SRMDDSC12Cust. drag file system: mime types - node types2TYPE_IDTypenvarchar320
21/XFT/SRMDDSC14Cust. drag file system: node types - node properties2TYPE_IDTypenvarchar320
TOPBasis Components
22/XFT/INV_C30Customizing: INV Cycle2TYPE_IDCycle Type IDnvarchar320
TOPCollaboration Folders
23CFX_COL_OBJTYPEObject Types (and Categories) per Collaboration3TYPE_IDObject IDvarbinary160
TOPCollaborative Cross Applications
24/POA/D_CLMTYP01TType Labels3TYPE_IDID in Content Lifecycle Managementint100
25/POA/D_CLM_DPLM1Deployment used mappings6TYPE_IDID in Content Lifecycle Managementint100
26/POA/D_CLM_ENT01Content Record3TYPE_IDID in Content Lifecycle Managementint100
27/POA/D_CLM_ENT10Extract Raw Data for Content Record3TYPE_IDID in Content Lifecycle Managementint100
28/POA/D_CLM_IDM01Content Record Identity5TYPE_IDID in Content Lifecycle Managementint100
29/POA/D_CLM_MD02Metadata File - Content Record Type Relationship3TYPE_IDID in Content Lifecycle Managementint100
30/POA/D_CLM_TYP01Content Record Type2TYPE_IDID in Content Lifecycle Managementint100
TOPData Mining
31RSDMTPN_ENGINESList of all the analytical services3TYPE_IDService Type GUIDnvarchar300
32RSDMTP_SERVICESList of all the analytical services2TYPE_IDService Type GUIDnvarchar300
TOPECM ABAP Stack
33NWECMD_DESCSNW ECM: Descriptions for Node and Property Types2TYPE_ID16 Byte UUID in 16 Bytes (Raw Format)varbinary160
34NWECMD_MIXINSNW ECM: Mixins of Nodes3TYPE_ID16 Byte UUID in 16 Bytes (Raw Format)varbinary160
35NWECMD_NODESNW ECM: Nodes6TYPE_ID16 Byte UUID in 16 Bytes (Raw Format)varbinary160
TOPEnergy Data Management
36EDEXTASKCONFERRData Exchange Task Confirmation Msssages Log5TYPE_IDProxy Log Category IDnvarchar400
TOPGateway SAP Data Enablement
37/IWBEP/I_MGW_CTCgeneric cluster table for meta data caching4TYPE_IDCharacter field of length 40nvarchar400
TOPliveCache Applications
38/SAPAPO/OMTSGUIDManage Counter for Descriptive GUIDs for Types2TYPE_ID3-Byte fieldnvarchar30
TOPPosition Budgeting and Control
39T77HRFPMFINEXC3Assignment of Reasons for Alt. Financing Requir. to Groups2TYPE_IDReason for Alternative Financing Requirementnvarchar100
TOPRecords and Case Management
40RMPSPRO_SELTYPSelection Type for Declaration2TYPE_IDDeclaration Selection Typenvarchar20
41RMPSPRO_SELTYP_TDescription of Selection Type3TYPE_IDDeclaration Selection Typenvarchar20
TOPSAP Business Workflow
42SWD_LEVTTYPSWorkflow: Rec Types for Workflow Event Receivers1TYPE_IDType of Local Eventnvarchar40
TOPSAP Utilities
43TEAMI_LOG_MSGMessages for AMI Communication (TEAMI_LOG_DATA)5TYPE_IDText, 40 Characters Longnvarchar400
TOPWeb Dynpro ABAP Rendering
44WDR_UIEL_ADAPTERWeb Dynpro Runtime: Adapter for Elements of UI Libraries3TYPE_IDGlobally Unique Identifiervarbinary160