PSM_FMFUNDBPD

DDL: PSM_FMFUNDBPD SQL: PSMFMFUNDBPD Type: view Package: PSM_S4C_FM_MD

Common CDS for FMFUNDBPD in CE and OP

PSM_FMFUNDBPD is a CDS View that provides data about "Common CDS for FMFUNDBPD in CE and OP" in SAP S/4HANA. It reads from 5 data sources (fmbudgetpd, fmfincode, fmfundbpd, PSM_CE_Or_OP, PSM_CE_Or_OP) and exposes 5 fields with key fields fikrs, fincode, versionAkeyfikrs, fincode, budget_pd. Part of development package PSM_S4C_FM_MD.

Data Sources (5)

SourceAliasJoin Type
fmbudgetpd fmbudgetpd from
fmfincode fmfincode cross
fmfundbpd fmfundbpd union
PSM_CE_Or_OP PSM_CE_Or_OP inner
PSM_CE_Or_OP PSM_CE_Or_OP inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSMFMFUNDBPD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Common CDS for FMFUNDBPD in CE and OP view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY fikrs fmfincode fikrs FM Area
KEY fincode fmfincode fincode Fund
KEY versionAkeyfikrs Rec BudPer
KEY fincode fincode Fund
KEY budget_pd Rec BudPer

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 PSM_FMFUNDBPD.
-- 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: PSMFMFUNDBPD

CREATE VIEW PSM_FMFUNDBPD AS
SELECT
  fmfincode.fikrs AS fikrs,
  fmfincode.fincode AS fincode,
  cast ( budget_pd as fm_budget_period ) as budget_pd AS versionAkeyfikrs,
  cast ( budget_pd as fm_budget_period ) AS budget_pd
FROM fmbudgetpd
CROSS JOIN fmfincode
INNER JOIN PSM_CE_Or_OP ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): fmfundbpd
;