topic Re: database view condition in Application Development and Automation Discussions

database view condition

Former Member — Wed, 07 Mar 2007 05:57:10 GMT

hi,

i create a view and the common field to join is only kostl. may i know how to condition it so that group and sort also racct, rprctr and hsl(amount) for every change of kostl. is it possible to do in view?

glpca kostl, racct, rprctr, hsl

ztable kostl

view column kostl racct rprctr hsl (only list important column here)

thanks

Re: database view condition

Former Member — Wed, 07 Mar 2007 06:02:40 GMT

Hi,

You Can give the Condition for joining the two tables as:

GLPCA-KOSTL = ZTABLE-KOSTL.

If at all you have GL account and Profit Center in Z table you can give them also.

Other wise declare Kostl as first field in the view and RACCT as second and RPRCTR as third field for sorting purpose.

Regards,

Anji