Calculating No. of records XI message payload

[Former Member]

Hello,

Can somebody help me out to calculate no.of records in terms of XML tags in XI message payload.

I have a scenario File->XI->ABAP proxy. File content conversion is used in FTP adapter. So my requirement is to count no. of records come from to XML tags.

Thanks in advance.

Best regards,

Jilan Bhasha

Message was edited by:

Jilan Bhasha.P

[Former Member]

Hi,

Recordsets per Message see in the below link

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm

Regards

Chilla..

[Former Member]

Hi Jilan,

Actually where do you want to get this count..

In sender file adapter config , we have option counter..

-- or you can have a UDF to count the no of msgs ..

-- you can use count function to root. that can be assigned toone target field..

Recordsets per Message see in the below link

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm

Hope this helps. Do get back to me in case you need any more details...

Regards

Kiran..

[Former Member]

Jilan,

>>So my requirement is to count no. of records come from to XML tags.

Do you mean you need to count the number of occurance of a particular element that has cardinality 0..unbounded. If so, use the standard funtion <b>sum</b> available in statistic functions.

Regards,

Jai Shankar

[Former Member]

Hi Jai Shankar,

yes , i want to count no. of occurances of a element of cardinality 1.unbounded in XML payload. But where can get this statistical functions to count sum.

Thanks & Regards,

Jilan Bhasha

[Former Member]

Jilan,

in mapping we have option to select standard function in standatds function you select the statical function then you will find the sum.

standarad function is available at bottom of our mapping next to UDF.

Regards

Sreeram.g.Reddy

[Former Member]

Hi Sreeram,

I have no mapping for this scenario. Thru ABAP proxy, XI adapter.

So i need check for any other way to count no. of occurances of XML tag to equate no. of records coming from input file.

Best Regards,

Jilan Bhasha

[Former Member]

if their no mapping then . then why do u want count.

even you cant use module processor bceause it ABAP proxy

Regards

Sreeram.g.Reddy

Message was edited by:

Sreeram Reddy

[Former Member]

HI,

You can write UDF which calcultes a no of XI records. or the simple way is to take all the values in one queue and use a count function.

Do let me know how your payload looks like.

Thanks

Sandeep.