I_LocationAnalytics
Location
I_LocationAnalytics is a Composite CDS View (Dimension) that provides data about "Location" in SAP S/4HANA. It reads from 1 data source (I_LocationBasic) and exposes 18 fields with key field Location. It has 5 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_LocationBasic | _Location | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_BusinessPartner | _BusinessPartner | $projection.BusinessPartner = _BusinessPartner.BusinessPartner |
| [0..1] | I_BusinessPartner | _CollaborationPartner | $projection.CollaborationPartner = _CollaborationPartner.BusinessPartner |
| [0..1] | I_UnitOfMeasure | _GeoCoordinatesUnit | $projection.GeoCoordinatesUnit = _GeoCoordinatesUnit.UnitOfMeasure |
| [0..*] | I_LocationAnalyticsText | _Text | $projection.Location = _Text.Location |
| [0..1] | I_LocationType | _LocationType | $projection.LocationType = _LocationType.LocationType |
Annotations (18)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Location | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AbapCatalog.sqlViewName | ILOCATIONANA | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.representativeKey | Location | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| VDM.viewType | #COMPOSITE | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.dataExtraction.enabled | true | view | |
| Analytics.internalName | #LOCAL | view |
Fields (18)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Location | Location | ||
| LocationUUID | LocationUUID | |||
| LocationType | LocationType | |||
| LocationAdditionalUUID | LocationAdditionalUUID | |||
| AddressID | AddressID | |||
| CollaborationPartner | CollaborationPartner | |||
| BusinessPartnerUUID | BusinessPartnerUUID | |||
| BusinessPartner | ||||
| AuthorizationGroup | I_LocationBasic | AuthorizationGroup | ||
| IsBusinessPurposeCompleted | I_LocationBasic | IsBusinessPurposeCompleted | ||
| Latitude | Latitude | |||
| Longitude | Longitude | |||
| GeoCoordinatesUnit | ||||
| _BusinessPartner | _BusinessPartner | |||
| _CollaborationPartner | _CollaborationPartner | |||
| _GeoCoordinatesUnit | _GeoCoordinatesUnit | |||
| _LocationType | _LocationType | |||
| _Text | _Text |
@EndUserText.label: 'Location'
@AccessControl: {authorizationCheck: #CHECK,
personalData.blocking: #REQUIRED,
personalData.blockingIndicator: [ 'IsBusinessPurposeCompleted', '_BusinessPartner.IsBusinessPurposeCompleted', '_CollaborationPartner.IsBusinessPurposeCompleted' ]}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata: {allowExtensions: true,
ignorePropagatedAnnotations: true}
@AbapCatalog: {sqlViewName: 'ILOCATIONANA',
compiler.compareFilter: true,
buffering: {status: #NOT_ALLOWED},
preserveKey: true}
@ObjectModel: {representativeKey: 'Location',
semanticKey: [ 'Location' ],
usageType: {serviceQuality: #C,
sizeCategory: #L,
dataClass: #MASTER},
supportedCapabilities: [ #ANALYTICAL_DIMENSION,
#CDS_MODELING_ASSOCIATION_TARGET,
#SQL_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE,
#EXTRACTION_DATA_SOURCE] }
@VDM: {viewType: #COMPOSITE}
@Analytics: {dataCategory: #DIMENSION,
dataExtraction: {enabled: true},
internalName: #LOCAL}
define view I_LocationAnalytics
as select from I_LocationBasic as _Location
association [0..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [0..1] to I_BusinessPartner as _CollaborationPartner on $projection.CollaborationPartner = _CollaborationPartner.BusinessPartner
association [0..1] to I_UnitOfMeasure as _GeoCoordinatesUnit on $projection.GeoCoordinatesUnit = _GeoCoordinatesUnit.UnitOfMeasure
association [0..*] to I_LocationAnalyticsText as _Text on $projection.Location = _Text.Location
association [0..1] to I_LocationType as _LocationType on $projection.LocationType = _LocationType.LocationType
{
@ObjectModel.text.association: '_Text'
key Location,
@Semantics.uuid:true
LocationUUID,
@ObjectModel.foreignKey.association: '_LocationType'
LocationType,
@Semantics.uuid:true
LocationAdditionalUUID,
AddressID,
@ObjectModel.foreignKey.association: '_CollaborationPartner'
CollaborationPartner,
@Semantics.uuid:true
BusinessPartnerUUID,
@ObjectModel.foreignKey.association: '_BusinessPartner'
_Location._BusinessPartner.BusinessPartner as BusinessPartner,
_Location.AuthorizationGroup as AuthorizationGroup,
@Semantics.booleanIndicator
_Location.IsBusinessPurposeCompleted as IsBusinessPurposeCompleted,
@Semantics.geoLocation.latitude: true
@Semantics.quantity.unitOfMeasure: 'GeoCoordinatesUnit'
Latitude,
@Semantics.geoLocation.longitude: true
@Semantics.quantity.unitOfMeasure: 'GeoCoordinatesUnit'
Longitude,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_GeoCoordinatesUnit'
cast ( 'DEG' as /scmtms/vdm_geocoord_unit ) as GeoCoordinatesUnit, // /scmtms/vdm_geocoord_unit C1 released
/* Associations */
_BusinessPartner,
_CollaborationPartner,
_GeoCoordinatesUnit,
_LocationType,
_Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONBASIC",
"I_TMBUSINESSPARTNERBYINTKEY"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_LOCATIONANALYTICSTEXT",
"I_LOCATIONTYPE",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA