Problem in BSIP table and RPKP Table

[former_member907283]

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

[former_member183164]

Hi,

Try LFA1

[former_member907283]

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.

[former_member183164]

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

[former_member907283]

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.