I_DefectCodeStdVH

DDL: I_DEFECTCODESTDVH SQL: IDC__VH Type: view COMPOSITE
7 Fields 1 Data Sources

Defect Code

I_DefectCodeStdVH (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_DefectCodeStdVH is a Composite CDS View that provides data about "Defect Code" in SAP S/4HANA. It reads from 1 data source (I_DefectCode) and exposes 7 fields with key fields DefectCodeGroup, DefectCode.

SAP Help Documentation

CategoryCDS Views for Quality Improvement
StatusReleased
Purpose
This view provides value help for defect codes. This view should be used for value help purposes only. If you intend to select the entire business data, use the Defect Code view instead.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentQM-QN
CapabilitiesData Provider for Value Help
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This view provides value help for defect codes. This view should be used for value help purposes only. If you intend to select the entire business data, use the Defect Code view instead.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_DefectCode I_DefectCode from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IDC__VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey DefectCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Defect Code view
Search.searchable true view
Consumption.ranked true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY DefectCodeGroup DefectCodeGroup Defect Code Group
KEY DefectCode DefectCode Damage Code
DefectCodeText Text for Defect Code
CodeIsInactive CodeIsInactive Inactive Indicator
DefectCodeGroupAndCode Defect Code Group and Code
_Text _Text
_DefectCodeGroup _DefectCodeGroup

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_DefectCodeStdVH.
-- 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: IDC__VH

CREATE VIEW I_DefectCodeStdVH AS
SELECT
  DefectCodeGroup,
  DefectCode,
  _Text[ 1:Language = $session.system_language ].DefectCodeText AS DefectCodeText,
  CodeIsInactive,
  cast( concat_with_space( DefectCodeGroup, DefectCode, 1) as qdefect_code_group_and_code preserving type ) AS DefectCodeGroupAndCode
FROM I_DefectCode
;

Learn More