Skip to Content
avatar image
Former Member

Standar CDS that shows start and final balance by bukrs, period fiscal, client and hkont

Dec 28, 2017 at 09:29 AM | 132 Views

Hi forum,

I have the following question: I need to build a report in SAP S/4HANA environment that shows the start balance and final balanace by bukrs, fiscal period, client and hkont. My problem is I am using a standard CDS (KNC1) but this CDS doesn't show this information. The information that shows is the start balance and the final balance by bukrs, fiscal year and client but not by bukrs, fiscal year, client and hkont. The tables that are under this cds doesn't have the account.

Is there any standard CDS o any way to calculate these figures.

I would appreciate your support

SAP S/4HANA Finance
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Shakeel Ahmed
    Jan 13 at 04:37 AM

    Hey Rocio,

    Though S/4 HANA is all about calculating aggregates on the fly from ACDOCA table. CDS views of old tables are there specially to support previous/old customization based on such eliminated tables (BSIS, BSAS, BSIK, BSAK, BSAD, BSID, FAGLFLEXA, FAGLFLEXT,KNC1 etc.) if you migrate from previous SAP version to S/4 HANA, but anyways you can write new reports on CDS views in S/4 HANA directly.

    Reply to your base query:

    1. It is recommended to use ACDOCA table to write such report. I can help you further in this. or

    2. You can also use CDS vies of FAGLFLEXT, this shall give you desired output.

    Refer a blog on ACDOCA FS:

    https://blogs.sap.com/2017/12/29/functional-specification-in-s4-hana-write-it-in-a-manner-that-technical-consultant-abaper-likes-it-fs-based-on-acdoca-table/

    Regards

    Shakeel

    Add comment
    10|10000 characters needed characters exceeded