/SAPHT/DRMDETL SAP (DRM Audit Trail) Table details
Dictionary Type: Table
Description: DRM Audit Trail
Description: DRM Audit Trail
ABAP Code to SELECT data from /SAPHT/DRMDETL
Related tables to /SAPHT/DRMDETL
Access table /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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
LOTNO | DRM lot number | /SAPHT/DRM_LOTNO | CHAR | 10 | ALPHA | BELNR | |||
AUDITNO | Total number of audit trails for DRM lot | /SAPHT/DRM_AUDITM | NUMC | 6 | NUMC6 | ||||
RUNNUMBER | run no. for fifo rollback. | /SAPHT/DRM_RUNNUMBER | CHAR | 30 | CHAR30 | ||||
CHANGE_DOCQTY | Change in the material document quantity | /SAPHT/DRM_CHMDOCQT | QUAN | 15(3) | MENGV15_3 | ||||
CHANGE_INVQTY | Change in the invoiced quantity | /SAPHT/DRM_CHIVQT | QUAN | 15(3) | MENGV15_3 | ||||
CHANGE_AVLQTY | Change in DRM lot available quantity | /SAPHT/DRM_CHAVQT | QUAN | 15(3) | MENGV15_3 | ||||
CHANGE_STQTY | Change in sell-through quantity | /SAPHT/DRM_CHSTQT | QUAN | 15(3) | MENGV15_3 | ||||
CHANGE_PIQTY | Change in material quantity issued to production | /SAPHT/DRM_CHPIQT | QUAN | 15(3) | MENGV15_3 | ||||
CHANGE_ECRQTY | Change in resale return quantity | /SAPHT/DRM_ECRETQTY | QUAN | 15(3) | MENG15 | ||||
CHANGE_MSRQTY | Change in quantity returned by distributor/ reseller | /SAPHT/DRM_MSRQTY | QUAN | 15(3) | MENGV15_3 | ||||
CHANGE_DSQTY | Change in Drop-Ship Sell-In qty | /SAPHT/DRM_DSSIQTY | QUAN | 15(3) | MENG15 | ||||
QTY_UNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
XN_DATE | Lot data modification effective date | /SAPHT/DRM_XN_DATE | DATS | 8 | DATUM | ||||
XN_CODE | DRM relevant transaction code | /SAPHT/DRM_XNCODE | CHAR | 20 | Assigned to domain | /SAPHT/DRM_XNCODE | /SAPHT/DRMHXN_CODE | ||
PROC_CODE | DRM relevant processing code | /SAPHT/DRM_PROCCODE | CHAR | 2 | /SAPHT/DRM_PROCCODE | ||||
INVNO | Inventory record number | /SAPHT/DRM_INVNO | CHAR | 10 | ALPHA | BELNR | |||
IDOCNO | IDoc number | EDI_DOCNUM | NUMC | 16 | EDI_DOCNUM | DCN | |||
COLL_RUN_NO | DRM collective processing number | /SAPHT/DRMCOLLRUNNO | CHAR | 10 | CHAR10 | ||||
TRANS_DATE | Reported date | /SAPHT/DRM_XNDT | DATS | 8 | DATS | ||||
STEXT | Short text for audit trail modification | /SAPHT/DRM_STEXT | CHAR | 10 | /SAPHT/DRM_STEXT | ||||
LTEXT | Long text for audit trail modification | /SAPHT/DRM_LTEXT | CHAR | 40 | /SAPHT/DRM_LTEXT | ||||
LS_REF_DOC_NO | Logical system of reference document | /SAPHT/DRM_LS_REFDOCNO | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
REF_DOC_TYP | Reference document type | /SAPHT/DRM_RFDOCTYP | CHAR | 2 | /SAPHT/DRM_DOCTYP | ||||
REF_DOC_NO | Reference document number | /SAPHT/DRM_RFDOCNO | CHAR | 12 | XUACCNT | ||||
REF_DOC_ITM | Reference document item number | /SAPHT/DRM_RFDOCITM | NUMC | 6 | Assigned to domain | POSNR | |||
PO_ORDER_TYPE | Purchasing Document Type | ESART | CHAR | 4 | Assigned to domain | BSART | BSA | ||
PRODORD_NO | Production order number | /SAPHT/DRM_PRODNO | CHAR | 12 | XUACCNT | ||||
SELLIN_DN_NO | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
SELLIN_DN_ITM | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
MATDOCNO | Goods Issue/ Goods receipt number | /SAPHT/DRM_MATDOCNO | CHAR | 10 | ALPHA | BELNR | |||
MATDOCITEM | Goods Issue/ Goods receipt item number | /SAPHT/DRM_MATDCITM | NUMC | 6 | Assigned to domain | POSNR | |||
MATDOCYR | Goods Issue/ Goods receipt document year | /SAPHT/DRM_MATDOCYR | NUMC | 4 | GJAHR | GJAHR | |||
MATDOCDATE | Sell-in goods issue/ receipt document date | /SAPHT/DRM_MATDOCDT | DATS | 8 | DATUM | ||||
INVDOCNO | Sell-in invoice/ invoice receipt document number | /SAPHT/DRM_INVDOCNO | CHAR | 10 | ALPHA | BELNR | |||
INVDOCITM | Sell-In invoice/ invoice receipt document item number | /SAPHT/DRM_INVDOCITM | NUMC | 6 | Assigned to domain | POSNR | |||
INVDOCYR | Fiscal year | /SAPHT/DRM_INVDOCYR | NUMC | 4 | GJAHR | GJAHR | |||
COMP_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
INV_DOC_TYPE | Billing Type | FKART | CHAR | 4 | Assigned to domain | FKART | |||
INVDATE | Sell-in invoice date | /SAPHT/DRM_INVDOCDT | DATS | 8 | DATUM | ||||
PRIC_UNIT | Pricing unit for price protectable price | /SAPHT/DRM_PRCUNIT | DEC | 5 | KPEIN | ||||
COND_RATE | Price protectable price condition rate | /SAPHT/DRM_COND_RATE | CURR | 11(2) | WERTV6 | ||||
COND_CURR | Price protectable price currency | /SAPHT/DRM_COND_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
COND_NUMER | Numerator for converting price protectable price | /SAPHT/DRM_COND_NUMERATOR | DEC | 5 | UMBSZ | ||||
COND_DENOM | Denominator for conversion to base unit | /SAPHT/DRM_COND_DENOM | DEC | 5 | UMBSN | ||||
COND_UOM | Pricing unit of measure | /SAPHT/DRM_PRIC_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
END_CUST | DRM end customer | /SAPHT/DRM_ENDCST | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | DEBI | |
TRACK_PARTNER | Tracking partner | /SAPHT/DRM_TRACK_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
MSBOOKPARTNO | Manufacturer Book Part Number | /SAPHT/DRM_MSBOOKPART | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT1 | |
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
MATERIAL | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
SALES_REP | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
LS_EC_SO | Logical system of end customer sales order | /SAPHT/DRM_LS_ECSO | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
EC_ORDR_NO | End customer sales order number | /SAPHT/DRM_ECSONO | CHAR | 10 | ALPHA | BELNR | |||
EC_ORDR_ITM | End customer sales order item number | /SAPHT/DRM_ECSOITM | NUMC | 6 | Assigned to domain | POSNR | |||
EC_DN_NO | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
EC_DN_ITEM | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
EC_SHP_DT | Resale shipping date | /SAPHT/DRM_ECSHPDATE | DATS | 8 | DATS | ||||
EC_INV_NO | End customer invoice number | /SAPHT/DRM_ECINVDOC | CHAR | 20 | CHAR20 | ||||
EC_INV_ITM | Resale invoice item number | /SAPHT/DRM_ECINVITM | NUMC | 6 | Assigned to domain | POSNR | |||
EC_INV_DT | Resale invoice date | /SAPHT/DRM_ECINVDATE | DATS | 8 | DATUM | ||||
EC_CM_NO | End customer return credit memo number | /SAPHT/DRM_ECCMDOC | CHAR | 20 | CHAR20 | ||||
EC_CM_ITM | End customer return credit memo item number | /SAPHT/DRM_ECCMITM | CHAR | 6 | ALPHA | POSEX | |||
LAST_SELLIN_DT | Last Sell-In date at the time of the Transaction | /SAPHT/DRM_SELLINDT_RES | DATS | 8 | DATUM | ||||
INT_XMNO | DRM internal transmission number | /SAPHT/DRM_INTXMNO | CHAR | 20 | ALPHA | /SAPHT/DRM_INTXMNO | |||
TRANSM_NO | EDI transmission number | /SAPHT/DRM_TRANSMNO | CHAR | 20 | CHAR20 | /SAPHT/DRM_TRANSM_NO | |||
EFF_DATE | EDI transmission effective date | /SAPHT/DRM_EFFDATE | DATS | 8 | DATS | ||||
STAGDOCNO | IDOC staging table document number | /SAPHT/DRM_STAGDOCNO | CHAR | 10 | ALPHA | BELNR | |||
RESALEPRC | Resale price | /SAPHT/DRM_RESPRC | CURR | 11(2) | WERTV6 | ||||
RESALECURR | Resale price currency | /SAPHT/DRM_RESCURR | CUKY | 5 | Assigned to domain | WAERS | |||
RESL_PRC_UNIT | Pricing quantity for resale price | /SAPHT/DRM_RESPRCUNIT | DEC | 5 | KPEIN | ||||
RESL_PRC_UOM | Unit of measure for pricing quantity | /SAPHT/DRM_RESPRCUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
IDOC_TYPE | Message Type | EDI_MESTYP | CHAR | 30 | Assigned to domain | EDI_MESTYP | MES | ||
O_PRIC_UNIT | Old price protectable price pricing unit | /SAPHT/DRM_OLDPRCUNIT | DEC | 5 | KPEIN | ||||
O_COND_RATE | Old price protectable price | /SAPHT/DRM_OLDCONDRATE | CURR | 11(2) | WERTV6 | ||||
O_COND_CURR | Old price protectable price currency | /SAPHT/DRM_OLDCONDCURR | CUKY | 5 | Assigned to domain | WAERS | |||
O_COND_NUMER | Nr for converting old PP condition units to base units | /SAPHT/DRM_OLDCONDNR | DEC | 5 | UMBSZ | ||||
O_COND_DENOM | Dr for converting old PP condition units to base units | /SAPHT/DRM_OLDCONDDR | DEC | 5 | UMBSN | ||||
O_COND_UOM | Unit of measure for old price protectable price | /SAPHT/DRM_OLD_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
O_PPTYPE | Old Price Protection Type | /SAPHT/DRM_OLDPPTYPE | CHAR | 1 | /SAPHT/DRM_PPTYPE | ||||
PPCLMQTY | Price protection claim quantity | /SAPHT/DRM_PPCLMQTY | QUAN | 15(3) | MENGV15_3 | ||||
PPRVLQTY | Lot quantity eligible for revaluation | /SAPHT/DRM_PPRVLQTY | QUAN | 15(3) | MENGV15_3 | ||||
PPEFFDATE | Price protection effective date | /SAPHT/DRM_PPEFFDATE | DATS | 8 | DATS | /SAPHT/DRM_PPEFFDT | |||
PPRUNDATE | Price protection run date | /SAPHT/DRM_PPRUNDATE | DATS | 8 | DATS | ||||
PPANNO | Price protection announcement number | /SAPHT/DRM_PPANNO | CHAR | 10 | CHAR10 | ||||
PP_CLM_AMOUNT | Price Protection Claim Amount | /SAPHT/PPCLAIM_AMOUNT | CURR | 15(2) | WERTV8 | ||||
CLM_AMOUNT_CURR | PP Claim Amount Currency | /SAPHT/PPCLAIM_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
LS_PPCLMDOC | Logical system of price protection claim document | /SAPHT/DRM_LS_PPCLM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
PP_SLS_DOCNO | Price protection credit/ debit memo request number | /SAPHT/DRM_PPSLSDOCNO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
PP_SLS_DOCITM | Price protection credit/ debit memo request item number | /SAPHT/DRM_PPSLSITMNO | NUMC | 6 | Assigned to domain | POSNR | |||
PP_SLS_DOCQTY | Price protection qty in the credit/debit memo request | /SAPHT/DRM_PP_SLSDOCQTY | QUAN | 15(3) | MENGV15 | ||||
PP_SLS_DOCAMT | Price protection amount in the credit/debit memo request | /SAPHT/DRM_PP_SLSDOCAMT | CURR | 15(2) | WERTV8 | ||||
PP_SLS_DOCCURR | Currency of the credit/debit memo request amount | /SAPHT/DRM_PP_SLSDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
PP_INV_DOCNO | Price protection credit/ debit memo number | /SAPHT/DRM_PPINVDOCNO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
PP_INV_DOCITM | Price protection credit/ debit memo item number | /SAPHT/DRM_PPINVITMNO | NUMC | 6 | Assigned to domain | POSNR | |||
PP_INV_DOCQTY | Price protection claim invoiced quantity | /SAPHT/DRM_PP_INVDOCQTY | QUAN | 15(3) | MENGV15 | ||||
PP_INV_DOCAMT | Price protection claim invoiced amount | /SAPHT/DRM_PP_INVDOCAMT | CURR | 15(2) | WERTV8 | ||||
PP_INV_DOCCURR | Currency for the price protection claim invoced amount | /SAPHT/DRM_PP_INVDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
LS_PPRVLDOC | Logical system of price protection revaluation document | /SAPHT/DRM_LS_PPRVL | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
PPRVLDOCNO | Price protection revaluation document number | /SAPHT/DRM_PPRVLDOCNO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
PPRVLDOCYR | Document year of Revaluation document | /SAPHT/DRM_PPRVLDOCYR | NUMC | 4 | GJAHR | GJAHR | |||
PPRVLPOST | Posting period of Revaluation document | /SAPHT/DRM_PPRVLPOST | NUMC | 3 | POPER | ||||
PPRECORDNO | Price protection due list record number | /SAPHT/DRM_RECORDNO | CHAR | 10 | ALPHA | BELNR | |||
CLAIMDOCNO | Ship-and-debit claim document number | /SAPHT/DRM_CLAIMDOCNO | CHAR | 10 | ALPHA | BELNR | |||
CUS_REF_FLD | Ship-and-debit claim reference number | /SAPHT/DRM_SDCUSREF | CHAR | 35 | /SAPHT/DRM_SDCUSREF | ||||
LS_SD_AGR | Logical system of ship & debit agreement | /SAPHT/DRM_LS_SDAGR | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
SD_AGR_NO | Ship-and-debit agreement number | /SAPHT/DRM_SDAGRNO | CHAR | 10 | ALPHA | BELNR | |||
SD_AGR_ITM | Ship-and-debit agreement item number | /SAPHT/DRM_SDAGRITM | NUMC | 6 | Assigned to domain | POSNR | |||
SD_AGR_RATE | Ship-and-debit agreement rate | /SAPHT/DRM_SDAGRRATE | CURR | 11(2) | WERTV6 | ||||
SD_AGR_CURR | Ship-and-debit agreement rate currency | /SAPHT/DRM_SDAGRCURR | CUKY | 5 | Assigned to domain | WAERS | |||
SD_PRIC_UNIT | Ship-and-debit agreement pricing unit | /SAPHT/DRM_AGR_PRC_UNIT | DEC | 5 | KPEIN | ||||
AGR_CON_NUM | Numerator for coversion to base unit | /SAPHT/DRM_AGR_COND_NUMER | DEC | 5 | UMBSZ | ||||
AGR_CON_DEN | Denominator for conversion to base unit of material | /SAPHT/DRM_AGR_COND_DENOM | DEC | 5 | UMBSN | ||||
LOT_COND_RATE | PP Rate of the Lot at the time of SD Claim | /SAPHT/DRM_LOTCONDRATE | CURR | 11(2) | WERTV6 | ||||
LOT_COND_CURR | PP Curr of the Lot at the time of SD Claim | /SAPHT/DRM_LOTCONDCURR | CUKY | 5 | Assigned to domain | WAERS | |||
LOT_PRIC_UNIT | PP Pricing Unit at the time of SD Claim | /SAPHT/DRM_LOTPRICUNIT | DEC | 5 | KPEIN | ||||
LOT_COND_NUMER | PP Condition Numerator at the time of SD Claim | /SAPHT/DRM_LOTCONDNUM | DEC | 5 | UMBSZ | ||||
LOT_COND_DENOM | PP Condition Denominator at the time of SD Claim | /SAPHT/DRM_LOTCONDDEN | DEC | 5 | UMBSN | ||||
LOT_CLAIM_QTY | Lot quantity used in the Claim Calculation | /SAPHT/DRM_LOTCLMQTY | QUAN | 15(3) | MENG15 | ||||
LOT_CLAIM_AMT | Claim Amount for the Lot | /SAPHT/DRM_LOTCLMAMT | CURR | 15(2) | WERTV8 | ||||
LOT_CLAIM_CURR | Claim Currency for the Lot | /SAPHT/DRM_LOTCLMCURR | CUKY | 5 | Assigned to domain | WAERS | |||
SD_SLS_DOCQTY | Ship and Debit qty in the credit/debit memo request | /SAPHT/DRM_SD_SLSDOCQTY | QUAN | 15(3) | MENGV15 | ||||
SD_SLS_DOCAMT | Ship and Debit amount in the credit/debit memo request | /SAPHT/DRM_SD_SLSDOCAMT | CURR | 15(2) | WERTV8 | ||||
SD_SLS_DOCCURR | Currency of the credit/debit memo request amount | /SAPHT/DRM_SD_SLSDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
SD_INV_DOCQTY | Ship-and-debit invoice document quantity | /SAPHT/DRM_SD_INVDOCQTY | QUAN | 15(3) | MENGV15 | ||||
SD_INV_DOCAMT | Amount paid out as ship-and-debit claim | /SAPHT/DRM_SD_INVDOCAMT | CURR | 15(2) | WERTV8 | ||||
SD_INV_DOCCURR | Currency for ship-and-debit amount in credit/ debit memo | /SAPHT/DRM_SD_INVDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
SD_SLS_DOCNO | Credit/ debit memo request number | /SAPHT/DRM_SLSDOC_NO | CHAR | 10 | ALPHA | BELNR | |||
SD_SLS_DOCITM | Credit/ debit memo request item number | /SAPHT/DRM_SLSDOC_ITM | NUMC | 6 | Assigned to domain | POSNR | |||
SD_INV_DOCNO | Credit/ debit memo number | /SAPHT/DRM_INVDOC_NO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
SD_INV_DOCITM | Credit/ debit memo item number | /SAPHT/DRM_INVDOC_ITM | NUMC | 6 | Assigned to domain | POSNR | |||
BILLUPDLDOCNO | Bill-up due list document number | /SAPHT/DRM_BILLUP_DL_DOC_NO | CHAR | 10 | ALPHA | BELNR | |||
ECRETNQTY | Lot Return Quantity used for Bill Up Due List Calculation | /SAPHT/LOT_ECRETNQTY | QUAN | 15(3) | MENG15 | ||||
BILLUPQTY | Calculated bill-up claim quantity | /SAPHT/DRM_CALCCLAIMQTY | QUAN | 15(3) | MENG15 | ||||
BU_SLS_DOCQTY | Bill up claim quantity in credit/ debit memo request | /SAPHT/DRM_BU_SLSDOCQTY | QUAN | 15(3) | MENGV15 | ||||
BU_INV_DOCQTY | Bill-up claim quantity in credit/ debit memo | /SAPHT/DRM_BU_INVDOCQTY | QUAN | 15(3) | MENGV15 | ||||
BILLUPAMT | Calculated claim amount | /SAPHT/DRM_CALCCLAIMAMT | CURR | 15(2) | WERTV8 | ||||
BILLUPAMTCUR | Currency for calculated claim amount | /SAPHT/DRM_CALCCLAIMCUR | CUKY | 5 | Assigned to domain | WAERS | |||
BU_SLS_DOCAMT | Bill up claim amount in credit/debit memo request | /SAPHT/DRM_BU_SLSDOCAMT | CURR | 15(2) | WERTV8 | ||||
BU_SLS_DOCCURR | Currency of bill-up claim amount in Cr/ Dr memo request | /SAPHT/DRM_BU_SLSDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
BU_INV_DOCAMT | Bill-up claim amount in credit/ debit memo | /SAPHT/DRM_BU_INVDOCAMT | CURR | 15(2) | WERTV8 | ||||
BU_INV_DOCCURR | Bill-up credit/ debit memo amount currency | /SAPHT/DRM_BU_INVDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
BU_SLS_DOCNO | Credit/ debit memo request number | /SAPHT/DRM_SLSDOC_NO | CHAR | 10 | ALPHA | BELNR | |||
BU_SLS_DOCITM | Credit/ debit memo request item number | /SAPHT/DRM_SLSDOC_ITM | NUMC | 6 | Assigned to domain | POSNR | |||
BU_INV_DOCNO | Credit/ debit memo number | /SAPHT/DRM_INVDOC_NO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
BU_INV_DOCITM | Credit/ debit memo item number | /SAPHT/DRM_INVDOC_ITM | NUMC | 6 | Assigned to domain | POSNR | |||
CANCEL_DOCTYP | Cancellation document type | /SAPHT/DRM_CANDOCTYP | CHAR | 2 | /SAPHT/DRM_DOCTYP | ||||
CANCEL_DOCNO | Cancellation document number | /SAPHT/DRM_CANDOCNO | CHAR | 12 | XUACCNT | ||||
CANCEL_DOCITM | Cancellation document item number | /SAPHT/DRM_CANDOCITM | NUMC | 6 | Assigned to domain | POSNR | |||
CANCEL_DOCDATE | Cancellation document date | /SAPHT/DRM_CANDOCDATE | DATS | 8 | DATUM | ||||
CANCEL_RUN_DATE | Cancellation run date | /SAPHT/DRMCANCELRUNDATE | DATS | 8 | DATS | ||||
CANCEL_IND | Cancellation indicator for audit trail | /SAPHT/DRM_CANCEL_IND | CHAR | 1 | /SAPHT/DRM_CANCEL_IND | ||||
CANCEL_INVNO | Cancellation invoice number | /SAPHT/DRM_CANCINVNO | CHAR | 10 | CHAR10 | ||||
CANCEL_INVITM | Cancellation Invoice item number | /SAPHT/DRM_CANCINVITM | NUMC | 6 | Assigned to domain | POSNR | |||
CANCEL_INVDATE | Cancellation invoice date | /SAPHT/DRM_CANCINVDATE | DATS | 8 | DATUM | ||||
REJ_REASON | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | Assigned to domain | ABGRU_VA | |||
CREATED_BY | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
CREATED_DT | Created on | /SAPHT/DRM_CRDATE | DATS | 8 | DATUM | ||||
CREATED_TM | Time created | C_TIME | TIMS | 6 | UZEIT | ||||
LASTCHGDBY | Last Changed By | UPNAM | CHAR | 12 | USNAM | ||||
LASTCHGDDT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
CHANGED_TM | Last changed at | AS4TIME | TIMS | 6 | AS4TIME | ||||
DUMMY_1 | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects