R_BudgetPeriodCoreTP

DDL: R_BUDGETPERIODCORETP Type: view_entity TRANSACTIONAL
14 Fields 1 Data Sources 4 Associations

Budget Period in Core using RAP

R_BudgetPeriodCoreTP is a Transactional CDS View that provides data about "Budget Period in Core using RAP" in SAP S/4HANA. It reads from 1 data source (I_BudgetPeriod) and exposes 14 fields with key field BudgetPeriod. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BudgetPeriod budgetpd from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_BudgetPeriod _Extension $projection.BudgetPeriod = _Extension.BudgetPeriod
[0..1] I_User _user_created $projection.CreatedByUser = _user_created.UserID
[0..1] I_User _user_changed $projection.LastChangedByUser = _user_changed.UserID
[0..*] R_BudgetPeriodCoreTextTP _Text

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Budget Period in Core using RAP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name BudgetPeriod view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BudgetPeriod 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
_Text _Text

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 R_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.

CREATE VIEW R_BudgetPeriodCoreTP AS
SELECT
  budgetpd.BudgetPeriod AS BudgetPeriod,
  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]
LEFT OUTER JOIN I_User AS _user_created ON CreatedByUser = _user_created.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _user_changed ON LastChangedByUser = _user_changed.UserID  -- association [0..1]
LEFT OUTER JOIN R_BudgetPeriodCoreTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More