/SAPHT/DRMAGRWL SAP (DRM - worklist table for agreement negotiation) Table details

Dictionary Type: Table
Description: DRM - worklist table for agreement negotiation




ABAP Code to SELECT data from /SAPHT/DRMAGRWL
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
MANDTClient MANDTCLNT3Assigned to domainMANDT
WORKLISTNODRM agreement worklist item number /SAPHT/DRM_WORKLISTNOCHAR10ALPHABELNR
WL_TYPEDRM agreement worklist type /SAPHT/DRM_WL_TYPECHAR1/SAPHT/DRM_WL_TYPE
WL_STATUSDRM agreement worklist item status /SAPHT/DRM_WL_STATUSCHAR1/SAPHT/DRM_WL_STATUS
DR_BRANCHDistributor/ reseller's code for reseller unit /SAPHT/DRM_BRANCHCHAR20CHAR20
MATERIALMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MSBOOKPARTNOManufacturer book part number /SAPHT/DRM_MSBOOKPARTNOCHAR18Assigned to domainMATN1MATNR/SAPHT/DRM_MSBOOKPRTMAT1
END_CUSTDRM end customer /SAPHT/DRM_ENDCSTCHAR10Assigned to domainALPHABU_PARTNERDEBI
TRACK_PARTNERTracking partner /SAPHT/DRM_TRACK_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBUPA
EFF_DATEEDI transmission effective date /SAPHT/DRM_EFFDATEDATS8DATS
DISCREPANCY_QTYDiscrepancy quantity /SAPHT/DRM_DELTAQUAN15(3) MENGV15_3
DISC_UOMDRM agreement worklist item quantity UoM /SAPHT/DRM_WL_UOMUNIT3Assigned to domainCUNITMEINS
SALES_PERSONDRM agreement negotiation worklist item sales person /SAPHT/DRM_SALES_PERSONCHAR20CHAR20
APPROVED_BYDRM agreement negotiation worklist item approved by /SAPHT/DRM_WL_APPROV_BYCHAR20CHAR20
SALESORD_NOSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
SALESORD_ITMSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
CUST_PO_NOCustomer purchase order number BSTKDCHAR35BSTKD
CUST_PO_ITMItem Number of the Underlying Purchase Order POSEXCHAR6ALPHAPOSEX
DESIGN_REG_NODesign registration number /SAPHT/DRM_DESIGN_REG_NOCHAR30CHAR30
REJ_REASONReason for rejection of quotations and sales orders ABGRU_VACHAR2Assigned to domainABGRU_VA
IDOCNO_SENTIDoc number EDI_DOCNUMNUMC16EDI_DOCNUMDCN
IDOCNO_RECDIDoc number EDI_DOCNUMNUMC16EDI_DOCNUMDCN
TRANSM_NO_RECDEDI transmission number /SAPHT/DRM_TRANSMNOCHAR20CHAR20/SAPHT/DRM_TRANSM_NO
SD_AGR_NOShip-and-debit agreement number /SAPHT/DRM_SDAGRNOCHAR10ALPHABELNR
SD_AGR_ITMShip-and-debit agreement item number /SAPHT/DRM_SDAGRITMNUMC6Assigned to domainPOSNR
AGR_APP_TYPEDRM agreement type /SAPHT/DRM_AGR_TYPECHAR1/SAPHT/DRM_AGR_TYPE
CAL_TYPEShip-and-debit claim amount calculation type /SAPHT/DRM_SDAGR_CALCHAR1/SAPHT/DRM_SDAGR_CAL
AGR_TYPEShip-and-debit agreement type /SAPHT/DRM_SDAGRTYPCHAR1/SAPHT/DRM_SDAGRTYP
KNUMHCondition record number KNUMHCHAR10KNUMB
LASTCOMPNODRM-Agreement Negotiation Agreement last competitor no. /SAPHT/DRMLASTCOMPNONUMC6NUMC6
LOGHANDLEApplication Log: Log Handle BALLOGHNDLCHAR22SYSUUID_22
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

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