Skip to Content
0
Former Member
Aug 13, 2009 at 09:56 AM

Creating View for an extractor with reference field

25 Views

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