C_ReExAssignFuncLocation

DDL: C_REEXASSIGNFUNCLOCATION SQL: CREEXASSFUNCL Type: view CONSUMPTION Package: ODATA_RE_EX

Functional Location Assignment

C_ReExAssignFuncLocation is a Consumption CDS View that provides data about "Functional Location Assignment" in SAP S/4HANA. It reads from 1 data source (I_TechnicalObject) and exposes 18 fields with key fields TechnicalObject, TechObjIsEquipOrFuncnlLoc. Part of development package ODATA_RE_EX.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_TechnicalObject I_TechnicalObject from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CREEXASSFUNCL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Functional Location Assignment view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY TechnicalObject TechnicalObject
KEY TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc
TechnicalObjectDescription Description
TechnicalObjectCategory TechnicalObjectCategory Category
TechnicalObjectCategoryDesc
TechnicalObjectType TechnicalObjectType Type
TechnicalObjectTypeDesc Type
PlantName _MaintenancePlanningPlant PlantName Planning Plant Name
TechObjectWithLeadingZeros
BusinessArea _LocationAccountAssignment BusinessArea
CompanyCode _LocationAccountAssignment CompanyCode
CostCenter _LocationAccountAssignment CostCenter
ControllingArea _LocationAccountAssignment ControllingArea
MaintenancePlanningPlant MaintenancePlanningPlant
MaintenancePlannerGroup MaintenancePlannerGroup
AuthorizationGroup AuthorizationGroup
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
_LocationAccountAssignment _LocationAccountAssignment 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CREEXASSFUNCL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Functional Location Assignment'
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
   usageType.serviceQuality: #X,
   usageType.sizeCategory: #XL,
   usageType.dataClass: #MIXED
}
define view C_ReExAssignFuncLocation 
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from I_TechnicalObject

{
  key TechnicalObject,
  key TechObjIsEquipOrFuncnlLoc,

      @EndUserText.label: 'Description'
      _TechnicalObjectText[1:Language = $session.system_language].TechnicalObjectDescription,
      @Semantics.text: true
      @ObjectModel.text.element:  [ 'TechnicalObjectCategoryDesc' ]
      @EndUserText.label: 'Category'
      TechnicalObjectCategory,
      @Semantics.text: true
      _TechnicalObjectCategory._Text[1: Language = $parameters.P_Language].TechnicalObjectCategoryDesc,
      @EndUserText.label: 'Type'
      @ObjectModel.text.element:  [ 'TechnicalObjectTypeDesc' ]
      TechnicalObjectType,
      @EndUserText.label: 'Type'
      @Semantics.text: true
      _TechnicalObjectType._Text[1: Language = $parameters.P_Language].TechnicalObjectTypeDesc,
      //_LocationAccountAssignment.PlantName,

      @EndUserText.label: 'Planning Plant Name'
      _MaintenancePlanningPlant.PlantName,   
      cast(TechnicalObject as char40) as TechObjectWithLeadingZeros,
      _LocationAccountAssignment.BusinessArea,
      _LocationAccountAssignment.CompanyCode,
      //DCL fields

      _LocationAccountAssignment.CostCenter,
      _LocationAccountAssignment.ControllingArea,
      MaintenancePlanningPlant,
      MaintenancePlannerGroup,
      AuthorizationGroup,
      //Association key for DCL

      //_LocationAccountAssignment key

      MaintObjectLocAcctAssgmtNmbr,
      _LocationAccountAssignment

} 

where TechObjIsEquipOrFuncnlLoc = 'EAMS_FL'

Learn More