View with no data

[Former Member]

Hello gurus,

I need to extract data to SAP BW from 2 tables - ( LFB1 and LFA1). I created a view in SE11 based on these 2 tables and I selected the join conditions proposed from SAP. At the end I got an error that some fields are not unique and I deleted the fields from the second table.

The tables that I used (LFB1 and LFA1) have data but after I activated my view I receved 0 data.

What am I doing whrong? Can anybody help me with this?

Thanx in advance,

Ramona

[Former Member]

the join conditions were wrong. I took the join conditions suggested from SAP in the Relationship button. I put there just 2 join conditions MANDT and LIFNR. It is working like this.

Edited by: Ramona Selmer on Oct 25, 2010 5:41 PM

[shaik_a]

Ramona,

If you can provide the join conditions it may be helpful to analyze.

-- SMA

[Former Member]

Hi,

Only use lifnr as join condition on both the tables.

ON (LFA1-LIFNR and LFB1-LIFNR)

Please also chack if you have given any selection condition.

for above conditions I am able to see data.