I_BudgetPeriodCoreTP

DDL: I_BUDGETPERIODCORETP SQL: IFMBDGTPDCORETP Type: view TRANSACTIONAL Package: ODATA_PSM_S4C_FM_MD
16 Fields 1 Data Sources 1 Associations

Manage Budget Period

I_BudgetPeriodCoreTP is a Transactional CDS View that provides data about "Manage Budget Period" in SAP S/4HANA. It reads from 1 data source (I_BudgetPeriod) and exposes 16 fields with key field BudgetPeriod. It has 1 association to related views. Part of development package ODATA_PSM_S4C_FM_MD.

Data Sources (1)

SourceAliasJoin Type
I_BudgetPeriod budgetpd from

Associations (1)

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

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName IFMBDGTPDCORETP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Budget Period view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.createEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.representativeKey BudgetPeriod view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence FMC_D_BDGTPD_DFT view
ObjectModel.entityChangeStateId EXTERNAL_CALCULATION view
ObjectModel.lifecycle.draft.expiryBehavior #RELATIVE_TO_PROCESSING_START view
ObjectModel.lifecycle.draft.expiryInterval P5D view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BudgetPeriod I_BudgetPeriod BudgetPeriod Budget Period
BudgetPeriodForEdit I_BudgetPeriod BudgetPeriod Budget Period
ValidityStartDate I_BudgetPeriod ValidityStartDate Validity Start Date
ValidityEndDate I_BudgetPeriod ValidityEndDate ValidTo
BudgetPeriodExpirationDate I_BudgetPeriod BudgetPeriodExpirationDate
BudgetPeriodReversalDate I_BudgetPeriod BudgetPeriodReversalDate
BudgetPeriodAuthznGrp I_BudgetPeriod BudgetPeriodAuthznGrp
CreatedByUser I_BudgetPeriod CreatedByUser User Name
CreationDate I_BudgetPeriod CreationDate Time Stamp
LastChangedByUser I_BudgetPeriod LastChangeUser User Name
LastChangeDate I_BudgetPeriod LastChangeDate Time Stamp
BudgetPeriodPeriodicity I_BudgetPeriod BudgetPeriodPeriodicity
_FundPeriodicity I_BudgetPeriod _FundPeriodicity
BudgetPeriodName
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BudgetPeriodCoreTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFMBDGTPDCORETP

CREATE VIEW I_BudgetPeriodCoreTP AS
SELECT
  budgetpd.BudgetPeriod AS BudgetPeriod,
  budgetpd.BudgetPeriod AS BudgetPeriodForEdit,
  budgetpd.ValidityStartDate AS ValidityStartDate,
  budgetpd.ValidityEndDate AS ValidityEndDate,
  budgetpd.BudgetPeriodExpirationDate AS BudgetPeriodExpirationDate,
  budgetpd.BudgetPeriodReversalDate AS BudgetPeriodReversalDate,
  budgetpd.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  budgetpd.CreatedByUser AS CreatedByUser,
  budgetpd.CreationDate AS CreationDate,
  budgetpd.LastChangeUser AS LastChangedByUser,
  budgetpd.LastChangeDate AS LastChangeDate,
  budgetpd.BudgetPeriodPeriodicity AS BudgetPeriodPeriodicity,
  budgetpd._FundPeriodicity AS _FundPeriodicity,
  budgetpd._Text[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName
FROM I_BudgetPeriod AS budgetpd
LEFT OUTER JOIN E_BudgetPeriod AS _Extension ON BudgetPeriod = _Extension.BudgetPeriod  -- association [0..1]
;

Learn More