I_LocationBasic

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_LocationBasic.
-- 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: ILOCATIONBASIC

CREATE VIEW I_LocationBasic AS
SELECT
  cast( locid as /sapapo/location_id preserving type ) AS LocationUUID,
  locno AS Location,
  loctype AS LocationType,
  cast( loc_uuid as /sapapo/location_uuid preserving type ) AS LocationAdditionalUUID,
  unlocode AS LocationUNCode,
  iatacode AS LocationIATACode,
  tzone AS LocationTimeZone,
  osta_flag AS LocationIsTemporary,
  adrnummer AS AddressID,
  locprio AS LocationProcessingPriority,
  cast( partner as /sapapo/collaboration_partner preserving type ) AS CollaborationPartner,
  partner_guid AS BusinessPartnerUUID,
  trailer_handling AS LocationTrailerHandling,
  locloadprofile AS LocationLoadingProfile,
  attequiprofile AS AttachedEquipmentProfile,
  shipper_sec_sts AS HandoverPartySecurityStatus,
  shipper_code AS HandoverParty,
  shipper_validity AS HandoverPartyExpiryDate,
  xpos AS Longitude,
  ypos AS Latitude,
  cast( geo_validity_end as tzntstmps preserving type ) AS GeoCoordsValidityEndDateTime,
  gc_level AS GeoCoordinatesLevel,
  strategy AS GeoCoordinatesStrategy,
  match_gc AS GeoCoordinatesMatchPercent,
  srcid AS GeoCoordinatesDataSource,
  gis_zone AS GeogrlInformationSystemZone,
  precisid AS GeoCoordinatesPrecision,
  manually_changed_gc AS GeoCoordsAreManuallyChanged,
  locally_changed_gc AS GeoCoordsAreLocallyChanged,
  cast( createutc as tzntstmpl ) AS CreationDateTime,
  createuser AS CreatedByUser,
  cast( changeutc as tzntstmps ) AS ChangedDateTime,
  changeuser AS LastChangedByUser,
  lvorm AS LocationIsMarkedForDeletion,
  cast( tpres_inb as /sapapo/tpres_inb preserving type ) AS InboundLoadingResourceUUID,
  cast( tpres_out as /sapapo/tpres_out preserving type ) AS OutboundLoadingResourceUUID,
  resflag AS ResourceValidity,
  cast( time_res as /sapapo/time_res_inb preserving type ) AS InboundCalendarResourceUUID,
  cast( time_res_out as /sapapo/time_res_out preserving type ) AS OutboundCalendarResourceUUID,
  gln AS GlobalLocationNumber,
  duns4 AS LocationDUNSNumber,
  dpcal AS SrvcPartsPlanningCalendar,
  capparm AS NumberOfSTOSendingLocation,
  capparm_rcv AS NumberOfSTOReceivingLocation,
  lgrad AS TargetServiceLevelRatio,
  bntyp AS LocationIsContractPackager,
  distr AS LocationDeliveryIsSpecial,
  loc_xblck AS IsBusinessPurposeCompleted,
  adv_shp_recv_rlv AS LocationAdvncdShipgRcvgRlvnce,
  _LocationAuthGroupEval.AuthorizationGroup AS AuthorizationGroup
FROM /sapapo/loc
LEFT OUTER JOIN I_BusinessPartner AS _CollaborationPartner ON CollaborationPartner = _CollaborationPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_AddressDefaultRepresentation AS _AddrDfltRprstn ON AddressID = _AddrDfltRprstn.AddressID  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _AddrAddlRprstn ON AddressID = _AddrAddlRprstn.AddressID AND _AddrAddlRprstn.AddressRepresentationCode is not initial  -- association [0..*]
LEFT OUTER JOIN I_AddrOrgNamePostalAddress AS _PostalAddrDfltRprstn ON AddressID = _PostalAddrDfltRprstn.AddressID AND _PostalAddrDfltRprstn.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_TMBusinessPartnerByIntKey AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_LocationText AS _Text ON LocationUUID = _Text.LocationUUID  -- association [0..*]
LEFT OUTER JOIN I_LocationType AS _LocationType ON LocationType = _LocationType.LocationType  -- association [0..1]
LEFT OUTER JOIN P_LocationAuthGroupEval AS _LocationAuthGroupEval ON LocationUUID = _LocationAuthGroupEval.LocationUUID  -- association [1..1]
;