Getting Line Items from BSEG

[Former Member]

Hi all,

i have an requirement requirement i.e

How to calculate the Line Items for a given GL account from BSEG.

plz could anyone help on this.

Thanks in advance.

sudharsan.

[Former Member]

Hi sudharan

In the BSEG table , you have to know the condition that you 'd like to select . for example

<b>The company code :</b> that mean you would like to select G/L Account which belong your company , not any company.

<b> Fiscal year :</b> If you don't entry the fiscal year , system will retrive all the G/L Account line item so you should specify which year that you would like the information.

<b>Document No :</b> sometimes your requirement may know the relavent document , if you can select only document that you 're interested , That is a good thing.

<b> G/L Account :</b> you should select only G/L Account that you 'd like.

<b>Special G/L indicator :</b> in the FI Module , G/L Account may be special G/L . you can use this indicator that you 'd like only normal G/L or Special G/L also.

<b>Business Area :</b> in the line item of G/L Account , you may entry business area for purpose , Example you entry Business Area for indentifing that G/L is for Factory of Office .

If you have any question , Let me know

Wiboon

[Former Member]

hI WIBOON thank for ur information. as u told, i want to get Line itemes based on

comp code from GLT0 table, G/L ac from GLT0 table, Doc no from BKPF. and based on Doc no and Debit/Credit indicator from BSEG i want DMBTR field.

Regards,

sudharsan.

[Former Member]

Hi,

You want which line item is GL???? In BSEG line items????

Check field 'account type' BSEG-KOART = 'S'.

Thanks,

Deepak.

[Former Member]

Hi deepak, thanks for quick replay.

but i want Line items for SHKZG is 'S' and 'H' for based on give GL ac no, comp code , doc no and on posting date(for current month).

plz help on this.

regards,

sudharsan.

[Former Member]

Hi,

First access BKPF based on comp code, doc no and posting date(find year).

Later on access BSEG with 'for all entries in it_bkpf'.

I think if you go like this you will come out of the issue.

Thanks,

Deepak.