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

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

423 Views

Hi,

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 (https://rapid.sap.com/bp/scopeitems/2YG) with the following specifics:

Model: SAP__FI_BPL_IM_PROJECT

Import query: A_JournalEntryItemBasicQuery
Dimension: SAP_ALL_PROJECT_WBSELEMENT


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?

Attachments

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