topic Re: simple QA in Application Development and Automation Discussions

simple QA

Former Member — Tue, 06 Jun 2006 12:09:44 GMT

data: begin of itab occurs 0,

zlblni like essr-lblni,

zebeln like essr-ebeln,

zebelp like essr-ebelp,

zbanfn like essr-banfn,

zbnfpo like essr-bnfpo,

zpackno like essr-packno,

zko_ebeln like ekko-ebeln,

zko_lifnr like ekko-lifnr,

zbelnr like rseg-belnr,

end of....

select single lblni ebeln ebelp banfn bnfpo packno

from essr

into corresponding fields of itab.

why its not work???

Re: simple QA

Former Member — Tue, 06 Jun 2006 12:11:27 GMT

Hi,

give the itabi field names same as database field names or else exclusively specify the fields of the itab in the select statement.

Re: simple QA

Former Member — Tue, 06 Jun 2006 12:11:52 GMT

The names of the internal table fields should be matching with those in the table.

This would work:

data: begin of itab occurs 0,

lblni like essr-lblni,

ebeln like essr-ebeln,

ebelp like essr-ebelp,

banfn like essr-banfn,

bnfpo like essr-bnfpo,

packno like essr-packno,

zko_ebeln like ekko-ebeln,

zko_lifnr like ekko-lifnr,

zbelnr like rseg-belnr,

end of....

Regards,

Ravi

Re: simple QA

Former Member — Tue, 06 Jun 2006 12:13:02 GMT

Hi liat,

1. BCOS the FIELD NAMES ARE DIFFERENT

2. THE FIELD NAMES SHOULD BE SAME.

3. Remove Z

from the field names in itab.

regards,

amit m.

Re: simple QA

Peter_Inotai — Tue, 06 Jun 2006 12:13:03 GMT

Because in ESSR you have field like EBELN and not ZEBELN, so move-correcponding won't move it as they have different names.

Either remove the z from your fields name or remove the move-corresponding and * from your select.

Peter

Re: simple QA

suresh_datti — Tue, 06 Jun 2006 12:13:27 GMT

like other said.. 'CORRESPONDING' will work for only an exact match of field names..

Regards,

Suresh Datti

Re: simple QA

Former Member — Tue, 06 Jun 2006 12:14:02 GMT

select single lblni ebeln ebelp banfn bnfpo packno

from essr

into (itab-zlblni,itab-zebeln,itab-zebelp,itab-zbanfn,

itab-zbnfpo,itab-zpackno).

Re: simple QA

Former Member — Tue, 06 Jun 2006 12:14:06 GMT

into corresponding fields compares the field names & moves the fields accordingly so declaring itab fields with the same names as the table names is always recommended.

Re: simple QA

Former Member — Tue, 06 Jun 2006 12:15:12 GMT

Hi Liat,

Remove Z and declare this way

data: begin of itab occurs 0,

lblni like essr-lblni,

ebeln like essr-ebeln,

ebelp like essr-ebelp,

banfn like essr-banfn,

bnfpo like essr-bnfpo,

packno like essr-packno,

ko_ebeln like ekko-ebeln,

ko_lifnr like ekko-lifnr,

belnr like rseg-belnr,end of....

Re: simple QA

Former Member — Tue, 06 Jun 2006 12:16:00 GMT

HOPE THIS HELPS YOU..

Syntatically your select will be correct. If you want to select multiple items use select as

select lblni ebeln ebelp banfn bnfpo packno
from essr into corresponding fields of table itab.
break-point.

Cheers,

Thomas.

Re: simple QA

Former Member — Tue, 06 Jun 2006 12:16:34 GMT

hi liat,

when u r using into corresponding fields of itab

the fieldnames should be the same.

like this..

data: begin of itab occurs 0,

lblni like essr-lblni,

ebeln like essr-ebeln,

ebelp like essr-ebelp,

banfn like essr-banfn,

bnfpo like essr-bnfpo,

packno like essr-packno,

zko_ebeln like ekko-ebeln,

zko_lifnr like ekko-lifnr,

zbelnr like rseg-belnr,

end of....

hope this helps,

priya.

Re: simple QA

LucianoBentiveg — Tue, 06 Jun 2006 12:18:05 GMT

yo can try too with:

select single lblni ebeln ebelp banfn bnfpo packno

from essr

into itab.