Skip to Content

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

Understanding SQLDATATYPES in XML file

In my XML file, I am generating data that display I have a certain SQL Data Type. Is there a list of SQL Data Types I can refer to if I am unable to view the table properties of the query?

So my question would be, "What data type is this SQLDataType="-9" ?" and is there a list I can refer to?

<Columns>
            <Column Description="PAYDAY" MaxRange="1" MinRange="0" Name="PAYDAY" SQLDataType="93" SourceColumn="PAYDAY" />
            <Column Description="WK" MaxRange="1" MinRange="0" Name="WK" *SQLDataType*="-9" SourceColumn="WK" />
            <Column Description="YEARNUMERIC" MaxRange="1" MinRange="0" Name="YEARNUMERIC" SQLDataType="-9" SourceColumn="YEARNUMERIC" />
            <Column Description="DEPT" MaxRange="1" MinRange="0" Name="DEPT" SQLDataType="-9" SourceColumn="DEPT" />
            <Column Description="REJQTY" MaxRange="1" MinRange="0" Name="REJQTY" SQLDataType="6" SourceColumn="REJQTY" />
</Columns>

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question