topic Re: View with no data in Application Development and Automation Discussions

View with no data

Former Member — Tue, 19 Oct 2010 09:06:46 GMT

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

Re: View with no data

Former Member — Tue, 19 Oct 2010 09:25:43 GMT

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

Re: View with no data

shaik_a — Tue, 19 Oct 2010 20:25:13 GMT

Ramona,

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

-- SMA

Re: View with no data

Former Member — Mon, 25 Oct 2010 12:02:35 GMT

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.