/SAPHT/DRMRLSDDL SAP (Rule Communication Structure on SDDL) Structure details
Description: Rule Communication Structure on SDDL
Related tables to /SAPHT/DRMRLSDDL
Access table /SAPHT/DRMRLSDDL
Structure field list including key, data, relationships and ABAP select examples
/SAPHT/DRMRLSDDL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Rule Communication Structure on SDDL" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_/SAPHT/DRMRLSDDL TYPE /SAPHT/DRMRLSDDL.
The /SAPHT/DRMRLSDDL table consists of various fields, each holding specific information or linking keys about Rule Communication Structure on SDDL data available in SAP. These include MANDT (Client), CLAIMDOCNO (Ship-and-debit claim document number), STAGDOCNO (IDOC staging table document number), MATCH_RESALENO (Matching Resale record for a SDDL record (STAGDOCNO)).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /SAPHT/DRMRLSDDL structure 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 | ||||
IDOCNO | IDoc number | EDI_DOCNUM | NUMC | 16 | EDI_DOCNUM | DCN | |||
LOTTYPE | DRM lot type | /SAPHT/DRM_LOTTYPE | CHAR | 1 | /SAPHT/DRM_LOTTYPE | ||||
PROC_STATUS | Processing status of staging record | /SAPHT/DRM_STAGSTAT | CHAR | 1 | /SAPHT/DRM_STAGSTAT |
Key field | Non-key field |
How do I retrieve data from SAP structure /SAPHT/DRMRLSDDL using ABAP code?
As /SAPHT/DRMRLSDDL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SAPHT/DRMRLSDDL as there is no data to select.How to access SAP table /SAPHT/DRMRLSDDL
Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMRLSDDL 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