topic problem in view in Application Development and Automation Discussions

problem in view

former_member189410 — Fri, 01 Jun 2007 04:46:49 GMT

Hi,

i created a view for three tables in which i m having

applno lc req docnum line no lc avail

0034 100 0034 1 200

0034 100 0034 2 400

0035 200 0035 1 2100

0036 300 0036 1 2200

0036 300 0036 2 2300

but the problem which i m facing is lc req value which i m getting for a particular appl no is duplicate i mean for a application dere is only one lc req but for the same document no dere is more than one lc avail.

so i m getting lc req more than once which is not reuired

required data

applno lc req docnum line no lc avail

0034 100 0034 1 200

0034 0034 2 400

0035 200 0035 1 2100

0036 300 0036 1 2200

0036 0036 2 2300

plz let me know hw cud i modify this in my program

thnx

points wil b assigned

Re: problem in view

Former Member — Fri, 01 Jun 2007 04:51:23 GMT

You might have not declared the KEY links between the tables that are used in the View correctly, that's why you may be getting duplicate values

Check the same and redefine the link between tables

First check manually in 2 tables for the records and then define and fetch data from the view and use

Reward points if useful

Regards

Anji

Re: problem in view

Former Member — Fri, 01 Jun 2007 04:53:03 GMT

data : flag.

sort itab by applno lc_req.

loop at itab.

at new lc_req.

flag = 'X'.

endat.

if flag = ''.

itab-lc_req = ''.

endif.

modify itab.

clear flag.

endloop.

regards

shiba dutta

Re: problem in view

Former Member — Fri, 01 Jun 2007 04:55:12 GMT

hi,

please use the primary key in the veiw for table/joining condition.

regards

prabhu