Aging wise report with profit center : BSIS, BSAS, FAGLFLEXA

[Former Member]

Hi All,

I have one report to modify.

I need to change report  (made 5 years ago ) in which record is fetched from BSIS and BSAS table to get all open and non cleared item at specific date i.e fetching record which is not cleared till the date (specified in input )

Now output is displayed aging wise i.e Aging wise HSL amount is displayed

Now  I need to modify this report and make Aging amount Profit center wise but problem is profit center is not maintained in BSIS and BSAS table here.

So i am fetching data from FAGLFLEXA table but problem is, both Clear items and non clear items are coming so it is affecting Aging wise HSL amount.

can any one help me how can i fetch open and clear item from FAGLFLEXA.

Record is being already fetched in internal table from BSIS and BSAS table.

Thank you in advance

[Former Member]

Okay I got my solution. here is what I'm doing to full fill my requirement

I am getting all record form BSIS and BSAS table into internal talble(say it_bsis_tmp)

so i am fetching data from FAGLFLEXA  by comparing RYEAR,DOCNR,RBUKRS,RACCT,BUZEI with respect to GJAHR,BELNR,BUKRS,HKONT,BUZEI of IT_BSIS_tmp accordingly.

SELECT

             RYEAR

             DOCNR

             RLDNR

             RBUKRS

             DOCLN

             RACCT

             PRCTR

             HSL

             FROM FAGLFLEXA INTO TABLE IST_FAGLFLEXA_X

             FOR ALL ENTRIES IN IT_BSIS_TMP    

                  WHERE RYEAR  = IT_BSIS_TMP-GJAHR

                       AND  DOCNR  = IT_BSIS_TMP-BELNR

                       AND  RLDNR  = "[static value]"

                       AND  RBUKRS = IT_BSIS_TMP-BUKRS

                       AND  RACCT  = IT_BSIS_TMP-HKONT

                       AND  PRCTR  IN "[Input paramter"]

                       AND  BUZEI  = IT_BSIS_TMP-BUZEI.