C_BSOrdProcFlwEntProject

DDL: C_BSORDPROCFLWENTPROJECT Type: view CONSUMPTION

Customer Project Attrib for BSOrd Prgrs

C_BSOrdProcFlwEntProject is a Consumption CDS View that provides data about "Customer Project Attrib for BSOrd Prgrs" in SAP S/4HANA. It reads from 1 data source (I_EnterpriseProject) and exposes 10 fields with key field UI5NetworkGraphAttributeValue. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProject EntProject from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_PPM_ProjProcessingStsTxt _ProcessingStsTxt EntProject.ProcessingStatus = _ProcessingStsTxt.ProcessingStatus
[0..*] P_BusSolnOrdEntProjectFlwLvl2 _Level2 EntProject.Project = _Level2.PrecedingDocument
[0..1] P_BusSolnOrdSubsqntDocTypeText _DocumentType _DocumentType.UI5NetworkGraphDescription = 'CPMP' ---Extension
[1..1] E_PPM_Project _Extension EntProject.ProjectUUID = _Extension.ProjectUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CENTPRATTRIB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
EndUserText.label Customer Project Attrib for BSOrd Prgrs view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY UI5NetworkGraphAttributeValue I_EnterpriseProject Project
CreationDate
ProjectStartDate I_EnterpriseProject ProjectStartDate
ProjectEndDate I_EnterpriseProject ProjectEndDate
ProcessingStatus I_EnterpriseProject ProcessingStatus
UI5NetworkGraphStatus
UI5NetworkGraphStatusName
TotalNetAmount _Level2 TotalNetAmount
TransactionCurrency _Level2 TransactionCurrency
UI5NetworkGraphDescription
@AbapCatalog: {
    sqlViewName:            'CENTPRATTRIB',
    compiler.compareFilter: true,
    preserveKey:            true
}

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
    dataClass:      #MIXED,
    serviceQuality: #C,
    sizeCategory:   #XL
}

@VDM: {
    viewType: #CONSUMPTION
}

@EndUserText.label: 'Customer Project Attrib for BSOrd Prgrs'
define view C_BSOrdProcFlwEntProject
  as select from I_EnterpriseProject as EntProject
  
  association [0..1] to I_PPM_ProjProcessingStsTxt as _ProcessingStsTxt  on EntProject.ProcessingStatus = _ProcessingStsTxt.ProcessingStatus
  
  association [0..*] to P_BusSolnOrdEntProjectFlwLvl2 as _Level2         on EntProject.Project = _Level2.PrecedingDocument
   
  association [0..1] to P_BusSolnOrdSubsqntDocTypeText as _DocumentType  on _DocumentType.UI5NetworkGraphDescription = 'CPMP'
  
  ---Extension Association
  association [1..1] to E_PPM_Project                 as _Extension  on  EntProject.ProjectUUID = _Extension.ProjectUUID  
{
  key EntProject.Project                                                                               as UI5NetworkGraphAttributeValue,
      cast(substring(cast(EntProject.CreationDateTime as abap.char(32)),1,8) as abap.dats)             as CreationDate,
      EntProject.ProjectStartDate,
      EntProject.ProjectEndDate,
      EntProject.ProcessingStatus,
      cast( EntProject.ProcessingStatus as fac_network_graph_status )                                 as UI5NetworkGraphStatus,
      _ProcessingStsTxt[1: LanguageCode = $session.system_language].ProcessingStatusText              as UI5NetworkGraphStatusName,
      
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _Level2.TotalNetAmount,
      _Level2.TransactionCurrency,
      @Semantics.text: true
      _DocumentType[1: Language = $session.system_language].UI5NetworkGraphDescriptionName  as UI5NetworkGraphDescription

}