problem in view

[former_member189410]

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

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

hi,

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

regards

prabhu