Logic of EKPO-Elikz value in 2LIS_02_ITM extractor

[igorpw]

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]

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!