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

BSIK and BSAK table fetching logic

Hi Gurus,

We have collected all invoices from BSIK and BSAK into an internal table now we want to fetch the purchase orders for the concerned invoices.

we have solution for that we are using BSEG which is a cluster table, as our requirement is not to fetch from Cluster tables, as it affects performance.

Can u please suggest a tranparent table and the selection criteria logic involved in that fetching

Advance Thanks,

Naveen.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 05:51 AM

    Hi,

    Retrieve data from EKKO/EKPO for the purchase orders obtained from BSIK/BSAK using for all entries of the same,

    Rgds,

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 05:58 AM

    try to make use of this FM

    l_awref = i_mblnr-->IR.

    l_aworg = i_mjahr-->year.

    l_awtyp = 'MKPF'.

    call function 'AC_DOCUMENT_RECORD'

    exporting

    i_awtyp = l_awtyp

    i_awref = l_awref

    i_aworg = l_aworg

    i_awsys = i_awsys

    exceptions

    no_reference = 1

    no_document = 2

    others = 3.

    by using this u will get all accounting documents for all Invoicess which u can collect from EBKE for a given PO

    Regards

    prabhu

    Add comment
    10|10000 characters needed characters exceeded