Content conversion parameters

[Former Member]

Hi All,

Need your help regarding file adapter....

I have data structure like

<b>Structure Category Occrrence</b>

DTPaymentadvice

PaymentDetails <b>Element</b> 0...unbounded - main root node

PaymentAdvice <b>Element</b> 1 -sub root node1

ProductCode <b>Element</b> 0..1 - field1 node

DebitCCode <b>Element</b> 0..1 - field2 node

DebitAccount <b>Element</b> 0..1 - field3 node

PymtCurrency <b>Element</b> 0..1 -- field4 node

Blank1 <b>Element</b> 0..1 -- sub root node2

EmailID1 <b>Element</b> 0..1 -field1 of sub root node2

Blank2 <b>Element</b> 0..1 -- sub root node3

EmailID2 <b>Element</b> 0..1 -field1 of sub root node3

InvoiceHead <b>Element</b> 0..1 --sub root node4

InvoiceHeader <b>Element</b> 0..1 ---field1 of sub root node4

InvoiceDataINV <b>Element</b> 0......unbounded ---sub root node5

DataInv <b>Element</b> 0..1 ---field1 of sub root node5

I need to get output like below

DFT@IN@1234567890@INR@ 33540.00@@20060628@2000000110@@@@@@@@@@@@Khandelwal Metal -> PaymentAdvice details

INV@ -> blank1

INV@ -> blank2

INV@ -> blank3

INV@ -> blank4

INV@ -> blank5

INV@PO NUMBER. INV.REF. DOC. NUM INV.AMOUNT DED. NET.AMOUNT. ->InvoiceHead

INV@ SDASA 2200000274 15000.000.00 15000.00. -> InvoiceDataINV

INV@ SASAS 2200000275 4500.000.00 4500.00. ->InvoiceDataINV

<b>currently I specified in content conversion parameters</b>

Recordset Strucuture PaymentDetails

PaymentDetails.fieldSeparator @

PaymentDetails.endSepartor @

but now i am getting my file output like

DFT@IN@

which is the value of first field in PaymentAdvice

Please let me know how to specify the content conversion parameters to get my requried output. let me know if any more details required.

Regards,

Dhill.

[justin_santhanam]

Dhil,

Can you populate the sample data in your o/b payload and reply back, since its little bit confusing.

Best regards,

raj.

[Former Member]

Hi raj,

below is my actual data

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

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">

<ns0:Message1>

<ns1:MTPaymentadviceFile xmlns:ns1="http://deere.com/xi/ijdcitibank">

<PaymentDetails>

<PaymentAdvice>

<ProductCode>EFT</ProductCode>

<DebitCCode>IN</DebitCCode>

<DebitAccount>36141016</DebitAccount>

<PymtCurrency>USD</PymtCurrency>

<PymtAmount>4100.00</PymtAmount>

<Branchcode/>

<ValueDate>20070530</ValueDate>

<TransactionReferenceNumber>2000000075</TransactionReferenceNumber>

<PreformatGroupCode/>

<PreformatCode/>

<ConfidentialIndicator/>

<OrderingPartyType/>

<OrderingPartyID/>

<OrderingPartyName/>

<OrderingPartyAddress1/>

<OrderingPartyAddress2/>

<OrderingPartyAddress3/>

<OrderingPartyRoutingMethod/>

<OrderingPartyRoutingCode/>

<BeneficiaryName>BRINEY SALES INC</BeneficiaryName>

<BeneficiaryAddress1/>

<BeneficiaryAddress2/>

<BeneficiaryAddress3>BAD AXE484139489US</BeneficiaryAddress3>

<BeneficiaryAccountType>01</BeneficiaryAccountType>

<BeneficiaryAccountNumber>123444</BeneficiaryAccountNumber>

<BeneficiaryReference/>

<BeneficiaryBankName>STATE STREET BANK AND TRUST CO</BeneficiaryBankName>

<BeneficiaryBankAddress1>02110 BOSTON</BeneficiaryBankAddress1>

<BeneficiaryBankAddress2/>

<BeneficiaryBankAddress3/>

<BeneficiaryBankRoutingMethod>IS</BeneficiaryBankRoutingMethod>

<BeneficiaryBankRoutingCode>SBOSUS33XXX</BeneficiaryBankRoutingCode>

<BeneficiaryBankAccountID/>

<BeneficiaryBankAccount/>

<BeneficiaryBankAdviceType/>

<PaymentDetails1>28053</PaymentDetails1>

<PaymentDetails2>20070528</PaymentDetails2>

<PaymentDetails3/>

<PaymentDetails4/>

<BeneficiaryIs/>

<BanktoBankInformationLine1/>

<BanktoBankInformationLine2/>

