Total record count from Attribute View

[Former Member]

Hi All - I am new to HANA and tried to build something very simple.

1. I created one attribute view by joining Billing tables , VBRP and VBRK , Header and detail table.

2. I joined both the tables with VBELN - Doc number.  Used referential join ( VBRK is on left and VBRP is on right side)

3.  Checked and activated the View.

4. when I try to run select count(*) from attribute view ,  I am getting some very high number of count which is no where close to VBRK and VBRP.

I am confused how come view can return huge number of records.

Any thought ? Experts.

Regards,

R

[Former Member]

Hi Rohan,

I think VBRP holds billing item data and VBRK holds header level data, so the left table should be VBRP and right one should be VBRK.

Now the total record count should be equal to what you have in VBRP table.

Regards,

Venkat N.