C_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 C_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: CINVGCSMLOCPERTP

CREATE VIEW C_InvgCsMLocRelatedPersnTP AS
SELECT
  InvgCsMRelationshipUUID,
  InvgCsMRelationshipSourceUUID,
  InvgCsMRelationshipTargetUUID,
  InvgCsMRelSourceTypeID,
  InvgCsMRelTargetTypeID,
  InvgCsMRelationshipTypeID,
  InvgCsMTextContent,
  InvgCsMTextObjectID,
  InvgCsMTextObjectType,
  InvgCsMTextTypeCode,
  InvgCsMTextLanguageCode,
  _ChangeLogText.InvgCsMTextContent AS InvgCsMTextLog,
  BusinessPartnerName,
  BusinessPartnerCategory,
  InvgCsMRelSecurityLevel,
  InvgCsMRelIsHidden,
  InvgCsMTargetID,
  InvgCsMRlibtyMtrxInfoRlibtyID,
  InvgCsMReliabilityMatrixUUID,
  InvgCsMRlibtyMtrxSrceRlibtyID,
  InvgCsMRlibtyMtrxRlibtyID,
  CreatedByUser,
  InvgCsMRelCreatedDateTime,
  LastChangedByUser,
  InvgCsMRelChangedDateTime,
  BusinessPartner,
  FormOfAddress,
  FirstName,
  LastName,
  InvgCsMIsUnknownPerson,
  GenderCodeName,
  BirthDate,
  StreetName,
  HouseNumber,
  PostalCode,
  CityName,
  Country,
  Region,
  PhoneNumber,
  PhoneNumberExtension,
  District,
  FaxNumber,
  FaxNumberExtension,
  EmailAddress,
  InvgCsMIsNewEntity,
  InvgCsMIsDeleteAllowed,
  InvgCsMRelValidFromDate,
  InvgCsMRelationshipValidToDate,
  InvgCsMRelationshipExpungeDate,
  InvgCsMSecurityLevel
FROM I_InvgCsMLocRelatedPersnTP AS LocRelatedPersn
LEFT OUTER JOIN C_InvgCsMBusinessPartnerVH AS _person ON BusinessPartner = _person.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_InvgCsMLocationTP AS _location ON InvgCsMRelationshipSourceUUID = _location.InvgCsMLocationID  -- association [1..1]
LEFT OUTER JOIN C_InvgCsMSecurityLevelVH AS _slvh ON InvgCsMRelSecurityLevel = _slvh.InvgCsMAuthScopeCode  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMSecurityLevelText AS _sltextvh ON InvgCsMRelSecurityLevel = _sltextvh.InvgCsMAuthScopeCode  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMSecurityLevelText AS _PersnSlTextVH ON InvgCsMSecurityLevel = _PersnSlTextVH.InvgCsMAuthScopeCode  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMLocPerRelshpType AS _reltypevh ON InvgCsMRelationshipTypeID = _reltypevh.InvgCsMRelationshipTypeID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMLocRelshpTypeText AS _reltypetextvh ON InvgCsMRelationshipTypeID = _reltypetextvh.InvgCsMRelationshipTypeID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMReliabilityVH AS _rlibtlyvh ON InvgCsMRlibtyMtrxRlibtyID = _rlibtlyvh.InvgCsMRlibtyMtrxRlibtyID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMSrceRlibtyVH AS _SrceRlibtyVH ON InvgCsMRlibtyMtrxSrceRlibtyID = _SrceRlibtyVH.InvgCsMRlibtyMtrxSrceRlibtyID  -- association [0..1]
LEFT OUTER JOIN C_InvgCsMSrceRlibtyTextVH AS _SrceRlibtyText ON InvgCsMRlibtyMtrxSrceRlibtyID = _SrceRlibtyText.InvgCsMRlibtyMtrxSrceRlibtyID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMInfoRlibtyVH AS _InfoRlibtyVH ON InvgCsMRlibtyMtrxInfoRlibtyID = _InfoRlibtyVH.InvgCsMRlibtyMtrxInfoRlibtyID  -- association [0..1]
LEFT OUTER JOIN C_InvgCsMInfoRlibtyTextVH AS _InfoRlibtyText ON InvgCsMRlibtyMtrxInfoRlibtyID = _InfoRlibtyText.InvgCsMRlibtyMtrxInfoRlibtyID  -- association [0..*]
LEFT OUTER JOIN C_Countryvhtemp AS _CountryValueHelp ON Country = _CountryValueHelp.Country  -- association [0..1]
LEFT OUTER JOIN C_Countrytextvhtemp AS _CountryText ON Country = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_Region AS _Region ON Region = _Region.Region AND Country = _Region.Country  -- association [0..1]
LEFT OUTER JOIN I_BPGenderValueHelpText AS _BPGenderText ON GenderCodeName = _BPGenderText.GenderCodeName  -- association [0..*]
LEFT OUTER JOIN I_BPGenderValueHelp AS _GenderValueHelp ON GenderCodeName = _GenderValueHelp.GenderCodeName  -- association [0..1]
LEFT OUTER JOIN C_FormOfAddressVHTemp AS _PersonTitleValueHelp ON FormOfAddress = _PersonTitleValueHelp.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN C_FormOfAddressTextVHTemp AS _PersonTitleText ON FormOfAddress = _PersonTitleText.FormOfAddress  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMRelshpNoteChangeLog AS _ChangeLogText ON InvgCsMRelationshipUUID = _ChangeLogText.InvgCsMTextObjectID  -- 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]
;