SAP Table /SAPHT/DRMDETL - DRM Audit Trail

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
LOTNO X /SAPHT/DRM_LOTNO CHAR 3 10 0 DRM lot number
AUDITNO X /SAPHT/DRM_AUDITM NUMC 13 6 0 Total number of audit trails for DRM lot
RUNNUMBER /SAPHT/DRM_RUNNUMBER CHAR 19 30 0 run no. for fifo rollback.
CHANGE_DOCQTY /SAPHT/DRM_CHMDOCQT QUAN 49 15 3 Change in the material document quantity
CHANGE_INVQTY /SAPHT/DRM_CHIVQT QUAN 57 15 3 Change in the invoiced quantity
CHANGE_AVLQTY /SAPHT/DRM_CHAVQT QUAN 65 15 3 Change in DRM lot available quantity
CHANGE_STQTY /SAPHT/DRM_CHSTQT QUAN 73 15 3 Change in sell-through quantity
CHANGE_PIQTY /SAPHT/DRM_CHPIQT QUAN 81 15 3 Change in material quantity issued to production
CHANGE_ECRQTY /SAPHT/DRM_ECRETQTY QUAN 89 15 3 Change in resale return quantity
CHANGE_MSRQTY /SAPHT/DRM_MSRQTY QUAN 97 15 3 Change in quantity returned by distributor/ reseller
CHANGE_DSQTY /SAPHT/DRM_DSSIQTY QUAN 105 15 3 Change in Drop-Ship Sell-In qty
QTY_UNIT MEINS UNIT 113 3 0 T006 Base Unit of Measure
XN_DATE /SAPHT/DRM_XN_DATE DATS 116 8 0 Lot data modification effective date
XN_CODE /SAPHT/DRM_XNCODE CHAR 124 20 0 /SAPHT/DRMCXNCD DRM relevant transaction code
PROC_CODE /SAPHT/DRM_PROCCODE CHAR 144 2 0 DRM relevant processing code
INVNO /SAPHT/DRM_INVNO CHAR 146 10 0 Inventory record number
IDOCNO EDI_DOCNUM NUMC 156 16 0 IDoc number
COLL_RUN_NO /SAPHT/DRMCOLLRUNNO CHAR 172 10 0 DRM collective processing number
TRANS_DATE /SAPHT/DRM_XNDT DATS 182 8 0 Reported date
STEXT /SAPHT/DRM_STEXT CHAR 190 10 0 Short text for audit trail modification
LTEXT /SAPHT/DRM_LTEXT CHAR 200 40 0 Long text for audit trail modification
LS_REF_DOC_NO /SAPHT/DRM_LS_REFDOCNO CHAR 240 10 0 Logical system of reference document
REF_DOC_TYP /SAPHT/DRM_RFDOCTYP CHAR 250 2 0 Reference document type
REF_DOC_NO /SAPHT/DRM_RFDOCNO CHAR 252 12 0 Reference document number
REF_DOC_ITM /SAPHT/DRM_RFDOCITM NUMC 264 6 0 Reference document item number
PO_ORDER_TYPE ESART CHAR 270 4 0 T161 Purchasing Document Type
PRODORD_NO /SAPHT/DRM_PRODNO CHAR 274 12 0 Production order number
SELLIN_DN_NO VBELN_VL CHAR 286 10 0 Delivery
SELLIN_DN_ITM POSNR_VL NUMC 296 6 0 Delivery Item
MATDOCNO /SAPHT/DRM_MATDOCNO CHAR 302 10 0 Goods Issue/ Goods receipt number
MATDOCITEM /SAPHT/DRM_MATDCITM NUMC 312 6 0 Goods Issue/ Goods receipt item number
MATDOCYR /SAPHT/DRM_MATDOCYR NUMC 318 4 0 Goods Issue/ Goods receipt document year
MATDOCDATE /SAPHT/DRM_MATDOCDT DATS 322 8 0 Sell-in goods issue/ receipt document date
INVDOCNO /SAPHT/DRM_INVDOCNO CHAR 330 10 0 Sell-in invoice/ invoice receipt document number
INVDOCITM /SAPHT/DRM_INVDOCITM NUMC 340 6 0 Sell-In invoice/ invoice receipt document item number
INVDOCYR /SAPHT/DRM_INVDOCYR NUMC 346 4 0 Fiscal year
COMP_CODE BUKRS CHAR 350 4 0 T001 Company Code
INV_DOC_TYPE FKART CHAR 354 4 0 Billing Type
INVDATE /SAPHT/DRM_INVDOCDT DATS 358 8 0 Sell-in invoice date
PRIC_UNIT /SAPHT/DRM_PRCUNIT DEC 366 5 0 Pricing unit for price protectable price
COND_RATE /SAPHT/DRM_COND_RATE CURR 369 11 2 Price protectable price condition rate
COND_CURR /SAPHT/DRM_COND_CURR CUKY 375 5 0 TCURC Price protectable price currency
COND_NUMER /SAPHT/DRM_COND_NUMERATOR DEC 380 5 0 Numerator for converting price protectable price
COND_DENOM /SAPHT/DRM_COND_DENOM DEC 383 5 0 Denominator for conversion to base unit
COND_UOM /SAPHT/DRM_PRIC_UOM UNIT 386 3 0 T006 Pricing unit of measure
END_CUST /SAPHT/DRM_ENDCST CHAR 389 10 0 DRM end customer
TRACK_PARTNER /SAPHT/DRM_TRACK_PARTNER CHAR 399 10 0 Tracking partner
MSBOOKPARTNO /SAPHT/DRM_MSBOOKPART CHAR 409 18 0 MARA Manufacturer Book Part Number
PARTNER BU_PARTNER CHAR 427 10 0 Business Partner Number
MATERIAL MATNR CHAR 437 18 0 MARA Material Number
SALES_REP BU_PARTNER CHAR 455 10 0 Business Partner Number
LS_EC_SO /SAPHT/DRM_LS_ECSO CHAR 465 10 0 Logical system of end customer sales order
EC_ORDR_NO /SAPHT/DRM_ECSONO CHAR 475 10 0 End customer sales order number
EC_ORDR_ITM /SAPHT/DRM_ECSOITM NUMC 485 6 0 End customer sales order item number
EC_DN_NO VBELN_VL CHAR 491 10 0 Delivery
EC_DN_ITEM POSNR_VL NUMC 501 6 0 Delivery Item
EC_SHP_DT /SAPHT/DRM_ECSHPDATE DATS 507 8 0 Resale shipping date
EC_INV_NO /SAPHT/DRM_ECINVDOC CHAR 515 20 0 End customer invoice number
EC_INV_ITM /SAPHT/DRM_ECINVITM NUMC 535 6 0 Resale invoice item number
EC_INV_DT /SAPHT/DRM_ECINVDATE DATS 541 8 0 Resale invoice date
EC_CM_NO /SAPHT/DRM_ECCMDOC CHAR 549 20 0 End customer return credit memo number
EC_CM_ITM /SAPHT/DRM_ECCMITM CHAR 569 6 0 End customer return credit memo item number
LAST_SELLIN_DT /SAPHT/DRM_SELLINDT_RES DATS 575 8 0 Last Sell-In date at the time of the Transaction
INT_XMNO /SAPHT/DRM_INTXMNO CHAR 583 20 0 DRM internal transmission number
TRANSM_NO /SAPHT/DRM_TRANSMNO CHAR 603 20 0 EDI transmission number
EFF_DATE /SAPHT/DRM_EFFDATE DATS 623 8 0 EDI transmission effective date
STAGDOCNO /SAPHT/DRM_STAGDOCNO CHAR 631 10 0 IDOC staging table document number
RESALEPRC /SAPHT/DRM_RESPRC CURR 641 11 2 Resale price
RESALECURR /SAPHT/DRM_RESCURR CUKY 647 5 0 TCURC Resale price currency
RESL_PRC_UNIT /SAPHT/DRM_RESPRCUNIT DEC 652 5 0 Pricing quantity for resale price
RESL_PRC_UOM /SAPHT/DRM_RESPRCUOM UNIT 655 3 0 T006 Unit of measure for pricing quantity
IDOC_TYPE EDI_MESTYP CHAR 658 30 0 Message Type
O_PRIC_UNIT /SAPHT/DRM_OLDPRCUNIT DEC 688 5 0 Old price protectable price pricing unit
O_COND_RATE /SAPHT/DRM_OLDCONDRATE CURR 691 11 2 Old price protectable price
O_COND_CURR /SAPHT/DRM_OLDCONDCURR CUKY 697 5 0 TCURC Old price protectable price currency
O_COND_NUMER /SAPHT/DRM_OLDCONDNR DEC 702 5 0 Nr for converting old PP condition units to base units
O_COND_DENOM /SAPHT/DRM_OLDCONDDR DEC 705 5 0 Dr for converting old PP condition units to base units
O_COND_UOM /SAPHT/DRM_OLD_UOM UNIT 708 3 0 T006 Unit of measure for old price protectable price
O_PPTYPE /SAPHT/DRM_OLDPPTYPE CHAR 711 1 0 Old Price Protection Type
PPCLMQTY /SAPHT/DRM_PPCLMQTY QUAN 712 15 3 Price protection claim quantity
PPRVLQTY /SAPHT/DRM_PPRVLQTY QUAN 720 15 3 Lot quantity eligible for revaluation
PPEFFDATE /SAPHT/DRM_PPEFFDATE DATS 728 8 0 Price protection effective date
PPRUNDATE /SAPHT/DRM_PPRUNDATE DATS 736 8 0 Price protection run date
PPANNO /SAPHT/DRM_PPANNO CHAR 744 10 0 Price protection announcement number
PP_CLM_AMOUNT /SAPHT/PPCLAIM_AMOUNT CURR 754 15 2 Price Protection Claim Amount
CLM_AMOUNT_CURR /SAPHT/PPCLAIM_CURR CUKY 762 5 0 TCURC PP Claim Amount Currency
LS_PPCLMDOC /SAPHT/DRM_LS_PPCLM CHAR 767 10 0 Logical system of price protection claim document
PP_SLS_DOCNO /SAPHT/DRM_PPSLSDOCNO CHAR 777 10 0 Price protection credit/ debit memo request number
PP_SLS_DOCITM /SAPHT/DRM_PPSLSITMNO NUMC 787 6 0 Price protection credit/ debit memo request item number
PP_SLS_DOCQTY /SAPHT/DRM_PP_SLSDOCQTY QUAN 793 15 3 Price protection qty in the credit/debit memo request
PP_SLS_DOCAMT /SAPHT/DRM_PP_SLSDOCAMT CURR 801 15 2 Price protection amount in the credit/debit memo request
PP_SLS_DOCCURR /SAPHT/DRM_PP_SLSDOCCURR CUKY 809 5 0 TCURC Currency of the credit/debit memo request amount
PP_INV_DOCNO /SAPHT/DRM_PPINVDOCNO CHAR 814 10 0 Price protection credit/ debit memo number
PP_INV_DOCITM /SAPHT/DRM_PPINVITMNO NUMC 824 6 0 Price protection credit/ debit memo item number
PP_INV_DOCQTY /SAPHT/DRM_PP_INVDOCQTY QUAN 830 15 3 Price protection claim invoiced quantity
PP_INV_DOCAMT /SAPHT/DRM_PP_INVDOCAMT CURR 838 15 2 Price protection claim invoiced amount
PP_INV_DOCCURR /SAPHT/DRM_PP_INVDOCCURR CUKY 846 5 0 TCURC Currency for the price protection claim invoced amount
LS_PPRVLDOC /SAPHT/DRM_LS_PPRVL CHAR 851 10 0 Logical system of price protection revaluation document
PPRVLDOCNO /SAPHT/DRM_PPRVLDOCNO CHAR 861 10 0 Price protection revaluation document number
PPRVLDOCYR /SAPHT/DRM_PPRVLDOCYR NUMC 871 4 0 Document year of Revaluation document
PPRVLPOST /SAPHT/DRM_PPRVLPOST NUMC 875 3 0 Posting period of Revaluation document
PPRECORDNO /SAPHT/DRM_RECORDNO CHAR 878 10 0 Price protection due list record number
CLAIMDOCNO /SAPHT/DRM_CLAIMDOCNO CHAR 888 10 0 Ship-and-debit claim document number
CUS_REF_FLD /SAPHT/DRM_SDCUSREF CHAR 898 35 0 Ship-and-debit claim reference number
LS_SD_AGR /SAPHT/DRM_LS_SDAGR CHAR 933 10 0 Logical system of ship & debit agreement
SD_AGR_NO /SAPHT/DRM_SDAGRNO CHAR 943 10 0 Ship-and-debit agreement number
SD_AGR_ITM /SAPHT/DRM_SDAGRITM NUMC 953 6 0 Ship-and-debit agreement item number
SD_AGR_RATE /SAPHT/DRM_SDAGRRATE CURR 959 11 2 Ship-and-debit agreement rate
SD_AGR_CURR /SAPHT/DRM_SDAGRCURR CUKY 965 5 0 TCURC Ship-and-debit agreement rate currency
SD_PRIC_UNIT /SAPHT/DRM_AGR_PRC_UNIT DEC 970 5 0 Ship-and-debit agreement pricing unit
AGR_CON_NUM /SAPHT/DRM_AGR_COND_NUMER DEC 973 5 0 Numerator for coversion to base unit
AGR_CON_DEN /SAPHT/DRM_AGR_COND_DENOM DEC 976 5 0 Denominator for conversion to base unit of material
LOT_COND_RATE /SAPHT/DRM_LOTCONDRATE CURR 979 11 2 PP Rate of the Lot at the time of SD Claim
LOT_COND_CURR /SAPHT/DRM_LOTCONDCURR CUKY 985 5 0 TCURC PP Curr of the Lot at the time of SD Claim
LOT_PRIC_UNIT /SAPHT/DRM_LOTPRICUNIT DEC 990 5 0 PP Pricing Unit at the time of SD Claim
LOT_COND_NUMER /SAPHT/DRM_LOTCONDNUM DEC 993 5 0 PP Condition Numerator at the time of SD Claim
LOT_COND_DENOM /SAPHT/DRM_LOTCONDDEN DEC 996 5 0 PP Condition Denominator at the time of SD Claim
LOT_CLAIM_QTY /SAPHT/DRM_LOTCLMQTY QUAN 999 15 3 Lot quantity used in the Claim Calculation
LOT_CLAIM_AMT /SAPHT/DRM_LOTCLMAMT CURR 1007 15 2 Claim Amount for the Lot
LOT_CLAIM_CURR /SAPHT/DRM_LOTCLMCURR CUKY 1015 5 0 TCURC Claim Currency for the Lot
SD_SLS_DOCQTY /SAPHT/DRM_SD_SLSDOCQTY QUAN 1020 15 3 Ship and Debit qty in the credit/debit memo request
SD_SLS_DOCAMT /SAPHT/DRM_SD_SLSDOCAMT CURR 1028 15 2 Ship and Debit amount in the credit/debit memo request
SD_SLS_DOCCURR /SAPHT/DRM_SD_SLSDOCCURR CUKY 1036 5 0 TCURC Currency of the credit/debit memo request amount
SD_INV_DOCQTY /SAPHT/DRM_SD_INVDOCQTY QUAN 1041 15 3 Ship-and-debit invoice document quantity
SD_INV_DOCAMT /SAPHT/DRM_SD_INVDOCAMT CURR 1049 15 2 Amount paid out as ship-and-debit claim
SD_INV_DOCCURR /SAPHT/DRM_SD_INVDOCCURR CUKY 1057 5 0 TCURC Currency for ship-and-debit amount in credit/ debit memo
SD_SLS_DOCNO /SAPHT/DRM_SLSDOC_NO CHAR 1062 10 0 Credit/ debit memo request number
SD_SLS_DOCITM /SAPHT/DRM_SLSDOC_ITM NUMC 1072 6 0 Credit/ debit memo request item number
SD_INV_DOCNO /SAPHT/DRM_INVDOC_NO CHAR 1078 10 0 Credit/ debit memo number
SD_INV_DOCITM /SAPHT/DRM_INVDOC_ITM NUMC 1088 6 0 Credit/ debit memo item number
BILLUPDLDOCNO /SAPHT/DRM_BILLUP_DL_DOC_NO CHAR 1094 10 0 Bill-up due list document number
ECRETNQTY /SAPHT/LOT_ECRETNQTY QUAN 1104 15 3 Lot Return Quantity used for Bill Up Due List Calculation
BILLUPQTY /SAPHT/DRM_CALCCLAIMQTY QUAN 1112 15 3 Calculated bill-up claim quantity
BU_SLS_DOCQTY /SAPHT/DRM_BU_SLSDOCQTY QUAN 1120 15 3 Bill up claim quantity in credit/ debit memo request
BU_INV_DOCQTY /SAPHT/DRM_BU_INVDOCQTY QUAN 1128 15 3 Bill-up claim quantity in credit/ debit memo
BILLUPAMT /SAPHT/DRM_CALCCLAIMAMT CURR 1136 15 2 Calculated claim amount
BILLUPAMTCUR /SAPHT/DRM_CALCCLAIMCUR CUKY 1144 5 0 TCURC Currency for calculated claim amount
BU_SLS_DOCAMT /SAPHT/DRM_BU_SLSDOCAMT CURR 1149 15 2 Bill up claim amount in credit/debit memo request
BU_SLS_DOCCURR /SAPHT/DRM_BU_SLSDOCCURR CUKY 1157 5 0 TCURC Currency of bill-up claim amount in Cr/ Dr memo request
BU_INV_DOCAMT /SAPHT/DRM_BU_INVDOCAMT CURR 1162 15 2 Bill-up claim amount in credit/ debit memo
BU_INV_DOCCURR /SAPHT/DRM_BU_INVDOCCURR CUKY 1170 5 0 TCURC Bill-up credit/ debit memo amount currency
BU_SLS_DOCNO /SAPHT/DRM_SLSDOC_NO CHAR 1175 10 0 Credit/ debit memo request number
BU_SLS_DOCITM /SAPHT/DRM_SLSDOC_ITM NUMC 1185 6 0 Credit/ debit memo request item number
BU_INV_DOCNO /SAPHT/DRM_INVDOC_NO CHAR 1191 10 0 Credit/ debit memo number
BU_INV_DOCITM /SAPHT/DRM_INVDOC_ITM NUMC 1201 6 0 Credit/ debit memo item number
CANCEL_DOCTYP /SAPHT/DRM_CANDOCTYP CHAR 1207 2 0 Cancellation document type
CANCEL_DOCNO /SAPHT/DRM_CANDOCNO CHAR 1209 12 0 Cancellation document number
CANCEL_DOCITM /SAPHT/DRM_CANDOCITM NUMC 1221 6 0 Cancellation document item number
CANCEL_DOCDATE /SAPHT/DRM_CANDOCDATE DATS 1227 8 0 Cancellation document date
CANCEL_RUN_DATE /SAPHT/DRMCANCELRUNDATE DATS 1235 8 0 Cancellation run date
CANCEL_IND /SAPHT/DRM_CANCEL_IND CHAR 1243 1 0 Cancellation indicator for audit trail
CANCEL_INVNO /SAPHT/DRM_CANCINVNO CHAR 1244 10 0 Cancellation invoice number
CANCEL_INVITM /SAPHT/DRM_CANCINVITM NUMC 1254 6 0 Cancellation Invoice item number
CANCEL_INVDATE /SAPHT/DRM_CANCINVDATE DATS 1260 8 0 Cancellation invoice date
REJ_REASON ABGRU_VA CHAR 1268 2 0 TVAG Reason for rejection of quotations and sales orders
CREATED_BY ERNAM CHAR 1270 12 0 Name of Person who Created the Object
CREATED_DT /SAPHT/DRM_CRDATE DATS 1282 8 0 Created on
CREATED_TM C_TIME TIMS 1290 6 0 Time created
LASTCHGDBY UPNAM CHAR 1296 12 0 Last Changed By
LASTCHGDDT AEDAT DATS 1308 8 0 Changed On
CHANGED_TM AS4TIME TIMS 1316 6 0 Last changed at
DUMMY_1 DUMMY CHAR 1322 1 0 Dummy function in length 1