P_FmavcAcoData

DDL: P_FMAVCACODATA SQL: PFMAVCACODATA Type: view BASIC
34 Fields 2 Data Sources

P_FmavcAcoData is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_FMAVCT_Compat, P_FMAVCT_Compat) and exposes 34 fields with key fields rfikrs, rrcty, rldnr, ryear, ceffyear_9.

Data Sources (2)

SourceAliasJoin Type
P_FMAVCT_Compat P_FMAVCT_Compat from
P_FMAVCT_Compat P_FMAVCT_Compat union_all

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFMAVCACODATA 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 (34)

KeyFieldSource TableSource FieldDescription
KEY rfikrs rfikrs FM Area
KEY rrcty rrcty Record Type
KEY rldnr rldnr Ledger (Compat.)
KEY ryear ryear Ref. Year1
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 alloctype_9 alloctype_9 Amount Type
KEY rtcur rtcur Currency
curr242endasAmount1
KEY rrcty rrcty Record Type
KEY rldnr rldnr Ledger (Compat.)
KEY ryear ryear Ref. Year1
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 alloctype_9 alloctype_9 Amount Type
KEY rtcur 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_FmavcAcoData.
-- 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: PFMAVCACODATA

CREATE VIEW P_FmavcAcoData AS
SELECT
  rfikrs,
  rrcty,
  rldnr,
  ryear,
  ceffyear_9,
  rcvrgrp_9,
  rgrant_nbr,
  rfund,
  budget_pd_9,
  rfundsctr,
  rcmmtitem,
  rfuncarea,
  rmeasure,
  ruserdim,
  alloctype_9,
  rtcur,
  case rrcty when '0' then cast(0 as abap.curr(24,2)) else cast((hsl01 + hsl02 + hsl03 + hsl04 + hsl05 + hsl06 + hsl07 + hsl08 + hsl09 + hsl10 + hsl11 + hsl12 + hsl13 + hsl14 + hsl15 + hsl16) as abap.curr(24,2)) end as Amount1 AS curr242endasAmount1,
  case rrcty when '0' then cast((hsl01 + hsl02 + hsl03 + hsl04 + hsl05 + hsl06 + hsl07 + hsl08 + hsl09 + hsl10 + hsl11 + hsl12 + hsl13 + hsl14 + hsl15 + hsl16) as abap.curr(24,2)) else cast(0 as abap.curr(24,2)) end as Amount0 AS curr242endasAmount0
FROM P_FMAVCT_Compat
-- UNION ALL with additional select branch(es): P_FMAVCT_Compat
;

Learn More