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
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:
Regards
Shakeel