Skip to Content
0
Oct 16, 2015 at 05:15 AM

How to concat 2 fields in database view for creating generic datasource

795 Views

Hi

How to concat 2 fields in database view for creating generic datasource?

I need to create a database view between RSEG and BKPF for creating generic datasource i.e.

RSEG's two fields BELNR &GJAHR are concat value is equal to BKPF's AWKEY value.

so I define following in Table/join Condition tab in SE11:

RSEG - MANDT = BKPF - MANDT

RSEG - BELNR & GJAHR = BKPF - AWKEY (Error: Field RSEG-BELNR&GJAHR does not belong to a base table)

How to resolve it?

Thanks