I_Distinct_Postingdate

DDL: I_DISTINCT_POSTINGDATE SQL: IFIDISTPOSTDATE Type: view BASIC
13 Fields 1 Data Sources

Distinct Posting Date

I_Distinct_Postingdate is a Basic CDS View (Dimension) that provides data about "Distinct Posting Date" in SAP S/4HANA. It reads from 1 data source (P_Distinct_Postingdate) and exposes 13 fields with key fields FiscalYearVariant, FiscalYear, CalendarDate, FiscalPeriod.

Data Sources (1)

SourceAliasJoin Type
P_Distinct_Postingdate P_Distinct_Postingdate from

Annotations (15)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFIDISTPOSTDATE view
AbapCatalog.preserveKey true view
EndUserText.label Distinct Posting Date view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey FiscalPeriod view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearVariant P_Distinct_Postingdate fiscal_year_variant FY Variant
KEY FiscalYear P_Distinct_Postingdate fiscal_year Tax Item Fiscal Year
KEY CalendarDate P_Distinct_Postingdate calendar_date Calendar Date
KEY FiscalPeriod P_Distinct_Postingdate fiscal_period Posting Period
IsSpecialPeriod P_Distinct_Postingdate is_special_period Is Spec. Period
FiscalYearPeriod P_Distinct_Postingdate fiscal_year_period Fiscal Year Period
FiscalYearStartDate P_Distinct_Postingdate fiscal_year_start_date Start Date
FiscalYearEndDate P_Distinct_Postingdate fiscal_year_end_date End Date
FiscalPeriodDate P_Distinct_Postingdate FiscalPeriodDate
FiscalPeriodEndDate P_Distinct_Postingdate fiscal_period_end_date End Date
_FiscalYearVariant _FiscalYearVariant
_FiscalYear _FiscalYear
_FiscalCalendarDate _FiscalCalendarDate

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 I_Distinct_Postingdate.
-- 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: IFIDISTPOSTDATE

CREATE VIEW I_Distinct_Postingdate AS
SELECT
  P_Distinct_Postingdate.fiscal_year_variant AS FiscalYearVariant,
  P_Distinct_Postingdate.fiscal_year AS FiscalYear,
  P_Distinct_Postingdate.calendar_date AS CalendarDate,
  P_Distinct_Postingdate.fiscal_period AS FiscalPeriod,
  P_Distinct_Postingdate.is_special_period AS IsSpecialPeriod,
  P_Distinct_Postingdate.fiscal_year_period AS FiscalYearPeriod,
  P_Distinct_Postingdate.fiscal_year_start_date AS FiscalYearStartDate,
  P_Distinct_Postingdate.fiscal_year_end_date AS FiscalYearEndDate,
  P_Distinct_Postingdate.FiscalPeriodDate AS FiscalPeriodDate,
  P_Distinct_Postingdate.fiscal_period_end_date AS FiscalPeriodEndDate
FROM P_Distinct_Postingdate
;

Learn More