/SAPHT/DRMSTAG SAP (DRM Staging Area) Table details
Dictionary Type: Table
Description: DRM Staging Area
Description: DRM Staging Area
ABAP Code to SELECT data from /SAPHT/DRMSTAG
Related tables to /SAPHT/DRMSTAG
Access table /SAPHT/DRMSTAG
Related tables to /SAPHT/DRMSTAG
Access table /SAPHT/DRMSTAG
Table field list including key, data, relationships and ABAP select examples
/SAPHT/DRMSTAG is a standard SAP Table which is used to store DRM Staging Area data and is available within R/3 SAP systems depending on the version and release level.
The /SAPHT/DRMSTAG table consists of various fields, each holding specific information or linking keys about DRM Staging Area data available in SAP. These include STAGDOCNO (IDOC staging table document number), INT_XMNO (DRM internal transmission number), TRANSM_NO (EDI transmission number), IDOCNO (IDoc number).. 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/DRMSTAG 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 | |||
STAGDOCNO | IDOC staging table document number | /SAPHT/DRM_STAGDOCNO | CHAR | 10 | ALPHA | BELNR | |||
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 | |||
IDOCNO | IDoc number | EDI_DOCNUM | NUMC | 16 | EDI_DOCNUM | DCN | |||
IDOC_TYPE | Message Type | EDI_MESTYP | CHAR | 30 | Assigned to domain | EDI_MESTYP | MES | ||
EFF_DATE | EDI transmission effective date | /SAPHT/DRM_EFFDATE | DATS | 8 | DATS | ||||
SALES_ORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
DIST_CHNL | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
DIVISION | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
TRANSM_DATE | EDI transmission date | /SAPHT/DRM_TRANSMDATE | DATS | 8 | DATS | ||||
XN_CODE | DRM relevant transaction code | /SAPHT/DRM_XNCODE | CHAR | 20 | Assigned to domain | /SAPHT/DRM_XNCODE | /SAPHT/DRMHXN_CODE | ||
EDIXNCODE | EDI transaction code | /SAPHT/DRM_EDIXNCODE | CHAR | 2 | /SAPHT/DRM_EDIXNCODE | ||||
PROC_CODE | DRM relevant processing code | /SAPHT/DRM_PROCCODE | CHAR | 2 | /SAPHT/DRM_PROCCODE | ||||
TRACK_PARTNER | Tracking partner | /SAPHT/DRM_TRACK_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | /SAPHT/DRM_MSDRIND | CHAR | 1 | /SAPHT/DRM_MSDRIND | ||||
MSBOOKPARTNO | Manufacturer book part number | /SAPHT/DRM_MSBOOKPARTNO | CHAR | 18 | Assigned to domain | MATN1 | MATNR | /SAPHT/DRM_MSBOOKPRT | MAT1 |
MATERIAL | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
DR_MATERIAL | Material as maintained in DRM partner's system | /SAPHT/DRM_DR_MATERIAL | CHAR | 35 | IDNEX | ||||
LOTTYPE | DRM lot type | /SAPHT/DRM_LOTTYPE | CHAR | 1 | /SAPHT/DRM_LOTTYPE | ||||
SELLTHRUQT | Reported material quantity in base unit | /SAPHT/DRM_SELLTTHRUQTY | QUAN | 15(3) | MENGV15_3 | ||||
QTY_UNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DR_STQTY | Quantity as reported by distributor/ reseller | /SAPHT/DRM_DRSTQTY | QUAN | 15(3) | MENGV15_3 | ||||
DR_QTY_UNIT | Unit of measure for reported quantity | /SAPHT/DRM_DRUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DR_QTY_EDI_UNIT | Reported Unit of measure in IDoc (ISO Format) | /SAPHT/DRM_ISODRUOM | CHAR | 3 | CHAR3 | ||||
ALT_STQTY | Reported quantity in alternative unit | /SAPHT/DRM_ALTSTQTY | QUAN | 15(3) | MENGV15_3 | ||||
ALT_QTY_UNIT | Alternative unit of measure for reported quantity | /SAPHT/DRM_ALTUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SALES_REP | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
END_CUST | DRM end customer | /SAPHT/DRM_ENDCST | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | DEBI | |
DR_END_CUST | Resale customer as reported by distributor/ reseller | /SAPHT/DRM_DRENDCST | CHAR | 20 | CHAR20 | ||||
EXT_REFNO | Resale customer external reference number | /SAPHT/DRM_EXT_CUST_REFNO | CHAR | 11 | CHAR11 | ||||
ECPARTFN | Qualifier for partner function | EDI_3035 | CHAR | 3 | EDI_3035 | ||||
IM_END_CUST | DRM end customer | /SAPHT/DRM_ENDCST | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | DEBI | |
DR_IM_END_CUST | Resale customer as reported by distributor/ reseller | /SAPHT/DRM_DRENDCST | CHAR | 20 | CHAR20 | ||||
IM_EXT_REFNO | Resale customer external reference number | /SAPHT/DRM_EXT_CUST_REFNO | CHAR | 11 | CHAR11 | ||||
IM_ECPARTFN | Qualifier for partner function | EDI_3035 | CHAR | 3 | EDI_3035 | ||||
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_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 | |||
RESALEPRC | Resale price | /SAPHT/DRM_RESPRC | CURR | 11(2) | WERTV6 | ||||
EDIRESLPRC | Reported resale rate in EDI | /SAPHT/DRM_EDIRESPRC | CHAR | 15 | EDIF5420 | ||||
RESALECURR | Resale price currency | /SAPHT/DRM_RESCURR | CUKY | 5 | Assigned to domain | WAERS | |||
EDIRESLCURR | Resale currency in EDI | /SAPHT/DRM_EDIRESCURR | CHAR | 3 | EDIF6345 | ||||
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 | ||
EDIRESLPRCUOM | Resale unit of measurement in EDI item | /SAPHT/DRM_EDIRESPRCUOM | CHAR | 3 | EDIF6411 | ||||
RESL_CON_NUM | Numerator for coversion to base unit | /SAPHT/DRM_RESL_COND_NUMER | DEC | 5 | UMBSZ | ||||
RESL_CON_DEN | Denominator for conversion to base unit of material | /SAPHT/DRM_RESL_COND_DENOM | DEC | 5 | UMBSN | ||||
EC_INV_DT | Resale invoice date | /SAPHT/DRM_ECINVDATE | DATS | 8 | DATUM | ||||
EC_SHP_DT | Resale shipping date | /SAPHT/DRM_ECSHPDATE | DATS | 8 | DATS | ||||
PROC_STATUS | Processing status of staging record | /SAPHT/DRM_STAGSTAT | CHAR | 1 | /SAPHT/DRM_STAGSTAT | ||||
COST | Cost price of material | /SAPHT/DRM_INVCOST | CURR | 11(2) | WERTV6 | ||||
EDICOSTPRC | Reported cost price in EDI line item | /SAPHT/DRM_EDICSTPRC | CHAR | 15 | EDIF5420 | ||||
COST_CURR | Inventory cost currency | /SAPHT/DRM_INVCURR | CUKY | 5 | Assigned to domain | WAERS | |||
EDICOSTCURR | Reported cost currency in EDI line item | /SAPHT/DRM_EDICSTCURR | CHAR | 3 | EDIF6345 | ||||
COST_PRC_UNIT | Inventory pricing unit | /SAPHT/DRM_INVCOSTUNIT | DEC | 5 | KPEIN | ||||
PRC_UOM | Unit of measure for inventory cost pricing quantity | /SAPHT/DRM_INVCOSTUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EDICOSTPRCUOM | Cost Unit of measurement in EDI | /SAPHT/DRM_EDICSTPRCUOM | CHAR | 3 | EDIF6411 | ||||
COST_CON_NUM | Numerator for coversion to base unit | /SAPHT/DRM_COST_COND_NUMER | DEC | 5 | UMBSZ | ||||
COST_CON_DEN | Denominator for conversion to base unit of material | /SAPHT/DRM_COST_COND_DENOM | DEC | 5 | UMBSN | ||||
INT_BRANCH | Manufacturer/ supplier's code for reseller unit | /SAPHT/DRM_INTBRANCH | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | DEBI | |
BRANCH | Distributor/ reseller's code for reseller unit | /SAPHT/DRM_BRANCH | CHAR | 20 | CHAR20 | ||||
STOCK_LOC | Stocking location | /SAPHT/DRM_STLOC | CHAR | 10 | CHAR10 | ||||
LOGHANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 | ||||
ERRORCODE | Error Code for storing errors in a record | /SAPHT/DRM_ERROR_CODE | CHAR | 100 | CHAR100 | ||||
REROUTEFLAG | Reroute flag | /SAPHT/DRM_RERTFLAG | CHAR | 1 | FLAG | ||||
ENDCSTADRNO | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
IM_ENDCSTADRNO | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
BRADRNO | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
TRANS_DATE | Reported date | /SAPHT/DRM_XNDT | DATS | 8 | DATS | ||||
VAL_MNCUR | Sum of values in the transmission in main currency | VAL_MNCUR | CURR | 15(2) | WERTV8 | ||||
MN_CURR | Manufacturer/ supplier's currency | MAIN_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
CUS_REF_FLD | Ship-and-debit claim reference number | /SAPHT/DRM_SDCUSREF | CHAR | 35 | /SAPHT/DRM_SDCUSREF | ||||
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 | |||
PRIC_UNIT | Ship-and-debit agreement pricing unit | /SAPHT/DRM_AGR_PRC_UNIT | DEC | 5 | KPEIN | ||||
SD_AGR_UOM | Unit of measure for SD Agreement | /SAPHT/DRM_SDAGRCUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
AGRM_CON_NUM | Numerator for coversion to base unit | /SAPHT/DRM_AGR_COND_NUMER | DEC | 5 | UMBSZ | ||||
AGRM_CON_DEN | Denominator for conversion to base unit of material | /SAPHT/DRM_AGR_COND_DENOM | DEC | 5 | UMBSN | ||||
REP_AGR_RATE | Ship-and-debit agreement rate reported by distributor | /SAPHT/DRM_REPAGRRATE | CURR | 11(2) | WERTV6 | ||||
EDI_AGR_RATE | Reported agreement rate in EDI | /SAPHT/DRM_EDIAGRRATE | CHAR | 15 | EDIF5420 | ||||
REP_AGR_CURR | Currency of reported ship-and-debit agreement rate | /SAPHT/DRM_REPAGRCURR | CUKY | 5 | Assigned to domain | WAERS | |||
EDI_AGR_CURR | Agreement currency in EDI | /SAPHT/DRM_EDIAGRCURR | CHAR | 3 | EDIF6345 | ||||
REP_PRIC_UNIT | Pricing unit for reported ship-and-debit agreement price | /SAPHT/DRM_REPPRICUNIT | DEC | 5 | KPEIN | ||||
REP_PRC_UOM | Unit of measure for pricing quantity | /SAPHT/DRM_REPPRICUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EDI_PRC_UOM | Reported agreement unit of measure in EDI | /SAPHT/DRM_EDIPRICUOM | CHAR | 3 | EDIF6411 | ||||
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 | ||||
REP_CLAIM_AMOUNT | Reported ship-and-debit claim amount | /SAPHT/DRM_REPCLAIMAMT | CURR | 15(2) | WERTV8 | ||||
EDI_CLAIM_AMOUNT | Reported claim amount in EDI | /SAPHT/DRM_EDICLAIMAMT | CHAR | 18 | EDIF5004 | ||||
REP_CLAIM_CURR | Reported ship-and-debit claim amount currency | /SAPHT/DRM_REPCLAIMCURR | CUKY | 5 | Assigned to domain | WAERS | |||
EDI_CLAIM_CURR | Claim currency in EDI | /SAPHT/DRM_EDICLAIMCURR | CHAR | 3 | EDIF6345 | ||||
INV_DOCNO | Credit/ debit memo number | /SAPHT/DRM_INVDOC_NO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
INV_DOCITM | Credit/ debit memo item number | /SAPHT/DRM_INVDOC_ITM | NUMC | 6 | Assigned to domain | POSNR | |||
RES_IDOCNO | Response IDoc number | /SAPHT/DRM_RERT_IDOCNO | NUMC | 16 | EDI_DOCNUM | DCN | |||
DESIGN_REG_NO | Design registration number | /SAPHT/DRM_DESIGN_REG_NO | CHAR | 30 | CHAR30 | ||||
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/DRMSTAG using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SAPHT/DRMSTAG to SELECT all data from the tableDATA: WA_/SAPHT/DRMSTAG TYPE /SAPHT/DRMSTAG.
SELECT SINGLE *
FROM /SAPHT/DRMSTAG
INTO CORRESPONDING FIELDS OF WA_/SAPHT/DRMSTAG
WHERE...
How to access SAP table /SAPHT/DRMSTAG
Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMSTAG 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