/SAPHT/DRMSDDL SAP (Ship and Debit Due List) Table details

Dictionary Type: Table
Description: Ship and Debit Due List




ABAP Code to SELECT data from /SAPHT/DRMSDDL
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
MANDTClient MANDTCLNT3Assigned to domainMANDT
CLAIMDOCNOShip-and-debit claim document number /SAPHT/DRM_CLAIMDOCNOCHAR10ALPHABELNR
STAGDOCNOIDOC staging table document number /SAPHT/DRM_STAGDOCNOCHAR10ALPHABELNR
MATCH_RESALENOMatching Resale record for a SDDL record (STAGDOCNO) /SAPHT/DRM_MATCHRESALECHAR10ALPHABELNR
INT_XMNODRM internal transmission number /SAPHT/DRM_INTXMNOCHAR20ALPHA/SAPHT/DRM_INTXMNO
TRANSM_NOEDI transmission number /SAPHT/DRM_TRANSMNOCHAR20CHAR20/SAPHT/DRM_TRANSM_NO
EFF_DATEEDI transmission effective date /SAPHT/DRM_EFFDATEDATS8DATS
SALES_ORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
DIST_CHNLDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
DIVISIONDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
TRANSM_DATEEDI transmission date /SAPHT/DRM_TRANSMDATEDATS8DATS
TRACK_PARTNERTracking partner /SAPHT/DRM_TRACK_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBUPA
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
MS_DR_INDIndicates manufacturer/supplier or distributor/reseller lot /SAPHT/DRM_MSDRINDCHAR1/SAPHT/DRM_MSDRIND
MSBOOKPARTNOManufacturer book part number /SAPHT/DRM_MSBOOKPARTNOCHAR18Assigned to domainMATN1MATNR/SAPHT/DRM_MSBOOKPRTMAT1
MATERIALMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
END_CUSTDRM end customer /SAPHT/DRM_ENDCSTCHAR10Assigned to domainALPHABU_PARTNERDEBI
DR_END_CUSTResale customer as reported by distributor/ reseller /SAPHT/DRM_DRENDCSTCHAR20CHAR20
EXT_REFNOResale customer external reference number /SAPHT/DRM_EXT_CUST_REFNOCHAR11CHAR11
LS_EC_INVLogical System of Resale Invoice /SAPHT/DRM_LS_ECINVCHAR10Assigned to domainALPHALOGSYS
EC_INV_NOEnd customer invoice number /SAPHT/DRM_ECINVDOCCHAR20CHAR20
EC_INV_ITMResale invoice item number /SAPHT/DRM_ECINVITMNUMC6Assigned to domainPOSNR
EC_INV_DTResale invoice date /SAPHT/DRM_ECINVDATEDATS8DATUM
EC_SHP_DTResale shipping date /SAPHT/DRM_ECSHPDATEDATS8DATS
CLAIM_STATUSProcessing Status of ship-and-debit claim /SAPHT/DRM_CLMSTATUSCHAR1/SAPHT/DRM_CLMSTATUS
XN_CODEDRM relevant transaction code /SAPHT/DRM_XNCODECHAR20Assigned to domain/SAPHT/DRM_XNCODE/SAPHT/DRMHXN_CODE
PROC_CODEDRM relevant processing code /SAPHT/DRM_PROCCODECHAR2/SAPHT/DRM_PROCCODE
ERRORCODEError Code for storing errors in a record /SAPHT/DRM_ERROR_CODECHAR100CHAR100
REROUTEFLAGReroute flag /SAPHT/DRM_RERTFLAGCHAR1FLAG
COSTDRM lot cost price for resold material /SAPHT/DRM_SDINVCOSTCURR11(2) WERTV6
COST_CURRInventory cost currency /SAPHT/DRM_SDINVCURRCUKY5Assigned to domainWAERS
COST_PRC_UNITInventory cost pricing quantity /SAPHT/DRM_SDINVUNITDEC5KPEIN
PRC_UOMUnit of measure for pricing quantity in inventory cost /SAPHT/DRM_INVUOMUNIT3Assigned to domainCUNITMEINS
REP_COSTDRM lot cost price for resold material /SAPHT/DRM_SDINVCOSTCURR11(2) WERTV6
REP_COST_CURRInventory cost currency /SAPHT/DRM_SDINVCURRCUKY5Assigned to domainWAERS
REP_COS_PRC_UNITInventory cost pricing quantity /SAPHT/DRM_SDINVUNITDEC5KPEIN
REP_COST_PRC_UOMUnit of measure for pricing quantity in inventory cost /SAPHT/DRM_INVUOMUNIT3Assigned to domainCUNITMEINS
RESALEPRCResale price /SAPHT/DRM_RESPRCCURR11(2) WERTV6
RESALECURRResale price currency /SAPHT/DRM_RESCURRCUKY5Assigned to domainWAERS
RESL_PRC_UNITPricing quantity for resale price /SAPHT/DRM_RESPRCUNITDEC5KPEIN
RESL_PRC_UOMUnit of measure for pricing quantity /SAPHT/DRM_RESPRCUOMUNIT3Assigned to domainCUNITMEINS
INT_BRANCHManufacturer/ supplier's code for reseller unit /SAPHT/DRM_INTBRANCHCHAR10Assigned to domainALPHABU_PARTNERDEBI
BRANCHDistributor/ reseller's code for reseller unit /SAPHT/DRM_BRANCHCHAR20CHAR20
CUS_REF_FLDShip-and-debit claim reference number /SAPHT/DRM_SDCUSREFCHAR35/SAPHT/DRM_SDCUSREF
REP_AGR_RATEShip-and-debit agreement rate reported by distributor /SAPHT/DRM_REPAGRRATECURR11(2) WERTV6
REP_AGR_CURRCurrency of reported ship-and-debit agreement rate /SAPHT/DRM_REPAGRCURRCUKY5Assigned to domainWAERS
REP_PRIC_UNITPricing unit for reported ship-and-debit agreement price /SAPHT/DRM_REPPRICUNITDEC5KPEIN
REP_PRC_UOMUnit of measure for pricing quantity /SAPHT/DRM_REPPRICUOMUNIT3Assigned to domainCUNITMEINS
LS_SD_AGRLogical system of ship & debit agreement /SAPHT/DRM_LS_SDAGRCHAR10Assigned to domainALPHALOGSYS
SD_AGR_NOShip-and-debit agreement number /SAPHT/DRM_SDAGRNOCHAR10ALPHABELNR
SD_AGR_ITMShip-and-debit agreement item number /SAPHT/DRM_SDAGRITMNUMC6Assigned to domainPOSNR
SD_AGR_TYPShip-and-debit agreement type /SAPHT/DRM_SDAGRTYPCHAR1/SAPHT/DRM_SDAGRTYP
AGR_CAL_TYPShip-and-debit claim amount calculation type /SAPHT/DRM_SDAGR_CALCHAR1/SAPHT/DRM_SDAGR_CAL
SD_AGR_RATEShip-and-debit agreement rate /SAPHT/DRM_SDAGRRATECURR11(2) WERTV6
SD_AGR_CURRShip-and-debit agreement rate currency /SAPHT/DRM_SDAGRCURRCUKY5Assigned to domainWAERS
PRIC_UNITShip-and-debit agreement pricing unit /SAPHT/DRM_AGR_PRC_UNITDEC5KPEIN
AGR_CON_NUMNumerator for coversion to base unit /SAPHT/DRM_AGR_COND_NUMERDEC5UMBSZ
AGR_CON_DENDenominator for conversion to base unit of material /SAPHT/DRM_AGR_COND_DENOMDEC5UMBSN
SD_AGR_UOMUnit of measure for SD Agreement /SAPHT/DRM_SDAGRCUOMUNIT3Assigned to domainCUNITMEINS
REP_CLAIM_QTYReported claim quantity /SAPHT/DRM_REPCLAIMQTYQUAN15(3) MENGV15_3
REP_CLAIM_AMOUNTReported ship-and-debit claim amount /SAPHT/DRM_REPCLAIMAMTCURR15(2) WERTV8
REP_CLAIM_CURRReported ship-and-debit claim amount currency /SAPHT/DRM_REPCLAIMCURRCUKY5Assigned to domainWAERS
CALC_CLAIM_QTYCalculated ship-and-debit claim quantity /SAPHT/DRM_SD_CALCCLAIMQTYQUAN15(3) MENG15
CALC_CLAIM_AMTCalculated ship-and-debit claim amount /SAPHT/DRM_SD_CALCCLAIMAMTCURR15(2) WERTV8
CALC_CLAIM_CURCurrency for ship and debit calculated claim amount /SAPHT/DRM_SD_CALCCLAIMCURCUKY5Assigned to domainWAERS
SD_SLS_DOCQTYShip and Debit qty in the credit/debit memo request /SAPHT/DRM_SD_SLSDOCQTYQUAN15(3) MENGV15
SD_SLS_DOCAMTShip and Debit amount in the credit/debit memo request /SAPHT/DRM_SD_SLSDOCAMTCURR15(2) WERTV8
SD_SLS_DOCCURRCurrency of the credit/debit memo request amount /SAPHT/DRM_SD_SLSDOCCURRCUKY5Assigned to domainWAERS
SD_INV_DOCQTYShip-and-debit invoice document quantity /SAPHT/DRM_SD_INVDOCQTYQUAN15(3) MENGV15
SD_INV_DOCAMTAmount paid out as ship-and-debit claim /SAPHT/DRM_SD_INVDOCAMTCURR15(2) WERTV8
SD_INV_DOCCURRCurrency for ship-and-debit amount in credit/ debit memo /SAPHT/DRM_SD_INVDOCCURRCUKY5Assigned to domainWAERS
BILLUP_QTY_LEFTRemaining Bill Up Quantity /SAPHT/DRM_BUQTYLEFTQUAN15(3) MENGV15_3
QTY_UNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
SLS_DOCNOCredit/ debit memo request number /SAPHT/DRM_SLSDOC_NOCHAR10ALPHABELNR
SLS_DOCITMCredit/ debit memo request item number /SAPHT/DRM_SLSDOC_ITMNUMC6Assigned to domainPOSNR
ABGRUReason for rejection of quotations and sales orders ABGRU_VACHAR2Assigned to domainABGRU_VA
COLL_RUN_NODRM collective processing number /SAPHT/DRMCOLLRUNNOCHAR10CHAR10
GROUP_NODRM claim processing group number /SAPHT/DRMGROUPNOCHAR10CHAR10
INV_DOCNOCredit/ debit memo number /SAPHT/DRM_INVDOC_NOCHAR10Assigned to domainALPHAVBELN
INV_DOCITMCredit/ debit memo item number /SAPHT/DRM_INVDOC_ITMNUMC6Assigned to domainPOSNR
LOGHANDLEApplication Log: Log Handle BALLOGHNDLCHAR22SYSUUID_22
RES_IDOCNOIDoc number EDI_DOCNUMNUMC16EDI_DOCNUMDCN
DESIGN_REG_NODesign registration number /SAPHT/DRM_DESIGN_REG_NOCHAR30CHAR30
CREATED_BYName of Person who Created the Object ERNAMCHAR12USNAM
CREATED_DTCreated on /SAPHT/DRM_CRDATEDATS8DATUM
CREATED_TMTime created C_TIMETIMS6UZEIT
LASTCHGDBYLast Changed By UPNAMCHAR12USNAM
LASTCHGDDTChanged On AEDATDATS8DATUM
CHANGED_TMLast changed at AS4TIMETIMS6AS4TIME
CANCEL_INVNOCredit/ debit memo number /SAPHT/DRM_INVDOC_NOCHAR10Assigned to domainALPHAVBELN
CANCELLED_BYCanceled by /SAPHT/CNNAMCHAR12USNAM
CANCELLED_DTCanceled on /SAPHT/CNDATDATS8DATUM

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!