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_FiscalYearChangeDocumentWST.
-- 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.
-- SQL view name: CFYCNGDWST
CREATE VIEW C_FiscalYearChangeDocumentWST AS
SELECT
CommitmentCarryForwardDocument,
FinancialManagementArea,
ReceiverFinMgmtAreaFiscalYear,
ReferenceDocument,
ReferenceDocumentContext,
FundsMgmtReferenceDocumentItem AS ReferenceDocumentItem,
RefDocAccountAssignment,
FundsMgmtRefDocScheduleLine AS ReferenceDocumentScheduleLine,
RefDocPricingElementContent,
ReferenceDocumentLogicalSystem,
ReferenceDocumentType,
CompanyCode,
OriginAccountingDocFiscalYear,
FundsManagementDocument,
FundsManagementDocumentItem,
FundsMgmtTransactionNumber,
SenderPostedFund,
cast( _SenderFund.FundName as fmis_sender_fund preserving type ) AS SenderPostedFundName,
cast( concat_with_space(SenderPostedFund, _SenderFund.FundName, 1) as fmis_sender_fundextendedname preserving type ) AS SenderPostedFundExtendedName,
SenderPostedBudgetPeriod,
cast( _SenderBPText.BudgetPeriodName as fm_sender_budget_period_name preserving type ) AS SenderPostedBudgetPeriodName,
cast( concat_with_space(SenderPostedBudgetPeriod, _SenderBPText.BudgetPeriodName, 1) as fmis_sender_budperextendedname preserving type ) AS SenderPostedBdgtPeriodExtdName,
SenderPostedFundsCenter,
cast( _SenderFundsCenter.FundsCenterName as fmis_sender_fundscenter preserving type ) AS SenderPostedFundsCenterName,
cast( concat_with_space(SenderPostedFundsCenter, _SenderFundsCenter.FundsCenterName, 1) as fmis_sender_fundscenterextname preserving type ) AS SenderPostedFndsCtrExtdName,
SenderPostedCommitmentItem,
cast( _SenderCommitmentItem.CommitmentItemName as fmis_sndr_commitment_item_name preserving type ) AS SenderPostedCommitmentItemName,
cast( concat_with_space(SenderPostedCommitmentItem, _SenderCommitmentItem.CommitmentItemName, 1) as fmis_sender_commititemextname preserving type ) AS SenderPostedCmtmtItmExtdName,
SenderPostedFunctionalArea,
cast( _SenderFuncAreaText.FunctionalAreaName as fmis_sender_funcarea preserving type ) AS SenderPostedFunctionalAreaName,
cast( concat_with_space(SenderPostedFunctionalArea, _SenderFuncAreaText.FunctionalAreaName, 1) as fmis_sender_funcareaextname preserving type ) AS SenderPostedFuncnlAreaExtdName,
SenderPostedFundedProgram,
cast( _SenderFundedProgramText.FundedProgramName as fmis_sender_fp_name preserving type ) AS SenderPostedFundedProgramName,
cast( concat_with_space(SenderPostedFundedProgram, _SenderFundedProgramText.FundedProgramName, 1) as fmis_sender_fndprgextendedname preserving type ) AS SenderPostedFundedPgmExtdName,
SenderPostedGrantId,
cast( _SenderGrantText.GrantName as gmis_sender_grant_nbr_name preserving type ) AS SenderPostedGrantName,
cast( concat_with_space(SenderPostedGrantId, _SenderGrantText.GrantName, 1) as fmis_sender_grantextendedname preserving type ) AS SenderPostedGrantExtendedName,
SenderFinMgmtAreaFiscalYear,
ReceiverPostedFund,
cast( _ReceiverFund.FundName as fmis_receiver_fund preserving type ) AS ReceiverPostedFundName,
cast( concat_with_space(ReceiverPostedFund, _ReceiverFund.FundName, 1) as fmis_rcvr_fundextendedname preserving type ) AS ReceiverPostedFundExtendedName,
ReceiverPostedBudgetPeriod,
cast( _ReceiverBPText.BudgetPeriodName as fm_receiver_budget_period_name preserving type ) AS ReceiverPostedBudgetPeriodName,
cast( concat_with_space(ReceiverPostedBudgetPeriod, _ReceiverBPText.BudgetPeriodName, 1) as fmis_rcvr_budperextendedname preserving type ) AS RcvrPostedBudgetPerdExtdName,
ReceiverPostedFundsCenter,
cast( _ReceiverFundsCenter.FundsCenterName as fmis_receiver_fundscenter preserving type ) AS ReceiverPostedFundsCenterName,
cast( concat_with_space(ReceiverPostedFundsCenter, _ReceiverFundsCenter.FundsCenterName, 1) as fmis_rcvr_fundscenterextname preserving type ) AS ReceiverPostedFndsCtrExtdName,
ReceiverPostedCommitmentItem,
cast( _ReceiverCommitmentItem.CommitmentItemName as fmis_rcvr_commitment_item_name preserving type ) AS ReceiverPostedCmtmtItemName,
cast( concat_with_space(ReceiverPostedCommitmentItem, _ReceiverCommitmentItem.CommitmentItemName, 1) as fmis_rcvr_commititemextname preserving type ) AS ReceiverPostedCmtmtItmExtdName,
ReceiverPostedFunctionalArea,
cast( _ReceiverFuncAreaText.FunctionalAreaName as fmis_receiver_funcarea preserving type ) AS ReceiverPostedFuncnlAreaName,
cast( concat_with_space(ReceiverPostedFunctionalArea, _ReceiverFuncAreaText.FunctionalAreaName, 1) as fmis_rcvr_funcareaextname preserving type ) AS RcvrPostedFuncnlAreaExtdName,
ReceiverPostedFundedProgram,
cast( _ReceiverFundedProgramText.FundedProgramName as fmis_receiver_fp_name preserving type ) AS ReceiverPostedFundedPgmName,
cast( concat_with_space(ReceiverPostedFundedProgram, _ReceiverFundedProgramText.FundedProgramName, 1) as fmis_rcvr_fndprgextendedname preserving type ) AS RcvrPostedFundedPgmExtdName,
ReceiverPostedGrantId,
cast( _ReceiverGrantText.GrantName as gmis_receiver_grant_nbr_name preserving type ) AS ReceiverPostedGrantName,
cast( concat_with_space(ReceiverPostedGrantId, _ReceiverGrantText.GrantName, 1) as fmis_rcvr_grantextendedname ) AS ReceiverPostedGrantExtdName,
ReceiverLedger,
CreatedByUser,
CreationDate,
CreationTime,
coalesce( _FundsMgmtCommitmentEntryItem.TransactionCurrency, _FundsManagementDocumentItem.TransactionCurrency ) AS TransactionCurrency,
coalesce( _FundsMgmtCommitmentEntryItem.PostedAmountInTransCrcy, _FundsManagementDocumentItem.PostedAmountInTransCrcy ) AS PostedAmountInTransCrcy,
coalesce( _FundsMgmtCommitmentEntryItem.FinancialManagementAreaCrcy, _FundsManagementDocumentItem.FinancialManagementAreaCrcy ) AS FinancialManagementAreaCrcy,
coalesce( _FundsMgmtCommitmentEntryItem.PostedAmountInFMACrcy, _FundsManagementDocumentItem.PostedAmountInFMACrcy ) AS PostedAmountInFMACrcy,
I_FundsMgmtCarryFwdDocument.SenderLedger AS SenderLedger
FROM I_FundsMgmtCarryFwdDocument
LEFT OUTER JOIN C_FundWST AS _SenderFund ON FinancialManagementArea = _SenderFund.FinancialManagementArea AND SenderPostedFund = _SenderFund.Fund -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _SenderBPText ON SenderPostedBudgetPeriod = _SenderBPText.BudgetPeriod AND _SenderBPText.Language = $session.system_language -- association [1..1]
LEFT OUTER JOIN C_FundsCenterWST AS _SenderFundsCenter ON FinancialManagementArea = _SenderFundsCenter.FinancialManagementArea AND SenderPostedFundsCenter = _SenderFundsCenter.FundsCenter AND CreationDate <= _SenderFundsCenter.ValidityEndDate AND CreationDate > _SenderFundsCenter.ValidityStartDate -- association [1..1]
LEFT OUTER JOIN C_CommitmentItemWST AS _SenderCommitmentItem ON FinancialManagementArea = _SenderCommitmentItem.FinancialManagementArea AND SenderPostedCommitmentItem = _SenderCommitmentItem.CommitmentItem AND SenderFinMgmtAreaFiscalYear = _SenderCommitmentItem.FinMgmtAreaFiscalYear -- association [1..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _SenderFuncAreaText ON _SenderFuncAreaText.Language = $session.system_language AND SenderPostedFunctionalArea = _SenderFuncAreaText.FunctionalArea -- association [1..1]
LEFT OUTER JOIN I_FundedProgramText AS _SenderFundedProgramText ON FinancialManagementArea = _SenderFundedProgramText.FinancialManagementArea AND SenderPostedFundedProgram = _SenderFundedProgramText.FundedProgram AND _SenderFundedProgramText.Language = $session.system_language -- association [1..1]
LEFT OUTER JOIN I_GrantText AS _SenderGrantText ON SenderPostedGrantId = _SenderGrantText.GrantID AND _SenderGrantText.Language = $session.system_language -- association [1..1]
LEFT OUTER JOIN C_FundWST AS _ReceiverFund ON FinancialManagementArea = _ReceiverFund.FinancialManagementArea AND ReceiverPostedFund = _ReceiverFund.Fund -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _ReceiverBPText ON ReceiverPostedBudgetPeriod = _ReceiverBPText.BudgetPeriod AND _ReceiverBPText.Language = $session.system_language -- association [1..1]
LEFT OUTER JOIN C_FundsCenterWST AS _ReceiverFundsCenter ON FinancialManagementArea = _ReceiverFundsCenter.FinancialManagementArea AND ReceiverPostedFundsCenter = _ReceiverFundsCenter.FundsCenter AND CreationDate <= _ReceiverFundsCenter.ValidityEndDate AND CreationDate > _ReceiverFundsCenter.ValidityStartDate -- association [1..1]
LEFT OUTER JOIN C_CommitmentItemWST AS _ReceiverCommitmentItem ON FinancialManagementArea = _ReceiverCommitmentItem.FinancialManagementArea AND ReceiverPostedCommitmentItem = _ReceiverCommitmentItem.CommitmentItem AND ReceiverFinMgmtAreaFiscalYear = _ReceiverCommitmentItem.FinMgmtAreaFiscalYear -- association [1..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _ReceiverFuncAreaText ON _ReceiverFuncAreaText.Language = $session.system_language AND ReceiverPostedFunctionalArea = _ReceiverFuncAreaText.FunctionalArea -- association [1..1]
LEFT OUTER JOIN I_FundedProgramText AS _ReceiverFundedProgramText ON FinancialManagementArea = _ReceiverFundedProgramText.FinancialManagementArea AND ReceiverPostedFundedProgram = _ReceiverFundedProgramText.FundedProgram AND _ReceiverFundedProgramText.Language = $session.system_language -- association [1..1]
LEFT OUTER JOIN I_GrantText AS _ReceiverGrantText ON ReceiverPostedGrantId = _ReceiverGrantText.GrantID AND _ReceiverGrantText.Language = $session.system_language -- association [1..1]
LEFT OUTER JOIN I_FundsMgmtCommitmentEntryItem AS _FundsMgmtCommitmentEntryItem ON FinancialManagementArea = _FundsMgmtCommitmentEntryItem.FinancialManagementArea AND ReceiverFinMgmtAreaFiscalYear = _FundsMgmtCommitmentEntryItem.FinMgmtAreaFiscalYear AND ReferenceDocument = _FundsMgmtCommitmentEntryItem.ReferenceDocument AND ReferenceDocumentType = _FundsMgmtCommitmentEntryItem.ReferenceDocumentType AND ReferenceDocumentContext = _FundsMgmtCommitmentEntryItem.ReferenceDocumentContext AND ReferenceDocumentItem = _FundsMgmtCommitmentEntryItem.FundsMgmtReferenceDocumentItem AND RefDocAccountAssignment = _FundsMgmtCommitmentEntryItem.RefDocAccountAssignment AND ReferenceDocumentScheduleLine = _FundsMgmtCommitmentEntryItem.FundsMgmtRefDocScheduleLine AND RefDocPricingElementContent = _FundsMgmtCommitmentEntryItem.RefDocPricingElementContent AND ReferenceDocumentType = _FundsMgmtCommitmentEntryItem.ReferenceDocumentType AND ReferenceDocumentLogicalSystem = _FundsMgmtCommitmentEntryItem.ReferenceDocumentLogicalSystem AND ReceiverLedger = _FundsMgmtCommitmentEntryItem.Ledger AND FundsMgmtTransactionNumber = _FundsMgmtCommitmentEntryItem.FundsMgmtTransactionNumber AND _FundsMgmtCommitmentEntryItem.FundsMgmtAmountType = '0350' AND ReferenceDocumentType <> ' ' -- association [0..*]
LEFT OUTER JOIN I_FundsManagementDocumentItem AS _FundsManagementDocumentItem ON FundsManagementDocument = _FundsManagementDocumentItem.FundsManagementDocument AND FinancialManagementArea = _FundsManagementDocumentItem.FinancialManagementArea AND FundsManagementDocumentItem = _FundsManagementDocumentItem.FundsManagementDocumentItem AND ReceiverFinMgmtAreaFiscalYear = _FundsManagementDocumentItem.FinMgmtAreaFiscalYear AND ReceiverLedger = _FundsManagementDocumentItem.Ledger AND _FundsManagementDocumentItem.FundsMgmtAmountType = '0350' AND ReferenceDocumentType = ' ' -- association [0..*]
;