C_ProdnSupplyAreaWorkCenter

DDL: C_PRODNSUPPLYAREAWORKCENTER Type: view_entity CONSUMPTION

Work Center of PSA Where Used

C_ProdnSupplyAreaWorkCenter is a Consumption CDS View that provides data about "Work Center of PSA Where Used" in SAP S/4HANA. It reads from 1 data source (I_WorkCenter) and exposes 12 fields with key fields WorkCenterInternalID, WorkCenterTypeCode. It has 3 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenter I_WorkCenter from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_WorkCenterText _WorkCenterText $projection.WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode and _WorkCenterText.Language = $session.system_language
[0..1] I_WorkCenterCategoryText _WorkCenterCategoryText $projection.WorkCenterCategoryCode = _WorkCenterCategoryText.WorkCenterCategoryCode and _WorkCenterCategoryText.Language = $session.system_language
[0..1] I_ProductionResourceUsageText _WorkCenterUsageText $projection.WorkCenterUsage = _WorkCenterUsageText.ProductionResourceUsage and _WorkCenterUsageText.Language = $session.system_language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Work Center of PSA Where Used view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center Description
KEY WorkCenterTypeCode WorkCenterTypeCode
WorkCenter WorkCenter
SupplyArea SupplyArea
Plant Plant
WorkCenterCategoryCode WorkCenterCategoryCode
WorkCenterUsage WorkCenterUsage
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate Validity End Date
WorkCenterText _WorkCenterText WorkCenterText
WorkCenterCategoryName _WorkCenterCategoryText WorkCenterCategoryName
ProductionResourceUsageDesc _WorkCenterUsageText ProductionResourceUsageDesc 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Work Center of PSA Where Used'

@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true

@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}
@Search.searchable:true
@ObjectModel: {
    semanticKey: ['SupplyArea', 'Plant', 'WorkCenterInternalID']
}
define view entity C_ProdnSupplyAreaWorkCenter
  as select from I_WorkCenter
  association [0..1] to I_WorkCenterText              as _WorkCenterText         on  $projection.WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID
                                                                                 and $projection.WorkCenterTypeCode   = _WorkCenterText.WorkCenterTypeCode
                                                                                 and _WorkCenterText.Language         = $session.system_language
  association [0..1] to I_WorkCenterCategoryText      as _WorkCenterCategoryText on  $projection.WorkCenterCategoryCode = _WorkCenterCategoryText.WorkCenterCategoryCode
                                                                                 and _WorkCenterCategoryText.Language   = $session.system_language
  association [0..1] to I_ProductionResourceUsageText as _WorkCenterUsageText    on  $projection.WorkCenterUsage   = _WorkCenterUsageText.ProductionResourceUsage
                                                                                 and _WorkCenterUsageText.Language = $session.system_language
{
      @Search.defaultSearchElement: true
      @EndUserText.label: 'Work Center Description'
      @ObjectModel.text.element: ['WorkCenterText']
  key WorkCenterInternalID,
  key WorkCenterTypeCode,

      @Search.defaultSearchElement: true
      WorkCenter,

      SupplyArea,
      Plant,

      @Search.defaultSearchElement: true
      @ObjectModel.text.element: ['WorkCenterCategoryName']
      WorkCenterCategoryCode,

      @Search.defaultSearchElement: true
      @ObjectModel.text.element: ['ProductionResourceUsageDesc']
      WorkCenterUsage,

      @EndUserText.label: 'Validity Start Date'
      ValidityStartDate,
      @EndUserText.label: 'Validity End Date'
      ValidityEndDate,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Semantics.text: true
      _WorkCenterText.WorkCenterText,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Semantics.text: true
      _WorkCenterCategoryText.WorkCenterCategoryName,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Semantics.text: true
      _WorkCenterUsageText.ProductionResourceUsageDesc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTIONRESOURCEUSAGETEXT",
"I_WORKCENTER",
"I_WORKCENTERCATEGORYTEXT",
"I_WORKCENTERTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More