I_CmtmtCarryForwardDocument

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 I_CmtmtCarryForwardDocument.
-- 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: ICMMTCCFDOC

CREATE VIEW I_CmtmtCarryForwardDocument AS
SELECT
  ccf.CommitmentCarryForwardDocument AS CommitmentCarryForwardDocument,
  ccf.FinancialManagementArea AS FinancialManagementArea,
  ccf.ReceiverFinMgmtAreaFiscalYear AS ReceiverFinMgmtAreaFiscalYear,
  ccf.FundsMgmtRefDocumentCategory AS FundsMgmtRefDocumentCategory,
  ccf.FundsMgmtCarryBackStatus AS FundsMgmtCarryBackStatus,
  ccf.FundsMgCarryBackRefDocument AS FundsMgCarryBackRefDocument,
  ccf.ReferenceDocument AS ReferenceDocument,
  ccf.ReferenceDocumentContext AS ReferenceDocumentContext,
  ccf.FundsMgmtReferenceDocumentItem AS FundsMgmtReferenceDocumentItem,
  ccf.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  ccf.RefDocAccountAssignment AS RefDocAccountAssignment,
  ccf.FundsMgmtRefDocScheduleLine AS FundsMgmtRefDocScheduleLine,
  ccf.RefDocPricingElementContent AS RefDocPricingElementContent,
  ccf.ReferenceDocumentType AS ReferenceDocumentType,
  ccf.CompanyCode AS CompanyCode,
  ccf.OriginAccountingDocFiscalYear AS OriginAccountingDocFiscalYear,
  ccf.FundsManagementDocument AS FundsManagementDocument,
  ccf.FundsMgmtValueType AS FundsMgmtValueType,
  ccf.FundsManagementDocumentItem AS FundsManagementDocumentItem,
  ccf.SenderLedger AS SenderLedger,
  ccf.SenderPostedFund AS SenderPostedFund,
  ccf.SenderPostedBudgetPeriod AS SenderPostedBudgetPeriod,
  ccf.SenderPostedFundsCenter AS SenderPostedFundsCenter,
  ccf.SenderPostedCommitmentItem AS SenderPostedCommitmentItem,
  ccf.SenderPostedFunctionalArea AS SenderPostedFunctionalArea,
  ccf.SenderPostedFundedProgram AS SenderPostedFundedProgram,
  ccf.SenderPostedGrantId AS SenderPostedGrantId,
  ccf.SenderPostedFundsMgmtCustField AS SenderPostedFundsMgmtCustField,
  ccf.SenderFinMgmtAreaFiscalYear AS SenderFinMgmtAreaFiscalYear,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  ccf.ReceiverLedger AS ReceiverLedger,
  ccf.ReceiverPostedFund AS ReceiverPostedFund,
  ccf.ReceiverPostedBudgetPeriod AS ReceiverPostedBudgetPeriod,
  ccf.ReceiverPostedFundsCenter AS ReceiverPostedFundsCenter,
  ccf.ReceiverPostedCommitmentItem AS ReceiverPostedCommitmentItem,
  ccf.ReceiverPostedFunctionalArea AS ReceiverPostedFunctionalArea,
  ccf.ReceiverPostedFundedProgram AS ReceiverPostedFundedProgram,
  ccf.ReceiverPostedGrantId AS ReceiverPostedGrantId,
  ccf.ReceiverPostedFundsMgmtCustFld AS ReceiverPostedFundsMgmtCustFld,
  _BudgetEntryDocument.BudgetEntryDocument AS BudgetEntryDocument,
  ccf.FundsMgmtTransactionNumber AS FundsMgmtTransactionNumber,
  ccf.CreatedByUser AS CreatedByUser,
  ccf.CreationDate AS CreationDate,
  ccf.CreationTime AS CreationTime,
  ccf.FundsMgCarryForwardLevel AS FundsMgCarryForwardLevel,
  ccf.FundsMgCarryForwardCounter AS FundsMgCarryForwardCounter,
  ccf.FsclYrChgDocHasFollowOnDoc AS FsclYrChgDocHasFollowOnDoc,
  ccf.FundsMgmtCarryFwdBudgetStatus AS FundsMgmtCarryFwdBudgetStatus
