Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Why is that the latest entry in EKBE doesn't have the latest BELNR?

walkerist
Participant
0 Kudos
378

Hi, I was encountering an issue where in the latest entry in EKBE table doesn't have the latest BELNR. Is this a normal working condition? as you can see below, the row which is highlighted in yellow is the latest entry in EKBE. However, its BELNR is less than the entry below it. Shouldn't the BELNR be in incremental sequence of 1?

5 REPLIES 5

shantraj
Explorer
0 Kudos
292

screenshot-2022-12-15-132932.png

I think, the entries sorted on Document number and Credit Indicator.

U can add one more entry with other credit indicator for the same document number and check where it will come and sit.

FredericGirod
Active Contributor
0 Kudos
292

What is this transaction ?

raymond_giuseppi
Active Contributor
0 Kudos
292

Check your FI/MM number ranges Customizing, not every document type uses the same range, only similar documents will share a common range. Try to sort first by VGABE / Transaction/event type (good movements, invoices, etc.) or BEWTP / Category of document

0 Kudos
292

Depending on the event type BELNR doesn't refer the same type of object,

Look at

    CASE <ekbe>-bewtp.
      WHEN 'E' OR 'O' OR 'U'.
        <ekbe>-tcode = 'MB03'. " material movement
      WHEN 'L' OR 'J'.
        <ekbe>-tcode = 'VL03N'. " delivery
      WHEN 'D'.
        <ekbe>-tcode = 'ML81N'. " Service Entry
      WHEN 'N' OR 'Q' OR 'W'.
        <ekbe>-tcode = 'MIR4'. " Invoice
      WHEN 'K'. 
        <ekbe>-tcode = 'MR11SHOW'. " Account maintenance document
      WHEN 'T'.
        <ekbe>-tcode = 'MR43'. " parked document
      WHEN OTHERS.
        <ekbe>-tcode = 'FB03'. " financial document
    ENDCASE.

Display the history within ME23N and navigate to display transaction with some double-clicks.

raymond_giuseppi
Active Contributor
0 Kudos
292

Could you add one of the following fields to your screenshot:

  • VGABE / Transaction/event type
  • BEWTP / Type of document

Then sort by this type and system date/time creation