Skip to Content
avatar image
Former Member

Migration - Customer & Vendors - Selection Criteria - movement in the past

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 07, 2015 at 09:16 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded