SAP ABAP Table /SAPHT/DRMPPDL (Price Protection Due List)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-HT-DRM (Application Component) Distributor-Reseller-Management
     ⤷ /SAPHT/DRM02 (Package) DRM Development

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/SAPHT/DRMPPDL	Table Relationship Diagram
Short Description	Price Protection Due List

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	RECORDNO	☑	/SAPHT/DRM_RECORDNO	BELNR	CHAR	10	0	Price protection due list record number
3	LOTNO	☐	/SAPHT/DRM_LOTNO	BELNR	CHAR	10	0	DRM lot number
4	MSBOOKPARTNO	☐	/SAPHT/DRM_MSBOOKPARTNO	MATNR	CHAR	18	0	Manufacturer book part number	*
5	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
6	TRACK_PARTNER	☐	/SAPHT/DRM_TRACK_PARTNER	BU_PARTNER	CHAR	10	0	Tracking partner	*
7	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
8	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
9	DIST_CHNL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
10	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	*
11	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
12	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
13	LOTTYPE	☐	/SAPHT/DRM_LOTTYPE	/SAPHT/DRM_LOTTYPE	CHAR	1	0	DRM lot type
14	END_CUST	☐	/SAPHT/DRM_ENDCST	BU_PARTNER	CHAR	10	0	DRM end customer	*
15	PPCLMQTY	☐	/SAPHT/DRM_PPCLMQTY	MENGV15_3	QUAN	15	3	Price protection claim quantity
16	QTY_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
17	OLDPRCUNIT	☐	/SAPHT/DRM_OLDPRCUNIT	KPEIN	DEC	5	0	Old price protectable price pricing unit
18	OLDCONDRATE	☐	/SAPHT/DRM_OLDCONDRATE	WERTV6	CURR	11	2	Old price protectable price
19	OLDCONDCURR	☐	/SAPHT/DRM_OLDCONDCURR	WAERS	CUKY	5	0	Old price protectable price currency	TCURC
20	OLDCONDNR	☐	/SAPHT/DRM_OLDCONDNR	UMBSZ	DEC	5	0	Nr for converting old PP condition units to base units
21	OLDCONDDR	☐	/SAPHT/DRM_OLDCONDDR	UMBSN	DEC	5	0	Dr for converting old PP condition units to base units
22	OLDCONDUOM	☐	/SAPHT/DRM_PRIC_UOM	MEINS	UNIT	3	0	Pricing unit of measure	*
23	NEWPRCUNIT	☐	/SAPHT/DRM_NEWPRCUNIT	KPEIN	DEC	5	0	New price protectable price pricing unit
24	NEWCONDRATE	☐	/SAPHT/DRM_NEWCONDRATE	WERTV6	CURR	11	2	New price protectable price
25	NEWCONDCURR	☐	/SAPHT/DRM_NEWCONDCURR	WAERS	CUKY	5	0	New price protectable price currency	TCURC
26	NEWCONDNR	☐	/SAPHT/DRM_NEWCONDNR	UMBSZ	DEC	5	0	Nr for converting new PP condition units to base units
27	NEWCONDDR	☐	/SAPHT/DRM_NEWCONDDR	UMBSN	DEC	5	0	Dr for converting new PP condition units to base units
28	NEWCONDUOM	☐	/SAPHT/DRM_PRIC_UOM	MEINS	UNIT	3	0	Pricing unit of measure	*
29	OLDPPTYPE	☐	/SAPHT/DRM_OLDPPTYPE	/SAPHT/DRM_PPTYPE	CHAR	1	0	Old Price Protection Type
30	PPTYPE	☐	/SAPHT/DRM_NEWPPTYPE	/SAPHT/DRM_PPTYPE	CHAR	1	0	New Price Protection Type
31	PPAMOUNT	☐	/SAPHT/DRM_PPAMOUNT	WERTV8	CURR	15	2	Price protection claim amount
32	PPAMTCURR	☐	/SAPHT/DRM_PPAMTCURR	WAERS	CUKY	5	0	Price protection claim amount currency	TCURC
33	PPCLM_STATUS	☐	/SAPHT/DRM_PPCLMSTATUS	/SAPHT/DRM_PPCLMSTATUS	CHAR	1	0	Price protection claim processing status
34	PPRVLQTY	☐	/SAPHT/DRM_PPRVLQTY	MENGV15_3	QUAN	15	3	Lot quantity eligible for revaluation
35	PPRVLAMT	☐	/SAPHT/DRM_PPRVLAMT	WERTV8	CURR	15	2	Price protection revaluation amount
36	PPRVLAMTCURR	☐	/SAPHT/DRM_PPRVLAMTCURR	WAERS	CUKY	5	0	Currency of Revaluation amount	*
37	PPRVL_STATUS	☐	/SAPHT/DRM_PPRVLSTATUS	/SAPHT/DRM_PPRVLSTATUS	CHAR	1	0	price protection related inventory revaluation status
38	PPANNO	☐	/SAPHT/DRM_PPANNO	CHAR10	CHAR	10	0	Price protection announcement number
39	PPEFFDATE	☐	/SAPHT/DRM_PPEFFDATE	DATS	DATS	8	0	Price protection effective date
40	PPRUNNO	☐	/SAPHT/DRMCOLLRUNNO	CHAR10	CHAR	10	0	DRM collective processing number
41	PPRUNGRPNO	☐	/SAPHT/DRMGROUPNO	CHAR10	CHAR	10	0	DRM claim processing group number
42	PPRUNDATE	☐	/SAPHT/DRM_PPRUNDATE	DATS	DATS	8	0	Price protection run date
43	PP_SLS_DOCQTY	☐	/SAPHT/DRM_PP_SLSDOCQTY	MENGV15	QUAN	15	3	Price protection qty in the credit/debit memo request
44	PP_SLS_DOCAMT	☐	/SAPHT/DRM_PP_SLSDOCAMT	WERTV8	CURR	15	2	Price protection amount in the credit/debit memo request
45	PP_SLS_DOCCURR	☐	/SAPHT/DRM_PP_SLSDOCCURR	WAERS	CUKY	5	0	Currency of the credit/debit memo request amount	*
46	PP_INV_DOCQTY	☐	/SAPHT/DRM_PP_INVDOCQTY	MENGV15	QUAN	15	3	Price protection claim invoiced quantity
47	PP_INV_DOCAMT	☐	/SAPHT/DRM_PP_INVDOCAMT	WERTV8	CURR	15	2	Price protection claim invoiced amount
48	PP_INV_DOCCURR	☐	/SAPHT/DRM_PP_INVDOCCURR	WAERS	CUKY	5	0	Currency for the price protection claim invoced amount	*
49	LS_PPCLMDOC	☐	/SAPHT/DRM_LS_PPCLM	LOGSYS	CHAR	10	0	Logical system of price protection claim document	*
50	PP_SLS_DOCNO	☐	/SAPHT/DRM_PPSLSDOCNO	VBELN	CHAR	10	0	Price protection credit/ debit memo request number	*
51	PP_SLS_DOCITM	☐	/SAPHT/DRM_PPSLSITMNO	POSNR	NUMC	6	0	Price protection credit/ debit memo request item number	*
52	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
53	PP_INV_DOCNO	☐	/SAPHT/DRM_PPINVDOCNO	VBELN	CHAR	10	0	Price protection credit/ debit memo number	*
54	PP_INV_DOCITM	☐	/SAPHT/DRM_PPINVITMNO	POSNR	NUMC	6	0	Price protection credit/ debit memo item number	*
55	RULE_RUNNO	☐	/SAPHT/DRM_RUNNO	BELNR	CHAR	10	0	Price Protection creation run no
56	.INCLUDE	☐				0	0	Cancellation Tracking fields
57	CANCEL_DOCTYP	☐	/SAPHT/DRM_CANDOCTYP	/SAPHT/DRM_DOCTYP	CHAR	2	0	Cancellation document type
58	CANCEL_DOCNO	☐	/SAPHT/DRM_CANDOCNO	XUACCNT	CHAR	12	0	Cancellation document number
59	CANCEL_DOCITM	☐	/SAPHT/DRM_CANDOCITM	POSNR	NUMC	6	0	Cancellation document item number	*
60	CANCEL_DOCDATE	☐	/SAPHT/DRM_CANDOCDATE	DATUM	DATS	8	0	Cancellation document date
61	CANCEL_RUN_DATE	☐	/SAPHT/DRMCANCELRUNDATE	DATS	DATS	8	0	Cancellation run date
62	CANCEL_IND	☐	/SAPHT/DRM_CANCEL_IND	/SAPHT/DRM_CANCEL_IND	CHAR	1	0	Cancellation indicator for audit trail
63	CANCEL_INVNO	☐	/SAPHT/DRM_CANCINVNO	CHAR10	CHAR	10	0	Cancellation invoice number
64	CANCEL_INVITM	☐	/SAPHT/DRM_CANCINVITM	POSNR	NUMC	6	0	Cancellation Invoice item number	*
65	CANCEL_INVDATE	☐	/SAPHT/DRM_CANCINVDATE	DATUM	DATS	8	0	Cancellation invoice date
66	REJ_REASON	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
67	LS_PPRVLDOC	☐	/SAPHT/DRM_LS_PPRVL	LOGSYS	CHAR	10	0	Logical system of price protection revaluation document	*
68	PPRVLDOCNO	☐	/SAPHT/DRM_PPRVLDOCNO	VBELN	CHAR	10	0	Price protection revaluation document number	*
69	PPRVLDOCYR	☐	/SAPHT/DRM_PPRVLDOCYR	GJAHR	NUMC	4	0	Document year of Revaluation document
70	PPRVLPOST	☐	/SAPHT/DRM_PPRVLPOST	POPER	NUMC	3	0	Posting period of Revaluation document
71	LS_REFDOC	☐	/SAPHT/DRM_LS_REFDOCNO	LOGSYS	CHAR	10	0	Logical system of reference document	*
72	REF_DOC_NO	☐	/SAPHT/DRM_RFDOCNO	XUACCNT	CHAR	12	0	Reference document number
73	REF_DOC_ITM	☐	/SAPHT/DRM_RFDOCITM	POSNR	NUMC	6	0	Reference document item number	*
74	REF_DOC_TYPE	☐	/SAPHT/DRM_REFDOCTYPE	CHAR4	CHAR	4	0	Document type used for price calculation
75	UPDTPRC	☐	/SAPHT/DRM_UPDTPRC	CHAR1	CHAR	1	0	Price Update Indicator
76	LOGHANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
77	MS_DR_IND	☐	/SAPHT/DRM_MSDRIND	/SAPHT/DRM_MSDRIND	CHAR	1	0	Indicates manufacturer/supplier or distributor/reseller lot
78	.INCLUDE	☐				0	0	DRM Structure for tracking Created By/Changed By...
79	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
80	CREATED_DT	☐	/SAPHT/DRM_CRDATE	DATUM	DATS	8	0	Created on
81	CREATED_TM	☐	C_TIME	UZEIT	TIMS	6	0	Time created
82	LASTCHGDBY	☐	UPNAM	USNAM	CHAR	12	0	Last Changed By
83	LASTCHGDDT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
84	CHANGED_TM	☐	AS4TIME	AS4TIME	TIMS	6	0	Last changed at
85	.INCLUDE	☐				0	0	Addtional Fields to be stored in DRM Transaction tables
86	DUMMY_1	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPHT/DRMPPDL	NEWCONDCURR	TCURC	WAERS		1	CN
2	/SAPHT/DRMPPDL	OLDCONDCURR	TCURC	WAERS		1	CN
3	/SAPHT/DRMPPDL	PPAMTCURR	TCURC	WAERS		1	CN
4	/SAPHT/DRMPPDL	QTY_UNIT	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in