/SAPHT/DRMSR3XNSEARCHKEY SAP (Search Keys for a R3XN record) Structure details

Dictionary Type: Structure
Description: Search Keys for a R3XN record




ABAP Code to SELECT data from /SAPHT/DRMSR3XNSEARCHKEY
Related tables to /SAPHT/DRMSR3XNSEARCHKEY
Access table /SAPHT/DRMSR3XNSEARCHKEY




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

/SAPHT/DRMSR3XNSEARCHKEY 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 "Search Keys for a R3XN record" 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_/SAPHT/DRMSR3XNSEARCHKEY TYPE /SAPHT/DRMSR3XNSEARCHKEY.

The /SAPHT/DRMSR3XNSEARCHKEY table consists of various fields, each holding specific information or linking keys about Search Keys for a R3XN record data available in SAP. These include LS_DOC_NO (Logical System of the SAP Transaction Document), DOC_TYP (Transaction Document Type), DOC_NO (Transaction Document Number), DOC_ITM (Transaction Document Item Number).. 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: Can be enhanced (character-type)


SAP /SAPHT/DRMSR3XNSEARCHKEY 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
LS_DOC_NOLogical System of the SAP Transaction Document /SAPHT/DRM_LS_DOC_NOCHAR10Assigned to domainALPHALOGSYS
DOC_TYPTransaction Document Type /SAPHT/DRM_DOCTYPCHAR2/SAPHT/DRM_DOCTYP
DOC_NOTransaction Document Number /SAPHT/DRM_DOCNOCHAR10ALPHABELNR
DOC_ITMTransaction Document Item Number /SAPHT/DRM_DOCITMNUMC6/SAPHT/DRM_DOCITM
DOC_YEARTransaction Document Year /SAPHT/DRM_DOCYRNUMC4GJAHRGJAHR
COMP_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
KEYNUMSearch key number /SAPHT/DRM_KEYNUMCHAR10ALPHABELNR
X_MSBOOKPARTNOCheckbox XFELDCHAR1XFELD
X_MATERIALCheckbox XFELDCHAR1XFELD
X_TRACK_PARTNERCheckbox XFELDCHAR1XFELD
X_PARTNERCheckbox XFELDCHAR1XFELD
X_LOTTYPECheckbox XFELDCHAR1XFELD
X_END_CUSTCheckbox XFELDCHAR1XFELD
X_PLANTCheckbox XFELDCHAR1XFELD
X_MS_DR_INDCheckbox XFELDCHAR1XFELD
X_SALES_ORGCheckbox XFELDCHAR1XFELD
X_DIST_CHNLCheckbox XFELDCHAR1XFELD
X_DIVISIONCheckbox XFELDCHAR1XFELD
X_ASSEMBLY_INDCheckbox XFELDCHAR1XFELD
X_REF_ASMB_SLSORDCheckbox XFELDCHAR1XFELD
X_REF_ASMB_SLSITMCheckbox XFELDCHAR1XFELD
MSBOOKPARTNOManufacturer book part number /SAPHT/DRM_MSBOOKPARTNOCHAR18Assigned to domainMATN1MATNR/SAPHT/DRM_MSBOOKPRTMAT1
MATERIALMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
TRACK_PARTNERTracking partner /SAPHT/DRM_TRACK_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBUPA
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
LOTTYPEDRM lot type /SAPHT/DRM_LOTTYPECHAR1/SAPHT/DRM_LOTTYPE
END_CUSTDRM end customer /SAPHT/DRM_ENDCSTCHAR10Assigned to domainALPHABU_PARTNERDEBI
PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MS_DR_INDIndicates manufacturer/supplier or distributor/reseller lot /SAPHT/DRM_MSDRINDCHAR1/SAPHT/DRM_MSDRIND
SALES_ORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
DIST_CHNLDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
DIVISIONDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
ASSEMBLY_INDAssembly indicator /SAPHT/DRM_ASSINDCHAR1/SAPHT/DRM_ASSIND
REF_ASMB_SLSORDReference assembly sales order /SAPHT/DRM_REF_ASMB_SLSORDCHAR10Assigned to domainALPHAVBELN
REF_ASMB_SLSITMReference sales order item /SAPHT/DRM_REF_ASMB_SLSITMNUMC6Assigned to domainPOSNR

Key field Non-key field



How do I retrieve data from SAP structure /SAPHT/DRMSR3XNSEARCHKEY using ABAP code?

As /SAPHT/DRMSR3XNSEARCHKEY 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 /SAPHT/DRMSR3XNSEARCHKEY as there is no data to select.

How to access SAP table /SAPHT/DRMSR3XNSEARCHKEY

Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMSR3XNSEARCHKEY 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!