I_FrcElmntWorkCenter

@EndUserText.label: 'Force elements by plant and Work Center'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog: { sqlViewName: 'IDFSPLANTWC' }
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.algorithm: #SESSION_VARIABLE


define view I_FrcElmntWorkCenter
  as select from crhd

  association [1..1] to crtx    as _text     on  $projection.WorkCenterInternalID = _text.objid

  association [1..1] to hrp1001 as _force    on  $projection.WorkCenterInternalID = _force.objid
  association [1..1] to t001w   as _PlantTxt on  $projection.Plant = _PlantTxt.werks
                                             and _PlantTxt.spras   = $session.system_language
{
  key crhd.objid      as WorkCenterInternalID,
  key _force.sobid    as FrcElmntOrgRelatedOrgID,
      crhd.objty      as WorkCenterTypeCode,
      crhd.werks      as Plant,
      crhd.arbpl      as WorkCenter,
      _text.spras     as Language,
      _text.ktext     as FrcElmntOrgWorkCenterDesc,
      _force.otype    as FrcElmntOrgType,
      _force.plvar    as FrcElmntOrgPlanVersion,
      _force.begda    as FrcElmntOrgValdtyStartDate,
      _force.endda    as FrcElmntOrgValdtyEndDate,
      _force.subty    as FrcElmntOrgSubType,
      _force.sclas    as FrcElmntOrgRelatedOrgType,
      _PlantTxt.name1 as FrcElmntOrgStockPlantName

}
where
      objty       = 'A'
  and _text.spras = $session.system_language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRHD",
"CRTX",
"HRP1001",
"T001W"
],
"ASSOCIATED":
[
"CRTX",
"HRP1001",
"T001W"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/