Customer Partner functions

[Former Member]

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

[Former Member · Accepted solution]

Thats OK. You must be careful with the the keys in the DSOs.

Ravi Thothadri

[Former Member]

I will go with the first one. If you have more than one ship to for a customer, if you have a business rule, you can apply and bring onle one. You can try in the exit code.

The second involve maintaining one more data source, info source, etc. and even then you have to handle multiple ship to for a customer.

Ravi Thothadri

[Former Member]

Ravi,

Thank you for immediate response.

I guess we need to bring Multiple Ship to's. If i need Multiple Ship to's, then i guess i definitely need to go with the second option.

If i go with the second option, please do advise if this will be the right approach.

Create Generic DS on KNVP with Full upload into a DSO in BW. Infoset on 0CUST_SLAES and the DSO.

Please do advise .

Thank you,

PVK

[Former Member]

Please do advise ......