table for GL line items.

[Former Member]

Hi ,

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

Regards,

[Former Member]

Open items table is BSID, cleared items is BSAD.

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

[Former Member]

BSEG and BKPF

[Former Member]

FAGLFLEXA - Line Items

FAGLFLEXT - Totals

Message was edited by:

Jr Roberto

[Former Member]

Hi ,

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

Pls reply.

[Former Member]

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

Jayasudha

[Former Member]

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

[Former Member]

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,

[Former Member]

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

[Former Member]

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