Query for Incoming Items (GRPO , Receipt from Production)

Hi

Can anyone guide me in designing the query for the below mentioned requirement from one of my client.

1. Regular GRPO

2. Subcontracting ( Receipt from production)

3. Inhouse production (Receipt from production)

4. Finished goods ( Receipt from production)

5. Return components( in Receipt from production)

Note: Apart from regular GRPO & Return Components, the remaining will be distinguished by having an “UDF” where user will select the respective option

ex.. SC, INHOUSE, FG

We need to coincide all the above into one query.

Can anyone help me on getting the required output for the above mentioned query.