Solved: Xpath expression

458

SAP Managed Tags:
SAP Business One

Hi experts,

I have this kind of file :

<Msg>

<Body>

<Msg>

<Body>

<BOM>

<BO>

...........

</Documents>

</BO>

</BOM>

</Payload>

</Body>

</Msg>

</Payload>

</bODY>

</mSG>

I would like to get the value of DocEntry in my <xsl:value of select=""/> but I don't know what is the correct syntaxe to use with the payload S.

Can you help me please?

Thanks

Best regards

Sarah

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

Comment

Hello Sarah,

Try this Msg/Body/Payload[@Role='S']/Msg/Body/Payload[@Role='S']/BOM/BO/Documents/DocEntry, if this xml came from an atom, try $msg//Msg/Body/Payload[@Role='S']/BOM/BO/Documents/DocEntry.

Regards,

Leo.

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

Comment

Hi Leo,

It's doesn't work the system doesn't get back the value

Any other suggestions please?

Thanks

Regards,

sarah

Hi Sarah,

Can you post here the real message from B1iF? Maybe the piece of message you paste before wasn't complete, so the xpath that I typed doesn't work.

Regards,

Leo.

Hi Leo,

This is the message in Message Log for my second step:

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

- <Msg xmlns="urn:com.sap.b1i.vplatform:entity" MessageId="140807162716667584350A0000221785" BeginTimeStamp="20140807162716" logmsg="0044" status="success" msglogexcl="false" MessageLog="true" SubMessageId="1" BackMessageId="2" DelMessageId="" b1msg="Exception : DI Error: (-10) Enter due date [ORDR.DocDueDate]" b1status="failure" vBIU.errhdlg="" exceptionmsg="Exception : DI Error: (-10) Enter due date [ORDR.DocDueDate]">

- <Header>

- <ErrorHandler phase="" async="Default error handling" sync="Default error handling" outbound="Default error handling" errorinbox="true">

- <delqueue status="false" qok="false">

<stream>S.Z.CCMarkSqlParrot</stream>

</delqueue>

- <callvBIU status="true">

</callvBIU>

</ErrorHandler>

- <Resumption>

</Resumption>

- <Variables>

</Variables>

- <ReceiverList>

</ReceiverList>

</Header>

- <Body>

- <Payload Role="S">

- <vPStatus xmlns="" status="success" no="0000" Message="processing finished" Phase="final" B1IMessageId="140807162713667571100A0000225F0B" SubMessageId="4_1" BeginTimeStamp="20140807162713" EndTimeStamp="20140807162715" SenderSysId="0010000100" ReceiverSysId="0010000107" SenderObjectTypeId="17" ReceiverObjectTypeId="" succ="Z.CCMarkSqlParrot">

- <Msg xmlns="urn:com.sap.b1i.vplatform:entity" MessageId="140807162713667571100A0000225F0B" BeginTimeStamp="20140807162713" recording="true" logmsg="0000" SubMessageId="4_1" status="success" msglogexcl="false" MessageLog="true" b1msg="" b1status="success" BackMessageId="4_2" DelMessageId="4">

- <Header>

- <Resumption>

</Resumption>

- <Variables>

</Variables>

- <VarProperties>

</VarProperties>

- <ReceiverList>

</ReceiverList>

</Header>

- <Body>

- <Payload Role="T" Type="B1Event" add="">

- <Event xmlns="" B1EventFilter="false">

- <b1e:b1events xmlns:b1e="urn:com.sap.b1i.sim:b1event">

- <b1e:b1event>

<b1e:eventsource>Parrot_Prod_New</b1e:eventsource>

<b1e:objecttype>17</b1e:objecttype>

<b1e:transactiontype>A</b1e:transactiontype>

<b1e:usercode>manager</b1e:usercode>

<b1e:userid>manager</b1e:userid>

- <b1e:keys count="1">

- <b1e:key>

<b1e:name>DocEntry</b1e:name>

<b1e:value>81628</b1e:value>

</b1e:key>

</b1e:keys>

<b1e:sourcesite>DEV-PARROT</b1e:sourcesite>

</b1e:b1event>

</b1e:b1events>

- <b1ie:B1IEvent xmlns:b1ie="urn:com.sap.b1i.sim:b1ievent" SysId="0010000100" SysTypeId="B1.8.8" Task="I" LocalObjectType="17">

- <b1ie:PrimaryKeyList>

<b1ie:PrimaryKey Key="DocEntry" Value="81628" />

</b1ie:PrimaryKeyList>

</b1ie:B1IEvent>

</Event>

</Payload>

- <Payload Role="S" Result="0000" Msg="">

- <BOM xmlns="">

- <BO>

- <AdmInfo>

</AdmInfo>

- <Documents>

- <row>

<DocType>dDocument_Items</DocType>

<CardName>Parrot_Prod_New</CardName>

<JournalMemo>Sales Orders - 11223</JournalMemo>

<SummeryType>dNoSummary</SummeryType>

<WareHouseUpdateType>dwh_CustomerOrders</WareHouseUpdateType>

<PeriodIndicator>Valeur par</PeriodIndicator>

<BPL_IDAssignedToInvoice nil="true">0</BPL_IDAssignedToInvoice>

<DownPaymentType>dptInvoice</DownPaymentType>

<EDocGenerationType>edocNotRelevant</EDocGenerationType>

<ClosingOption>coByCurrentSystemDate</ClosingOption>

<AuthorizationStatus>dasWithout</AuthorizationStatus>

<U_GTI_D004 nil="true" />

<U_GTI_D006 nil="true" />

<U_GTI_D013>0.000000</U_GTI_D013>

<U_GTI_D014>0.000000</U_GTI_D014>

<U_GTI_D021 nil="true" />

<U_GTI_D022 nil="true" />

<U_GTI_D023 nil="true" />

<U_GTI_D053 nil="true" />

<U_GTI_D054 nil="true" />

<U_PAR_D003 nil="true" />

<U_PAR_D002 nil="true" />

<U_IFC_OLD nil="true">0</U_IFC_OLD>

<U_IFC_NbColis>0.000000</U_IFC_NbColis>

<U_IFC_Bq />

<U_IFC_AchTel nil="true" />

<U_IFC_AchMail nil="true" />

<U_PFL_TypCde>NO</U_PFL_TypCde>

<U_PFL_Afact>N</U_PFL_Afact>

<U_PFL_CptClientTpt nil="true" />

<U_PFL_ServiceTpt nil="true" />

<U_PFL_ActiviteCde nil="true" />

<U_PFL_NumTransKN1 nil="true" />

<U_PFL_NumTransKN2 nil="true" />

<U_PFL_DateTransKN1 nil="true" />

<U_PFL_DateTransKN2 nil="true" />

<U_PFL_NumBLKN nil="true" />

<U_PFL_DatePrepaKN nil="true" />

<U_PFL_DateExpeKN nil="true" />

<U_PFL_Conformite nil="true" />

<U_PFL_NumTrack nil="true" />

<U_PFL_RangPrepa>50</U_PFL_RangPrepa>

<U_PAR_D004>N</U_PAR_D004>

<U_HK_TSF nil="true" />

<U_HK_FR nil="true" />

<U_HK_RECHK nil="true" />

<U_HK_RECFR nil="true" />

<U_HK_FACHK nil="true" />

<U_HK_DATE_TSF nil="true" />

<U_HK_TIME_TSF nil="true">0000</U_HK_TIME_TSF>

<U_HK_TEXTE nil="true" />

<U_MA_ClientCode_N1 nil="true" />

<U_MA_ClientName_N2 nil="true" />

<U_MA_Channel_N2 />

<U_MA_ApprovalNumber nil="true" />

<U_MA_Detail_TO nil="true" />

<U_MA_Bdgt_EURinHQ nil="true" />

<U_MA_Turnover_EUR nil="true" />

<U_MA_HQ_Budget_EUR nil="true" />

<U_MA_ROI nil="true" />

<U_FL_TSF nil="true" />

