SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

/SAPHT/DRMDETL Table in SAP | DRM Audit Trail Table & Fields List

/SAPHT/DRMDETL is a SAP table coming under IS module and ECC-DIMP component.View details, Fields & related tables of /SAPHT/DRMDETL in SAP.

  • Table description : DRM Audit Trail
  • Module : IS-HT-DRM
  • Parent Module : IS
  • Package : /SAPHT/DRM02
  • Software Component : ECC-DIMP
/SAPHT/DRMDETL table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP /SAPHT/DRMDETL Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
LOTNODRM lot number/SAPHT/DRM_LOTNOBELNR
AUDITNOTotal number of audit trails for DRM lot/SAPHT/DRM_AUDITMNUMC6
RUNNUMBERrun no. for fifo rollback./SAPHT/DRM_RUNNUMBERCHAR30
CHANGE_DOCQTYChange in the material document quantity/SAPHT/DRM_CHMDOCQTMENGV15_3
CHANGE_INVQTYChange in the invoiced quantity/SAPHT/DRM_CHIVQTMENGV15_3
CHANGE_AVLQTYChange in DRM lot available quantity/SAPHT/DRM_CHAVQTMENGV15_3
CHANGE_STQTYChange in sell-through quantity/SAPHT/DRM_CHSTQTMENGV15_3
CHANGE_PIQTYChange in material quantity issued to production/SAPHT/DRM_CHPIQTMENGV15_3
CHANGE_ECRQTYChange in resale return quantity/SAPHT/DRM_ECRETQTYMENG15
CHANGE_MSRQTYChange in quantity returned by distributor/ reseller/SAPHT/DRM_MSRQTYMENGV15_3
CHANGE_DSQTYChange in Drop-Ship Sell-In qty/SAPHT/DRM_DSSIQTYMENG15
QTY_UNITBase Unit of MeasureMEINSMEINS
XN_DATELot data modification effective date/SAPHT/DRM_XN_DATEDATUM
XN_CODEDRM relevant transaction code/SAPHT/DRM_XNCODE/SAPHT/DRM_XNCODE
PROC_CODEDRM relevant processing code/SAPHT/DRM_PROCCODE/SAPHT/DRM_PROCCODE
INVNOInventory record number/SAPHT/DRM_INVNOBELNR
IDOCNOIDoc numberEDI_DOCNUMEDI_DOCNUM
COLL_RUN_NODRM collective processing number/SAPHT/DRMCOLLRUNNOCHAR10
TRANS_DATEReported date/SAPHT/DRM_XNDTDATS
STEXTShort text for audit trail modification/SAPHT/DRM_STEXT/SAPHT/DRM_STEXT
LTEXTLong text for audit trail modification/SAPHT/DRM_LTEXT/SAPHT/DRM_LTEXT
.INCLUDESellin Tracking Fields    
LS_REF_DOC_NOLogical system of reference document/SAPHT/DRM_LS_REFDOCNOLOGSYS
REF_DOC_TYPReference document type/SAPHT/DRM_RFDOCTYP/SAPHT/DRM_DOCTYP
REF_DOC_NOReference document number/SAPHT/DRM_RFDOCNOXUACCNT
REF_DOC_ITMReference document item number/SAPHT/DRM_RFDOCITMPOSNR
PO_ORDER_TYPEPurchasing Document TypeESARTBSART
PRODORD_NOProduction order number/SAPHT/DRM_PRODNOXUACCNT
SELLIN_DN_NODeliveryVBELN_VLVBELN
SELLIN_DN_ITMDelivery ItemPOSNR_VLPOSNR
MATDOCNOGoods Issue/ Goods receipt number/SAPHT/DRM_MATDOCNOBELNR
MATDOCITEMGoods Issue/ Goods receipt item number/SAPHT/DRM_MATDCITMPOSNR
MATDOCYRGoods Issue/ Goods receipt document year/SAPHT/DRM_MATDOCYRGJAHR
MATDOCDATESell-in goods issue/ receipt document date/SAPHT/DRM_MATDOCDTDATUM
INVDOCNOSell-in invoice/ invoice receipt document number/SAPHT/DRM_INVDOCNOBELNR
INVDOCITMSell-In invoice/ invoice receipt document item number/SAPHT/DRM_INVDOCITMPOSNR
INVDOCYRFiscal year/SAPHT/DRM_INVDOCYRGJAHR
COMP_CODECompany CodeBUKRSBUKRS
INV_DOC_TYPEBilling TypeFKARTFKART
INVDATESell-in invoice date/SAPHT/DRM_INVDOCDTDATUM
PRIC_UNITPricing unit for price protectable price/SAPHT/DRM_PRCUNITKPEIN
COND_RATEPrice protectable price condition rate/SAPHT/DRM_COND_RATEWERTV6
COND_CURRPrice protectable price currency/SAPHT/DRM_COND_CURRWAERS
COND_NUMERNumerator for converting price protectable price/SAPHT/DRM_COND_NUMERATORUMBSZ
COND_DENOMDenominator for conversion to base unit/SAPHT/DRM_COND_DENOMUMBSN
COND_UOMPricing unit of measure/SAPHT/DRM_PRIC_UOMMEINS
.INCLUDESellthru Tracking Fields    
END_CUSTDRM end customer/SAPHT/DRM_ENDCSTBU_PARTNER
TRACK_PARTNERTracking partner/SAPHT/DRM_TRACK_PARTNERBU_PARTNER
MSBOOKPARTNOManufacturer Book Part Number/SAPHT/DRM_MSBOOKPARTMATNR
PARTNERBusiness Partner NumberBU_PARTNERBU_PARTNER
MATERIALMaterial NumberMATNRMATNR
SALES_REPBusiness Partner NumberBU_PARTNERBU_PARTNER
LS_EC_SOLogical system of end customer sales order/SAPHT/DRM_LS_ECSOLOGSYS
EC_ORDR_NOEnd customer sales order number/SAPHT/DRM_ECSONOBELNR
EC_ORDR_ITMEnd customer sales order item number/SAPHT/DRM_ECSOITMPOSNR
EC_DN_NODeliveryVBELN_VLVBELN
EC_DN_ITEMDelivery ItemPOSNR_VLPOSNR
EC_SHP_DTResale shipping date/SAPHT/DRM_ECSHPDATEDATS
EC_INV_NOEnd customer invoice number/SAPHT/DRM_ECINVDOCCHAR20
EC_INV_ITMResale invoice item number/SAPHT/DRM_ECINVITMPOSNR
EC_INV_DTResale invoice date/SAPHT/DRM_ECINVDATEDATUM
EC_CM_NOEnd customer return credit memo number/SAPHT/DRM_ECCMDOCCHAR20
EC_CM_ITMEnd customer return credit memo item number/SAPHT/DRM_ECCMITMPOSEX
LAST_SELLIN_DTLast Sell-In date at the time of the Transaction/SAPHT/DRM_SELLINDT_RESDATUM
INT_XMNODRM internal transmission number/SAPHT/DRM_INTXMNO/SAPHT/DRM_INTXMNO
TRANSM_NOEDI transmission number/SAPHT/DRM_TRANSMNOCHAR20
EFF_DATEEDI transmission effective date/SAPHT/DRM_EFFDATEDATS
STAGDOCNOIDOC staging table document number/SAPHT/DRM_STAGDOCNOBELNR
RESALEPRCResale price/SAPHT/DRM_RESPRCWERTV6
RESALECURRResale price currency/SAPHT/DRM_RESCURRWAERS
RESL_PRC_UNITPricing quantity for resale price/SAPHT/DRM_RESPRCUNITKPEIN
RESL_PRC_UOMUnit of measure for pricing quantity/SAPHT/DRM_RESPRCUOMMEINS
IDOC_TYPEMessage TypeEDI_MESTYPEDI_MESTYP
.INCLUDEPP Due List Tracking Fields    
O_PRIC_UNITOld price protectable price pricing unit/SAPHT/DRM_OLDPRCUNITKPEIN
O_COND_RATEOld price protectable price/SAPHT/DRM_OLDCONDRATEWERTV6
O_COND_CURROld price protectable price currency/SAPHT/DRM_OLDCONDCURRWAERS
O_COND_NUMERNr for converting old PP condition units to base units/SAPHT/DRM_OLDCONDNRUMBSZ
O_COND_DENOMDr for converting old PP condition units to base units/SAPHT/DRM_OLDCONDDRUMBSN
O_COND_UOMUnit of measure for old price protectable price/SAPHT/DRM_OLD_UOMMEINS
O_PPTYPEOld Price Protection Type/SAPHT/DRM_OLDPPTYPE/SAPHT/DRM_PPTYPE
PPCLMQTYPrice protection claim quantity/SAPHT/DRM_PPCLMQTYMENGV15_3
PPRVLQTYLot quantity eligible for revaluation/SAPHT/DRM_PPRVLQTYMENGV15_3
PPEFFDATEPrice protection effective date/SAPHT/DRM_PPEFFDATEDATS
PPRUNDATEPrice protection run date/SAPHT/DRM_PPRUNDATEDATS
PPANNOPrice protection announcement number/SAPHT/DRM_PPANNOCHAR10
PP_CLM_AMOUNTPrice Protection Claim Amount/SAPHT/PPCLAIM_AMOUNTWERTV8
CLM_AMOUNT_CURRPP Claim Amount Currency/SAPHT/PPCLAIM_CURRWAERS
LS_PPCLMDOCLogical system of price protection claim document/SAPHT/DRM_LS_PPCLMLOGSYS
PP_SLS_DOCNOPrice protection credit/ debit memo request number/SAPHT/DRM_PPSLSDOCNOVBELN
PP_SLS_DOCITMPrice protection credit/ debit memo request item number/SAPHT/DRM_PPSLSITMNOPOSNR
PP_SLS_DOCQTYPrice protection qty in the credit/debit memo request/SAPHT/DRM_PP_SLSDOCQTYMENGV15
PP_SLS_DOCAMTPrice protection amount in the credit/debit memo request/SAPHT/DRM_PP_SLSDOCAMTWERTV8
PP_SLS_DOCCURRCurrency of the credit/debit memo request amount/SAPHT/DRM_PP_SLSDOCCURRWAERS
PP_INV_DOCNOPrice protection credit/ debit memo number/SAPHT/DRM_PPINVDOCNOVBELN
PP_INV_DOCITMPrice protection credit/ debit memo item number/SAPHT/DRM_PPINVITMNOPOSNR
PP_INV_DOCQTYPrice protection claim invoiced quantity/SAPHT/DRM_PP_INVDOCQTYMENGV15
PP_INV_DOCAMTPrice protection claim invoiced amount/SAPHT/DRM_PP_INVDOCAMTWERTV8
PP_INV_DOCCURRCurrency for the price protection claim invoced amount/SAPHT/DRM_PP_INVDOCCURRWAERS
LS_PPRVLDOCLogical system of price protection revaluation document/SAPHT/DRM_LS_PPRVLLOGSYS
PPRVLDOCNOPrice protection revaluation document number/SAPHT/DRM_PPRVLDOCNOVBELN
PPRVLDOCYRDocument year of Revaluation document/SAPHT/DRM_PPRVLDOCYRGJAHR
PPRVLPOSTPosting period of Revaluation document/SAPHT/DRM_PPRVLPOSTPOPER
PPRECORDNOPrice protection due list record number/SAPHT/DRM_RECORDNOBELNR
.INCLUDESD Due List Tracking fields    
CLAIMDOCNOShip-and-debit claim document number/SAPHT/DRM_CLAIMDOCNOBELNR
CUS_REF_FLDShip-and-debit claim reference number/SAPHT/DRM_SDCUSREF/SAPHT/DRM_SDCUSREF
LS_SD_AGRLogical system of ship & debit agreement/SAPHT/DRM_LS_SDAGRLOGSYS
SD_AGR_NOShip-and-debit agreement number/SAPHT/DRM_SDAGRNOBELNR
SD_AGR_ITMShip-and-debit agreement item number/SAPHT/DRM_SDAGRITMPOSNR
SD_AGR_RATEShip-and-debit agreement rate/SAPHT/DRM_SDAGRRATEWERTV6
SD_AGR_CURRShip-and-debit agreement rate currency/SAPHT/DRM_SDAGRCURRWAERS
SD_PRIC_UNITShip-and-debit agreement pricing unit/SAPHT/DRM_AGR_PRC_UNITKPEIN
AGR_CON_NUMNumerator for coversion to base unit/SAPHT/DRM_AGR_COND_NUMERUMBSZ
AGR_CON_DENDenominator for conversion to base unit of material/SAPHT/DRM_AGR_COND_DENOMUMBSN
LOT_COND_RATEPP Rate of the Lot at the time of SD Claim/SAPHT/DRM_LOTCONDRATEWERTV6
LOT_COND_CURRPP Curr of the Lot at the time of SD Claim/SAPHT/DRM_LOTCONDCURRWAERS
LOT_PRIC_UNITPP Pricing Unit at the time of SD Claim/SAPHT/DRM_LOTPRICUNITKPEIN
LOT_COND_NUMERPP Condition Numerator at the time of SD Claim/SAPHT/DRM_LOTCONDNUMUMBSZ
LOT_COND_DENOMPP Condition Denominator at the time of SD Claim/SAPHT/DRM_LOTCONDDENUMBSN
LOT_CLAIM_QTYLot quantity used in the Claim Calculation/SAPHT/DRM_LOTCLMQTYMENG15
LOT_CLAIM_AMTClaim Amount for the Lot/SAPHT/DRM_LOTCLMAMTWERTV8
LOT_CLAIM_CURRClaim Currency for the Lot/SAPHT/DRM_LOTCLMCURRWAERS
SD_SLS_DOCQTYShip and Debit qty in the credit/debit memo request/SAPHT/DRM_SD_SLSDOCQTYMENGV15
SD_SLS_DOCAMTShip and Debit amount in the credit/debit memo request/SAPHT/DRM_SD_SLSDOCAMTWERTV8
SD_SLS_DOCCURRCurrency of the credit/debit memo request amount/SAPHT/DRM_SD_SLSDOCCURRWAERS
SD_INV_DOCQTYShip-and-debit invoice document quantity/SAPHT/DRM_SD_INVDOCQTYMENGV15
SD_INV_DOCAMTAmount paid out as ship-and-debit claim/SAPHT/DRM_SD_INVDOCAMTWERTV8
SD_INV_DOCCURRCurrency for ship-and-debit amount in credit/ debit memo/SAPHT/DRM_SD_INVDOCCURRWAERS
SD_SLS_DOCNOCredit/ debit memo request number/SAPHT/DRM_SLSDOC_NOBELNR
SD_SLS_DOCITMCredit/ debit memo request item number/SAPHT/DRM_SLSDOC_ITMPOSNR
SD_INV_DOCNOCredit/ debit memo number/SAPHT/DRM_INVDOC_NOVBELN
SD_INV_DOCITMCredit/ debit memo item number/SAPHT/DRM_INVDOC_ITMPOSNR
.INCLUDEBill up due list tracking fields    
BILLUPDLDOCNOBill-up due list document number/SAPHT/DRM_BILLUP_DL_DOC_NOBELNR
ECRETNQTYLot Return Quantity used for Bill Up Due List Calculation/SAPHT/LOT_ECRETNQTYMENG15
BILLUPQTYCalculated bill-up claim quantity/SAPHT/DRM_CALCCLAIMQTYMENG15
BU_SLS_DOCQTYBill up claim quantity in credit/ debit memo request/SAPHT/DRM_BU_SLSDOCQTYMENGV15
BU_INV_DOCQTYBill-up claim quantity in credit/ debit memo/SAPHT/DRM_BU_INVDOCQTYMENGV15
BILLUPAMTCalculated claim amount/SAPHT/DRM_CALCCLAIMAMTWERTV8
BILLUPAMTCURCurrency for calculated claim amount/SAPHT/DRM_CALCCLAIMCURWAERS
BU_SLS_DOCAMTBill up claim amount in credit/debit memo request/SAPHT/DRM_BU_SLSDOCAMTWERTV8
BU_SLS_DOCCURRCurrency of bill-up claim amount in Cr/ Dr memo request/SAPHT/DRM_BU_SLSDOCCURRWAERS
BU_INV_DOCAMTBill-up claim amount in credit/ debit memo/SAPHT/DRM_BU_INVDOCAMTWERTV8
BU_INV_DOCCURRBill-up credit/ debit memo amount currency/SAPHT/DRM_BU_INVDOCCURRWAERS
BU_SLS_DOCNOCredit/ debit memo request number/SAPHT/DRM_SLSDOC_NOBELNR
BU_SLS_DOCITMCredit/ debit memo request item number/SAPHT/DRM_SLSDOC_ITMPOSNR
BU_INV_DOCNOCredit/ debit memo number/SAPHT/DRM_INVDOC_NOVBELN
BU_INV_DOCITMCredit/ debit memo item number/SAPHT/DRM_INVDOC_ITMPOSNR
.INCLUDECancellation Tracking fields    
CANCEL_DOCTYPCancellation document type/SAPHT/DRM_CANDOCTYP/SAPHT/DRM_DOCTYP
CANCEL_DOCNOCancellation document number/SAPHT/DRM_CANDOCNOXUACCNT
CANCEL_DOCITMCancellation document item number/SAPHT/DRM_CANDOCITMPOSNR
CANCEL_DOCDATECancellation document date/SAPHT/DRM_CANDOCDATEDATUM
CANCEL_RUN_DATECancellation run date/SAPHT/DRMCANCELRUNDATEDATS
CANCEL_INDCancellation indicator for audit trail/SAPHT/DRM_CANCEL_IND/SAPHT/DRM_CANCEL_IND
CANCEL_INVNOCancellation invoice number/SAPHT/DRM_CANCINVNOCHAR10
CANCEL_INVITMCancellation Invoice item number/SAPHT/DRM_CANCINVITMPOSNR
CANCEL_INVDATECancellation invoice date/SAPHT/DRM_CANCINVDATEDATUM
REJ_REASONReason for rejection of quotations and sales ordersABGRU_VAABGRU_VA
.INCLUDEDRM Structure for tracking Created By/Changed By...    
CREATED_BYName of Person who Created the ObjectERNAMUSNAM
CREATED_DTCreated on/SAPHT/DRM_CRDATEDATUM
CREATED_TMTime createdC_TIMEUZEIT
LASTCHGDBYLast Changed ByUPNAMUSNAM
LASTCHGDDTLast Changed OnAEDATDATUM
CHANGED_TMLast changed atAS4TIMEAS4TIME
.INCLUDEAddtional Fields to be stored in DRM Transaction tables    
DUMMY_1Dummy function in length 1DUMMYDUMMY

