I_CharcAttributeCodeGrp

DDL: I_CHARCATTRIBUTECODEGRP SQL: ICHRCATTRBTCDGRP Type: view BASIC
7 Fields 1 Data Sources 1 Associations

Characteristic Attribute Code Group

I_CharcAttributeCodeGrp (Basic)

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

Manufacturing

I_CharcAttributeCodeGrp is a Basic CDS View that provides data about "Characteristic Attribute Code Group" in SAP S/4HANA. It reads from 1 data source (qpgr) and exposes 7 fields with key field CharacteristicAttributeCodeGrp. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentQM-IM
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>The purpose of this CDS view is the definition of code groups for selected sets (catalog 1).</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
qpgr qpgr from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CharcAttributeCodeGrpText _Text $projection.CharacteristicAttributeCodeGrp = _Text.CharacteristicAttributeCodeGrp

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICHRCATTRBTCDGRP view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Characteristic Attribute Code Group view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey CharacteristicAttributeCodeGrp view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CharacteristicAttributeCodeGrp qpgr codegruppe Code Group
CodeGroupStatus qpgr status Status of Master Record
CharcAttribCodeGroupCrtedBy qpgr ersteller Name of User Who Created the Data Record
CharcAttribCodeGroupCrtedOn qpgr e_datum System Date on Which Data Record Was Created
CharcAttribCodeGroupLastChgdBy qpgr aenderer Name of User Who Last Changed Data Record
CharcAttribCodeGroupLastChgdOn qpgr a_datum System Date on Which Data Record Was Changed
_Text _Text

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_CharcAttributeCodeGrp.
-- 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: ICHRCATTRBTCDGRP

CREATE VIEW I_CharcAttributeCodeGrp AS
SELECT
  qpgr.codegruppe AS CharacteristicAttributeCodeGrp,
  qpgr.status AS CodeGroupStatus,
  qpgr.ersteller AS CharcAttribCodeGroupCrtedBy,
  qpgr.e_datum AS CharcAttribCodeGroupCrtedOn,
  qpgr.aenderer AS CharcAttribCodeGroupLastChgdBy,
  qpgr.a_datum AS CharcAttribCodeGroupLastChgdOn
FROM qpgr
LEFT OUTER JOIN I_CharcAttributeCodeGrpText AS _Text ON CharacteristicAttributeCodeGrp = _Text.CharacteristicAttributeCodeGrp  -- association [0..*]
;

Learn More