Skip to Content
Nov 11, 2020 at 04:56 PM

Problem with loading transactional data on different hierarchical levels of WBS dimension (S/4HANA)



In our project, we use S/4 HANA Public Cloud together with SAP Analytics Cloud as the planning tool. In S/4 HANA, project costs can be booked on different WBS levels of the WBS hierarchy. For example, as can be seen in the screenshot below, €400 is booked directly on Fase 1 (44-000001-01) and €455 is booked on the leaf node of Fase 1: AIO 1 (44-000001-01-01). Therefore, as is shown in blue, the total costs booked on Fase 1 is €855:

When using a live connection in SAC with the specific Custom Business Objectfrom S/4, the data can be shown in the exact same format:

However, the data cannot be mapped correctly whien using an import job via the Project Planning in SAC business content ( with the following specifics:


Import query: A_JournalEntryItemBasicQuery

In the screenshot below, the dimension with the specific WBS elements is shown in more detail:

Although the member ID’s are a leaf node in the first hierarchy of the WBS dimension, the following issue is shown during the import of the journal entries:

Column "WBS Element" has the following errors: Not a leaf node

Does anyone has any experience with S/4 bookings on different WBS hierarchical levels and their import in SAC?


screenshot1.jpg (39.4 kB)
screenshot2.png (48.4 kB)
screenshot3.png (81.9 kB)
screenshot4.png (30.5 kB)