how to extract partner function data from VBPA through generic DS?

[former_member182467]

Hi Folks,

We have a requirement to extract the Partner function PARVW = 'zc' from VBPA. Please find my below points and advise.

1) There is no date field in VBPA to extract the delta through generic ds. ( where I will lookup with the SO and populate the value for PARVW = ZC).

2) I need to combine VBAP and VBPA as I need the ZC value for all the SO's along with item level.

3) There are few SO' with the item number blank in VBPA, how do I extract the data based on a view if I put the below condition, its not extracting the data with SO item = blank from VBPA. There are few SO in VBPA where the ZC value is maintained at the header level as well.

4) Do we have any standard DS on VBPA table ?

Please advise if I am not clear.

Thanks

DR

[ranganath_korata · Accepted solution]

Hi Daniel,

I believe the view will not help in your situation as the data in the Key fields of the two tables is not consistent. You are better off enhancing the standard VBAP extractor to fetch records from VBPA. Alternately, you can do a Full on VBPA with a Selection, and write the logic in the transformation in BW. We are doing the latter in our system due to the small volume of data in our VBPA table for the Selection that we are interested in.

Thanks,

Ranga

[former_member182467 · Accepted solution]

Hi Ranganath,

Thanks for the reply. Actually I thought its a trans DS and it will have huge data....but to my surprise it has only 95k rec and I think its a better approach as well to go with the full update .

Thanks for the thought. It helped.

Cheers

DR

[Former Member]

Hi Daniel,

Try using in your view first vbap table and then join with vbpa, so you will have dates from vbap table and in selection conditions you can put VBPA table, PARVW field = in operator and the value ZC in comparison.

Regards,

Gorka.

[former_member182467]

Hi Gorka,

I tried the same, but its not extracting the VBPA records with the item number is blank. ...As there is a chance that some SO's have ZC at the header level and in those records, item is blank in VBPA, and its not extracting those records. You mean the order of tables in the join conditions will make sense ?

Can you please advise , if I did nt get your point.

Cheers

DR

[Former Member]

Hi Daniel,

You can use 2LIS_11_VAITM extractor and enhance it in CMOD with a select to VBAP entering by VBELN and POSNR.

Regards,

Gorka.