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.