cancel
Showing results for 
Search instead for 
Did you mean: 

Logic of EKPO-Elikz value in 2LIS_02_ITM extractor

igorpw
Explorer
0 Kudos
364

Hi there,

Currently I'm trying to figure out what the logic is behind determining the most recent 'Delivery Completed Indicator' (2LIS_02_ITM-ELIKZ) value ('True' or 'False).

When looking in the EKPO table, you'll get an 'X' in the Elikz field when completed, however in the extractor you do not have simply one row with the most recent value, you'll have multiple rows and fields that are determining which is the most recent Elikz value.

With the following query, I came quite close, but it's definitely not the final logic being used in SAP.

            SELECT
                ebeln,ebelp,bwvorg,elikz,sum(aktwe) aktwe,sum(alief) alief,client
            FROM [EDW].[2LIS_02_ITM]
            WHERE 1=1
			and Bwvorg = 2
			and Rocancel = 'False'
            GROUP BY
                ebeln,ebelp,bwvorg,elikz,client
            HAVING SUM(alief) > 0

I noticed for instance that there are also many of the Elikz values that are recent, are actually when: bwvorg = 1 and Budat_dtm is null. But if I take that as a starting point, I'll also end up with the incorrect values.

Unfortunately for us there isn't a workaround via material movements, since the users ocassionally put the indicator on 'True' or 'False' manually.

Can anyone help me understanding the actual logic behind the 'Delivery Completed Indicator' in SAP?

Kind regards,

Igor

former_member34
Product and Topic Expert
Product and Topic Expert

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with our Q&A Tutorial: https://developers.sap.com/tutorials/community-qa.html, as it provides tips for preparing questions that draw responses from our members. Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

Many thanks!

Accepted Solutions (0)

Answers (0)