Create sales order with ms excel - No column for pricing amount

[former_member195790]

Dear experts,

I'd like to create sales order by using ms excel. But the excel template I have downloaded

from the system doesn't have column for input pricing amount of each product item.

How can I make it appear in excel template?

Best Regards,

Krit R.

[Adie · Accepted solution]

Hello Krit,

System will determine the sales price according to the price strategy (price list, discount list, etc...) which you have maintained in the system.

Thanks,

Adie

[former_member195790 · Accepted solution]

Dear Adie,

Thank you very much for your answer.

I also asked this question to  SAP team. The answer is same to you.

However , I think that excel template will upload the data via web service.

Which is not allow to specify PricingAndTaxCalculation at the first time of calling creation sales order web service.  But we can specify it as a modification in second web service call.

That indicate I need  at least 2 web services calling (create and then update) from external application (Maybe java desktop app etc.) .

If you know better way to accomplish or It could be done by excel.  Please let me know .

Best Regards,

Krit R.

[Former Member · Accepted solution]

Hi Krit,

Were you successful and updateding PricingAndTaxCalculation on the items of a sales order via the web service?  I've been successful in updating the list price of an item as long as it was not on a Price List.  But I keep getting errors on the update of the PricingAndTaxCalculation.

These are different messges I'm receiving for two different producst.  Strangely enough I'm not getting tue UUID code error on the first item (first message below). 

Costs not determined: No valid purchase price for material in company WF100 (TA Corporate);There is no inventory cost for material xxx-3420-STD-01 in company DF100 (TA Corporate)

Update not possible; specified data for SALES_ORDER-ITEM-ITEM_PRC_AND_TAX_CALCULATION-ITEM_PRICE_COMPONENT with key UUID-CONTENT = `00163E0D28721ED688B6D10211EAD269` does not exist

If I leave the UUID off the transaction I receive the message: Update not possible; existing data for ITEM_PRICE_COMPONENT not fully specified

I'm happy to have gotten as far as I have, but any tips or ideas would be appreciated.

Best,

Howard

<?xml version="1.0"?><SalesOrderMaintainRequestBundleMessage_sync xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<SalesOrder itemListCompleteTransmissionIndicator="false" actionCode="02">

  <ID>2019070</ID>

  <Item itemBusinessTransactionDocumentReferenceListCompleteTransmissionIndicator="false" actionCode="02">

    <ID>10</ID><PriceAndTaxCalculationItem itemPriceComponentListCompleteTransmissionIndicator="false">

      <ItemMainPrice>

        <Rate>

          <DecimalValue>99.19</DecimalValue>

          <MeasureUnitCode>EA</MeasureUnitCode>

          <CurrencyCode>USD</CurrencyCode>

        </Rate>

      </ItemMainPrice>

      <ItemPriceComponent actionCode="02">

        <TypeCode>0008</TypeCode>

        <Description languageCode="EN">Cost</Description>

        <Rate>

           <DecimalValue>99.0</DecimalValue>

           <CurrencyCode>USD</CurrencyCode>

           <BaseMeasureUnitCode>EA</BaseMeasureUnitCode>

          </Rate>

          <RateBaseQuantityTypeCode>EA</RateBaseQuantityTypeCode>

      </ItemPriceComponent></PriceAndTaxCalculationItem>

      <EXTUnitCost00163E041E0E1ED2B38BB069CB468F2A currencyCode="USD" xmlns="http://sap.com/xi/AP/CustomerExtension/BYD/A0UQ1">91.59</EXTUnitCost00163E041E0E1ED2B38BB069CB468F2A>

   </Item>

   <Item itemBusinessTransactionDocumentReferenceListCompleteTransmissionIndicator="false" actionCode="02">

     <ID>20</ID><PriceAndTaxCalculationItem itemPriceComponentListCompleteTransmissionIndicator="false">

       <ItemMainPrice>

         <Rate>

           <DecimalValue>99.19</DecimalValue>

           <MeasureUnitCode>EA</MeasureUnitCode>

           <CurrencyCode>USD</CurrencyCode>

        </Rate>

      </ItemMainPrice>

      <ItemPriceComponent actionCode="02">

        <TypeCode>0008</TypeCode>

        <Description languageCode="EN">Cost</Description>

        <Rate>

           <DecimalValue>99.0</DecimalValue>

           <CurrencyCode>USD</CurrencyCode>

           <BaseMeasureUnitCode>EA</BaseMeasureUnitCode>

       </Rate>

       <RateBaseQuantityTypeCode>EA</RateBaseQuantityTypeCode>

     </ItemPriceComponent>

  </PriceAndTaxCalculationItem>

  <EXTUnitCost00163E041E0E1ED2B38BB069CB468F2A currencyCode="USD" xmlns="http://sap.com/xi/AP/CustomerExtension/BYD/A0UQ1">16.57</EXTUnitCost00163E041E0E1ED2B38BB069CB468F2A>

</Item>

</SalesOrder>

</SalesOrderMaintainRequestBundleMessage_sync>

[pardhreddyc]

Dear,

From which system you downloaded the template?Is it your custom template?

You want to create sale orders by uploading the date from excel? if so you can try with lsmw/bdc or bapi.

Check the link for more ifo:

ABAP - Simple program to create sales order using BAPI - Code Gallery - SCN Wiki

Reagrds,

Pardhu

[former_member195790]

Thanks Pardhu

But my question is not relate to ECC ABAP development.

I ask this for SAP Business bydesign.

Sorry for making you misunderstood.

Best Regards,

Krit R

[marlene_katzschner]

Hi Krit

please check the blog of my colleague Knut, where he describes how to use WebServices in Excel.

With this descriptionhttp://scn.sap.com/community/business-bydesign/blog/2015/05/15/mass-changes-of-byd-data-using-excel-...  you should be able to modify your excel.

For the WSDL for the webservice navigate to to application and user management -> input and Output management -> Service Explorer.

Best regards

Marlene