I_CommsnBizObjectCategory

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 I_CommsnBizObjectCategory.
-- 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 I_CommsnBizObjectCategory AS
SELECT
  objcat.appl AS CommissionApplication,
  cast ( objcat.busobj_type as cacs_vdm_busobjtyp ) AS CommsnBizObjCategory,
  objcat.version AS CommsnDocCalculatingObjVers,
  cast ( objcat.busi_begin as cacs_busitime_b_vdm ) AS CommsnContrEffctvFrmDateTime,
  cast ( objcat.busi_end as cacs_busitime_e_vdm ) AS CommsnContrEffctvToDateTime,
  objcat.flg_cancel_obj AS CommissionObjectIsInvalid,
  objcat.flg_cancel_vers AS CommissionVersionIsInvalid,
  objcat.chg_tcode AS CommissionChangeTransaction,
  objcat.chg_usr AS CommissionChangedBy,
  objcat.tri_meth_typ AS CommissionTriggeringMethodType,
  objcat.tri_meth_target AS CommissionProcessingTarget,
  objcat.status_version AS CommissionObjectVersionStatus,
  objcat.status_work AS CommsnObjProcgStatus
FROM tcacs_busobj AS objcat
LEFT OUTER JOIN I_CommsnBizObjectCategoryText AS _text ON CommissionApplication = _text.CommissionApplication AND CommsnBizObjCategory = _text.CommsnBizObjCategory  -- association [1..*]
;