SAP ABAP Table /SAPHT/DRMHEAD (DRM FIFO Header)

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/DRMHEAD	Table Relationship Diagram
Short Description	DRM FIFO Header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	LOTNO	☑	/SAPHT/DRM_LOTNO	BELNR	CHAR	10	0	DRM lot number
3	DELETE_FLAG	☐	/SAPHT/DRM_DELETE_FLAG	/SAPHT/DRM_DELETE_FLAG	CHAR	1	0	Lot deletion flag
4	.INCLUDE	☐				0	0	DRM FIFO Header: Logical Key
5	MSBOOKPARTNO	☐	/SAPHT/DRM_MSBOOKPARTNO	MATNR	CHAR	18	0	Manufacturer book part number	*
6	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
7	TRACK_PARTNER	☐	/SAPHT/DRM_TRACK_PARTNER	BU_PARTNER	CHAR	10	0	Tracking partner	*
8	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
9	LOTTYPE	☐	/SAPHT/DRM_LOTTYPE	/SAPHT/DRM_LOTTYPE	CHAR	1	0	DRM lot type
10	END_CUST	☐	/SAPHT/DRM_ENDCST	BU_PARTNER	CHAR	10	0	DRM end customer	*
11	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
12	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
13	DIST_CHNL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
14	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	*
15	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
16	BUCKETTYPE	☐	/SAPHT/DRM_BUCKTYP	/SAPHT/DRM_BUCKTYPE	CHAR	2	0	DRM bucket type
17	MS_DR_IND	☐	/SAPHT/DRM_MSDRIND	/SAPHT/DRM_MSDRIND	CHAR	1	0	Indicates manufacturer/supplier or distributor/reseller lot
18	ASSEMBLY_IND	☐	/SAPHT/DRM_ASSIND	/SAPHT/DRM_ASSIND	CHAR	1	0	Assembly indicator
19	.INCLUDE	☐				0	0	DRM FIFO Header: Data record
20	MATDOCQTY	☐	/SAPHT/DRM_MDQTY	MENG15	QUAN	15	3	Material document quantity
21	INVOICQTY	☐	/SAPHT/DRM_INVQTY	MENG15	QUAN	15	3	Invoice quantity
22	DRAVLQTY	☐	/SAPHT/DRM_AVLQTY	MENG15	QUAN	15	3	Unresold quantity in DRM lot
23	DRSTQTY	☐	/SAPHT/DRM_STQTY	MENG15	QUAN	15	3	Sell-through quantity
24	PRISSQTY	☐	/SAPHT/DRM_PRISSQTY	MENG15	QUAN	15	3	Quantity of material issued to production
25	ECRETQTY	☐	/SAPHT/DRM_ECRETQTY	MENG15	QUAN	15	3	Change in resale return quantity
26	MSRETQTY	☐	/SAPHT/DRM_MSRETQTY	MENG15	QUAN	15	3	Quantity returned by distributor/ reseller
27	DSSELLINQTY	☐	/SAPHT/DRM_DSSELLINQTY	MENG15	QUAN	15	3	Drop-Ship Sell-in qty awaiting Resale Reporting
28	QTY_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
29	ALT_UOM	☐	/SAPHT/DRM_ALT_UOM	MEINS	UNIT	3	0	Alternate unit of measure for quantities	T006
30	QTY_NUMER	☐	/SAPHT/DRM_QTY_NUMER	UMBSZ	DEC	5	0	Numerator to convert quantities
31	QTY_DENOM	☐	/SAPHT/DRM_QTY_DENOM	UMBSN	DEC	5	0	Denominator to convert quantities
32	PRIC_UNIT	☐	/SAPHT/DRM_PRCUNIT	KPEIN	DEC	5	0	Pricing unit for price protectable price
33	COND_RATE	☐	/SAPHT/DRM_COND_RATE	WERTV6	CURR	11	2	Price protectable price condition rate
34	COND_CURR	☐	/SAPHT/DRM_COND_CURR	WAERS	CUKY	5	0	Price protectable price currency	TCURC
35	COND_NUMER	☐	/SAPHT/DRM_COND_NUMERATOR	UMBSZ	DEC	5	0	Numerator for converting price protectable price
36	COND_DENOM	☐	/SAPHT/DRM_COND_DENOM	UMBSN	DEC	5	0	Denominator for conversion to base unit
37	COND_UOM	☐	/SAPHT/DRM_PRIC_UOM	MEINS	UNIT	3	0	Pricing unit of measure	T006
38	LAST_SELLIN_DT	☐	/SAPHT/DRM_SELLINDT	DATUM	DATS	8	0	Latest Sell In Date
39	PPTYPE	☐	/SAPHT/DRM_PPTYPE	/SAPHT/DRM_PPTYPE	CHAR	1	0	Price protection type
40	LASTAUDITNO	☐	/SAPHT/DRM_AUDITM	NUMC6	NUMC	6	0	Total number of audit trails for DRM lot
41	PP_STATUS	☐	/SAPHT/DRM_PPSTATUS	/SAPHT/DRM_PPSTATUS	CHAR	1	0	Price protection status of DRM lot
42	REF_ASMB_PRODORD	☐	/SAPHT/DRM_PRODNO	XUACCNT	CHAR	12	0	Production order number
43	REF_ASMB_SLSORD	☐	/SAPHT/DRM_REF_ASMB_SLSORD	VBELN	CHAR	10	0	Reference assembly sales order	*
44	REF_ASMB_SLSITM	☐	/SAPHT/DRM_REF_ASMB_SLSITM	POSNR	NUMC	6	0	Reference sales order item	*
45	.INCLUDE	☐				0	0	DRM Structure for tracking Created By/Changed By...
46	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
47	CREATED_DT	☐	/SAPHT/DRM_CRDATE	DATUM	DATS	8	0	Created on
48	CREATED_TM	☐	C_TIME	UZEIT	TIMS	6	0	Time created
49	LASTCHGDBY	☐	UPNAM	USNAM	CHAR	12	0	Last Changed By
50	LASTCHGDDT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
51	CHANGED_TM	☐	AS4TIME	AS4TIME	TIMS	6	0	Last changed at
52	.INCLUDE	☐				0	0	Addtional Fields to be stored in DRM Transaction tables
53	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/DRMHEAD	ALT_UOM	T006	MSEHI	REF
2	/SAPHT/DRMHEAD	COND_CURR	TCURC	WAERS	REF
3	/SAPHT/DRMHEAD	COND_UOM	T006	MSEHI	REF

History

Last changed by/on	SAP	20110901
SAP Release Created in