cancel
Showing results for 
Search instead for 
Did you mean: 

Business Content Extractor for KONA table

Former Member
0 Kudos

Hi,

I'm doing a BI sales report and will have to filer on agreement type.

In the transactional data from 2LIS_13 I have the agreement number.

Therefor I am looking for a Business Content infoobject that reads master data for the agreement (e.g. agreement type etc from the KONA table)

I have found 0WS_AGREEMT_ATTR extractor that reads from KONA table (view V_BI_KONA)

but only extracts purchasing agreements (KONA --> KAPPL='M')

Does anyone know of any Business Content extractor that reads from KONA without the

selection Condition KAPPL='M'?

The alternative would be to create a generic datasource, but I wanted to explore the knowledge in this forum first.

Thanks,

Tobias

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member202718
Active Contributor
0 Kudos

Hi Tobias,

Try Enhancing 0WS_AGREEMT_ATTR extractor  with KAPPL with ZKAPPL...

regards

SVU

Former Member
0 Kudos

Dear,

Is the condition hard coded somewhere to read only KAPPL = 'M', Is it possible to remove this if it is used as filter? You might try to use SAP enhancements if you want to remove this condition so that all kind of type comes.

Other way is as you said to go for generic one, bring all required fields that you want from KONA and get those selected only. Question is that how would use delta here?

Thanks & Regards,

M

dkle
Participant
0 Kudos

Hi,

it is not hard coded in the extractor, but the view V_BI_KONA contains a selection for KAPPL = 'M' itself. It is not possible to get all data without modification.

dkle
Participant
0 Kudos

This message was moderated.