P_ProductsByWorkCenter

DDL: P_PRODUCTSBYWORKCENTER SQL: PPRODBYWRKCNTR Type: view COMPOSITE
13 Fields 3 Data Sources

P_ProductsByWorkCenter is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_ProductPlant, I_BOOMaterialAssignment, I_BillOfOperationsOpBasic) and exposes 13 fields with key fields Material, WorkCenterInternalID, WorkCenterTypeCode.

Data Sources (3)

SourceAliasJoin Type
I_ProductPlant _Product inner
I_BOOMaterialAssignment _ProductAssign inner
I_BillOfOperationsOpBasic _Route inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPRODBYWRKCNTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Material I_BOOMaterialAssignment Material Vehicle Model
KEY WorkCenterInternalID _WorkCenter WorkCenterInternalID Work Center
KEY WorkCenterTypeCode _WorkCenter WorkCenterTypeCode Object Type
Plant _WorkCenter Plant Valuation Area
WorkCenter _WorkCenter WorkCenter Work Center
WorkCenterCategoryCode _WorkCenter WorkCenterCategoryCode
WorkCenterText
WorkCenterResponsible WorkCenterResponsible
WorkCenterIsToBeDeleted _WorkCenter WorkCenterIsToBeDeleted
AdvancedPlanningIsSupported _WorkCenter AdvancedPlanningIsSupported
CapacityInternalID _Capacity CapacityInternalID Capacity ID
CapacityIsFinite _Capacity CapacityIsFinite
PlantName

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 P_ProductsByWorkCenter.
-- 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: PPRODBYWRKCNTR

CREATE VIEW P_ProductsByWorkCenter AS
SELECT
  _ProductAssign.Material AS Material,
  _WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  _WorkCenter.WorkCenterTypeCode AS WorkCenterTypeCode,
  _WorkCenter.Plant AS Plant,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  _WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  WorkCenterResponsible,
  _WorkCenter.WorkCenterIsToBeDeleted AS WorkCenterIsToBeDeleted,
  _WorkCenter.AdvancedPlanningIsSupported AS AdvancedPlanningIsSupported,
  _Capacity.CapacityInternalID AS CapacityInternalID,
  _Capacity.CapacityIsFinite AS CapacityIsFinite,
  _WorkCenter._Plant.PlantName AS PlantName
INNER JOIN I_BillOfOperationsOpBasic AS _Route ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOOMaterialAssignment AS _ProductAssign ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductPlant AS _Product ON /* join condition not captured in parsed metadata */
;

Learn More