I_FiscalCalYearPeriodForCoCode

DDL: I_FISCALCALYEARPERIODFORCOCODE SQL: IFIFCFYPERDCC Type: view BASIC
14 Fields 2 Data Sources 4 Associations 2 OData Services 1 Fiori Apps

Fiscal Year Period for Company Code

I_FiscalCalYearPeriodForCoCode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_FiscalCalYearPeriodForCoCode is a Basic CDS View (Dimension) that provides data about "Fiscal Year Period for Company Code" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, P_FiscalYearPeriod) and exposes 14 fields with key fields CompanyCode, FiscalYearPeriod. It has 4 associations to related views. It is exposed through 2 OData services (FAC_ACE_DSP_PERDC_ACCR_AMT_SRV, UI_MANUALACCRS_MNG). It is used in 1 Fiori application: Manage Manual Accruals.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-IS
CapabilitiesAnalytical Dimension, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
P_FiscalYearPeriod P_FiscalYearPeriod from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_FiscalYearVariant _FiscalYearVariant $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
[0..1] I_FiscalYearForCompanyCode _FiscalYear $projection.FiscalYear = _FiscalYear.FiscalYear and $projection.CompanyCode = _FiscalYear.CompanyCode
[0..*] I_FiscalPeriodForCoCodeText _Text $projection.CompanyCode = _Text.CompanyCode and $projection.FiscalYear = _Text.FiscalYear and $projection.FiscalPeriod = _Text.FiscalPeriod

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIFCFYPERDCC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey FiscalYearPeriod view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
EndUserText.label Fiscal Year Period for Company Code view

OData Services (2)

ServiceBindingVersionContractRelease
FAC_ACE_DSP_PERDC_ACCR_AMT_SRV FAC_ACE_DSP_PERDC_AMT_SRV V2 C1 NOT_RELEASED
UI_MANUALACCRS_MNG UI_MANUALACCRS_MNG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5423 Manage Manual Accruals Transactional With this app, you can create, import, edit, and copy accrual objects as well as change their status. You can use this app to: - Display and edit accrual objects. - Create new accrual objects. - Copy accrual objects. - Import accrual objects from a spreadsheet file. - Change the status of an accrual object by pausing, suspending, or resuming its accrual subobjects. - Prematurely finish accrual subobjects by terminating them or undo premature termination. - View the parameters assigned to an accrual object. - View a detailed summary of changes made to the accrual object, comparing the old and new values of the accrual object fields.

Manage Manual Accruals

Business Role: General Ledger Accountant

With this app, you can create, import, edit, and copy accrual objects as well as change their status.

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Company Code
KEY FiscalYearPeriod P_FiscalYearPeriod fiscal_year_period Fiscal Year + Fiscal Period
FiscalYear P_FiscalYearPeriod fiscal_year Tax Item Fiscal Year
FiscalPeriod P_FiscalYearPeriod fiscal_period Posting Period
FiscalYearVariant P_FiscalYearPeriod fiscal_year_variant Fiscal Year Variant
FiscalPeriodStartDate P_FiscalYearPeriod fiscal_period_start_date Start Date of Fiscal Period
FiscalPeriodEndDate P_FiscalYearPeriod fiscal_period_end_date End Date of Fiscal Period
IsSpecialPeriod P_FiscalYearPeriod is_special_period Indicator: Is Special Period
FiscalYearStartDate P_FiscalYearPeriod fiscal_year_start_date Start Date of Fiscal Year
FiscalYearEndDate P_FiscalYearPeriod fiscal_year_end_date End Date of Fiscal Year
_CompanyCode _CompanyCode
_FiscalYearVariant _FiscalYearVariant
_FiscalYear _FiscalYear
_Text _Text

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_FiscalCalYearPeriodForCoCode.
-- 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: IFIFCFYPERDCC

CREATE VIEW I_FiscalCalYearPeriodForCoCode AS
SELECT
  cast( I_CompanyCode.CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  P_FiscalYearPeriod.fiscal_year_period AS FiscalYearPeriod,
  P_FiscalYearPeriod.fiscal_year AS FiscalYear,
  P_FiscalYearPeriod.fiscal_period AS FiscalPeriod,
  P_FiscalYearPeriod.fiscal_year_variant AS FiscalYearVariant,
  P_FiscalYearPeriod.fiscal_period_start_date AS FiscalPeriodStartDate,
  P_FiscalYearPeriod.fiscal_period_end_date AS FiscalPeriodEndDate,
  P_FiscalYearPeriod.is_special_period AS IsSpecialPeriod,
  P_FiscalYearPeriod.fiscal_year_start_date AS FiscalYearStartDate,
  P_FiscalYearPeriod.fiscal_year_end_date AS FiscalYearEndDate
FROM P_FiscalYearPeriod
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForCoCodeText AS _Text ON CompanyCode = _Text.CompanyCode AND FiscalYear = _Text.FiscalYear AND FiscalPeriod = _Text.FiscalPeriod  -- association [0..*]
;

Learn More