Hi you,
I've a problem with the amounts of the transaction of FS10N.
I want to select them in a manual way using BKPF and BSEG, but I don't know exactly how to define the select-statement. I know that the values are stored also in other tables but I have the goal to select them using the named two database-tables.
Are there any special fields in BSEG/BKPF that I have to use? In the moment I select in this way:
----
SELECT bukrs belnr gjahr monat FROM bkpf
INTO CORRESPONDING FIELDS OF TABLE lt_bkpf
WHERE bukrs IN s_bukrs
AND bstat = space
AND gjahr = p_gjahr
AND monat IN s_perio.
SELECT bukrs belnr gjahr hkont kostl dmbtr shkzg FROM bseg
INTO CORRESPONDING FIELDS OF TABLE lt_bseg_data
FOR ALL ENTRIES IN lt_bkpf
WHERE bukrs = lt_bkpf-bukrs
AND belnr = lt_bkpf-belnr
AND gjahr = lt_bkpf-gjahr
AND hkont IN s_hkont.
----
The last point I do is calculating the amount regarding the field SHKZG (S / H). In about 90% of the cases, the calculated amount is the same like displayed in FS10N, but in some special cases it differs and I really don't know why 😔
Can you give me a hint, please?
Thanks a lot...
Greets.
Markus