SAP ABAP Table /SAPHT/DRMDETL (DRM Audit Trail)
Hierarchy
ECC-DIMP (Software Component) DIMP
   IS-HT-DRM (Application Component) Distributor-Reseller-Management
     /SAPHT/DRM02 (Package) DRM Development
Basic Data
Table Category TRANSP    Transparent table 
Transparent table /SAPHT/DRMDETL   Table Relationship Diagram
Short Description DRM Audit Trail    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 LOTNO /SAPHT/DRM_LOTNO BELNR CHAR 10   0   DRM lot number  
3 AUDITNO /SAPHT/DRM_AUDITM NUMC6 NUMC 6   0   Total number of audit trails for DRM lot  
4 RUNNUMBER /SAPHT/DRM_RUNNUMBER CHAR30 CHAR 30   0   run no. for fifo rollback.  
5 CHANGE_DOCQTY /SAPHT/DRM_CHMDOCQT MENGV15_3 QUAN 15   3   Change in the material document quantity  
6 CHANGE_INVQTY /SAPHT/DRM_CHIVQT MENGV15_3 QUAN 15   3   Change in the invoiced quantity  
7 CHANGE_AVLQTY /SAPHT/DRM_CHAVQT MENGV15_3 QUAN 15   3   Change in DRM lot available quantity  
8 CHANGE_STQTY /SAPHT/DRM_CHSTQT MENGV15_3 QUAN 15   3   Change in sell-through quantity  
9 CHANGE_PIQTY /SAPHT/DRM_CHPIQT MENGV15_3 QUAN 15   3   Change in material quantity issued to production  
10 CHANGE_ECRQTY /SAPHT/DRM_ECRETQTY MENG15 QUAN 15   3   Change in resale return quantity  
11 CHANGE_MSRQTY /SAPHT/DRM_MSRQTY MENGV15_3 QUAN 15   3   Change in quantity returned by distributor/ reseller  
12 CHANGE_DSQTY /SAPHT/DRM_DSSIQTY MENG15 QUAN 15   3   Change in Drop-Ship Sell-In qty  
13 QTY_UNIT MEINS MEINS UNIT 3   0   Base Unit of Measure *
14 XN_DATE /SAPHT/DRM_XN_DATE DATUM DATS 8   0   Lot data modification effective date  
15 XN_CODE /SAPHT/DRM_XNCODE /SAPHT/DRM_XNCODE CHAR 20   0   DRM relevant transaction code *
16 PROC_CODE /SAPHT/DRM_PROCCODE /SAPHT/DRM_PROCCODE CHAR 2   0   DRM relevant processing code  
17 INVNO /SAPHT/DRM_INVNO BELNR CHAR 10   0   Inventory record number  
18 IDOCNO EDI_DOCNUM EDI_DOCNUM NUMC 16   0   IDoc number  
19 COLL_RUN_NO /SAPHT/DRMCOLLRUNNO CHAR10 CHAR 10   0   DRM collective processing number  
20 TRANS_DATE /SAPHT/DRM_XNDT DATS DATS 8   0   Reported date  
21 STEXT /SAPHT/DRM_STEXT /SAPHT/DRM_STEXT CHAR 10   0   Short text for audit trail modification  
22 LTEXT /SAPHT/DRM_LTEXT /SAPHT/DRM_LTEXT CHAR 40   0   Long text for audit trail modification  
23 .INCLUDE       0   0   Sellin Tracking Fields  
24 LS_REF_DOC_NO /SAPHT/DRM_LS_REFDOCNO LOGSYS CHAR 10   0   Logical system of reference document *
25 REF_DOC_TYP /SAPHT/DRM_RFDOCTYP /SAPHT/DRM_DOCTYP CHAR 2   0   Reference document type  
26 REF_DOC_NO /SAPHT/DRM_RFDOCNO XUACCNT CHAR 12   0   Reference document number  
27 REF_DOC_ITM /SAPHT/DRM_RFDOCITM POSNR NUMC 6   0   Reference document item number *
28 PO_ORDER_TYPE ESART BSART CHAR 4   0   Purchasing Document Type *
29 PRODORD_NO /SAPHT/DRM_PRODNO XUACCNT CHAR 12   0   Production order number  
30 SELLIN_DN_NO VBELN_VL VBELN CHAR 10   0   Delivery *
31 SELLIN_DN_ITM POSNR_VL POSNR NUMC 6   0   Delivery Item *
32 MATDOCNO /SAPHT/DRM_MATDOCNO BELNR CHAR 10   0   Goods Issue/ Goods receipt number  
33 MATDOCITEM /SAPHT/DRM_MATDCITM POSNR NUMC 6   0   Goods Issue/ Goods receipt item number *
34 MATDOCYR /SAPHT/DRM_MATDOCYR GJAHR NUMC 4   0   Goods Issue/ Goods receipt document year  
35 MATDOCDATE /SAPHT/DRM_MATDOCDT DATUM DATS 8   0   Sell-in goods issue/ receipt document date  
36 INVDOCNO /SAPHT/DRM_INVDOCNO BELNR CHAR 10   0   Sell-in invoice/ invoice receipt document number  
37 INVDOCITM /SAPHT/DRM_INVDOCITM POSNR NUMC 6   0   Sell-In invoice/ invoice receipt document item number *
38 INVDOCYR /SAPHT/DRM_INVDOCYR GJAHR NUMC 4   0   Fiscal year  
39 COMP_CODE BUKRS BUKRS CHAR 4   0   Company Code *
40 INV_DOC_TYPE FKART FKART CHAR 4   0   Billing Type *
41 INVDATE /SAPHT/DRM_INVDOCDT DATUM DATS 8   0   Sell-in invoice date  
42 PRIC_UNIT /SAPHT/DRM_PRCUNIT KPEIN DEC 5   0   Pricing unit for price protectable price  
43 COND_RATE /SAPHT/DRM_COND_RATE WERTV6 CURR 11   2   Price protectable price condition rate  
44 COND_CURR /SAPHT/DRM_COND_CURR WAERS CUKY 5   0   Price protectable price currency *
45 COND_NUMER /SAPHT/DRM_COND_NUMERATOR UMBSZ DEC 5   0   Numerator for converting price protectable price  
46 COND_DENOM /SAPHT/DRM_COND_DENOM UMBSN DEC 5   0   Denominator for conversion to base unit  
47 COND_UOM /SAPHT/DRM_PRIC_UOM MEINS UNIT 3   0   Pricing unit of measure *
48 .INCLUDE       0   0   Sellthru Tracking Fields  
49 END_CUST /SAPHT/DRM_ENDCST BU_PARTNER CHAR 10   0   DRM end customer *
50 TRACK_PARTNER /SAPHT/DRM_TRACK_PARTNER BU_PARTNER CHAR 10   0   Tracking partner *
51 MSBOOKPARTNO /SAPHT/DRM_MSBOOKPART MATNR CHAR 18   0   Manufacturer Book Part Number *
52 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
53 MATERIAL MATNR MATNR CHAR 18   0   Material Number *
54 SALES_REP BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
55 LS_EC_SO /SAPHT/DRM_LS_ECSO LOGSYS CHAR 10   0   Logical system of end customer sales order *
56 EC_ORDR_NO /SAPHT/DRM_ECSONO BELNR CHAR 10   0   End customer sales order number  
57 EC_ORDR_ITM /SAPHT/DRM_ECSOITM POSNR NUMC 6   0   End customer sales order item number *
58 EC_DN_NO VBELN_VL VBELN CHAR 10   0   Delivery *
59 EC_DN_ITEM POSNR_VL POSNR NUMC 6   0   Delivery Item *
60 EC_SHP_DT /SAPHT/DRM_ECSHPDATE DATS DATS 8   0   Resale shipping date  
61 EC_INV_NO /SAPHT/DRM_ECINVDOC CHAR20 CHAR 20   0   End customer invoice number  
62 EC_INV_ITM /SAPHT/DRM_ECINVITM POSNR NUMC 6   0   Resale invoice item number *
63 EC_INV_DT /SAPHT/DRM_ECINVDATE DATUM DATS 8   0   Resale invoice date  
64 EC_CM_NO /SAPHT/DRM_ECCMDOC CHAR20 CHAR 20   0   End customer return credit memo number  
65 EC_CM_ITM /SAPHT/DRM_ECCMITM POSEX CHAR 6   0   End customer return credit memo item number  
66 LAST_SELLIN_DT /SAPHT/DRM_SELLINDT_RES DATUM DATS 8   0   Last Sell-In date at the time of the Transaction  
67 INT_XMNO /SAPHT/DRM_INTXMNO /SAPHT/DRM_INTXMNO CHAR 20   0   DRM internal transmission number  
68 TRANSM_NO /SAPHT/DRM_TRANSMNO CHAR20 CHAR 20   0   EDI transmission number  
69 EFF_DATE /SAPHT/DRM_EFFDATE DATS DATS 8   0   EDI transmission effective date  
70 STAGDOCNO /SAPHT/DRM_STAGDOCNO BELNR CHAR 10   0   IDOC staging table document number  
71 RESALEPRC /SAPHT/DRM_RESPRC WERTV6 CURR 11   2   Resale price  
72 RESALECURR /SAPHT/DRM_RESCURR WAERS CUKY 5   0   Resale price currency *
73 RESL_PRC_UNIT /SAPHT/DRM_RESPRCUNIT KPEIN DEC 5   0   Pricing quantity for resale price  
74 RESL_PRC_UOM /SAPHT/DRM_RESPRCUOM MEINS UNIT 3   0   Unit of measure for pricing quantity *
75 IDOC_TYPE EDI_MESTYP EDI_MESTYP CHAR 30   0   Message Type *
76 .INCLUDE       0   0   PP Due List Tracking Fields  
77 O_PRIC_UNIT /SAPHT/DRM_OLDPRCUNIT KPEIN DEC 5   0   Old price protectable price pricing unit  
78 O_COND_RATE /SAPHT/DRM_OLDCONDRATE WERTV6 CURR 11   2   Old price protectable price  
79 O_COND_CURR /SAPHT/DRM_OLDCONDCURR WAERS CUKY 5   0   Old price protectable price currency *
80 O_COND_NUMER /SAPHT/DRM_OLDCONDNR UMBSZ DEC 5   0   Nr for converting old PP condition units to base units  
81 O_COND_DENOM /SAPHT/DRM_OLDCONDDR UMBSN DEC 5   0   Dr for converting old PP condition units to base units  
82 O_COND_UOM /SAPHT/DRM_OLD_UOM MEINS UNIT 3   0   Unit of measure for old price protectable price *
83 O_PPTYPE /SAPHT/DRM_OLDPPTYPE /SAPHT/DRM_PPTYPE CHAR 1   0   Old Price Protection Type  
84 PPCLMQTY /SAPHT/DRM_PPCLMQTY MENGV15_3 QUAN 15   3   Price protection claim quantity  
85 PPRVLQTY /SAPHT/DRM_PPRVLQTY MENGV15_3 QUAN 15   3   Lot quantity eligible for revaluation  
86 PPEFFDATE /SAPHT/DRM_PPEFFDATE DATS DATS 8   0   Price protection effective date  
87 PPRUNDATE /SAPHT/DRM_PPRUNDATE DATS DATS 8   0   Price protection run date  
88 PPANNO /SAPHT/DRM_PPANNO CHAR10 CHAR 10   0   Price protection announcement number  
89 PP_CLM_AMOUNT /SAPHT/PPCLAIM_AMOUNT WERTV8 CURR 15   2   Price Protection Claim Amount  
90 CLM_AMOUNT_CURR /SAPHT/PPCLAIM_CURR WAERS CUKY 5   0   PP Claim Amount Currency *
91 LS_PPCLMDOC /SAPHT/DRM_LS_PPCLM LOGSYS CHAR 10   0   Logical system of price protection claim document *
92 PP_SLS_DOCNO /SAPHT/DRM_PPSLSDOCNO VBELN CHAR 10   0   Price protection credit/ debit memo request number *
93 PP_SLS_DOCITM /SAPHT/DRM_PPSLSITMNO POSNR NUMC 6   0   Price protection credit/ debit memo request item number *
94 PP_SLS_DOCQTY /SAPHT/DRM_PP_SLSDOCQTY MENGV15 QUAN 15   3   Price protection qty in the credit/debit memo request  
95 PP_SLS_DOCAMT /SAPHT/DRM_PP_SLSDOCAMT WERTV8 CURR 15   2   Price protection amount in the credit/debit memo request  
96 PP_SLS_DOCCURR /SAPHT/DRM_PP_SLSDOCCURR WAERS CUKY 5   0   Currency of the credit/debit memo request amount *
97 PP_INV_DOCNO /SAPHT/DRM_PPINVDOCNO VBELN CHAR 10   0   Price protection credit/ debit memo number *
98 PP_INV_DOCITM /SAPHT/DRM_PPINVITMNO POSNR NUMC 6   0   Price protection credit/ debit memo item number *
99 PP_INV_DOCQTY /SAPHT/DRM_PP_INVDOCQTY MENGV15 QUAN 15   3   Price protection claim invoiced quantity  
100 PP_INV_DOCAMT /SAPHT/DRM_PP_INVDOCAMT WERTV8 CURR 15   2   Price protection claim invoiced amount  
101 PP_INV_DOCCURR /SAPHT/DRM_PP_INVDOCCURR WAERS CUKY 5   0   Currency for the price protection claim invoced amount *
102 LS_PPRVLDOC /SAPHT/DRM_LS_PPRVL LOGSYS CHAR 10   0   Logical system of price protection revaluation document *
103 PPRVLDOCNO /SAPHT/DRM_PPRVLDOCNO VBELN CHAR 10   0   Price protection revaluation document number *
104 PPRVLDOCYR /SAPHT/DRM_PPRVLDOCYR GJAHR NUMC 4   0   Document year of Revaluation document  
105 PPRVLPOST /SAPHT/DRM_PPRVLPOST POPER NUMC 3   0   Posting period of Revaluation document  
106 PPRECORDNO /SAPHT/DRM_RECORDNO BELNR CHAR 10   0   Price protection due list record number  
107 .INCLUDE       0   0   SD Due List Tracking fields  
108 CLAIMDOCNO /SAPHT/DRM_CLAIMDOCNO BELNR CHAR 10   0   Ship-and-debit claim document number  
109 CUS_REF_FLD /SAPHT/DRM_SDCUSREF /SAPHT/DRM_SDCUSREF CHAR 35   0   Ship-and-debit claim reference number  
110 LS_SD_AGR /SAPHT/DRM_LS_SDAGR LOGSYS CHAR 10   0   Logical system of ship & debit agreement *
111 SD_AGR_NO /SAPHT/DRM_SDAGRNO BELNR CHAR 10   0   Ship-and-debit agreement number  
112 SD_AGR_ITM /SAPHT/DRM_SDAGRITM POSNR NUMC 6   0   Ship-and-debit agreement item number *
113 SD_AGR_RATE /SAPHT/DRM_SDAGRRATE WERTV6 CURR 11   2   Ship-and-debit agreement rate  
114 SD_AGR_CURR /SAPHT/DRM_SDAGRCURR WAERS CUKY 5   0   Ship-and-debit agreement rate currency *
115 SD_PRIC_UNIT /SAPHT/DRM_AGR_PRC_UNIT KPEIN DEC 5   0   Ship-and-debit agreement pricing unit  
116 AGR_CON_NUM /SAPHT/DRM_AGR_COND_NUMER UMBSZ DEC 5   0   Numerator for coversion to base unit  
117 AGR_CON_DEN /SAPHT/DRM_AGR_COND_DENOM UMBSN DEC 5   0   Denominator for conversion to base unit of material  
118 LOT_COND_RATE /SAPHT/DRM_LOTCONDRATE WERTV6 CURR 11   2   PP Rate of the Lot at the time of SD Claim  
119 LOT_COND_CURR /SAPHT/DRM_LOTCONDCURR WAERS CUKY 5   0   PP Curr of the Lot at the time of SD Claim *
120 LOT_PRIC_UNIT /SAPHT/DRM_LOTPRICUNIT KPEIN DEC 5   0   PP Pricing Unit at the time of SD Claim  
121 LOT_COND_NUMER /SAPHT/DRM_LOTCONDNUM UMBSZ DEC 5   0   PP Condition Numerator at the time of SD Claim  
122 LOT_COND_DENOM /SAPHT/DRM_LOTCONDDEN UMBSN DEC 5   0   PP Condition Denominator at the time of SD Claim  
123 LOT_CLAIM_QTY /SAPHT/DRM_LOTCLMQTY MENG15 QUAN 15   3   Lot quantity used in the Claim Calculation  
124 LOT_CLAIM_AMT /SAPHT/DRM_LOTCLMAMT WERTV8 CURR 15   2   Claim Amount for the Lot  
125 LOT_CLAIM_CURR /SAPHT/DRM_LOTCLMCURR WAERS CUKY 5   0   Claim Currency for the Lot *
126 SD_SLS_DOCQTY /SAPHT/DRM_SD_SLSDOCQTY MENGV15 QUAN 15   3   Ship and Debit qty in the credit/debit memo request  
127 SD_SLS_DOCAMT /SAPHT/DRM_SD_SLSDOCAMT WERTV8 CURR 15   2   Ship and Debit amount in the credit/debit memo request  
128 SD_SLS_DOCCURR /SAPHT/DRM_SD_SLSDOCCURR WAERS CUKY 5   0   Currency of the credit/debit memo request amount *
129 SD_INV_DOCQTY /SAPHT/DRM_SD_INVDOCQTY MENGV15 QUAN 15   3   Ship-and-debit invoice document quantity  
130 SD_INV_DOCAMT /SAPHT/DRM_SD_INVDOCAMT WERTV8 CURR 15   2   Amount paid out as ship-and-debit claim  
131 SD_INV_DOCCURR /SAPHT/DRM_SD_INVDOCCURR WAERS CUKY 5   0   Currency for ship-and-debit amount in credit/ debit memo *
132 SD_SLS_DOCNO /SAPHT/DRM_SLSDOC_NO BELNR CHAR 10   0   Credit/ debit memo request number  
133 SD_SLS_DOCITM /SAPHT/DRM_SLSDOC_ITM POSNR NUMC 6   0   Credit/ debit memo request item number *
134 SD_INV_DOCNO /SAPHT/DRM_INVDOC_NO VBELN CHAR 10   0   Credit/ debit memo number *
135 SD_INV_DOCITM /SAPHT/DRM_INVDOC_ITM POSNR NUMC 6   0   Credit/ debit memo item number *
136 .INCLUDE       0   0   Bill up due list tracking fields  
137 BILLUPDLDOCNO /SAPHT/DRM_BILLUP_DL_DOC_NO BELNR CHAR 10   0   Bill-up due list document number  
138 ECRETNQTY /SAPHT/LOT_ECRETNQTY MENG15 QUAN 15   3   Lot Return Quantity used for Bill Up Due List Calculation  
139 BILLUPQTY /SAPHT/DRM_CALCCLAIMQTY MENG15 QUAN 15   3   Calculated bill-up claim quantity  
140 BU_SLS_DOCQTY /SAPHT/DRM_BU_SLSDOCQTY MENGV15 QUAN 15   3   Bill up claim quantity in credit/ debit memo request  
141 BU_INV_DOCQTY /SAPHT/DRM_BU_INVDOCQTY MENGV15 QUAN 15   3   Bill-up claim quantity in credit/ debit memo  
142 BILLUPAMT /SAPHT/DRM_CALCCLAIMAMT WERTV8 CURR 15   2   Calculated claim amount  
143 BILLUPAMTCUR /SAPHT/DRM_CALCCLAIMCUR WAERS CUKY 5   0   Currency for calculated claim amount *
144 BU_SLS_DOCAMT /SAPHT/DRM_BU_SLSDOCAMT WERTV8 CURR 15   2   Bill up claim amount in credit/debit memo request  
145 BU_SLS_DOCCURR /SAPHT/DRM_BU_SLSDOCCURR WAERS CUKY 5   0   Currency of bill-up claim amount in Cr/ Dr memo request *
146 BU_INV_DOCAMT /SAPHT/DRM_BU_INVDOCAMT WERTV8 CURR 15   2   Bill-up claim amount in credit/ debit memo  
147 BU_INV_DOCCURR /SAPHT/DRM_BU_INVDOCCURR WAERS CUKY 5   0   Bill-up credit/ debit memo amount currency *
148 BU_SLS_DOCNO /SAPHT/DRM_SLSDOC_NO BELNR CHAR 10   0   Credit/ debit memo request number  
149 BU_SLS_DOCITM /SAPHT/DRM_SLSDOC_ITM POSNR NUMC 6   0   Credit/ debit memo request item number *
150 BU_INV_DOCNO /SAPHT/DRM_INVDOC_NO VBELN CHAR 10   0   Credit/ debit memo number *
151 BU_INV_DOCITM /SAPHT/DRM_INVDOC_ITM POSNR NUMC 6   0   Credit/ debit memo item number *
152 .INCLUDE       0   0   Cancellation Tracking fields  
153 CANCEL_DOCTYP /SAPHT/DRM_CANDOCTYP /SAPHT/DRM_DOCTYP CHAR 2   0   Cancellation document type  
154 CANCEL_DOCNO /SAPHT/DRM_CANDOCNO XUACCNT CHAR 12   0   Cancellation document number  
155 CANCEL_DOCITM /SAPHT/DRM_CANDOCITM POSNR NUMC 6   0   Cancellation document item number *
156 CANCEL_DOCDATE /SAPHT/DRM_CANDOCDATE DATUM DATS 8   0   Cancellation document date  
157 CANCEL_RUN_DATE /SAPHT/DRMCANCELRUNDATE DATS DATS 8   0   Cancellation run date  
158 CANCEL_IND /SAPHT/DRM_CANCEL_IND /SAPHT/DRM_CANCEL_IND CHAR 1   0   Cancellation indicator for audit trail  
159 CANCEL_INVNO /SAPHT/DRM_CANCINVNO CHAR10 CHAR 10   0   Cancellation invoice number  
160 CANCEL_INVITM /SAPHT/DRM_CANCINVITM POSNR NUMC 6   0   Cancellation Invoice item number *
161 CANCEL_INVDATE /SAPHT/DRM_CANCINVDATE DATUM DATS 8   0   Cancellation invoice date  
162 REJ_REASON ABGRU_VA ABGRU_VA CHAR 2   0   Reason for rejection of quotations and sales orders *
163 .INCLUDE       0   0   DRM Structure for tracking Created By/Changed By...  
164 CREATED_BY ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
165 CREATED_DT /SAPHT/DRM_CRDATE DATUM DATS 8   0   Created on  
166 CREATED_TM C_TIME UZEIT TIMS 6   0   Time created  
167 LASTCHGDBY UPNAM USNAM CHAR 12   0   Last Changed By  
168 LASTCHGDDT AEDAT DATUM DATS 8   0   Last Changed On  
169 CHANGED_TM AS4TIME AS4TIME TIMS 6   0   Last changed at  
170 .INCLUDE       0   0   Addtional Fields to be stored in DRM Transaction tables  
171 DUMMY_1 DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
History
Last changed by/on SAP  20110901 
SAP Release Created in