I_DFS_ObjToWrkCtrRelshpDEX

DDL: I_DFS_OBJTOWRKCTRRELSHPDEX Type: view_entity COMPOSITE
19 Fields 1 Data Sources

Defense Workcenter Extractor

I_DFS_ObjToWrkCtrRelshpDEX (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Work Center · Cross Applications

I_DFS_ObjToWrkCtrRelshpDEX is a Composite CDS View (Dimension) that provides data about "Defense Workcenter Extractor" in SAP S/4HANA. It reads from 1 data source (I_WorkCenter) and exposes 19 fields with key fields WorkCenterInternalID, WorkCenterTypeCode.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-DFS-PM-MNT
CapabilitiesAnalytical Dimension, Data Source for Data Extraction, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_WorkCenter I_WorkCenter from

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Defense Workcenter Extractor view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.representativeKey WorkCenterInternalID view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name WorkCenter view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Object ID of the resource
KEY WorkCenterTypeCode WorkCenterTypeCode Object types of the CIM resource
WorkCenter WorkCenter Work Center
PlanVersion PlanVersion Plan Version
ForceElementOrgID WrkCtrHumRsceObjID Human Resource Object ID
WorkCenterLastChangedBy WorkCenterLastChangedBy User Name
WorkCenterLastChangeDateTime WorkCenterLastChangeDateTime Date and Time of Last Change
WorkCenterCategoryCode WorkCenterCategoryCode Work Center Category
WorkCenterLocation WorkCenterLocation Work center location
WorkCenterResponsible WorkCenterResponsible Person Responsible for the Work Center
Plant Plant Valuation Area
MachineType MachineType Machine Type
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate Valid-To Date
EmployeeSuitability EmployeeSuitability Employee Suitability
ControllingArea _WorkCenterCostCenter ControllingArea Controlling Area
CostCenter _WorkCenterCostCenter CostCenter Cost Center
FactoryCalendar _Capacity FactoryCalendar Factory Calendar ID
_WorkCenterType _WorkCenterType

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_DFS_ObjToWrkCtrRelshpDEX.
-- 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 I_DFS_ObjToWrkCtrRelshpDEX AS
SELECT
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  PlanVersion,
  WrkCtrHumRsceObjID AS ForceElementOrgID,
  WorkCenterLastChangedBy,
  WorkCenterLastChangeDateTime,
  WorkCenterCategoryCode,
  WorkCenterLocation,
  WorkCenterResponsible,
  Plant,
  MachineType,
  ValidityStartDate,
  ValidityEndDate,
  EmployeeSuitability,
  _WorkCenterCostCenter.ControllingArea AS ControllingArea,
  _WorkCenterCostCenter.CostCenter AS CostCenter,
  _Capacity.FactoryCalendar AS FactoryCalendar
FROM I_WorkCenter
;

Learn More