getting SQL Error in BOBJ during SAP R/3 to XSD conversion

dataservices sap-erp-bw
1

Hi Friend ,
i am doing simple conversion from SAP database table to XSD i am getting follwoing error please help me to sort out this issue

13852 9292 RES-020148 03/08/2011 10:05:38 Query either selects from no object at all, or its SELECT produces <5> columns while the query output schema specifies

Thanks
Amit

amit.shivhare :india: (BOB member since 2011-08-03)

2

How does the Query “Row” look like?

Werner Daehn :de: (BOB member since 2004-12-17)

3

Hi wdaehn,
thanks for reply
i have imported SAP table CSKT . i have done one to one message mapping to all field

CSKT.MANDT
CSKT.SPRAS
CSKT.KOKRS,
CSKT.KOSTL,
CSKT.DATBI,
CSKT.KTEXT,
CSKT.LTEXT,
CSKT.MCTXT

and i have used following XSD strct.
ROW
plant
material
date
Qtty
other

<?xml version="1.0" encoding="UTF-8" ?>
  • <xsd:schema targetNamespace=“urn:kcc.com:file:multidoc:independent_processing” xmlns:xsd=“http://www.w3.org/2001/XMLSchema” xmlns=“urn:kcc.com:file:multidoc:independent_processing”>
    <xsd:element name=“MT_PRodBooking” type=“DT_PRodBooking” />
  • <xsd:complexType name=“DT_PRodBooking”>
  • xsd:annotation
    <xsd:appinfo source=“http://sap.com/xi/VersionID”>d4c20b7dbac211df85360000004bc383</xsd:appinfo>
    </xsd:annotation>
  • xsd:sequence
  • <xsd:element name=“Row” minOccurs=“0” maxOccurs=“unbounded”>
  • xsd:annotation
    <xsd:appinfo source=“http://sap.com/xi/TextID”>d41e46e0bac211dfbf810018de2c0962</xsd:appinfo>
    <xsd:documentation />
    </xsd:annotation>
  • xsd:complexType
  • xsd:sequence
  • <xsd:element name=“Plant” type=“xsd:string”>
  • xsd:annotation
    <xsd:appinfo source=“http://sap.com/xi/TextID”>94136680b4f911dfcd4a001635c696d0</xsd:appinfo>
    <xsd:documentation />
    </xsd:annotation>
    </xsd:element>
  • <xsd:element name=“Material” type=“xsd:string”>
  • xsd:annotation
    <xsd:appinfo source=“http://sap.com/xi/TextID”>94136681b4f911df9413001635c696d0</xsd:appinfo>
    <xsd:documentation />
    </xsd:annotation>
    </xsd:element>
  • <xsd:element name=“Date” type=“xsd:string”>
  • xsd:annotation
    <xsd:appinfo source=“http://sap.com/xi/TextID”>94136682b4f911df892e001635c696d0</xsd:appinfo>
    <xsd:documentation />
    </xsd:annotation>
    </xsd:element>
  • <xsd:element name=“Qtty” type=“xsd:string”>
  • xsd:annotation
    <xsd:appinfo source=“http://sap.com/xi/TextID”>94136683b4f911dfbd87001635c696d0</xsd:appinfo>
    <xsd:documentation />
    </xsd:annotation>
    </xsd:element>
  • <xsd:element name=“Other” type=“xsd:string”>
  • xsd:annotation
    <xsd:appinfo source=“http://sap.com/xi/TextID”>94136684b4f911dfad56001635c696d0</xsd:appinfo>
    <xsd:documentation />
    </xsd:annotation>
    </xsd:element>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:element>
    </xsd:sequence>
    </xsd:complexType>
    </xsd:schema>

amit.shivhare :india: (BOB member since 2011-08-03)

4

I guess this would help you
https://wiki.sdn.sap.com/wiki/display/BOBJ/The+Nested+Relational+Data+Model+NRDM

Werner Daehn :de: (BOB member since 2004-12-17)