/SAPHT/DRMR3XN SAP (DRM relevant ERP Transactions) Table details

Dictionary Type: Table
Description: DRM relevant ERP Transactions




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




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

/SAPHT/DRMR3XN is a standard SAP Table which is used to store DRM relevant ERP Transactions data and is available within R/3 SAP systems depending on the version and release level.

The /SAPHT/DRMR3XN table consists of various fields, each holding specific information or linking keys about DRM relevant ERP Transactions 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP /SAPHT/DRMR3XN table 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
MANDTClient MANDTCLNT3T000MANDT
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
REF_DOC_TYPReference document type /SAPHT/DRM_RFDOCTYPCHAR2/SAPHT/DRM_DOCTYP
REF_DOC_NOReference document number /SAPHT/DRM_RFDOCNOCHAR12XUACCNT
REF_DOC_ITMReference document item number /SAPHT/DRM_RFDOCITMNUMC6Assigned to domainPOSNR
REF_DOC_YEARReference document year /SAPHT/DRM_RFDOCYRNUMC4GJAHRGJAHR
ABGRUReason for rejection of quotations and sales orders ABGRU_VACHAR2Assigned to domainABGRU_VA
ORDER_NOOrder number /SAPHT/DRM_ORDERNOCHAR12XUACCNT
ORDER_ITMOrder item /SAPHT/DRM_ORDERITMNUMC6Assigned to domainPOSNR
PO_ORDER_TYPEPurchasing Document Type ESARTCHAR4Assigned to domainBSARTBSA
INV_DOC_TYPEBilling Type FKARTCHAR4Assigned to domainFKART
MATDOCNOGoods Issue/ Goods receipt number /SAPHT/DRM_MATDOCNOCHAR10ALPHABELNR
MATDOCITEMGoods Issue/ Goods receipt item number /SAPHT/DRM_MATDCITMNUMC6Assigned to domainPOSNR
MATDOCYRGoods Issue/ Goods receipt document year /SAPHT/DRM_MATDOCYRNUMC4GJAHRGJAHR
DS_ORD_NODrop-ship sales order number /SAPHT/DRM_DS_ORD_NOCHAR10ALPHABELNR
DS_ORD_ITMDrop-ship sales order item number /SAPHT/DRM_DSORDITMNUMC6/SAPHT/DRM_DOCITM
DOC_QTYDocument quantity /SAPHT/DRM_DOCQTQUAN15(3) MENG15
MATCHED_QTYMatched quantity /SAPHT/DRM_MATQTQUAN15(3) MENG15
QTY_UNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
PRIC_UNITPricing unit for price protectable price /SAPHT/DRM_PRCUNITDEC5KPEIN
COND_RATEPrice protectable price condition rate /SAPHT/DRM_COND_RATECURR11(2) WERTV6
COND_CURRPrice protectable price currency /SAPHT/DRM_COND_CURRCUKY5Assigned to domainWAERS
COND_NUMERNumerator for converting price protectable price /SAPHT/DRM_COND_NUMERATORDEC5UMBSZ
COND_DENOMDenominator for conversion to base unit /SAPHT/DRM_COND_DENOMDEC5UMBSN
COND_UOMPricing unit of measure /SAPHT/DRM_PRIC_UOMUNIT3Assigned to domainCUNITMEINS
DOC_VALUENet value of the order item in document currency NETWR_APCURR15(2) WERTV8
DOC_VALUE_CURRSD Document Currency WAERKCUKY5Assigned to domainWAERSFWS
DOC_DATEDocument creation date /SAPHT/DRM_DOCDATEDATS8DATUM
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
RESALEPRCResale price /SAPHT/DRM_RESPRCCURR11(2) WERTV6
RESALECURRResale price currency /SAPHT/DRM_RESCURRCUKY5Assigned to domainWAERS
RESL_PRC_UNITPricing quantity for resale price /SAPHT/DRM_RESPRCUNITDEC5KPEIN
RESL_PRC_UOMUnit of measure for pricing quantity /SAPHT/DRM_RESPRCUOMUNIT3Assigned to domainCUNITMEINS
SALES_ORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
DIST_CHNLDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
DIVISIONDivision SPARTCHAR2TSPASPARTSPAC_SPART
PURCH_ORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
PPTYPEPrice protection type /SAPHT/DRM_PPTYPECHAR1/SAPHT/DRM_PPTYPE
RB_LOTNOReconciliation bucket lot number /SAPHT/DRM_RBLOTNOCHAR10CHAR10
CUS_REF_FLDShip-and-debit claim reference number /SAPHT/DRM_SDCUSREFCHAR35/SAPHT/DRM_SDCUSREF
IND_ATO_MTSObject ID CCOBJIDCHAR1CHAR1
PROD_ORD_NOOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
XN_CODEDRM relevant transaction code /SAPHT/DRM_XNCODECHAR20/SAPHT/DRMCXNCD/SAPHT/DRM_XNCODE/SAPHT/DRMHXN_CODE
PROC_CODEDRM relevant processing code /SAPHT/DRM_PROCCODECHAR2/SAPHT/DRM_PROCCODE
MS_DR_INDIndicates manufacturer/supplier or distributor/reseller lot /SAPHT/DRM_MSDRINDCHAR1/SAPHT/DRM_MSDRIND
PROC_STATUSStatus of transactions /SAPHT/DRM_R3STATUSCHAR1/SAPHT/DRM_R3STATUS
LOGHANDLEApplication Log: Log Handle BALLOGHNDLCHAR22SYSUUID_22
CREATED_BYName of Person who Created the Object ERNAMCHAR12USNAM
CREATED_DTCreated on /SAPHT/DRM_CRDATEDATS8DATUM
CREATED_TMTime created C_TIMETIMS6UZEIT
LASTCHGDBYLast Changed By UPNAMCHAR12USNAM
LASTCHGDDTChanged On AEDATDATS8DATUM
CHANGED_TMLast changed at AS4TIMETIMS6AS4TIME

Key field Non-key field



How do I retrieve data from SAP table /SAPHT/DRMR3XN using ABAP code

The following ABAP code Example will allow you to do a basic selection on /SAPHT/DRMR3XN to SELECT all data from the table
DATA: WA_/SAPHT/DRMR3XN TYPE /SAPHT/DRMR3XN.

SELECT SINGLE *
FROM /SAPHT/DRMR3XN
INTO CORRESPONDING FIELDS OF WA_/SAPHT/DRMR3XN
WHERE...

How to access SAP table /SAPHT/DRMR3XN

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