C_InvgCsMObjRelatedLocTP

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_InvgCsMObjRelatedLocTP.
-- 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: CINVGCSMOBJLOCTP

CREATE VIEW C_InvgCsMObjRelatedLocTP AS
SELECT
  InvgCsMRelationshipUUID,
  InvgCsMRelationshipSourceUUID,
  InvgCsMRelationshipTargetUUID,
  InvgCsMRelationshipTargetUUID AS InvgCsMLocationID,
  InvgCsMRelSourceTypeID,
  InvgCsMRelTargetTypeID,
  InvgCsMRelationshipTypeID,
  InvgCsMTextContent,
  InvgCsMTextObjectID,
  InvgCsMTextObjectType,
  InvgCsMTextTypeCode,
  InvgCsMTextLanguageCode,
  _ChangeLogText.InvgCsMTextContent AS InvgCsMTextLog,
  CreatedByUser,
  InvgCsMRelCreatedDateTime,
  LastChangedByUser,
  InvgCsMRelChangedDateTime,
  InvgCsMRelSecurityLevel,
  InvgCsMRelIsHidden,
  InvgCsMRlibtyMtrxInfoRlibtyID,
  InvgCsMReliabilityMatrixUUID,
  InvgCsMRlibtyMtrxSrceRlibtyID,
  InvgCsMRlibtyMtrxRlibtyID,
  InvgCsMTargetLocationID,
  InvgCsMTargetLocationName,
  InvgCsMTgtLocationCategoryUUID,
  InvgCsMCategoryID,
  CityName,
  PostalCode,
  StreetName,
  Country,
  Region,
  _Region._RegionText[1:Language = $session.system_language ].RegionName AS InvgCsMRegionText,
  InvgCsMIsNewEntity,
  InvgCsMIsDeleteAllowed,
  InvgCsMRelValidFromDate,
  InvgCsMRelationshipValidToDate,
  InvgCsMAddrValidFromDate,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  AddressTimeZone,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  CompanyPostalCode,
  HouseNumber,
  HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  FormOfAddress,
  TaxJurisdiction,
  TransportZone,
  AdditionalStreetSuffixName,
  CityFileTestStatus,
  AddressStreetUnusable,
  AddressPostBoxUnusable,
  DistrictName,
  CityNumber,
  HomeCityName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  SecondaryRegionName,
  TownshipCode,
  TownshipName,
  BusinessPartnerName1,
  BusinessPartnerName2,
  SearchTerm1,
  SearchTerm2,
  BusinessPartnerName3,
  BusinessPartnerName4,
  AddressCityPostBoxCode,
  InvgCsMAddrHouseNumberRange,
  InvgCsMAddrDistrictCode,
  InvgCsMAddrDiffntCityName,
  InvgCsMAddrValidToDate,
  InvgCsMAddrNameText,
  InvgCsMAddrNameCareOfText,
  InvgCsMAddrRegionGroup,
  InvgCsMAddrPostlCodeExtn,
  InvgCsMAddrPOBoxCodeExtn,
  InvgCsMAddrCustPostCodeExtn,
  InvgCsMAddrPostDelivDstrctCode,
  InvgCsMAddrStCode,
  InvgCsMAddrStAbbrCode,
  InvgCsMAddrSortPhone,
  InvgCsMAddrOrigin,
  InvgCsMAddrExtn1Text,
  InvgCsMAddrExtn2Text,
  InvgCsMAddressID,
  InvgCsMAddrRecdLangCrtnCode,
  InvgCsMAddrBizPrpsIsCmpltd,
  InvgCsMAddrRemarkText,
  ObjRelatedLoc.InvgCsMLocationSecurityLevel AS InvgCsMLocationSecurityLevel
FROM I_InvgCsMObjRelatedLocTP AS ObjRelatedLoc
LEFT OUTER JOIN C_InvgCsMLocationVH AS _locationinfo ON InvgCsMRelationshipTargetUUID = _locationinfo.InvgCsMLocationID  -- association [0..1]
LEFT OUTER JOIN C_InvgCsMObjectTP AS _object ON InvgCsMRelationshipSourceUUID = _object.InvgCsMObjectID  -- 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 _LocSlTextVH ON InvgCsMLocationSecurityLevel = _LocSlTextVH.InvgCsMAuthScopeCode  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMObjLocRelshpType AS _reltypevh ON InvgCsMRelationshipTypeID = _reltypevh.InvgCsMRelationshipTypeID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMObjRelshpTypeText 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_InvgCsMLocCategoryVH AS _CategoryVH ON InvgCsMTgtLocationCategoryUUID = _CategoryVH.InvgCsMCategoryUUID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMCategoryText AS _CategoryText ON InvgCsMTgtLocationCategoryUUID = _CategoryText.InvgCsMCategoryUUID  -- 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 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_InvgCsMRelshpNoteChangeLog AS _ChangeLogText ON InvgCsMRelationshipUUID = _ChangeLogText.InvgCsMTextObjectID  -- association [0..*]
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]
;