FROM I_FundsMgmtCarryFwdDocument AS ccf
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND SenderFinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FinMgmtFiscalYear ON FinancialManagementArea = _FinMgmtFiscalYear.FinancialManagementArea AND CommitmentItemFiscalYear = _FinMgmtFiscalYear.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_Fund AS _SenderFund ON FinancialManagementArea = _SenderFund.FinancialManagementArea AND SenderPostedFund = _SenderFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _SenderCommitmentItem ON FinancialManagementArea = _SenderCommitmentItem.FinancialManagementArea AND CommitmentItemFiscalYear = _SenderCommitmentItem.FinMgmtAreaFiscalYear AND SenderPostedCommitmentItem = _SenderCommitmentItem.CommitmentItem  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _SenderBudgetPeriod ON SenderPostedBudgetPeriod = _SenderBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _SenderFunctionalArea ON SenderPostedFunctionalArea = _SenderFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _SenderFundedProgram ON FinancialManagementArea = _SenderFundedProgram.FinancialManagementArea AND SenderPostedFundedProgram = _SenderFundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _SenderFundsCenter ON FinancialManagementArea = _SenderFundsCenter.FinancialManagementArea AND SenderPostedFundsCenter = _SenderFundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_Grant AS _SenderGrant ON SenderPostedGrantId = _SenderGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _ReceiverFund ON FinancialManagementArea = _ReceiverFund.FinancialManagementArea AND ReceiverPostedFund = _ReceiverFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _ReceiverCommitmentItem ON FinancialManagementArea = _ReceiverCommitmentItem.FinancialManagementArea AND ReceiverPostedCommitmentItem = _ReceiverCommitmentItem.CommitmentItem AND CommitmentItemFiscalYear = _ReceiverCommitmentItem.FinMgmtAreaFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _ReceiverBudgetPeriod ON ReceiverPostedBudgetPeriod = _ReceiverBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _ReceiverFunctionalArea ON ReceiverPostedFunctionalArea = _ReceiverFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _ReceiverFundedProgram ON FinancialManagementArea = _ReceiverFundedProgram.FinancialManagementArea AND ReceiverPostedFundedProgram = _ReceiverFundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _ReceiverFundsCenter ON FinancialManagementArea = _ReceiverFundsCenter.FinancialManagementArea AND ReceiverPostedFundsCenter = _ReceiverFundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_Grant AS _ReceiverGrant ON ReceiverPostedGrantId = _ReceiverGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON FinancialManagementAreaCrcy = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtCommitmentEntryItem AS _CommitmentDocument ON ReferenceDocument = _CommitmentDocument.ReferenceDocument AND ReferenceDocumentContext = _CommitmentDocument.ReferenceDocumentContext AND FundsMgmtReferenceDocumentItem = _CommitmentDocument.FundsMgmtReferenceDocumentItem AND RefDocAccountAssignment = _CommitmentDocument.RefDocAccountAssignment AND FundsMgmtRefDocScheduleLine = _CommitmentDocument.FundsMgmtRefDocScheduleLine AND RefDocPricingElementContent = _CommitmentDocument.RefDocPricingElementContent AND ReferenceDocumentType = _CommitmentDocument.ReferenceDocumentType AND FundsMgmtTransactionNumber = _CommitmentDocument.FundsMgmtTransactionNumber AND FundsManagementDocument is initial  -- association [0..*]
LEFT OUTER JOIN I_FundsManagementDocumentItem AS _ActualsDocument ON ReferenceDocument = _ActualsDocument.FundsMgmtFinDocNumber AND OriginAccountingDocFiscalYear = _ActualsDocument.FundsMgmtFinDocFiscalYear AND CompanyCode = _ActualsDocument.CompanyCode AND FundsMgmtTransactionNumber = _ActualsDocument.FundsMgmtTransactionNumber AND FundsManagementDocument is not initial  -- association [0..*]
LEFT OUTER JOIN I_BudgetEntryDocument AS _BudgetEntryDocument ON CommitmentCarryForwardDocument = _BudgetEntryDocument.ReferenceDocument AND FinancialManagementArea = _BudgetEntryDocument.FinancialManagementArea AND ReceiverFinMgmtAreaFiscalYear = _BudgetEntryDocument.BudgetDocumentYear AND _BudgetEntryDocument.ReferenceDocumentType = 'FMCCF' AND FsclYrChgDocHasFollowOnDoc = 'X'  -- association [0..1]
LEFT OUTER JOIN E_CmtmtCarryFwdDoc AS _Extension ON CommitmentCarryForwardDocument = _Extension.CommitmentCarryForwardDocument AND FinancialManagementArea = _Extension.FinancialManagementArea AND ReceiverFinMgmtAreaFiscalYear = _Extension.ReceiverFinMgmtAreaFiscalYear  -- association [1..1]
;