DB2QWHCT SAP (Correlation Data Mapping) Structure details

Dictionary Type: Structure
Description: Correlation Data Mapping




ABAP Code to SELECT data from DB2QWHCT
Related tables to DB2QWHCT
Access table DB2QWHCT




Structure field list including key, data, relationships and ABAP select examples

DB2QWHCT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Correlation Data Mapping" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DB2QWHCT TYPE DB2QWHCT.

The DB2QWHCT table consists of various fields, each holding specific information or linking keys about Correlation Data Mapping data available in SAP. These include QWHCCV (Field type char, length 12), QWHCCN (Field type char, length 8), QWHCLEN (Small integer), QWHCTYP (Field type numc, length 3, 1 byte).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP DB2QWHCT structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MEMBNMDB2 member name in data sharing environment DB2MEMNCHAR8DB2CHAR08
QWHCCVField type char, length 12 DB2CHAR12CHAR12DB2CHAR12
QWHCCNField type char, length 8 DB2CHAR08CHAR8DB2CHAR08
QWHCLENSmall integer DB2INT2AAINT25DB2SINT
QWHCTYPField type numc, length 3, 1 byte DB2NUMC03NUMC3DB2NUMC03
QWHCRESField type char, length 1, reserved DB2RES01CHAR1DB2CHAR01
QWHCAIDField type char, length 8 DB2CHAR08CHAR8DB2CHAR08
QWHCPLANField type char, length 8 DB2CHAR08CHAR8DB2CHAR08
QWHCOPIDField type char, length 8 DB2CHAR08CHAR8DB2CHAR08
QWHCATYPField Type DEC, Length 10 DB2DEC10DEC10DEC_10
QWHCTOKNField type char, length 22 DB2CHAR22CHAR22DB2CHAR22
QWHCRES1Field type char, length 2, reserved DB2RES02CHAR2DB2CHAR02
QWHCEUIDThe end user's work station user ID DB2WHCEUIDCHAR128CHAR128
QWHCEUTXTransaction or application the end user is running DB2WHCEUTXCHAR32CHAR32
QWHCEUWNThe end user's workstation name DB2WHCEUWNCHAR18CHAR18
QWHCRES2Field type char, length 2, reserved DB2RES02CHAR2DB2CHAR02

Key field Non-key field



How do I retrieve data from SAP structure DB2QWHCT using ABAP code?

As DB2QWHCT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB2QWHCT as there is no data to select.

How to access SAP table DB2QWHCT

Within an ECC or HANA version of SAP you can also view further information about DB2QWHCT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!