CDB_OBJ_INFO

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view CDB_OBJ_INFO.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW CDB_OBJ_INFO AS
SELECT
  cdb_objh.obj_name AS CDBOObjectName,
  cdb_objt.text AS CDBOObjectText,
  cdb_objh.exp_obj_type AS CDBORefObjType,
  cdb_objh.exp_obj_name AS CDBORefObjName,
  cdb_objh.status AS CDBOStatus,
  cdb_objh.created_by AS CDBOCreatedBy,
  cdb_objh.created_on AS CDBOCreatedOn,
  cdb_objh.changed_by AS CDBOChangedBy,
  cdb_objh.changed_on AS CDBOChangedOn,
  tadir.devclass AS CDBOPackage,
  tadir.srcsystem AS CDBOSrcSystem,
  df14l.ps_posid AS CDBOApplComp,
  df14t.name AS CDBOApplCompName,
  tdevc.dlvunit AS CDBODeliveryUnit,
  cdb_objd.business_area AS BusinessArea,
  cdb_objd.sub_bus_area AS SubBusArea,
  cdb_objd.ps_posid AS PsPosid,
  cdb_objd.cds_view_type AS CdsViewType,
  cdb_objd.cds_view_status AS CdsViewStatus
FROM cdb_objh
LEFT OUTER JOIN cdb_objt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cdb_objd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14t ON /* join condition not captured in parsed metadata */
;