I_SchedProdnWrkCtrAreaOfRespy

DDL: I_SCHEDPRODNWRKCTRAREAOFRESPY SQL: ISHPDWCAOR Type: view COMPOSITE
8 Fields 8 Data Sources

Work Centers By Area of Responsibilty

I_SchedProdnWrkCtrAreaOfRespy is a Composite CDS View that provides data about "Work Centers By Area of Responsibilty" in SAP S/4HANA. It reads from 8 data sources and exposes 8 fields with key fields WorkCenter, Plant.

Data Sources (8)

SourceAliasJoin Type
I_BOOMaterialAssgmtChangeState _MaterialTaskList inner
I_BOOSqncOperationAssgmtChgSt _OperationActivities inner
I_BillOfOperationsOpBasic _OperationActTasks inner
I_OperationControlProfile _OperationControlProfile inner
I_SchedProdnPlngDets _plngdets left_outer
P_ProductionVersion _ProductionVersions inner
I_ProductPlant _ProductPlant inner
P_WORKCENTERCATEGORYAPPL wcappl left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISHPDWCAOR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label Work Centers By Area of Responsibilty view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkCenter _WorkCenter WorkCenter Work Center
KEY Plant _WorkCenter Plant Valuation Area
WorkCenterInternalID _WorkCenter WorkCenterInternalID Work Center
WorkCenterTypeCode _WorkCenter WorkCenterTypeCode Object Type
CapacityInternalID _WorkCenter CapacityInternalID Capacity ID
CapacityResponsiblePlanner _Capacity CapacityResponsiblePlanner
WorkCenterResponsible _WorkCenter WorkCenterResponsible
WorkCenterDesc

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_SchedProdnWrkCtrAreaOfRespy.
-- 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: ISHPDWCAOR

CREATE VIEW I_SchedProdnWrkCtrAreaOfRespy AS
SELECT
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter.Plant AS Plant,
  _WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  _WorkCenter.WorkCenterTypeCode AS WorkCenterTypeCode,
  _WorkCenter.CapacityInternalID AS CapacityInternalID,
  _Capacity.CapacityResponsiblePlanner AS CapacityResponsiblePlanner,
  _WorkCenter.WorkCenterResponsible AS WorkCenterResponsible,
  _WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc
LEFT OUTER JOIN I_SchedProdnPlngDets AS _plngdets ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_WORKCENTERCATEGORYAPPL AS wcappl ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationControlProfile AS _OperationControlProfile ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillOfOperationsOpBasic AS _OperationActTasks ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS _OperationActivities ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOOMaterialAssgmtChangeState AS _MaterialTaskList ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProductionVersion AS _ProductionVersions ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductPlant AS _ProductPlant ON /* join condition not captured in parsed metadata */
;

Learn More