/SAPHT/DRMSDDL SAP (Ship and Debit Due List) Table details
Description: Ship and Debit Due List
Related tables to /SAPHT/DRMSDDL
Access table /SAPHT/DRMSDDL
Table field list including key, data, relationships and ABAP select examples
/SAPHT/DRMSDDL is a standard SAP Table which is used to store Ship and Debit Due List data and is available within R/3 SAP systems depending on the version and release level.
The /SAPHT/DRMSDDL table consists of various fields, each holding specific information or linking keys about Ship and Debit Due List data available in SAP. These include CLAIMDOCNO (Ship-and-debit claim document number), STAGDOCNO (IDOC staging table document number), MATCH_RESALENO (Matching Resale record for a SDDL record (STAGDOCNO)), INT_XMNO (DRM internal transmission 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/DRMSDDL 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 | |||
CLAIMDOCNO | Ship-and-debit claim document number | /SAPHT/DRM_CLAIMDOCNO | CHAR | 10 | ALPHA | BELNR | |||
STAGDOCNO | IDOC staging table document number | /SAPHT/DRM_STAGDOCNO | CHAR | 10 | ALPHA | BELNR | |||
MATCH_RESALENO | Matching Resale record for a SDDL record (STAGDOCNO) | /SAPHT/DRM_MATCHRESALE | 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 | |||
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 | ||||
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 |
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 | ||||
LS_EC_INV | Logical System of Resale Invoice | /SAPHT/DRM_LS_ECINV | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
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_SHP_DT | Resale shipping date | /SAPHT/DRM_ECSHPDATE | DATS | 8 | DATS | ||||
CLAIM_STATUS | Processing Status of ship-and-debit claim | /SAPHT/DRM_CLMSTATUS | CHAR | 1 | /SAPHT/DRM_CLMSTATUS | ||||
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 | ||||
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 | ||||
COST | DRM lot cost price for resold material | /SAPHT/DRM_SDINVCOST | CURR | 11(2) | WERTV6 | ||||
COST_CURR | Inventory cost currency | /SAPHT/DRM_SDINVCURR | CUKY | 5 | Assigned to domain | WAERS | |||
COST_PRC_UNIT | Inventory cost pricing quantity | /SAPHT/DRM_SDINVUNIT | DEC | 5 | KPEIN | ||||
PRC_UOM | Unit of measure for pricing quantity in inventory cost | /SAPHT/DRM_INVUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
REP_COST | DRM lot cost price for resold material | /SAPHT/DRM_SDINVCOST | CURR | 11(2) | WERTV6 | ||||
REP_COST_CURR | Inventory cost currency | /SAPHT/DRM_SDINVCURR | CUKY | 5 | Assigned to domain | WAERS | |||
REP_COS_PRC_UNIT | Inventory cost pricing quantity | /SAPHT/DRM_SDINVUNIT | DEC | 5 | KPEIN | ||||
REP_COST_PRC_UOM | Unit of measure for pricing quantity in inventory cost | /SAPHT/DRM_INVUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
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 | ||
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 | ||||
CUS_REF_FLD | Ship-and-debit claim reference number | /SAPHT/DRM_SDCUSREF | CHAR | 35 | /SAPHT/DRM_SDCUSREF | ||||
REP_AGR_RATE | Ship-and-debit agreement rate reported by distributor | /SAPHT/DRM_REPAGRRATE | CURR | 11(2) | WERTV6 | ||||
REP_AGR_CURR | Currency of reported ship-and-debit agreement rate | /SAPHT/DRM_REPAGRCURR | CUKY | 5 | Assigned to domain | WAERS | |||
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 | ||
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_TYP | Ship-and-debit agreement type | /SAPHT/DRM_SDAGRTYP | CHAR | 1 | /SAPHT/DRM_SDAGRTYP | ||||
AGR_CAL_TYP | Ship-and-debit claim amount calculation type | /SAPHT/DRM_SDAGR_CAL | CHAR | 1 | /SAPHT/DRM_SDAGR_CAL | ||||
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 | ||||
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 | ||||
SD_AGR_UOM | Unit of measure for SD Agreement | /SAPHT/DRM_SDAGRCUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
REP_CLAIM_QTY | Reported claim quantity | /SAPHT/DRM_REPCLAIMQTY | QUAN | 15(3) | MENGV15_3 | ||||
REP_CLAIM_AMOUNT | Reported ship-and-debit claim amount | /SAPHT/DRM_REPCLAIMAMT | CURR | 15(2) | WERTV8 | ||||
REP_CLAIM_CURR | Reported ship-and-debit claim amount currency | /SAPHT/DRM_REPCLAIMCURR | CUKY | 5 | Assigned to domain | WAERS | |||
CALC_CLAIM_QTY | Calculated ship-and-debit claim quantity | /SAPHT/DRM_SD_CALCCLAIMQTY | QUAN | 15(3) | MENG15 | ||||
CALC_CLAIM_AMT | Calculated ship-and-debit claim amount | /SAPHT/DRM_SD_CALCCLAIMAMT | CURR | 15(2) | WERTV8 | ||||
CALC_CLAIM_CUR | Currency for ship and debit calculated claim amount | /SAPHT/DRM_SD_CALCCLAIMCUR | 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 | |||
BILLUP_QTY_LEFT | Remaining Bill Up Quantity | /SAPHT/DRM_BUQTYLEFT | QUAN | 15(3) | MENGV15_3 | ||||
QTY_UNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SLS_DOCNO | Credit/ debit memo request number | /SAPHT/DRM_SLSDOC_NO | CHAR | 10 | ALPHA | BELNR | |||
SLS_DOCITM | Credit/ debit memo request item number | /SAPHT/DRM_SLSDOC_ITM | NUMC | 6 | Assigned to domain | POSNR | |||
ABGRU | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | Assigned to domain | ABGRU_VA | |||
COLL_RUN_NO | DRM collective processing number | /SAPHT/DRMCOLLRUNNO | CHAR | 10 | CHAR10 | ||||
GROUP_NO | DRM claim processing group number | /SAPHT/DRMGROUPNO | CHAR | 10 | CHAR10 | ||||
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 | |||
LOGHANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 | ||||
RES_IDOCNO | IDoc number | EDI_DOCNUM | 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 | ||||
CANCEL_INVNO | Credit/ debit memo number | /SAPHT/DRM_INVDOC_NO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
CANCELLED_BY | Canceled by | /SAPHT/CNNAM | CHAR | 12 | USNAM | ||||
CANCELLED_DT | Canceled on | /SAPHT/CNDAT | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table /SAPHT/DRMSDDL using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SAPHT/DRMSDDL to SELECT all data from the tableDATA: WA_/SAPHT/DRMSDDL TYPE /SAPHT/DRMSDDL.
SELECT SINGLE *
FROM /SAPHT/DRMSDDL
INTO CORRESPONDING FIELDS OF WA_/SAPHT/DRMSDDL
WHERE...
How to access SAP table /SAPHT/DRMSDDL
Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMSDDL 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