<U_SAV_RMA nil="true">0</U_SAV_RMA>

<U_SAV_Tobeduplicated>N</U_SAV_Tobeduplicated>

<U_SAV_Duplicated>N</U_SAV_Duplicated>

<U_SAV_Duplicatedate nil="true" />

<U_SAV_NumTransIbolt nil="true" />

<U_BUDT_FWD nil="true" />

<U_BUDT_FWD_Note_1 nil="true" />

<U_BUDT_FWD_Note_2 nil="true" />

<U_PFL_Poids>0.000000</U_PFL_Poids>

<U_CR_ImpEDI>N</U_CR_ImpEDI>

<U_CR_BuyEDI>N</U_CR_BuyEDI>

<U_CR_Entrega>N</U_CR_Entrega>

<U_CR_Cliente nil="true" />

<U_CR_DirPedi>N</U_CR_DirPedi>

<U_CR_ImpDate nil="true" />

<U_CR_DepEDI>N</U_CR_DepEDI>

<U_CR_TemEDI>N</U_CR_TemEDI>

<U_CR_SucEDI>N</U_CR_SucEDI>

<U_CR_DlnEDI>N</U_CR_DlnEDI>

<U_CR_InvEDI>N</U_CR_InvEDI>

<U_ESP_Portes>Y</U_ESP_Portes>

<U_ESP_PrtImp>0</U_ESP_PrtImp>

<U_PFL_email nil="true" />

<U_PFL_phone nil="true" />

<U_PFL_carrier_info nil="true" />

<U_ExRefNo nil="true" />

<U_B1i_RefSO nil="true" />

<U_B1i_CUST_SCG>No</U_B1i_CUST_SCG>

<U_B1i_DS>No</U_B1i_DS>

<U_CR_RMA nil="true">0</U_CR_RMA>

<U_CR_RMANum nil="true">0</U_CR_RMANum>

<U_CR_RMACNum nil="true">0</U_CR_RMACNum>

<U_CR_RMATNum nil="true">0</U_CR_RMATNum>

<U_CR_RMARecep nil="true" />

<U_CR_RMADate nil="true" />

<U_CR_RMATime nil="true">0000</U_CR_RMATime>

<U_PFL_ship_status nil="true" />

<U_PFL_ship_date nil="true" />

<U_PFL_carrier_id nil="true" />

<U_PFL_carrier_name nil="true" />

<U_PFL_carrier_tracki nil="true" />

<U_PFL_carrier_weblin nil="true" />

<U_PFL_nb_pallet>0.000000</U_PFL_nb_pallet>

<U_PFL_volume_total>0.000000</U_PFL_volume_total>

<U_EZ_DocNum nil="true" />

<U_EZ_Requestor nil="true" />

<U_EZ_CostingCodeH1 nil="true" />

<U_EZ_CostingCodeH2 nil="true" />

<U_EZ_CostingCodeH3 nil="true" />

<U_EZ_CostingCodeH4 nil="true" />

<U_EZ_CostingCodeH5 nil="true" />

</row>

</Documents>

- <Document_Lines>

- <row>

<ItemDescription>FAISCEAU TOYOTA</ItemDescription>

<TreeType>iNotATree</TreeType>

<Address>Geodis - Bat Evl3 - Activite Parrot Z.i La piece de la remise - Route de Corbeil 91004 EVRY FRANCE</Address>

<CorrectionInvoiceItem>ciis_ShouldBe</CorrectionInvoiceItem>

<SWW />

<PickStatusEx>dlps_NotPicked</PickStatusEx>

<LineType>dlt_Regular</LineType>

<U_GTI_E021>N</U_GTI_E021>

<U_GTI_E046>Y</U_GTI_E046>

<U_GTI_E032 nil="true" />

<U_GTI_E082 nil="true" />

<U_PAR_E088 nil="true" />

<U_PAR_E087 nil="true" />

<U_IFC_OLD nil="true">0.000000</U_IFC_OLD>

<U_PAR_TYMA>01</U_PAR_TYMA>

<U_PFL_NumCdeCompt nil="true" />

<U_PFL_DateExpImp nil="true" />

<U_PFL_NumTransIbolt nil="true" />

<U_PFL_Aconsigner>N</U_PFL_Aconsigner>

<U_PFL_Consigne>N</U_PFL_Consigne>

<U_PFL_REF_HA nil="true" />

<U_IBO_RefHA nil="true" />

<U_MARK_COSTS nil="true" />

<U_MARK_CHANNELS nil="true" />

<U_MARK_BUD nil="true" />

<U_FA_NEM nil="true">0</U_FA_NEM>

<U_EDI_Tax_1>0.000000</U_EDI_Tax_1>

<U_EDI_Tax_2>0.000000</U_EDI_Tax_2>

<U_EDI_Tax_3>0.000000</U_EDI_Tax_3>

<U_ExRefNo nil="true" />

<U_ExPrice nil="true">0.000000</U_ExPrice>

<U_ExCurrency nil="true" />

<U_IMMO_USE_SUP_1>N</U_IMMO_USE_SUP_1>

<U_IMMO_LOCAL nil="true" />

<U_FOU_tobeexported>N</U_FOU_tobeexported>

<U_FOU_exported>N</U_FOU_exported>

<U_FOU_date nil="true" />

<U_FOU_ibolt_id nil="true" />

<U_FOU_po_num nil="true" />

<U_IFC_NBCOLIS nil="true">0</U_IFC_NBCOLIS>

<U_IFC_NBP nil="true">0</U_IFC_NBP>

<U_B1I_BaseLine nil="true" />

<U_EZ_LineNum nil="true" />

<U_EZ_DocNum nil="true" />

<U_EZ_CostingCodeL1 nil="true" />

<U_EZ_CostingCodeL2 nil="true" />

<U_EZ_CostingCodeL3 nil="true" />

<U_EZ_CostingCodeL4 nil="true" />

<U_EZ_CostingCodeL5 nil="true" />

<U_PFL_LotNumber nil="true" />

</row>

</Document_Lines>

- <TaxExtension>

- <row>

</row>

</TaxExtension>

- <AddressExtension>

- <row>

</row>

</AddressExtension>

</BO>

</BOM>

</Payload>

- <Payload Role="C" id="atom1" system="0010000100" mode="single" method="Query Statement(Query Statement)" sql="SELECT Name from [@GTI0004] where Code=''" disable-output-escaping="false">

</Payload>

- <Payload id="atom0" Role="R">

- <Fileout xmlns="" type="file">

- <BOM>

- <BO>

- <AdmInfo>

<Object>Commande Client</Object>

<DO>PARROT</DO>

<Ident-DO>39414949600025</Ident-DO>

<Entrepot>GEODIS_EVRY_PARROT</Entrepot>

<Ident-Entrepot>3016001500804</Ident-Entrepot>

</AdmInfo>

- <CommandeClient>

<nom-client>Parrot_Prod_New</nom-client>

<num-ref-client />

<date-commande>20140807</date-commande>

<date-livraison>20140808</date-livraison>

<code-incoterm />

<lieu-incoterm />

<code-postale />

<ident-fiscal />

<type-commande>NO</type-commande>

<a-facturer>N</a-facturer>

<priorite-preparation>50</priorite-preparation>

<nb_colis_total>0.000000</nb_colis_total>

<nb_palette_total>0.000000</nb_palette_total>

<volume_total>0.000000</volume_total>

<poids_total>0.000000</poids_total>

</CommandeClient>

- <CommandeClient-Lines>

- <row>

<num-ligne>0</num-ligne>

<code-article>AC000005AA</code-article>

<desc-article>FAISCEAU TOYOTA</desc-article>

</row>

</CommandeClient-Lines>

</BO>

</BOM>

</Fileout>

</Payload>

- <Payload Role="R2">

- <Fileout xmlns="" type="file">

- <BOM>

- <BO>

- <AdmInfo>

<Object>Commande Client</Object>

<DO>PARROT</DO>

