SAP ABAP Table DRMXMSTR (LIS Communication Structure for DRM)

Hierarchy

☛

ECC-DIMP (Software Component) DIMP
⤷

IS-HT-DRM (Application Component) Distributor-Reseller-Management
⤷

DRM4 (Package) Development class for LIS structures

Basic Data

Table Category	INTTAB	Structure
Structure	DRMXMSTR	Table Relationship Diagram
Short Description	LIS Communication Structure for DRM

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
2	SALES_ORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
3	DIST_CHNL	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
4	DIVN	SPART	SPART	CHAR	2	0	Division	*
5	PARTNER	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
6	TRK_PRNR	TRK_PRNR	BU_PARTNER	CHAR	10	0	Tracking partner	*
7	TRANSM_NO	TRANSM_NO	CHAR20	CHAR	20	0	Transmission number
8	TRANSM_DT	TRANSM_DT	DATS	DATS	8	0	Date of EDI transmission
9	INT_XMNO	INTXMNO	CHAR20	CHAR	20	0	Internal transmission number
10	IDOC_TYPE	EDI_DOCTYP	EDI_DOCTYP	CHAR	8	0	IDoc Type
11	MSG_TYPE	EDI_MESTYP	EDI_MESTYP	CHAR	30	0	Message Type	*
12	MAIN_CURR	MAIN_CURR	WAERS	CUKY	5	0	Manufacturer/ supplier's currency	*
13	TXMN_CURR	TXMN_CURR	WAERS	CUKY	5	0	Currency in which transmission data has been reported	*
14	VAL_TXCUR	VAL_TXCUR	WERTV8	CURR	15	2	Sum of values in EDI transmission in transmission currency
15	VAL_MNCUR	VAL_MNCUR	WERTV8	CURR	15	2	Sum of values in the transmission in main currency
16	TOT_LINES	TOT_LN	/SAPHT/DRM_XMLNS	DEC	8	0	Total number of lines in EDI transmission
17	TOT_VWLN	TOT_VWLN	/SAPHT/DRM_XMLNS	DEC	8	0	Total Number of Viewed Lines
18	TOT_ERLN	TOT_ERLN	/SAPHT/DRM_XMLNS	DEC	8	0	Total number of errored lines in EDI transmission
19	VAL_ERLN	VAL_ERLN	WERTV8	CURR	15	2	Sum of values in errored lines in main currency
20	TOT_DLLN	TOT_DLLN	/SAPHT/DRM_XMLNS	DEC	8	0	Total number of deleted lines in EDI transmission
21	VAL_DLLN	VAL_DLLN	WERTV8	CURR	15	2	Sum of values in deleted lines in main currency
22	TOT_MNLN	TOT_MNLN	/SAPHT/DRM_XMLNS	DEC	8	0	Total number of Manual lines in a transmission
23	EFF_DATE	EFF_DATE	DATS	DATS	8	0	Effective date of EDI transmission
24	STATUS	XM_STATUS	/SAPHT/DRM_XM_STATUS	CHAR	1	0	Transmission status
25	DUPL_STAT	DUPL_FD	/SAPHT/DRM_DUPL_STAT	CHAR	1	0	Duplicate feed indicator for EDI transmission
26	TRAN_TYPE	PROCCODE	/SAPHT/DRM_PROCCODE	CHAR	2	0	DRM relevant processing code
27	MN_CURR	MN_CURR	CHAR5	CHAR	5	0	Manufacturer/ supplier's currency
28	TX_CURR	TX_CURR	CHAR5	CHAR	5	0	Currency in which transmission data has been reported
29	ENDCUST	END_CUST	BU_PARTNER	CHAR	10	0	Customer to whom distributor/ reseller made resale	*
30	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
31	STWAE	STWAE	WAERS	CUKY	5	0	Statistics currency	*
32	BASME	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
33	SDQTAPP	SDQTAPP	MENGV15_3	QUAN	15	3	Ship-and-debit claim quantity approved
34	SDAMAPP	SDAMAPP	WERTV8	CURR	15	2	Ship-and-debit claim amount approved
35	SDQTCLM	SDQTCLM	MENGV15_3	QUAN	15	3	Ship-and-debit claim quantity sent by distributor/ reseller
36	SDAMCLM	SDAMCLM	WERTV8	CURR	15	2	Ship-and-debit claimed amount
37	PPQTCR	PPQTCR	MENGV15_3	QUAN	15	3	Price protection claim approved quantity
38	PPAMCR	PPAMCR	WERTV8	CURR	15	2	Price protection approved amount
39	PPQTDB	PPQTDB	MENGV15_3	QUAN	15	3	Price protection claimed quantity
40	PPAMDB	PPAMDB	WERTV8	CURR	15	2	Price protection claimed amount
41	BLQTCLM	BLQTCLM	MENGV15_3	QUAN	15	3	Bill-up claim quantity
42	BLAMCLM	BLAMCLM	WERTV8	CURR	15	2	Bill-up claim amount
43	STQTNL	STQTNL	MENGV15_3	QUAN	15	3	Quantity of material resold from normal lot
44	STQTBP	STQTBP	MENGV15_3	QUAN	15	3	Quantity of material resold from special buy lot
45	STAMNL	STAMNL	WERTV8	CURR	15	2	Value of resale from normal lot
46	STAMBP	STAMBP	WERTV8	CURR	15	2	Value of resale of material from special buy lot
47	ERTQTNL	ERTQTNL	MENGV15_3	QUAN	15	3	Quantity of material returned by resale customer
48	ERTQTBP	ERTQTBP	MENGV15_3	QUAN	15	3	Resale return quantity from special buy lot
49	ERTAMNL	ERTAMNL	WERTV8	CURR	15	2	Refund amount against resale return from normal lot
50	RTQTBKP	RTQTBKP	WERTV8	CURR	15	2	Refund amount against resale return from special buy lot
51	RTNMQYGR	RTNMQYGR	MENGV15_3	QUAN	15	3	Return quantity issued/ received from normal lot
52	RTBPQYCM	RTBPQYCM	MENGV15_3	QUAN	15	3	Return quantity from special buy lot approved for refund
53	DRTAMNL	DRTAMNL	WERTV8	CURR	15	2	Refund amount for sales return from normal lot
54	DRTAMBP	DRTAMBP	MENGV15_3	QUAN	15	3	Sales return quantity from special buy lot
55	DRTQYNAP	DRTQYNAP	MENGV15_3	QUAN	15	3	Normal price lot return quantity approved for refund
56	DRTAMBAP	DRTAMBAP	WERTV8	CURR	15	2	Refund amount approved against return from special buy lot
57	SIQYNLGI	SIQYNLGI	MENGV15_3	QUAN	15	3	Goods Issue quantity for normal lot sale to distributor
58	SIQYNLIV	SIQYNLIV	MENGV15_3	QUAN	15	3	Invoiced quantity for normal lot sale to distributor
59	SIAMNL	SIAMNL	WERTV8	CURR	15	2	Normal lot invoice amount
60	SIQYBPGI	SIQYBPGI	MENGV15_3	QUAN	15	3	Special buy lot quantity sold to distributor/ reseller
61	SIQYBPIV	SIQYBPIV	MENGV15_3	QUAN	15	3	Special buy invoiced quantity
62	SIAMBP	SIAMBP	WERTV8	CURR	15	2	Special buy invoice amount
63	PCRQYNL	PCRQYNL	MENGV15_3	QUAN	15	3	Increment applied on normal lot quantity for reconciliation
64	PCRQYBP	PCRQYBP	MENGV15_3	QUAN	15	3	Increment applied to special buy quantity for reconciliation
65	NCRQYNL	NCRQYNL	MENGV15_3	QUAN	15	3	Reduction applied for reconciliation of normal lot quantity
66	NCRQYBP	NCRQYBP	MENGV15_3	QUAN	15	3	Reduction applied to special buy quantity for reconciliation
67	STADAT	STADAT	DATUM	DATS	8	0	Statistics date
68	PURCH_ORG	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
69	PLANT	EWERK	WERKS	CHAR	4	0	Plant	*
70	STQYNLIV	STQYNLIV	MENGV15_3	QUAN	15	3	Invoice quantity of material resold from normal lot
71	STQYBPIV	STQYBPIV	MENGV15_3	QUAN	15	3	Invoice quantity for material resold from special buy lot
72	STAMNLIV	STAMNLIV	WERTV8	CURR	15	2	Invoice amount for resale from normal lot
73	STAMBPIV	STAMBPIV	WERTV8	CURR	15	2	Invoice amount for resale from special buy lot
74	STQYNLGI	STQYNLGI	MENGV15_3	QUAN	15	3	Goods issue quantity of material resold from normal lot
75	STQYBPGI	STQYBPGI	MENGV15_3	QUAN	15	3	Goods issue quantity of material resold from special buy lot
76	DSQYNL	DSQYNL	MENGV15_3	QUAN	15	3	Drop ship quantity from normal lot
77	DSAMNL	DSAMNL	WERTV8	CURR	15	2	Drop ship amount for normal lot
78	DSQYBP	DSQYBP	MENGV15_3	QUAN	15	3	Drop ship quantity from special buy lot
79	DSAMBP	DSAMBP	WERTV8	CURR	15	2	Drop ship amount for special buy lot
80	WAERK	WAERK	WAERS	CUKY	5	0	SD document currency	*
81	KURSK_DT	WWERT_D	DATUM	DATS	8	0	Translation date
82	HWAER	HWAER	WAERS	CUKY	5	0	Local Currency	*
83	KURSK	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
84	STCUR	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
85	STDSQYNL	STDSQYNL	MENGV15_3	QUAN	15	3	Drop-ship quantity from normal lot
86	STDSAMNL	STDSAMNL	WERTV8	CURR	15	2	Amount for drop-ship resale from normal lot
87	STDSQYBP	STDSQYBP	MENGV15_3	QUAN	15	3	Drop-ship quantity from special buy lot
88	STDSAMBP	STDSAMBP	WERTV8	CURR	15	2	DRM Drop Ship (Special Price) Amount Sell Through