P_FundsCenterMinMaxDates

DDL: P_FUNDSCENTERMINMAXDATES SQL: PFDCTRMINMAXDAT Type: view BASIC
6 Fields 1 Data Sources

P_FundsCenterMinMaxDates is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (fmfctr) and exposes 6 fields with key fields FinancialManagementArea, FundsCenter.

Data Sources (1)

SourceAliasJoin Type
fmfctr fmfctr from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFDCTRMINMAXDAT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea fikrs FM Area
KEY FundsCenter fictr Funds Center
MaximumValidityEndDate
MinimumValidityEndDate
MaximumValidityStartDate
MinimumValidityStartDate

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_FundsCenterMinMaxDates.
-- 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: PFDCTRMINMAXDAT

CREATE VIEW P_FundsCenterMinMaxDates AS
SELECT
  fikrs AS FinancialManagementArea,
  fictr AS FundsCenter,
  max( datbis ) AS MaximumValidityEndDate,
  min( datbis ) AS MinimumValidityEndDate,
  max( datab ) AS MaximumValidityStartDate,
  min( datab ) AS MinimumValidityStartDate
FROM fmfctr
;

Learn More