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