SAP Query Creation with copy of a table

[former_member615785]

Hi Experts,

I need help in query creation:

Requirement:

Business Scenario

1. In case of STO, where material with SERIAL NO.1 is sent from PLANT1 (Delivering Plant) to PLANT2 (Receiving Plant)

2. IRN can be created only if SERIAL NO. for material in both plant is maintained same. Like below

a. MARC – SERNP = SERIAL1, where MARC – WERKS = PLANT1

b. MARC – SERNP = SERIAL1, where MARC – WERKS = PLANT2

3. Always only 1line item is in delivery, it is business requirement. So I can use LIKP and LIPS without any duplicity.

Requirement why I am creating query:

1.Now to support users, I want to facilitate them they can check serial no. for both plant, if IRN issue is coming

2.So to do that I did the below:

a. Linked LIKP – VBELN to LIPS – VBELN

b. Linked LIPS – MATNR to MARC – MATNR

c. Linked LIPS – WERKS to MARC – WERKS

• And finally fetched MARC – SERNP = SERIAL1, where MARC – WERKS = PLANT

Challenges:

1.Now to check if MARC – SERNP = SERIAL1, where MARC – WERKS = PLANT2 or not.

2.I need to have a copy of MARC so that I can pass MATNR with PLANT2.

a. But query is not allowing

Help Required:

• 1.How can I create a copy of MARC in query so that error doesn’t come which is coming in attachment? (Please Find Attachment)

Thanks in Advance

Please help me if any solution is there !!

screenshot-of-query.jpg