Skip to Content

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

Dec 28, 2017 at 09:29 AM


avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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:



10 |10000 characters needed characters left characters exceeded