SAP Table /SAPHT/DRMSTAG - DRM Staging Area

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
STAGDOCNO X /SAPHT/DRM_STAGDOCNO CHAR 3 10 0 IDOC staging table document number
INT_XMNO /SAPHT/DRM_INTXMNO CHAR 13 20 0 DRM internal transmission number
TRANSM_NO /SAPHT/DRM_TRANSMNO CHAR 33 20 0 EDI transmission number
IDOCNO EDI_DOCNUM NUMC 53 16 0 IDoc number
IDOC_TYPE EDI_MESTYP CHAR 69 30 0 Message Type
EFF_DATE /SAPHT/DRM_EFFDATE DATS 99 8 0 EDI transmission effective date
SALES_ORG VKORG CHAR 107 4 0 TVKO Sales Organization
DIST_CHNL VTWEG CHAR 111 2 0 TVTW Distribution Channel
DIVISION SPART CHAR 113 2 0 TSPA Division
TRANSM_DATE /SAPHT/DRM_TRANSMDATE DATS 115 8 0 EDI transmission date
XN_CODE /SAPHT/DRM_XNCODE CHAR 123 20 0 /SAPHT/DRMCXNCD DRM relevant transaction code
EDIXNCODE /SAPHT/DRM_EDIXNCODE CHAR 143 2 0 EDI transaction code
PROC_CODE /SAPHT/DRM_PROCCODE CHAR 145 2 0 DRM relevant processing code
TRACK_PARTNER /SAPHT/DRM_TRACK_PARTNER CHAR 147 10 0 Tracking partner
PARTNER BU_PARTNER CHAR 157 10 0 Business Partner Number
MS_DR_IND /SAPHT/DRM_MSDRIND CHAR 167 1 0 Indicates manufacturer/supplier or distributor/reseller lot
MSBOOKPARTNO /SAPHT/DRM_MSBOOKPARTNO CHAR 168 18 0 MARA Manufacturer book part number
MATERIAL MATNR CHAR 186 18 0 MARA Material Number
DR_MATERIAL /SAPHT/DRM_DR_MATERIAL CHAR 204 35 0 Material as maintained in DRM partner's system
LOTTYPE /SAPHT/DRM_LOTTYPE CHAR 239 1 0 DRM lot type
SELLTHRUQT /SAPHT/DRM_SELLTTHRUQTY QUAN 240 15 3 Reported material quantity in base unit
QTY_UNIT MEINS UNIT 248 3 0 T006 Base Unit of Measure
DR_STQTY /SAPHT/DRM_DRSTQTY QUAN 251 15 3 Quantity as reported by distributor/ reseller
DR_QTY_UNIT /SAPHT/DRM_DRUOM UNIT 259 3 0 T006 Unit of measure for reported quantity
DR_QTY_EDI_UNIT /SAPHT/DRM_ISODRUOM CHAR 262 3 0 Reported Unit of measure in IDoc (ISO Format)
ALT_STQTY /SAPHT/DRM_ALTSTQTY QUAN 265 15 3 Reported quantity in alternative unit
ALT_QTY_UNIT /SAPHT/DRM_ALTUOM UNIT 273 3 0 T006 Alternative unit of measure for reported quantity
SALES_REP BU_PARTNER CHAR 276 10 0 Business Partner Number
END_CUST /SAPHT/DRM_ENDCST CHAR 286 10 0 DRM end customer
DR_END_CUST /SAPHT/DRM_DRENDCST CHAR 296 20 0 Resale customer as reported by distributor/ reseller
EXT_REFNO /SAPHT/DRM_EXT_CUST_REFNO CHAR 316 11 0 Resale customer external reference number
ECPARTFN EDI_3035 CHAR 327 3 0 Qualifier for partner function
IM_END_CUST /SAPHT/DRM_ENDCST CHAR 330 10 0 DRM end customer
DR_IM_END_CUST /SAPHT/DRM_DRENDCST CHAR 340 20 0 Resale customer as reported by distributor/ reseller
IM_EXT_REFNO /SAPHT/DRM_EXT_CUST_REFNO CHAR 360 11 0 Resale customer external reference number
IM_ECPARTFN EDI_3035 CHAR 371 3 0 Qualifier for partner function
EC_INV_NO /SAPHT/DRM_ECINVDOC CHAR 374 20 0 End customer invoice number
EC_INV_ITM /SAPHT/DRM_ECINVITM NUMC 394 6 0 Resale invoice item number
EC_CM_NO /SAPHT/DRM_ECCMDOC CHAR 400 20 0 End customer return credit memo number
EC_CM_ITM /SAPHT/DRM_ECCMITM CHAR 420 6 0 End customer return credit memo item number
RESALEPRC /SAPHT/DRM_RESPRC CURR 426 11 2 Resale price
EDIRESLPRC /SAPHT/DRM_EDIRESPRC CHAR 432 15 0 Reported resale rate in EDI
RESALECURR /SAPHT/DRM_RESCURR CUKY 447 5 0 TCURC Resale price currency
EDIRESLCURR /SAPHT/DRM_EDIRESCURR CHAR 452 3 0 Resale currency in EDI
RESL_PRC_UNIT /SAPHT/DRM_RESPRCUNIT DEC 455 5 0 Pricing quantity for resale price
RESL_PRC_UOM /SAPHT/DRM_RESPRCUOM UNIT 458 3 0 T006 Unit of measure for pricing quantity
EDIRESLPRCUOM /SAPHT/DRM_EDIRESPRCUOM CHAR 461 3 0 Resale unit of measurement in EDI item
RESL_CON_NUM /SAPHT/DRM_RESL_COND_NUMER DEC 464 5 0 Numerator for coversion to base unit
RESL_CON_DEN /SAPHT/DRM_RESL_COND_DENOM DEC 467 5 0 Denominator for conversion to base unit of material
EC_INV_DT /SAPHT/DRM_ECINVDATE DATS 470 8 0 Resale invoice date
EC_SHP_DT /SAPHT/DRM_ECSHPDATE DATS 478 8 0 Resale shipping date
PROC_STATUS /SAPHT/DRM_STAGSTAT CHAR 486 1 0 Processing status of staging record
COST /SAPHT/DRM_INVCOST CURR 487 11 2 Cost price of material
EDICOSTPRC /SAPHT/DRM_EDICSTPRC CHAR 493 15 0 Reported cost price in EDI line item
COST_CURR /SAPHT/DRM_INVCURR CUKY 508 5 0 TCURC Inventory cost currency
EDICOSTCURR /SAPHT/DRM_EDICSTCURR CHAR 513 3 0 Reported cost currency in EDI line item
COST_PRC_UNIT /SAPHT/DRM_INVCOSTUNIT DEC 516 5 0 Inventory pricing unit
PRC_UOM /SAPHT/DRM_INVCOSTUOM UNIT 519 3 0 T006 Unit of measure for inventory cost pricing quantity
EDICOSTPRCUOM /SAPHT/DRM_EDICSTPRCUOM CHAR 522 3 0 Cost Unit of measurement in EDI
COST_CON_NUM /SAPHT/DRM_COST_COND_NUMER DEC 525 5 0 Numerator for coversion to base unit
COST_CON_DEN /SAPHT/DRM_COST_COND_DENOM DEC 528 5 0 Denominator for conversion to base unit of material
INT_BRANCH /SAPHT/DRM_INTBRANCH CHAR 531 10 0 Manufacturer/ supplier's code for reseller unit
BRANCH /SAPHT/DRM_BRANCH CHAR 541 20 0 Distributor/ reseller's code for reseller unit
STOCK_LOC /SAPHT/DRM_STLOC CHAR 561 10 0 Stocking location
LOGHANDLE BALLOGHNDL CHAR 571 22 0 Application Log: Log Handle
ERRORCODE /SAPHT/DRM_ERROR_CODE CHAR 593 100 0 Error Code for storing errors in a record
REROUTEFLAG /SAPHT/DRM_RERTFLAG CHAR 693 1 0 Reroute flag
ENDCSTADRNO AD_ADDRNUM CHAR 694 10 0 Address number
IM_ENDCSTADRNO AD_ADDRNUM CHAR 704 10 0 Address number
BRADRNO AD_ADDRNUM CHAR 714 10 0 Address number
TRANS_DATE /SAPHT/DRM_XNDT DATS 724 8 0 Reported date
VAL_MNCUR VAL_MNCUR CURR 732 15 2 Sum of values in the transmission in main currency
MN_CURR MAIN_CURR CUKY 740 5 0 TCURC Manufacturer/ supplier's currency
CUS_REF_FLD /SAPHT/DRM_SDCUSREF CHAR 745 35 0 Ship-and-debit claim reference number
SD_AGR_NO /SAPHT/DRM_SDAGRNO CHAR 780 10 0 Ship-and-debit agreement number
SD_AGR_ITM /SAPHT/DRM_SDAGRITM NUMC 790 6 0 Ship-and-debit agreement item number
SD_AGR_RATE /SAPHT/DRM_SDAGRRATE CURR 796 11 2 Ship-and-debit agreement rate
SD_AGR_CURR /SAPHT/DRM_SDAGRCURR CUKY 802 5 0 TCURC Ship-and-debit agreement rate currency
PRIC_UNIT /SAPHT/DRM_AGR_PRC_UNIT DEC 807 5 0 Ship-and-debit agreement pricing unit
SD_AGR_UOM /SAPHT/DRM_SDAGRCUOM UNIT 810 3 0 T006 Unit of measure for SD Agreement
AGRM_CON_NUM /SAPHT/DRM_AGR_COND_NUMER DEC 813 5 0 Numerator for coversion to base unit
AGRM_CON_DEN /SAPHT/DRM_AGR_COND_DENOM DEC 816 5 0 Denominator for conversion to base unit of material
REP_AGR_RATE /SAPHT/DRM_REPAGRRATE CURR 819 11 2 Ship-and-debit agreement rate reported by distributor
EDI_AGR_RATE /SAPHT/DRM_EDIAGRRATE CHAR 825 15 0 Reported agreement rate in EDI
REP_AGR_CURR /SAPHT/DRM_REPAGRCURR CUKY 840 5 0 TCURC Currency of reported ship-and-debit agreement rate
EDI_AGR_CURR /SAPHT/DRM_EDIAGRCURR CHAR 845 3 0 Agreement currency in EDI
REP_PRIC_UNIT /SAPHT/DRM_REPPRICUNIT DEC 848 5 0 Pricing unit for reported ship-and-debit agreement price
REP_PRC_UOM /SAPHT/DRM_REPPRICUOM UNIT 851 3 0 T006 Unit of measure for pricing quantity
EDI_PRC_UOM /SAPHT/DRM_EDIPRICUOM CHAR 854 3 0 Reported agreement unit of measure in EDI
AGR_CON_NUM /SAPHT/DRM_AGR_COND_NUMER DEC 857 5 0 Numerator for coversion to base unit
AGR_CON_DEN /SAPHT/DRM_AGR_COND_DENOM DEC 860 5 0 Denominator for conversion to base unit of material
REP_CLAIM_AMOUNT /SAPHT/DRM_REPCLAIMAMT CURR 863 15 2 Reported ship-and-debit claim amount
EDI_CLAIM_AMOUNT /SAPHT/DRM_EDICLAIMAMT CHAR 871 18 0 Reported claim amount in EDI
REP_CLAIM_CURR /SAPHT/DRM_REPCLAIMCURR CUKY 889 5 0 TCURC Reported ship-and-debit claim amount currency
EDI_CLAIM_CURR /SAPHT/DRM_EDICLAIMCURR CHAR 894 3 0 Claim currency in EDI
INV_DOCNO /SAPHT/DRM_INVDOC_NO CHAR 897 10 0 Credit/ debit memo number
INV_DOCITM /SAPHT/DRM_INVDOC_ITM NUMC 907 6 0 Credit/ debit memo item number
RES_IDOCNO /SAPHT/DRM_RERT_IDOCNO NUMC 913 16 0 Response IDoc number
DESIGN_REG_NO /SAPHT/DRM_DESIGN_REG_NO CHAR 929 30 0 Design registration number
CREATED_BY ERNAM CHAR 959 12 0 Name of Person who Created the Object
CREATED_DT /SAPHT/DRM_CRDATE DATS 971 8 0 Created on
CREATED_TM C_TIME TIMS 979 6 0 Time created
LASTCHGDBY UPNAM CHAR 985 12 0 Last Changed By
LASTCHGDDT AEDAT DATS 997 8 0 Changed On
CHANGED_TM AS4TIME TIMS 1005 6 0 Last changed at
DUMMY_1 DUMMY CHAR 1011 1 0 Dummy function in length 1