Creating View for an extractor with reference field

[Former Member]

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

[Former Member]

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

[Former Member]

Could you please share how this was resolved?

I currently have the same requirement/issue.

Many Thanks,