Skip to Content
avatar image
Former Member

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

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 13, 2007 at 09:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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