/SAPHT/DRMDETL related tables

TableNote
/SAPHT/DRMDETLDRM Audit Trail
A435Sales org./Distr. chl/Customer/Material/DRM Agr No/DRM Itm
RSAUPROFAudit: Audit configuration parameters (audit profile)
AUT_C_DELTTXIDAudit Trail (ILM): DBTABLOG Long Text Obj. w/o Logging
AUT_C_DTELLOGAudit Trail (ILM): Customizing Change Document Creation
AUT_C_DTELLOGTAudit Trail (ILM): Text Table Customizing Change Document
AUT_C_TABLOGAudit Trail (ILM): Customizing of Table Logging
AUT_C_TABLOGTAudit Trail (ILM): Text Table Customizing Table Log
AUT_C_TEST_0Audit Trail (ILM): Test Table 0
AUT_C_TEST_1Audit Trail (ILM): Test Table 1
AUT_C_TEST_2Audit Trail (ILM): Test Table 2
AUT_C_TRANSLOGAudit Trail (ILM): Assignment Transaction/Objects (S_AUT02)
AUT_D_ARCH_HISTAudit Trail (ILM): History Archiving Long Text Logs
AUT_D_DBTABLOGAudit Trail (ILM): Storage of Archived Table Logs
AUT_D_ILM_CDHDRAudit Trail (ILM): Storage Change Document Headers (ILM)
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com