I_FundedProgram

DDL: I_FUNDEDPROGRAM SQL: IFMFUNDEDPROG Type: view COMPOSITE

Funded Program

I_FundedProgram is a Composite CDS View (Dimension) 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.

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 (18)

NameValueLevelField
EndUserText.label Funded Program view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey FundedProgram view
Analytics.dataCategory #DIMENSION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFMFUNDEDPROG view
Metadata.allowExtensions true view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name FundedProgram view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea
KEY FundedProgram FundedProgram
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
FundedProgramExpirationDate FundedProgramExpirationDate
FundedProgramAuthznGrp FundedProgramAuthznGrp
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: #MANDATORY
@AccessControl.privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser', '_FundedProgramHierarchyNode']
@ObjectModel.representativeKey: 'FundedProgram'
@Analytics.dataCategory: #DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE,#EXTRACTION_DATA_SOURCE]
@ObjectModel: {
    usageType: {
      dataClass: #MASTER,
      serviceQuality: #A,
      sizeCategory: #S
    },
    modelingPattern: #ANALYTICAL_DIMENSION
}
@Metadata.ignorePropagatedAnnotations:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IFMFUNDEDPROG'
@Metadata.allowExtensions:true
@Analytics.dataExtraction: {enabled:true}
@ObjectModel.sapObjectNodeType.name:'FundedProgram'
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,
      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