I_BudgetPeriod

DDL: I_BUDGETPERIOD SQL: IBUDGETPERIOD Type: view COMPOSITE

Budget Period

I_BudgetPeriod is a Composite CDS View (Dimension) that provides data about "Budget Period" in SAP S/4HANA. It reads from 1 data source (I_BudgetPeriodBasic) and exposes 17 fields with key field BudgetPeriod. It has 1 association to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_BudgetPeriodBasic I_BudgetPeriodBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_BudgetPeriod _Extension $projection.BudgetPeriod = _Extension.BudgetPeriod

Annotations (17)

NameValueLevelField
EndUserText.label Budget Period view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey BudgetPeriod view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IBUDGETPERIOD view
AbapCatalog.preserveKey true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BudgetPeriod BudgetPeriod
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
BudgetPeriodExpirationDate BudgetPeriodExpirationDate
BudgetPeriodReversalDate BudgetPeriodReversalDate
BudgetPeriodAuthznGrp BudgetPeriodAuthznGrp
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangeUser LastChangeUser
LastChangeDate LastChangeDate
BudgetPeriodPeriodicity BudgetPeriodPeriodicity
_FundPeriodicity _FundPeriodicity
_Text _Text
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_BudgetPeriodHierarchyNode _BudgetPeriodHierarchyNode
_FundToBudgetPeriod _FundToBudgetPeriod 
@EndUserText.label: 'Budget Period'
@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true, internalName: #LOCAL }
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser']
@ObjectModel.representativeKey: 'BudgetPeriod'
@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
}
@Metadata.ignorePropagatedAnnotations:true
@Metadata.allowExtensions:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IBUDGETPERIOD'
@AbapCatalog.preserveKey: true
define view I_BudgetPeriod
  as select from I_BudgetPeriodBasic
 
    association [1..1] to E_BudgetPeriod as _Extension  //do not expose this association in the projection list of the view 

       on  $projection.BudgetPeriod  = _Extension.BudgetPeriod 
 
{
      @ObjectModel.text.association: '_Text'
      @ObjectModel.hierarchy.association: '_BudgetPeriodHierarchyNode'
  key BudgetPeriod,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      @Semantics.businessDate.to: true
      ValidityEndDate,
      BudgetPeriodExpirationDate,
      BudgetPeriodReversalDate,
      BudgetPeriodAuthznGrp,
      @Consumption.valueHelpDefinition: { entity: { name: 'I_BusinessUserVH', element: 'UserID' } }
      CreatedByUser,
//      @ObjectModel.readOnly: true --> leads to ATC error


      @Semantics.systemDate.createdAt: true
      CreationDate,
//      @ObjectModel.readOnly: true --> leads to ATC error


      @Consumption.valueHelpDefinition: { entity: { name: 'I_BusinessUserVH', element: 'UserID' } }
      LastChangeUser,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_FundPeriodicity',
                     element: 'FundPeriodicity' }
        }]
      @ObjectModel.foreignKey.association: '_FundPeriodicity'
      BudgetPeriodPeriodicity,

      _FundPeriodicity,
      _Text,
      _CreatedByUser,
      _LastChangedByUser,
      _BudgetPeriodHierarchyNode,
      _FundToBudgetPeriod
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUDGETPERIODBASIC"
],
"ASSOCIATED":
[
"E_BUDGETPERIOD",
"I_BUDGETPERIODHIERARCHYNODE",
"I_BUDGETPERIODTEXT",
"I_FUNDPERIODICITY",
"I_FUNDTOBUDGETPERIOD",
"I_USER"
],
"BASE":
[
"I_BUDGETPERIODBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More