R_LocationTP

DDL: R_LOCATIONTP Type: view_entity TRANSACTIONAL Package: RAP_LOCATION
34 Fields 1 Data Sources 6 Associations

Transactional Processing View for Location

R_LocationTP is a Transactional CDS View that provides data about "Transactional Processing View for Location" in SAP S/4HANA. It reads from 1 data source (I_LocationBasic) and exposes 34 fields with key field LocationUUID. It has 6 associations to related views. Part of development package RAP_LOCATION.

Data Sources (1)

SourceAliasJoin Type
I_LocationBasic _LocationBasic from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_TranspUNLocationCode _TranspUNLocationCode _TranspUNLocationCode.LocationUNCode = $projection.LocationUNCode
[0..1] I_TranspIATALocationCode _TranspIATALocationCode _TranspIATALocationCode.LocationIATACode = $projection.LocationIATACode
[0..1] E_LocationBasic _Extension $projection.LocationUUID = _Extension.LocationUUID
[0..*] R_LocationTextTP _LocationTextTP
[0..1] R_LocationAddressTP _LocationAddressTP
[0..*] R_LocationGeoCoordinatesTP _LocationGeoCoordinatesTP

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.sapObjectNodeType.name Location view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY LocationUUID LocationUUID UUID
Location Text
LocationType I_LocationBasic LocationType Location Type
LocationAdditionalUUID LocationAdditionalUUID
LocationTimeZone Time Zone Difference
GlobalLocationNumber GlobalLocationNumber GLN
LocationDUNSNumber LocationDUNSNumber DUNS+4
LocationUNCode UN/LOCODE
LocationIATACode LocationIATACode IATA Code
Longitude Longitude Longitude
Latitude Latitude Latitude
GeoCoordsValidityEndDateTime GeoCoordsValidityEndDateTime
GeoCoordinatesLevel GeoCoordinatesLevel Geocoding Level
GeoCoordinatesStrategy GeoCoordinatesStrategy Strategy
GeoCoordinatesMatchPercent GeoCoordinatesMatchPercent Match (%)
GeoCoordinatesDataSource GeoCoordinatesDataSource Diag.Srce ID
GeogrlInformationSystemZone GeogrlInformationSystemZone GIS Zone
GeoCoordinatesPrecision GeoCoordinatesPrecision Precision
GeoCoordsAreManuallyChanged GeoCoordsAreManuallyChanged Manually Changed GC
GeoCoordsAreLocallyChanged GeoCoordsAreLocallyChanged Local Change in GC
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
ChangedDateTime ChangedDateTime Time Stamp
LocalLastChangeDateTime ChangedDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
LocationIsTemporary LocationIsTemporary Temporary Location
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
AddressID I_LocationBasic AddressID Ship-to address
_LocationType _LocationType
_TranspUNLocationCode _TranspUNLocationCode
_TranspIATALocationCode _TranspIATALocationCode
_LocationTextTP _LocationTextTP
_LocationAddressTP _LocationAddressTP
_LocationGeoCoordinatesTP _LocationGeoCoordinatesTP

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 R_LocationTP.
-- 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.

CREATE VIEW R_LocationTP AS
SELECT
  LocationUUID,
  cast( Location as /sapapo/locno preserving type ) AS Location,
  _LocationBasic.LocationType AS LocationType,
  LocationAdditionalUUID,
  cast( LocationTimeZone as tznzone preserving type ) AS LocationTimeZone,
  GlobalLocationNumber,
  LocationDUNSNumber,
  cast( LocationUNCode as /sapapo/loc_unlocode preserving type ) AS LocationUNCode,
  LocationIATACode,
  Longitude,
  Latitude,
  GeoCoordsValidityEndDateTime,
  GeoCoordinatesLevel,
  GeoCoordinatesStrategy,
  GeoCoordinatesMatchPercent,
  GeoCoordinatesDataSource,
  GeogrlInformationSystemZone,
  GeoCoordinatesPrecision,
  GeoCoordsAreManuallyChanged,
  GeoCoordsAreLocallyChanged,
  CreationDateTime,
  CreatedByUser,
  ChangedDateTime,
  ChangedDateTime AS LocalLastChangeDateTime,
  LastChangedByUser,
  LocationIsTemporary,
  IsBusinessPurposeCompleted,
  _LocationBasic.AddressID AS AddressID
FROM I_LocationBasic AS _LocationBasic
LEFT OUTER JOIN I_TranspUNLocationCode AS _TranspUNLocationCode ON _TranspUNLocationCode.LocationUNCode = LocationUNCode  -- association [0..1]
LEFT OUTER JOIN I_TranspIATALocationCode AS _TranspIATALocationCode ON _TranspIATALocationCode.LocationIATACode = LocationIATACode  -- association [0..1]
LEFT OUTER JOIN E_LocationBasic AS _Extension ON LocationUUID = _Extension.LocationUUID  -- association [0..1]
LEFT OUTER JOIN R_LocationTextTP AS _LocationTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_LocationAddressTP AS _LocationAddressTP ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_LocationGeoCoordinatesTP AS _LocationGeoCoordinatesTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More