I_InvgCsMLocation

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_InvgCsMLocation.
-- 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: IINVGCSMLOCATION

CREATE VIEW I_InvgCsMLocation AS
SELECT
  location_id AS InvgCsMLocationID,
  location_name AS InvgCsMLocationName,
  cat_guid AS InvgCsMLocationCategoryUUID,
  security_level AS InvgCsMLocationSecurityLevel,
  hidden_flag AS InvgCsMLocationIsHidden,
  addrnumber AS AddressID,
  created_by AS InvgCsMLocationCreatedBy,
  created_on AS InvgCsMLocationCreatedOnDate,
  changed_by AS InvgCsMLocationChangedBy,
  changed_on AS InvgCsMLocationChangedOnDate,
  cat_id AS InvgCsMCategoryID,
  location_uuid AS InvgCsMLocationUUID,
  _Address.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  _Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  _Address.PrfrdCommMediumType AS PrfrdCommMediumType,
  _Address.POBox AS POBox,
  _Address.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _Address.POBoxPostalCode AS POBoxPostalCode,
  _Address.POBoxLobbyName AS POBoxLobbyName,
  _Address.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _Address.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _Address.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _Address.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _Address.DeliveryServiceNumber AS DeliveryServiceNumber,
  _Address.AddressTimeZone AS AddressTimeZone,
  _Address.CityFileTestStatus AS CityFileTestStatus,
  _Address.AddressStreetUnusable AS AddressStreetUnusable,
  _Address.AddressPostBoxUnusable AS AddressPostBoxUnusable,
  _Address.FullName AS FullName,
  _Address.CityName AS CityName,
  _Address.DistrictName AS DistrictName,
  _Address.District AS District,
  _Address.InvgCsMAddrDistrictCode AS InvgCsMAddrDistrictCode,
  _Address.InvgCsMAddrDiffntCityName AS InvgCsMAddrDiffntCityName,
  _Address.InvgCsMAddrValidFromDate AS InvgCsMAddrValidFromDate,
  _Address.InvgCsMAddrValidToDate AS InvgCsMAddrValidToDate,
  _Address.InvgCsMAddrNameText AS InvgCsMAddrNameText,
  _Address.InvgCsMAddrNameCareOfText AS InvgCsMAddrNameCareOfText,
  _Address.InvgCsMAddrRegionGroup AS InvgCsMAddrRegionGroup,
  _Address.InvgCsMAddrPostlCodeExtn AS InvgCsMAddrPostlCodeExtn,
  _Address.InvgCsMAddrPOBoxCodeExtn AS InvgCsMAddrPOBoxCodeExtn,
  _Address.InvgCsMAddrCustPostCodeExtn AS InvgCsMAddrCustPostCodeExtn,
  _Address.HomeCityName AS HomeCityName,
  _Address.PostalCode AS PostalCode,
  _Address.CompanyPostalCode AS CompanyPostalCode,
  _Address.StreetName AS StreetName,
  _Address.StreetPrefixName AS StreetPrefixName,
  _Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  _Address.StreetSuffixName AS StreetSuffixName,
  _Address.HouseNumber AS HouseNumber,
  _Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  _Address.InvgCsMAddrHouseNumberRange AS InvgCsMAddrHouseNumberRange,
  _Address.Building AS Building,
  _Address.Floor AS Floor,
  _Address.RoomNumber AS RoomNumber,
  _Address.SecondaryRegionName AS SecondaryRegionName,
  _Address.County AS County,
  _Address.TownshipCode AS TownshipCode,
  _Address.TownshipName AS TownshipName,
  _Address.FormOfAddress AS FormOfAddress,
  _Address.CityNumber AS CityNumber,
  _Address.CityCode AS CityCode,
  _Address.Country AS Country,
  _Address.CountyCode AS CountyCode,
  _Address.Region AS Region,
  _Address.BusinessPartnerName1 AS BusinessPartnerName1,
  _Address.BusinessPartnerName2 AS BusinessPartnerName2,
  _Address.SearchTerm1 AS SearchTerm1,
  _Address.SearchTerm2 AS SearchTerm2,
  _Address.StreetSearch AS StreetSearch,
  _Address.CitySearch AS CitySearch,
  _Address.Nation AS Nation,
  _Address.BusinessPartnerName3 AS BusinessPartnerName3,
  _Address.BusinessPartnerName4 AS BusinessPartnerName4,
  _Address.TaxJurisdiction AS TaxJurisdiction,
  _Address.TransportZone AS TransportZone,
  _Address.AddressCityPostBoxCode AS AddressCityPostBoxCode,
  _Address.InvgCsMAddrPostDelivDstrctCode AS InvgCsMAddrPostDelivDstrctCode,
  _Address.InvgCsMAddrStCode AS InvgCsMAddrStCode,
  _Address.InvgCsMAddrStAbbrCode AS InvgCsMAddrStAbbrCode,
  _Address.InvgCsMAddrSortPhone AS InvgCsMAddrSortPhone,
  _Address.InvgCsMAddrOrigin AS InvgCsMAddrOrigin,
  _Address.InvgCsMAddrExtn1Text AS InvgCsMAddrExtn1Text,
  _Address.InvgCsMAddrExtn2Text AS InvgCsMAddrExtn2Text,
  _Address.InvgCsMAddressID AS InvgCsMAddressID,
  _Address.InvgCsMAddrRecdLangCrtnCode AS InvgCsMAddrRecdLangCrtnCode,
  _Address.InvgCsMAddrBizPrpsIsCmpltd AS InvgCsMAddrBizPrpsIsCmpltd,
  _Address.InvgCsMAddrRemarkText AS InvgCsMAddrRemarkText,
  image_id AS InvgCsMImageFileID,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  latitude AS InvgCsMGeoLocationLatitude,
  longitude AS InvgCsMGeoLocationLongitude,
  altitude AS InvgCsMGeoLocationAltitude,
  arch_status AS ArchivingStatus,
  _Address._CountyCode AS _CountyCode,
  _Address._CityCode AS _CityCode,
  _Address._Country AS _Country,
  _Address._Region AS _Region
FROM crms4d_icm_loc AS _location
LEFT OUTER JOIN I_InvgCsMAddress AS _Address ON _Address.AddressID = _location.addrnumber  -- association [1..1]
LEFT OUTER JOIN E_InvgCsMLocation AS _LocationExtension ON _location.location_id = _LocationExtension.InvgCsMLocationID  -- association [1..1]
;