/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
Here is some free PDF files that you can download free for your reference.
Download Now
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
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
LOTNO | DRM lot number | /SAPHT/DRM_LOTNO | BELNR |
AUDITNO | Total number of audit trails for DRM lot | /SAPHT/DRM_AUDITM | NUMC6 |
RUNNUMBER | run no. for fifo rollback. | /SAPHT/DRM_RUNNUMBER | CHAR30 |
CHANGE_DOCQTY | Change in the material document quantity | /SAPHT/DRM_CHMDOCQT | MENGV15_3 |
CHANGE_INVQTY | Change in the invoiced quantity | /SAPHT/DRM_CHIVQT | MENGV15_3 |
CHANGE_AVLQTY | Change in DRM lot available quantity | /SAPHT/DRM_CHAVQT | MENGV15_3 |
CHANGE_STQTY | Change in sell-through quantity | /SAPHT/DRM_CHSTQT | MENGV15_3 |
CHANGE_PIQTY | Change in material quantity issued to production | /SAPHT/DRM_CHPIQT | MENGV15_3 |
CHANGE_ECRQTY | Change in resale return quantity | /SAPHT/DRM_ECRETQTY | MENG15 |
CHANGE_MSRQTY | Change in quantity returned by distributor/ reseller | /SAPHT/DRM_MSRQTY | MENGV15_3 |
CHANGE_DSQTY | Change in Drop-Ship Sell-In qty | /SAPHT/DRM_DSSIQTY | MENG15 |
QTY_UNIT | Base Unit of Measure | MEINS | MEINS |
XN_DATE | Lot data modification effective date | /SAPHT/DRM_XN_DATE | DATUM |
XN_CODE | DRM relevant transaction code | /SAPHT/DRM_XNCODE | /SAPHT/DRM_XNCODE |
PROC_CODE | DRM relevant processing code | /SAPHT/DRM_PROCCODE | /SAPHT/DRM_PROCCODE |
INVNO | Inventory record number | /SAPHT/DRM_INVNO | BELNR |
IDOCNO | IDoc number | EDI_DOCNUM | EDI_DOCNUM |
COLL_RUN_NO | DRM collective processing number | /SAPHT/DRMCOLLRUNNO | CHAR10 |
TRANS_DATE | Reported date | /SAPHT/DRM_XNDT | DATS |
STEXT | Short text for audit trail modification | /SAPHT/DRM_STEXT | /SAPHT/DRM_STEXT |
LTEXT | Long text for audit trail modification | /SAPHT/DRM_LTEXT | /SAPHT/DRM_LTEXT |
.INCLUDE | Sellin Tracking Fields | ||
LS_REF_DOC_NO | Logical system of reference document | /SAPHT/DRM_LS_REFDOCNO | LOGSYS |
REF_DOC_TYP | Reference document type | /SAPHT/DRM_RFDOCTYP | /SAPHT/DRM_DOCTYP |
REF_DOC_NO | Reference document number | /SAPHT/DRM_RFDOCNO | XUACCNT |
REF_DOC_ITM | Reference document item number | /SAPHT/DRM_RFDOCITM | POSNR |
PO_ORDER_TYPE | Purchasing Document Type | ESART | BSART |
PRODORD_NO | Production order number | /SAPHT/DRM_PRODNO | XUACCNT |
SELLIN_DN_NO | Delivery | VBELN_VL | VBELN |
SELLIN_DN_ITM | Delivery Item | POSNR_VL | POSNR |
MATDOCNO | Goods Issue/ Goods receipt number | /SAPHT/DRM_MATDOCNO | BELNR |
MATDOCITEM | Goods Issue/ Goods receipt item number | /SAPHT/DRM_MATDCITM | POSNR |
MATDOCYR | Goods Issue/ Goods receipt document year | /SAPHT/DRM_MATDOCYR | GJAHR |
MATDOCDATE | Sell-in goods issue/ receipt document date | /SAPHT/DRM_MATDOCDT | DATUM |
INVDOCNO | Sell-in invoice/ invoice receipt document number | /SAPHT/DRM_INVDOCNO | BELNR |
INVDOCITM | Sell-In invoice/ invoice receipt document item number | /SAPHT/DRM_INVDOCITM | POSNR |
INVDOCYR | Fiscal year | /SAPHT/DRM_INVDOCYR | GJAHR |
COMP_CODE | Company Code | BUKRS | BUKRS |
INV_DOC_TYPE | Billing Type | FKART | FKART |
INVDATE | Sell-in invoice date | /SAPHT/DRM_INVDOCDT | DATUM |
PRIC_UNIT | Pricing unit for price protectable price | /SAPHT/DRM_PRCUNIT | KPEIN |
COND_RATE | Price protectable price condition rate | /SAPHT/DRM_COND_RATE | WERTV6 |
COND_CURR | Price protectable price currency | /SAPHT/DRM_COND_CURR | WAERS |
COND_NUMER | Numerator for converting price protectable price | /SAPHT/DRM_COND_NUMERATOR | UMBSZ |
COND_DENOM | Denominator for conversion to base unit | /SAPHT/DRM_COND_DENOM | UMBSN |
COND_UOM | Pricing unit of measure | /SAPHT/DRM_PRIC_UOM | MEINS |
.INCLUDE | Sellthru Tracking Fields | ||
END_CUST | DRM end customer | /SAPHT/DRM_ENDCST | BU_PARTNER |
TRACK_PARTNER | Tracking partner | /SAPHT/DRM_TRACK_PARTNER | BU_PARTNER |
MSBOOKPARTNO | Manufacturer Book Part Number | /SAPHT/DRM_MSBOOKPART | MATNR |
PARTNER | Business Partner Number | BU_PARTNER | BU_PARTNER |
MATERIAL | Material Number | MATNR | MATNR |
SALES_REP | Business Partner Number | BU_PARTNER | BU_PARTNER |
LS_EC_SO | Logical system of end customer sales order | /SAPHT/DRM_LS_ECSO | LOGSYS |
EC_ORDR_NO | End customer sales order number | /SAPHT/DRM_ECSONO | BELNR |
EC_ORDR_ITM | End customer sales order item number | /SAPHT/DRM_ECSOITM | POSNR |
EC_DN_NO | Delivery | VBELN_VL | VBELN |
EC_DN_ITEM | Delivery Item | POSNR_VL | POSNR |
EC_SHP_DT | Resale shipping date | /SAPHT/DRM_ECSHPDATE | DATS |
EC_INV_NO | End customer invoice number | /SAPHT/DRM_ECINVDOC | CHAR20 |
EC_INV_ITM | Resale invoice item number | /SAPHT/DRM_ECINVITM | POSNR |
EC_INV_DT | Resale invoice date | /SAPHT/DRM_ECINVDATE | DATUM |
EC_CM_NO | End customer return credit memo number | /SAPHT/DRM_ECCMDOC | CHAR20 |
EC_CM_ITM | End customer return credit memo item number | /SAPHT/DRM_ECCMITM | POSEX |
LAST_SELLIN_DT | Last Sell-In date at the time of the Transaction | /SAPHT/DRM_SELLINDT_RES | DATUM |
INT_XMNO | DRM internal transmission number | /SAPHT/DRM_INTXMNO | /SAPHT/DRM_INTXMNO |
TRANSM_NO | EDI transmission number | /SAPHT/DRM_TRANSMNO | CHAR20 |
EFF_DATE | EDI transmission effective date | /SAPHT/DRM_EFFDATE | DATS |
STAGDOCNO | IDOC staging table document number | /SAPHT/DRM_STAGDOCNO | BELNR |
RESALEPRC | Resale price | /SAPHT/DRM_RESPRC | WERTV6 |
RESALECURR | Resale price currency | /SAPHT/DRM_RESCURR | WAERS |
RESL_PRC_UNIT | Pricing quantity for resale price | /SAPHT/DRM_RESPRCUNIT | KPEIN |
RESL_PRC_UOM | Unit of measure for pricing quantity | /SAPHT/DRM_RESPRCUOM | MEINS |
IDOC_TYPE | Message Type | EDI_MESTYP | EDI_MESTYP |
.INCLUDE | PP Due List Tracking Fields | ||
O_PRIC_UNIT | Old price protectable price pricing unit | /SAPHT/DRM_OLDPRCUNIT | KPEIN |
O_COND_RATE | Old price protectable price | /SAPHT/DRM_OLDCONDRATE | WERTV6 |
O_COND_CURR | Old price protectable price currency | /SAPHT/DRM_OLDCONDCURR | WAERS |
O_COND_NUMER | Nr for converting old PP condition units to base units | /SAPHT/DRM_OLDCONDNR | UMBSZ |
O_COND_DENOM | Dr for converting old PP condition units to base units | /SAPHT/DRM_OLDCONDDR | UMBSN |
O_COND_UOM | Unit of measure for old price protectable price | /SAPHT/DRM_OLD_UOM | MEINS |
O_PPTYPE | Old Price Protection Type | /SAPHT/DRM_OLDPPTYPE | /SAPHT/DRM_PPTYPE |
PPCLMQTY | Price protection claim quantity | /SAPHT/DRM_PPCLMQTY | MENGV15_3 |
PPRVLQTY | Lot quantity eligible for revaluation | /SAPHT/DRM_PPRVLQTY | MENGV15_3 |
PPEFFDATE | Price protection effective date | /SAPHT/DRM_PPEFFDATE | DATS |
PPRUNDATE | Price protection run date | /SAPHT/DRM_PPRUNDATE | DATS |
PPANNO | Price protection announcement number | /SAPHT/DRM_PPANNO | CHAR10 |
PP_CLM_AMOUNT | Price Protection Claim Amount | /SAPHT/PPCLAIM_AMOUNT | WERTV8 |
CLM_AMOUNT_CURR | PP Claim Amount Currency | /SAPHT/PPCLAIM_CURR | WAERS |
LS_PPCLMDOC | Logical system of price protection claim document | /SAPHT/DRM_LS_PPCLM | LOGSYS |
PP_SLS_DOCNO | Price protection credit/ debit memo request number | /SAPHT/DRM_PPSLSDOCNO | VBELN |
PP_SLS_DOCITM | Price protection credit/ debit memo request item number | /SAPHT/DRM_PPSLSITMNO | POSNR |
PP_SLS_DOCQTY | Price protection qty in the credit/debit memo request | /SAPHT/DRM_PP_SLSDOCQTY | MENGV15 |
PP_SLS_DOCAMT | Price protection amount in the credit/debit memo request | /SAPHT/DRM_PP_SLSDOCAMT | WERTV8 |
PP_SLS_DOCCURR | Currency of the credit/debit memo request amount | /SAPHT/DRM_PP_SLSDOCCURR | WAERS |
PP_INV_DOCNO | Price protection credit/ debit memo number | /SAPHT/DRM_PPINVDOCNO | VBELN |
PP_INV_DOCITM | Price protection credit/ debit memo item number | /SAPHT/DRM_PPINVITMNO | POSNR |
PP_INV_DOCQTY | Price protection claim invoiced quantity | /SAPHT/DRM_PP_INVDOCQTY | MENGV15 |
PP_INV_DOCAMT | Price protection claim invoiced amount | /SAPHT/DRM_PP_INVDOCAMT | WERTV8 |
PP_INV_DOCCURR | Currency for the price protection claim invoced amount | /SAPHT/DRM_PP_INVDOCCURR | WAERS |
LS_PPRVLDOC | Logical system of price protection revaluation document | /SAPHT/DRM_LS_PPRVL | LOGSYS |
PPRVLDOCNO | Price protection revaluation document number | /SAPHT/DRM_PPRVLDOCNO | VBELN |
PPRVLDOCYR | Document year of Revaluation document | /SAPHT/DRM_PPRVLDOCYR | GJAHR |
PPRVLPOST | Posting period of Revaluation document | /SAPHT/DRM_PPRVLPOST | POPER |
PPRECORDNO | Price protection due list record number | /SAPHT/DRM_RECORDNO | BELNR |
.INCLUDE | SD Due List Tracking fields | ||
CLAIMDOCNO | Ship-and-debit claim document number | /SAPHT/DRM_CLAIMDOCNO | BELNR |
CUS_REF_FLD | Ship-and-debit claim reference number | /SAPHT/DRM_SDCUSREF | /SAPHT/DRM_SDCUSREF |
LS_SD_AGR | Logical system of ship & debit agreement | /SAPHT/DRM_LS_SDAGR | LOGSYS |
SD_AGR_NO | Ship-and-debit agreement number | /SAPHT/DRM_SDAGRNO | BELNR |
SD_AGR_ITM | Ship-and-debit agreement item number | /SAPHT/DRM_SDAGRITM | POSNR |
SD_AGR_RATE | Ship-and-debit agreement rate | /SAPHT/DRM_SDAGRRATE | WERTV6 |
SD_AGR_CURR | Ship-and-debit agreement rate currency | /SAPHT/DRM_SDAGRCURR | WAERS |
SD_PRIC_UNIT | Ship-and-debit agreement pricing unit | /SAPHT/DRM_AGR_PRC_UNIT | KPEIN |
AGR_CON_NUM | Numerator for coversion to base unit | /SAPHT/DRM_AGR_COND_NUMER | UMBSZ |
AGR_CON_DEN | Denominator for conversion to base unit of material | /SAPHT/DRM_AGR_COND_DENOM | UMBSN |
LOT_COND_RATE | PP Rate of the Lot at the time of SD Claim | /SAPHT/DRM_LOTCONDRATE | WERTV6 |
LOT_COND_CURR | PP Curr of the Lot at the time of SD Claim | /SAPHT/DRM_LOTCONDCURR | WAERS |
LOT_PRIC_UNIT | PP Pricing Unit at the time of SD Claim | /SAPHT/DRM_LOTPRICUNIT | KPEIN |
LOT_COND_NUMER | PP Condition Numerator at the time of SD Claim | /SAPHT/DRM_LOTCONDNUM | UMBSZ |
LOT_COND_DENOM | PP Condition Denominator at the time of SD Claim | /SAPHT/DRM_LOTCONDDEN | UMBSN |
LOT_CLAIM_QTY | Lot quantity used in the Claim Calculation | /SAPHT/DRM_LOTCLMQTY | MENG15 |
LOT_CLAIM_AMT | Claim Amount for the Lot | /SAPHT/DRM_LOTCLMAMT | WERTV8 |
LOT_CLAIM_CURR | Claim Currency for the Lot | /SAPHT/DRM_LOTCLMCURR | WAERS |
SD_SLS_DOCQTY | Ship and Debit qty in the credit/debit memo request | /SAPHT/DRM_SD_SLSDOCQTY | MENGV15 |
SD_SLS_DOCAMT | Ship and Debit amount in the credit/debit memo request | /SAPHT/DRM_SD_SLSDOCAMT | WERTV8 |
SD_SLS_DOCCURR | Currency of the credit/debit memo request amount | /SAPHT/DRM_SD_SLSDOCCURR | WAERS |
SD_INV_DOCQTY | Ship-and-debit invoice document quantity | /SAPHT/DRM_SD_INVDOCQTY | MENGV15 |
SD_INV_DOCAMT | Amount paid out as ship-and-debit claim | /SAPHT/DRM_SD_INVDOCAMT | WERTV8 |
SD_INV_DOCCURR | Currency for ship-and-debit amount in credit/ debit memo | /SAPHT/DRM_SD_INVDOCCURR | WAERS |
SD_SLS_DOCNO | Credit/ debit memo request number | /SAPHT/DRM_SLSDOC_NO | BELNR |
SD_SLS_DOCITM | Credit/ debit memo request item number | /SAPHT/DRM_SLSDOC_ITM | POSNR |
SD_INV_DOCNO | Credit/ debit memo number | /SAPHT/DRM_INVDOC_NO | VBELN |
SD_INV_DOCITM | Credit/ debit memo item number | /SAPHT/DRM_INVDOC_ITM | POSNR |
.INCLUDE | Bill up due list tracking fields | ||
BILLUPDLDOCNO | Bill-up due list document number | /SAPHT/DRM_BILLUP_DL_DOC_NO | BELNR |
ECRETNQTY | Lot Return Quantity used for Bill Up Due List Calculation | /SAPHT/LOT_ECRETNQTY | MENG15 |
BILLUPQTY | Calculated bill-up claim quantity | /SAPHT/DRM_CALCCLAIMQTY | MENG15 |
BU_SLS_DOCQTY | Bill up claim quantity in credit/ debit memo request | /SAPHT/DRM_BU_SLSDOCQTY | MENGV15 |
BU_INV_DOCQTY | Bill-up claim quantity in credit/ debit memo | /SAPHT/DRM_BU_INVDOCQTY | MENGV15 |
BILLUPAMT | Calculated claim amount | /SAPHT/DRM_CALCCLAIMAMT | WERTV8 |
BILLUPAMTCUR | Currency for calculated claim amount | /SAPHT/DRM_CALCCLAIMCUR | WAERS |
BU_SLS_DOCAMT | Bill up claim amount in credit/debit memo request | /SAPHT/DRM_BU_SLSDOCAMT | WERTV8 |
BU_SLS_DOCCURR | Currency of bill-up claim amount in Cr/ Dr memo request | /SAPHT/DRM_BU_SLSDOCCURR | WAERS |
BU_INV_DOCAMT | Bill-up claim amount in credit/ debit memo | /SAPHT/DRM_BU_INVDOCAMT | WERTV8 |
BU_INV_DOCCURR | Bill-up credit/ debit memo amount currency | /SAPHT/DRM_BU_INVDOCCURR | WAERS |
BU_SLS_DOCNO | Credit/ debit memo request number | /SAPHT/DRM_SLSDOC_NO | BELNR |
BU_SLS_DOCITM | Credit/ debit memo request item number | /SAPHT/DRM_SLSDOC_ITM | POSNR |
BU_INV_DOCNO | Credit/ debit memo number | /SAPHT/DRM_INVDOC_NO | VBELN |
BU_INV_DOCITM | Credit/ debit memo item number | /SAPHT/DRM_INVDOC_ITM | POSNR |
.INCLUDE | Cancellation Tracking fields | ||
CANCEL_DOCTYP | Cancellation document type | /SAPHT/DRM_CANDOCTYP | /SAPHT/DRM_DOCTYP |
CANCEL_DOCNO | Cancellation document number | /SAPHT/DRM_CANDOCNO | XUACCNT |
CANCEL_DOCITM | Cancellation document item number | /SAPHT/DRM_CANDOCITM | POSNR |
CANCEL_DOCDATE | Cancellation document date | /SAPHT/DRM_CANDOCDATE | DATUM |
CANCEL_RUN_DATE | Cancellation run date | /SAPHT/DRMCANCELRUNDATE | DATS |
CANCEL_IND | Cancellation indicator for audit trail | /SAPHT/DRM_CANCEL_IND | /SAPHT/DRM_CANCEL_IND |
CANCEL_INVNO | Cancellation invoice number | /SAPHT/DRM_CANCINVNO | CHAR10 |
CANCEL_INVITM | Cancellation Invoice item number | /SAPHT/DRM_CANCINVITM | POSNR |
CANCEL_INVDATE | Cancellation invoice date | /SAPHT/DRM_CANCINVDATE | DATUM |
REJ_REASON | Reason for rejection of quotations and sales orders | ABGRU_VA | ABGRU_VA |
.INCLUDE | DRM Structure for tracking Created By/Changed By... | ||
CREATED_BY | Name of Person who Created the Object | ERNAM | USNAM |
CREATED_DT | Created on | /SAPHT/DRM_CRDATE | DATUM |
CREATED_TM | Time created | C_TIME | UZEIT |
LASTCHGDBY | Last Changed By | UPNAM | USNAM |
LASTCHGDDT | Last Changed On | AEDAT | DATUM |
CHANGED_TM | Last changed at | AS4TIME | AS4TIME |
.INCLUDE | Addtional Fields to be stored in DRM Transaction tables | ||
DUMMY_1 | Dummy function in length 1 | DUMMY | DUMMY |
/SAPHT/DRMDETL related tables
Table | Note |
---|---|
/SAPHT/DRMDETL | DRM Audit Trail |
A435 | Sales org./Distr. chl/Customer/Material/DRM Agr No/DRM Itm |
RSAUPROF | Audit: Audit configuration parameters (audit profile) |
AUT_C_DELTTXID | Audit Trail (ILM): DBTABLOG Long Text Obj. w/o Logging |
AUT_C_DTELLOG | Audit Trail (ILM): Customizing Change Document Creation |
AUT_C_DTELLOGT | Audit Trail (ILM): Text Table Customizing Change Document |
AUT_C_TABLOG | Audit Trail (ILM): Customizing of Table Logging |
AUT_C_TABLOGT | Audit Trail (ILM): Text Table Customizing Table Log |
AUT_C_TEST_0 | Audit Trail (ILM): Test Table 0 |
AUT_C_TEST_1 | Audit Trail (ILM): Test Table 1 |
AUT_C_TEST_2 | Audit Trail (ILM): Test Table 2 |
AUT_C_TRANSLOG | Audit Trail (ILM): Assignment Transaction/Objects (S_AUT02) |
AUT_D_ARCH_HIST | Audit Trail (ILM): History Archiving Long Text Logs |
AUT_D_DBTABLOG | Audit Trail (ILM): Storage of Archived Table Logs |
AUT_D_ILM_CDHDR | Audit Trail (ILM): Storage Change Document Headers (ILM) |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP