3275112 - Exclude Filters for WBS Element and Project not working as expected

In App Display Line Items in General Ledger (App ID F2217) the usage of exclude filters for WBS Element & Project is not working as expected.

The fetched result does not contain the NULL (empty) values

Fields concerned:

WBS Element External ID (WBSElementExternalID)
Partner WBS Element External ID (PartnerWBSElementExternalID)
Project External ID (ProjectExternalID)
Partner Project External ID (PartnerProjectExternalID )
Inv. Special Stock WBS Element External ID (InvtrySpclStockWBSElmntExtID)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP S/4HANA Cloud 

The following example is shown for the WBS Element External ID, but the same behavior can be seen for all other affected attributes, mentioned in the symptom section above.

1.1 In App Display Line Items in General Ledger, there are overall 55,656 line items fetched for Company Code 1010 and Ledger 0L within the last month.

1.2 Define Conditions: WBS Element External ID = empty 

Results: 51,290 line items 

1.3 Define Conditions: WBS Element External ID = not empty 

Results:  4,366 Line Items 

1.4 Total 55,656 = 4366 (not empty values) + 51,290 (empty values)  

This is correct. 

2.1 Define Conditions: WBS Element External ID contains TESTDP11 

Results:  74 Line Items

2.2 Define Conditions: WBS Element External ID does not contain or not equal to TESTDP11

Results:  4,292 Line Items

This is not an accurate result as it does not contain line items which have an empty WBS Element External ID. 

The affected fields are not fetched from the ACDOCA database table, they are added via associations instead.

This is realized via a left-outer-join with the respective table.

As a consequence, these fields are either filled or NULL (empty), so that the exclude filter is not working as expected, as shown with the above example.

3 Possible Workarounds

Workaround Option 1:
In App Display Line Items in General Ledger  

Define Conditions 
WBS Element External ID

less than TESTDP11 
greater than TESTDP11
empty 

Results: Total = 55,582 Line Items 

This is correct, overall total 55,656 = line items with WBS Element TESTDP11  74 and those without TESTDP11 55,582

Workaround Option 2:

Apply the exclude filter on the deprecated old WBS Element attribute instead.

This is working as expected, as this old attribute is directly coming from the ACDOCA database table.


Results: Total Line Items: 55,582 

This is correct. 

Workaround Option 3:

Using Extensibility App Extensibility: Display Line Items in General Ledger (Key User)  https://help.sap.com/docs/SAP_S4HANA_CLOUD/0fa84c9d9c634132b7c4abb9ffdd8f06/15ee31fac4be4e6497a76abe449fe49c.html?locale=en-US
Add fields 
WBS Element Internal ID (WBSElementInternalID )
Project Internal ID (ProjectInternalID)
Partner Project Internal ID (PartnerProjectInternalID)
Inv. Special Stock WBS Element Internal ID (InvtrySpclStockWBSElmntIntID)

If you have added the four internal attributes mentioned above via Data Source Extension, you can apply your exclude filter for these fields.

This is working as expected, as these internal attributes are directly fetched from the ACDOCA database table

C_JournalEntryItemBrowser , KBA , FI-FIO-GL-IS , Reporting Apps , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem