R_SourcingProjectContactDraft

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 R_SourcingProjectContactDraft.
-- 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 R_SourcingProjectContactDraft AS
SELECT
  SourcingProjectContactDraft.sourcingprojectcontactuuid AS SourcingProjectContactUUID,
  SourcingProjectContactDraft.sourcingprojectuuid AS SourcingProjectUUID,
  SourcingProjectContactDraft.sourcingprojectcontactcategory AS SourcingProjectContactCategory,
  SourcingProjectContactDraft.businesspartner AS BusinessPartner,
  SourcingProjectContactDraft.businesspartneruuid AS BusinessPartnerUUID,
  SourcingProjectContactDraft.srcgprojcntctisvisibletosuplr AS SrcgProjCntctIsVisibleToSuplr,
  SourcingProjectContactDraft.srcgprojcontactiscontributor AS SrcgProjContactIsContributor,
  SourcingProjectContactDraft.userid AS UserID,
  SourcingProjectContactDraft.isbusinesspurposecompleted AS IsBusinessPurposeCompleted,
  SourcingProjectContactDraft.authorizationgroup AS AuthorizationGroup,
  SourcingProjectContactDraft.sourcingorigin AS SourcingOrigin,
  SourcingProjectContactDraft.sourcingscenario AS SourcingScenario,
  SourcingProjectContactDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  SourcingProjectContactDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  SourcingProjectContactDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  SourcingProjectContactDraft.draftentityoperationcode AS DraftEntityOperationCode,
  SourcingProjectContactDraft.hasactiveentity AS HasActiveEntity,
  SourcingProjectContactDraft.draftfieldchanges AS DraftFieldChanges
FROM mmsrcgpcontact_d AS SourcingProjectContactDraft
LEFT OUTER JOIN R_SourcingProjectDraft AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_SourcingProjectContactD AS _Extension ON SourcingProjectContactUUID = _Extension.SourcingProjectContactUUID  -- association [1..1]
;