4 Replies Latest reply: Apr 17, 2011 11:08 PM by amit kumar mahapatra RSS

EKBE table extraction

Marek Kapanowski
Currently Being Moderated

Hi Experts,

There is no standard extractor for EKBE table, that is why I have decided to create generic data source based on FM with delta update. Is it good idea?

Which field could I use as delta field? We have a few millions entries, so that full update is not good idea.

 

Regards&thanks in advance

Marek

  • Re: EKBE table extraction
    Arminder Singh
    Currently Being Moderated

    Hi,

     

    If you need only a couple of fields then why dont you enhance 2LIS_02_ITM from EKBE table(that's if u r using PO Item DS)? Otherwise you can go with the generic extractor for sure. And you can use BUDAT for delta.

     

    Regards,

    Arminder

  • Re: EKBE table extraction
    Huseyin Akturk
    Currently Being Moderated

    Hi,

     

    I know at least 2 ds: 2lis_02_cgr, 2lis_02_sgr.

  • Re: EKBE table extraction
    ASHUTOSH SINGH
    Currently Being Moderated

    Hi ,

     

    I have built a datasource on EKBE and EKBEH both . This table shows purchase order history related for a purchase order like GR date and IR date etc . There are two approaches which you use to pull the data from EKBE table . In my case i only wanted to pull out the data based on specific movement types .

     

    1) Build a generic datasource on this table . And at the infopackage level write a routine for the field GJAHR (Material Document Year) . The logic for thsi routine will be based on the current date, take out the year . So based on this logic it will always pull the data for the current year.

     

     

    2) Or build a generic datasource . Enable delta based on BUDAT to pull the data . But in this approach i am not sure whether a entry coming in this table is updated only once . Because if the same combinaton of primary keys is getting updated twice in this table , then there is a chance of missing the data . Better consult a functional consultant regarding this . He will be able to tell you as to how this table gets updated during a standard MM flow .

     

     

    Hope this reply was helpful.

     

     

    Thanks & regards,

    Ashutosh Singh

  • Re: EKBE table extraction
    amit kumar mahapatra
    Currently Being Moderated

    Yes you can enhance 2LIS_02_ITM to get EKBE field info..this is the best way..but if at all u need many then yes you can create one new but i would prefer going fo a View on EKBE table with BUDAT field.

Actions