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

Find Sales Order Item Basic Data by Elements query fails

I am trying to consume Find Sales Order Item Basic Data by Elements in .NET 3.0.

Every thing appears to be working fine -- I could query by PO number, Creation time, SalesOrganisationID etc.

However, the most basic query is mysteriously failing. I just want to query by Sales order number, and have given a valid sales order number 6718 that exists in SAP.

It fails giving the following errors:

(in Log.LogItem.Note variable): 

<b>"Conversion failed: Invalid input format"</b>

(in Log.LogItem.TypeID variable):

<b>"701(SFB)"</b>

Code is pretty simple, and I am just trying to query Saler Order number 6718. Of course there is nothing wrong with its format.

From the ESOA site, all I could get was:

<i>----


QUOTE -


The following values are optional selection criteria for restricting the search result:

SelectionByID – Document number range

INCLUSION_EXCLUSION_CODE

INTERVAL_BOUNDARY_TYPE_CODE

LOWER_BOUNDARY_ID

Value

UPPER_BOUNDARY_ID Value

Value

-


UNQUOTE -


</i>

I could not even have any documentation on what to put in InclusionExclusionCode, and IntervalBoundaryTypeCode. They apper to be some Global Data Types for which I couldn't find any documentation. By sifting through Wiki, I just guessed a couple of values praying that it may work. I am a bit new to ESOA, but have expertise in .NET 3.0. Would someone guide me where to find the documentation for that, where are the error codes listed, so that I make the queries with little better preparation.

            querydata.SelectionByID = new SalesOrderERPItemBasicDataByElementsQueryMessage_syncSalesOrderERPItemBasicDataSelectionByElementsSelectionByID[1];//Single element array is good enough 
            querydata.SelectionByID[0] = new SalesOrderERPItemBasicDataByElementsQueryMessage_syncSalesOrderERPItemBasicDataSelectionByElementsSelectionByID();
            querydata.SelectionByID[0].InclusionExclusionCode = "E";
            querydata.SelectionByID[0].IntervalBoundaryTypeCode = "6";
            querydata.SelectionByID[0].LowerBoundaryID = new SalesOrderID();
            querydata.SelectionByID[0].LowerBoundaryID.Value = "6718";
            querydata.SelectionByID[0].UpperBoundaryID = new SalesOrderID();
            querydata.SelectionByID[0].UpperBoundaryID.Value = "6718";

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 04, 2007 at 04:44 PM

    I finally found that GDT type 1 is for single, and "I" for include and issued the qury -- it works perfectly well!!

    querydata.SelectionByID = new SalesOrderERPItemBasicDataByElementsQueryMessage_syncSalesOrderERPItemBasicDataSelectionByElementsSelectionByID[1];//Single element array is good enough 
                querydata.SelectionByID[0] = new SalesOrderERPItemBasicDataByElementsQueryMessage_syncSalesOrderERPItemBasicDataSelectionByElementsSelectionByID();
                querydata.SelectionByID[0].InclusionExclusionCode = "I";//include
                querydata.SelectionByID[0].IntervalBoundaryTypeCode = "1";//single valued
                querydata.SelectionByID[0].LowerBoundaryID = new SalesOrderID();
                querydata.SelectionByID[0].LowerBoundaryID.Value = "6718";

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 05:08 PM

    How do you test with a SOAP Client - I am trying to use same dataset as provided?

    I did with WSDL Test - SAP, SOAP Client and got the following error:

    http://schemas.xmlsoap.org/soap/envelope/">

    <soap-env:Body>

    http://sap.com/xi/APPL/Global2">

    <Log>

    <MaximumLogItemSeverityCode>1</MaximumLogItemSeverityCode>

    <Item>

    <TypeID>701(SFB)</TypeID>

    <SeverityCode>1</SeverityCode>

    <Note>Conversion failed: Invalid input format</Note>

    </Item>

    <Item>

    <TypeID>701(SFB)</TypeID>

    <SeverityCode>1</SeverityCode>

    <Note>Conversion failed: Invalid input format</Note>

    </Item>

    <Item>

    <TypeID>701(SFB)</TypeID>

    <SeverityCode>1</SeverityCode>

    <Note>Conversion failed: Invalid input format</Note>

    </Item>

    <Item>

    <TypeID>701(SFB)</TypeID>

    <SeverityCode>1</SeverityCode>

    <Note>Conversion failed: Invalid input format</Note>

    </Item>

    <Item>

    <TypeID>701(SFB)</TypeID>

    <SeverityCode>1</SeverityCode>

    <Note>Conversion failed: Invalid input format</Note>

    </Item>

    </Log>

    </nr1:SalesOrderERPBasicDataByElementsResponse_sync>

    </soap-env:Body>

    </soap-env:Envelope>

    Thanks..

    Vikas

    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.