I_BPFiscalYearProcessTP

DDL: I_BPFISCALYEARPROCESSTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_GOV_BO

BP fiscal years

I_BPFiscalYearProcessTP is a Transactional CDS View that provides data about "BP fiscal years" in SAP S/4HANA. It reads from 1 data source (I_BPFiscalYearProcess) and exposes 45 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BusinessPartner. It has 3 associations to related views. Part of development package MDC_BUPA_GOV_BO.

1 data source(s) 45 fields

Data Sources (1)

SourceAliasJoin Type
I_BPFiscalYearProcess BPFiscalYear from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BPProcessKPIRecordType _RecordType $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordType.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[0..*] I_MDChgProcRecordMessages _RecordMessages $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordMessages.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP fiscal years view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY BusinessPartner BusinessPartner
KEY BusinessPartnerFiscalYear BusinessPartnerFiscalYear
BPBalanceSheetCurrency BPBalanceSheetCurrency
BPAnnualStockholderMeetingDate BPAnnualStockholderMeetingDate
BPFiscalYearStartDate BPFiscalYearStartDate
BPFiscalYearEndDate BPFiscalYearEndDate
BPFiscalYearIsClosed BPFiscalYearIsClosed
BPFiscalYearClosingDate BPFiscalYearClosingDate
BPFsclYrCnsldtdFinStatementDte BPFsclYrCnsldtdFinStatementDte
BPCapitalStockAmtInBalShtCrcy BPCapitalStockAmtInBalShtCrcy
BPIssdStockCptlAmtInBalShtCrcy BPIssdStockCptlAmtInBalShtCrcy
BPPartcipnCertAmtInBalShtCrcy BPPartcipnCertAmtInBalShtCrcy
BPEquityCapitalAmtInBalShtCrcy BPEquityCapitalAmtInBalShtCrcy
BPGrossPremiumAmtInBalShtCrcy BPGrossPremiumAmtInBalShtCrcy
BPNetPremiumAmtInBalShtCrcy BPNetPremiumAmtInBalShtCrcy
BPAnnualSalesAmtInBalShtCrcy BPAnnualSalesAmtInBalShtCrcy
BPAnnualNetIncAmtInBalShtCrcy BPAnnualNetIncAmtInBalShtCrcy
BPDividendDistrAmtInBalShtCrcy BPDividendDistrAmtInBalShtCrcy
BPDebtRatioInYears BPDebtRatioInYears
BPAnnualPnLAmtInBalShtCrcy BPAnnualPnLAmtInBalShtCrcy
BPBalSheetTotalAmtInBalShtCrcy BPBalSheetTotalAmtInBalShtCrcy
BPNumberOfEmployees BPNumberOfEmployees
BPCptlReserveAmtInBalShtCrcy BPCptlReserveAmtInBalShtCrcy
BPLglRevnRsrvAmtInBalShtCrcy BPLglRevnRsrvAmtInBalShtCrcy
RevnRsrvOwnStkAmtInBalShtCrcy RevnRsrvOwnStkAmtInBalShtCrcy
BPStatryReserveAmtInBalShtCrcy BPStatryReserveAmtInBalShtCrcy
BPOthRevnRsrvAmtInBalShtCrcy BPOthRevnRsrvAmtInBalShtCrcy
BPPnLCarryfwdAmtInBalShtCrcy BPPnLCarryfwdAmtInBalShtCrcy
BPSuborddLbltyAmtInBalShtCrcy BPSuborddLbltyAmtInBalShtCrcy
BPRetOnTotalCptlEmpldInPercent BPRetOnTotalCptlEmpldInPercent
BPDebtClearancePeriodInYears BPDebtClearancePeriodInYears
BPFinancingCoeffInPercent BPFinancingCoeffInPercent
BPEquityRatioInPercent BPEquityRatioInPercent
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
AddressLine1Text
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP fiscal years'
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPFiscalYearProcessTP
  as select from I_BPFiscalYearProcess as BPFiscalYear
  association        to parent I_BusinessPartnerProcessTP as _BusinessPartner     on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to I_BPProcessKPIRecordType          as _RecordType          on  $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _RecordType.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _RecordType.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _RecordType.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH         as _KPIUpdateStatusText on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [0..*] to I_MDChgProcRecordMessages         as _RecordMessages      on  $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _RecordMessages.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _RecordMessages.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _RecordMessages.MDChgProcessSrceObject
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key BusinessPartner,
  key BusinessPartnerFiscalYear,
      BPBalanceSheetCurrency,
      BPAnnualStockholderMeetingDate,
      BPFiscalYearStartDate,
      BPFiscalYearEndDate,
      BPFiscalYearIsClosed,
      BPFiscalYearClosingDate,
      BPFsclYrCnsldtdFinStatementDte,
      BPCapitalStockAmtInBalShtCrcy,
      BPIssdStockCptlAmtInBalShtCrcy,
      BPPartcipnCertAmtInBalShtCrcy,
      BPEquityCapitalAmtInBalShtCrcy,
      BPGrossPremiumAmtInBalShtCrcy,
      BPNetPremiumAmtInBalShtCrcy,
      BPAnnualSalesAmtInBalShtCrcy,
      BPAnnualNetIncAmtInBalShtCrcy,
      BPDividendDistrAmtInBalShtCrcy,
      BPDebtRatioInYears,
      BPAnnualPnLAmtInBalShtCrcy,
      BPBalSheetTotalAmtInBalShtCrcy,
      BPNumberOfEmployees,
      BPCptlReserveAmtInBalShtCrcy,
      BPLglRevnRsrvAmtInBalShtCrcy,
      RevnRsrvOwnStkAmtInBalShtCrcy,
      BPStatryReserveAmtInBalShtCrcy,
      BPOthRevnRsrvAmtInBalShtCrcy,
      BPPnLCarryfwdAmtInBalShtCrcy,
      BPSuborddLbltyAmtInBalShtCrcy,
      BPRetOnTotalCptlEmpldInPercent,
      BPDebtClearancePeriodInYears,
      BPFinancingCoeffInPercent,
      BPEquityRatioInPercent,
      MDChgProcSrceLastChgdDateTime,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,

      /* Record Identification */
      /* Has been moved to a virtual field in the projection layer, therefore the dummy entry */
      cast( '' as abap.char(209) )                                                   as AddressLine1Text,

      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified preserving type ) as MDChgProcKPIUpdateStatus,

      _BusinessPartner,
      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages
}

Learn More