enlarge 0FI_AA_12 with field BUDAT

[Former Member]

Hi to all,

I'm trying to enlarge the extractor 0FI_AA_12 with a field "BUDAT". I need this to see everyday changes in amortization of assets. I have enlarged a structure DTFIAA_12 with field "BUDAT", and tried to unite it in user-exit. But I couldn't find any connection between fields of extractor and field "BUDAT" in ANLP table.

Are there any ways to solve this problem?

Best regards,

Yeskendir

P.S. I can't use any other extractor for example 0FI_AA_002, because data provided by this extractor is insufficient for task completion.

[Former Member]

We make it by user-exit in two step:

IF i_datasource EQ '0FI_AA_12'.

LOOP AT c_t_data.

MOVE c_t_data TO wa_DTFIAA12.

• step 1. Fill BELNR and AFABER

SELECT SINGLE GJAHR BELNR MAX( AFABER ) INTO CORRESPONDING FIELDS OF wa_dtfiaa12 from ANLP WHERE

BUKRS = wa_dtfiaa12-BUKRS

and GJAHR = wa_dtfiaa12-FISCPER+(4)

and PERAF = wa_dtfiaa12-FISCPER+4(3)

and ANLN1 = wa_dtfiaa12-ANLN1

and ANLN2 = wa_dtfiaa12-ANLN2

GROUP BY GJAHR BELNR

.

IF sy-subrc = 0.

MOVE wa_dtfiaa12 TO c_t_data.

MODIFY c_t_data.

ENDIF.

• step 2. Fill BUDAT from BKPF

SELECT SINGLE BUDAT FROM BKPF INTO wa_dtfiaa12-budat

where BUKRS = wa_dtfiaa12-bukrs

and BELNR = wa_dtfiaa12-belnr

and GJAHR = wa_dtfiaa12-gjahr

.

IF sy-subrc = 0.

MOVE wa_dtfiaa12 TO c_t_data.

MODIFY c_t_data.

ENDIF.

CLEAR wa_dtfiaa12.

ENDLOOP.

ENDIF.

[Former Member]

We need this information for preparing notes to the financial statements. Is there any technical possibility to add a field "Posting Date" (BUDAT) to the extractor 0FI_AA_12? If it is possible. could You tell the way how we can do it.

[Former Member]

As you know in AA12 we have depreciation sums in every month and that sums is formed in one day of the month, for example (29.01.2010, 26.02.20.10, 31.03.2010 - last working day). So we have know, in which day depreciation sums is formed. Our company have to form balance sheet day by day and give it to government.

[Former Member]

If it is a pure balance sheet/trial balance I would use the GL extractors for that as they have the posting date on the bseg line item or is it for the notes to the financial stataments ie the breakdown by asset transaction types/asset history sheet groups?

If this is a governement requirement - standard SAP R/3 reports will supply this as part of standard deliverable (if not raise a message through your SAP account manager)

[Former Member]

Yes I agree, that the deprecation run monthly. And I enlarge 0FI_AA_11 with a field "BUDAT". But in bw I need to see all values of two extractors 0FI_AA_11 and 0FI_AA_12 day by day. It need for balance sheet which must be formed by everyday.

Kind regards,

Yeskendir

[Former Member]

You can run AA11 and AA12 daily - but balance sheet data for AA12 will only ever happen once a month on the depreciation run

There iwll be no balance sheet postings until that happens - AA11 affects the balance sheet as well and that will pick up daily postings

Sorry I am not sure I understand all the requirement and how it maps to AA processes

[Former Member]

Posted day by day? But you only run the deprecation run monthly

Is the data available via a transaction type if so it will available under the AA_11 transaction datasource