topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Tue, 21 Feb 2006 08:43:11 GMT

hi, i want to upload data ,by LSMW

There is item and header

if i want to put both header and item in one single file, how i should arrage the file.

with the help of identifier,pls exp me by example

Thanks

Re: Query

Former Member — Tue, 21 Feb 2006 09:04:34 GMT

Hello Deepak,

Yes u can do this by arranging the input file in the format ....

rec type data.....

1 dfjhdflk dfkjdlkfjd dskjdlk<-----Header line

2 kjdlkdf dfkjkdljs skdjsk<------Detail line

2 <--all related detail lines data for the header

1 <--- new header....

So the first char explains the type of the record

Re: Query

abdul_hakim — Tue, 21 Feb 2006 09:16:03 GMT

Hi Deepak,

You need some identifier in the file for distiguishing between header and item data.For eg H for header and P for item.This rules applies to BDC as well.Unless and until you have an identifier you can't upload the data..

Regads,

Abdul

Re: Query

Former Member — Tue, 21 Feb 2006 09:24:10 GMT

Hi Deepak,

You have to specify two different settings for this.

- While creating structures add an extra field as first field in your both header and item structures. For that field give a constant in the 'Identifying Field content' column.

Example -> Header structure - HEADER

Item Structure - ITEM

HEADER - First field HEAD_IDEN (char 9) and identifier HEAD_IDEN

ITEM - First field ITEM_IDEN (char 9) and identifier ITEM_IDEN

Sample data in the file

HEAD_IDEN 11

ITEM_IDEN 11

- While specifying files select ‘Data for multiple Source structures (Seq .File)’ option.

Regards,

Rajesh.