<Ident-DO>39414949600025</Ident-DO>

<Entrepot>GEODIS_EVRY_PARROT</Entrepot>

<Ident-Entrepot>3016001500804</Ident-Entrepot>

</AdmInfo>

- <CommandeClient>

<nom-client>Parrot_Prod_New</nom-client>

<num-ref-client />

<date-commande>20140807</date-commande>

<date-livraison>20140808</date-livraison>

<code-incoterm />

<lieu-incoterm />

<code-postale />

<ident-fiscal />

<type-commande>NO</type-commande>

<a-facturer>N</a-facturer>

<priorite-preparation>50</priorite-preparation>

<nb_colis_total>0.000000</nb_colis_total>

<nb_palette_total>0.000000</nb_palette_total>

<volume_total>0.000000</volume_total>

<poids_total>0.000000</poids_total>

</CommandeClient>

- <CommandeClient-Lines>

- <row>

<num-ligne>0</num-ligne>

<code-article>AC000005AA</code-article>

<desc-article>FAISCEAU TOYOTA</desc-article>

</row>

</CommandeClient-Lines>

</BO>

</BOM>

</Fileout>

</Payload>

</Body>

</Msg>

</vPStatus>

</Payload>

- <Payload Role="R" id="atom0">

- <B1out xmlns="" type="object">

- <Documents>

- <row>

<DocType>dDocument_Items</DocType>

</row>

</Documents>

<Document_Lines />

</B1out>

</Payload>

- <Payload Role="R2" Call="object" Type="DIAPI">

- <Envelope xmlns="">

- <Header>

</Header>

- <Body>

- <BOM>

- <BO>

- <AdmInfo>

</AdmInfo>

- <QueryParams>

</QueryParams>

- <Documents>

- <row>

<DocType>dDocument_Items</DocType>

</row>

</Documents>

<Document_Lines />

</BO>

</BOM>

</Body>

</Envelope>

</Payload>

</Body>

</Msg>

Hi Sarah

Based on your input you should be able to get value of DocEntry using one of two methods:


<xsl:template name="transform">
    <DocEntry>
      <xsl:value-of select="//b1e:value"/>
    </DocEntry>
    <DocEntry2>
     <xsl:value-of select="//vpf:Payload[./@Role = 'S' and @Result != '']//DocEntry"/>
    </DocEntry2>
  </xsl:template>

Since Msg element belongs to a namespace xmlns="urn:com.sap.b1i.vplatform:entity" you should almost always attach 'vpf:' prefix to Payload, Body and Msg tags.

Kind regards,

Radek

Hi Sarah,

try this


/vpf:Msg/vpf:Body/vpf:Payload[@Role='S']/*/vpf:Msg/vpf:Body/vpf:Payload[@Role='S']/*/*/*[local-name(.)='Documents']/*/*[local-name(.)='DocEntry']

Regards,

Leo.

Great Radek, Much easier !!

Hi Radek,

it's work thank you very much!!

Just another question, now I have access to DocEntry i want to update row of my order.

I have to access to Document_Lines but it's the same problem how to access if it's in the inbound of the first step?

your method works for the DocEntry but I don't see how to do with other things?

Thank you very much

regards

sarah

Hi Radek,

I find my answer with your second method thank you

regards,

sarah

Hi Radek and Leo,

I don't know if it's because the syntax but when I do that:

<row>

<DocType>dDocument_Items</DocType>

</row>

</Documents>

<Document_Lines>

<xsl:for-each select="//vpf:Payload[./@Role = 'S' and @Result != '']//Document_Lines/*">

<xsl:if test= "//vpf:Payload[./@Role = 'S' and @Result != '']//Document_Lines/row/U_GTI_E046='Y' and //vpf:Payload[./@Role = 'S' and @Result != '']//Document_Lines/row/U_GTI_E021='N'">

<row>

<U_GTI_E021>Y</U_GTI_E021>

<U_PFL_DateExpImp>

<xsl:value-of select="//vpf:Payload[./@Role = 'S' and @Result != '']//CreationDate"/>

</U_PFL_DateExpImp>

</row>

</if>

</xsl:for-each>

</Document_Lines>

</B1out>

The sytem read always the first line and not the other. because of that I can't do update my order correctly.

Can you help me again with that please?

Thank you very much

regards

Sarah

Hi Sarah

The following document has helped me many times when dealing with XSLT:

http://www.ibm.com/developerworks/library/x-xsltmistakes/

I think that your current problem is related to 'Don't lose the context node' section, listening 8.

Hope this helps - otherwise please send your input XML.

Kind regards,

Radek

Hi radek

this is my input xml:

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

- <Msg xmlns="urn:com.sap.b1i.vplatform:entity" MessageId="140808111554328763920A000022D64E" BeginTimeStamp="20140808111554" logmsg="0000" status="success" msglogexcl="false" MessageLog="true" SubMessageId="1" BackMessageId="2" DelMessageId="" b1msg="" b1status="success">

- <Header>

- <Resumption>

</Resumption>

- <Variables>

</Variables>

- <Properties>

</Properties>

- <ReceiverList>

</ReceiverList>

</Header>

- <Body>

- <Payload Role="S">

- <vPStatus xmlns="" status="success" no="0000" Message="processing finished" Phase="final" B1IMessageId="140808111551328754440A000022D896" SubMessageId="4_1" BeginTimeStamp="20140808111551" EndTimeStamp="20140808111553" SenderSysId="0010000100" ReceiverSysId="0010000107" SenderObjectTypeId="17" ReceiverObjectTypeId="" succ="Z.CCMarkSqlParrot">

- <Msg xmlns="urn:com.sap.b1i.vplatform:entity" MessageId="140808111551328754440A000022D896" BeginTimeStamp="20140808111551" recording="true" logmsg="0000" SubMessageId="4_1" status="success" msglogexcl="false" MessageLog="true" b1msg="" b1status="success" BackMessageId="4_2" DelMessageId="4">

- <Header>

- <Resumption>

</Resumption>

- <Variables>

</Variables>

- <Properties>

</Properties>

- <VarProperties>

</VarProperties>

- <ReceiverList>

</ReceiverList>

</Header>

- <Body>

- <Payload Role="T" Type="B1Event" add="">

- <Event xmlns="" B1EventFilter="false">

- <b1e:b1events xmlns:b1e="urn:com.sap.b1i.sim:b1event">

- <b1e:b1event>

<b1e:eventsource>Parrot_Prod_New</b1e:eventsource>

<b1e:objecttype>17</b1e:objecttype>

<b1e:transactiontype>A</b1e:transactiontype>

<b1e:usercode>manager</b1e:usercode>

<b1e:userid>manager</b1e:userid>

- <b1e:keys count="1">

- <b1e:key>

<b1e:name>DocEntry</b1e:name>

<b1e:value>81647</b1e:value>

</b1e:key>

</b1e:keys>

<b1e:sourcesite>DEV-PARROT</b1e:sourcesite>

</b1e:b1event>

</b1e:b1events>

- <b1ie:B1IEvent xmlns:b1ie="urn:com.sap.b1i.sim:b1ievent" SysId="0010000100" SysTypeId="B1.8.8" Task="I" LocalObjectType="17">

- <b1ie:PrimaryKeyList>

<b1ie:PrimaryKey Key="DocEntry" Value="81647" />

</b1ie:PrimaryKeyList>

</b1ie:B1IEvent>

</Event>

</Payload>

- <Payload Role="S" Result="0000" Msg="">

- <BOM xmlns="">

- <BO>

- <AdmInfo>

</AdmInfo>

- <Documents>

- <row>

<DocType>dDocument_Items</DocType>

<CardName>PARROT MARKETING - CHANNEL MARKETING</CardName>

<Address>174 Quai de Jemmapes (3eme Etage) 75010 PARIS FRANCE</Address>

<JournalMemo>Sales Orders - 400001</JournalMemo>

<SummeryType>dNoSummary</SummeryType>

