on 11-18-2011 2:05 PM
Hi All,
In SAP IS retail, i need the table name where i can get the first sales date for an article at site level. Here the sales may happen through sales order and as well through POS (for which sales order is not available).
I can get this information based on movement type by using MSEG/MKPF table, but since we have many records in this table it creates performance issue. Is there any other table name or option to get the first sales date for an article at site level.
Regards,
Prabu
Hi
Two options:
1. Search the first mov 251 (it's the usual movement while you create the invoice type FP) for this plant, but usually, in IS-R systems, MSEG is a huge table.
2. Search the first item in invoice. See Note 185530 - Performance: Customer developments in SD to know the proper table to search it.
3. Create your own LIS to store this type of information (from stock mov or from invoice) with the conditions that you need.
I hope this helps you
Regards
Eduardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kemal,
Wellcome to SDN. The meaning of IS Retail? IS is industry solution for retail companies. Think in a supermarket. You don't have the typical flow of SO, delivery and invoice. The customer goes to the supermarket, get the goods, do a check-out in a point of sale (POS) and pay. This POS use a software, non-SAP, that build a file with a sales aggregation. This information use to be populated in SAP with the IDOC type WPUUMS. Thsi IDOC build the invoice (type FP), movements by sale (instead the movements from PGI of deliveries, for instance, the mov. 601) and some LIS (logistic information system) for Retail (RIS) as S120 and so on.
I hope this helps you
Regards
Eduardo
Edited by: E_Hinojosa on Nov 21, 2011 9:45 AM
User | Count |
---|---|
98 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.