Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DI Sever for User Defined Table

Hai Guys,

I am using B1WS web service. I want to post values to User Defined Table (EX: @TableName) using web services,is there any services for User Defined Table in Web Services

please give me a solution for this..

replied

Hello madhu,

B1WS is unable to access UDT. But DI Server can access UDT with RecordSet

SOAP Request Message:

<?xml version="1.0" encoding="UTF-16"?>
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
 <env:Header>
  <SessionID>4FFCFAA3-5493-456A-BC89-410B35AF096C</SessionID>
 </env:Header>
 <env:Body>
  <dis:ExecuteSQL xmlns:dis="http://www.sap.com/SBO/DIS">
   <DoQuery>SELECT OCRD.CardCode, OCRD.CardName, OCPR.Name FROM OCRD 
JOIN OCPR ON OCRD.CardCode = OCPR.CardCode 
WHERE OCRD.CardCode IN (SELECT DISTINCT ORDN.CardCode FROM ORDN)</DoQuery>
  </dis:ExecuteSQL>
 </env:Body>
</env:Envelope>

SOAP Response Message:

<?xml version="1.0"?><env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
<env:Body><ExecuteSQLResponse xmlns="http://www.sap.com/SBO/DIS"><BOM><BO><AdmInfo><Object>oRecordset</Object></AdmInfo>
<OCRD><row><CardCode>C002</CardCode><CardName>SAP</CardName><Name>2</Name></row><row><CardCode>C002</CardCode>
<CardName>SAP</CardName><Name>l</Name></row><row><CardCode>C002</CardCode><CardName>SAP</CardName><Name>Z</Name>
</row></OCRD></BO></BOM></ExecuteSQLResponse></env:Body></env:Envelope>

Kind Regards

-Yatsea

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question