XML OUTPUT

[Former Member]

Hi All,

Can anyone confirm how to display or change the standard SRM PO Output XML mappings?The XML message is visible in PI but I cannot control which fields have been mapped from the PO, which transaction controls this?

Any help would be greatly appreciated

Thanks

David

[masa_139 · Accepted solution]

Hi,

If you are talking about XML(Buyer side) -> XML(Supplier side) mapping, NetWeaver PI has mapping function.

Transaction is SXMB_IFR. Select Integration Builder.

Regards,

Masa

[Former Member · Accepted solution]

Hi Masa,

Many thanks for the info, the issue I have is how to define which fields should be passed to PI, at the moment I am just seeing the field tags passed to PI but I do not know where these field are mapped from in the PO or how to change these. Any help would be really appreciated

[masa_139 · Accepted solution]

Hi,

Can you give us real example?

Which field do you want to map where? Where is the PO XML destination? SUS or ERP or Supplier system?

Regards,

Masa

[Former Member · Accepted solution]

Hi Masa,

The below is an extract from the message PurchaseOrderRequest that is being sent to PI from the SRM PO, I have not made any settings to define this data, but I know that this is taken from the PO. My question is to understand where these fields or structure is mapped from so that this data is sent to PI - is there a transaction or table to define this? Many thanks for all your help.

David

<EvaluatedReceiptSettlementIndicator>false</EvaluatedReceiptSettlementIndicator>

</FollowUpInvoiceRequest>

- <Item>

<ID schemeID="BTDItemID">1</ID>

<ActionCode>01</ActionCode>

<UnplannedItemPermissionCode>01</UnplannedItemPermissionCode>

- <Product>

<SellerID>6604796</SellerID>

<TypeCode>1</TypeCode>

<Note>Motorola GP300 NiMH Battery</Note>

</Product>

- <ProductCategory>

<BuyerID>007012</BuyerID>

</ProductCategory>

- <Price>

<NetAmount currencyCode="GBP">26.12</NetAmount>

- <NetUnitPrice>

<Amount currencyCode="GBP">26.12</Amount>

<BaseQuantity unitCode="EA">1.0</BaseQuantity>

</NetUnitPrice>

</Price>

- <DeliveryTerms>

<MaximumLeadTimeDuration>000</MaximumLeadTimeDuration>

</DeliveryTerms>

- <BuyerProductCatalogueReference>

<ID schemeAgencyID="SRQ_BS_200" schemeAgencySchemeAgencyID="ZZZ"></ID>

<ItemID>6604796</ItemID>

</BuyerProductCatalogueReference>

<Description languageCode="en">Motorola GP300 NiMH Battery</Description>

- <FollowUpPurchaseOrderConfirmation>

<RequirementCode>04</RequirementCode>

</FollowUpPurchaseOrderConfirmation>

- <FollowUpDespatchedDeliveryNotification>

<RequirementCode>04</RequirementCode>

</FollowUpDespatchedDeliveryNotification>

[masa_139 · Accepted solution]

Hi,

Please check the BADI BBP_SAPXML1_OUT_BADI in SE18 transaction.

Main program should be proxy interface. Please go to SPROXY transaction and find the PO interface.

Regards,

Masa

[Former Member · Accepted solution]

Hi Masa,

Many thanks for that, I really appreciate the help, this appears to be just what I was looking for :O)

Thank you very much

David

[Former Member · Accepted solution]

Hi

I have found the BADI (BBP_SAPXML1_OUT_BADI) and the main PO Interface in SPROXY but I'm unsure how these are defined or activated? Is there a function in SPROXY for doing this? Sorry to be a pain you've been a big help.

Thanks

David

[masa_139 · Accepted solution]

Hi,

We are not clear what do you want to implement.

Can you share your business requirement? BADI may not be a solution.

Regards,

Masa

[Former Member · Accepted solution]

Hi Masa,

The requirement is to send PO XML message to PI and then to the vendor. PI to vendor detail is ok and no further information is needed. I need to know how to map or send PO data e.g item price field to PI , what controls this? at the moment this data is in the message but I don't know what function controls this. I have seen the structure in SPROXY but how is this mapped to the PO is there a BADI or function?

Really appreciate the help

David

[masa_139 · Accepted solution]

Hi,

Sorry for my bad English reading. Which one is your issue/requirement?

A. You want to delete item price information from XML PO

B. Item price information is not in XML PO

C. You want to send out XML PO with different price

D. You want to send out XML PO with different XML schema to the vendor

<Price>

<NetAmount currencyCode="GBP">26.12<;/NetAmount>

<NetUnitPrice>

<Amount currencyCode="GBP">26.12<;/Amount>

<BaseQuantity unitCode="EA">1.0<;/BaseQuantity>

</NetUnitPrice>

</Price>

Regards,

Masa

[Former Member · Accepted solution]

Hi Masa,

As an example I would like to add the payment terms to the XML message. The payment terms are in the PO but not in the XML message. How would this be added?

Thanks

David