Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Creating View for an extractor with reference field

Former Member

‎2009 Aug 13 10:56 AM

0 Likes
471

Hi All,

Here is my requirement.

I need to create a DB view for an extractor. I need to join 3 tables : AUFK,AFIK & AFKO.

Table Join Conditions:

AUFK MANDT = AFIH MANDT

AUFK MANDT = AFKO MANDT

AUFK AUFNR = AFIH AUFNR

AUFK AUFNR = AFKO AUFNR

This AUFK table has a Z field ZZACCOMPLISH(QUAN field) and it it referning to MARA-MEINS.

I created view successfully with all fileds including ZZACCOMPLISH.

But when i give the view name in RSO2, i am getting an error message that 'ZZACCOMPLISH' is refering to some other table.

In this case i don't know how to include MEINS in ths view and There is no link between table AUFK and MARA.

Please guide me on this.

Regards,

Ashok

Reply
1 REPLY 1
Read only

Former Member

‎2009 Nov 25 1:51 PM

0 Likes
424

Could you please share how this was resolved?

I currently have the same requirement/issue.

Many Thanks,