/SAPHT/DRMAGRWL SAP (DRM - worklist table for agreement negotiation) Table details
Description: DRM - worklist table for agreement negotiation
Related tables to /SAPHT/DRMAGRWL
Access table /SAPHT/DRMAGRWL
Table field list including key, data, relationships and ABAP select examples
/SAPHT/DRMAGRWL is a standard SAP Table which is used to store DRM - worklist table for agreement negotiation data and is available within R/3 SAP systems depending on the version and release level.
The /SAPHT/DRMAGRWL table consists of various fields, each holding specific information or linking keys about DRM - worklist table for agreement negotiation data available in SAP. These include WORKLISTNO (DRM agreement worklist item number), WL_TYPE (DRM agreement worklist type), WL_STATUS (DRM agreement worklist item status), DR_BRANCH (Distributor/ reseller's code for reseller unit).. 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/DRMAGRWL 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 | |||
WORKLISTNO | DRM agreement worklist item number | /SAPHT/DRM_WORKLISTNO | CHAR | 10 | ALPHA | BELNR | |||
WL_TYPE | DRM agreement worklist type | /SAPHT/DRM_WL_TYPE | CHAR | 1 | /SAPHT/DRM_WL_TYPE | ||||
WL_STATUS | DRM agreement worklist item status | /SAPHT/DRM_WL_STATUS | CHAR | 1 | /SAPHT/DRM_WL_STATUS | ||||
DR_BRANCH | Distributor/ reseller's code for reseller unit | /SAPHT/DRM_BRANCH | CHAR | 20 | CHAR20 | ||||
MATERIAL | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MSBOOKPARTNO | Manufacturer book part number | /SAPHT/DRM_MSBOOKPARTNO | CHAR | 18 | Assigned to domain | MATN1 | MATNR | /SAPHT/DRM_MSBOOKPRT | MAT1 |
END_CUST | DRM end customer | /SAPHT/DRM_ENDCST | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | DEBI | |
TRACK_PARTNER | Tracking partner | /SAPHT/DRM_TRACK_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
EFF_DATE | EDI transmission effective date | /SAPHT/DRM_EFFDATE | DATS | 8 | DATS | ||||
DISCREPANCY_QTY | Discrepancy quantity | /SAPHT/DRM_DELTA | QUAN | 15(3) | MENGV15_3 | ||||
DISC_UOM | DRM agreement worklist item quantity UoM | /SAPHT/DRM_WL_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SALES_PERSON | DRM agreement negotiation worklist item sales person | /SAPHT/DRM_SALES_PERSON | CHAR | 20 | CHAR20 | ||||
APPROVED_BY | DRM agreement negotiation worklist item approved by | /SAPHT/DRM_WL_APPROV_BY | CHAR | 20 | CHAR20 | ||||
SALESORD_NO | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
SALESORD_ITM | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
CUST_PO_NO | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
CUST_PO_ITM | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6 | ALPHA | POSEX | |||
DESIGN_REG_NO | Design registration number | /SAPHT/DRM_DESIGN_REG_NO | CHAR | 30 | CHAR30 | ||||
REJ_REASON | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | Assigned to domain | ABGRU_VA | |||
IDOCNO_SENT | IDoc number | EDI_DOCNUM | NUMC | 16 | EDI_DOCNUM | DCN | |||
IDOCNO_RECD | IDoc number | EDI_DOCNUM | NUMC | 16 | EDI_DOCNUM | DCN | |||
TRANSM_NO_RECD | EDI transmission number | /SAPHT/DRM_TRANSMNO | CHAR | 20 | CHAR20 | /SAPHT/DRM_TRANSM_NO | |||
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 | |||
AGR_APP_TYPE | DRM agreement type | /SAPHT/DRM_AGR_TYPE | CHAR | 1 | /SAPHT/DRM_AGR_TYPE | ||||
CAL_TYPE | Ship-and-debit claim amount calculation type | /SAPHT/DRM_SDAGR_CAL | CHAR | 1 | /SAPHT/DRM_SDAGR_CAL | ||||
AGR_TYPE | Ship-and-debit agreement type | /SAPHT/DRM_SDAGRTYP | CHAR | 1 | /SAPHT/DRM_SDAGRTYP | ||||
KNUMH | Condition record number | KNUMH | CHAR | 10 | KNUMB | ||||
LASTCOMPNO | DRM-Agreement Negotiation Agreement last competitor no. | /SAPHT/DRMLASTCOMPNO | NUMC | 6 | NUMC6 | ||||
LOGHANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 | ||||
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 |
Key field | Non-key field |
How do I retrieve data from SAP table /SAPHT/DRMAGRWL using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SAPHT/DRMAGRWL to SELECT all data from the tableDATA: WA_/SAPHT/DRMAGRWL TYPE /SAPHT/DRMAGRWL.
SELECT SINGLE *
FROM /SAPHT/DRMAGRWL
INTO CORRESPONDING FIELDS OF WA_/SAPHT/DRMAGRWL
WHERE...
How to access SAP table /SAPHT/DRMAGRWL
Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMAGRWL 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