C_ProdnSupplyAreaWorkCenter

DDL: C_PRODNSUPPLYAREAWORKCENTER Type: view_entity CONSUMPTION Package: ODATA_PP_KAB_FIO_MANAGE_PSA
12 Fields 1 Data Sources 3 Associations 2 OData Services

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. It is exposed through 2 OData services (ASQL_F6935, UI_PRODSUPPLYAREA_MANAGE). Part of development package ODATA_PP_KAB_FIO_MANAGE_PSA.

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

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F6935 ASQL_F6935 C2 NOT_RELEASED
UI_PRODSUPPLYAREA_MANAGE UI_PRODSUPPLYAREA_MANAGE V4 C1 NOT_RELEASED

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center Description
KEY WorkCenterTypeCode WorkCenterTypeCode Object Type
WorkCenter WorkCenter Work Center
SupplyArea SupplyArea Supply Area
Plant Plant Valuation Area
WorkCenterCategoryCode WorkCenterCategoryCode Work Center Category
WorkCenterUsage WorkCenterUsage
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate Validity End Date
WorkCenterText _WorkCenterText WorkCenterText Work Center Text
WorkCenterCategoryName _WorkCenterCategoryText WorkCenterCategoryName
ProductionResourceUsageDesc _WorkCenterUsageText ProductionResourceUsageDesc

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProdnSupplyAreaWorkCenter.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_ProdnSupplyAreaWorkCenter AS
SELECT
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  SupplyArea,
  Plant,
  WorkCenterCategoryCode,
  WorkCenterUsage,
  ValidityStartDate,
  ValidityEndDate,
  _WorkCenterText.WorkCenterText AS WorkCenterText,
  _WorkCenterCategoryText.WorkCenterCategoryName AS WorkCenterCategoryName,
  _WorkCenterUsageText.ProductionResourceUsageDesc AS ProductionResourceUsageDesc
FROM I_WorkCenter
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode AND _WorkCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterCategoryText AS _WorkCenterCategoryText ON WorkCenterCategoryCode = _WorkCenterCategoryText.WorkCenterCategoryCode AND _WorkCenterCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductionResourceUsageText AS _WorkCenterUsageText ON WorkCenterUsage = _WorkCenterUsageText.ProductionResourceUsage AND _WorkCenterUsageText.Language = $session.system_language  -- association [0..1]
;

Learn More