I_BUDGETPERIOD

CDS View

Budget Period

I_BUDGETPERIOD is a CDS View in S/4HANA. Budget Period. It contains 12 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 12 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_BudgetPeriod_ObjP view from CONSUMPTION Additional Selection - Budget Period
ESH_N_BDGTPER view from
I_BudgetPeriodCoreTP view from TRANSACTIONAL Manage Budget Period
I_BudgetPeriodStdVH view from COMPOSITE Budget Period
I_BudgetPeriodTP view from TRANSACTIONAL Manage Budget Period
R_BudgetPeriodCoreTP view_entity from TRANSACTIONAL Budget Period in Core using RAP
R_BudgetPeriodTP view_entity from TRANSACTIONAL Manage Budget Period - TP

Fields (12)

KeyField CDS FieldsUsed in Views
KEY BudgetPeriod BudgetPeriod,BudgetPeriodForEdit 5
_FundPeriodicity _FundPeriodicity 3
BudgetPeriodAuthznGrp BudgetPeriodAuthznGrp 5
BudgetPeriodExpirationDate BudgetPeriodExpirationDate 5
BudgetPeriodPeriodicity BudgetPeriodPeriodicity 3
BudgetPeriodReversalDate BudgetPeriodReversalDate 5
CreatedByUser CreatedByUser 5
CreationDate CreationDate 5
LastChangeDate LastChangeDate 5
LastChangeUser LastChangedByUser,LastChangeUser 5
ValidityEndDate ValidityEndDate 5
ValidityStartDate ValidityStartDate 5 
@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