Generic DataSource Purchase Requisition [EBAN & EBKN]

[Former Member]

I believe that many here have had the need to create a generic datasource purchase requisitions between the tables EBAN and EBKN.

This is a trivial knowledge, but there are many doubts in the community and no solid document demonstrating the development of a datasource between EBAN and EBKN.

Someone who has this experience can share the solution with us?

Grateful.

[former_member182465 · Accepted solution]

Hi Marcos,

It depends on your requirement.

If you directly need just data from the 2 tables as you mentioned just see if any SAP has provided. If not then you can create a  view directly on table.

If you need any further help on creating a view just search in sdn for creating a view. Sometimes you will not get help directly as you require(EBAN,EBKN). Try to understand the document on view and try to use that for your tables

If you have any calculations based on some conditions .... then you need to go with the extractor function module.

[former_member182465 · Accepted solution]

This message was moderated.

[Former Member]

Hi Andre,

yes its possible to create a generic data source on top of these 2 tables.

- Create a view on 2 table EBKN and EBAN. use the join condition to create a view.

- Create a generic data source.

use this view while creating a generic data source.

--> This will be full load data source ... not delta enabled

If you want to create a generic data source which is delta enabled then you need to create a function module where you can use the view as your structure in FM and also you need to consider the change document tables (CDHDR and CDPOST with OBJECTID = 'BANF') in the logic and extract the delta. this is a bit tricky but possible, you can take help of ABAP person to full this requirement.

Hope this info helps ...

Regards

KP

[Former Member]

Hi,

take a look at

Which is a very interesting example for purchase requisition delta extraction (but of course you can ignore the delta related part if you don't need it)

[MGrob]

Hi

Try to create a datasource based on a view which joins EBAN and EBKN with the key MANDT;BANFN ;BNFPO

hope that helps

Martin

[Former Member]

Hi,

This is based on requirement; so if you are going for generic datasource you can start from requirement as nothing is available as of now to you.

Regards,

Ganesh