topic Re: key fields declaration in Application Development and Automation Discussions

key fields declaration

Former Member — Tue, 12 Jun 2007 11:18:07 GMT

Hi,

i have this declaration:

data: begin of tab1 occurs 0,

mat(18) type c,

anno(4) type n,

mese(2) type n,

tipval(3) type n,

imp(9) type p decimals 2,

qty(9) type p decimals 3,

end of tab1.

How can I declare the fields mat, anno and mese as a key field?

thanks a lot.

Re: key fields declaration

Former Member — Tue, 12 Jun 2007 11:22:00 GMT

Hi,

DATA itab { {TYPE tabkind OF [REF TO] type}

| {LIKE tabkind OF dobj} }

[WITH key] .

regards,

shardul shah

data : begin of itab occurs 0,

ebeln like ekpo-ebeln,

ebelp like ekpo-ebelp,

loekz like ekpo-loekz,

aedat like ekpo-aedat,

matnr like ekpo-matnr,

end of itab.

data : x_tab like table of itab with key ebeln with header line.

Message was edited by:

Shardul Shah

Re: key fields declaration

Former Member — Tue, 12 Jun 2007 11:23:16 GMT

Where you wants to create/use them as key fields

in the internal table or DB table?

In the database table you can just tick the field after FIELD

there is nothing to be done for the internal table.

Reward points for useful Answers

Regards

Anji

Re: key fields declaration

seshatalpasai_madala — Tue, 12 Jun 2007 11:26:08 GMT

Hi,

OCCURS is obsolete, you can instead use TYPE STANDARD TABLE along with WITH KEY addition to define the key.

TYPES: begin of tab1,

mat(18) type c,

anno(4) type n,

mese(2) type n,

tipval(3) type n,

imp(9) type p decimals 2,

qty(9) type p decimals 3,

end of tab1.

DATA: itab type standard table of tab1 with key mat anno mese.

Regards,

Sesh

Re: key fields declaration

Former Member — Tue, 12 Jun 2007 11:28:12 GMT

Hi,

U can't give the key fields directly for those fields.U can give in the following way:

data: begin of tab1 occurs 0,

mat(18) type c,

anno(4) type n,

mese(2) type n,

tipval(3) type n,

imp(9) type p decimals 2,

qty(9) type p decimals 3,

end of tab1,

it_tab1 like table of tab1 with Unique key mat anno mese with Header Line.

Regards,

Padmam.

Re: key fields declaration

abdul_hakim — Tue, 12 Jun 2007 11:33:46 GMT

Hi,

Use the below code..

data: begin of tab1,

mat(18) type c,

anno(4) type n,

mese(2) type n,

tipval(3) type n,

imp(9) type p decimals 2,

qty(9) type p decimals 3,

end of tab1.

data itab like table of tab1 with unique key mat anno mese.

dont use occurs 0 method as itis obsolete and wont be supported in OO Context..

Cheers,

Hakim

Mark all useful answers..