Skip to Content
0
Former Member
Jan 11, 2012 at 09:37 AM

Creation of additional fields in Infoset SQ02

511 Views

Hi Experts,

I'm a FICO consultant trying to create a query.

Requirement : Link RSEG Table to BKPF Table in the join condition

Link: RSEG-BELNR concatenated with RSEG-GJAHR = BKPF-XBLNR

Now I'm trying to create an additional field in SQ02 named MiroYear and in the field code part i gave the below piece of code

"CONCATENATE RSEG-BELNR RSEG-GJAHR INTO MIROYEAR."

It shows no syntax errors. I added the same to the field group as well.

Issue: The additional field (MIROYEAR) is not appearing in the join condition in SQ02.

Is this the right way to create an additonal field? Have i made any mistake? Or any of you have any better ideas to join RSEG and BKPF in SQ02?

Your quick response will be appreciated

Best Regards

Vimal