Skip to Content
avatar image
Former Member

Problem in BSIP table and RPKP Table

Hi Expert, I m making report for vendor invoice detail in that i m using BSIP table which is for Index for Vendor Validation of Double Documents in this table I am not getting all the vendor name in field lifnr but I am getting all the Vendor name in RBKP table and if I Am using RBKP table joining with BKPF and BSEG than report is taking time in execution . So plz tell me in which table i will get all vendor name and it will be easy for joining with bseg directly. Abhishek Tripathi
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Sep 20, 2014 at 06:37 AM

    Hi,

    Try LFA1

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2014 at 06:48 AM

    hi Ethan,

    In lfa1 i will get all the vendor but my demand is to get the vendor which r present in RBKP table while linking RBKP and BKPF it is taking lot of time so I m using BSIP table in the place of RBKP but I m not getting all the vendor in BSIP that r present in RBKP table so in which table i will get rest of vendor.

    Add comment
    10|10000 characters needed characters exceeded

    • then try BKPF table..

      You can give a link to table with one another no issues in that.

      Instead of finding every required field in 1 table which is hardly possible, you can create a link between one table with another and thats the better way of doing(If I am not wrong)

      Regards,

      Ethan

  • avatar image
    Former Member
    Sep 20, 2014 at 07:04 AM

    in BKPF table there is a field AWKEy and RBKP table there is a field BELNR and GJAHR if i M Concatenating both field BELNR & GJAHR thaN it is equal to AWKEY of BKPF but it is taking lot of time.

    Add comment
    10|10000 characters needed characters exceeded