biuan SAP® BUSINESS ONE SDK
SQL Reports / CRDB Tables Tree List
API OCRT
OCRT - CRDB Tables Tree List Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ID KEY UNIQUEIDInt
11
PRIMARYYes
NodeStrNode String ListnVarChar
20
FatherIDParent IDInt
11
TableNameTable NamenVarChar
20

SELECT statement

SELECT OCRT.ID AS 'ID', OCRT.NodeStr AS 'Node String List', OCRT.FatherID AS 'Parent ID', OCRT.TableName AS 'Table Name' FROM OCRT AS OCRT

Related information
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates