Skip to Content
author's profile photo Former Member
Former Member

How to bind BusinessPartner XML BillTo Address in SAPB1IF

Hello Experts,

i had binded Business Partners Header Document table OCRD columns ,My problem is how to bind child tables CRD1 for BillTo and Ship To.

<BusinessPartners>

<row>

<CardCode><xsl:value-of select="jdbc:CARDCODE/text()"></xsl:value-of></CardCode>

<CardName><xsl:value-of select="jdbc:CARDNAME/text()"></xsl:value-of></CardName>

<WTLiable>N</WTLiable>

<Notes>Created by B1if from INDB_TBL (XXX.DBTBL2B1BP)</Notes>

<CardType><xsl:value-of select="jdbc:CARDTYPE/text()"></xsl:value-of></CardType>

<GroupCode><xsl:value-of select="jdbc:GROUPCODE/text()"></xsl:value-of></GroupCode>

<Phone1><xsl:value-of select="jdbc:PHONE1/text()"></xsl:value-of></Phone1>

<Cellular><xsl:value-of select="jdbc:CELLULAR/text()"></xsl:value-of></Cellular>

<E_Mail><xsl:value-of select="jdbc:EMAIL/text()"></xsl:value-of></E_Mail>

<Free_Text><xsl:value-of select="jdbc:FREE_TEXT/text()"></xsl:value-of></Free_Text>

</row>

</BusinessPartners>

Help would be appreciated

Regards,

Vijay Kumar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Apr 15, 2012 at 01:24 AM

    <BPAddresses> tag in the same level as BusinessPartners tag.

    <BOM xmlns:b1Link="http://www.zeditsolutions.com/v1.0/b1Link">

    <BO>

    <AdmInfo>

    <Object>2</Object>

    <Version>2</Version>

    </AdmInfo>

    <BusinessPartners>...</BusinessPartners>

    <BPAddresses>

    <row>

    <AddressName></AddressName>

    <Street></Street>

    <Block></Block>

    <ZipCode></ZipCode>

    <City></City>

    <County></County>

    <Country></Country>

    <State></State>

    <BuildingFloorRoom></BuildingFloorRoom>

    <AddressType>1</AddressType> bo_BillTo

    </row>

    <row>

    <AddressName></AddressName>

    <Street></Street>

    <Block></Block>

    <ZipCode></ZipCode>

    <City></City>

    <County></County>

    <Country></Country>

    <State></State>

    <TaxCode></TaxCode>

    <BuildingFloorRoom></BuildingFloorRoom>

    <AddressType>0</AddressType> bo_ShipTo

    </row>

    </BPAddresses>

    </BO>

    </BOM>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2012 at 08:26 PM

    Hi,

    In your coding, the BillTo and ShipTo are both mandatory. You need check them first to bypass certain BP id in case some addresses are missing.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.