cancel
Showing results for 
Search instead for 
Did you mean: 

Can we extract all items for each document from 0FC_BP_ITEMS ?

Former Member
0 Kudos

Hi  Friends,

We are trying to extract all the item level details from Data source -  0FC_BP_ITEMS (FI-CA Business Partner Items) But we find more than one line item details for each document in table DFKKOPK (Items in contract account document), However the same is not showing from RSA3.

Please can you advise, if there any other dataSource to bring all the item level details to extract.

Regards

TT

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Not sure about the standard datasource for extraction.

http://scn.sap.com/thread/3355600

Here Generic DS was created for the same table. Also this table will contain lot of data records so routine was written accordingly to pick up the data. Have a go through, might be helpfull.

Br,

Arpit

former_member183012
Active Contributor
0 Kudos

Hi,

I think whatever datasource you mentioned that is correct.

This DataSource extracts all business partner items, both open as well as cleared items, in the plugged-in OLTP system. All statistical items are also included in this. Repetitions in DFKKOPW are mixed with sample item data in DFKKOP and extracted to the BI system.

The transfer structure contains only the standard fields. If you require invisible fields to be delivered with your applications&evaluations in the DataSource, you must convert the fields in the plugged-in OLTP system as visible and replicate the DataSource in the BI system.

I would suggest please crosscheck with R/3 and BI once again.

Regards,

Ganesh Bothe

Former Member
0 Kudos

This message was moderated.