P_FndsMgmtCmtmtOpnItmCurFsclYr

DDL: P_FNDSMGMTCMTMTOPNITMCURFSCLYR SQL: PFMIOIITMCURFY Type: view BASIC
9 Fields 1 Data Sources

P_FndsMgmtCmtmtOpnItmCurFsclYr is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (fmioi) and exposes 9 fields with key fields ReferenceDocument, FundsMgmtRefDocumentCategory, ReferenceDocumentContext, ReferenceDocumentItem, RefDocAccountAssignment.

Data Sources (1)

SourceAliasJoin Type
fmioi fmioi from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFMIOIITMCURFY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
VDM.private true view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ReferenceDocument fmioi refbn Ref.document no
KEY FundsMgmtRefDocumentCategory fmioi refbt Reference Doc. Cat.
KEY ReferenceDocumentContext fmioi rforg Refer. Org.Unit
KEY ReferenceDocumentItem fmioi rfpos Reference item
KEY RefDocAccountAssignment fmioi rfknt Acct Assnmt No.
KEY ReferenceDocumentScheduleLine fmioi rfete Schedule Line
KEY RefDocPricingElementContent fmioi rcond Counter
FinMgmtAreaCurrentFiscalYear
FundsMgmtUpdateDate

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_FndsMgmtCmtmtOpnItmCurFsclYr.
-- 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: PFMIOIITMCURFY

CREATE VIEW P_FndsMgmtCmtmtOpnItmCurFsclYr AS
SELECT
  fmioi.refbn AS ReferenceDocument,
  fmioi.refbt AS FundsMgmtRefDocumentCategory,
  fmioi.rforg AS ReferenceDocumentContext,
  fmioi.rfpos AS ReferenceDocumentItem,
  fmioi.rfknt AS RefDocAccountAssignment,
  fmioi.rfete AS ReferenceDocumentScheduleLine,
  fmioi.rcond AS RefDocPricingElementContent,
  max ( fmioi.gjahr ) AS FinMgmtAreaCurrentFiscalYear,
  max ( fmioi.zhldt ) AS FundsMgmtUpdateDate
FROM fmioi
;

Learn More