I_SrvcDocQualification

DDL: I_SRVCDOCQUALIFICATION Type: view_entity BASIC

CRMS4 Qualification Details

I_SrvcDocQualification is a Basic CDS View that provides data about "CRMS4 Qualification Details" in SAP S/4HANA. It reads from 1 data source (crms4d_qualif) and exposes 9 fields with key fields ServiceOrder, ServiceObjectType, ServiceDocumentItem, SrvcDocQualification.

Data Sources (1)

SourceAliasJoin Type
crms4d_qualif crms4d_qualif from

Annotations (8)

NameValueLevelField
EndUserText.label CRMS4 Qualification Details view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ServiceOrder object_id Transaction ID
KEY ServiceObjectType objtype_h Trans. Cat.
KEY ServiceDocumentItem number_int Item Number in Doc.
KEY SrvcDocQualification objid Work Center
SrvcDocQualifnValdtyStrtDteTme validfrom Vers.Valid From
SrvcDocQualifnValdtyEndDteTme validto Vers.Valid To
SrvcDocQualifnIsMandatory obligatory Required
SrvcDocQualifnProficiencyValue prfcy_opt Optimum Qual.Reqment
SrvcDocQualifnWeightingValue weighing Weighting

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_SrvcDocQualification.
-- 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_SrvcDocQualification AS
SELECT
  object_id AS ServiceOrder,
  objtype_h AS ServiceObjectType,
  number_int AS ServiceDocumentItem,
  objid AS SrvcDocQualification,
  validfrom AS SrvcDocQualifnValdtyStrtDteTme,
  validto AS SrvcDocQualifnValdtyEndDteTme,
  obligatory AS SrvcDocQualifnIsMandatory,
  prfcy_opt AS SrvcDocQualifnProficiencyValue,
  weighing AS SrvcDocQualifnWeightingValue
FROM crms4d_qualif
;