C_ReExAssignEquipment

DDL: C_REEXASSIGNEQUIPMENT SQL: CREEXASSEQUI Type: view CONSUMPTION

Equipment Assignment

C_ReExAssignEquipment is a Consumption CDS View that provides data about "Equipment Assignment" in SAP S/4HANA. It reads from 1 data source (I_TechnicalObject) and exposes 19 fields with key fields TechnicalObject, TechObjIsEquipOrFuncnlLoc.

1 data source(s) 19 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 CREEXASSEQUI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Equipment Assignment view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

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
FunctionalLocation _LocationAccountAssignment FunctionalLocation
CostCenter _LocationAccountAssignment CostCenter
ControllingArea _LocationAccountAssignment ControllingArea
MaintenancePlanningPlant MaintenancePlanningPlant
MaintenancePlannerGroup MaintenancePlannerGroup
AuthorizationGroup AuthorizationGroup
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
_LocationAccountAssignment _LocationAccountAssignment 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CREEXASSEQUI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Equipment Assignment'
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
   usageType.serviceQuality: #X,
   usageType.sizeCategory: #XL,
   usageType.dataClass: #MIXED
}
define view C_ReExAssignEquipment 
  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,
      @EndUserText.label: 'Planning Plant Name'
      _MaintenancePlanningPlant.PlantName,   
      cast(TechnicalObject as char40) as TechObjectWithLeadingZeros,
      _LocationAccountAssignment.BusinessArea,
      _LocationAccountAssignment.CompanyCode,
      _LocationAccountAssignment.FunctionalLocation,      
      //DCL fields

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

      //_LocationAccountAssignment key

      MaintObjectLocAcctAssgmtNmbr,
      _LocationAccountAssignment

} 

where TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOCATIONACCOUNTASSIGNMENT",
"I_PLANT",
"I_TECHNICALOBJECT",
"I_TECHNICALOBJECTCATEGORY",
"I_TECHNICALOBJECTCATEGORYT",
"I_TECHNICALOBJECTTEXT",
"I_TECHNICALOBJECTTYPE",
"I_TECHNICALOBJECTTYPETEXT"
],
"ASSOCIATED":
[
"I_LOCATIONACCOUNTASSIGNMENT"
],
"BASE":
[
"I_TECHNICALOBJECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More