Upon Adding navigational Attr only few records coming

[former_member209202]

Hi All,

I need a urgent help. Following is the details of the issue :-

We are using 0FI_AP_30 datasource for a report. the data flow is Datasource-> Standard DSO-> Multiprovider.

Transformation Details from Datasource -> DSO:-

LIFNR is mapped to 0VENDOR and 0VEN_PURORG. Please note the Key for master data 0VENDOR is LIFNR and master data 0VEN_PURORG is LIFNR and EKORG.

In the report we have 0VENDOR, Purchansing organization and navigational attributes of the 0VENDOR and 0VENDOR_PURORG.

When i am pulling the navigational attributes of the 0VEN_PURORG in the report the number of rows getting reduced and only showing the the rows for which there is a value of Purchasing organization from 0FI_AP_30. Whenever this Purchasing organization from 0FI_AP_30 is # then those records get suppressed and not shown in the report.

Following is the details of the query:-

Now when i run the query following is the output and exactly these many rows comes. In this Purchasing organozation has values like 1000, 200. No # value is there.

However when I remove the Purchasing Status and Purchasing Group which are navigational attribute of 0VEN_PUORG from the report row the output rows are more.

Here all the records for which purchasing organization has values or # are coming.

Expectation : We need all the records when we add the navigational attributes of the 0VEN_PURORG. Please help.

I went through the the follwoing link, however did not find the solution.

Regards

Sourav

[former_member185132 · Accepted solution]

I have seen this happening as well. The reason was that in the S-table and Q-table of the characteristic (0VEN_PUORG in your case) there were no records for the characteristic value.

For instance, if you go to the S table of VEN_PUORG, you may not find any records having the vendor 215896. The solution is to load the master data for VEN_PUORG for these values.