I_FISCALYEARPERIODFORCMPNYCODE

CDS View

Fiscal Year Period For Company Code

I_FISCALYEARPERIODFORCMPNYCODE is a CDS View in S/4HANA. Fiscal Year Period For Company Code. It contains 17 fields. 17 CDS views read from this table.

Used by 17 CDS view(s) 17 fields

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_ActualCostRateTimeline view inner CONSUMPTION Actual Cost Rate Timeline
C_APMinFiscalPeriodStartDate view from CONSUMPTION Minimal Fiscal Period Start Date
C_FiscalYearPeriodForCoCodeVH view_entity from CONSUMPTION Fiscal Year Period For Company Code
C_ServiceCostRateTimeline view inner CONSUMPTION Service Cost Rate Timeline Chart
C_SlsAcctgFsclPerdForCoCodeVH view from CONSUMPTION Fiscal Year Period for Company Code Value Help
I_JVAFiscalYearPeriodForCoCode view from COMPOSITE JVA Fiscal Year Period For Company Code
I_JVAFiscalYearPeriodForCoCode view inner COMPOSITE JVA Fiscal Year Period For Company Code
I_JVAFiscalYrPerdForEquityGrp view inner COMPOSITE JVA Fiscal Year Period For Equity Group
I_LastDayOfFsclDteFunctionVH view from BASIC Last day of fiscal date function
I_PPM_CurrentPeriod view inner COMPOSITE Current period for a project
P_EntProjActlCostDatesByID view inner CONSUMPTION
P_FIARCN_TOTAL_PERIODS view from CONSUMPTION
P_FiscalPeriodLast6Mnths view from COMPOSITE
P_Matval_Manage_FiscPer_Info view from COMPOSITE
P_Matval_Manage_Val_Chart view inner BASIC
P_PCCOrderOutPutQtyByPeriod view inner COMPOSITE
P_PH_SalesPurchasesSummaryItem view left_outer COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 3
KEY FiscalPeriod CurrentFiscalPeriod,FiscalPeriod,PreviousFiscalPeriod 6
KEY FiscalYear CurrentFiscalYear,FiscalYear,PreviousFiscalYear 6
_CompanyCode _CompanyCode 1
_FiscalPeriodStartDate _FiscalPeriodStartDate 1
_FiscalYear _FiscalYear 1
_FiscalYearVariant _FiscalYearVariant 1
_Text _Text 1
FiscalPeriodEndDate FiscalPeriodEndDate 3
FiscalPeriodStartDate DateFunctionStartDate,FiscalPeriodStartDate 3
FiscalYearEndDate FiscalYearEndDate 1
FiscalYearPeriod FiscalYearPeriod 2
FiscalYearStartDate FiscalYearStartDate 1
FiscalYearVariant FiscalYearVariant 1
IsSpecialPeriod IsSpecialPeriod 1
NextFiscalPeriod NextFiscalPeriod 1
NextFiscalPeriodFiscalYear NextFiscalPeriodFiscalYear 1 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.sqlViewName: 'IFIFYEARPERIODCC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Fiscal Year Period For Company Code'
@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #CUSTOMIZING

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'FiscalPeriod'
@Analytics: { dataCategory: #DIMENSION }

@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, 
                                     #CDS_MODELING_ASSOCIATION_TARGET, 
                                     #CDS_MODELING_DATA_SOURCE,
                                     #SQL_DATA_SOURCE]
                                     
define view I_FiscalYearPeriodForCmpnyCode as select from I_FiscalYearPeriod inner join  I_CompanyCode 
                                                       on I_FiscalYearPeriod.FiscalYearVariant = I_CompanyCode.FiscalYearVariant

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

{

      //--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

@ObjectModel.foreignKey.association: '_CompanyCode'      
key cast( I_CompanyCode.CompanyCode as fis_bukrs preserving type ) as CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'      
key FiscalYear,
@ObjectModel.text.association: '_Text'
key FiscalPeriod,

@ObjectModel.foreignKey.association: '_FiscalYearVariant'      
    I_FiscalYearPeriod.FiscalYearVariant,

@ObjectModel.foreignKey.association: '_FiscalPeriodStartDate'      
    FiscalPeriodStartDate,
    FiscalPeriodEndDate,
    
    IsSpecialPeriod,
    
    FiscalYearStartDate,
    FiscalYearEndDate,
    
    NextFiscalPeriod,
    NextFiscalPeriodFiscalYear,
     
    FiscalYearPeriod,
    
    _CompanyCode,
    _FiscalYearVariant,
    _FiscalPeriodStartDate,
    _FiscalYear,
    _Text 
           
}

                   

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_FISCALYEARPERIOD"
],
"ASSOCIATED":
[
"I_CALENDARDATE",
"I_COMPANYCODE",
"I_FISCALPERIODFORCOCODETEXT",
"I_FISCALYEARFORCOMPANYCODE",
"I_FISCALYEARVARIANT"
],
"BASE":
[
"I_FISCALYEARPERIOD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More