Skip to Content

ABAP : report developed Problem basis of FS10n

Dear Friends,

I want a favor from you this is the critical problem basis on concept ,

Actually I am developing an account z report on the basis of FS10n , actually where I am getting the problem ,

I have to display the GRIR balance from the starting year of GL creation to current fiscal year , And I have to

show only the documents which are not cleared .In FS10 suppose I want to put the values like GL(13110100) account then fiscal year (2012)

then in cumulative balance if the documents are uncleared posting date is of previous year (20.11.2011) shown in the report .

But in My Z report I am selecting the documents on the basis of (GL, Fiscal Year, Posting date) and I am deleting the Documents which are cleared .

I am giving (13110100, 2012 , (1.04.2006 - 30.11.2012) ) so documents which are uncleared but are in the fiscal year 2011 are not shown in

my report and If I am giving the Fiscal year in ranges in input (2006-2012) then report is out of time .

Hope you got me .Please suggest me to solve this problem.

Thanks & Regards,

Rihan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 17, 2012 at 05:33 AM

    HI Rihan ,

    I guess there are many FM available based on your requirement.

    Like BAPI_GL_ACC_GET.

    Also you can check tables BSIS and BSAS for your purpose.

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear friends,

      In my report I want to get the duplicates values, but I am getting unique value

      by default even I did not use Delete adjustment concept , How the duplicates values

      are deleted , My queries are here ,

      SELECT BELNR BUDAT BLART FROM BKPF INTO CORRESPONDING FIELDS OF TABLE IBSIG

      WHERE bukrs = '1100'

      AND BUDAT IN S_BUDAT

      AND gjahr IN s_gjahr

      AND blart in ('RE','WE','WA')

      AND tcode IN ('MIR7','FBCJ','FB60','FB08', 'MIRO', 'MIGO_GR', 'ML81N',

      'MIGO_GI')

      AND stblg EQ space

      %_HINTS ORACLE 'index(BKPF"ZNB")'.

      IF NOT IBSIG[] IS INITIAL.

      SELECT BELNR GJAHR EBELN DMBTR SHKZG AUGDT AUGBL LIFNR HKONT

      FROM BSEG INTO CORRESPONDING FIELDS OF TABLE IBSID FOR ALL ENTRIES IN IBSIG

      where belnr eq ibsig-belnr

      and hkont in s_hkont

      and gjahr in s_gjahr

      and lifnr in s_lifnr.

      ENDIF.

      LOOP AT IBSId .

      READ TABLE IBSIG WITH KEY BELNR = IBSID-BELNR.

      break-point.

      move ibsig-budat to ibsid-budat.

      move ibsig-blart to ibsid-blart.

      DELETE IBSID WHERE BUDAT LT S_BUDAT-low and budat Gt s_budat-high.

      DELETE IBSID WHERE AUGDT NE 0 .

      DELETE IBSID WHERE BELNR EQ 0 .

      IF IBSId-SHKZG EQ 'H' AND IBSID-DMBTR > 0.

      IBSID-DMBTR = IBSId-DMBTR * -1.

      ENDIF.

      MODIFY IBSID.

      ENDLOOP.

      please suggest

      Rihan

  • Posted on Dec 17, 2012 at 07:22 AM

    For balance : tables like GLT0 "G/L account master record transaction figures"

    For documents : get non cleared documents in BSAS where clearing date AUGDT is greater than date of analysis and not cleared document in BSIS, in both tables documents where BUDAT is lowed or equal date of analysis. Only then read tables BKPF and BSEG for fields required for the report and not in the secondary index tables.

    Regards,

    Raymond

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.