I_FundedProgram

DDL: I_FUNDEDPROGRAM SQL: IFMFUNDEDPROG Type: view COMPOSITE Package: PSM_S4C_BASIS

Funded Program

I_FundedProgram is a Composite CDS View that provides data about "Funded Program" in SAP S/4HANA. It reads from 1 data source (I_FundedProgramBasic) and exposes 20 fields with key fields FinancialManagementArea, FundedProgram. It has 1 association to related views. Part of development package PSM_S4C_BASIS.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_FundedProgramBasic I_FundedProgramBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_FundedProgram _Extension $projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.FundedProgram = _Extension.FundedProgram

Annotations (14)

NameValueLevelField
EndUserText.label Funded Program view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey FundedProgram view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFMFUNDEDPROG view
AbapCatalog.preserveKey true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea
KEY FundedProgram FundedProgram
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
FundedProgramExpirationDate FundedProgramExpirationDate
FundedProgramAuthznGrp FundedProgramAuthznGrp Funded Program Authorization Group
FundedPgmFinMgmtAreaForAuthzn FundedPgmFinMgmtAreaForAuthzn
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
FundedProgramType FundedProgramType
_FinMgmtArea _FinMgmtArea
_Text _Text
_FundedProgramType _FundedProgramType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_FundedProgramHierarchyNode _FundedProgramHierarchyNode 
@EndUserText.label: 'Funded Program'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Analytics.internalName: #LOCAL
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser', '_FundedProgramHierarchyNode']
@ObjectModel.representativeKey: 'FundedProgram'
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE]
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #S
}
@Metadata.ignorePropagatedAnnotations:true
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IFMFUNDEDPROG'
@AbapCatalog.preserveKey: true
define view I_FundedProgram
  as select from I_FundedProgramBasic
  
    association [1..1] to E_FundedProgram as _Extension  //do not expose this association in the projection list of the view 

       on  $projection.FinancialManagementArea  = _Extension.FinancialManagementArea
       and $projection.FundedProgram            = _Extension.FundedProgram  

{
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_FinMgmtAreaStdVH',
                     element: 'FinancialManagementArea' }
        }]
      @ObjectModel.foreignKey.association: '_FinMgmtArea'
  key FinancialManagementArea,     
      @ObjectModel.text.association: '_Text' 
      @ObjectModel.hierarchy.association: '_FundedProgramHierarchyNode'
  key FundedProgram,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      @Semantics.businessDate.to: true
      ValidityEndDate,
      FundedProgramExpirationDate,
      @EndUserText.label: 'Funded Program Authorization Group'
      FundedProgramAuthznGrp,
      FundedPgmFinMgmtAreaForAuthzn,
      @Consumption.valueHelpDefinition: { entity: { name: 'I_BusinessUserVH', element: 'UserID' } }
      CreatedByUser,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      CreationTime,
      @Consumption.valueHelpDefinition: { entity: { name: 'I_BusinessUserVH', element: 'UserID' } }
      LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      LastChangeTime,
      @ObjectModel.foreignKey.association: '_FundedProgramType'
      FundedProgramType,

      _FinMgmtArea,
      _Text,
      _FundedProgramType,
      _CreatedByUser,
      _LastChangedByUser,
      _FundedProgramHierarchyNode      
}

Learn More