recalculate remaining sdorder quantity
2 Beiträge
•
Seite 1 von 1
2 Beiträge
Seite 1 von 1
Beitrag
von chrisumisu (ForumUser / 1 / 0 /
0
)
»
Hi everyone,
has anyone an idea how i can realize following situation:
i have to calculate the remaing sd-orders quantity.
for example an internal table like this:
just one single line, when vbeln & posnr are the same, but more than one vbbe-slno entry
thanks for any suggestions!
has anyone an idea how i can realize following situation:
i have to calculate the remaing sd-orders quantity.
for example an internal table like this:
just one single line, when vbeln & posnr are the same, but more than one vbbe-slno entry
thanks for any suggestions!
Du hast keine ausreichende Berechtigung, um die Dateianhänge dieses Beitrags anzusehen.
gesponsert ⓘ
Stellenangebote auf ABAPforum.com schalten
kostenfrei für Ausbildungsberufe und Werksstudenten
kostenfrei für Ausbildungsberufe und Werksstudenten
Beitrag
von Lukas Sanders (ForumUser / 68 / 7 /
34
)
»
Hi,
you could use the LOOP AT... GROUP BY statement. First group the datasets by VBELN and POSNR, then within those groups calculate the sum and add it to another internal table.
There are some good examples here: https://codezentrale.de/abap-gruppierun ... up-member/
It might also work with the COLLECT statement. This requires an internal table with VBELN and POSNR as key and would also add SLNO as it adds all numeric non-value fields together.
you could use the LOOP AT... GROUP BY statement. First group the datasets by VBELN and POSNR, then within those groups calculate the sum and add it to another internal table.
Code: Alles auswählen.
DATA: lt_input TYPE ...,
...,
lt_output TYPE ...,
lv_omeng TYPE vbbe-omeng.
" get data ...
" groups by VBELNR
LOOP AT lt_input ASSIGNING FIELD-SYMBOL(<fs_vbel>) GROUP BY <fs_vbel>-vbelnr ASCENDING.
"group by POSNR
LOOP AT GROUP <fs_vbel> ASSIGNING FIELD-SYMBOL(<fs_pos>) GROUP BY <fs_pos>-posnr ASCENDING.
CLEAR lv_omeng.
" add up value of OMENG within group
LOOP AT GROUP <fs_pos> ASSIGNING FIELD-SYMBOL(<fs_sl>).
ADD <fs_sl>-omeng TO lv_omeng.
ENDLOOP.
" append aggregated structure to output table
APPEND VALUE #( vbeln = <fs_sl>-vbeln posnr = <fs_sl>-posnr slno = 1 omeng = lv_omeng ) TO lt_output.
ENDLOOP.
ENDLOOP.
" do something...
It might also work with the COLLECT statement. This requires an internal table with VBELN and POSNR as key and would also add SLNO as it adds all numeric non-value fields together.
Code: Alles auswählen.
DATA: lt_output TYPE HASHED TABLE OF ... WITH UNIQUE KEY vbelnr posnr,
....
" get data ...
LOOP AT lt_input INTO ls_input.
" new line for each key pair, sums for SLNO and OMENG
COLLECT ls_input INTO lt_output.
ENDLOOP.
" correct the SLNO value
LOOP AT lt_output ASSIGNING FIELD-SYMBOL(<fs_output>).
<fs_output>-slno = 1.
ENDLOOP.
" do something ...
Seite 1 von 1
Vergleichbare Themen
1
Antw.
Antw.
1596
Views
Views
3
Antw.
Antw.
1854
Views
Views
Formatierte Ausgabe von QUANTITY und UNIT
von a-dead-trousers » 22.01.2019 10:55 • Verfasst in ABAP® Core
von a-dead-trousers » 22.01.2019 10:55 • Verfasst in ABAP® Core
Frage die ABAP Experten
Über diesen Beitrag
Unterstütze die Community und teile den Beitrag für mehr Leser und Austausch
Aktuelle Forenbeiträge
Newsletter Anmeldung
Keine Beiträge verpassen! Wöchentlich versenden wir lesenwerte Beiträge aus unserer Community.Die letzte Ausgabe findest du hier.