File Content Conversion

Hi All,

The scenario is File to IDoc and i am using Sender FCC. The data is

H0010100120070802200708021001001 9001 001146

D001010012050000000706 0181820099000 0000099000

H0029100120070805200708051001004 9001 1 001146

D002910010123456789 0000000100000 0000100000

D002910010123456788 0200000050000 0000050000

H - Header

D - Data

Header includes Header data

Data also includes information

I have given in Recordset structure as Header,,Data,

But the xml structure after conversion is

But i need the structure to be as

</Header>

</Header>

Even Header also includes data.

So how can i specify in FCC. Is it possible in FCC, if so let me how can i go about it ??

Regards

Ramesh P

SAP Managed Tags:
SAP Process Integration

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

analyzing ur input file:

D002910010123456789 0000000100000 0000100000 and

D002910010123456788 0200000050000 0000050000 should be under

H0029100120070805200708051001004 9001 1 001146

and the same with

H0010100120070802200708021001001 9001 001146 and

D001010012050000000706 0181820099000 0000099000

if this is the case u get strucutre after convertion as

are u getting this one? if not whats the issue?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

hi prabu,

you have determined exactly correct. I am receiving the content how you have specified.

But can i get the structure as

</Header>

Because with structure which i am getting now i have problem in generating IDoc.

The IDoc generated only has

Segment1 - for header

Segment2 - for data >>>>>>>>>>>>>> other data are missing

Segment1 - for header

Segment2 - for data

how shall i go about to get it right in IDoc

Please give suggestion

regards

Ramesh P

with ur FCC inplace, D00101 is associated to the header H00101. In this case u will get only

</header>

and not

but for D0029 u will get as below as there are 2 line items associated with header H0029

Message was edited by:

Prabhu S

Hi,

Yes prabhu

I need the structure as you specified. But how to achieve using FCC.

Regards

Ramesh P

I have given Recordset as Header,1,Data,*

but i am getting as

regards

Ramesh P

considering this data:

H0010100120070802200708021001001 9001 001146

D001010012050000000706 0181820099000 0000099000

H0029100120070805200708051001004 9001 1 001146

D002910010123456789 0000000100000 0000100000

D002910010123456788 0200000050000 0000050000

post the expected xml strucutre with the dataset and also the FCC parameters u had maintained.

Hi Prabu,

Thanks for your replies.

for the above data the xml structure i require is

<?xml version="1.0" encoding="utf-8"?>

<ns:StoreOrderDetails xmlns:ns="http://namespace.com">

<Body>

</Body>

</Header>

<Body>

</Body>

<Body>

</Body>

</Header>

</ns:StoreOrderDetails>

<b>FCC parameters</b>

Document Name - StoreOrderDetails

Document NameSpace - http://namespace.com

Recordset Structure - Header,,Body,

Recordset Sequence - Ascending

Key Field Name - Record Type

and i have given the conversion parameters

<b>and i am getting payload as</b>

<?xml version="1.0" encoding="utf-8"?>

<ns:StoreOrderDetails xmlns:ns="http://namespace.com">

</Header>

<Body>

</Body>

</Header>

<Body>

</Body>

<Body>

</Body>

</ns:StoreOrderDetails>

Hope you got the clear picture. Suggest me how to go about

Regard

Ramesh P

Message was edited by:

Ramesh Parashivamurthy

Hi Ramesh,

I dont think the way you want the xml structure is possible without module development.

I think the problem comes in mapping.

You can easily acheive the same using node functions and UDF.

Regards,

Sumit

hi sumit,

Thanks for your reply.

How can i go about using node funcitons or UDF

check with ur DT

is ur current DT as follows:

Header
|
|
Body

check with

Header
 |
 |__Body

Hi Prabhu,

I dont think itz related with Data Type def. No matter in which way you define the DT it all(xml) depends on the FCC parameters mentioned in the adapter.

Regards,

Sumit

my DT given is

Header

Body

why i have given like this is because my xml payload after FCC is coming as

Header

Body

I just need help in converting the payload after FCC as

Header

Data

Then my target will be achieved.

I read many blogs, i didnt come across such situation. I think this is not possible thru FCC. Do i have make some other appraoch ??

Thanks and Regards,

Ramesh P

i doubt this bcoz the data the is pulled up after FCC is structured as per the data type defintion. hence we may need to have this handleed by changing the DT and FCC acordingly. Still there exists another option via maaping where u need to define another structre as per requirement and use it as a target MT and do the mapping

Hi Prabhu,

How does it matter .. as in FCC and data type def..

>>>FCC is structured as per the data type defintion

True but if you change the data type defination with out changing the FCC . It doesnt matter. The xml would be the same as before.

What i mean to say is that--

While FCC the structure of the data type / message type is not taken into consideration..

Regards,

Sumit Khetawat

Message was edited by:

Sumit Khetawat

u missed 'after' keyword. The xml strucutre that is framed after the FCC and aligns with the DT. considering this we need change in the DT

Message was edited by:

Prabhu S

Hi,

Can i frame a xml structure like

|<Data/>

</header>

|<Data/>

</header>

using FCC.

I think this is not possible right, so i have to take care during mapping only ??

Am i correct.If so how to go about in shifting the nodes

Regards

Ramesh P

ramesh

as per ur post the req structure is

Header

|__Body

and as of now ur are getting the structure

Header

Body

confirm what is required?

prabhu,

