I_WrkCtrBySemanticKeyVH

DDL: I_WRKCTRBYSEMANTICKEYVH SQL: IWCBSK__VH1 Type: view_entity COMPOSITE Package: VDM_PP_MD_WKC
25 Fields 1 Data Sources

Work Center by Semantic Key

I_WrkCtrBySemanticKeyVH is a Composite CDS View that provides data about "Work Center by Semantic Key" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterBySemanticKey) and exposes 25 fields with key fields Plant, WorkCenter. Part of development package VDM_PP_MD_WKC.

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterBySemanticKey I_WorkCenterBySemanticKey from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey WorkCenter view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #COMPOSITE view
EndUserText.label Work Center by Semantic Key view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Plant Plant Valuation Area
KEY WorkCenter WorkCenter Work Center
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
WorkCenterIsToBeDeleted WorkCenterIsToBeDeleted
WorkCenterCategoryCode WorkCenterCategoryCode
WorkCenterLocation WorkCenterLocation
WorkCenterLocationGroup WorkCenterLocationGroup
WorkCenterUsage WorkCenterUsage
WorkCenterResponsible WorkCenterResponsible
MachineType MachineType
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
_Plant _Plant
_WorkCenterType _WorkCenterType
_WorkCenterResponsible _WorkCenterResponsible
_WorkCenterCategory _WorkCenterCategory
_WorkCenterLocation _WorkCenterLocation
_WorkCenterLocationGroup _WorkCenterLocationGroup
_WorkCenterUsage _WorkCenterUsage
_Text _Text
_WorkCenterTextBySemanticKey _WorkCenterTextBySemanticKey
_MachineType _MachineType
_ValidityStartDate _ValidityStartDate
_ValidityEndDate _ValidityEndDate

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 I_WrkCtrBySemanticKeyVH.
-- 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.
-- SQL view name: IWCBSK__VH1

CREATE VIEW I_WrkCtrBySemanticKeyVH AS
SELECT
  Plant,
  WorkCenter,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenterIsToBeDeleted,
  WorkCenterCategoryCode,
  WorkCenterLocation,
  WorkCenterLocationGroup,
  WorkCenterUsage,
  WorkCenterResponsible,
  MachineType,
  ValidityStartDate,
  ValidityEndDate
FROM I_WorkCenterBySemanticKey
;

Learn More