<ShipToCode>PARROT SA (Marketing) - CHANNEL</ShipToCode>

<WareHouseUpdateType>dwh_CustomerOrders</WareHouseUpdateType>

<Address2>174 Quai de Jemmapes Escalier B - 3eme etage - Canal 75010 PARIS FRANCE</Address2>

<PeriodIndicator>Valeur par</PeriodIndicator>

<PayToCode>PARROT SA</PayToCode>

<BPL_IDAssignedToInvoice nil="true">0</BPL_IDAssignedToInvoice>

...

<U_PFL_ServiceTpt nil="true" />

<U_PFL_ActiviteCde nil="true" />

<U_PFL_NumTransKN1 nil="true" />

<U_PFL_NumTransKN2 nil="true" />

<U_PFL_DateTransKN1 nil="true" />

<U_PFL_DateTransKN2 nil="true" />

<U_PFL_NumBLKN nil="true" />

<U_PFL_DatePrepaKN nil="true" />

<U_PFL_DateExpeKN nil="true" />

<U_PFL_Conformite nil="true" />

<U_PFL_NumTrack nil="true" />

<U_PFL_RangPrepa>50</U_PFL_RangPrepa>

<U_PAR_D004>N</U_PAR_D004>

<U_HK_TSF nil="true" />

<U_HK_FR nil="true" />

<U_HK_RECHK nil="true" />

<U_HK_RECFR nil="true" />

...

</row>

</Documents>

- <Document_Lines>

- <row>

<ItemDescription>X - Faisceau adaptateur VOLVO</ItemDescription>

<TreeType>iNotATree</TreeType>

<Address>Kuehne + Nagel Distripôle Parisud – Bât 2 -secteur 3 77124 LIEUSAINT FRANCE</Address>

<CorrectionInvoiceItem>ciis_ShouldBe</CorrectionInvoiceItem>

<SWW />

<ShipToCode>PARROT SA (Marketing) - CHANNEL</ShipToCode>

<PickStatusEx>dlps_NotPicked</PickStatusEx>

<LineType>dlt_Regular</LineType>

<ShipToDescription>174 Quai de Jemmapes Escalier B - 3eme etage - Canal 75010 PARIS FRANCE</ShipToDescription>

<U_GTI_E021>N</U_GTI_E021>

<U_GTI_E046>Y</U_GTI_E046>

<U_GTI_E032 nil="true" />

<U_GTI_E082 nil="true" />

<U_PAR_E088 nil="true" />

<U_PAR_E087 nil="true" />

<U_IFC_OLD nil="true">0.000000</U_IFC_OLD>

<U_PAR_TYMA>01</U_PAR_TYMA>

<U_PFL_NumCdeCompt nil="true" />

<U_PFL_DateExpImp nil="true" />

<U_PFL_NumTransIbolt nil="true" />

<U_PFL_Aconsigner>N</U_PFL_Aconsigner>

<U_PFL_Consigne>N</U_PFL_Consigne>

...

</row>

- <row>

<ItemDescription>X-FAISCEAU CHRYSLER</ItemDescription>

<TreeType>iNotATree</TreeType>

<Address>Geodis - Bat Evl3 - Activite Parrot Z.i La piece de la remise - Route de Corbeil 91004 EVRY FRANCE</Address>

<CorrectionInvoiceItem>ciis_ShouldBe</CorrectionInvoiceItem>

<SWW />

<ShipToCode>PARROT SA (Marketing) - CHANNEL</ShipToCode>

<PickStatusEx>dlps_NotPicked</PickStatusEx>

<LineType>dlt_Regular</LineType>

<ShipToDescription>174 Quai de Jemmapes Escalier B - 3eme etage - Canal 75010 PARIS FRANCE</ShipToDescription>

<U_GTI_E021>N</U_GTI_E021>

<U_GTI_E046>Y</U_GTI_E046>

<U_GTI_E032 nil="true" />

<U_GTI_E082 nil="true" />

...

</row>

</Document_Lines>

- <TaxExtension>

- <row>

<StreetS>174 Quai de Jemmapes</StreetS>

...

</TaxExtension>

- <AddressExtension>

- <row>

<ShipToStreet>174 Quai de Jemmapes</ShipToStreet>

<ShipToBlock>Escalier B - 3eme etage - Canal</ShipToBlock>

<ShipToCity>PARIS</ShipToCity>

<BillToStreet>174 Quai de Jemmapes (3eme Etage)</BillToStreet>

<BillToCity>PARIS</BillToCity>

</row>

</AddressExtension>

</BO>

</BOM>

</Payload>

- <ResultSet xmlns="urn:com.sap.b1i.adapter:jdbcadapter" rowCount="1">

- <Row>

<Name>DSV Messagerie EU</Name>

</Row>

</ResultSet>

</Payload>

- <Payload id="atom0" Role="R">

- <Fileout xmlns="" type="file">

- <BOM>

- <BO>

- <AdmInfo>

<Object>Commande Client</Object>

<DO>PARROT</DO>

<Ident-DO>39414949600025</Ident-DO>

<Entrepot>GEODIS_EVRY_PARROT</Entrepot>

<Ident-Entrepot>3016001500804</Ident-Entrepot>

</AdmInfo>

- <CommandeClient>

<nom-client>PARROT MARKETING - CHANNEL MARKETING</nom-client>

<num-ref-client />

<date-commande>20140808</date-commande>

<date-livraison>20140809</date-livraison>

<nom-transporteur>DSV Messagerie EU</nom-transporteur>

<code-incoterm>DDU</code-incoterm>

<lieu-incoterm>PARIS</lieu-incoterm>

<adresse>174 Quai de Jemmapes</adresse>

<code-postale>75010</code-postale>

<ville>PARIS</ville>

<ident-fiscal>FR70394149496</ident-fiscal>

<type-commande>NO</type-commande>

<a-facturer>N</a-facturer>

<priorite-preparation>50</priorite-preparation>

<nb_colis_total>0.000000</nb_colis_total>

<nb_palette_total>0.000000</nb_palette_total>

<volume_total>0.000000</volume_total>

<poids_total>0.000000</poids_total>

</CommandeClient>

- <CommandeClient-Lines>

- <row>

<num-ligne>0</num-ligne>

<code-article>AC000007AA</code-article>

<desc-article>X - Faisceau adaptateur VOLVO</desc-article>

</row>

- <row>

<num-ligne>1</num-ligne>

<code-article>AC000010AA</code-article>

<desc-article>X-FAISCEAU CHRYSLER</desc-article>

</row>

</CommandeClient-Lines>

</BO>

</BOM>

</Fileout>

</Payload>

- <Payload Role="R2">

- <Fileout xmlns="" type="file">

- <BOM>

- <BO>

- <AdmInfo>

<Object>Commande Client</Object>

<DO>PARROT</DO>

<Ident-DO>39414949600025</Ident-DO>

<Entrepot>GEODIS_EVRY_PARROT</Entrepot>

<Ident-Entrepot>3016001500804</Ident-Entrepot>

</AdmInfo>

- <CommandeClient>

<nom-client>PARROT MARKETING - CHANNEL MARKETING</nom-client>

<num-ref-client />

<date-commande>20140808</date-commande>

<date-livraison>20140809</date-livraison>

<nom-transporteur>DSV Messagerie EU</nom-transporteur>

<code-incoterm>DDU</code-incoterm>

<lieu-incoterm>PARIS</lieu-incoterm>

<adresse>174 Quai de Jemmapes</adresse>

<code-postale>75010</code-postale>

<ville>PARIS</ville>

<ident-fiscal>FR70394149496</ident-fiscal>

<type-commande>NO</type-commande>

<a-facturer>N</a-facturer>

<priorite-preparation>50</priorite-preparation>

<nb_colis_total>0.000000</nb_colis_total>

<nb_palette_total>0.000000</nb_palette_total>

<volume_total>0.000000</volume_total>

<poids_total>0.000000</poids_total>

</CommandeClient>

- <CommandeClient-Lines>

