I_CmtmtCarryForwardLotItem

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_CmtmtCarryForwardLotItem.
-- 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: IFMFYCLTI

CREATE VIEW I_CmtmtCarryForwardLotItem AS
SELECT
  fikrs AS FinancialManagementArea,
  syear AS SenderFinMgmtAreaFiscalYear,
  cflotnr AS CommitmentCarryForwardLot,
  indexcnt AS CommitmentCarryForwardLotItem,
  refbn AS ReferenceDocument,
  refbt AS FundsMgmtRefDocumentCategory,
  rforg AS ReferenceDocumentContext,
  rfpos AS FundsMgmtReferenceDocumentItem,
  rfknt AS RefDocAccountAssignment,
  rfete AS FundsMgmtRefDocScheduleLine,
  rcond AS RefDocPricingElementContent,
  rftyp AS ReferenceDocumentType,
  rfsys AS ReferenceDocumentLogicalSystem,
  fmbelnr AS FundsManagementDocument,
  fmbuzei AS FundsManagementDocumentItem,
  bukrs AS CompanyCode,
  kngjahr AS OriginAccountingDocFiscalYear,
  sledger AS SenderLedger,
  wrttp AS FundsMgmtValueType,
  cfstat AS FundsMgmtCarryForwardStatus,
  cfcnt AS FundsMgCarryForwardCounter,
  rgrant AS ReceiverPostedGrantId,
  rfonds AS ReceiverPostedFund,
  rfistl AS ReceiverPostedFundsCenter,
  rfipex AS ReceiverPostedCommitmentItem,
  rfarea AS ReceiverPostedFunctionalArea,
  rmeasure AS ReceiverPostedFundedProgram,
  rbudget_pd AS ReceiverPostedBudgetPeriod,
  sgrant AS SenderPostedGrantId,
  sfonds AS SenderPostedFund,
  sfistl AS SenderPostedFundsCenter,
  sfipex AS SenderPostedCommitmentItem,
  sfarea AS SenderPostedFunctionalArea,
  smeasure AS SenderPostedFundedProgram,
  sbudget_pd AS SenderPostedBudgetPeriod,
  cfdocnr AS CommitmentCarryForwardDocument,
  cfdocnr_pred AS CmtmtCarryFwdDocPredecessor,
  cfdocnr_root AS CmtmtCarryForwardDocumentRoot,
  chain_vt_level AS CmtmtCarryFwdAdjmtValueType,
  flg_root AS CmtmtCarryFwdDocumentIsRoot,
  _FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  fkbtr AS CmtmtCarryFwdAmtInFMACrcy,
  trbtr AS CmtmtCarryFwdAmtInTransCrcy,
  fktbtr AS CmtmtCarryFwdTotAmtInFMACrcy,
  trtbtr AS CmtmtCarryFwdTotAmtInTransCrcy,
  twaer AS TransactionCurrency,
  erlkz AS FundsMgmtCmtmtItemIsCompleted,
  stats AS FundsManagementStatisticalType,
  suserdim AS SenderPostedFundsMgmtCustField,
  ruserdim AS ReceiverPostedFundsMgmtCustFld
FROM fmccflot
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN E_CmtmtCarryForwardLotItem AS _Extension ON FinancialManagementArea = _Extension.FinancialManagementArea AND SenderFinMgmtAreaFiscalYear = _Extension.SenderFinMgmtAreaFiscalYear AND CommitmentCarryForwardLot = _Extension.CommitmentCarryForwardLot AND CommitmentCarryForwardLotItem = _Extension.CommitmentCarryForwardLotItem  -- association [1..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]
;