i <b>require </b>the following structure after FCC

Header

|_ <data>

</Header>

Header

|_ <data>

</Header>

Header

|_ <data>

</Header>

But now i am getting it as

Header </Header>

<data>

Header </Header>

<data>

Header </Header>

<data>

Hope you are clear

Thanks and regards

Ramesh P

Message was edited by:

Ramesh Parashivamurthy

just do a simple test by changing the DT strucutre like:

Header

|_ <data>

what is the existing strucutre of ur DT?

The exact problem is in my IDoc generation

my idoc is

Segment1

|__ Segment2

My current data type is

Header

Data

Hence i cannot map it correctly

i need my DT as

Header

|__Data

If i get my xml payload like this my problem will be solved and even the IDoc will be generated perfectly.

<i>just do a simple test by changing the DT strucutre like:</i>

I tried as you said, i ll get mapping error.

regards

Ramesh P

is it a mapping error? what does the error says? is it in sxmb_moni?

yes the error runtime mapping exception

it can generate the target element is the error. - sxmb_moni

regards,

Ramesh P

seems some issue with the mapping and not with FCC. can u check the payload and can u post the same???

Hi Prabhu,

Typically in a FCC..

AFAIK changing the structure of DT doesnt change the way XML is generated. It all depends on the FC conversion parameters mentioned in the file adapter.

Regards,

Sumit

hi sumit,

do i have to use splitbyvalue nodefunction to achieve this. Basically i need to remove the child node and place it in under another node

regards

Ramesh P

i'm trying to understand the need of the option Record Structure in FCC? if FCC controls the way XML is generated then why do we need to specify the record strucutre name?

Ramesh

Splitbyvalue introduces contexts. can u post the payload to see how the xml is framed after the change in the DT?

thkx

Prabhu

Hi Prabhu,

Cause then it needs to know the structure of the xml document to create.

Btw ..you can try changing the data type to a different structure and let the FCC be as it is. XML being created will still be the same..

If you understood wht i am saying ..just give it a try in your XI system...

Anyway..Might be both of us are thinking in a different way.

Regards,

Sumit

prabhu

how can i get the payload after the change in DT

since my recordset structure - Header,,Data,

my payload will be generated as

Header

Data

regards

Ramesh P

if the error (mapping) is in sxmb_moni u can take that payload and mail me on that.

Message was edited by:

Prabhu S

yes, the record strucutre is required for the xi to understand how the xml doc is to be created. when we are chaging the DT i believe it could make a difference. maybe we might need to change the FCC also (?). our thoughts are not in sync and lets try it out

after the change in DT ensure the same changes are seen in MT. Else change the MT and activate

Hi Prabhu,

>>>we are chaging the DT i believe it could make a difference. maybe we might need to change the FCC also (?).

Unless and untill we change the FCC it wont make any difference .. simply by changing the DT/MT.

Incase you try it out do post your observation .

Regards,

Sumit

I changed my DT

Header

|__ Body

I am receiving any error while mapping. Because there is data generated for Data node.

="MAPPING">EXCEPTION_DURING_EXECUTE</SAP:Code>

<SAP:P2>com.sap.aii.utilxi.misc.api.BaseRuntimeException</SAP:P2>

<SAP:P3>RuntimeException in Message-Mapping transformatio~</SAP:P3

Because the target node cannot be generated.

Since we have specified as in FCC as Header,,Data, the DT should be

Header </Header>

Data </Data>

but my requirement is

Data </Data>

</Header>

Thanks and Regards

Ramesh P

if my <b>source </b>xml structure is like this

Can we <b>change </b>this to

</Header>

both Header and Data are 0... unbounded.

Can we change it? is it possible in FCC or we need to use some node functions as such

Regards

Ramesh P

error related with mapping. need to check with mappping now. can u mail me the payload after the change from moni?

Ramesh

I have tried a solution which you are discussing and it will give the required...You posted sample XML file you are getting right(which is not the required one)...take that as input file XML for mapping and create a target data type and message type as follow

StorOrderDetails_Target
      --Header (1..1)
           -RecordType
           -Transnum
           -.........
           -Body (0 to Unbounded)
               -RecordType
               -TransNum
               -........

and map your source XML to corresponding fields in target...just like one to one map..You will get the required mapping you want..

if you have any questions let me know....i guess it should work

Hi Guru

I tried this intermediate mapping. After the mapping the data generated is as follows

<ns0:StoreOrderDetailsIntermediate>

−

−

<Body>

</Body>

−

<Body>

</Body>

−

<Body>

</Body>

−

<Body>

</Body>

−

<Body>

</Body>

</Header>

</ns0:StoreOrderDetailsIntermediate>

The structure all messed up Guru, Now the structure comes as

Header

Body

Header

regards

Ramesh P

Ramesh

Could you post screen shot your intermediate mapping..

I will try to work it out

can i have your e-id

Just a question...the output XML you have got is as follows

</header>

This is the one you want right..(or is it different)...I was thinking of above format is what you want...any ways my email is

it is different

all the body of other headers was coming under one header only

regards

Ramesh P

Hi Ramesh,

>>>>>But i need the structure to be as--

As per the test data given by you..You mean like this way ?

</Header>

</Header>

Check this blog.. /people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Also this link from sap help..

http://help.sap.com/saphelp_nw04/helpdata/en/0d/00453c91f37151e10000000a11402f/frameset.htm

Regards,

Sumit

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count