C_SchedProdnWrkCtrSqncVH

DDL: C_SCHEDPRODNWRKCTRSQNCVH SQL: CSHEDPDWCSQNCVH Type: view CONSUMPTION
12 Fields 1 Data Sources

Work Ctr Filter for dispatch by sequence

C_SchedProdnWrkCtrSqncVH is a Consumption CDS View that provides data about "Work Ctr Filter for dispatch by sequence" in SAP S/4HANA. It reads from 1 data source (I_SchedProdnWrkCtrSqncVH) and exposes 12 fields with key fields OrderID, OrderCategory, Product, Plant, ProductionVersion.

Data Sources (1)

SourceAliasJoin Type
I_SchedProdnWrkCtrSqncVH _WorkCenterSqnc from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CSHEDPDWCSQNCVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Work Ctr Filter for dispatch by sequence view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
AbapCatalog.preserveKey true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY OrderID OrderID Order ID
KEY OrderCategory OrderCategory Order Category
KEY Product Product Product Sold
KEY Plant I_SchedProdnWrkCtrSqncVH Plant Valuation Area
KEY ProductionVersion ProductionVersion Version ID
WorkCenter WorkCenter Work Center
WorkCenterInternalID I_SchedProdnWrkCtrSqncVH WorkCenterInternalID Work Center
WorkCenterDesc WorkCenterDesc Work Center Description
BOOExplosionDate BOOExplosionDate
BOMExplosionDate BOMExplosionDate
PlndOrderPlannedStartDate PlndOrderPlannedStartDate
PlndOrderPlannedEndDate PlndOrderPlannedEndDate

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_SchedProdnWrkCtrSqncVH.
-- 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: CSHEDPDWCSQNCVH

CREATE VIEW C_SchedProdnWrkCtrSqncVH AS
SELECT
  OrderID,
  OrderCategory,
  Product,
  _WorkCenterSqnc.Plant AS Plant,
  ProductionVersion,
  WorkCenter,
  _WorkCenterSqnc.WorkCenterInternalID AS WorkCenterInternalID,
  WorkCenterDesc,
  BOOExplosionDate,
  BOMExplosionDate,
  PlndOrderPlannedStartDate,
  PlndOrderPlannedEndDate
FROM I_SchedProdnWrkCtrSqncVH AS _WorkCenterSqnc
;

Learn More