topic Re: Import structure query in Application Development and Automation Discussions

Import structure query

Former Member — Tue, 09 Jan 2007 06:26:40 GMT

hi gurus,

In a se37 function builder i have a structure in the import paramter

ie i am getting list of client in the import

how i can write the query to get the details of the list of client

it says the error as

"it" must be a flat structure. You cannot use internal

tables, strings, references, or structures as components. -

senthil.

Former Member — Tue, 09 Jan 2007 06:32:41 GMT

if it is structure the u can u use for all entries clause to fetch all the details as per ur import values lik -

select * from dbtab into corresponding fields of itab for all entries in itab1

where field1 = itab1-field1 "optional

amit

Former Member — Tue, 09 Jan 2007 06:35:44 GMT

snthil,

In function module

select required columns form x table in to table itab

for all entries in structure

where client eq structure-client.

Now you will get required client details in your internal table.

Pls. mark if useful

Former Member — Tue, 09 Jan 2007 06:48:13 GMT

thnax for u r reply

i have a FM in import as clientno like zclientno(structure to get list of client )

i want to have the output from the input as ( there will be many input clien no )

based on the cleint no i want to take the output inot an IT table from kna1 table

senthil

Former Member — Tue, 09 Jan 2007 06:52:50 GMT

u have to write the select condition as per mentioned in my last post

second option can be tht u can have a loop at the internal table having clients and inside loop u can fetch the client details one by one like -

loop at itab.

select single * from KNA1 into corresponding fields of itab1 where Mandt = itab-mandt.

endloop.

second option will degrade ur performance so use the first one only.

amit

Former Member — Tue, 09 Jan 2007 06:55:08 GMT

Hi Senthil ,

Sorry but i am still not clear with your requirement , coule you pleae rephrase it .

Regards

Arun