/SAPHT/DRMPPDL SAP (Price Protection Due List) Table details
Dictionary Type: Table
Description: Price Protection Due List
Description: Price Protection Due List
ABAP Code to SELECT data from /SAPHT/DRMPPDL
Related tables to /SAPHT/DRMPPDL
Access table /SAPHT/DRMPPDL
Related tables to /SAPHT/DRMPPDL
Access table /SAPHT/DRMPPDL
Table field list including key, data, relationships and ABAP select examples
/SAPHT/DRMPPDL is a standard SAP Table which is used to store Price Protection Due List data and is available within R/3 SAP systems depending on the version and release level.
The /SAPHT/DRMPPDL table consists of various fields, each holding specific information or linking keys about Price Protection Due List data available in SAP. These include RECORDNO (Price protection due list record number), LOTNO (DRM lot number), MSBOOKPARTNO (Manufacturer book part number), MATERIAL (Material 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/DRMPPDL 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 | |||
RECORDNO | Price protection due list record number | /SAPHT/DRM_RECORDNO | CHAR | 10 | ALPHA | BELNR | |||
LOTNO | DRM lot number | /SAPHT/DRM_LOTNO | CHAR | 10 | ALPHA | BELNR | |||
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 |
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 |
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 | |
PURCH_ORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LOTTYPE | DRM lot type | /SAPHT/DRM_LOTTYPE | CHAR | 1 | /SAPHT/DRM_LOTTYPE | ||||
END_CUST | DRM end customer | /SAPHT/DRM_ENDCST | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | DEBI | |
PPCLMQTY | Price protection claim quantity | /SAPHT/DRM_PPCLMQTY | QUAN | 15(3) | MENGV15_3 | ||||
QTY_UNIT | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
OLDPRCUNIT | Old price protectable price pricing unit | /SAPHT/DRM_OLDPRCUNIT | DEC | 5 | KPEIN | ||||
OLDCONDRATE | Old price protectable price | /SAPHT/DRM_OLDCONDRATE | CURR | 11(2) | WERTV6 | ||||
OLDCONDCURR | Old price protectable price currency | /SAPHT/DRM_OLDCONDCURR | CUKY | 5 | TCURC | WAERS | |||
OLDCONDNR | Nr for converting old PP condition units to base units | /SAPHT/DRM_OLDCONDNR | DEC | 5 | UMBSZ | ||||
OLDCONDDR | Dr for converting old PP condition units to base units | /SAPHT/DRM_OLDCONDDR | DEC | 5 | UMBSN | ||||
OLDCONDUOM | Pricing unit of measure | /SAPHT/DRM_PRIC_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
NEWPRCUNIT | New price protectable price pricing unit | /SAPHT/DRM_NEWPRCUNIT | DEC | 5 | KPEIN | ||||
NEWCONDRATE | New price protectable price | /SAPHT/DRM_NEWCONDRATE | CURR | 11(2) | WERTV6 | ||||
NEWCONDCURR | New price protectable price currency | /SAPHT/DRM_NEWCONDCURR | CUKY | 5 | TCURC | WAERS | |||
NEWCONDNR | Nr for converting new PP condition units to base units | /SAPHT/DRM_NEWCONDNR | DEC | 5 | UMBSZ | ||||
NEWCONDDR | Dr for converting new PP condition units to base units | /SAPHT/DRM_NEWCONDDR | DEC | 5 | UMBSN | ||||
NEWCONDUOM | Pricing unit of measure | /SAPHT/DRM_PRIC_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OLDPPTYPE | Old Price Protection Type | /SAPHT/DRM_OLDPPTYPE | CHAR | 1 | /SAPHT/DRM_PPTYPE | ||||
PPTYPE | New Price Protection Type | /SAPHT/DRM_NEWPPTYPE | CHAR | 1 | /SAPHT/DRM_PPTYPE | ||||
PPAMOUNT | Price protection claim amount | /SAPHT/DRM_PPAMOUNT | CURR | 15(2) | WERTV8 | ||||
PPAMTCURR | Price protection claim amount currency | /SAPHT/DRM_PPAMTCURR | CUKY | 5 | TCURC | WAERS | |||
PPCLM_STATUS | Price protection claim processing status | /SAPHT/DRM_PPCLMSTATUS | CHAR | 1 | /SAPHT/DRM_PPCLMSTATUS | ||||
PPRVLQTY | Lot quantity eligible for revaluation | /SAPHT/DRM_PPRVLQTY | QUAN | 15(3) | MENGV15_3 | ||||
PPRVLAMT | Price protection revaluation amount | /SAPHT/DRM_PPRVLAMT | CURR | 15(2) | WERTV8 | ||||
PPRVLAMTCURR | Currency of Revaluation amount | /SAPHT/DRM_PPRVLAMTCURR | CUKY | 5 | Assigned to domain | WAERS | |||
PPRVL_STATUS | price protection related inventory revaluation status | /SAPHT/DRM_PPRVLSTATUS | CHAR | 1 | /SAPHT/DRM_PPRVLSTATUS | ||||
PPANNO | Price protection announcement number | /SAPHT/DRM_PPANNO | CHAR | 10 | CHAR10 | ||||
PPEFFDATE | Price protection effective date | /SAPHT/DRM_PPEFFDATE | DATS | 8 | DATS | /SAPHT/DRM_PPEFFDT | |||
PPRUNNO | DRM collective processing number | /SAPHT/DRMCOLLRUNNO | CHAR | 10 | CHAR10 | ||||
PPRUNGRPNO | DRM claim processing group number | /SAPHT/DRMGROUPNO | CHAR | 10 | CHAR10 | ||||
PPRUNDATE | Price protection run date | /SAPHT/DRM_PPRUNDATE | DATS | 8 | DATS | ||||
PP_SLS_DOCQTY | Price protection qty in the credit/debit memo request | /SAPHT/DRM_PP_SLSDOCQTY | QUAN | 15(3) | MENGV15 | ||||
PP_SLS_DOCAMT | Price protection amount in the credit/debit memo request | /SAPHT/DRM_PP_SLSDOCAMT | CURR | 15(2) | WERTV8 | ||||
PP_SLS_DOCCURR | Currency of the credit/debit memo request amount | /SAPHT/DRM_PP_SLSDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
PP_INV_DOCQTY | Price protection claim invoiced quantity | /SAPHT/DRM_PP_INVDOCQTY | QUAN | 15(3) | MENGV15 | ||||
PP_INV_DOCAMT | Price protection claim invoiced amount | /SAPHT/DRM_PP_INVDOCAMT | CURR | 15(2) | WERTV8 | ||||
PP_INV_DOCCURR | Currency for the price protection claim invoced amount | /SAPHT/DRM_PP_INVDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
LS_PPCLMDOC | Logical system of price protection claim document | /SAPHT/DRM_LS_PPCLM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
PP_SLS_DOCNO | Price protection credit/ debit memo request number | /SAPHT/DRM_PPSLSDOCNO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
PP_SLS_DOCITM | Price protection credit/ debit memo request item number | /SAPHT/DRM_PPSLSITMNO | NUMC | 6 | Assigned to domain | POSNR | |||
ABGRU | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | Assigned to domain | ABGRU_VA | |||
PP_INV_DOCNO | Price protection credit/ debit memo number | /SAPHT/DRM_PPINVDOCNO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
PP_INV_DOCITM | Price protection credit/ debit memo item number | /SAPHT/DRM_PPINVITMNO | NUMC | 6 | Assigned to domain | POSNR | |||
RULE_RUNNO | Price Protection creation run no | /SAPHT/DRM_RUNNO | CHAR | 10 | ALPHA | BELNR | |||
CANCEL_DOCTYP | Cancellation document type | /SAPHT/DRM_CANDOCTYP | CHAR | 2 | /SAPHT/DRM_DOCTYP | ||||
CANCEL_DOCNO | Cancellation document number | /SAPHT/DRM_CANDOCNO | CHAR | 12 | XUACCNT | ||||
CANCEL_DOCITM | Cancellation document item number | /SAPHT/DRM_CANDOCITM | NUMC | 6 | Assigned to domain | POSNR | |||
CANCEL_DOCDATE | Cancellation document date | /SAPHT/DRM_CANDOCDATE | DATS | 8 | DATUM | ||||
CANCEL_RUN_DATE | Cancellation run date | /SAPHT/DRMCANCELRUNDATE | DATS | 8 | DATS | ||||
CANCEL_IND | Cancellation indicator for audit trail | /SAPHT/DRM_CANCEL_IND | CHAR | 1 | /SAPHT/DRM_CANCEL_IND | ||||
CANCEL_INVNO | Cancellation invoice number | /SAPHT/DRM_CANCINVNO | CHAR | 10 | CHAR10 | ||||
CANCEL_INVITM | Cancellation Invoice item number | /SAPHT/DRM_CANCINVITM | NUMC | 6 | Assigned to domain | POSNR | |||
CANCEL_INVDATE | Cancellation invoice date | /SAPHT/DRM_CANCINVDATE | DATS | 8 | DATUM | ||||
REJ_REASON | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | Assigned to domain | ABGRU_VA | |||
LS_PPRVLDOC | Logical system of price protection revaluation document | /SAPHT/DRM_LS_PPRVL | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
PPRVLDOCNO | Price protection revaluation document number | /SAPHT/DRM_PPRVLDOCNO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
PPRVLDOCYR | Document year of Revaluation document | /SAPHT/DRM_PPRVLDOCYR | NUMC | 4 | GJAHR | GJAHR | |||
PPRVLPOST | Posting period of Revaluation document | /SAPHT/DRM_PPRVLPOST | NUMC | 3 | POPER | ||||
LS_REFDOC | Logical system of reference document | /SAPHT/DRM_LS_REFDOCNO | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
REF_DOC_NO | Reference document number | /SAPHT/DRM_RFDOCNO | CHAR | 12 | XUACCNT | ||||
REF_DOC_ITM | Reference document item number | /SAPHT/DRM_RFDOCITM | NUMC | 6 | Assigned to domain | POSNR | |||
REF_DOC_TYPE | Document type used for price calculation | /SAPHT/DRM_REFDOCTYPE | CHAR | 4 | CHAR4 | ||||
UPDTPRC | Price Update Indicator | /SAPHT/DRM_UPDTPRC | CHAR | 1 | CHAR1 | ||||
LOGHANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 | ||||
MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | /SAPHT/DRM_MSDRIND | CHAR | 1 | /SAPHT/DRM_MSDRIND | ||||
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 | ||||
DUMMY_1 | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
Key field | Non-key field |
How do I retrieve data from SAP table /SAPHT/DRMPPDL using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SAPHT/DRMPPDL to SELECT all data from the tableDATA: WA_/SAPHT/DRMPPDL TYPE /SAPHT/DRMPPDL.
SELECT SINGLE *
FROM /SAPHT/DRMPPDL
INTO CORRESPONDING FIELDS OF WA_/SAPHT/DRMPPDL
WHERE...
How to access SAP table /SAPHT/DRMPPDL
Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMPPDL 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