C_DefectOutputParameterFDP

DDL: C_DEFECTOUTPUTPARAMETERFDP Type: view_entity CONSUMPTION Package: ODATA_QM_DEFECT

Parameter for Defect (QM) Output

C_DefectOutputParameterFDP is a Consumption CDS View that provides data about "Parameter for Defect (QM) Output" in SAP S/4HANA. It reads from 1 data source (I_Defect) and exposes 10 fields with key field Defect. Part of development package ODATA_QM_DEFECT.

Data Sources (1)

SourceAliasJoin Type
I_Defect _Defect from

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Parameter for Defect (QM) Output view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.compositionRoot false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Defect Defect
DefectInternalID DefectInternalID Internal Defect ID
DefectCategory DefectCategory
DefectCodeGroup DefectCodeGroup Code Group
DefectCode DefectCode Damage Code
DefectCodeGroupAndCode
DefectClass DefectClass Defect Class
DefectLifecycleStatus DefectLifecycleStatus
Material Material Vehicle Model
Plant Plant Valuation Area

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 C_DefectOutputParameterFDP.
-- 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 C_DefectOutputParameterFDP AS
SELECT
  Defect,
  DefectInternalID,
  DefectCategory,
  DefectCodeGroup,
  DefectCode,
  cast( concat_with_space(_Defect.DefectCodeGroup, _Defect.DefectCode, 1) as qdefect_code_group_and_code preserving type ) AS DefectCodeGroupAndCode,
  DefectClass,
  DefectLifecycleStatus,
  Material,
  Plant
FROM I_Defect AS _Defect
;