Customer Invoice Request XML Specification

[Former Member]

Hi All,

I've been searching my butt off looking for the customer invoice request XML spec.

Where is it?

Judson

[Ticg]

1. Getting back to the original question, the updated info for the XML file format is in this wiki - go to the bottom of the wiki page.  There's about 3 formats based on your BYD version.

https://www.sme.sap.com/irj/sme/community/collaboration/wiki?path=/pages/viewpage.action&pageId=2748...

2. I like to hear how the Customer Invoice Request Comm Arrangement was created ?  @Rufat ?

[Former Member]

Hi Tim,

In 1302, there is a communication arrangement available.

Just create a new one and choose from the list.

Best Regards,

Rufat

[RobertReiz]

The links in this thread don't work anymore. Can somebody post updated links?

[Former Member]

Seems to have been some changes in the V4.0 version as the template does not seem to upload the files. Could you advise the changes in the references etc.. that have been made to the template...?

[Former Member]

Hi Andrew - did you have any success here?  Did you attempt this in FP4.0?   interested to learn from your experience if you found any useful documentaton.

[Former Member]

Customer Invoice Request webservice is available and WSDL for the same can be downloaded from your respective ByDesign FP4.0 or FP3.5 systems. However, the webservice is not directly exposed for consumption via the e-commerce webservices or any other means. I guess, this needs to be done via an add-on solution.

Regards

Asif

[Former Member]

Do you know how to 'enable' a webservice, or are they always enabled? 

1. I can see WSDL etc. but how do I actually allow ByD to accept it?  Do I have to create a communication arrangement?  To create a communication arrangment do I have to enable anything?

I can't find any useful documentation on how to use a webservice? 

Anything would be useful - many thanks.

John

[Former Member]

John,

that is where it gets tricky. Someone from SAP has to release that webservice for general use (something akin to Shipping Integration) to be able to consume it. It makes no sense for SAP to create those many webservices (150+), and not release them for consumption. Maybe it will be done in future, maybe not. Until then, you probably have to make do with an add-on.

I think the original question here was looking for an spec or xml for a service interface called CustomerInvoiceProcessingRequestInvoicingIn which allows you to do the same.

@Judson, were you able to find the spec?

- Asif

[Former Member]

Hi Asif,

I know this thread has gone off-beat a little.  I am interested in web-service only now... essentially how one would configure web-service from ByD perspective.   I can see there is a released webservice for something like 'Managecustomerin', I can see the WSDL etc. but I just need to know how to actually use it at a high level.

I understand that 3rd party has to develop the 'interface' to generate the info. in correct XML format for transfer into ByD,  but how does that transfer actually happen or be enabled.  It a simple high level quesiton, but is the web service always available and you just write to it? OR does something need to be activated in the ByD system to allow the receiving of the information?   I am aware of communication agreements, but even a released web-service does not appear as a communication agreement option - unless it is added some how?

Hope my question makes sense, I am talking about somehting Idon't know enough about!

[Former Member]

ByDesign web service. These are the webservices created by SAP. Some of them are released via the e-commerce, and some of them via the Shipping Services add-on in the SAP Store. To be able to consume them, you need to go to buy them from SAP Store (current price $0) just like you would buy any add-on solution and have them activated/deployed on your ByDesign system. This will automatically create an entry in the Communication Arrangement and will provide you with a username, password to be able to access these webservices.

Partner webservices. The webservices created via the ByDesign Studio need to be added to a workcenter view which needs to be assigned to any Business User in order to consume them. There is a good and detailed amount of information available on this in the SDK Documentation.

Does this answer your question.

P.S. Sorry about hijacking your thread Judson Wickham.

[Former Member]

No worries.

Like Asif said, you need to scope in e-commerce to be able to use this group of web services.

I'd send you that info but I guess it was a waste of time sending you the info yesterday, since it looks like you now have no interest in using the CustomerInvoiceProcessingRequestInvoicingIn Service Integration.

H8 WASTING TIME

I don't think I'm going to give away free information to people on the SCN that email me anymore. It takes up at least two hours a day and in this case the info was not even considered, even though I provided exactly what was asked.

Question for me? $150/hr, minimum 1 hour.

And BTW I have customers loading many thousands of invoices a day via my modified Excel Upload for the the CustomerInvoiceProcessingRequestInvoicingIn Service Integration.

[Former Member]

Judson,

My customer has two requirements:

1. Ability to create and modify ByD accounts from external source

2. Ability to load customer invoices into ByD from external source

