I_PPS_FedSystApprvlStatusText

DDL: I_PPS_FEDSYSTAPPRVLSTATUSTEXT Type: view_entity BASIC

Federal System Approval Status - Text

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

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PPS_FedSystApprvlStatusVH _FedSystApprvlStatus $projection.PPSFedSystStatus = _FedSystApprvlStatus.PPSFedSystStatus
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Federal System Approval Status - Text view
ObjectModel.dataCategory #TEXT view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PPSFedSystStatus
KEY Language
DomainText ddtext
_FedSystApprvlStatus _FedSystApprvlStatus
_Language _Language
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Federal System Approval Status - Text'
@ObjectModel.dataCategory: #TEXT
//@ObjectModel.representativeKey: 'PPSFedSystStatus'

@Metadata.ignorePropagatedAnnotations: true
//@Analytics.technicalName: 'FEDSYSAPPRSTSQ2'

@VDM: {
lifecycle.contract.type: #SAP_INTERNAL_API,
viewType: #BASIC }
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MASTER
}
define view entity I_PPS_FedSystApprvlStatusText as select from dd07t

association [1..1] to I_PPS_FedSystApprvlStatusVH as _FedSystApprvlStatus on $projection.PPSFedSystStatus = _FedSystApprvlStatus.PPSFedSystStatus
 
  association [0..1] to I_Language                      as _Language         on $projection.Language = _Language.Language

{
@ObjectModel.foreignKey.association: '_FedSystApprvlStatus'
      @ObjectModel.text.element: ['DomainText']
  key cast ( dd07t.domvalue_l as pps_e_apprvl_sts )      as PPSFedSystStatus,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key cast( dd07t.ddlanguage as spras preserving type ) as Language,
      @Semantics.text: true
      ddtext                                            as DomainText,
      _FedSystApprvlStatus,
      _Language
}
where
  domname = 'PPS_D_PUBPS_STS'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_PPS_FEDSYSTAPPRVLSTATUSVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/