- <row>

<num-ligne>0</num-ligne>

<code-article>AC000007AA</code-article>

<desc-article>X - Faisceau adaptateur VOLVO</desc-article>

</row>

- <row>

<num-ligne>1</num-ligne>

<code-article>AC000010AA</code-article>

<desc-article>X-FAISCEAU CHRYSLER</desc-article>

</row>

</CommandeClient-Lines>

</BO>

</BOM>

</Fileout>

</Payload>

</Body>

</Msg>

</vPStatus>

</Payload>

- <Payload Role="R" id="atom0">

- <B1out xmlns="" type="object">

- <Documents>

- <row>

<DocType>dDocument_Items</DocType>

</row>

</Documents>

- <Document_Lines>

- <row>

<U_GTI_E021>Y</U_GTI_E021>

<U_PFL_DateExpImp>20140808</U_PFL_DateExpImp>

<U_GTI_E021>Y</U_GTI_E021>

<U_PFL_DateExpImp>20140808</U_PFL_DateExpImp>

</row>

</Document_Lines>

</B1out>

</Payload>

- <Payload Role="R2" Call="object" Type="DIAPI">

- <Envelope xmlns="">

- <Header>

</Header>

- <Body>

- <BOM>

- <BO>

- <AdmInfo>

</AdmInfo>

- <QueryParams>

</QueryParams>

- <Documents>

- <row>

<DocType>dDocument_Items</DocType>

</row>

</Documents>

- <Document_Lines>

- <row>

<U_GTI_E021>Y</U_GTI_E021>

<U_PFL_DateExpImp>20140808</U_PFL_DateExpImp>

<U_GTI_E021>Y</U_GTI_E021>

<U_PFL_DateExpImp>20140808</U_PFL_DateExpImp>

</row>

</Document_Lines>

</BO>

</BOM>

</Body>

</Envelope>

</Payload>

</Body>

</Msg>

As you see the system read only line 0 twice (2 lines).

I would like test for each line the value of an attribut and if the test is ok update order but the code which I post doesn't work.

Did you see my error ou do you have an idea to do that please?

There is my code :

<row>

<DocType>dDocument_Items</DocType>

</row>

</Documents>

<Document_Lines>

<xsl:for-each select="//vpf:Payload[./@Role = 'S' and @Result != '']//Document_Lines/*">

<xsl:if test= "//vpf:Payload[./@Role = 'S' and @Result != '']//Document_Lines/row/U_GTI_E046='Y' and //vpf:Payload[./@Role = 'S' and @Result != '']//Document_Lines/row/U_GTI_E021='N'">

<row>

<U_GTI_E021>Y</U_GTI_E021>

<U_PFL_DateExpImp>

<xsl:value-of select="//vpf:Payload[./@Role = 'S' and @Result != '']//CreationDate"/>

</U_PFL_DateExpImp>

</row>

</if>

</xsl:for-each>

</Document_Lines>

</B1out>

Thanks

regards

Sarah

Hi Sarah

Actually in the document that I referred to in my previous comment you could find that for-each function creates new context:


The expression /invoice/item in xsl:for-each correctly selects all items in the invoice. But expressions inside xsl:for-each are wrong, as they start with /, which means that they're absolute. Such expressions always return a description, the quantity, and price of the first item (remember from the previous section that xsl:value-of returns only the first node from a node set), because an absolute expression does not depend on the current node, which corresponds to the currently processed item.
To easily fix this problem, use a relative expression inside xsl:for-each

i. e.: <xsl:if test= "U_GTI_E046='Y' and U_GTI_E021='N'">

Kind regards,

Radek

Hi Radek,

Sorry but I don't understand very well, What I suppose to put inside xsl:for each to considere all the lines and not just the first and to do my test on all the lines?

Thank you very much

Regards,

sarah

Hi Sarah

Your xsl:for-each is ok.

The only thing that needs to be changed is your if statement. Since when your loop is being executed it changes a processing context you don't have to use absolute paths inside your loop. Thus you need to change only your if statement to:

<xsl:if test= "U_GTI_E046='Y' and U_GTI_E021='N'">

Kind regards,

Radek

Hi Radek,

Thank you for your answer.

I try that you said but it doesn't work.

The test is made only on the first line and it's not made correctly.

My code is:

<row>

<DocType>dDocument_Items</DocType>

</row>

</Documents>

<Document_Lines>

<xsl:for-each select="//vpf:Payload[./@Role = 'S' and @Result != '']//Document_Lines/*">

<xsl:if test="U_GTI_E046='Y' and U_GTI_E021='N'">

<row>

<U_GTI_E021>Y</U_GTI_E021>

<U_PFL_DateExpImp>

<xsl:value-of select="//vpf:Payload[./@Role = 'S' and @Result != '']//CreationDate"/>

</U_PFL_DateExpImp>

</row>

</xsl:if>

</xsl:for-each>

</Document_Lines>

</B1out>

Is that ok?

Thank you very much for your help

Regards,

Sarah

Hi Radek,

I change the position of my if statement, I put after <row> and apparently it's work fine

Thank you very much for your help,

Regards,

Sarah

Great! It saves me headache - I just tried and it seemed to be working and I've have been struggling to figure out what's the reason for your problems.

I'm glad that I've been helpful.

Kind regards,

Radek

Hi Radek,

I work on another scenario but I have almost the same problem that at my first post.

I have scenario with two steps. First step export an order of sap to a file on a FTP. The second step get back this file from the FTP and create a Delivery notes in sap from this file.

The two steps are link by Succesor/predecessor,

This is the message from B1i:

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

- <Msg xmlns="urn:com.sap.b1i.vplatform:entity" MessageId="140812095722094324630A0000220F5C" BeginTimeStamp="20140812095722" logmsg="0044" status="success" msglogexcl="false" MessageLog="true" SubMessageId="1" BackMessageId="2" DelMessageId="" b1msg="Exception : DI Error: (-2028) No matching records found (ODBC -2028)" b1status="failure" vBIU.errhdlg="" exceptionmsg="Exception : DI Error: (-2028) No matching records found (ODBC -2028)">

- <Header>

- <ErrorHandler phase="" async="Default error handling" sync="Default error handling" outbound="Default error handling" errorinbox="true">

- <delqueue status="false" qok="false">

<stream>S.Z.Scenario2BonLivraison</stream>

</delqueue>

- <callvBIU status="true">

</callvBIU>

</ErrorHandler>

- <Resumption>

</Resumption>

- <Variables>

</Variables>

- <ReceiverList>

</ReceiverList>

</Header>

- <Body>

- <Payload Role="S">

- <vPStatus xmlns="" status="success" no="0000" Message="processing finished" Phase="final" B1IMessageId="140812095717094314920A000022BC74" SubMessageId="4_1" BeginTimeStamp="20140812095717" EndTimeStamp="20140812095722" SenderSysId="0010000100" ReceiverSysId="0010000107" SenderObjectTypeId="17" ReceiverObjectTypeId="" succ="Z.Scenario2BonLivraison">

- <Msg xmlns="urn:com.sap.b1i.vplatform:entity" MessageId="140812095717094314920A000022BC74" BeginTimeStamp="20140812095717" recording="true" logmsg="0000" SubMessageId="4_1" status="success" msglogexcl="false" MessageLog="true" b1msg="" b1status="success" BackMessageId="4_2" DelMessageId="4">

- <Header>

- <Resumption>

</Resumption>

- <Variables>

</Variables>

- <ReceiverList>

</ReceiverList>

</Header>

- <Body>

- <Payload Role="T" Type="B1Event" add="">

- <Event xmlns="" B1EventFilter="false">

- <b1e:b1events xmlns:b1e="urn:com.sap.b1i.sim:b1event">

- <b1e:b1event>

<b1e:eventsource>Parrot_Prod_New</b1e:eventsource>

<b1e:objecttype>17</b1e:objecttype>

<b1e:transactiontype>A</b1e:transactiontype>

