topic Re: View on MKPF in Application Development and Automation Discussions

View on MKPF

Former Member — Mon, 02 Nov 2009 04:16:09 GMT

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

Re: View on MKPF

rvinod1982 — Mon, 02 Nov 2009 04:23:30 GMT

Hi,

You want to join MKPF with which table?

Regards,

Vinod

Re: View on MKPF

Former Member — Mon, 02 Nov 2009 04:26:52 GMT

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

Re: View on MKPF

Former Member — Mon, 02 Nov 2009 21:54:51 GMT

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,