I_FundToBudgetPeriodTP

DDL: I_FUNDTOBUDGETPERIODTP SQL: IFUNDTOBPTP Type: view TRANSACTIONAL
13 Fields 1 Data Sources 3 Associations

Manage Fund to Budget Period Relation

I_FundToBudgetPeriodTP is a Transactional CDS View that provides data about "Manage Fund to Budget Period Relation" in SAP S/4HANA. It reads from 1 data source (I_FundToBudgetPeriod) and exposes 13 fields with key fields FinancialManagementArea, Fund, BudgetPeriod. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FundToBudgetPeriod iFundToBudgetPeriod from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_FundTP _Fund $projection.FinancialManagementArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund
[1..1] I_FinancialManagementArea _FinMgmtArea $projection.FinancialManagementArea = _FinMgmtArea.FinancialManagementArea
[0..1] I_BudgetPeriod _BudgetPeriod $projection.BudgetPeriodForEdit = _BudgetPeriod.BudgetPeriod

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IFUNDTOBPTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Fund to Budget Period Relation view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence FMFUNDBP_DRAFT view
ObjectModel.lifecycle.draft.expiryBehavior #RELATIVE_TO_PROCESSING_START view
ObjectModel.lifecycle.draft.expiryInterval P5D view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_FundToBudgetPeriod FinancialManagementArea FM Area
KEY Fund I_FundToBudgetPeriod Fund Sender Fund
KEY BudgetPeriod I_FundToBudgetPeriod BudgetPeriod Budget Period
BudgetPeriodForEdit I_FundToBudgetPeriod BudgetPeriod Budget Period
ApplOfFundByBudgetPeriod I_FundToBudgetPeriod ApplOfFundByBudgetPeriod
BdgtPerdAssociationIsInactive I_FundToBudgetPeriod BdgtPerdAssociationIsInactive
FundFinMgmtAreaForAuthzn I_FundToBudgetPeriod FundFinMgmtAreaForAuthzn
FundAuthznGrp I_FundToBudgetPeriod FundAuthznGrp
BudgetPeriodAuthznGrp I_FundToBudgetPeriod BudgetPeriodAuthznGrp
_Fund _Fund
_FinMgmtArea _FinMgmtArea
_BudgetPeriod _BudgetPeriod
_ApplicationOfFund I_FundToBudgetPeriod _ApplicationOfFund

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_FundToBudgetPeriodTP.
-- 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: IFUNDTOBPTP

CREATE VIEW I_FundToBudgetPeriodTP AS
SELECT
  iFundToBudgetPeriod.FinancialManagementArea AS FinancialManagementArea,
  iFundToBudgetPeriod.Fund AS Fund,
  iFundToBudgetPeriod.BudgetPeriod AS BudgetPeriod,
  iFundToBudgetPeriod.BudgetPeriod AS BudgetPeriodForEdit,
  iFundToBudgetPeriod.ApplOfFundByBudgetPeriod AS ApplOfFundByBudgetPeriod,
  iFundToBudgetPeriod.BdgtPerdAssociationIsInactive AS BdgtPerdAssociationIsInactive,
  iFundToBudgetPeriod.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  iFundToBudgetPeriod.FundAuthznGrp AS FundAuthznGrp,
  iFundToBudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  iFundToBudgetPeriod._ApplicationOfFund AS _ApplicationOfFund
FROM I_FundToBudgetPeriod AS iFundToBudgetPeriod
LEFT OUTER JOIN I_FundTP AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [1..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriodForEdit = _BudgetPeriod.BudgetPeriod  -- association [0..1]
;

Learn More