I_CommitmentCarryForwardLot

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_CommitmentCarryForwardLot.
-- 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: IFMFYCLTH

CREATE VIEW I_CommitmentCarryForwardLot AS
SELECT
  CommitmentCarryForwardLot.fikrs AS FinancialManagementArea,
  CommitmentCarryForwardLot.syear AS SenderFinMgmtAreaFiscalYear,
  CommitmentCarryForwardLot.cflotnr AS CommitmentCarryForwardLot,
  CommitmentCarryForwardLot.cpudt_sel AS CreationDate,
  CommitmentCarryForwardLot.cputm_sel AS CreationTime,
  CommitmentCarryForwardLot.uname_sel AS CreatedByUser,
  cast (CommitmentCarryForwardLot.cpudt_ap_ccf as fm_ccf_cpudt_app_oi ) AS CmtmtCarryFwdApprvlCmtmtDate,
  cast ( CommitmentCarryForwardLot.cputm_ap_ccf as fm_ccf_cputm_app_oi ) AS CmtmtCarryFwdApprvlCmtmtTime,
  cast (CommitmentCarryForwardLot.uname_ap_ccf as fm_ccf_uname_app_oi ) AS CarryFwdApprvlCmtmtCrtedByUser,
  cast (CommitmentCarryForwardLot.cpudt_ap_bud as fm_ccf_cpudt_app_bud ) AS CarryFwdApprvlBdgtForCmtmtDate,
  cast (CommitmentCarryForwardLot.cputm_ap_bud as fm_ccf_cputm_app_bud ) AS CarryFwdApprvlBdgtForCmtmtTime,
  CommitmentCarryForwardLot.uname_ap_bud AS ApprvlBdgtForCmtmtCrtedByUser,
  CommitmentCarryForwardLot.memo AS CmtmtCarryFwdLotDescription,
  CommitmentCarryForwardLot.zero AS ZeroCmtmtCarryFwdSts
FROM fmccflothd AS CommitmentCarryForwardLot
INNER JOIN fmfycc AS CommitmentCarryForwardSetting ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN E_CommitmentCarryForwardLot AS _Extension ON FinancialManagementArea = _Extension.FinancialManagementArea AND SenderFinMgmtAreaFiscalYear = _Extension.SenderFinMgmtAreaFiscalYear AND CommitmentCarryForwardLot = _Extension.CommitmentCarryForwardLot  -- association [1..1]
;