Data Extraction: SBIW

[Former Member]

Dear DP Admin Experts,

I have a sales item data source (business content data sources) that I am replicating to APO .

I need to update key figures in the target infocube based on what item category the Product x Customer belongs to. A particular item category means free goods and rest mean paid goods. This is to make a distinction between free goods and paid goods in sales history.

How do I do this ?

Thanks

Guru.

[rajkj · Accepted solution]

Hi Guru,

The Sales Document Item's item category (PSTYV) and Sales Document Schedule Line's category (ETTYP) provide the information that you described. If extract data from Sales Doc Item and schedule line data sources, you can build a simple logic to verify the values and populate the required key figures selectively.

Thanks,
Rajesh

[Former Member · Accepted solution]

Thanks Rajesh,

Being a first timer, I was struggling to imagine how to do this. I am yet to replicate the datasources for vbap and vbep tables. 

Let me see If I am able to do this without scary messages

Thanks

Guru