Skip to Content
author's profile photo Former Member
Former Member

Generic DataSource Purchase Requisition [EBAN & EBKN]

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Dec 29, 2013 at 03:39 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 02, 2014 at 10:49 AM

    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


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2013 at 09:19 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 29, 2013 at 09:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 09:27 AM

    Hi,

    take a look at How to Create Generic DataSources Which Use the Delta Queue (NW2004)

    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)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.