creating data types

[Former Member]

Hi

How do u create a data type when u get an input file.

How do u know when to create header , footer n all?

Can some one tell me or send a url on how to create data types. would be of great help!

Thanks!

[Former Member · Accepted solution]

Dear Neha,

Normally we would be in such dilemma when we have a file at sending side.

you need to analyze the pattern of data specified in file.

Normally this will be better explained in TS.

if you are not provided with TS, then you got plenty of work to do before desinging Data type Object.

Regards

Praveen

[Former Member · Accepted solution]

Hi

We are provided with TS usually. But generally what is the procedure to follow when creating data types.

We do have files at the sender side.

Thanks

[Former Member · Accepted solution]

Any body there? Please help

Thanks!

Edited by: Neha Shah on Jan 1, 2009 7:47 AM

[Former Member · Accepted solution]

Dear Neha,

Steps to create Data Type for File Structure.

1. Findout what are the field names for your file structure create the same in the Data Type as Element

a) Specify Cardinality - 0, 1, Unbounded or fixed number.

this depends on how many times this field is expected in the file structure

b) Specify Type - specify the type in which format you are getting this field in File Structure (String,Date, Numeric, etc..)

c) Identify any attributed for the element: It can be defined as charecteristics of an Element.

d) Identify Parent child relationship between Field name in File Structure, create as Identified.

e) Make sure Element names and Arrtibute name are proper based on the SAP Naming standards or

client specific naming standards.

Updates required.

Regards

Praveen

[Former Member · Accepted solution]

Thanks alot Praveen,

I have another doubt. In message mapping, we can make the occurences of message type 0-unbounded instead of the usuaa one.

What is the purporse of that?

When message type is more than 1 what does that mean?

Does number of message type represent no. of files being picked up?

thanks

Neha

[Former Member · Accepted solution]

HI,

The occurance indicates the possibility of multiple values.

For e.g. Have look on below structure

Root

-

---

>Student______________ Occurance 0 to Unbounded

-

---

>Name______________Occurance 1 to 1

-

---

>Address___________ Occurance 1 to 1

-

---

>Marks_____________ Occurance 1 to 1

Now underr root you can have multiple students, thus the occurnace is multiple.

But under student other fields are unique thus single occurnace.

Thanks

Swarup

[Former Member · Accepted solution]

Thanks guys. But sum1 pls answer my question. Does message type represent the number of files?

[Former Member · Accepted solution]

HI,

The Mesasge Type in Mapping part. i.e. Top Mesage Type on Target Side will always have occurance 1.

If you try to change the occurnace of Mesasge type, then it will create below structure

Message----

---

Occurnace 1:1

|_______>Message1 -

---

Occurnace 1:1

|_______----

---

>MT_test -

---

Occurnace 0:Unbounded

It shows you that you can't create the multiple files as the base message type will be single. But you can have multiple message types on target side. i.e. Multi-Mapping.

thanks

Swarup

[Former Member · Accepted solution]

Dear Neha,

logically if you are selecting 0 to unbounded Messages Type in message mapping, means PI runtime expects either 0 or unbounded messages while mapping. Normally you keep 1 to 1 means you are providing only single message for executing scenario.

hope you got the answer.

Regards

Praveen

[former_member184619]

Hi Neha,

just keep few basic things in mind while creating Data type

1. What's the structure provided in input file provided and create the same in IR

2. Assign the data type

3. Define the occurrences

4. create it as element/attribute

check this for more details:

http://help.sap.com/saphelp_nw70/helpdata/EN/a5/04623c4f69b712e10000000a114084/frameset.htm

Sachin

[Former Member]

HI,

Generally identifying the structure from the input file need some analysis work.

You may refer some of the below tips while creating the data types

1. List down the input structure of data fields from input file.

2. Decide the Header and detail information based on the data and go for sub-structure.

3. With File adapter try to maintain the structure level max. upto 2.

i.e. Root>Header>Fields etc.

4. Try to avoid the substructure for the internal fields.

5. Decide the Occurances fo every root and sub structures and fields.

6. Identify if there any relations within Header and detail fields.etc.

Check with SAP Help for various activities

http://help.sap.com/saphelp_nw04/helpdata/en/a5/04623c4f69b712e10000000a114084/content.htm

Thanks

Swarup