I_FrcElmntOrgExtRelshpWithDrft

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_FrcElmntOrgExtRelshpWithDrft.
-- 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: IFEORGEXTRELDRFT

CREATE VIEW I_FrcElmntOrgExtRelshpWithDrft AS
SELECT
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgDfsExternalRelshp.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgDfsExternalRelshp.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS FrcElmntOrgDraftUUID,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgType AS FrcElmntOrgRelatedOrgType,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelatedOrgID AS FrcElmntOrgRelatedOrgID,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgRelshpPriority AS FrcElmntOrgRelshpPriority,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgCnctntdRelshpName AS FrcElmntOrgCnctntdRelshpName,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgLastChgdByUserName AS FrcElmntOrgLastChgdByUserName,
  _FrcElmntOrgRelshpCode._FrcElmntOrgRelshpText[1:FrcElmntOrgLanguage=$session.system_language].FrcElmntOrgRelshpDesc AS FrcElmntOrgRelshpDesc,
  cast( ' ' as boole_d preserving type ) AS FrcElmntOrgDrftHasActiveEntity,
  '1' AS FrcElmntOrgTechnicalStatusName,
  cast( FrcElmntOrgDfsExternalRelshp.DfsAssgmtPlanStatusObject as abap.char(22) ) AS DfsAssgmtPlanStatusObject,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlanDelimitDate AS FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  FrcElmntOrgDfsExternalRelshp.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty
FROM I_FrcElmntOrgDfsExternalRelshp AS FrcElmntOrgDfsExternalRelshp
INNER JOIN I_DraftAdministrativeData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FrcElmntOrgWithAuthorization AS _StrucAuth ON DraftFrcElmntExternalRelshp.FrcElmntOrgRelatedOrgID = _StrucAuth.ForceElementOrgID  -- association [0..1]
-- UNION with additional select branch(es): I_FrcElmntOrgExtRelshpDraft
;