Skip to Content
0
Former Member
Sep 08, 2007 at 10:54 AM

Data Extraction

23 Views

Hi all.

please look at this code.

form get_data using t_data like it_data .

SELECT zsettlement~ecod

zsettlement~alwnc

zsettlement~elnc

zsettlement~salp

zsettlement~salc

zsettlement~bons

zsettlement~advn

zsettlement~notp1

zsettlement~recv

zsettlement~idca

zsettlement~stat

zsettlement~gratu

zsettlement~remark

zsettlement~lwd

ZSETTLEMENT~ESI

ZSETTLEMENT~PF

INTO CORRESPONDING FIELDS OF TABLE t_data

FROM zsettlement as zsettlement

WHERE zsettlement~slno in s_slno

AND zsettlement~ecod in s_ecod

.

i want to select single value from t_data.

how to do this , if i use statement like this

total = zsettlement~remark.

it will give error bocoz there is no header line . is there any other way so that i can fetch the value from t_data.

please help me .

Regards.

prajwala.k