SAP ABAP Table /SAPHT/DRMSPPDL_SORT (Sort structure for price protection)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPHT/DRMSPPDL_SORT	Table Relationship Diagram
Short Description	Sort structure for price protection

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in