cancel
Showing results for 
Search instead for 
Did you mean: 

Add new field in R3PROD2B1ITEM

Former Member
0 Kudos

Hello,

I want to add a new field in R3PROD2B1ITEM.

I want to transfert product hierarchy (MARA-PRODH) from R3 to Supplier Catalogue Number in B1 (OITM-SuppCatNum).

I change R3PROD2B1ITEM.xls file and I add after GEWEI section:

- <xsl:if test="GEWEI!=''">

- <PurchaseWeightUnit>

<xsl:value-of select="GEWEI" />

</PurchaseWeightUnit>

</xsl:if>

- <xsl:if test="PRDHA!=''">

- <SupplierCatalogNo>

<xsl:value-of select="PRDHA" />

</SupplierCatalogNo>

</xsl:if>

I make a zip with this new file and import it in B1Integration.

I enter in R3 a product hierarchy on item and send this modification to B1i.

I can see in message log my message in sucess status but field supplier Catalog No is empty in B1. In the message log in B1i I can see segment PRDHA with the good value but this data isn't in B1.

Do you have any idea ?

May be I have to change another file ?

Do you know wich one ?

Thank you

Regards

Jerome Baralis

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Ok It's running now:

my code is good but I don't write it at the good place.

If I put it after "IDOC/E1MARAM" :

<i>

<xsl:value-of select="$vSalesUnit" />

</SalesUnit>

</xsl:if>

- <xsl:for-each select="IDOC/E1MARAM"></i>

it's working

Regards

Jerome

Eneveux
Product and Topic Expert
Product and Topic Expert
0 Kudos

Jerome,

If you read through this article, this should assist you with your question. It sounds like there is not a mapping from the R/3 field to the new Business One field.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/0bf4978f-0e01-0010-2d89-c14...

Eddy

Former Member
0 Kudos

Hello Eddy,

Thank you for you answer.

I know this article and I use it for update R3PROD2B1ITEM.xsl

I don't agree with you, mapping between R3 and B1 is possible but maybe I don't have the good syntax. Field SupplierCatalogNo is a standard field in B1 and in DI API 2005 Help documentation you can see SupplierCatalogNo as public properties of OITM table.

So maybe my syntax isn't good or I have to change another file but I don't find it.

Regards

Jerome