Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you please clarify what is tables, columns/fields and literal strings and values here?
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