<b1e:usercode>manager</b1e:usercode>

<b1e:userid>manager</b1e:userid>

- <b1e:keys count="1">

- <b1e:key>

<b1e:name>DocEntry</b1e:name>

<b1e:value>81668</b1e:value>

</b1e:key>

</b1e:keys>

<b1e:sourcesite>DEV-PARROT</b1e:sourcesite>

</b1e:b1event>

</b1e:b1events>

- <b1ie:B1IEvent xmlns:b1ie="urn:com.sap.b1i.sim:b1ievent" SysId="0010000100" SysTypeId="B1.8.8" Task="I" LocalObjectType="17">

- <b1ie:PrimaryKeyList>

<b1ie:PrimaryKey Key="DocEntry" Value="81668" />

</b1ie:PrimaryKeyList>

</b1ie:B1IEvent>

</Event>

</Payload>

- <Payload Role="S" Result="0000" Msg="">

- <BOM xmlns="">

- <BO>

- <AdmInfo>

</AdmInfo>

- <Documents>

- <row>

<DocType>dDocument_Items</DocType>

<CardName>Parrot_Prod_New</CardName>

<JournalMemo>Sales Orders - 11223</JournalMemo>

...

<DownPaymentType>dptInvoice</DownPaymentType>

...

<ClosingOption>coByCurrentSystemDate</ClosingOption>

<AuthorizationStatus>dasWithout</AuthorizationStatus>

<U_GTI_D004 nil="true" />

<U_GTI_D006 nil="true" />

<U_GTI_D013>0.000000</U_GTI_D013>

<U_GTI_D014>0.000000</U_GTI_D014>

<U_GTI_D021 nil="true" />

<U_GTI_D022 nil="true" />

<U_GTI_D023 nil="true" />

<U_GTI_D053 nil="true" />

<U_GTI_D054 nil="true" />

<U_PAR_D003 nil="true" />

<U_PAR_D002 nil="true" />

<U_IFC_OLD nil="true">0</U_IFC_OLD>

<U_IFC_NbColis>0.000000</U_IFC_NbColis>

<U_IFC_Bq />

<U_IFC_AchTel nil="true" />

<U_IFC_AchMail nil="true" />

<U_PFL_TypCde>NO</U_PFL_TypCde>

<U_PFL_Afact>N</U_PFL_Afact>

<U_PFL_CptClientTpt nil="true" />

<U_PFL_ServiceTpt nil="true" />

<U_PFL_ActiviteCde nil="true" />

<U_PFL_NumTransKN1 nil="true" />

<U_PFL_NumTransKN2 nil="true" />

<U_PFL_DateTransKN1 nil="true" />

<U_PFL_DateTransKN2 nil="true" />

<U_PFL_NumBLKN nil="true" />

<U_PFL_DatePrepaKN nil="true" />

<U_PFL_DateExpeKN nil="true" />

<U_PFL_Conformite nil="true" />

<U_PFL_NumTrack nil="true" />

<U_PFL_RangPrepa>50</U_PFL_RangPrepa>

<U_PAR_D004>N</U_PAR_D004>

<U_HK_TSF nil="true" />

<U_HK_FR nil="true" />

<U_HK_RECHK nil="true" />

<U_HK_RECFR nil="true" />

<U_HK_FACHK nil="true" />

<U_HK_DATE_TSF nil="true" />

<U_HK_TIME_TSF nil="true">0000</U_HK_TIME_TSF>

<U_HK_TEXTE nil="true" />

<U_MA_ClientCode_N1 nil="true" />

<U_MA_ClientName_N2 nil="true" />

<U_MA_Channel_N2 />

<U_MA_ApprovalNumber nil="true" />

<U_MA_Detail_TO nil="true" />

<U_MA_Bdgt_EURinHQ nil="true" />

<U_MA_Turnover_EUR nil="true" />

<U_MA_HQ_Budget_EUR nil="true" />

<U_MA_ROI nil="true" />

<U_FL_TSF nil="true" />

<U_SAV_RMA nil="true">0</U_SAV_RMA>

<U_SAV_Tobeduplicated>N</U_SAV_Tobeduplicated>

<U_SAV_Duplicated>N</U_SAV_Duplicated>

<U_SAV_Duplicatedate nil="true" />

<U_SAV_NumTransIbolt nil="true" />

<U_BUDT_FWD nil="true" />

<U_BUDT_FWD_Note_1 nil="true" />

<U_BUDT_FWD_Note_2 nil="true" />

<U_PFL_Poids>0.000000</U_PFL_Poids>

<U_CR_ImpEDI>N</U_CR_ImpEDI>

<U_CR_BuyEDI>N</U_CR_BuyEDI>

<U_CR_Entrega>N</U_CR_Entrega>

<U_CR_Cliente nil="true" />

<U_CR_DirPedi>N</U_CR_DirPedi>

<U_CR_ImpDate nil="true" />

<U_CR_DepEDI>N</U_CR_DepEDI>

<U_CR_TemEDI>N</U_CR_TemEDI>

<U_CR_SucEDI>N</U_CR_SucEDI>

<U_CR_DlnEDI>N</U_CR_DlnEDI>

<U_CR_InvEDI>N</U_CR_InvEDI>

<U_ESP_Portes>Y</U_ESP_Portes>

<U_ESP_PrtImp>0</U_ESP_PrtImp>

<U_PFL_email nil="true" />

<U_PFL_phone nil="true" />

<U_PFL_carrier_info nil="true" />

<U_ExRefNo nil="true" />

<U_B1i_RefSO nil="true" />

<U_B1i_CUST_SCG>No</U_B1i_CUST_SCG>

<U_B1i_DS>No</U_B1i_DS>

<U_CR_RMA nil="true">0</U_CR_RMA>

<U_CR_RMANum nil="true">0</U_CR_RMANum>

<U_CR_RMACNum nil="true">0</U_CR_RMACNum>

<U_CR_RMATNum nil="true">0</U_CR_RMATNum>

<U_CR_RMARecep nil="true" />

<U_CR_RMADate nil="true" />

<U_CR_RMATime nil="true">0000</U_CR_RMATime>

<U_PFL_ship_status nil="true" />

<U_PFL_ship_date nil="true" />

<U_PFL_carrier_id nil="true" />

<U_PFL_carrier_name nil="true" />

<U_PFL_carrier_tracki nil="true" />

<U_PFL_carrier_weblin nil="true" />

<U_PFL_nb_pallet>0.000000</U_PFL_nb_pallet>

<U_PFL_volume_total>0.000000</U_PFL_volume_total>

<U_EZ_DocNum nil="true" />

<U_EZ_Requestor nil="true" />

<U_EZ_CostingCodeH1 nil="true" />

<U_EZ_CostingCodeH2 nil="true" />

<U_EZ_CostingCodeH3 nil="true" />

<U_EZ_CostingCodeH4 nil="true" />

<U_EZ_CostingCodeH5 nil="true" />

</row>

</Documents>

- <Document_Lines>

- <row>

<ItemDescription>X - Faisceau adaptateur VOLVO</ItemDescription>

<TreeType>iNotATree</TreeType>

...

<Address>Kuehne + Nagel Distripôle Parisud – Bât 2 -secteur 3 77124 LIEUSAINT FRANCE</Address>

...

<SWW />

<PickStatusEx>dlps_NotPicked</PickStatusEx>

<LineType>dlt_Regular</LineType>

...

<U_IFC_OLD nil="true">0.000000</U_IFC_OLD>

<U_PAR_TYMA>01</U_PAR_TYMA>

<U_PFL_NumCdeCompt nil="true" />

<U_PFL_DateExpImp nil="true" />

<U_PFL_NumTransIbolt nil="true" />

<U_PFL_Aconsigner>N</U_PFL_Aconsigner>

<U_PFL_Consigne>N</U_PFL_Consigne>

<U_PFL_REF_HA nil="true" />

<U_IBO_RefHA nil="true" />

<U_MARK_COSTS nil="true" />

