A_WorkCenterCapacityText

DDL: A_WORKCENTERCAPACITYTEXT SQL: AWRKCTRCAPTXT Type: view COMPOSITE

Capacity Description

A_WorkCenterCapacityText is a Composite CDS View that provides data about "Capacity Description" in SAP S/4HANA. It reads from 1 data source (I_CapacityText) and exposes 3 fields with key fields CapacityInternalID, Language. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_CapacityText I_CapacityText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_WorkCenterCapacity _Capacity $projection.CapacityInternalID = _Capacity.CapacityInternalID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AWRKCTRCAPTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Capacity 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 (3)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID
KEY Language Language
CapacityText CapacityText 
@AbapCatalog.sqlViewName: 'AWRKCTRCAPTXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Capacity 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_WorkCenterCapacityText
  as select from I_CapacityText
  association [1..1] to A_WorkCenterCapacity as _Capacity on $projection.CapacityInternalID = _Capacity.CapacityInternalID
{
  key CapacityInternalID,
  key Language,

      @Semantics.text: true
      CapacityText,

      case when _Capacity.CapacityLastChangeDateTime is null then
           cast('20190101120000' as kap_lastchange_datetime)
      else _Capacity.CapacityLastChangeDateTime end                                 as CapacityLastChangeDateTime
}

Learn More