on 09-30-2018 12:33 PM
Row count is different in ecc table loaded through SLT and Attribute View, can you figure out the reason
Thanks in advance
Hi Monica,
Firstly, I would like to re-iterate 9958e4b6df99431a84a41b015b639ac8‘s point that since Attribute and Analytic views are being deprecated, you should only use Calculation Views going forward.
Secondly, even under the deprecated approach, an Attribute View is not the appropriate view for table EKPO. EKPO is a transaction table for Purchase Order Items, containing values such as quantities. Therefore, an Analytic View is more appropriate. Attribute Views are for defining a Dimension and its attributes. In this context, I would not consider a Purchase Order Item to be a Dimension. I suspect your Attribute View is returning fewer rows than the underlying EKPO table. This may be due to what fields you have defined as key fields in the Attribute View. For example, if only the Purchasing Document Number is defined as the key, its possible that only unique rows are being returned, instead of all items.
In any case, as mentioned above, especially if you are performing this exercise for testing/reconciliation purposes, I would not spend any time attempting this with deprecated Attribute Views. You should implement Calculation Views only.
Regards,
Mustafa.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mustafa Bensan,
I created Anlaytic view only, but the row count is different in the result.
This is my joining condition -
EKPO.EBLEN - EKKO.EBLEN
EKPO.MATNR - MARA.MATNR
This is my Analytic View
you should keep them both as left join
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Sergio Guerrero, I have a doubt my scenario is to display last 5 year sale, and compare each year sale with current year. Can you provide a general idea about this. Also when we use text join.
this issue seems like it may be very system specific... you may need to reach out to others within your organization... does Mustafa's suggestion make sense? i am not sure how else to guide you without actually asking to see the system.. it seems like you are following the right steps... other than that... you may need to see if there is an issue on SLT? a delay on replication? other issues... if you are at tech ed this week, there may be help around
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes, go to the view properties... and change session client to cross client
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you need to create a calculation view only.... you should not be creating any attribute/analytics views anymore.
in the calc view... you can drop a projection for each table.. then a join node to join those projections on your specified columns (MANDT, EBELN, MATNR) however you need to join those. ekko to ekpo... then to mara and eventually makt...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Created calculation view, but the final result not showing anythng. Can you figure out the error.
does your view have a SAP client filter? any other filter? have you tried to do a select count on the sql console?
is your join (left) or inner join? do you have any other filter that may be affecting these records?
also make sure the sap client in you ecc system is the same as the mandt on your view
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No, didnt used any filters. And the attribute view contains only one table EKPO, so no joins also. I created this attribute view for testing purpose only. Also can you explain how we can join these tables EKKO-EKPO-MARA. I created a anlaytic view for this, but my row count in result is different.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.