Skip to Content
0
Former Member
Jan 13, 2008 at 07:15 PM

Amounts in transaction FS10N - how to select?

57 Views

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