BSEG Logic

[Former Member]

Hi Guyz,

i'm looking for following logic for Accounts Payable transactions ...i'm developing a report having 'document type' and posting date on selection screen.....

i'm downloading the results in CSV file... i want to know how to identify a bseg line item whether it is a gross amount or net amount... as my program does processing based on this ....

DMBTR will have the value for each line item (gross, net, tax) .... i'm looking for logic which should work for all AP document types (i.e., doc types in FB01) ....

i'm sure program needs to workout logic based on posting keys and may be doc types also... any help??

thanks in advance

[Former Member]

Hi Guyz,

i'm looking for following logic for Accounts Payable transactions ...i'm developing a report having 'document type' and posting date on selection screen.....

i'm downloading the results in CSV file... i want to know how to identify a bseg line item whether it is a gross amount or net amount... as my program does processing based on this ....

DMBTR will have the value for each line item (gross, net, tax) .... i'm looking for logic which should work for all AP document types (i.e., doc types in FB01) ....

i'm sure program needs to workout logic based on posting keys and may be doc types also... any help??

thanks in advance

[marcela_martinez]

Hi Kasu,

Mi suggestion is asking to the FI consultant which are the document types in each case. As you said, the gross, net and tax amount are different items at the document, and each kind of them deppends on the document type and on the posting key.

I hope it helps you.

Kind regards.

[Former Member]

i'm actually looking for that logic...appreciate if any one can throw some light on it....

[christine_evans]

The essential first step when building a report is to understand your data. FI documents are configured differently at different sites, so follow the good advice already given and ask your FI consultant about this. To get some more technical information, display a document in FB03 while running ST05 SQL trace - the trace file should tell you all you need to know about how to get the data from the database.

[alpesh_saparia3]

Hi,

All the tax related items you can find in table BSET.