I_InvgCsMLocRelatedPersnTP

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_InvgCsMLocRelatedPersnTP.
-- 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: IINVGCSMLOCPERTP

CREATE VIEW I_InvgCsMLocRelatedPersnTP AS
SELECT
  InvgCsMRelationshipUUID,
  InvgCsMRelationshipSourceUUID,
  InvgCsMRelationshipTargetUUID,
  InvgCsMRelSourceTypeID,
  InvgCsMRelTargetTypeID,
  InvgCsMRelationshipTypeID,
  InvgCsMRelSecurityLevel,
  InvgCsMRelationshipExpungeDate,
  InvgCsMRelValidFromDate,
  InvgCsMRelationshipValidToDate,
  InvgCsMRelationshipIsDeleted,
  InvgCsMRelArchiveStatusCode,
  InvgCsMRelEntitiesHash,
  InvgCsMRelCreatedDateTime,
  CreatedByUser,
  InvgCsMRelChangedDateTime,
  LastChangedByUser,
  InvgCsMRelCreatedByOrgID,
  InvgCsMRelChangedByOrgID,
  InvgCsMRelIsHidden,
  _bp.BusinessPartner AS BusinessPartner,
  _bp.BusinessPartnerName AS BusinessPartnerName,
  _bp.BusinessPartnerCategory AS BusinessPartnerCategory,
  _bp.AcademicTitle AS AcademicTitle,
  _bp.FormOfAddress AS FormOfAddress,
  _bp.FirstName AS FirstName,
  _bp.LastName AS LastName,
  _bp.GenderCodeName AS GenderCodeName,
  _bp.IsFemale AS IsFemale,
  _bp.BirthDate AS BirthDate,
  _bp.InvgCsMIsUnknownPerson AS InvgCsMIsUnknownPerson,
  _bp.InvgCsMSecurityLevel AS InvgCsMSecurityLevel,
  _bp.AddressID AS AddressID,
  _bp._Address.StreetName AS StreetName,
  _bp._Address.HouseNumber AS HouseNumber,
  _bp._Address.PostalCode AS PostalCode,
  _bp._Address.CityName AS CityName,
  _bp._Address.Country AS Country,
  _bp._Address.CountyCode AS CountyCode,
  _bp._Address.Region AS Region,
  _bp._Address.District AS District,
  _bp._Address._DefaultPhoneNumber.DestinationLocationCountry AS DestinationLocationCountry,
  _bp._Address._DefaultPhoneNumber.PhoneNumber AS PhoneNumber,
  _bp._Address._DefaultPhoneNumber.PhoneNumberExtension AS PhoneNumberExtension,
  _bp._Address._DefaultEmailAddress.EmailAddress AS EmailAddress,
  _bp._Address._DefaultFaxNumber.FaxNumber AS FaxNumber,
  _bp._Address._DefaultFaxNumber.FaxNumberExtension AS FaxNumberExtension,
  _bp._AcademicTitleValueHelp AS _AcademicTitleValueHelp,
  _bp._AcademicTitleText AS _AcademicTitleText,
  InvgCsMReliabilityMatrixUUID,
  InvgCsMRlibtyMtrxRefObjID,
  InvgCsMRlibtyMtrxRefTypeCode,
  InvgCsMRlibtyMtrxRefSetTypeID,
  InvgCsMRlibtyMtrxRefLogSystID,
  InvgCsMRlibtyMtrxSrceRlibtyID,
  InvgCsMRlibtyMtrxInfoRlibtyID,
  InvgCsMRlibtyMtrxHndlgCodeID,
  InvgCsMRlibtyMtrxIsDeleted,
  InvgCsMRlibtyMtrxArchiveSts,
  cast('' as crm_icm_mat_reliability_id ) AS InvgCsMRlibtyMtrxRlibtyID,
  cast( 'TICM-BPDIS' as abap.char( 20 ) ) AS InvgCsMTargetID,
  cast('' as boolean) AS InvgCsMIsNewEntity,
  cast('' as boolean) AS InvgCsMIsDeleteAllowed,
  _RelNote.InvgCsMTextContent AS InvgCsMTextContent,
  _RelNote.InvgCsMTextObjectID AS InvgCsMTextObjectID,
  _RelNote.InvgCsMTextObjectType AS InvgCsMTextObjectType,
  _RelNote.InvgCsMTextTypeCode AS InvgCsMTextTypeCode,
  _RelNote.InvgCsMTextLanguageCode AS InvgCsMTextLanguageCode
FROM I_InvgCsMLocVisibleReltdPersn
LEFT OUTER JOIN I_InvgCsMLocationTP AS _location ON InvgCsMRelationshipSourceUUID = _location.InvgCsMLocationID  -- association [1..1]
LEFT OUTER JOIN I_InvgCsMBusinessPartner AS _bp ON InvgCsMRelationshipTargetUUID = _bp.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_InvgCsMRelationshipNote AS _RelNote ON InvgCsMRelationshipUUID = _RelNote.InvgCsMTextObjectID AND _RelNote.InvgCsMTextObjectType = 'ICM_REL' AND _RelNote.InvgCsMTextTypeCode = 'NOTE' AND _RelNote.InvgCsMTextLanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_InvgCsMRelationship AS _RelationExtension ON InvgCsMRelationshipUUID = _RelationExtension.InvgCsMRelationshipUUID  -- association [1..1]
LEFT OUTER JOIN E_InvgCsMReliabilityMatrix AS _RelMatExtension ON InvgCsMReliabilityMatrixUUID = _RelMatExtension.InvgCsMReliabilityMatrixUUID  -- association [1..1]
;