P_Scbo_action_U

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 P_Scbo_action_U.
-- 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.
-- SQL view name: P_SCBO_ACT_U_V

CREATE VIEW P_Scbo_action_U AS
SELECT
  cast( hextobin('00000000000000000000000000000000') as sdraft_key ) AS ActionDraftUUID,
  Active.BusinessObjectID AS ActiveBusinessObjectID,
  Active.NodeID AS ActiveNodeID,
  Active.ActionID AS ActiveActionID,
  cast( hextobin('00000000000000000000000000000000') as sdraft_key ) AS BusinessObjectDraftUUID,
  cast( hextobin('00000000000000000000000000000000') as sdraft_key ) AS NodeDraftUUID,
  Active.ActionID AS ActionID,
  Active.OrdinalNumber AS OrdinalNumber,
  Active.Description AS Description,
  Active.ClassNameBopf AS ClassNameBopf,
  Active.ClassNameKeyUser AS ClassNameKeyUser,
  cast( 'X' as boole_d ) AS IsActiveEntity,
  cast( ' ' as boole_d ) AS HasActiveEntity,
  Draft.businessobjectdraftuuid as DraftAdministrativeDataUUID AS actiondraftuuidasActionDraftUUID,
  cast( ' ' as boole_d ) AS HasDraftEntity,
  Draft.businessobjectdraftuuid AS DraftAdministrativeDataUUID
FROM I_Scbo_Action AS Active
LEFT OUTER JOIN scbo_bl_action_d AS Draft ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): scbo_bl_action_d
;