The WebDav excel upload for Customer Invoices is much appreciated and will be used (this is not part of the ecommerce add-on).  It was not a waste of your time.

I am now trying to understand part 1. and how to use the "ManageCustomerIn" web service as well.   I have learned that it is availale as part of ecommerce webservice...

Thanks

[Former Member]

John,

As an SAP employee you would think you would have access to this as it is fairly straight forward. And part of CORE ByDesign  integration. In Fact using the Search feature on the SCN.. or Looking into the E-Commerce integration Documentation might also help.  (If not you could engage a Partner)

There is no High level overview of it other than they have to push the XML to that Soap Endpoint with the correct Credentials...

[Former Member]

Hello Asif,

one thing that is missing for the CustomerInvoiceRequestIn Webservice is, that there is no documentation for it. It is merely impossible to create a "Minimal Request". Do you have any idea here? Another possibility would be to use a QueryIn Webservice for it in order to analyze the attributes you get. But I don´´t know where to find it. And some QueryIn-Methods tell me that the Authorization Role for this webservice is missing...(by using the SOAP UI client)....

Best Regards,

Rufat

[Former Member]

Minimal Request:

<?xml version="1.0" encoding="utf-8"?>

<CustomerInvoiceRequestRequest>

  <MessageHeader>

    <CreationDateTime />

  </MessageHeader>

  <CustomerInvoiceRequest actionCode="04" reconciliationPeriodCounterValue="1">

  <BaseBusinessTransactionDocumentID>V00064348</BaseBusinessTransactionDocumentID>

<BaseBusinessTransactionDocumentTypeCode>29</BaseBusinessTransactionDocumentTypeCode>

    <ProposedInvoiceDate>2012-05-07</ProposedInvoiceDate>

    <name>Extreme Reach - DEV</name>

<ReferenceBusinessTransactionDocumentID>V00064348</ReferenceBusinessTransactionDocumentID>

    <BusinessProcessVariantType>

      <BusinessProcessVariantTypeCode>1</BusinessProcessVariantTypeCode>

      <MainIndicator>true</MainIndicator>

    </BusinessProcessVariantType>

    <BusinessProcessVariantType>

      <BusinessProcessVariantTypeCode>319</BusinessProcessVariantTypeCode>

      <MainIndicator>false</MainIndicator>

    </BusinessProcessVariantType>

    <BuyerParty>

      <InternalID>2113</InternalID>

    </BuyerParty>

    <EmployeeResponsibleParty>

      <InternalID>8000000017</InternalID>

    </EmployeeResponsibleParty>

    <SalesUnitParty>

      <InternalID>TV3003</InternalID>

    </SalesUnitParty>

    <SalesAndServiceBusinessArea>

      <DistributionChannelCode>01</DistributionChannelCode>

    </SalesAndServiceBusinessArea>

    <PricingTerms>

      <PricingProcedureCode listID="2">PPSTD1</PricingProcedureCode>

      <CurrencyCode>USD</CurrencyCode>

    </PricingTerms>

    <Item actionCode="04">

  <BaseBusinessTransactionDocumentItemID>10</BaseBusinessTransactionDocumentItemID>

<BaseBusinessTransactionDocumentItemTypeCode>002</BaseBusinessTransactionDocumentItemTypeCode>

      <SettlementRelevanceIndicator>true</SettlementRelevanceIndicator>

      <BaseItemCancelledIndicator>false</BaseItemCancelledIndicator>    <ReceivablesPropertyMovementDirectionCode>2</ReceivablesPropertyMovementDirectionCode>

      <Product>

        <InternalID>V-SD-NEXTDAY-STN-ONLINE-FIRST</InternalID>

        <TypeCode>2</TypeCode>

      </Product>

      <CashDiscountDeductibleIndicator>false</CashDiscountDeductibleIndicator>

      <Quantity unitCode="EA">1</Quantity>

      <QuantityTypeCode>EA</QuantityTypeCode>

      <PriceAndTax>

        <PriceComponent>

          <TypeCode listID="2">7PR1</TypeCode>

          <CategoryCode>1</CategoryCode>

          <PurposeCode>1000</PurposeCode>

          <MajorLevelOrdinalNumberValue>10</MajorLevelOrdinalNumberValue>

          <MinorLevelOrdinalNumberValue>1</MinorLevelOrdinalNumberValue>

          <Rate>

            <DecimalValue>2.0000</DecimalValue>

            <CurrencyCode>USD</CurrencyCode>

            <BaseDecimalValue>1</BaseDecimalValue>

            <BaseMeasureUnitCode>EA</BaseMeasureUnitCode>

          </Rate>

          <RateBaseQuantityTypeCode>EA</RateBaseQuantityTypeCode>

          <CalculationBasis>

            <BaseCode>3</BaseCode>

            <Quantity unitCode="EA">1</Quantity>

            <QuantityTypeCode>EA</QuantityTypeCode>

            <Amount currencyCode="USD">0</Amount>

          </CalculationBasis>

          <CalculatedAmount currencyCode="" />

          <RoundingDifferenceAmount currencyCode="" />

          <EffectiveIndicator>true</EffectiveIndicator>

          <ManuallyChangedIndicator>true</ManuallyChangedIndicator>

          <GroupedIndicator />

          <OriginCode>2</OriginCode>

          <PriceSpecificationUUID />

          <PriceSpecificationDeterminationTimePoint>

            <TypeCode>1</TypeCode>

            <Date>2012-05-07</Date>

          </PriceSpecificationDeterminationTimePoint>

        </PriceComponent>

      </PriceAndTax>

      <AccountingCodingBlockAssignment>     <AccountingCodingBlock>A1520<GeneralLedgerAccountAliasCode>Z0003</GeneralLedgerAccountAliasCode></AccountingCodingBlock>

      </AccountingCodingBlockAssignment>

    </Item>

  </CustomerInvoiceRequest>

