SAP ABAP Table /SAPHT/DRMSTAG (DRM Staging Area)

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/DRMSTAG	Table Relationship Diagram
Short Description	DRM Staging Area

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	STAGDOCNO	☑	/SAPHT/DRM_STAGDOCNO	BELNR	CHAR	10	0	IDOC staging table document number
3	INT_XMNO	☐	/SAPHT/DRM_INTXMNO	/SAPHT/DRM_INTXMNO	CHAR	20	0	DRM internal transmission number
4	TRANSM_NO	☐	/SAPHT/DRM_TRANSMNO	CHAR20	CHAR	20	0	EDI transmission number
5	IDOCNO	☐	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	0	IDoc number
6	IDOC_TYPE	☐	EDI_MESTYP	EDI_MESTYP	CHAR	30	0	Message Type	*
7	EFF_DATE	☐	/SAPHT/DRM_EFFDATE	DATS	DATS	8	0	EDI transmission effective date
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	TRANSM_DATE	☐	/SAPHT/DRM_TRANSMDATE	DATS	DATS	8	0	EDI transmission date
12	XN_CODE	☐	/SAPHT/DRM_XNCODE	/SAPHT/DRM_XNCODE	CHAR	20	0	DRM relevant transaction code	*
13	EDIXNCODE	☐	/SAPHT/DRM_EDIXNCODE	/SAPHT/DRM_EDIXNCODE	CHAR	2	0	EDI transaction code
14	PROC_CODE	☐	/SAPHT/DRM_PROCCODE	/SAPHT/DRM_PROCCODE	CHAR	2	0	DRM relevant processing code
15	TRACK_PARTNER	☐	/SAPHT/DRM_TRACK_PARTNER	BU_PARTNER	CHAR	10	0	Tracking partner	*
16	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
17	MS_DR_IND	☐	/SAPHT/DRM_MSDRIND	/SAPHT/DRM_MSDRIND	CHAR	1	0	Indicates manufacturer/supplier or distributor/reseller lot
18	MSBOOKPARTNO	☐	/SAPHT/DRM_MSBOOKPARTNO	MATNR	CHAR	18	0	Manufacturer book part number	*
19	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
20	DR_MATERIAL	☐	/SAPHT/DRM_DR_MATERIAL	IDNEX	CHAR	35	0	Material as maintained in DRM partner's system
21	LOTTYPE	☐	/SAPHT/DRM_LOTTYPE	/SAPHT/DRM_LOTTYPE	CHAR	1	0	DRM lot type
22	SELLTHRUQT	☐	/SAPHT/DRM_SELLTTHRUQTY	MENGV15_3	QUAN	15	3	Reported material quantity in base unit
23	QTY_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
24	DR_STQTY	☐	/SAPHT/DRM_DRSTQTY	MENGV15_3	QUAN	15	3	Quantity as reported by distributor/ reseller
25	DR_QTY_UNIT	☐	/SAPHT/DRM_DRUOM	MEINS	UNIT	3	0	Unit of measure for reported quantity	*
26	DR_QTY_EDI_UNIT	☐	/SAPHT/DRM_ISODRUOM	CHAR3	CHAR	3	0	Reported Unit of measure in IDoc (ISO Format)
27	ALT_STQTY	☐	/SAPHT/DRM_ALTSTQTY	MENGV15_3	QUAN	15	3	Reported quantity in alternative unit
28	ALT_QTY_UNIT	☐	/SAPHT/DRM_ALTUOM	MEINS	UNIT	3	0	Alternative unit of measure for reported quantity	*
29	SALES_REP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
30	END_CUST	☐	/SAPHT/DRM_ENDCST	BU_PARTNER	CHAR	10	0	DRM end customer	*
31	DR_END_CUST	☐	/SAPHT/DRM_DRENDCST	CHAR20	CHAR	20	0	Resale customer as reported by distributor/ reseller
32	EXT_REFNO	☐	/SAPHT/DRM_EXT_CUST_REFNO	CHAR11	CHAR	11	0	Resale customer external reference number
33	ECPARTFN	☐	EDI_3035	EDI_3035	CHAR	3	0	Qualifier for partner function
34	IM_END_CUST	☐	/SAPHT/DRM_ENDCST	BU_PARTNER	CHAR	10	0	DRM end customer	*
35	DR_IM_END_CUST	☐	/SAPHT/DRM_DRENDCST	CHAR20	CHAR	20	0	Resale customer as reported by distributor/ reseller
36	IM_EXT_REFNO	☐	/SAPHT/DRM_EXT_CUST_REFNO	CHAR11	CHAR	11	0	Resale customer external reference number
37	IM_ECPARTFN	☐	EDI_3035	EDI_3035	CHAR	3	0	Qualifier for partner function
38	EC_INV_NO	☐	/SAPHT/DRM_ECINVDOC	CHAR20	CHAR	20	0	End customer invoice number
39	EC_INV_ITM	☐	/SAPHT/DRM_ECINVITM	POSNR	NUMC	6	0	Resale invoice item number	*
40	EC_CM_NO	☐	/SAPHT/DRM_ECCMDOC	CHAR20	CHAR	20	0	End customer return credit memo number
41	EC_CM_ITM	☐	/SAPHT/DRM_ECCMITM	POSEX	CHAR	6	0	End customer return credit memo item number
42	RESALEPRC	☐	/SAPHT/DRM_RESPRC	WERTV6	CURR	11	2	Resale price
43	EDIRESLPRC	☐	/SAPHT/DRM_EDIRESPRC	EDIF5420	CHAR	15	0	Reported resale rate in EDI
44	RESALECURR	☐	/SAPHT/DRM_RESCURR	WAERS	CUKY	5	0	Resale price currency	*
45	EDIRESLCURR	☐	/SAPHT/DRM_EDIRESCURR	EDIF6345	CHAR	3	0	Resale currency in EDI
46	RESL_PRC_UNIT	☐	/SAPHT/DRM_RESPRCUNIT	KPEIN	DEC	5	0	Pricing quantity for resale price
47	RESL_PRC_UOM	☐	/SAPHT/DRM_RESPRCUOM	MEINS	UNIT	3	0	Unit of measure for pricing quantity	*
48	EDIRESLPRCUOM	☐	/SAPHT/DRM_EDIRESPRCUOM	EDIF6411	CHAR	3	0	Resale unit of measurement in EDI item
49	RESL_CON_NUM	☐	/SAPHT/DRM_RESL_COND_NUMER	UMBSZ	DEC	5	0	Numerator for coversion to base unit
50	RESL_CON_DEN	☐	/SAPHT/DRM_RESL_COND_DENOM	UMBSN	DEC	5	0	Denominator for conversion to base unit of material
51	EC_INV_DT	☐	/SAPHT/DRM_ECINVDATE	DATUM	DATS	8	0	Resale invoice date
52	EC_SHP_DT	☐	/SAPHT/DRM_ECSHPDATE	DATS	DATS	8	0	Resale shipping date
53	PROC_STATUS	☐	/SAPHT/DRM_STAGSTAT	/SAPHT/DRM_STAGSTAT	CHAR	1	0	Processing status of staging record
54	COST	☐	/SAPHT/DRM_INVCOST	WERTV6	CURR	11	2	Cost price of material
55	EDICOSTPRC	☐	/SAPHT/DRM_EDICSTPRC	EDIF5420	CHAR	15	0	Reported cost price in EDI line item
56	COST_CURR	☐	/SAPHT/DRM_INVCURR	WAERS	CUKY	5	0	Inventory cost currency	*
57	EDICOSTCURR	☐	/SAPHT/DRM_EDICSTCURR	EDIF6345	CHAR	3	0	Reported cost currency in EDI line item
58	COST_PRC_UNIT	☐	/SAPHT/DRM_INVCOSTUNIT	KPEIN	DEC	5	0	Inventory pricing unit
59	PRC_UOM	☐	/SAPHT/DRM_INVCOSTUOM	MEINS	UNIT	3	0	Unit of measure for inventory cost pricing quantity	*
60	EDICOSTPRCUOM	☐	/SAPHT/DRM_EDICSTPRCUOM	EDIF6411	CHAR	3	0	Cost Unit of measurement in EDI
61	COST_CON_NUM	☐	/SAPHT/DRM_COST_COND_NUMER	UMBSZ	DEC	5	0	Numerator for coversion to base unit
62	COST_CON_DEN	☐	/SAPHT/DRM_COST_COND_DENOM	UMBSN	DEC	5	0	Denominator for conversion to base unit of material
63	INT_BRANCH	☐	/SAPHT/DRM_INTBRANCH	BU_PARTNER	CHAR	10	0	Manufacturer/ supplier's code for reseller unit	*
64	BRANCH	☐	/SAPHT/DRM_BRANCH	CHAR20	CHAR	20	0	Distributor/ reseller's code for reseller unit
65	STOCK_LOC	☐	/SAPHT/DRM_STLOC	CHAR10	CHAR	10	0	Stocking location
66	LOGHANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
67	ERRORCODE	☐	/SAPHT/DRM_ERROR_CODE	CHAR100	CHAR	100	0	Error Code for storing errors in a record
68	REROUTEFLAG	☐	/SAPHT/DRM_RERTFLAG	FLAG	CHAR	1	0	Reroute flag
69	ENDCSTADRNO	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
70	IM_ENDCSTADRNO	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
71	BRADRNO	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
72	TRANS_DATE	☐	/SAPHT/DRM_XNDT	DATS	DATS	8	0	Reported date
73	VAL_MNCUR	☐	VAL_MNCUR	WERTV8	CURR	15	2	Sum of values in the transmission in main currency
74	MN_CURR	☐	MAIN_CURR	WAERS	CUKY	5	0	Manufacturer/ supplier's currency	*
75	.INCLUDE	☐				0	0	Ship and Debit Claim Data
76	CUS_REF_FLD	☐	/SAPHT/DRM_SDCUSREF	/SAPHT/DRM_SDCUSREF	CHAR	35	0	Ship-and-debit claim reference number
77	SD_AGR_NO	☐	/SAPHT/DRM_SDAGRNO	BELNR	CHAR	10	0	Ship-and-debit agreement number
78	SD_AGR_ITM	☐	/SAPHT/DRM_SDAGRITM	POSNR	NUMC	6	0	Ship-and-debit agreement item number	*
79	SD_AGR_RATE	☐	/SAPHT/DRM_SDAGRRATE	WERTV6	CURR	11	2	Ship-and-debit agreement rate
80	SD_AGR_CURR	☐	/SAPHT/DRM_SDAGRCURR	WAERS	CUKY	5	0	Ship-and-debit agreement rate currency	*
81	PRIC_UNIT	☐	/SAPHT/DRM_AGR_PRC_UNIT	KPEIN	DEC	5	0	Ship-and-debit agreement pricing unit
82	SD_AGR_UOM	☐	/SAPHT/DRM_SDAGRCUOM	MEINS	UNIT	3	0	Unit of measure for SD Agreement	*
83	AGRM_CON_NUM	☐	/SAPHT/DRM_AGR_COND_NUMER	UMBSZ	DEC	5	0	Numerator for coversion to base unit
84	AGRM_CON_DEN	☐	/SAPHT/DRM_AGR_COND_DENOM	UMBSN	DEC	5	0	Denominator for conversion to base unit of material
85	REP_AGR_RATE	☐	/SAPHT/DRM_REPAGRRATE	WERTV6	CURR	11	2	Ship-and-debit agreement rate reported by distributor
86	EDI_AGR_RATE	☐	/SAPHT/DRM_EDIAGRRATE	EDIF5420	CHAR	15	0	Reported agreement rate in EDI
87	REP_AGR_CURR	☐	/SAPHT/DRM_REPAGRCURR	WAERS	CUKY	5	0	Currency of reported ship-and-debit agreement rate	*
88	EDI_AGR_CURR	☐	/SAPHT/DRM_EDIAGRCURR	EDIF6345	CHAR	3	0	Agreement currency in EDI
89	REP_PRIC_UNIT	☐	/SAPHT/DRM_REPPRICUNIT	KPEIN	DEC	5	0	Pricing unit for reported ship-and-debit agreement price
90	REP_PRC_UOM	☐	/SAPHT/DRM_REPPRICUOM	MEINS	UNIT	3	0	Unit of measure for pricing quantity	*
91	EDI_PRC_UOM	☐	/SAPHT/DRM_EDIPRICUOM	EDIF6411	CHAR	3	0	Reported agreement unit of measure in EDI
92	AGR_CON_NUM	☐	/SAPHT/DRM_AGR_COND_NUMER	UMBSZ	DEC	5	0	Numerator for coversion to base unit
93	AGR_CON_DEN	☐	/SAPHT/DRM_AGR_COND_DENOM	UMBSN	DEC	5	0	Denominator for conversion to base unit of material
94	REP_CLAIM_AMOUNT	☐	/SAPHT/DRM_REPCLAIMAMT	WERTV8	CURR	15	2	Reported ship-and-debit claim amount
95	EDI_CLAIM_AMOUNT	☐	/SAPHT/DRM_EDICLAIMAMT	EDIF5004	CHAR	18	0	Reported claim amount in EDI
96	REP_CLAIM_CURR	☐	/SAPHT/DRM_REPCLAIMCURR	WAERS	CUKY	5	0	Reported ship-and-debit claim amount currency	*
97	EDI_CLAIM_CURR	☐	/SAPHT/DRM_EDICLAIMCURR	EDIF6345	CHAR	3	0	Claim currency in EDI
98	INV_DOCNO	☐	/SAPHT/DRM_INVDOC_NO	VBELN	CHAR	10	0	Credit/ debit memo number	*
99	INV_DOCITM	☐	/SAPHT/DRM_INVDOC_ITM	POSNR	NUMC	6	0	Credit/ debit memo item number	*
100	RES_IDOCNO	☐	/SAPHT/DRM_RERT_IDOCNO	EDI_DOCNUM	NUMC	16	0	Response IDoc number
101	DESIGN_REG_NO	☐	/SAPHT/DRM_DESIGN_REG_NO	CHAR30	CHAR	30	0	Design registration number
102	.INCLUDE	☐				0	0	DRM Structure for tracking Created By/Changed By...
103	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
104	CREATED_DT	☐	/SAPHT/DRM_CRDATE	DATUM	DATS	8	0	Created on
105	CREATED_TM	☐	C_TIME	UZEIT	TIMS	6	0	Time created
106	LASTCHGDBY	☐	UPNAM	USNAM	CHAR	12	0	Last Changed By
107	LASTCHGDDT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
108	CHANGED_TM	☐	AS4TIME	AS4TIME	TIMS	6	0	Last changed at
109	.INCLUDE	☐				0	0	Addtional Fields to be stored in DRM Transaction tables
110	DUMMY_1	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20130529
SAP Release Created in