SQ02 Infoset join to additional field

[Carl_H]

Hi,

My objective is to link sales orders to process orders (VBAK and AFPO) in a report. The issue is that our configuration is MTS with final assembly and not MTO, so we are creating process orders (COR1) and not production orders so we can't create and order against a specific sales order.

I first tried to use a non-used field in sales order to provide the process order number like VBAK-IHREZ and then link AFPO-AUFNR to VBAK-IHREZ. It did not work of course.

Then I tried to create an Extra > Additional field ZAUFNR like AFPO-AUFNR and code VBAK-IHREZ Move TO ZAUFNR and link AFPO to ZAUFNR. The output is all blank field except AUFNR where the correct process order is populated. 

Is there a way to achieve that with a custom field? Or any other workarounds? 

Thanks for your support!

Carl

[Carl_H · Accepted solution]

Alright, So my initial plan did work finally. I did a beginner mistake when I tought the process order number in AFPO was, lets say '1234', but I realised that the unconverted value is '00001234'.

So what I did is update the code of my field ZAUFNR to be : CONCATENATE '0000' VBAK-IHREZ INTO ZAUFNR.

Then I added the table AFPO in my infoset as an additional table where AUFNR = ZAUFNR and POSNR = '0001'.

It works perfectly!