cancel
Showing results for 
Search instead for 
Did you mean: 

Row count is different in ecc table loaded through SLT and Attribute View

Former Member
0 Kudos

Row count is different in ecc table loaded through SLT and Attribute View, can you figure out the reason

Thanks in advance

pfefferf
Active Contributor
0 Kudos

Please can you add some more details, e.g. how does your (obsolete) attribute view look like, what settings it has (especially the client and privilege settings); what is the SLT configuration, ....

Just asking with a single sentence w/o context, like you did it, will not result in a valuable feedback in most cases.

Former Member
0 Kudos

Loaded EKPO table using SLT and verified with ECC. Row count is same as in ECC. But when I created a attribute view for EKPO table for testing, the row count is different.

And my scenario is JOIN these tables EKKO-EKPO-MARA-MAKT for reporting.

My final report count is different, thats why I checked in this way.

Sorry for the incomplete information above.

Accepted Solutions (0)

Answers (6)

Answers (6)

MustafaBensan
Active Contributor

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.

Former Member
0 Kudos

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

untitled.png

MustafaBensan
Active Contributor
0 Kudos

Hi monicatoms,

As mentioned before, Analytic and Attribute Views are now deprecated. Please create a Calculation View, after which we can perform further analysis if you are still encountering a reconciliation issue.

Regards,

Mustafa.

Former Member
0 Kudos

Can you figure out error in the following calculation view

untitled2.png

MustafaBensan
Active Contributor
0 Kudos

Hi monicatoms,

Can you post the error message?

Former Member
0 Kudos

Its executed without any error, but not showing any records.

SergioG_TX
Active Contributor
0 Kudos

you should keep them both as left join

Former Member
0 Kudos

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.

SergioG_TX
Active Contributor
0 Kudos

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

Former Member
0 Kudos

SLT is working fine, I checked with ECC, the row count is same. But after creating calculation view the row count is diffrerent.

This is my joining condition, also cardinality also specified.

EKKO.EBLEN- EKPO.EBELN(LEFT JOIN)

MARA.MANDT - MAKT.MANDT (TEXT JOIN)

SergioG_TX
Active Contributor
0 Kudos

yes, go to the view properties... and change session client to cross client

Former Member

Hi Sergio Guerrero,

Thanks a lot, Its working now, but still row count is different.

untitled3.png

SergioG_TX
Active Contributor
0 Kudos

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...

Former Member
0 Kudos
Hi Sergio Guerrero,

Created calculation view, but the final result not showing anythng. Can you figure out the error.

untitled2.png

SergioG_TX
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

untitled.png