<U_MARK_CHANNELS nil="true" />

<U_MARK_BUD nil="true" />

<U_FA_NEM nil="true">0</U_FA_NEM>

<U_EDI_Tax_1>0.000000</U_EDI_Tax_1>

<U_EDI_Tax_2>0.000000</U_EDI_Tax_2>

<U_EDI_Tax_3>0.000000</U_EDI_Tax_3>

<U_ExRefNo nil="true" />

<U_ExPrice nil="true">0.000000</U_ExPrice>

<U_ExCurrency nil="true" />

<U_IMMO_USE_SUP_1>N</U_IMMO_USE_SUP_1>

<U_IMMO_LOCAL nil="true" />

<U_FOU_tobeexported>N</U_FOU_tobeexported>

<U_FOU_exported>N</U_FOU_exported>

<U_FOU_date nil="true" />

<U_FOU_ibolt_id nil="true" />

<U_FOU_po_num nil="true" />

<U_IFC_NBCOLIS nil="true">0</U_IFC_NBCOLIS>

<U_IFC_NBP nil="true">0</U_IFC_NBP>

<U_B1I_BaseLine nil="true" />

<U_EZ_LineNum nil="true" />

<U_EZ_DocNum nil="true" />

<U_EZ_CostingCodeL1 nil="true" />

<U_EZ_CostingCodeL2 nil="true" />

<U_EZ_CostingCodeL3 nil="true" />

<U_EZ_CostingCodeL4 nil="true" />

<U_EZ_CostingCodeL5 nil="true" />

<U_PFL_LotNumber nil="true" />

</row>

- <row>

<ItemDescription>X-FAISCEAU CHRYSLER</ItemDescription>

<TreeType>iNotATree</TreeType>

<Address>Geodis - Bat Evl3 - Activite Parrot Z.i La piece de la remise - Route de Corbeil 91004 EVRY FRANCE</Address>

a<TaxType>tt_Yes</TaxType>

<CorrectionInvoiceItem>ciis_ShouldBe</CorrectionInvoiceItem>

...

<U_GTI_E021>N</U_GTI_E021>

<U_GTI_E046>N</U_GTI_E046>

<U_GTI_E032 nil="true" />

<U_GTI_E082 nil="true" />

<U_PAR_E088 nil="true" />

<U_PAR_E087 nil="true" />

<U_IFC_OLD nil="true">0.000000</U_IFC_OLD>

<U_PAR_TYMA>01</U_PAR_TYMA>

<U_PFL_NumCdeCompt nil="true" />

<U_PFL_DateExpImp nil="true" />

<U_PFL_NumTransIbolt nil="true" />

<U_PFL_Aconsigner>N</U_PFL_Aconsigner>

<U_PFL_Consigne>N</U_PFL_Consigne>

<U_PFL_REF_HA nil="true" />

<U_IBO_RefHA nil="true" />

<U_MARK_COSTS nil="true" />

<U_MARK_CHANNELS nil="true" />

<U_MARK_BUD nil="true" />

<U_FA_NEM nil="true">0</U_FA_NEM>

<U_EDI_Tax_1>0.000000</U_EDI_Tax_1>

<U_EDI_Tax_2>0.000000</U_EDI_Tax_2>

<U_EDI_Tax_3>0.000000</U_EDI_Tax_3>

<U_ExRefNo nil="true" />

<U_ExPrice nil="true">0.000000</U_ExPrice>

<U_ExCurrency nil="true" />

<U_IMMO_USE_SUP_1>N</U_IMMO_USE_SUP_1>

<U_IMMO_LOCAL nil="true" />

<U_FOU_tobeexported>N</U_FOU_tobeexported>

<U_FOU_exported>N</U_FOU_exported>

<U_FOU_date nil="true" />

<U_FOU_ibolt_id nil="true" />

<U_FOU_po_num nil="true" />

<U_IFC_NBCOLIS nil="true">0</U_IFC_NBCOLIS>

<U_IFC_NBP nil="true">0</U_IFC_NBP>

<U_B1I_BaseLine nil="true" />

<U_EZ_LineNum nil="true" />

<U_EZ_DocNum nil="true" />

<U_EZ_CostingCodeL1 nil="true" />

<U_EZ_CostingCodeL2 nil="true" />

<U_EZ_CostingCodeL3 nil="true" />

<U_EZ_CostingCodeL4 nil="true" />

<U_EZ_CostingCodeL5 nil="true" />

<U_PFL_LotNumber nil="true" />

</row>

...

</Document_Lines>

</BO>

</BOM>

</Payload>

- <Payload Role="X" id="atom3">

- <Fileout xmlns="" type="file">

- <BOM>

- <BO>

- <AdmInfo>

<Object>Commande Client</Object>

<DO>PARROT</DO>

<Ident-DO>39414949600025</Ident-DO>

<Entrepot>GEODIS_EVRY_PARROT</Entrepot>

<Ident-Entrepot>3016001500804</Ident-Entrepot>

</AdmInfo>

- <LivraisonClient>

<Num-Transaction />

<Date-Transaction />

<bonlivraison-KN />

<date-preparation />

<type-commande>NO</type-commande>

<nb_colis_total>0.000000</nb_colis_total>

<nb_palette_total>0.000000</nb_palette_total>

<volume_total>0.000000</volume_total>

<poids_total>0.000000</poids_total>

<Shipment_Date />

</LivraisonClient>

- <LivraisonClient-Lines>

- <row>

<num-ligne>0</num-ligne>

<code-article>AC000007AA</code-article>

<desc-article>X - Faisceau adaptateur VOLVO</desc-article>

</row>

- <row>

<num-ligne>1</num-ligne>

<code-article>AC000010AA</code-article>

<desc-article>X-FAISCEAU CHRYSLER</desc-article>

</row>

</LivraisonClient-Lines>

</BO>

</BOM>

</Fileout>

</Payload>

- <Payload id="atom0" Role="R">

- <Fileout xmlns="" type="file">

- <BOM>

- <BO>

- <AdmInfo>

<Object>Commande Client</Object>

<DO>PARROT</DO>

<Ident-DO>39414949600025</Ident-DO>

<Entrepot>GEODIS_EVRY_PARROT</Entrepot>

<Ident-Entrepot>3016001500804</Ident-Entrepot>

</AdmInfo>

- <LivraisonClient>

<Num-Transaction />

<Date-Transaction />

<bonlivraison-KN />

<date-preparation />

<type-commande>NO</type-commande>

<nb_colis_total>0.000000</nb_colis_total>

<nb_palette_total>0.000000</nb_palette_total>

<volume_total>0.000000</volume_total>

<poids_total>0.000000</poids_total>

<Shipment_Date />

</LivraisonClient>

- <LivraisonClient-Lines>

- <row>

<num-ligne>0</num-ligne>

<code-article>AC000007AA</code-article>

<desc-article>X - Faisceau adaptateur VOLVO</desc-article>

</row>

- <row>

<num-ligne>1</num-ligne>

<code-article>AC000010AA</code-article>

<desc-article>X-FAISCEAU CHRYSLER</desc-article>

</row>

</LivraisonClient-Lines>

</BO>

</BOM>

</Fileout>

</Payload>

- <Payload Role="R2">

- <Fileout xmlns="" type="file">

- <BOM>

- <BO>

- <AdmInfo>

<Object>Commande Client</Object>

<DO>PARROT</DO>

<Ident-DO>39414949600025</Ident-DO>

<Entrepot>GEODIS_EVRY_PARROT</Entrepot>

<Ident-Entrepot>3016001500804</Ident-Entrepot>

</AdmInfo>

- <LivraisonClient>

<Num-Transaction />

<Date-Transaction />

<bonlivraison-KN />

<date-preparation />

<type-commande>NO</type-commande>

<nb_colis_total>0.000000</nb_colis_total>

<nb_palette_total>0.000000</nb_palette_total>

<volume_total>0.000000</volume_total>

<poids_total>0.000000</poids_total>

