A_WorkCenterDescription

DDL: A_WORKCENTERDESCRIPTION SQL: AWORKCTRDESC Type: view COMPOSITE

Description

A_WorkCenterDescription is a Composite CDS View that provides data about "Description" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterText) and exposes 7 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, Language. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterText I_WorkCenterText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_WorkCenters _WorkCenter $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AWORKCTRDESC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Description view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.updateEnabled true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
KEY Language Language
WorkCenterDesc WorkCenterText
WorkCenter _WorkCenter WorkCenter
Plant _WorkCenter Plant
WorkCenterCategoryCode _WorkCenter WorkCenterCategoryCode 
@AbapCatalog.sqlViewName: 'AWORKCTRDESC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Description'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory : #S, dataClass: #MIXED}
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel.updateEnabled: true
define view A_WorkCenterDescription
  as select from I_WorkCenterText
  association [1..1] to A_WorkCenters as _WorkCenter on  $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
                                                     and $projection.WorkCenterTypeCode   = _WorkCenter.WorkCenterTypeCode
{
  key WorkCenterInternalID,
  key WorkCenterTypeCode,

  key Language,

      @Semantics.text : true
      WorkCenterText                                     as WorkCenterDesc,

      _WorkCenter.WorkCenter                             as WorkCenter,
      _WorkCenter.Plant,
      _WorkCenter.WorkCenterCategoryCode,
      case when _WorkCenter.WorkCenterLastChangeDateTime is null then
       cast(dats_tims_to_tstmp(cast('20190101' as dats), cast('120000'as tims), 'UTC', $session.client, 'NULL') as cr_lastchange_datetime)
       else _WorkCenter.WorkCenterLastChangeDateTime end as WorkCenterLastChangeDateTime
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_WORKCENTERS",
"I_WORKCENTERTEXT"
],
"ASSOCIATED":
[
"A_WORKCENTERS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More