C_ManageWrkCtrGrpWorkCenterVH

DDL: C_MANAGEWRKCTRGRPWORKCENTERVH Type: view_entity CONSUMPTION Package: ODATA_PP_WORKCENTER_GROUP
5 Fields 2 Data Sources 1 OData Services

Consumption View for Work Center VH

C_ManageWrkCtrGrpWorkCenterVH is a Consumption CDS View that provides data about "Consumption View for Work Center VH" in SAP S/4HANA. It reads from 2 data sources (P_ProductionVersion, I_WorkCenterText) and exposes 5 fields with key fields WorkCenter, Plant, WorkCenterInternalID. It is exposed through 1 OData service (ASQL_F5381). Part of development package ODATA_PP_WORKCENTER_GROUP.

Data Sources (2)

SourceAliasJoin Type
P_ProductionVersion _ProductionVersion left_outer
I_WorkCenterText _WorkCenterText left_outer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View for Work Center VH view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F5381 ASQL_F5381 C2 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY WorkCenter _WorkCenter WorkCenter Work Center
KEY Plant _WorkCenter Plant Plant
KEY WorkCenterInternalID _WorkCenter WorkCenterInternalID Work Center
WorkCenterText I_WorkCenterText WorkCenterText Work Center Description
WorkCenterResponsible _WorkCenter WorkCenterResponsible Person Responsible

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_ManageWrkCtrGrpWorkCenterVH.
-- 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_ManageWrkCtrGrpWorkCenterVH AS
SELECT
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter.Plant AS Plant,
  _WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  _WorkCenterText.WorkCenterText AS WorkCenterText,
  _WorkCenter.WorkCenterResponsible AS WorkCenterResponsible
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ProductionVersion AS _ProductionVersion ON /* join condition not captured in parsed metadata */
;

Learn More