I_InvgCsMLocRelatedLocTP

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_InvgCsMLocRelatedLocTP.
-- 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: IINVGCSMLOCLOCTP

CREATE VIEW I_InvgCsMLocRelatedLocTP AS
SELECT
  InvgCsMRelationshipUUID,
  InvgCsMRelationshipSourceUUID,
  InvgCsMRelationshipTargetUUID,
  InvgCsMRelSourceTypeID,
  InvgCsMRelTargetTypeID,
  InvgCsMRelationshipTypeID,
  InvgCsMRelSecurityLevel,
  InvgCsMRelationshipExpungeDate,
  InvgCsMRelValidFromDate,
  InvgCsMRelationshipValidToDate,
  InvgCsMRelationshipIsDeleted,
  InvgCsMRelArchiveStatusCode,
  InvgCsMRelEntitiesHash,
  InvgCsMRelCreatedDateTime,
  CreatedByUser,
  InvgCsMRelChangedDateTime,
  LastChangedByUser,
  InvgCsMRelCreatedByOrgID,
  InvgCsMRelChangedByOrgID,
  InvgCsMRelIsHidden,
  cast(bintohex(_targetlocation.InvgCsMLocationCategoryUUID) as char32) AS InvgCsMTgtLocationCategoryUUID,
  _targetlocation.InvgCsMLocationID AS InvgCsMTargetLocationID,
  _targetlocation.InvgCsMLocationName AS InvgCsMTargetLocationName,
  _targetlocation.InvgCsMCategoryID AS InvgCsMCategoryID,
  _targetlocation.AddressID AS AddressID,
  _targetlocation.POBox AS POBox,
  _targetlocation.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _targetlocation.POBoxPostalCode AS POBoxPostalCode,
  _targetlocation.POBoxLobbyName AS POBoxLobbyName,
  _targetlocation.CityName AS CityName,
  _targetlocation.DistrictName AS DistrictName,
  _targetlocation.CityNumber AS CityNumber,
  _targetlocation.HomeCityName AS HomeCityName,
  _targetlocation.PostalCode AS PostalCode,
  _targetlocation.StreetName AS StreetName,
  _targetlocation.StreetPrefixName AS StreetPrefixName,
  _targetlocation.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  _targetlocation.StreetSuffixName AS StreetSuffixName,
  _targetlocation.HouseNumber AS HouseNumber,
  _targetlocation.Country AS Country,
  _targetlocation.Region AS Region,
  _targetlocation.SecondaryRegionName AS SecondaryRegionName,
  _targetlocation.CountyCode AS CountyCode,
  _targetlocation.InvgCsMAddrValidFromDate AS InvgCsMAddrValidFromDate,
  _targetlocation.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _targetlocation.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _targetlocation.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _targetlocation.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _targetlocation.DeliveryServiceNumber AS DeliveryServiceNumber,
  _targetlocation.AddressTimeZone AS AddressTimeZone,
  _targetlocation.CorrespondenceLanguage AS CorrespondenceLanguage,
  _targetlocation.PrfrdCommMediumType AS PrfrdCommMediumType,
  _targetlocation.CompanyPostalCode AS CompanyPostalCode,
  _targetlocation.HouseNumberSupplementText AS HouseNumberSupplementText,
  _targetlocation.Building AS Building,
  _targetlocation.Floor AS Floor,
  _targetlocation.RoomNumber AS RoomNumber,
  _targetlocation.FormOfAddress AS FormOfAddress,
  _targetlocation.TaxJurisdiction AS TaxJurisdiction,
  _targetlocation.TransportZone AS TransportZone,
  _targetlocation.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  _targetlocation.CityFileTestStatus AS CityFileTestStatus,
  _targetlocation.AddressStreetUnusable AS AddressStreetUnusable,
  _targetlocation.AddressPostBoxUnusable AS AddressPostBoxUnusable,
  _targetlocation.TownshipCode AS TownshipCode,
  _targetlocation.TownshipName AS TownshipName,
  _targetlocation.BusinessPartnerName1 AS BusinessPartnerName1,
  _targetlocation.BusinessPartnerName2 AS BusinessPartnerName2,
  _targetlocation.SearchTerm1 AS SearchTerm1,
  _targetlocation.SearchTerm2 AS SearchTerm2,
  _targetlocation.BusinessPartnerName3 AS BusinessPartnerName3,
  _targetlocation.BusinessPartnerName4 AS BusinessPartnerName4,
  _targetlocation.AddressCityPostBoxCode AS AddressCityPostBoxCode,
  _targetlocation.InvgCsMAddrHouseNumberRange AS InvgCsMAddrHouseNumberRange,
  _targetlocation.InvgCsMAddrDistrictCode AS InvgCsMAddrDistrictCode,
  _targetlocation.InvgCsMAddrDiffntCityName AS InvgCsMAddrDiffntCityName,
  _targetlocation.InvgCsMAddrValidToDate AS InvgCsMAddrValidToDate,
  _targetlocation.InvgCsMAddrNameText AS InvgCsMAddrNameText,
  _targetlocation.InvgCsMAddrNameCareOfText AS InvgCsMAddrNameCareOfText,
  _targetlocation.InvgCsMAddrRegionGroup AS InvgCsMAddrRegionGroup,
  _targetlocation.InvgCsMAddrPostlCodeExtn AS InvgCsMAddrPostlCodeExtn,
  _targetlocation.InvgCsMAddrPOBoxCodeExtn AS InvgCsMAddrPOBoxCodeExtn,
  _targetlocation.InvgCsMAddrCustPostCodeExtn AS InvgCsMAddrCustPostCodeExtn,
  _targetlocation.InvgCsMAddrPostDelivDstrctCode AS InvgCsMAddrPostDelivDstrctCode,
  _targetlocation.InvgCsMAddrStCode AS InvgCsMAddrStCode,
  _targetlocation.InvgCsMAddrStAbbrCode AS InvgCsMAddrStAbbrCode,
  _targetlocation.InvgCsMAddrSortPhone AS InvgCsMAddrSortPhone,
  _targetlocation.InvgCsMAddrOrigin AS InvgCsMAddrOrigin,
  _targetlocation.InvgCsMAddrExtn1Text AS InvgCsMAddrExtn1Text,
  _targetlocation.InvgCsMAddrExtn2Text AS InvgCsMAddrExtn2Text,
  _targetlocation.InvgCsMAddressID AS InvgCsMAddressID,
  _targetlocation.InvgCsMAddrRecdLangCrtnCode AS InvgCsMAddrRecdLangCrtnCode,
  _targetlocation.InvgCsMAddrBizPrpsIsCmpltd AS InvgCsMAddrBizPrpsIsCmpltd,
  _targetlocation.InvgCsMAddrRemarkText AS InvgCsMAddrRemarkText,
  _targetlocation._Country AS _Country,
  _targetlocation._CountyCode AS _CountyCode,
  _targetlocation._Region AS _Region,
  _targetlocation.InvgCsMLocationSecurityLevel AS InvgCsMLocationSecurityLevel,
  InvgCsMReliabilityMatrixUUID,
  InvgCsMRlibtyMtrxRefObjID,
  InvgCsMRlibtyMtrxRefTypeCode,
  InvgCsMRlibtyMtrxRefSetTypeID,
  InvgCsMRlibtyMtrxRefLogSystID,
  InvgCsMRlibtyMtrxSrceRlibtyID,
  InvgCsMRlibtyMtrxInfoRlibtyID,
  InvgCsMRlibtyMtrxHndlgCodeID,
  InvgCsMRlibtyMtrxIsDeleted,
  InvgCsMRlibtyMtrxArchiveSts,
  cast('' as crm_icm_mat_reliability_id ) AS InvgCsMRlibtyMtrxRlibtyID,
  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_InvgCsMLocVisibleReltdLoc
LEFT OUTER JOIN I_InvgCsMVisibleLocation AS _targetlocation ON InvgCsMRelationshipTargetUUID = _targetlocation.InvgCsMLocationID  -- association [0..1]
LEFT OUTER JOIN I_InvgCsMLocationTP AS _location ON InvgCsMRelationshipSourceUUID = _location.InvgCsMLocationID  -- association [1..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]
;