P_FmavcAcoDataAgg

DDL: P_FMAVCACODATAAGG SQL: PFMAVCACODATAAGG Type: view BASIC
18 Fields 1 Data Sources 2 Associations

P_FmavcAcoDataAgg is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_FmavcAcoData) and exposes 18 fields with key fields rfikrs, rldnr, ryear, ceffyear_9, rcvrgrp_9. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_FmavcAcoData P_FmavcAcoData from

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_FundsCenterValidityDate _FundsCenterValidityDate $projection.rfikrs = _FundsCenterValidityDate.FinancialManagementArea and $projection.rfundsctr = _FundsCenterValidityDate.FundsCenter and $projection.ryear = _FundsCenterValidityDate.FinMgmtAreaFiscalYear
[1..1] I_FiscalYearForFinMgmtArea _FiscalYearForFinMgmtArea $projection.rfikrs = _FiscalYearForFinMgmtArea.FinancialManagementArea and $projection.ryear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFMAVCACODATAAGG view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY rfikrs P_FmavcAcoData rfikrs FM Area
KEY rldnr P_FmavcAcoData rldnr Ledger (Compat.)
KEY ryear P_FmavcAcoData ryear Ref. Year1
KEY ceffyear_9 P_FmavcAcoData ceffyear_9 YCE
KEY rcvrgrp_9 P_FmavcAcoData rcvrgrp_9 Cover Group
KEY rgrant_nbr P_FmavcAcoData rgrant_nbr Grant
KEY rfund P_FmavcAcoData rfund Fund
KEY budget_pd_9 P_FmavcAcoData budget_pd_9 Budget Period
KEY rfundsctr P_FmavcAcoData rfundsctr Funds Center
KEY rcmmtitem P_FmavcAcoData rcmmtitem Commitment Item
KEY rfuncarea P_FmavcAcoData rfuncarea Functional Area
KEY rmeasure P_FmavcAcoData rmeasure Receiver FProg
KEY ruserdim P_FmavcAcoData ruserdim Rec.Cstr-Spc Fd
KEY rtcur P_FmavcAcoData rtcur Currency
ConsumableAmount
ConsumedAmount
ValidityEndDate _FundsCenterValidityDate ValidityEndDate ValidTo
CommitmentItemFiscalYear _FiscalYearForFinMgmtArea CommitmentItemFiscalYear Commit. Item FY

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 P_FmavcAcoDataAgg.
-- 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: PFMAVCACODATAAGG

CREATE VIEW P_FmavcAcoDataAgg AS
SELECT
  P_FmavcAcoData.rfikrs AS rfikrs,
  P_FmavcAcoData.rldnr AS rldnr,
  P_FmavcAcoData.ryear AS ryear,
  P_FmavcAcoData.ceffyear_9 AS ceffyear_9,
  P_FmavcAcoData.rcvrgrp_9 AS rcvrgrp_9,
  P_FmavcAcoData.rgrant_nbr AS rgrant_nbr,
  P_FmavcAcoData.rfund AS rfund,
  P_FmavcAcoData.budget_pd_9 AS budget_pd_9,
  P_FmavcAcoData.rfundsctr AS rfundsctr,
  P_FmavcAcoData.rcmmtitem AS rcmmtitem,
  P_FmavcAcoData.rfuncarea AS rfuncarea,
  P_FmavcAcoData.rmeasure AS rmeasure,
  P_FmavcAcoData.ruserdim AS ruserdim,
  P_FmavcAcoData.rtcur AS rtcur,
  sum(P_FmavcAcoData.Amount1) AS ConsumableAmount,
  sum(P_FmavcAcoData.Amount0) AS ConsumedAmount,
  _FundsCenterValidityDate.ValidityEndDate AS ValidityEndDate,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear
FROM P_FmavcAcoData
LEFT OUTER JOIN P_FundsCenterValidityDate AS _FundsCenterValidityDate ON rfikrs = _FundsCenterValidityDate.FinancialManagementArea AND rfundsctr = _FundsCenterValidityDate.FundsCenter AND ryear = _FundsCenterValidityDate.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON rfikrs = _FiscalYearForFinMgmtArea.FinancialManagementArea AND ryear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
;

Learn More