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

MM and FI report

Hello All -

Tables involved:

Datasource : 2LIS_02_ACC(ECC 6.0)

EKBE, BSAK, BKPF.

They want to see data from BSAK and BKPF and EKBE for PO.

Can you please suggest how to do.

Thanks,

Praveen

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 13, 2009 at 09:19 AM

    Dear Praveen,

    If you want to get the PO Number from Finance Tables, take first 10 digits from ALLOCATION NUMBER and match it with PO number in EKBE Table.

    If you are not clear come please come back me with more details

    Regards

    Amar

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 12, 2009 at 04:28 AM

    Hi,

    BSAK - EBELN
    EKBE - EBELN
    BKPF - You don't have EBELN

    In 2LIS_02_ACC you have EKKO-EBELN. If you want to see the PO from the above tables you need to enhance the structure MC02M_0ACC based on the above tables. But you don't have EBELN in BKPF table.

    For details check in SAP help site.

    http://help.sap.com/saphelp_nw70/helpdata/en/5c/8ea0e626e442efb109232830faded9/frameset.htm

    Thanks

    Reddy

    Edited by: Surendra Reddy on Feb 12, 2009 5:29 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2009 at 09:08 AM

    Hi

    You dont have any Standard Extractor with BSAK and BKPF and EKBE for PO.

    You can either Enhance the DS or Generic Extractor

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2009 at 09:49 PM

    Answered

    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.