Question Re: table for GL line items. in Technology Q&A

table for GL line items.

Former Member — Thu, 20 Sep 2007 06:04:27 GMT

Hi ,

Can anybody tell me what is the table for GL line items in R3 side.

Regards,

Re: table for GL line items.

Former Member — Thu, 20 Sep 2007 06:07:18 GMT

FAGLFLEXA - Line Items

FAGLFLEXT - Totals

Message was edited by:

Jr Roberto

Re: table for GL line items.

Former Member — Thu, 20 Sep 2007 06:19:30 GMT

BSEG and BKPF

Re: table for GL line items.

Former Member — Thu, 20 Sep 2007 06:22:19 GMT

Hi ,

If I enter these names; System response is "this table does not exist".

Pls reply.

Re: table for GL line items.

Former Member — Thu, 20 Sep 2007 06:24:45 GMT

Hope you are entering in R/3 side. It shoulde be at R/3

Jayasudha

Re: table for GL line items.

Former Member — Thu, 20 Sep 2007 06:29:41 GMT

Open ECC - SE 11 - Table - BSEG & BKPF ( As Voodi's reply )

Re: table for GL line items.

Former Member — Thu, 20 Sep 2007 06:36:50 GMT

Thanks Voodi and Roberto,

Actually I am in need of following.

I need to take all fields from 0FI_AR_3 DS and Additional fields as follows.

Profit centre

Net Due date

FI Document number

Document line number

End customer country code

Group currency (USD)

customer no

End customer country

document no

line item

Note: Only pull in AR documents into the structure that have status of OPEN.

Can I find out all these fields from both these tables?

Regards,

Re: table for GL line items.

Former Member — Thu, 20 Sep 2007 07:02:09 GMT

If I enter these names; System response is "this table does not exist".

It means that you have not implemented New GL and are still on old GL, so BSEG and BKPF should the tables ur extractor is reading

Re: table for GL line items.

Former Member — Thu, 20 Sep 2007 07:06:18 GMT

I need to take all fields from 0FI_AR_3 DS and Additional fields as follows.

Profit centre

Net Due date

FI Document number

Document line number

End customer country code

Group currency (USD)

customer no

End customer country

document no

line item

Note: Only pull in AR documents into the structure that have status of OPEN.

You cant use 0fi_ar_3 as it is not delta enabled, you should be looking at 0fi_ar_4. And all the fields you mentioned are pretty much available int he std extractor, and regarding the country codes, you can look at the customer attributes, and to use the same in the query make them navigational

Re: table for GL line items.

Former Member — Thu, 27 Sep 2007 17:45:25 GMT

Open items table is BSID, cleared items is BSAD.

If you are looking for GL data, open table is BSIS, cleared is BSAS.