SAP ABAP Table MCHTMS0DRM (DRM: BW Extraction Structure)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-HT-DRM (Application Component) Distributor-Reseller-Management
     ⤷ DRM11 (Package) DRM --> BW Extraction

Basic Data

Table Category	INTTAB	Structure
Structure	MCHTMS0DRM	Table Relationship Diagram
Short Description	DRM: BW Extraction Structure

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C1