Skip to Content
avatar image
Former Member

DIS: problem with templates and actual data

Hi All:

I've been browsing every thread where the DI Server is discussed here, I read all the info in the SDK.

What I want is somehow simple:

1) Retrieve information from some businessobject and display that in a webpage.

2) Modify the data and update it back in SBO.

I created some webservices, login, GetObject, UpdateObject.

In my webpage, I use the login to get my sessionId. Then, Use the GetObject to get some actual data, like, a BusinessPArtner information.

Until here, no problem. I can show the data very well.

The update part is the tricky one: I 've tried sending back the same XML, an alter xml with the update command and the queryparams, I tried getting the ObjectTemplate and the ObjectSchema and nothing.

Does anybody can describeme how they have managed to do this? maybe a working sample(please no the one in the SDK)??

Thanks in advance

Harold Gómez

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 02, 2006 at 08:13 AM

    Hello Harold,

    How about this ?

    Henry

    = = = = =

    02/06/2006 10:50:57 Request

    <?xml version="1.0" encoding="UTF-16"?>

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

    <env:Header>

    <SessionID>783D0E2E-B261-BCA0-F007-4625AB83B6C5</SessionID>

    </env:Header>

    <env:Body>

    http://www.sap.com/SBO/DIS">

    <Object>oOrders</Object>

    <DocEntry>285</DocEntry>

    </dis:GetByKey>

    </env:Body>

    </env:Envelope>

    02/06/2006 10:50:59 Response (OK)

    http://www.w3.org/2003/05/soap-envelope">

    http://www.sap.com/SBO/DIS">

    <BOM>

    <BO>

    <AdmInfo><Object>oOrders</Object>

    <Version>2</Version>

    </AdmInfo><Documents>

    <row>

    <DocEntry>285</DocEntry>

    <DocNum>285</DocNum>

    <DocType>dDocument_Items</DocType>

    <HandWritten>tNO</HandWritten>

    <Printed>tNO</Printed>

    <DocumentStatus>bost_Open</DocumentStatus>

    <DocObjectCode>17</DocObjectCode>

    <DocDate>20060601</DocDate>

    <DocDueDate>20060601</DocDueDate>

    <CardCode>02095</CardCode>

    <CardName>Red Capital Invest Ltd</CardName>

    <Address>FINLAND</Address>

    <NumAtCard/>

    <VatSum>29.360000</VatSum>

    <VatSumFc>0.000000</VatSumFc>

    <DiscountPercent>0.000000</DiscountPercent><TotalDiscount>0.000000</TotalDiscount><DocCurrency>EUR</DocCurrency><DocRate>1.000000</DocRate><DocTotal>162.800000</DocTotal><DocTotalFc>0.000000</DocTotalFc><Reference1>285</Reference1><Reference2/><Comments/><JournalMemo>Sales Orders - 02095</JournalMemo><TransNum>0</TransNum><PaymentGroupCode>11</PaymentGroupCode><DocTime>1910</DocTime><SalesPersonCode>-1</SalesPersonCode><TransportationCode>0</TransportationCode><PartialSupply>tYES</PartialSupply><Confirmed>tYES</Confirmed><ImportFileNum>0</ImportFileNum><SummeryType>dNoSummary</SummeryType><WareHouseUpdateType>dwh_CustomerOrders</WareHouseUpdateType><ContactPersonCode>0</ContactPersonCode><ShowSCN>tNO</ShowSCN><VatSumSys>29.360000</VatSumSys><DocTotalSys>162.800000</DocTotalSys><UpdateDate>20060601</UpdateDate><CreationDate>20060601</CreationDate><Series>2</Series><TaxDate>20060601</TaxDate><FinancialPeriod>18</FinancialPeriod><Address2/><Indicator/><NetProcedure>tNO</NetProcedure><ShipToCode/><FederalTaxID/><PaymentReference>020952853</PaymentReference><WTAmount>0.000000</WTAmount><WTAmountFC>0.000000</WTAmountFC><WTAmountSC>0.000000</WTAmountSC><Form1099>0</Form1099><Box1099/><Submitted>tNO</Submitted><Rounding>tNO</Rounding><RevisionPo>tNO</RevisionPo><Segment>0</Segment><RequriedDate>20060601</RequriedDate><CancelDate>20060701</CancelDate><PickStatus>tNO</PickStatus><Pick>tNO</Pick><BlockDunning>tNO</BlockDunning><PaymentMethod/><PaymentBlock>tNO</PaymentBlock><PaymentBlockEntry>0</PaymentBlockEntry><MaximumCashDiscount>tNO</MaximumCashDiscount><Reserve>tNO</Reserve><CentralBankIndicator/><PickRemark/><Project/><DeferredTax>tNO</DeferredTax><TaxExemptionLetterNum/><ExemptionValidityDateFrom/><ExemptionValidityDateTo/><WTApplied>0.000000</WTApplied><WTAppliedFC>0.000000</WTAppliedFC><BillOfExchangeReserved>tNO</BillOfExchangeReserved><AgentCode/><WTAppliedSC>0.000000</WTAppliedSC><TotalEqualizationTax>0.000000</TotalEqualizationTax><TotalEqualizationTaxFC>0.000000</TotalEqualizationTaxFC><TotalEqualizationTaxSC>0.000000</TotalEqualizationTaxSC><NumberOfInstallments>1</NumberOfInstallments><ApplyTaxOnFirstInstallment>tNO</ApplyTaxOnFirstInstallment><WTNonSubjectAmount>0.000000</WTNonSubjectAmount><WTNonSubjectAmountSC>0.000000</WTNonSubjectAmountSC><WTNonSubjectAmountFC>0.000000</WTNonSubjectAmountFC><WTExemptedAmount>0.000000</WTExemptedAmount><WTExemptedAmountSC>0.000000</WTExemptedAmountSC><WTExemptedAmountFC>0.000000</WTExemptedAmountFC><VatDate/><ExternalCorrectedDocNum/><InternalCorrectedDocNum>0</InternalCorrectedDocNum><NextCorrectingDocument>0</NextCorrectingDocument><BaseAmount>0.000000</BaseAmount><BaseAmountSC>0.000000</BaseAmountSC><BaseAmountFC>0.000000</BaseAmountFC><BPL_IDAssignedToInvoice>0</BPL_IDAssignedToInvoice><PeriodIndicator>Oletusarvo</PeriodIndicator><ManualNumber/><UseShpdGoodsAct>tNO</UseShpdGoodsAct><DocumentSubType>bod_None</DocumentSubType><DownPayment>0.000000</DownPayment><FolioPrefixString/><FolioNumber>0</FolioNumber><DocumentsOwner>9</DocumentsOwner><BPChannelCode/><BPChannelContact>0</BPChannelContact><PayToCode/><IsPayToBank/><PayToBankCountry/><PayToBankCode/><PayToBankAccountNo/><PayToBankBranch/><ReserveInvoice>tNO</ReserveInvoice><TrackingNumber/><LanguageCode>17</LanguageCode></row></Documents>

    <Document_Lines>

    !!DOCUMENT LINES OMITTED IN ORDER TO SAVE SPACE!!

    </Document_Lines>

    <SerialNumbers/><BatchNumbers/><Document_LinesAdditionalExpenses/><WithholdingTaxLines/><DocumentsAdditionalExpenses/><WithholdingTaxData/><TaxExtension/></BO></BOM></dis:GetByKeyResponse></env:Body></env:Envelope>

    02/06/2006 10:51:15 Request

    <?xml version="1.0"?>

    http://www.w3.org/2003/05/soap-envelope">

    <env:Header>

    <SessionID>783D0E2E-B261-BCA0-F007-4625AB83B6C5</SessionID>

    </env:Header>

    <env:Body>

    http://www.sap.com/SBO/DIS" CommandID="Update Documents">

    <BOM>

    <BO>

    <AdmInfo>

    <Object>oOrders</Object>

    </AdmInfo>

    <QueryParams>

    <DocEntry>285</DocEntry>

    </QueryParams>

    <Documents>

    <row>

    <DocDate>20060601</DocDate>

    <DocDueDate>20060601</DocDueDate>

    <CardCode>02095</CardCode>

    <NumAtCard></NumAtCard>

    <DiscountPercent>0.00</DiscountPercent>

    <Comments></Comments>

    <SalesPersonCode>-1</SalesPersonCode>

    <ShipToCode></ShipToCode>

    <DocumentsOwner>9</DocumentsOwner>

    </row>

    </Documents>

    <Document_Lines>

    <row>

    <ItemCode>02TEST</ItemCode><ItemDescription>Kokeillaan taas (02TEST)</ItemDescription><Quantity>2</Quantity><ShipDate>20060601</ShipDate><Price>13.44</Price><Currency>EUR</Currency><DiscountPercent>4.00</DiscountPercent><WarehouseCode>01</WarehouseCode><SalesPersonCode>-1</SalesPersonCode><CostingCode /><ProjectCode /><VatGroup>V1</VatGroup><FreeText /><ShippingMethod>1</ShippingMethod>

    </row>

    <row>

    <ItemCode>03TEST</ItemCode><ItemDescription /><Quantity>1.000000</Quantity><ShipDate>20060601</ShipDate><Price>120.000000</Price><Currency>EUR</Currency><DiscountPercent>0.000000</DiscountPercent><WarehouseCode>01</WarehouseCode><SalesPersonCode>7</SalesPersonCode><CostingCode /><ProjectCode /><VatGroup>V1</VatGroup><FreeText /><ShippingMethod>1</ShippingMethod>

    </row>

    </Document_Lines>

    </BO>

    </BOM>

    </dis:UpdateObject>

    </env:Body>

    </env:Envelope>

    02/06/2006 10:51:16 Start DoCommand

    02/06/2006 10:51:23 End DoCommand

    02/06/2006 10:51:23 Response (OK)

    http://www.w3.org/2003/05/soap-envelope">

    <env:Body>

    http://www.sap.com/SBO/DIS" CommandID="Update Documents">

    <RetKey>285</RetKey>

    </dis:UpdateObjectResponse>

    </env:Body>

    </env:Envelope>

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thank you very much, henry.

      I'll try your second approach, first, mostly because using xslt is very time consuming.

      Harold Gómez V.