I_BPFISCALYEARPROCESS

CDS View

BP fiscal years

I_BPFISCALYEARPROCESS is a CDS View in S/4HANA. BP fiscal years. It contains 7 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 7 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPFiscalYearProcessChanges view from BP fiscal years changes
I_BPFiscalYearProcessChanges view union_all BP fiscal years changes
I_BPFiscalYearProcessTP view_entity from TRANSACTIONAL BP fiscal years

Fields (7)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY BusinessPartnerFiscalYear BusinessPartnerFiscalYear 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP fiscal years'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPFiscalYearProcess
  as select from bp021_prc
  association [1..1] to I_BusinessPartnerProcess as _BusinessPartner on  bp021_prc.process_id      = _BusinessPartner.MasterDataChangeProcess
                                                                     and bp021_prc.process_step_no = _BusinessPartner.MDChgProcessStep
                                                                     and bp021_prc.source_system   = _BusinessPartner.MDChgProcessSrceSystem
                                                                     and bp021_prc.source_id       = _BusinessPartner.MDChgProcessSrceObject

{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key partnr                   as BusinessPartner,
      @Semantics.calendar.year: true
  key business_y               as BusinessPartnerFiscalYear,
  
      bal_sh_cur               as BPBalanceSheetCurrency,
      gen_meet_d               as BPAnnualStockholderMeetingDate,
      @Semantics.businessDate.from: true
      bu_y_begin               as BPFiscalYearStartDate,
      @Semantics.businessDate.to: true
      bu_y_end                 as BPFiscalYearEndDate,
      annual_acc               as BPFiscalYearIsClosed,
      @EndUserText.label: 'Year-End Closing Date'
      annu_acc_d               as BPFiscalYearClosingDate,
      @Semantics.businessDate.at: true
      cons_fst_d               as BPFsclYrCnsldtdFinStatementDte,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      capi_stock               as BPCapitalStockAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      shar_stock               as BPIssdStockCptlAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      prsh_stock               as BPPartcipnCertAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      equity                   as BPEquityCapitalAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      gross_amnt               as BPGrossPremiumAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      net_amount               as BPNetPremiumAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      turnover                 as BPAnnualSalesAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      net_income               as BPAnnualNetIncAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      div_dis_am               as BPDividendDistrAmtInBalShtCrcy,
      debts_fact               as BPDebtRatioInYears,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      dis_profit               as BPAnnualPnLAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      bal_amount               as BPBalSheetTotalAmtInBalShtCrcy,
      staff_count              as BPNumberOfEmployees,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      cap_res                  as BPCptlReserveAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      rev_res_leg              as BPLglRevnRsrvAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      rev_res_own_shr          as RevnRsrvOwnStkAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      rev_res_by_laws          as BPStatryReserveAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      rev_res_others           as BPOthRevnRsrvAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      forw_profit_loss         as BPPnLCarryfwdAmtInBalShtCrcy,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      liabilit_second          as BPSuborddLbltyAmtInBalShtCrcy,
      ret_tot_cap_empl         as BPRetOnTotalCptlEmpldInPercent,
      reduc_long_term          as BPDebtClearancePeriodInYears,
      coeff_finance            as BPFinancingCoeffInPercent,
      equity_capit             as BPEquityRatioInPercent,

      source_recency           as MDChgProcSrceLastChgdDateTime,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,

      _BusinessPartner
}

Learn More