</CustomerInvoiceRequestRequest>

[Former Member]

Hi Rufat,

There is hardly any documentation for any of the webservices in Business ByDesign. All the request XMLs are being created by trial-and-error or by looking into the sample code provided by SAP for the e-commerce integration. I am sure Judson must have created the above sample using similar techniques, which is more than helpful in this case.

- Asif

[Former Member]

Thank you both for your quick answer, Judson and Asif!

@Asif: There are great documentation on on other webservices (especially E-Commerce). For example: The webservice ManageCustomerIn is very well documented with Minimal Requests and codes. I assumed that it would be logical to do the same for CustomerInvoiceRequestIn.

@Judson: I´ve tested your minimal request. After multiple WebService Processing Errors (some attributes haven´t been in my WSDL-Structure) I get another response message:

   <env:Text xml:lang="en">RABAX occurred on server side</env:Text>

         </env:Reason>

         <env:Detail>

            <sap:Rabax xmlns:sap="http://www.sap.com/webas/710/soap/runtime/abap/fault/generic">

               <SYDATUM>20130118</SYDATUM>

               <SYUZEIT>135323</SYUZEIT>

               <ERRORCODE>GETWA_NOT_ASSIGNED</ERRORCODE>

I tried to configure the Communication Scenario in ByD but unfortunately I have no idea what the

communication scenario for this webservice is called. I had no  problem with the integration of Point-Sales Processes. Do I even have to configure the scenario?? I don´t understand this error message and how to fix it.

Best Regards,

Rufat

[Former Member]

...ok, it works with the MaintainAsBundle

--->the error message only appears by using the CheckBundleMaintenance. I think that´s becaus some fields/attributes of the wsdl-structure

are missing in our system.

[Former Member]

Hey Judson,

Check out these pages and documents for more information about how to upload customer invoice requests using an Excel Upload or using XML files placed in a WebDAV folder:

Excel Customer Invoice Request Upload tool: [https://wiki.sme.sap.com/wiki/x/-oUxDQ|https://wiki.sme.sap.com/wiki/x/-oUxDQ]

How To Guide for XML WebDav Upload: [https://www.sdn.sap.com/irj/sme/solutions?rid=/library/uuid/9088af2d-597d-2e10-b4b3-b72a6dd830d0|https://www.sdn.sap.com/irj/sme/solutions?rid=/library/uuid/9088af2d-597d-2e10-b4b3-b72a6dd830d0]

I've tested against a FP 3.5 reference system and both methods work like a charm.

-Kurtis

[Former Member]

Hi - could somebody in SAP please update/verify the above links?  Also, is there FP4.0 documentation on this?

[Former Member]

Thanks to David Thorne for these links:

This wiki page is quite good for integration scenarios: https://wiki.sme.sap.com/wiki/display/AMI/SAP+Business+ByDesign+Integration+Offerings

As is this document (particularly the last bit on service explorer in FP4.0: https://www.sme.sap.com/irj/sme/solutions?rid=/library/uuid/00211ca2-9cc2-2f10-af87-d6677abf0e1f

[Former Member]

Hi Kurtis

I get 404s on both your links - "Excel Customer Invoice Request Upload tool" and "How To Guide for XML WebDav Upload".

Do you have current links for these 2 resources?

Cheers

Ola