Skip to Content
author's profile photo Former Member
Former Member

FI Link with MARA

Hi Friends,

I need a link in FBL3N or BSEG or another table that gives me all the FI line item information and a key field by line that I can link to the MARA table.

Best Regards

Prashant

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 10:46 PM

    If you check BKPF for your GL posting, you can get AWKEY, which is the concatenation of the material document and year. Use this key to search the material documents (MSEG), and from there you can get the reference to the material itself (MATNR) to use with MARA.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2007 at 10:41 PM

    Hi,

    Have you checked MARA-MATNR = BSEG-MATNR?

    If you want to use SELECT statement with JOIN option, please use table BSAK/BSIK instead of BSEG.

    Regards,

    Ferry Lianto

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.