logic as "If Sales Document / Order Item in Orders DSO has no corresponding Sales Document / Order Item in Despatches DSO then 1 else 0 to target DSO

[former_member210874]

Hi Gurus,

We have a requirement of writing logic on Sales document/Order Item from sources.

Scenario:

Here the scenario is, we have the two DSO's 1) Orders and 2) Despatches at source level and we are loading Orders, Despatches source level DSO's to target DSO with Sales Document/Order Item as Key fields.

We need to write logic as "If Sales Document / Order Item in Orders DSO has no corresponding Sales Document / Order Item in Despatches DSO then 1 else 0 to target DSO.

Please guide.

Thanks,

Pavan kumar

[Former Member]

Hi Pavan,

please try the below.

Data : IT_DSO1 type STANDARD TABLE OF /BIC/(dso active table),

           WA_DSO1  TYPE /BIC/(dso active table).

SELECT SALES DOC

               ORDER ITEM

  FROM /BIC/........(dso active table)

INTO CORRESPONDING FIELDS OF TABLE IT_DSO1.

loop at IT_DSO1 into WA_DSO1.

    loop at result_package assigning <result_fields>.

   if <result_fields>-sales doc NE WA_DSO1-sales doc   or <result_fields>-order item NE WA_DSO1-order item.  

     New field(result) = 0

    else

    New field(result) = 1.

     endif.

    endloop.

endloop.

Regrads,

Fathima.

[former_member210874]

Hi Fathima,

Your code seems to be comparing only DSO1 Sales document/Item. Here my requirement is i need to compare Sales Document/Item of DSO1 with Sales Document/Item of DSO2 before going to target DSO3.

Thanks & Regards,

Pavan Kumar