/SAPHT/DRMDETL SAP (DRM Audit Trail) Table details

Dictionary Type: Table
Description: DRM Audit Trail




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




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

/SAPHT/DRMDETL is a standard SAP Table which is used to store DRM Audit Trail data and is available within R/3 SAP systems depending on the version and release level.

The /SAPHT/DRMDETL table consists of various fields, each holding specific information or linking keys about DRM Audit Trail data available in SAP. These include LOTNO (DRM lot number), AUDITNO (Total number of audit trails for DRM lot), RUNNUMBER (run no. for fifo rollback.), CHANGE_DOCQTY (Change in the material document quantity).. 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/DRMDETL 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 MANDTCLNT3Assigned to domainMANDT
LOTNODRM lot number /SAPHT/DRM_LOTNOCHAR10ALPHABELNR
AUDITNOTotal number of audit trails for DRM lot /SAPHT/DRM_AUDITMNUMC6NUMC6
RUNNUMBERrun no. for fifo rollback. /SAPHT/DRM_RUNNUMBERCHAR30CHAR30
CHANGE_DOCQTYChange in the material document quantity /SAPHT/DRM_CHMDOCQTQUAN15(3) MENGV15_3
CHANGE_INVQTYChange in the invoiced quantity /SAPHT/DRM_CHIVQTQUAN15(3) MENGV15_3
CHANGE_AVLQTYChange in DRM lot available quantity /SAPHT/DRM_CHAVQTQUAN15(3) MENGV15_3
CHANGE_STQTYChange in sell-through quantity /SAPHT/DRM_CHSTQTQUAN15(3) MENGV15_3
CHANGE_PIQTYChange in material quantity issued to production /SAPHT/DRM_CHPIQTQUAN15(3) MENGV15_3
CHANGE_ECRQTYChange in resale return quantity /SAPHT/DRM_ECRETQTYQUAN15(3) MENG15
CHANGE_MSRQTYChange in quantity returned by distributor/ reseller /SAPHT/DRM_MSRQTYQUAN15(3) MENGV15_3
CHANGE_DSQTYChange in Drop-Ship Sell-In qty /SAPHT/DRM_DSSIQTYQUAN15(3) MENG15
QTY_UNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
XN_DATELot data modification effective date /SAPHT/DRM_XN_DATEDATS8DATUM
XN_CODEDRM relevant transaction code /SAPHT/DRM_XNCODECHAR20Assigned to domain/SAPHT/DRM_XNCODE/SAPHT/DRMHXN_CODE
PROC_CODEDRM relevant processing code /SAPHT/DRM_PROCCODECHAR2/SAPHT/DRM_PROCCODE
INVNOInventory record number /SAPHT/DRM_INVNOCHAR10ALPHABELNR
IDOCNOIDoc number EDI_DOCNUMNUMC16EDI_DOCNUMDCN
COLL_RUN_NODRM collective processing number /SAPHT/DRMCOLLRUNNOCHAR10CHAR10
TRANS_DATEReported date /SAPHT/DRM_XNDTDATS8DATS
STEXTShort text for audit trail modification /SAPHT/DRM_STEXTCHAR10/SAPHT/DRM_STEXT
LTEXTLong text for audit trail modification /SAPHT/DRM_LTEXTCHAR40/SAPHT/DRM_LTEXT
LS_REF_DOC_NOLogical system of reference document /SAPHT/DRM_LS_REFDOCNOCHAR10Assigned to domainALPHALOGSYS
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
PO_ORDER_TYPEPurchasing Document Type ESARTCHAR4Assigned to domainBSARTBSA
PRODORD_NOProduction order number /SAPHT/DRM_PRODNOCHAR12XUACCNT
SELLIN_DN_NODelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
SELLIN_DN_ITMDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
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
MATDOCDATESell-in goods issue/ receipt document date /SAPHT/DRM_MATDOCDTDATS8DATUM
INVDOCNOSell-in invoice/ invoice receipt document number /SAPHT/DRM_INVDOCNOCHAR10ALPHABELNR
INVDOCITMSell-In invoice/ invoice receipt document item number /SAPHT/DRM_INVDOCITMNUMC6Assigned to domainPOSNR
INVDOCYRFiscal year /SAPHT/DRM_INVDOCYRNUMC4GJAHRGJAHR
COMP_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
INV_DOC_TYPEBilling Type FKARTCHAR4Assigned to domainFKART
INVDATESell-in invoice date /SAPHT/DRM_INVDOCDTDATS8DATUM
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
END_CUSTDRM end customer /SAPHT/DRM_ENDCSTCHAR10Assigned to domainALPHABU_PARTNERDEBI
TRACK_PARTNERTracking partner /SAPHT/DRM_TRACK_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBUPA
MSBOOKPARTNOManufacturer Book Part Number /SAPHT/DRM_MSBOOKPARTCHAR18Assigned to domainMATN1MATNRMAT1
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
MATERIALMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
SALES_REPBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
LS_EC_SOLogical system of end customer sales order /SAPHT/DRM_LS_ECSOCHAR10Assigned to domainALPHALOGSYS
EC_ORDR_NOEnd customer sales order number /SAPHT/DRM_ECSONOCHAR10ALPHABELNR
EC_ORDR_ITMEnd customer sales order item number /SAPHT/DRM_ECSOITMNUMC6Assigned to domainPOSNR
EC_DN_NODelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
EC_DN_ITEMDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
EC_SHP_DTResale shipping date /SAPHT/DRM_ECSHPDATEDATS8DATS
EC_INV_NOEnd customer invoice number /SAPHT/DRM_ECINVDOCCHAR20CHAR20
EC_INV_ITMResale invoice item number /SAPHT/DRM_ECINVITMNUMC6Assigned to domainPOSNR
EC_INV_DTResale invoice date /SAPHT/DRM_ECINVDATEDATS8DATUM
EC_CM_NOEnd customer return credit memo number /SAPHT/DRM_ECCMDOCCHAR20CHAR20
EC_CM_ITMEnd customer return credit memo item number /SAPHT/DRM_ECCMITMCHAR6ALPHAPOSEX
LAST_SELLIN_DTLast Sell-In date at the time of the Transaction /SAPHT/DRM_SELLINDT_RESDATS8DATUM
INT_XMNODRM internal transmission number /SAPHT/DRM_INTXMNOCHAR20ALPHA/SAPHT/DRM_INTXMNO
TRANSM_NOEDI transmission number /SAPHT/DRM_TRANSMNOCHAR20CHAR20/SAPHT/DRM_TRANSM_NO
EFF_DATEEDI transmission effective date /SAPHT/DRM_EFFDATEDATS8DATS
STAGDOCNOIDOC staging table document number /SAPHT/DRM_STAGDOCNOCHAR10ALPHABELNR
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
IDOC_TYPEMessage Type EDI_MESTYPCHAR30Assigned to domainEDI_MESTYPMES
O_PRIC_UNITOld price protectable price pricing unit /SAPHT/DRM_OLDPRCUNITDEC5KPEIN
O_COND_RATEOld price protectable price /SAPHT/DRM_OLDCONDRATECURR11(2) WERTV6
O_COND_CURROld price protectable price currency /SAPHT/DRM_OLDCONDCURRCUKY5Assigned to domainWAERS
O_COND_NUMERNr for converting old PP condition units to base units /SAPHT/DRM_OLDCONDNRDEC5UMBSZ
O_COND_DENOMDr for converting old PP condition units to base units /SAPHT/DRM_OLDCONDDRDEC5UMBSN
O_COND_UOMUnit of measure for old price protectable price /SAPHT/DRM_OLD_UOMUNIT3Assigned to domainCUNITMEINS
O_PPTYPEOld Price Protection Type /SAPHT/DRM_OLDPPTYPECHAR1/SAPHT/DRM_PPTYPE
PPCLMQTYPrice protection claim quantity /SAPHT/DRM_PPCLMQTYQUAN15(3) MENGV15_3
PPRVLQTYLot quantity eligible for revaluation /SAPHT/DRM_PPRVLQTYQUAN15(3) MENGV15_3
PPEFFDATEPrice protection effective date /SAPHT/DRM_PPEFFDATEDATS8DATS/SAPHT/DRM_PPEFFDT
PPRUNDATEPrice protection run date /SAPHT/DRM_PPRUNDATEDATS8DATS
PPANNOPrice protection announcement number /SAPHT/DRM_PPANNOCHAR10CHAR10
PP_CLM_AMOUNTPrice Protection Claim Amount /SAPHT/PPCLAIM_AMOUNTCURR15(2) WERTV8
CLM_AMOUNT_CURRPP Claim Amount Currency /SAPHT/PPCLAIM_CURRCUKY5Assigned to domainWAERS
LS_PPCLMDOCLogical system of price protection claim document /SAPHT/DRM_LS_PPCLMCHAR10Assigned to domainALPHALOGSYS
PP_SLS_DOCNOPrice protection credit/ debit memo request number /SAPHT/DRM_PPSLSDOCNOCHAR10Assigned to domainALPHAVBELN
PP_SLS_DOCITMPrice protection credit/ debit memo request item number /SAPHT/DRM_PPSLSITMNONUMC6Assigned to domainPOSNR
PP_SLS_DOCQTYPrice protection qty in the credit/debit memo request /SAPHT/DRM_PP_SLSDOCQTYQUAN15(3) MENGV15
PP_SLS_DOCAMTPrice protection amount in the credit/debit memo request /SAPHT/DRM_PP_SLSDOCAMTCURR15(2) WERTV8
PP_SLS_DOCCURRCurrency of the credit/debit memo request amount /SAPHT/DRM_PP_SLSDOCCURRCUKY5Assigned to domainWAERS
PP_INV_DOCNOPrice protection credit/ debit memo number /SAPHT/DRM_PPINVDOCNOCHAR10Assigned to domainALPHAVBELN
PP_INV_DOCITMPrice protection credit/ debit memo item number /SAPHT/DRM_PPINVITMNONUMC6Assigned to domainPOSNR
PP_INV_DOCQTYPrice protection claim invoiced quantity /SAPHT/DRM_PP_INVDOCQTYQUAN15(3) MENGV15
PP_INV_DOCAMTPrice protection claim invoiced amount /SAPHT/DRM_PP_INVDOCAMTCURR15(2) WERTV8
PP_INV_DOCCURRCurrency for the price protection claim invoced amount /SAPHT/DRM_PP_INVDOCCURRCUKY5Assigned to domainWAERS
LS_PPRVLDOCLogical system of price protection revaluation document /SAPHT/DRM_LS_PPRVLCHAR10Assigned to domainALPHALOGSYS
PPRVLDOCNOPrice protection revaluation document number /SAPHT/DRM_PPRVLDOCNOCHAR10Assigned to domainALPHAVBELN
PPRVLDOCYRDocument year of Revaluation document /SAPHT/DRM_PPRVLDOCYRNUMC4GJAHRGJAHR
PPRVLPOSTPosting period of Revaluation document /SAPHT/DRM_PPRVLPOSTNUMC3POPER
PPRECORDNOPrice protection due list record number /SAPHT/DRM_RECORDNOCHAR10ALPHABELNR
CLAIMDOCNOShip-and-debit claim document number /SAPHT/DRM_CLAIMDOCNOCHAR10ALPHABELNR
CUS_REF_FLDShip-and-debit claim reference number /SAPHT/DRM_SDCUSREFCHAR35/SAPHT/DRM_SDCUSREF
LS_SD_AGRLogical system of ship & debit agreement /SAPHT/DRM_LS_SDAGRCHAR10Assigned to domainALPHALOGSYS
SD_AGR_NOShip-and-debit agreement number /SAPHT/DRM_SDAGRNOCHAR10ALPHABELNR
SD_AGR_ITMShip-and-debit agreement item number /SAPHT/DRM_SDAGRITMNUMC6Assigned to domainPOSNR
SD_AGR_RATEShip-and-debit agreement rate /SAPHT/DRM_SDAGRRATECURR11(2) WERTV6
SD_AGR_CURRShip-and-debit agreement rate currency /SAPHT/DRM_SDAGRCURRCUKY5Assigned to domainWAERS
SD_PRIC_UNITShip-and-debit agreement pricing unit /SAPHT/DRM_AGR_PRC_UNITDEC5KPEIN
AGR_CON_NUMNumerator for coversion to base unit /SAPHT/DRM_AGR_COND_NUMERDEC5UMBSZ
AGR_CON_DENDenominator for conversion to base unit of material /SAPHT/DRM_AGR_COND_DENOMDEC5UMBSN
LOT_COND_RATEPP Rate of the Lot at the time of SD Claim /SAPHT/DRM_LOTCONDRATECURR11(2) WERTV6
LOT_COND_CURRPP Curr of the Lot at the time of SD Claim /SAPHT/DRM_LOTCONDCURRCUKY5Assigned to domainWAERS
LOT_PRIC_UNITPP Pricing Unit at the time of SD Claim /SAPHT/DRM_LOTPRICUNITDEC5KPEIN
LOT_COND_NUMERPP Condition Numerator at the time of SD Claim /SAPHT/DRM_LOTCONDNUMDEC5UMBSZ
LOT_COND_DENOMPP Condition Denominator at the time of SD Claim /SAPHT/DRM_LOTCONDDENDEC5UMBSN
LOT_CLAIM_QTYLot quantity used in the Claim Calculation /SAPHT/DRM_LOTCLMQTYQUAN15(3) MENG15
LOT_CLAIM_AMTClaim Amount for the Lot /SAPHT/DRM_LOTCLMAMTCURR15(2) WERTV8
LOT_CLAIM_CURRClaim Currency for the Lot /SAPHT/DRM_LOTCLMCURRCUKY5Assigned to domainWAERS
SD_SLS_DOCQTYShip and Debit qty in the credit/debit memo request /SAPHT/DRM_SD_SLSDOCQTYQUAN15(3) MENGV15
SD_SLS_DOCAMTShip and Debit amount in the credit/debit memo request /SAPHT/DRM_SD_SLSDOCAMTCURR15(2) WERTV8
SD_SLS_DOCCURRCurrency of the credit/debit memo request amount /SAPHT/DRM_SD_SLSDOCCURRCUKY5Assigned to domainWAERS
SD_INV_DOCQTYShip-and-debit invoice document quantity /SAPHT/DRM_SD_INVDOCQTYQUAN15(3) MENGV15
SD_INV_DOCAMTAmount paid out as ship-and-debit claim /SAPHT/DRM_SD_INVDOCAMTCURR15(2) WERTV8
SD_INV_DOCCURRCurrency for ship-and-debit amount in credit/ debit memo /SAPHT/DRM_SD_INVDOCCURRCUKY5Assigned to domainWAERS
SD_SLS_DOCNOCredit/ debit memo request number /SAPHT/DRM_SLSDOC_NOCHAR10ALPHABELNR
SD_SLS_DOCITMCredit/ debit memo request item number /SAPHT/DRM_SLSDOC_ITMNUMC6Assigned to domainPOSNR
SD_INV_DOCNOCredit/ debit memo number /SAPHT/DRM_INVDOC_NOCHAR10Assigned to domainALPHAVBELN
SD_INV_DOCITMCredit/ debit memo item number /SAPHT/DRM_INVDOC_ITMNUMC6Assigned to domainPOSNR
BILLUPDLDOCNOBill-up due list document number /SAPHT/DRM_BILLUP_DL_DOC_NOCHAR10ALPHABELNR
ECRETNQTYLot Return Quantity used for Bill Up Due List Calculation /SAPHT/LOT_ECRETNQTYQUAN15(3) MENG15
BILLUPQTYCalculated bill-up claim quantity /SAPHT/DRM_CALCCLAIMQTYQUAN15(3) MENG15
BU_SLS_DOCQTYBill up claim quantity in credit/ debit memo request /SAPHT/DRM_BU_SLSDOCQTYQUAN15(3) MENGV15
BU_INV_DOCQTYBill-up claim quantity in credit/ debit memo /SAPHT/DRM_BU_INVDOCQTYQUAN15(3) MENGV15
BILLUPAMTCalculated claim amount /SAPHT/DRM_CALCCLAIMAMTCURR15(2) WERTV8
BILLUPAMTCURCurrency for calculated claim amount /SAPHT/DRM_CALCCLAIMCURCUKY5Assigned to domainWAERS
BU_SLS_DOCAMTBill up claim amount in credit/debit memo request /SAPHT/DRM_BU_SLSDOCAMTCURR15(2) WERTV8
BU_SLS_DOCCURRCurrency of bill-up claim amount in Cr/ Dr memo request /SAPHT/DRM_BU_SLSDOCCURRCUKY5Assigned to domainWAERS
BU_INV_DOCAMTBill-up claim amount in credit/ debit memo /SAPHT/DRM_BU_INVDOCAMTCURR15(2) WERTV8
BU_INV_DOCCURRBill-up credit/ debit memo amount currency /SAPHT/DRM_BU_INVDOCCURRCUKY5Assigned to domainWAERS
BU_SLS_DOCNOCredit/ debit memo request number /SAPHT/DRM_SLSDOC_NOCHAR10ALPHABELNR
BU_SLS_DOCITMCredit/ debit memo request item number /SAPHT/DRM_SLSDOC_ITMNUMC6Assigned to domainPOSNR
BU_INV_DOCNOCredit/ debit memo number /SAPHT/DRM_INVDOC_NOCHAR10Assigned to domainALPHAVBELN
BU_INV_DOCITMCredit/ debit memo item number /SAPHT/DRM_INVDOC_ITMNUMC6Assigned to domainPOSNR
CANCEL_DOCTYPCancellation document type /SAPHT/DRM_CANDOCTYPCHAR2/SAPHT/DRM_DOCTYP
CANCEL_DOCNOCancellation document number /SAPHT/DRM_CANDOCNOCHAR12XUACCNT
CANCEL_DOCITMCancellation document item number /SAPHT/DRM_CANDOCITMNUMC6Assigned to domainPOSNR
CANCEL_DOCDATECancellation document date /SAPHT/DRM_CANDOCDATEDATS8DATUM
CANCEL_RUN_DATECancellation run date /SAPHT/DRMCANCELRUNDATEDATS8DATS
CANCEL_INDCancellation indicator for audit trail /SAPHT/DRM_CANCEL_INDCHAR1/SAPHT/DRM_CANCEL_IND
CANCEL_INVNOCancellation invoice number /SAPHT/DRM_CANCINVNOCHAR10CHAR10
CANCEL_INVITMCancellation Invoice item number /SAPHT/DRM_CANCINVITMNUMC6Assigned to domainPOSNR
CANCEL_INVDATECancellation invoice date /SAPHT/DRM_CANCINVDATEDATS8DATUM
REJ_REASONReason for rejection of quotations and sales orders ABGRU_VACHAR2Assigned to domainABGRU_VA
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
DUMMY_1Dummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



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

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

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

How to access SAP table /SAPHT/DRMDETL

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