I_CmtmtCarryForwardLotCube

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_CmtmtCarryForwardLotCube.
-- 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: ICCFLOTANC

CREATE VIEW I_CmtmtCarryForwardLotCube AS
SELECT
  FinancialManagementArea,
  SenderFinMgmtAreaFiscalYear,
  CommitmentCarryForwardLot,
  CommitmentCarryForwardLotItem,
  _CommitmentCarryForwardLot.CmtmtCarryForwardApprovalStep AS CmtmtCarryForwardApprovalStep,
  _CommitmentCarryForwardLot.CmtmtCarryFwdLotIsCompleted AS CmtmtCarryFwdLotIsCompleted,
  _CommitmentCarryForwardLot.CreationDate AS CreationDate,
  _CommitmentCarryForwardLot.CreationTime AS CreationTime,
  _CommitmentCarryForwardLot.CreatedByUser AS CreatedByUser,
  _CommitmentCarryForwardLot.CmtmtCarryFwdApprvlCmtmtDate AS CmtmtCarryFwdApprvlCmtmtDate,
  _CommitmentCarryForwardLot.CmtmtCarryFwdApprvlCmtmtTime AS CmtmtCarryFwdApprvlCmtmtTime,
  _CommitmentCarryForwardLot.CarryFwdApprvlCmtmtCrtedByUser AS CarryFwdApprvlCmtmtCrtedByUser,
  _CommitmentCarryForwardLot.CarryFwdApprvlBdgtForCmtmtDate AS CarryFwdApprvlBdgtForCmtmtDate,
  _CommitmentCarryForwardLot.CarryFwdApprvlBdgtForCmtmtTime AS CarryFwdApprvlBdgtForCmtmtTime,
  _CommitmentCarryForwardLot.ApprvlBdgtForCmtmtCrtedByUser AS ApprvlBdgtForCmtmtCrtedByUser,
  _CommitmentCarryForwardLot.CmtmtCarryFwdLotDescription AS CmtmtCarryFwdLotDescription,
  _CommitmentCarryForwardLot.ZeroCmtmtCarryFwdSts AS ZeroCmtmtCarryFwdSts,
  ReferenceDocument,
  FundsMgmtRefDocumentCategory,
  ReferenceDocumentContext,
  FundsMgmtReferenceDocumentItem,
  RefDocAccountAssignment,
  FundsMgmtRefDocScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentType,
  ReferenceDocumentLogicalSystem,
  FundsManagementDocument,
  FundsManagementDocumentItem,
  CompanyCode,
  OriginAccountingDocFiscalYear,
  SenderLedger,
  FundsMgmtValueType,
  FundsMgmtCarryForwardStatus,
  FundsMgCarryForwardCounter,
  ReceiverPostedGrantId,
  ReceiverPostedFund,
  ReceiverPostedFundsCenter,
  ReceiverPostedCommitmentItem,
  ReceiverPostedFunctionalArea,
  ReceiverPostedFundedProgram,
  ReceiverPostedBudgetPeriod,
  SenderPostedGrantId,
  SenderPostedFund,
  SenderPostedFundsCenter,
  SenderPostedCommitmentItem,
  SenderPostedFunctionalArea,
  SenderPostedFundedProgram,
  SenderPostedBudgetPeriod,
  CommitmentCarryForwardDocument,
  CmtmtCarryFwdDocPredecessor,
  CmtmtCarryForwardDocumentRoot,
  CmtmtCarryFwdAdjmtValueType,
  CmtmtCarryFwdDocumentIsRoot,
  CmtmtCarryFwdAmtInFMACrcy,
  CmtmtCarryFwdAmtInTransCrcy,
  CmtmtCarryFwdTotAmtInFMACrcy,
  CmtmtCarryFwdTotAmtInTransCrcy,
  TransactionCurrency,
  _FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  FundsMgmtCmtmtItemIsCompleted,
  FundsManagementStatisticalType,
  SenderPostedFundsMgmtCustField,
  ReceiverPostedFundsMgmtCustFld
FROM I_CmtmtCarryForwardLotItem
LEFT OUTER JOIN I_CommitmentCarryForwardLot AS _CommitmentCarryForwardLot ON CommitmentCarryForwardLot = _CommitmentCarryForwardLot.CommitmentCarryForwardLot AND FinancialManagementArea = _CommitmentCarryForwardLot.FinancialManagementArea AND SenderFinMgmtAreaFiscalYear = _CommitmentCarryForwardLot.SenderFinMgmtAreaFiscalYear  -- association [1..1]
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 SenderPostedCommitmentItem = _SenderCommitmentItem.CommitmentItem AND CommitmentItemFiscalYear = _SenderCommitmentItem.FinMgmtAreaFiscalYear  -- 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]
;