on 2014 Jun 22 11:28 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
10 | |
10 | |
10 | |
10 | |
9 | |
8 | |
7 | |
6 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.