Skip to Content

EKBE & EKET

hi,

i´m working on a report using Logical DataBase

MEPOLDB

.

The problem i´m facing is that there are several entries of ekbe-menge for a single entry of eket-menge.

is there a relationship between ekbe-menge ekbe-bldat and eket-menge eket-sfldt?

Any help would be greatly appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 07, 2005 at 11:44 PM

    Sorry, but without knowing more about what you are trying to do this will be a difficult question to answer. EKBE is the line item history for the purchasing doc. It lists related movements that have posted against the PO.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Pablo Casamayor

      Hi calsadillo,

      the point is, it's quite normal that there are several entries in table EKBE for a single position of a purchase order. Table EKBE stores every goods-receipt movement and every invoice posted to one single position of a purchase order. So if you want to retrieve just one record from table EKBE, I think it's not possible.

      But: depending on what you want to do, you could write some sort of

      select shkzg sum(menge)
      into corresponding fields of ekbe
      from ekbe
      where ebeln = ...
      and ebelp = ...
      group by vgabe
      

      ...and then you will have, for instance, two records: one for debit positions (shkzg = S), and one for credit positions (shkzg = H). Then you could say:

      if ekbe-shkzg = 'H'.
        ekbe-menge = ekbe-menge * ( -1 ).
      endif.
      

      ...and continue with the summarization.

      Please let us know if it helped. Best regards,

      Alvaro

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.