Skip to Content
0
Former Member
Apr 25, 2007 at 10:59 AM

Please optimise des Codes

13 Views

I am working with some Account Tables BSIS,BSAS ,BSEC . I have to select data from these table on the basis of Region ( Not a primary key in BSEC) ,Fiscal year and Company code.here is my code:

SELECT BELNR GJAHR BUZEI NAME1 INTO ITAB1 FROM BSEC WHERE

BUKRS = CC " Company Code

AND GJAHR = FY " Fiscal yr

AND REGIO = RR " Region

AND XCPDK = 'X'." One time Customer

APPEND ITAB1.

CLEAR ITAB1.

ENDSELECT.

But its taking Lotz time im going mad now....

Plz help me ...My objective is to collect BELNR and compare it to BSAS and BSIS table BELNR to check whther Document is Clear or Not.

or if any one knws any table where REGIO wud be a Primary Key.