Skip to Content
-1
May 27, 2020 at 05:29 AM

Accumulated depreciation value in sap table and field sap

696 Views

Dear Experts,

I need to give a logic for Accumulated depreciation which is coming from report "S_ALR_87011968"

We are building reports in Power BI where some KPI's are coming from SAP report "S_ALR_87011968" Accumulated Dep.

I have given a logic from table ANLC and ANLP.

Below Logic I have given and 99% values are matching with SAP t code "S_ALR_87011968" but few are not matching.

If anyone has prepared FS for Acc Dep then please help.

I appreciate your help.

Note: I can not use FM as it is not accessible in PBI.

(ANLC_KNAFA) + (ANLC_KAAFA) + (ANLC_NAFAL)+(ANLC_NAFAV)+(ANLP_NAFAZ)

Detail Logic as below.

Pass ANLA VALUES to ANLC where
ANLC_BUKRS = ANLA_BUKRS
ANLC_ANLN1 = ANLA_ANLN1
ANLC_GJHAR= Input fiscal Year
ANLC_AFABE = Default Depreciation Area i.e. 01Get ANLC_KNAFA, ANLC_KAAFA, ALNC_NAFAV, & ANLC_NAFAL
Pass ANLA VALUES to ANLP where
ANLP_BUKRS = ANLA_BUKRS
ANLP_ANLN1 = ANLA_ANLN1
ANLP_GJHAR= Input fiscal Year
ANLP_PERAF = (From 1 - to till report date period)Input period calculated based on report date
ANLP_AFABER = Default Depreciation Area i.e. 01Get ANLP_NAFAZ