How to link MARC-WERKS field with WRPL-KUNNR ?

[Former Member]

Hi,

I need to join MARC and WRPL to get RP type and the Min-Max target Stk using SQVI query. But even it I use T001W table, need to give input twice, once for WERKS & next for KUNNR. In case of multiple site selection, junk values are getting populated.

Is there a way to put single input of site and WERKS=KUNNR..?

Rgds,

Amit

[Former Member]

Hi Amit,

Its not possible to join them as the data types are different, either use a customized report or supply value to both the field as input. If you go for the second option, make both the fields as Mandatory in the default variant.

Steve.

[Former Member · Accepted solution]

Hello,

You should join MARC-WERKS to T001W-WERKS, T001W-KUNNR to WRPL-KUNNR and MARC-MATNR to WRPL-MATNR in SQVI Data source. In the Selection fields choose only MARC-WERKS.

Thanks,

Venu

[Former Member]

Thanks, that was helpful...