database view condition

[Former Member]

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

[Former Member]

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