I_QltyProcmtCertStatusT

DDL: I_QLTYPROCMTCERTSTATUST SQL: IQLTYPRCTCRTSTST Type: view BASIC

Quality Certificate Status Text

I_QltyProcmtCertStatusT is a Basic CDS View that provides data about "Quality Certificate Status Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields Language, QltyProcmtCertStatus. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_QltyProcmtCertStatus _QltyProcmtCertStatus $projection.QltyProcmtCertStatus = _QltyProcmtCertStatus.QltyProcmtCertStatus
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (9)

NameValueLevelField
EndUserText.label Quality Certificate Status Text view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey QltyProcmtCertStatus view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.sqlViewName IQLTYPRCTCRTSTST view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language ddlanguage
KEY QltyProcmtCertStatus
QltyProcmtCertStatusText
_QltyProcmtCertStatus _QltyProcmtCertStatus
_Language _Language 
@EndUserText.label: 'Quality Certificate Status Text'
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'QltyProcmtCertStatus'
@ObjectModel.usageType.dataClass: #META 
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@AbapCatalog.sqlViewName: 'IQLTYPRCTCRTSTST'
@VDM.viewType: #BASIC

define view I_QltyProcmtCertStatusT as select from dd07t  
    association [0..1] to I_QltyProcmtCertStatus as _QltyProcmtCertStatus on $projection.QltyProcmtCertStatus = _QltyProcmtCertStatus.QltyProcmtCertStatus
    association [0..1] to I_Language             as _Language             on $projection.Language = _Language.Language  
  {
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key ddlanguage as Language,
    key cast ( substring( domvalue_l, 1, 1 ) as vdm_qcstatus ) as QltyProcmtCertStatus,
    @Semantics.text: true
    cast(dd07t.ddtext as vdm_qcstatus_text preserving type ) as  QltyProcmtCertStatusText,
    _QltyProcmtCertStatus,
    _Language
  
}where dd07t.domname = 'QCSTATUS' and dd07t.as4local = 'A' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_QLTYPROCMTCERTSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More