I_MaintenanceWorkCenterOrgUnit

DDL: I_MAINTENANCEWORKCENTERORGUNIT SQL: IMTWKCTRORG Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Work Center-to-Org Unit Assignment

I_MaintenanceWorkCenterOrgUnit is a Basic CDS View that provides data about "Work Center-to-Org Unit Assignment" in SAP S/4HANA. It reads from 1 data source (crhd) and exposes 8 fields with key fields WorkCenterInternalID, WorkCenterTypeCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
crhd crhd from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_OrgUnit _OrganizationalUnit $projection.OrganizationalUnit = _OrganizationalUnit.OrganizationalUnit

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMTWKCTRORG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Center-to-Org Unit Assignment view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID crhd objid Work Center
KEY WorkCenterTypeCode crhd objty Prj. Obj. Type
WorkCenter crhd arbpl Work Center
Plant crhd werks Receiving Plant
OrganizationObjType crhd hrtyp Object type
OrganizationalUnit crhd hroid Object ID
PlanVersion crhd hrplvar Plan version
_OrganizationalUnit _OrganizationalUnit

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_MaintenanceWorkCenterOrgUnit.
-- 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: IMTWKCTRORG

CREATE VIEW I_MaintenanceWorkCenterOrgUnit AS
SELECT
  crhd.objid AS WorkCenterInternalID,
  crhd.objty AS WorkCenterTypeCode,
  crhd.arbpl AS WorkCenter,
  crhd.werks AS Plant,
  crhd.hrtyp AS OrganizationObjType,
  crhd.hroid AS OrganizationalUnit,
  crhd.hrplvar AS PlanVersion
FROM crhd
LEFT OUTER JOIN I_OrgUnit AS _OrganizationalUnit ON OrganizationalUnit = _OrganizationalUnit.OrganizationalUnit  -- association [0..1]
;

Learn More