We need to extract Partner functions for Customer. Can anyone please look at the below options and suggest me the best one...
1. Enhance 0CUST_SALES with Z field's for Sold-To,Ship-To,Bill-To,Mark-for and Payer and then user exit code to populate them with values from KNVP.
Pro's : Would be a straight forward enhancement
Con's: If a customer has multiple Ship-To's, i can only take one of them. Also if a partner function changes it will not be included in delta load.
2. Build a Generic DS on KNVP and then in BW enhance or join 0CUST_SALES with generic ds on KNVP.
Pro's: Con's from the first point
Con's :KNVP doesn't have any date field. This can't be a Delta extractor. Need to do Full load.
If second option is the good one, please do advise on how i would merge data from 0CUST_SALES with Generic DS data..Infoset on two master data objects or Multiprovider or Master data and ODS(Generic DS).
Appreciate any help.
Thank you,
PVK