<BanktoBankInformationLine3/>

<BanktoBankInformationLine4/>

<BanktoBankInformationLine5/>

<BanktoBankInformationLine6/>

<IntermediaryBankRoutingMethod/>

<IntermediaryBankRoutingCode/>

<IntermediaryBankName/>

<IntermediaryBankAddress1/>

<IntermediaryBankAddress2/>

<IntermediaryBankAddress3/>

<IntermediaryBankCountryCode/>

<IntermediaryBankCountryName/>

<FXContract/>

<ExchangeRate/>

<IntraCompanyIndicator/>

<ChargesIndicator/>

<ChargesAccount/>

<PriorityFlag/>

<PreAdviceFlag/>

<NumberOfCreditParties/>

<EntryDescription/>

<SecondIntermediaryBankOtherIDType/>

<SecondIntermediaryBankOtherID/>

<SecondIntermediaryBankAdviceType/>

<SecondIntermediaryBankName/>

<SecondIntermediaryBankAddress1/>

<SecondIntermediaryBankAddress2/>

<SecondIntermediaryBankAddress3/>

<AdviceToName/>

<AdviceMediaAdviceType/>

<FaxNumber/>

<AlternateFaxNumber/>

<ContactPhoneNumber/>

<InternetAddressAccountName/>

<PaymentType/>

<TransactionType/>

<MailToName/>

<MailToAddress1/>

<MailToAddress2/>

<MailToAddress3/>

<MailToAddress4/>

<MailToCountryCode/>

<MailToCountryName/>

<BeneficiaryCountryCode/>

<BeneficiaryCountryName/>

<ClearingCountryCode/>

<ClearingCountryName/>

<PayableAtLocation/>

<PDCDiscounting/>

<CustomField1/>

<CustomField2/>

<CustomField3/>

<CustomField4/>

<CustomField5>NOADVISE</CustomField5>

<CustomField6>N</CustomField6>

<CustomField7/>

<CustomField8/>

<CustomField9/>

<CustomField10/>

<CustomField11/>

<CustomField12/>

<CustomField13/>

<CustomField14/>

<CustomField15/>

<CustomField16/>

<CustomField17/>

<CustomField18/>

<CustomField19/>

<CustomField20/>

<Constant>@</Constant>

</PaymentAdvice>

<Blank1>

<EmailID1>INV@ . </EmailID1>

</Blank1>

<Blank2>

<EmailID2>INV@ . </EmailID2>

</Blank2>

<Blank3>

<Blank3>INV@ . </Blank3>

</Blank3>

<Blank4>

<Blank4>INV@ . </Blank4>

</Blank4>

<Blank5>

<Blank5>INV@ . </Blank5>

</Blank5>

<InvoiceHead>

<InvoiceHeader>INV@PYT.AMT. CUR INV.NO. REF.FIELD INV.DATE. . </InvoiceHeader>

</InvoiceHead>

<InvoiceDataINV>

<DataInv>INV@ 3000.00 USD 1900000165 28051 20070528 . </DataInv>

</InvoiceDataINV>

<InvoiceDataINV>

<DataInv>INV@ 1000.00 USD 1900000166 28052 20070528 . </DataInv>

</InvoiceDataINV>

<InvoiceDataINV>

<DataInv>INV@ 100.00 USD 1900000167 28053 20070528 . </DataInv>

</InvoiceDataINV>

<InvoiceDataCRM/>

<InvoiceDataCRM/>

<InvoiceDataCRM/>

</PaymentDetails>

</ns1:MTPaymentadviceFile>

</ns0:Message1>

</ns0:Messages>

I can see the same data in sxmb_moni and RWB also but not coming in file.. please help out on this.

Regards,

Dhill

[justin_santhanam]

Dhil,

Sorry for the late reply. Please find the below content conversions

<b>Recordset Structure</b> : PaymentDetails,PaymentAdvice,Blank1,Blank2,Blank3,Blank4,Blank5,InvoiceHead,InvoiceDataINV

PaymentDetails.endSeparator 'nl'

PaymentDetails.fieldSeparator @

PaymentAdvice.fieldSeparator @

PaymentAdvice.endSeparator @

Blank1.fieldSeparator @

Blank1.endSeparator @

Blank2.fieldSeparator @

Blank2.endSeparator @

Blank3.fieldSeparator @

Blank3.endSeparator @

Blank4.fieldSeparator @

Blank4.endSeparator @

Blank5.fieldSeparator @

Blank5.endSeparator @

InvoiceHead.fieldSeparator @

InvoiceHead.endSeparator @

InvoiceDataINV.fieldSeparator @

InvoiceDataINV.endSeparator @

Best Regards,

raj.