problem in view creation

[Former Member]

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]

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]

hi

good

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

http://help.sap.com/saphelp_nw04/helpdata/en/f5/35c83ecedc636be10000000a114084/content.htm

http://www.sapdb.org/7.4/htmhelp/6d/117c44d14811d2a97400a0c9449261/content.htm

thanks

mrutyun^