topic Re: problem in view creation in Application Development and Automation Discussions

problem in view creation

Former Member — Mon, 15 Oct 2007 07:35:17 GMT

i have made a view,

in that view im using tables like afko,afpo,vbak,vbap,aufk

now i want the sales order item number which is present in vbap.

so in the tables join conditions i have written afko-kunnr = vbap-kunnr.

but if there is no customer number in afko then no ouput is getting displaced.

what changes should i do that even if there is no customer number (kunnr) i should still be able to see the ouput.

Former Member — Mon, 15 Oct 2007 07:47:36 GMT

Hi Amit,

Take the Order number from AFKO and write the join as AFKO-AUFNR = AFPO-AUFNR.

Then from AFPO you can take KDAUF and KDPOS like

AFPO-KDAUF = VBAP-VBELN and

AFPO-KDPOS = VBAP-POSNR.

I think this will solve your problem.

Former Member — Mon, 15 Oct 2007 08:44:40 GMT

good

go through this link which ll give you better idea about the creationof views

thanks

mrutyun^