Billing Amount local currency in BSEG

[former_member445510]

Hello,

did someone have any code to get Amount in local currency in BSEG from VBRK or VBRP?

i know that i have to use BKFP-AWTYP, AWKEY to get data from bseg, but BSEG has items, and i don't know if i have to sum those items or take just one Item record?

Any input please?

[Former Member]

Hi Ouail,

In BSEG there will be one entry for each item of the accounting document, with the total debit amount matching the total credit amount.  For a billing document, you can find the amount billed from the line item that posts against the customer account.  Select only the BSEG records for the documents where the account type is Customer by checking BSEG-KOART = 'D'.

Jim

[Former Member]

Forgot to mention: the local currency amount is in the field BSEG-DMBTR.

[former_member445510]

Thank u very much Jim.

And If i want to get the amount with VAT, i have to extract from BSET? if yes, how to select one record from bset?

Can i get also the local currency value from bkpf-HWAER?

[Former Member]

Hi Ouail,

Yes, BSEG-HWAER contains the local currency code.  For the VAT tax question, see this thread: