Skip to Content
0
Former Member
Jan 09, 2009 at 03:39 PM

Data Extraction from a SAP Table

82 Views

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