I_PPM_MilestoneApprovalStatus

DDL: I_PPM_MILESTONEAPPROVALSTATUS SQL: IPPMMSTAPPRVLSTS Type: view BASIC

Milestone Approval Status

I_PPM_MilestoneApprovalStatus is a Basic CDS View that provides data about "Milestone Approval Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field MilestoneApprovalStatus. It has 1 association to related views.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[1] I_PPM_MilestoneApprovalStsText _Text $projection.MilestoneApprovalStatus = _Text.MilestoneApprovalStatus and _Text.Language = $session.system_language

Annotations (13)

NameValueLevelField
EndUserText.label Milestone Approval Status view
AbapCatalog.sqlViewName IPPMMSTAPPRVLSTS view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey MilestoneApprovalStatus view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.dataCategory #VALUE_HELP view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MilestoneApprovalStatus
_Text _Text 
@EndUserText.label: 'Milestone Approval Status'
@AbapCatalog.sqlViewName: 'IPPMMSTAPPRVLSTS'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl: {
    authorizationCheck:     #NOT_REQUIRED  
}

@ObjectModel:
{
   resultSet.sizeCategory: #XS, //Value help in Project Brief

   representativeKey: 'MilestoneApprovalStatus',
   usageType: 
   {
      serviceQuality: #B,
      dataClass: #MASTER,
      sizeCategory:   #S
   }   
}
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API
@ObjectModel.dataCategory: #VALUE_HELP

define view I_PPM_MilestoneApprovalStatus as select from dd07l 
  association [1] to I_PPM_MilestoneApprovalStsText as _Text on $projection.MilestoneApprovalStatus = _Text.MilestoneApprovalStatus
                                                 and _Text.Language = $session.system_language 

{
  //dd07l 

  @ObjectModel.text.association: '_Text'
  key cast ( substring( domvalue_l, 1, 5 ) as /s4ppm/tv_mlstn_apprvl_status ) as MilestoneApprovalStatus,

  _Text
} where
      domname  = '/S4PPM/MLSTN_APPRVL_STATUS'
  and as4local = 'A' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_PPM_MILESTONEAPPROVALSTSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More