I_UtilsTechnicalObjLocation

DDL: I_UTILSTECHNICALOBJLOCATION SQL: IETECHOBJLOC Type: view BASIC

Technical Object Location

I_UtilsTechnicalObjLocation is a Basic CDS View (Dimension) that provides data about "Technical Object Location" in SAP S/4HANA. It reads from 1 data source (I_FunctionalLocation) and exposes 12 fields with key field FunctionalLocation. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_FunctionalLocation I_FunctionalLocation from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.maintenanceplant = _Plant.Plant

Annotations (14)

NameValueLevelField
EndUserText.label Technical Object Location view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey FunctionalLocation view
AbapCatalog.sqlViewName IETECHOBJLOC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation I_FunctionalLocation FunctionalLocation
MaintObjectLocAcctAssgmtNmbr I_FunctionalLocation MaintObjectLocAcctAssgmtNmbr
MaintenancePlant
AddressID
MaintenanceObjectLocation
_FunctionalLocationText I_FunctionalLocation _FunctionalLocationText
MaintenancePlanningPlant I_FunctionalLocation MaintenancePlanningPlant
MaintenancePlannerGroup I_FunctionalLocation MaintenancePlannerGroup
AuthorizationGroup I_FunctionalLocation AuthorizationGroup
_Plant _Plant
_MaintenancePlannerGroup _MaintenancePlannerGroup
_MaintenancePlanningPlant _MaintenancePlanningPlant 
@EndUserText.label: 'Technical Object Location' //same as DDL description

@VDM.viewType: #BASIC
@Analytics: { dataCategory: #DIMENSION }
@ObjectModel.semanticKey:  [ 'FunctionalLocation' ]
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.representativeKey: 'FunctionalLocation'
@AbapCatalog.sqlViewName: 'IETECHOBJLOC'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: 'MASTER'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter:true
//@AbapCatalog.preserveKey:true

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE ]
@Metadata.allowExtensions:true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION

define view I_UtilsTechnicalObjLocation
  as select from I_FunctionalLocation
  association [0..1] to I_Plant as _Plant on $projection.maintenanceplant = _Plant.Plant
{
  key I_FunctionalLocation.FunctionalLocation,
      I_FunctionalLocation.MaintObjectLocAcctAssgmtNmbr,
      @ObjectModel.foreignKey.association: '_Plant'
      I_FunctionalLocation._LocationAccountAssignment[1: MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr].MaintenancePlant,
      //    I_FunctionalLocation._LocationAccountAssignment[1: MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr]._Plant,

      I_FunctionalLocation._LocationAccountAssignment[1: MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr].AddressID,
      I_FunctionalLocation._LocationAccountAssignment[1: MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr].MaintenanceObjectLocation,
      I_FunctionalLocation._FunctionalLocationText,
      @ObjectModel.foreignKey.association: '_MaintenancePlanningPlant'
      I_FunctionalLocation.MaintenancePlanningPlant,
      @ObjectModel.foreignKey.association: '_MaintenancePlannerGroup'
      I_FunctionalLocation.MaintenancePlannerGroup,
      I_FunctionalLocation.AuthorizationGroup,
      _Plant,
      _MaintenancePlannerGroup,
      _MaintenancePlanningPlant

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNCTIONALLOCATION",
"I_LOCATIONACCOUNTASSIGNMENT"
],
"ASSOCIATED":
[
"I_FUNCTIONALLOCATIONTEXT",
"I_MAINTENANCEPLANNERGROUP",
"I_MAINTENANCEPLANPLANT",
"I_PLANT"
],
"BASE":
[
"I_FUNCTIONALLOCATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More