I_DefectCodeStdVH

DDL: I_DEFECTCODESTDVH Type: view_entity COMPOSITE Package: VDM_QM_NOTIFICATION
9 Fields 1 Data Sources 5 OData Services

Defect Code

I_DefectCodeStdVH (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public 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 9 fields with key fields DefectCodeGroup, DefectCode. It is exposed through 5 OData services (ASQL_F1685A, ASQL_F2219, ASQL_F2649, ...). Part of development package VDM_QM_NOTIFICATION.

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

CategoryComposite
StateC1
Line of BusinessManufacturing
Application ComponentQM-QN-2CL
CapabilitiesData Provider for Value Help
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageManufacturing for SAP S/4HANA Cloud Public 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 (14)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
ObjectModel.dataCategory #VALUE_HELP view
Analytics.technicalName IDC__VH view
ObjectModel.representativeKey DefectCode view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Defect Code view
Search.searchable true view
Consumption.ranked true view

OData Services (5)

ServiceBindingVersionContractRelease
ASQL_F1685A ASQL_F1685A C2 NOT_RELEASED
ASQL_F2219 ASQL_F2219 C2 NOT_RELEASED
ASQL_F2649 ASQL_F2649 C2 NOT_RELEASED
ASQL_F2914 ASQL_F2914 C2 NOT_RELEASED
ASQL_F4197 ASQL_F4197 C2 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DefectCodeGroup DefectCodeGroup Defect Code Group
KEY DefectCode DefectCode Damage Code
DefectCodeText Text for Defect Code
DefectCodeGroupText Text for Defect Code Group
CodeIsInactive CodeIsInactive Inactive Indicator
DefectCodeGroupAndCode Defect Code Group and Code
_Text _Text
CodeGroupStatus CodeGroupStatus Status of Master Record
_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.

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

Learn More