P_GMAVCDataUser

DDL: P_GMAVCDATAUSER SQL: PGMAVCDATAUSER Type: view BASIC
15 Fields 5 Data Sources

P_GMAVCDataUser is a Basic CDS View in SAP S/4HANA. It reads from 5 data sources (P_GMAVCT_Compat, t001, gmgr, fpb_persparm, fpb_persparm) and exposes 15 fields with key fields rbukrs, rrcty, rldnr, ryear, grantee_fy_9.

Data Sources (5)

SourceAliasJoin Type
P_GMAVCT_Compat AVC from
t001 CC inner
gmgr MD inner
fpb_persparm p1 left_outer
fpb_persparm p2 left_outer

Parameters (3)

NameTypeDefault
P_uname syuname
P_CompanyCodeCurrency vdm_v_company_code_currency
P_AvailabilityControlLedger buavc_aldnr

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PGMAVCDATAUSER 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 (15)

KeyFieldSource TableSource FieldDescription
KEY rbukrs rbukrs Company Code
KEY rrcty rrcty Record Type
KEY rldnr rldnr Ledger (Compat.)
KEY ryear ryear Ref. Year1
KEY grantee_fy_9 grantee_fy_9 Grantee Fisc. Year
KEY ceffyear_9 ceffyear_9 YCE
KEY rgrant_nbr rgrant_nbr Grant
KEY rfund rfund Fund
KEY alloctype_9 alloctype_9 Amount Type
KEY wfstate_9 wfstate_9 Workflow Status
KEY rtcur rtcur Currency
curr242endasHSLAmount1
curr242endasHSLAmount0
curr242endasTSLAmount1
curr242endasTSLAmount0

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_GMAVCDataUser.
-- 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: PGMAVCDATAUSER
-- Parameters: P_uname : syuname, P_CompanyCodeCurrency : vdm_v_company_code_currency, P_AvailabilityControlLedger : buavc_aldnr

CREATE VIEW P_GMAVCDataUser AS
SELECT
  rbukrs,
  rrcty,
  rldnr,
  ryear,
  grantee_fy_9,
  ceffyear_9,
  rgrant_nbr,
  rfund,
  alloctype_9,
  wfstate_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 HSLAmount1 AS curr242endasHSLAmount1,
  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 HSLAmount0 AS curr242endasHSLAmount0,
  case rrcty when '0' then cast(0 as abap.curr(24,2)) else cast((tsl01 + tsl02 + tsl03 + tsl04 + tsl05 + tsl06 + tsl07 + tsl08 + tsl09 + tsl10 + tsl11 + tsl12 + tsl13 + tsl14 + tsl15 + tsl16) as abap.curr(24,2)) end as TSLAmount1 AS curr242endasTSLAmount1,
  case rrcty when '0' then cast((tsl01 + tsl02 + tsl03 + tsl04 + tsl05 + tsl06 + tsl07 + tsl08 + tsl09 + tsl10 + tsl11 + tsl12 + tsl13 + tsl14 + tsl15 + tsl16) as abap.curr(24,2)) else cast(0 as abap.curr(24,2)) end as TSLAmount0 AS curr242endasTSLAmount0
FROM P_GMAVCT_Compat AS AVC
INNER JOIN t001 AS CC ON /* join condition not captured in parsed metadata */
INNER JOIN gmgr AS MD ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fpb_persparm AS p1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fpb_persparm AS p2 ON /* join condition not captured in parsed metadata */
;

Learn More