I_FrcElmntOrgRelshpWithDrft

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_FrcElmntOrgRelshpWithDrft.
-- 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: IFEORGRELDRFT

CREATE VIEW I_FrcElmntOrgRelshpWithDrft AS
SELECT
  FrcElmntOrgStrucRelshp.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgStrucRelshp.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgStrucRelshp.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgStrucRelshp.FrcElmntOrgRelshpSpec AS FrcElmntOrgRelshpSpec,
  FrcElmntOrgStrucRelshp.FrcElmntOrgRelshpBtwnObj AS FrcElmntOrgRelshpBtwnObj,
  FrcElmntOrgStrucRelshp.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgStrucRelshp.FrcElmntOrgRelshpPriority AS FrcElmntOrgRelshpPriority,
  FrcElmntOrgStrucRelshp.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgStrucRelshp.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgStrucRelshp.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS FrcElmntOrgDraftUUID,
  FrcElmntOrgStrucRelshp.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgStrucRelshp.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgStrucRelshp.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntOrgStrucRelshp.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntOrgStrucRelshp.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntOrgStrucRelshp.FrcElmntOrgRelshpDesc AS FrcElmntOrgRelshpDesc,
  FrcElmntOrgStrucRelshp.FrcElmntOrgCnctntdRelshpText AS FrcElmntOrgCnctntdRelshpText,
  FrcElmntOrgStrucRelshp.FrcElmntOrgLastChgdByUserName AS FrcElmntOrgLastChgdByUserName,
  cast( ' ' as boole_d preserving type ) AS FrcElmntOrgDrftHasActiveEntity
FROM I_FrcElmntOrgRelshp AS FrcElmntOrgStrucRelshp
INNER JOIN I_DraftAdministrativeData ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_FrcElmntOrgDrftStrucRelshp
;