C_BPFiscalYearProcessTP

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 C_BPFiscalYearProcessTP.
-- 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.

CREATE VIEW C_BPFiscalYearProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BusinessPartner,
  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,
  virtual SourceSystem : abap.sstring( 260 ) AS sstring260,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType,
  _BusinessPartner._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _BusinessPartner.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcKPIUpdateStatus,
  virtual MDChangeProcessMessageType : symsgty AS virtualMDChangeProcessMessageTypesymsgty,
  virtual MDChangeProcessMessageID : msgid AS virtualMDChangeProcessMessageIDmsgid,
  virtual MDChangeProcessMessageNumber : msgno AS virtualMDChangeProcessMessageNumbermsgno,
  _BusinessPartner.MDChgProcessActivationTarget AS MDChgProcessActivationTarget,
  _BusinessPartner._RecordTargetText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTargetText,
  _BusinessPartner.MDChgProcessReplicationStatus AS MDChgProcessReplicationStatus,
  _BusinessPartner._ReplicationStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcReplicationStatusText
FROM I_BPFiscalYearProcessTP
LEFT OUTER JOIN C_BPFiscalYearProcessChanges AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND BusinessPartner = _Changes.BusinessPartner AND BusinessPartnerFiscalYear = _Changes.BusinessPartnerFiscalYear AND _Changes.MDChgProcessSourceModified = 'X'  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '147'  -- association [0..1]
;