A_SrvcOrdQualification

DDL: A_SRVCORDQUALIFICATION Type: view_entity CONSUMPTION
7 Fields 2 Data Sources 1 Associations

Srvc Order Header Qualification Details

A_SrvcOrdQualification is a Consumption CDS View that provides data about "Srvc Order Header Qualification Details" in SAP S/4HANA. It reads from 2 data sources (I_SrvcDocQualification, I_ServiceDocumentEnhcd) and exposes 7 fields with key fields ServiceOrder, SrvcDocQualification. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_SrvcDocQualification Qualification from
I_ServiceDocumentEnhcd ServiceOrder inner

Associations (1)

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

Annotations (11)

NameValueLevelField
EndUserText.label Srvc Order Header Qualification Details view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION 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 (7)

KeyFieldSource TableSource FieldDescription
KEY ServiceOrder I_ServiceDocumentEnhcd ServiceDocument Transaction ID
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_SrvcOrdQualification.
-- 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_SrvcOrdQualification AS
SELECT
  ServiceOrder.ServiceDocument AS ServiceOrder,
  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_ServiceDocumentEnhcd AS ServiceOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_ServiceOrder AS _ServiceOrder ON ServiceOrder = _ServiceOrder.ServiceOrder  -- association [1..1]
;

Learn More