topic Create a column in Application Development and Automation Discussions

Create a column

former_member713424 — Mon, 16 Nov 2020 10:23:07 GMT

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.

Re: Create a column

RaymondGiuseppi — Mon, 16 Nov 2020 10:38:21 GMT

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

Re: Create a column

Abinathsiva — Mon, 16 Nov 2020 17:22:44 GMT

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...

Re: Create a column

Patrick_vN — Mon, 16 Nov 2020 19:32:57 GMT

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")