I_FiscalYearVariant
Fiscal Year Variant
I_FiscalYearVariant is a Basic CDS View (Dimension) that provides data about "Fiscal Year Variant" in SAP S/4HANA. It reads from 1 data source (t009) and exposes 8 fields with key field FiscalYearVariant.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| t009 | t009 | from |
Annotations (22)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| VDM.viewType | #BASIC | view | |
| AbapCatalog.buffering.status | #ACTIVE | view | |
| AbapCatalog.buffering.type | #FULL | view | |
| AbapCatalog.buffering.numberOfKeyFields | 2 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.sqlViewName | IFIFISCYEARVAR | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.dataExtraction.enabled | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Fiscal Year Variant | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #CUSTOMIZING | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_DIMENSION | view | |
| ObjectModel.representativeKey | FiscalYearVariant | view | |
| ObjectModel.sapObjectNodeType.name | FiscalYearVariant | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Search.searchable | true | view | |
| Consumption.ranked | true | view |
Fields (8)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | FiscalYearVariant | |||
| FiscalPeriodIsEqualMonth | ||||
| IsYearDependent | xjabh | |||
| PostingPeriodsNumberVal | anzbp | |||
| NumberOfSpecialPeriods | anzsp | |||
| FsclWeekStartIsFsclYearStart | xweek | |||
| FiscalCalendarIsWeekBased | xweekquart | |||
| _Text | _Text |
@VDM: {lifecycle.contract.type: #PUBLIC_LOCAL_API,
viewType: #BASIC
}
@AbapCatalog: { buffering: {status: #ACTIVE,
type: #FULL,
numberOfKeyFields: 2},
compiler.compareFilter: true,
sqlViewName: 'IFIFISCYEARVAR',
preserveKey: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Fiscal Year Variant'
@ObjectModel: {usageType: { serviceQuality: #A,
sizeCategory: #S,
dataClass: #CUSTOMIZING },
modelingPattern: #ANALYTICAL_DIMENSION,
supportedCapabilities: [#ANALYTICAL_DIMENSION,
#CDS_MODELING_ASSOCIATION_TARGET,
#CDS_MODELING_DATA_SOURCE,
#SQL_DATA_SOURCE,
#EXTRACTION_DATA_SOURCE],
representativeKey: 'FiscalYearVariant',
sapObjectNodeType.name: 'FiscalYearVariant'
}
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@Consumption.ranked: true
define view I_FiscalYearVariant as select from t009
association[0..*] to I_FiscalYearVariantText as _Text on $projection.FiscalYearVariant = _Text.FiscalYearVariant
{
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold: 0.8
@Search.ranking: #HIGH
@ObjectModel.text.association: '_Text'
@Semantics.fiscal.yearVariant: true
key cast( periv as fis_periv preserving type ) as FiscalYearVariant,
cast( xkale as fis_xkale preserving type ) as FiscalPeriodIsEqualMonth,
xjabh as IsYearDependent,
anzbp as PostingPeriodsNumberVal,
anzsp as NumberOfSpecialPeriods,
xweek as FsclWeekStartIsFsclYearStart,
xweekquart as FiscalCalendarIsWeekBased,
_Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T009"
],
"ASSOCIATED":
[
"I_FISCALYEARVARIANTTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA