How to find BLART(Document Type) field in the table FAGLFLEXA?

[Former Member]

Hi Guys,

Can anybody tell where can we find the Field BLART(Document type) in FAGLFLEXA Table or FAGLFLEXT? or else is there anyway we can link the table FAGLFLEXA with the field BLART.

Thanks,

Gopi .

[Former Member]

Hello Gopi,

The field BLART is not available in FAGLFEXA/T. You will have to get it from the document header, which is stored in table BKPF. There the field BLART is available.

You can link FAGLFLEXA with BKPF on document number (BELNR), fiscal year (GJAHR - RYEAR), company code (BUKRS).

Kind Regards,

Bart

[Former Member]

Hi Bart,

How to link FAGLFLEXA and FAGLFLEXAT Tables.?I am getting the Data from FAGLFLEXT table and the additional condition while retrieving the data is with Document type 'we'.so how to link these 2 tables FAGLFLEXA and FAGLFLEXT?

Thanks,

Gopi.

[Former Member]

Document type is only in BKPF. So you should link FAGLFLEXA with BKPF where

BKPF-GJAHR = FAGLFLEXA-RYEAR

BKPF-BUKRS = FAGLFLEXA-RBUKRS

BKPF-BELNR = FAGLFLEXA-DOCNR

You cannot link FAGLFLEXT with BKPF, as faglflext contains totals of documents, so the sum of all the documents having the same dimensions. That means that one record in Faglflext can represent 10 documents, which may have different document types. So instead of going for FAGLFLEXT data, go for faglflexa data, which you can link with BKPF, like explained above.

Than throw out the records from FAGLFLEXA that have a wrong doc. type in BKPF.

PS: to link FAGLFLEXA with FAGLFLEXT, take over all dimension fields for the search on FAGLFLEXA. you'll than get 1...n records in FAGLFLEXA.

Dimensions are: gl accoun (racct), profit center (PRCTR), comp. code (BUKRS), ...

Kind Regards,

Bart