C_QltyCertCustomerVH

DDL: C_QLTYCERTCUSTOMERVH SQL: CQCCUSTOMERVH Type: view CONSUMPTION
15 Fields 1 Data Sources 1 Associations

Quality Cert Customer Value Help

C_QltyCertCustomerVH is a Consumption CDS View that provides data about "Quality Cert Customer Value Help" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 15 fields with key field Customer. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_Customer Customer from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CountryText _Text $projection.Country = _Text.Country and _Text.Language = $session.system_language

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CQCCUSTOMERVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quality Cert Customer Value Help view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Customer view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer Sold-to Party
OrganizationBPName1 I_Customer OrganizationBPName1 Name 1
OrganizationBPName2 I_Customer OrganizationBPName2 Name 2
CustomerName I_Customer CustomerName Customer Name
Country I_Customer Country Venue: Ctry/Reg
CityName I_Customer CityName City
StreetName I_Customer StreetName Street
PostalCode I_Customer PostalCode Postal Code
EmailAddress Email Address
CustomerAccountGroup I_Customer CustomerAccountGroup Account group
AuthorizationGroup I_Customer AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_Customer IsBusinessPurposeCompleted Purpose Complete Flag
Language _Text Language Report Text Language
NationalityName _Text NationalityName
_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 C_QltyCertCustomerVH.
-- 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: CQCCUSTOMERVH

CREATE VIEW C_QltyCertCustomerVH AS
SELECT
  Customer.Customer AS Customer,
  Customer.OrganizationBPName1 AS OrganizationBPName1,
  Customer.OrganizationBPName2 AS OrganizationBPName2,
  Customer.CustomerName AS CustomerName,
  Customer.Country AS Country,
  Customer.CityName AS CityName,
  Customer.StreetName AS StreetName,
  Customer.PostalCode AS PostalCode,
  Customer._StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  Customer.CustomerAccountGroup AS CustomerAccountGroup,
  Customer.AuthorizationGroup AS AuthorizationGroup,
  Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Text.Language AS Language,
  _Text.NationalityName AS NationalityName
FROM I_Customer AS Customer
LEFT OUTER JOIN I_CountryText AS _Text ON Country = _Text.Country AND _Text.Language = $session.system_language  -- association [1..1]
;

Learn More