Create a column

[former_member713424]

Hi,

i have this request in my report:

8 – Enter in LIPS with:

LIPS-VGBEL = VBAP-VBELN

LIPS-VGPOS = VBAP-POSNR

If a record I found, fill the column DELIVERED with ‘X’

Else fill the column DELIVERED = ‘ ‘ .

i have to create this column.

[RaymondGiuseppi]

Add this column in your displayed structure, what is your exact problem?

[Abinathsiva]

Hi,

Assuming your question where 8 refers vgabe value @ekbe table so, passing the delivery number and item number to likp - lips then make mark a delivery in your custom program.. here if entry is available in Ekbe with movement type then delivery is completed unless for same EBELN and VGABE 8 with reversal movement type...

[Patrick_vN]

Depending on your NW version, you might consider adding this check to your openSQL statement combining the LEFT OUTER JOIN- and CASE-statements to create/fill the additional 'DELIVERED'-column containing the flag you want. That way you have the desired result automatically.

But of course that only works if there is an SQL statement..

(and in the CASE-part of the SQL you check the content of one of the fields of the joined table. If it is null, there is no "outer-join-record")