Set analysis

[Anonymous]

Hi all,

I want calculate the cash value, the condition is

Fetch data from table VBRP , Where (VBELN) in VBAK equal  (AUBEL)  in VBRP, Filter out A from (RRREL), Get cash order (VGBEL), Exclude duplicate cash orders.
Pass the cash sales order number received from  (VGBEL) in VBRP  to VBELN in VBAK,  fetch Net value from field "NETWR" in VBAK, the sum of this Net Value is Cash value.

[petter]

Can you please clarify what is tables, columns/fields and literal strings and values here?

[Anonymous]

Table VBRP

Fields RRREL, AUBEL, VGBEL.

first have to filter out "A" from the field RRREL.

next avoid duplicates from the field VGBEL.

This VGBEL should match with VBLEN in another table VBAK

Cash value is sum(NETWR) in table VBAK