saporder Datahub extension - New attribute not coming in idoc

[srini_sandaka2]

Hi Experts,

I tried to follow the process to add new attibute by creating custom extensions giving depedency as saporder-raw/canonical/target extensions. But I cannot see the new attribute the the outgoing idoc. Here are my xml files for custom extensions. Can someone please help, what can be missing.

Target: saporder-target zsaporder-canonical

         <targetSystem>
               <name>SapErpSystem</name>
               <type>SAP_IDOC</type>
               <exportURL>${targetsystem.saperp.url}</exportURL>
               <userName>${targetsystem.saperp.username}</userName>
               <password>${targetsystem.saperp.password}</password>
         <exportCodes>
             <exportCode>receiverpartner=${targetsystem.saperp.receivername}</exportCode>
         </exportCodes>
               <targetItems>
                              <item>                    <type>SALESORDER_CREATEFROMDAT202$E1SALESORDER_CREATEFROMDAT2$E1BPSDITM</type>
                 <canonicalItemSource>CanonicalOrderItem</canonicalItemSource>
                 <attributes>
                     <attribute>
                         <name>SALESDOCUMENTIN</name>
                         <transformationExpression>orderId</transformationExpression>
                     </attribute>
                     <attribute>
                         <name>PLANT</name>
                         <transformationExpression>matl_GROUP</transformationExpression>
                     </attribute>
                 </attributes>
             </item>                                              
               </targetItems>
         </targetSystem>
   </targetSystems>

[former_member575835]

The item_no is missiing.Please provide item no inorder for it to process at item level.

Check the OOB mapping.

[VinayKumarS]

Have you done the datahub create-drop/update. Then only it will create new columns and data will be processed.

[srini_sandaka2]

Yes Vinay, it has create-drop, I tried with update also, but it does not work. Any other process to add a new attribute? Please suggest.

[VinayKumarS]

hi priya, can you please attach the xml's. I see what all you did is right. I only tell one thing to try. Can you please change the column name to matlGroup from matl_GROUP. And try

[srini_sandaka2]

I tried but it did not work..I observed that if I add attribute at header level it works. Item level is not working..