Question Re: Generic DataSource Purchase Requisition [EBAN & EBKN] in Technology Q&A

Generic DataSource Purchase Requisition [EBAN & EBKN]

Former Member — Thu, 26 Dec 2013 21:29:49 GMT

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.

Re: Generic DataSource Purchase Requisition [EBAN & EBKN]

Former Member — Fri, 27 Dec 2013 09:19:37 GMT

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

Re: Generic DataSource Purchase Requisition [EBAN & EBKN]

MGrob — Sun, 29 Dec 2013 09:41:58 GMT

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

hope that helps

Martin

Re: Generic DataSource Purchase Requisition [EBAN & EBKN]

former_member182465 — Sun, 29 Dec 2013 15:39:53 GMT

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.

Re: Generic DataSource Purchase Requisition [EBAN & EBKN]

former_member182465 — Sun, 29 Dec 2013 16:27:42 GMT

This message was moderated.

Re: Generic DataSource Purchase Requisition [EBAN & EBKN]

Former Member — Thu, 02 Jan 2014 09:27:00 GMT

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)

Re: Generic DataSource Purchase Requisition [EBAN & EBKN]

Former Member — Thu, 02 Jan 2014 10:49:23 GMT

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