/SAPHT/DRMSPPDL_SCR_200 SAP (Price protection transaction - Screen 200) Structure details
Description: Price protection transaction - Screen 200
Related tables to /SAPHT/DRMSPPDL_SCR_200
Access table /SAPHT/DRMSPPDL_SCR_200
Structure field list including key, data, relationships and ABAP select examples
/SAPHT/DRMSPPDL_SCR_200 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 "Price protection transaction - Screen 200" 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/DRMSPPDL_SCR_200 TYPE /SAPHT/DRMSPPDL_SCR_200.
The /SAPHT/DRMSPPDL_SCR_200 table consists of various fields, each holding specific information or linking keys about Price protection transaction - Screen 200 data available in SAP. These include MANDT (Client), RECORDNO (Price protection due list record number), LOTNO (DRM lot number), MSBOOKPARTNO (Manufacturer book part 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /SAPHT/DRMSPPDL_SCR_200 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 | |||
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 | ||||
MARK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
LINK1 | Char 80 | CHAR80 | CHAR | 80 | CHAR80 | ||||
LINK2 | Char 80 | CHAR80 | CHAR | 80 | CHAR80 |
Key field | Non-key field |
How do I retrieve data from SAP structure /SAPHT/DRMSPPDL_SCR_200 using ABAP code?
As /SAPHT/DRMSPPDL_SCR_200 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/DRMSPPDL_SCR_200 as there is no data to select.How to access SAP table /SAPHT/DRMSPPDL_SCR_200
Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMSPPDL_SCR_200 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