A_SrvcOrdItemQualification

DDL: A_SRVCORDITEMQUALIFICATION Type: view_entity COMPOSITE
8 Fields 2 Data Sources 1 Associations

Srvc Order Item Qualification Details

A_SrvcOrdItemQualification is a Composite CDS View that provides data about "Srvc Order Item Qualification Details" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentItemEnhcd, I_SrvcDocQualification) and exposes 8 fields with key fields ServiceOrder, ServiceDocumentItem, SrvcDocQualification. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd _ServiceOrderItemEnhcd inner
I_SrvcDocQualification Qualification from

Associations (1)

CardinalityTargetAliasCondition
[1] A_ServiceOrder _ServiceOrder $projection.ServiceOrder = _ServiceOrder.ServiceOrder

Annotations (11)

NameValueLevelField
EndUserText.label Srvc Order Item Qualification Details view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ServiceOrder I_SrvcDocQualification ServiceOrder Transaction ID
KEY ServiceDocumentItem I_SrvcDocQualification ServiceDocumentItem Service Document
KEY SrvcDocQualification I_SrvcDocQualification SrvcDocQualification Work Center
SrvcDocQualifnValdtyStrtDteTme I_SrvcDocQualification SrvcDocQualifnValdtyStrtDteTme Vers.Valid From
SrvcDocQualifnValdtyEndDteTme I_SrvcDocQualification SrvcDocQualifnValdtyEndDteTme Vers.Valid To
SrvcDocQualifnIsMandatory I_SrvcDocQualification SrvcDocQualifnIsMandatory Required
SrvcDocQualifnProficiencyValue I_SrvcDocQualification SrvcDocQualifnProficiencyValue Optimum Qual.Reqment
_ServiceOrder _ServiceOrder

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 A_SrvcOrdItemQualification.
-- 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 A_SrvcOrdItemQualification AS
SELECT
  Qualification.ServiceOrder AS ServiceOrder,
  Qualification.ServiceDocumentItem AS ServiceDocumentItem,
  Qualification.SrvcDocQualification AS SrvcDocQualification,
  Qualification.SrvcDocQualifnValdtyStrtDteTme AS SrvcDocQualifnValdtyStrtDteTme,
  Qualification.SrvcDocQualifnValdtyEndDteTme AS SrvcDocQualifnValdtyEndDteTme,
  Qualification.SrvcDocQualifnIsMandatory AS SrvcDocQualifnIsMandatory,
  Qualification.SrvcDocQualifnProficiencyValue AS SrvcDocQualifnProficiencyValue
FROM I_SrvcDocQualification AS Qualification
INNER JOIN I_ServiceDocumentItemEnhcd AS _ServiceOrderItemEnhcd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_ServiceOrder AS _ServiceOrder ON ServiceOrder = _ServiceOrder.ServiceOrder  -- association [1]
;

Learn More