I_MfgQualifnWrkCtrAssgmtBasic

DDL: I_MFGQUALIFNWRKCTRASSGMTBASIC SQL: IQUALWCASSGMTBSC Type: view BASIC
11 Fields 1 Data Sources 1 Associations

Qualification Work Center Assignment

I_MfgQualifnWrkCtrAssgmtBasic is a Basic CDS View that provides data about "Qualification Work Center Assignment" in SAP S/4HANA. It reads from 1 data source (mpe_qual_e_wc) and exposes 11 fields with key fields MfgHumanResourceQualification, WorkCenterTypeCode, WorkCenterInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
mpe_qual_e_wc WorkCenterAssignment from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_WorkCenterBySemanticKey _WorkCenter $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IQUALWCASSGMTBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Qualification Work Center Assignment view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MfgHumanResourceQualification mfghumanresourcequalification Object ID
KEY WorkCenterTypeCode workcentertypecode Object Type
KEY WorkCenterInternalID workcenterinternalid Work Center
CreationDate creationdate Time Stamp
EndDate enddate Term to
MfgQualifnRequiredSkillLevel mfgqualifnrequiredskilllevel SkillLevel
CreatedByName created_by Version Created By
CreationDateTime created_at Uploaded On
ChangedByName changed_by User Name
LastChangeDateTime changed_at Timestamp
_WorkCenter _WorkCenter

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_MfgQualifnWrkCtrAssgmtBasic.
-- 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: IQUALWCASSGMTBSC

CREATE VIEW I_MfgQualifnWrkCtrAssgmtBasic AS
SELECT
  MfgHumanResourceQualification,
  WorkCenterTypeCode,
  WorkCenterInternalID,
  CreationDate,
  EndDate,
  MfgQualifnRequiredSkillLevel,
  created_by AS CreatedByName,
  created_at AS CreationDateTime,
  changed_by AS ChangedByName,
  changed_at AS LastChangeDateTime
FROM mpe_qual_e_wc AS WorkCenterAssignment
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode  -- association [1..1]
;

Learn More