on 10-06-2015 9:16 PM
Hello Together,
The functional selection criteria for the customers & vendors is defined as:
- all customers and vendors with movements in the past X years
as per my understanding one has to check all possible documents like sales documents:
1) select all sales documents, that have been created/changed in the past 2 years
2) check all tables with entries related to the selected sales documents (VBAK, VBAP, V...)
3) check all fields with domain equal to KUNNR and select the respective values
Is there another more simple way to select the required data?
Thanks
Amin
No, there is no simpler way, actually contrary, you would need to do even more selects to avoid missing some important business partners.
you would need to check the special stock tables, it could be that there is consignment stock at a customer or subcontract stock at a vendor and nobody cared about it for several years, and you won't find documents in the selected time frame either. But they have to be migrated too otherwise the stock migration will fail.
Further you have analyze the partner functions. It happens quite often that a vendor or customer gets a deletion flag and nobody had evaluated if they are used as partners in other customers and vendors. The same might happen if you exclude customers from migration that had no sales in the given period.
when you extract the customers and migrate them then you will find customer numbers for partners which were not migrated and finally a mandatory partner is missing, and because of that you can't load this customer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
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.