Automate

​Dears,

I am trying to query and bring the results of price condition (KONV table) together with billing data from Tables VBRK+VBRP.

I couldn't create just one query in Studio, due issues with repeating entries and also the order of results from query 1 didn't match with results from query 2, so I did two queries:

Query 1: VBRK+VBRP - Figure 1

VBRK has the filed document condition which is used in the query 2

Query 2: KNOV - Figure 2

Now I am with some issues in the composer. I cant execute query 2. I have tried few rules, but no success.

The field number of the document condition in table VBRK (last field) is in a repeating table. I created a rule to target the document condition in the price table (InOp field).

Therefore, when I execute, it seems that Query 1 data in the repeating table gets cleared and nothing happens in query 2

The ideal solution, is that I could bring all the results in just one line for each item, not in two separate tables. Is there a way I can merge these two queries in the composer?

Any suggestions to help me here?


------------------------------
Antonio Miranda | Process Support Advisor
ExxonMobil Business Support Center Czechia s.r.o. | 42077499600
------------------------------

Hi Antonio

I didn't see the figures or examples in your post, but I did try this out.

(1) you should be able to use the In operator in a form - using the output of one query as input in another.  I've done that before.  You should check out why the list of document condition is getting blanked out - perhaps by a rule?  Is the output mapped to the same table?   Also make sure you've mapped the 2nd query correctly. 
(2) you can put all of the tables together in one query - simple example attached.  You join:
       VBRK-KNUMV to KONV-KNUMV (billing header table number of document condition to conditions table number of document condition)  The VBRK-KNUMV field is not indexed, so your join will look a bit different
       and
       VBRP-POSNR to KONV-KPOSN (billing item table item number to conditions table condition item number)


Hope that helps,
Sigrid

------------------------------
Sigrid Kok
pse | Winshuttle North America
------------------------------

Original Message:
Sent: 09-09-2019 06:35
From: Antonio Miranda
Subject: Billing data x Condition Prices Query

​Dears,

I am trying to query and bring the results of price condition (KONV table) together with billing data from Tables VBRK+VBRP.

I couldn't create just one query in Studio, due issues with repeating entries and also the order of results from query 1 didn't match with results from query 2, so I did two queries:

Query 1: VBRK+VBRP - Figure 1

VBRK has the filed document condition which is used in the query 2

Query 2: KNOV - Figure 2

Now I am with some issues in the composer. I cant execute query 2. I have tried few rules, but no success.

The field number of the document condition in table VBRK (last field) is in a repeating table. I created a rule to target the document condition in the price table (InOp field).

Therefore, when I execute, it seems that Query 1 data in the repeating table gets cleared and nothing happens in query 2

The ideal solution, is that I could bring all the results in just one line for each item, not in two separate tables. Is there a way I can merge these two queries in the composer?

Any suggestions to help me here?


------------------------------
Antonio Miranda | Process Support Advisor
ExxonMobil Business Support Center Czechia s.r.o. | 42077499600
------------------------------