file processing

Home Page Forums BizTalk 2004 – BizTalk 2010 file processing

Viewing 0 reply threads
  • Author
    Posts
    • #26180

      HI All,
      I required your suggestion here,
       have Transaction from pip to xml(IDOC) and csv .
      pip as a source for both IDOC creation and CSV creation.
      1st condition:I have to create idoc if ProductLineItem.GlobalPurchaseOrderStatusCode = ‘ACCEPT’
      IF ‘PENDING’or ‘REJECT’ – i need to create CSV file

      and if ‘ACCEPT’ i need to check one more condition as below

      2nd condition:for every unique <ProductLineItem><DocumentLineReference><ProprietaryDocumentIdentifier> where <GlobalDocumentReferenceTypeCode = ‘Sales Order’> 
      here is the part of schema structure through sample
      <ProductLineItem>(unbounded)
      <buyerLineItem>
        <LineNumber\>
        </buyerLineItem>
      <comments>
        <FreeFormText></FreeFormText>
        </comments>
      <DocumentLineReference>(unbounded)
        <DateTimeStamp></DateTimeStamp>
        <GlobalDocumentReferenceTypeCode></GlobalDocumentReferenceTypeCode>
        <ProprietaryDocumentIdentifier></ProprietaryDocumentIdentifier>
        </DocumentLineReference>
        <GlobalProductUnitOfMeasureCode></GlobalProductUnitOfMeasureCode>
        <GlobalPurchaseOrderStatusCode>Accept</GlobalPurchaseOrderStatusCode> (max occur :1)
      <isDropShip>

       

      One approach I followed would be to use the standard XML Debauching for each ProductlineItem
      This in combination with a property schema where the GlobalPurchaseOrderStatusCode = “ACCEPT” would help you route between two send ports, first where the XML is mapped to a FF Schema for generating the CSV and the second where the XML is mapped to the IDOC schema and sent to SAP using the Adapter.

      But here if I followed like above  i am missing second condition
      Please anyone advice here

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.