Hi all
This is regarding Contract1 , which has a Building assigned to it ( BU ) , further i assign this BU to another Contract say Contract2.
Now my requirement is to Extract the data for all those contracts which have a BU which is further assigned to a contract2.
What i do is : i have to retrieve the data from the table VIBDBU ( BU table ) , with Objnr as the key. Here BU is having a naming convention as IB.
Please review my code and let me know , what am i missing .....
SELECT * FROM vibdbu INTO wa_vibdbu
WHERE objnr EQ loc_recn-objnr.
IF wa_vibdbu-objnr(2) EQ 'IB' .
SELECT * FROM vibdbu INTO wa_vibdbu
WHERE objnr EQ wa_vibdbu-objnr .
SELECT * FROM vibdbu INTO wa_vibdbu
WHERE bukrs EQ wa_vibdbu-bukrs AND
swenr EQ wa_vibdbu-swenr AND
sgenr EQ wa_vibdbu-sgenr .
SELECT SINGLE bukrs recnnr INTO CORRESPONDING FIELDS OF wa_subleases
FROM vicncn
WHERE objnr EQ wa_s_vibdbu-objnr .
IF sy-subrc EQ 0 .
COLLECT wa_subleases INTO subleases .
ENDIF .
ENDSELECT .
ENDSELECT .
ENDSELECT .
ENDIF .
Thanks
Shweta