C_FunctionalLocationDP

DDL: C_FUNCTIONALLOCATIONDP Type: view_entity CONSUMPTION Package: VDM_EAM_FUNCTIONALLOCATION

Functional Location

C_FunctionalLocationDP is a Consumption CDS View that provides data about "Functional Location" in SAP S/4HANA. It reads from 1 data source (C_FunctionalLocationDEX) and exposes 42 fields with key field FunctionalLocation. It has 2 associations to related views. It is exposed through 1 OData service (DP_FUNCTIONALLOCATION). Part of development package VDM_EAM_FUNCTIONALLOCATION.

Data Sources (1)

SourceAliasJoin Type
C_FunctionalLocationDEX C_FunctionalLocationDEX from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_FuncLocationPartnerDP _FunctionalLocation $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
[0..*] C_FunctionalLocationTextDP _Text $projection.FunctionalLocation = _Text.FunctionalLocation

Annotations (12)

NameValueLevelField
EndUserText.label Functional Location view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey FunctionalLocation view
ObjectModel.sapObjectNodeType.name FunctionalLocation view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
DataIntegration.deltaReplication.intended true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
DP_FUNCTIONALLOCATION DP_FUNCTIONALLOCATION C2 NOT_RELEASED

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation FunctionalLocation
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
ABCIndicator ABCIndicator
AddressID AddressID
MasterFixedAsset MasterFixedAsset
ConstructionMaterial ConstructionMaterial
CompanyCode CompanyCode
CostCenter CostCenter
ControllingArea ControllingArea
OperationStartDate OperationStartDate
TechnicalObjectType TechnicalObjectType
AssetLocation AssetLocation
MaintenancePlant MaintenancePlant
AssetRoom AssetRoom
MaintenancePlanningPlant MaintenancePlanningPlant
PlantSection PlantSection
MaintenancePlannerGroup MaintenancePlannerGroup
WBSElementExternalID WBSElementExternalID
FunctionalLocationCategory FunctionalLocationCategory
MainWorkCenter MainWorkCenter
MainWorkCenterPlant MainWorkCenterPlant
SettlementOrder SettlementOrder
WorkCenter WorkCenter
WorkCenterPlant WorkCenterPlant
MainWorkCenterInternalID MainWorkCenterInternalID
WorkCenterInternalID WorkCenterInternalID
WorkCenterTypeCode WorkCenterTypeCode
SuperiorFunctionalLocation SuperiorFunctionalLocation
CreationDate CreationDate
LastChangeDate LastChangeDate
AuthorizationGroup AuthorizationGroup
LastChangeDateTime LastChangeDateTime
FunctionalLocationEndOfUseDate FunctionalLocationEndOfUseDate
MaintObjectInternalID MaintObjectInternalID
FuncnlLocIsMarkedForDeletion FuncnlLocIsMarkedForDeletion
WBSElementInternalID WBSElementInternalID
LinearDataStartPoint LinearDataStartPoint
LinearDataEndPoint LinearDataEndPoint
LinearDataLength LinearDataLength
LinearDataUnitOfMeasure LinearDataUnitOfMeasure
_FunctionalLocation _FunctionalLocation
_Text _Text
@EndUserText.label: 'Functional Location'
@AccessControl: {
    authorizationCheck:      #MANDATORY,
    personalData.blocking:   #REQUIRED
    }
@ObjectModel: {
    supportedCapabilities: [ #EXTERNAL_DATA_PROVIDER ],
    representativeKey: 'FunctionalLocation',
    sapObjectNodeType.name: 'FunctionalLocation',
    usageType: {
       dataClass: #MIXED,
       serviceQuality: #C,
       sizeCategory: #XL
       }
    }
@DataIntegration.deltaReplication: { intended: true }
@VDM.viewType: #CONSUMPTION
@Metadata: {
    ignorePropagatedAnnotations: true,
    allowExtensions: true }
define root view entity C_FunctionalLocationDP
  as select from C_FunctionalLocationDEX
  association [0..*] to C_FuncLocationPartnerDP    as _FunctionalLocation on $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
  association [0..*] to C_FunctionalLocationTextDP as _Text               on $projection.FunctionalLocation = _Text.FunctionalLocation
{
  key FunctionalLocation,
      MaintObjectLocAcctAssgmtNmbr,
      ABCIndicator,
      AddressID,
      MasterFixedAsset,
      ConstructionMaterial,
      CompanyCode,
      CostCenter,
      ControllingArea,
      OperationStartDate,
      TechnicalObjectType,
      AssetLocation,
      MaintenancePlant,
      AssetRoom,
      MaintenancePlanningPlant,
      PlantSection,
      MaintenancePlannerGroup,
      //      WBSElement,

      WBSElementExternalID,
//      @ObjectModel.sapObjectNodeTypeReference: 'FunctionalLocationCategory'

      FunctionalLocationCategory,
      MainWorkCenter,
      MainWorkCenterPlant,
      SettlementOrder,
      WorkCenter,
      WorkCenterPlant,
      MainWorkCenterInternalID,
      WorkCenterInternalID,
      WorkCenterTypeCode,
      SuperiorFunctionalLocation,
      CreationDate,
      LastChangeDate,
      AuthorizationGroup,
      LastChangeDateTime,
      FunctionalLocationEndOfUseDate,
      MaintObjectInternalID,
      @Semantics.booleanIndicator: true
      FuncnlLocIsMarkedForDeletion,
      WBSElementInternalID,
      LinearDataStartPoint,
      LinearDataEndPoint,
      @Semantics.quantity.unitOfMeasure: 'LinearDataUnitOfMeasure'
      LinearDataLength,
      LinearDataUnitOfMeasure,
      /* Associations */
      //      _ABCIndicator,

      //      _CompanyCode,

      //      _ConstructionMaterial,

      //      _ControllingArea,

      //      _CostCenter,

      //      _FuncnlLocIsMarkedForDeletion,

      //      _FunctionalLocationCategory,

      //      _FunctionalLocationText,

      //      _Location,

      //      _MaintenancePlannerGroup,

      //      _MaintenancePlanningPlant,

      //      _MaintenancePlanPlant,

      //      _MaintenancePlant,

      //      _MainWorkCenter,

      //      _MainWorkCenterBySemanticKey,

      //      _MainWorkCenterPlant,

      //      _MasterFixedAsset,

      //      _PlantSection,

      //      _SettlementOrder,

      //      _TechnicalObjectType,

      //      _WBSElementBasicData,

      //      _WorkCenter,

      //      _WorkCenterBySemanticKey,

      //      _WorkCenterPlant,

      //      _WorkCenterType,


      _FunctionalLocation,
      _Text
}