File content conversion parameters

[Former Member]

Hi

I have a file which is variable length and pipe delimited ... structure is like

DT_ AwardInformation

XXX_ACEAward

Header

PayDate

EndDate

DetailRecord

PersonnelNumber

Infotype

Subtype

Field3

Field4

Field5

TrailerRecord

TotalRecord

TotalAmount

venkat

[vikas_agarwal]

Hi,

File Content Conversion Parameters for yr data Type are:

Document name-> Source message type

Document Namespace: Namescape

Recordset name-> XXX_ACEAward

Recordset Namespace->

Recordset structure->Header,,Detail Record,,TrailerRecord,*

Recordset per message->*

Header.fieldSeparator->|

Header.endSeparator->'nl'

Header.keyFieldValue->1

Header.keyFieldlnStructure->ignore

Header.fieldNames-> paydate,enddate

DetailRecord.fieldSeparator->|

DetailRecord.endSeparator->'nl'

DetailRecord.fieldNames->PersonnelNumber,Infotype,Subtype,Field3,Field4,Field5

DetailRecord.keyFieldValue->1

DetailRecord.keyFieldlnStructure->ignore

TrailerRecord.fieldSeparator->|

TrailerRecord.endSeparator->'nl'

TrailerRecord.fieldNames-> TotalRecord,TotalAmount

TrailerRecord.keyFieldValue->1

TrailerRecord.keyFieldlnStructure->ignore

Regards

Vikas

[Former Member]

Hi Vikas

Even i have to validate whether Header record present or not using UDF

Can u help me in writing UDF... as i am new for writing UDF functions

Venkat

[Former Member]

Hi,

Refer this blog..

/people/swaroopa.vishwanath/blog/2005/06/24/generic-approach-for-validating-incoming-flat-file-in-sap-xi--part-1

/people/swaroopa.vishwanath/blog/2005/06/29/generic-approach-for-validating-incoming-flat-file-in-sap-xi--part-ii

I hope this might help you...

vasanth

[Former Member]

Hi Vasanth

Thanks for the Blogs

But i need to do that using the UDF

Do u have any blogs or links to check the header record using the UDF

venkat

[Former Member]

Hi Vikas

I am getting the Error

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'xml.keyfieldName': no value found

venkat

[Former Member]

Venkatesh,

In Content conversion parameters, there is a field called Key Field Name. Set you keyfield name there..Key Field is a field by which you identify every record from file.

Nilesh

[Former Member]

Hi

What if i dont have any Key Field by which i identify every record.. even then also i have to filled keyfield name..

venkat

[Former Member]

If you specified a variable number of substructures for Recordset Structure, in other words, at least one substructure has the value ‘*’, then the substructures must be identified by the parser from their content. A key field must be set with different constants for the substructures. In this case, you must specify a key field, and the field name must occur in all substructures.

Vaibhav

[Former Member]

Hi,

Parameters for File content conversion

Document name-> Source message type

Document Namespace

Recordset name-> XXX_ACEAward

Recordset Namespace->

Recordset structure->Header,1,Detail Record,1,TrailerRecord,1

Recordset per message->*

Header.fieldSeparator->|

Header.endSeparator->'nl'

Header.keyFieldValue->1

Header.keyFieldlnStructure->ignore

Header.fieldNames-> paydate,enddate

DetailRecord.fieldSeparator->|

DetailRecord.endSeparator->'nl'

DetailRecord.fieldNames->PersonnelNumber,Infotype,Subtype,Field3,Field4

DetailRecord.keyFieldValue->1

DetailRecord.keyFieldlnStructure->ignore

TrailerRecord.fieldSeparator->|

TrailerRecord.endSeparator->'nl'

TrailerRecord.fieldNames-> TotalRecord,TotalAmount

TrailerRecord.keyFieldValue->1

TrailerRecord.keyFieldlnStructure->ignore

Regards,

S.RamNarender

Message was edited by:

Ram Narender

[Former Member]

Hi Ram

Could u explain me whats the use of KeyfieldValue and ketFieldInStructure parameters...

venkat

[Former Member]

Hi,

for KeyfieldValue & keyFieldInStructure

Refer this

http://help.sap.com/saphelp_nw70/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

vasanth

[Former Member]

But as you mentioned on the reply for FCC

we have set the Key field name ...but we are using in the KeyFiledValue ...it does not show any error..

venkat

[Former Member]

Sorry Structure is like

DT_ AwardInformation

XXX_ACEAward

<b>Header</b>

PayDate

EndDate

<b>DetailRecord</b>

PersonnelNumber

Infotype

Subtype

Field3

Field4

Field5

<b>TrailerRecord</b>

TotalRecord

TotalAmount

[Former Member]

Hi,

Refer this blogs.....which talks about FCC

http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCC

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp - FCC

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy - FCC

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter - EOIO - File

I hope this might help you...

regards,

vasanth.