P_FmavcAcoDataUser

DDL: P_FMAVCACODATAUSER SQL: PFMAVCACOUSER Type: view BASIC
35 Fields 23 Data Sources

P_FmavcAcoDataUser is a Basic CDS View in SAP S/4HANA. It reads from 23 data sources and exposes 35 fields with key fields rfikrs, rrcty, rldnr, ryear, ceffyear_9.

Data Sources (23)

SourceAliasJoin Type
P_FMAVCT_Compat AVC from
P_FMAVCT_Compat AVC union_all
fpb_persparm p1 inner
fpb_persparm p1 inner
fpb_persparm p10 inner
fpb_persparm p10 inner
fpb_persparm p11 inner
fpb_persparm p2 inner
fpb_persparm p2 inner
fpb_persparm p3 inner
fpb_persparm p3 inner
fpb_persparm p4 inner
fpb_persparm p4 inner
fpb_persparm p5 inner
fpb_persparm p5 inner
fpb_persparm p6 inner
fpb_persparm p6 inner
fpb_persparm p7 inner
fpb_persparm p7 inner
fpb_persparm p8 inner
fpb_persparm p8 inner
fpb_persparm p9 inner
fpb_persparm p9 inner

Parameters (1)

NameTypeDefault
P_uname syuname

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFMAVCACOUSER 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 (35)

KeyFieldSource TableSource FieldDescription
KEY rfikrs P_FMAVCT_Compat rfikrs FM Area
KEY rrcty P_FMAVCT_Compat rrcty Record Type
KEY rldnr P_FMAVCT_Compat rldnr Ledger (Compat.)
KEY ryear P_FMAVCT_Compat ryear Ref. Year1
KEY ceffyear_9 P_FMAVCT_Compat ceffyear_9 YCE
KEY rcvrgrp_9 P_FMAVCT_Compat rcvrgrp_9 Cover Group
KEY rgrant_nbr P_FMAVCT_Compat rgrant_nbr Grant
KEY rfund P_FMAVCT_Compat rfund Fund
KEY budget_pd_9 P_FMAVCT_Compat budget_pd_9 Budget Period
KEY rfundsctr P_FMAVCT_Compat rfundsctr Funds Center
KEY rcmmtitem P_FMAVCT_Compat rcmmtitem Commitment Item
KEY rfuncarea P_FMAVCT_Compat rfuncarea Functional Area
KEY rmeasure P_FMAVCT_Compat rmeasure Receiver FProg
KEY ruserdim P_FMAVCT_Compat ruserdim Rec.Cstr-Spc Fd
KEY alloctype_9 P_FMAVCT_Compat alloctype_9 Amount Type
KEY rtcur P_FMAVCT_Compat rtcur Currency
curr242endasAmount1
rfikrs FM Area
KEY rrcty P_FMAVCT_Compat rrcty Record Type
KEY rldnr P_FMAVCT_Compat rldnr Ledger (Compat.)
KEY ryear P_FMAVCT_Compat ryear Ref. Year1
KEY ceffyear_9 P_FMAVCT_Compat ceffyear_9 YCE
KEY rcvrgrp_9 P_FMAVCT_Compat rcvrgrp_9 Cover Group
KEY rgrant_nbr P_FMAVCT_Compat rgrant_nbr Grant
KEY rfund P_FMAVCT_Compat rfund Fund
KEY budget_pd_9 P_FMAVCT_Compat budget_pd_9 Budget Period
KEY rfundsctr P_FMAVCT_Compat rfundsctr Funds Center
KEY rcmmtitem P_FMAVCT_Compat rcmmtitem Commitment Item
KEY rfuncarea P_FMAVCT_Compat rfuncarea Functional Area
KEY rmeasure P_FMAVCT_Compat rmeasure Receiver FProg
KEY ruserdim P_FMAVCT_Compat ruserdim Rec.Cstr-Spc Fd
KEY alloctype_9 P_FMAVCT_Compat alloctype_9 Amount Type
KEY rtcur P_FMAVCT_Compat rtcur Currency
curr242endasAmount1
curr242endasAmount0

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_FmavcAcoDataUser.
-- 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: PFMAVCACOUSER
-- Parameters: P_uname : syuname

CREATE VIEW P_FmavcAcoDataUser AS
SELECT
  AVC.rfikrs AS rfikrs,
  AVC.rrcty AS rrcty,
  AVC.rldnr AS rldnr,
  AVC.ryear AS ryear,
  AVC.ceffyear_9 AS ceffyear_9,
  AVC.rcvrgrp_9 AS rcvrgrp_9,
  AVC.rgrant_nbr AS rgrant_nbr,
  AVC.rfund AS rfund,
  AVC.budget_pd_9 AS budget_pd_9,
  AVC.rfundsctr AS rfundsctr,
  AVC.rcmmtitem AS rcmmtitem,
  AVC.rfuncarea AS rfuncarea,
  AVC.rmeasure AS rmeasure,
  AVC.ruserdim AS ruserdim,
  AVC.alloctype_9 AS alloctype_9,
  AVC.rtcur AS rtcur,
  case AVC.rrcty when '0' then cast(0 as abap.curr(24,2)) else cast((AVC.hsl01 + AVC.hsl02 + AVC.hsl03 + AVC.hsl04 + AVC.hsl05 + AVC.hsl06 + AVC.hsl07 + AVC.hsl08 + AVC.hsl09 + AVC.hsl10 + AVC.hsl11 + AVC.hsl12 + AVC.hsl13 + AVC.hsl14 + AVC.hsl15 + AVC.hsl16) as abap.curr(24,2)) end as Amount1 AS curr242endasAmount1,
  case AVC.rrcty when '0' then cast((AVC.hsl01 + AVC.hsl02 + AVC.hsl03 + AVC.hsl04 + AVC.hsl05 + AVC.hsl06 + AVC.hsl07 + AVC.hsl08 + AVC.hsl09 + AVC.hsl10 + AVC.hsl11 + AVC.hsl12 + AVC.hsl13 + AVC.hsl14 + AVC.hsl15 + AVC.hsl16) as abap.curr(24,2)) else cast(0 as abap.curr(24,2)) end as Amount0 AS curr242endasAmount0
FROM P_FMAVCT_Compat AS AVC
INNER JOIN fpb_persparm AS p1 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p2 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p3 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p4 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p5 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p6 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p7 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p8 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p9 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p10 ON /* join condition not captured in parsed metadata */
INNER JOIN fpb_persparm AS p11 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_FMAVCT_Compat
;

Learn More