View on MKPF

[Former Member]

Hi Friends,

I want to make join on MKPF table through Reference(XBLNR) field . but the select statatement for executing query is getting very slow . is there any view available on MKPF table or any other method throught which we can fetch records through MKPF .

I have reference document only for making join through MKPF.

Kamal

[Former Member]

Hi Friends,

I want to make join on MKPF table through Reference(XBLNR) field . but the select statatement for executing query is getting very slow . is there any view available on MKPF table or any other method throught which we can fetch records through MKPF .

I have reference document only for making join through MKPF.

Kamal

[rvinod1982]

Hi,

You want to join MKPF with which table?

Regards,

Vinod

[Former Member]

i want to join MKPF with VBRP table (VBRP-VGBEL ~ MKPF-XBLNR) for fetching the Posting Date .

[Former Member]

Hi ,

Why don't you create an database View with MKPF & VBRP table's select only the fields required for your requirement, so that in dabase level the view will be created , and it will be alsofaster ...always you can use the View created for any select statement related to this fetch .

Regards,