Skip to Content
0
Sep 16, 2010 at 11:45 AM

FOR ALL ENTRIES IN - For Batch Split & multiple items

71 Views

Hi,

My Report is to find Production Order from Sale Order.

Flow of tables -

(VBAK- VBAP- LIPS - SER01 - OBJK - SER05 - CAUFV)

Report is working accurate in normal scenario. But -

Here, In Batch split with multiple items -->

FOR ALL ENTRIES IN - is not taking values.

one case for Ex-->

sale order   so item        obdelivery           obd item           serial no
39782            10             1234              900001                 12
39782            10             1234              900002                 13
39782            20             3456              10                     14

Here,

only one OBD 1234 (sr no 12 & 13 ) is get entered in ITAB and not 3456.

(i.e. in gi_objkso all 3 entries are there, but in gi_objkpo only two entries are transferred)

Where, Production order is there for all three Sr. No.

My code is -->

IF NOT gi_ser01 IS INITIAL.
          SELECT obknr equnr sernr matnr
                 FROM objk
                 INTO TABLE gi_objkso
                 FOR ALL ENTRIES IN gi_ser01
                 WHERE obknr EQ gi_ser01-obknr
                   AND equnr IN so_equnr
                   AND sernr IN so_sernr
                   AND matnr IN so_matnr
                   AND taser EQ 'SER01'.
          IF NOT gi_objkso IS INITIAL.
                       SELECT obknr equnr sernr matnr
                   FROM objk
                   INTO TABLE gi_objkpo
                   FOR ALL ENTRIES IN gi_objkso
                   WHERE sernr EQ gi_objkso-sernr
                     AND equnr EQ gi_objkso-equnr
                     AND matnr EQ gi_objkso-matnr
                     AND taser EQ 'SER05'.