<Shipment_Date />

</LivraisonClient>

- <LivraisonClient-Lines>

- <row>

<num-ligne>0</num-ligne>

<code-article>AC000007AA</code-article>

<desc-article>X - Faisceau adaptateur VOLVO</desc-article>

</row>

- <row>

<num-ligne>1</num-ligne>

<code-article>AC000010AA</code-article>

<desc-article>X-FAISCEAU CHRYSLER</desc-article>

</row>

</LivraisonClient-Lines>

</BO>

</BOM>

</Fileout>

</Payload>

</Body>

</Msg>

</vPStatus>

</Payload>

- <Payload Role="C" id="atom1" statusNo="0" status="ok" calltype="FTPP" deleted="false" filePattern="test021.xml" ftpServer="10.0.0.34" ftpPort="21" userName="infoclip" password="{{0/HgRi2oL8zSRpK0abd54XA==}}">

<ftp.filename>//test021.xml</ftp.filename>

- <ftp.file>

- <Fileout xmlns="" type="file">

- <BOM>

- <BO>

- <AdmInfo>

<Object>Commande Client</Object>

<DO>PARROT</DO>

<Ident-DO>39414949600025</Ident-DO>

<Entrepot>GEODIS_EVRY_PARROT</Entrepot>

<Ident-Entrepot>3016001500804</Ident-Entrepot>

</AdmInfo>

- <LivraisonClient>

<Num-Transaction>12345678</Num-Transaction>

<Date-Transaction>20140813</Date-Transaction>

<bonlivraison-KN>55555</bonlivraison-KN>

<date-preparation>20140825</date-preparation>

<type-commande>EX</type-commande>

<nb_colis_total>50.000000</nb_colis_total>

<nb_palette_total>50.000000</nb_palette_total>

<volume_total>100.000000</volume_total>

<poids_total>100.000000</poids_total>

<Shipment_Date>20140820</Shipment_Date>

</LivraisonClient>

- <LivraisonClient-Lines>

- <row>

<num-ligne>0</num-ligne>

<code-article>AC000015AA</code-article>

<desc-article>X - FAISCEAU RENAULT / MERCEDES</desc-article>

</row>

- <row>

<num-ligne>1</num-ligne>

<code-article>AC000011AA</code-article>

<desc-article>FAISCEAU FORD / JAGUAR</desc-article>

</row>

</LivraisonClient-Lines>

</BO>

</BOM>

</Fileout>

</ftp.file>

</Payload>

- <Payload Role="R" id="atom0">

- <B1out xmlns="" type="object">

- <Documents>

- <row>

<U_PFL_NumTransKN1 />

<U_PFL_DateTransKN1 />

<U_PFL_NumBLKN />

<U_PFL_DatePrepaKN />

<U_GTI_D013 />

<U_PFL_nb_pallet />

<U_PFL_volume_total />

<U_PFL_Poids />

<U_PFL_ship_date />

</row>

</Documents>

<Document_Lines />

</B1out>

</Payload>

- <Payload Role="R2" Call="object" Type="DIAPI">

- <Envelope xmlns="">

- <Header>

</Header>

- <Body>

- <BOM>

- <BO>

- <AdmInfo>

</AdmInfo>

- <QueryParams>

</QueryParams>

- <Documents>

- <row>

<U_PFL_NumTransKN1 />

<U_PFL_DateTransKN1 />

<U_PFL_NumBLKN />

<U_PFL_DatePrepaKN />

<U_GTI_D013 />

<U_PFL_nb_pallet />

<U_PFL_volume_total />

<U_PFL_Poids />

<U_PFL_ship_date />

</row>

</Documents>

<Document_Lines />

</BO>

</BOM>

</Body>

</Envelope>

</Payload>

</Body>

</Msg>

and my code in atom0 of the second step is :

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

- <xsl:stylesheet xmlns:b1e="urn:com.sap.b1i.sim:b1event" xmlns:b1ie="urn:com.sap.b1i.sim:b1ievent" xmlns:bfa="urn:com.sap.b1i.bizprocessor:bizatoms" xmlns:jdbc="urn:com.sap.b1i.adapter:jdbcadapter" xmlns:rfc="urn:sap-com:document:sap:rfc:functions" xmlns:sim="urn:com.sap.b1i.sim:entity" xmlns:utils2="com.sap.b1i.bpc_tools.Utilities" xmlns:vpf="urn:com.sap.b1i.vplatform:entity" xmlns:xci="urn:com.sap.b1i.xcellerator:intdoc" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" bfa:force="" vpf:force="" jdbc:force="" rfc:force="" b1ie:force="" b1e:force="" xci:force="" sim:force="" utils2:force="">

<xsl:output method="xml" encoding="UTF-8" indent="yes" />

<xsl:param name="atom" />

<xsl:param name="sessionid" />

<xsl:variable name="msg" select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']" />

<xsl:variable name="vpSender" select="/vpf:Msg/vpf:Header/vpf:Sender/@Id" />

<xsl:variable name="vpObject" select="/vpf:Msg/vpf:Header/vpf:Sender/@ObjId" />

<xsl:variable name="vpReceiver" select="/vpf:Msg/vpf:Header/vpf:ReceiverList/vpf:Receiver[./@handover='P']/@Id" />

<xsl:variable name="vpfile" select="/vpf:Msg/vpf:Header/vpf:Variables/vpf:var[./@id='file']/@value" />

- <xsl:template match="/">

- <Msg xmlns="urn:com.sap.b1i.vplatform:entity">

<xsl:copy-of select="/vpf:Msg/@*" />

<xsl:copy-of select="/vpf:Msg/vpf:Header" />

- <Body>

<xsl:copy-of select="/vpf:Msg/vpf:Body/*" />

- <Payload Role="R" id="{$atom}">

<xsl:call-template name="transform" />

</Payload>

</Body>

</Msg>

</xsl:template>

- <xsl:template name="transform">

<row>

<U_PFL_NumTransKN1><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//Num-Transaction"/></U_PFL_NumTransKN1>

<U_PFL_DateTransKN1><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//Date-Transaction"/></U_PFL_DateTransKN1>

<U_PFL_NumBLKN><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//bonlivraison-KN"/></U_PFL_NumBLKN>

<U_PFL_DatePrepaKN><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//date-preparation"/></U_PFL_DatePrepaKN>

<U_PFL_TypCde><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//type-commande"/></U_PFL_TypCde>

<U_GTI_D013><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//nb_colis_total"/></U_GTI_D013>

<U_PFL_nb_pallet><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//nb_palette_total"/></U_PFL_nb_pallet>

<U_PFL_volume_total><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//volume_total"/></U_PFL_volume_total>

<U_PFL_Poids><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//poids_total"/></U_PFL_Poids>

<U_PFL_ship_date><xsl:value-of select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//Shipment_Date"/></U_PFL_ship_date>

</row>

</Documents>

<Document_Lines>

<xsl:for-each select="//vpf:Payload[./@Role = 'C' and @calltype ='FTTP']//Document_Lines/*">

<row>

</row>

</xsl:for-each>

</Document_Lines>

</B1out>

<xsl:attribute name="pltype">xml</xsl:attribute>

</xsl:template>

</xsl:stylesheet>

The first step works fine but the second fails and the result message is :

Exception : Invoke of: ReadXml Source: Description: '' is not a valid value for property 'U_PFL_TypCde'. The valid values are: 'NO' - 'NO', 'EX' - 'EX', 'TRF' - 'TRF', 'CDS' - 'CDS', 'WEB' - 'WEB'

or when I delete the UPFLTypCde the message is :

Exception : Invoke of: ReadXml Source: Description: Property 'Conformite' of 'Document' is invalid

and when I delete again Conformite I have this message:

Exception : DI Error: (-2028) No matching records found (ODBC -2028)

In resume, The system doesn't get back informations to create the delivery notes

Do you see where is my mistake in my syntaxe please?

Thank you for your help

Best regards

Sarah

Ask a Question