P_FmavcOcoDataUserAggEnh

DDL: P_FMAVCOCODATAUSERAGGENH SQL: PFMAVCOCOUSERENH Type: view BASIC
20 Fields 1 Data Sources

P_FmavcOcoDataUserAggEnh is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_FmavcOcoDataUserAgg) and exposes 20 fields with key fields rfikrs, rldnr, ceffyear_9, rcvrgrp_9, rgrant_nbr.

Data Sources (1)

SourceAliasJoin Type
P_FmavcOcoDataUserAgg P_FmavcOcoDataUserAgg from

Parameters (2)

NameTypeDefault
P_uname syuname
P_BudgetUsageThldInPercent buavc_budget_usage

Annotations (9)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY rfikrs rfikrs FM Area
KEY rldnr rldnr Ledger (Compat.)
KEY ceffyear_9 ceffyear_9 YCE
KEY rcvrgrp_9 rcvrgrp_9 Cover Group
KEY rgrant_nbr rgrant_nbr Grant
KEY rfund rfund Fund
KEY budget_pd_9 budget_pd_9 Budget Period
KEY rfundsctr rfundsctr Funds Center
KEY rcmmtitem rcmmtitem Commitment Item
KEY rfuncarea rfuncarea Functional Area
KEY rmeasure rmeasure Receiver FProg
KEY ruserdim ruserdim Rec.Cstr-Spc Fd
KEY rtcur rtcur Currency
ValidityEndDate ValidityEndDate ValidTo
CommitmentItemFiscalYear CommitmentItemFiscalYear Commit. Item FY
ConsumableAmountInFMACrcy
ConsumedAmountInFMACrcy
AvailableAmountInFMACrcy
HundredTimesAvailableAmount
NumberOfControlObjects

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_FmavcOcoDataUserAggEnh.
-- 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: PFMAVCOCOUSERENH
-- Parameters: P_uname : syuname, P_BudgetUsageThldInPercent : buavc_budget_usage

CREATE VIEW P_FmavcOcoDataUserAggEnh AS
SELECT
  rfikrs,
  rldnr,
  ceffyear_9,
  rcvrgrp_9,
  rgrant_nbr,
  rfund,
  budget_pd_9,
  rfundsctr,
  rcmmtitem,
  rfuncarea,
  rmeasure,
  ruserdim,
  rtcur,
  ValidityEndDate,
  CommitmentItemFiscalYear,
  cast(ConsumableAmount as buavc_consumable_amount) AS ConsumableAmountInFMACrcy,
  cast(ConsumedAmount as buavc_consumed_amount) AS ConsumedAmountInFMACrcy,
  cast( (ConsumableAmount - ConsumedAmount) as buavc_available_amount) AS AvailableAmountInFMACrcy,
  cast(100 * (ConsumableAmount - ConsumedAmount) as buavc_100_times_available) AS HundredTimesAvailableAmount,
  cast(count( * ) as buavc_obj_count) AS NumberOfControlObjects
FROM P_FmavcOcoDataUserAgg
;

Learn More