I_FundsMgmtCmtmtEntryItemBasic

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_FundsMgmtCmtmtEntryItemBasic.
-- 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: IFMIOIB

CREATE VIEW I_FundsMgmtCmtmtEntryItemBasic AS
SELECT
  fmioi.refbn AS ReferenceDocument,
  fmioi.refbt AS FundsMgmtRefDocumentCategory,
  fmioi.rforg AS ReferenceDocumentContext,
  fmioi.rfpos AS FundsMgmtReferenceDocumentItem,
  fmioi.rfknt AS RefDocAccountAssignment,
  fmioi.rfete AS FundsMgmtRefDocScheduleLine,
  fmioi.rcond AS RefDocPricingElementContent,
  fmioi.rftyp AS ReferenceDocumentType,
  cast( fmioi.rfsys as fis_awsys preserving type ) AS ReferenceDocumentLogicalSystem,
  fmioi.btart AS FundsMgmtAmountType,
  fmioi.rldnr AS Ledger,
  fmioi.gjahr AS FinMgmtAreaFiscalYear,
  fmioi.stunr AS FundsMgmtSequenceNumber,
  fmioi.gnjhr AS CashEffectivityFiscalYear,
  fmioi.perio AS FinMgmtAreaPeriod,
  fmioi.tranr AS FundsMgmtTransactionNumber,
  fmioi.erlkz AS FundsMgmtCmtmtItemIsCompleted,
  fmioi.loekz AS FundsMgmtCmtmtItemIsDeleted,
  fmioi.twaer AS TransactionCurrency,
  fmioi.trbtr AS PostedAmountInTransCrcy,
  _FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  fmioi.fkbtr AS PostedAmountInFMACrcy,
  fmioi.fikrs AS FinancialManagementArea,
  cast (fmioi.fistl as fmis_posted_funds_center) AS PostedFundsCenter,
  cast (fmioi.fonds as fmis_posted_fund) AS PostedFund,
  cast (fmioi.fipex as fmis_posted_cmtmt_item) AS PostedCommitmentItem,
  cast (fmioi.farea as fmis_posted_functional_area) AS PostedFunctionalArea,
  cast (fmioi.measure as fmis_posted_funded_program) AS PostedFundedProgram,
  cast (fmioi.grant_nbr as fmis_posted_grant_nbr) AS PostedGrantID,
  cast (budget_pd as fmis_posted_budget_period) AS PostedBudgetPeriod,
  cast (fmioi.userdim as fmis_posted_userdim) AS PostedFundsMgmtCustomerField,
  fmioi.bus_area AS BusinessArea,
  fmioi.bukrs AS CompanyCode,
  fmioi.hkont AS GLAccount,
  fmioi.wrttp AS FundsMgmtValueType,
  fmioi.vrgng AS BusinessTransactionType,
  fmioi.stats AS IsStatisticalItem,
  fmioi.stats AS FundsManagementStatisticalType,
  fmioi.cflev AS FundsMgCarryForwardLevel,
  fmioi.cfstat AS FundsMgmtCmtmtCarryFwdStatus,
  fmioi.zhldt AS FundsMgmtUpdateDate,
  fmioi.objnrz AS FundsMgmtObjectNumber,
  fmioi.lifnr AS Supplier,
  fmioi.prctr AS ProfitCenter,
  fmioi.segment AS Segment,
  _CompanyCode.ControllingArea AS ControllingArea,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear
FROM fmioi
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON ReferenceDocumentLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON PostedBudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND PostedFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND PostedCommitmentItem = _CommitmentItem.CommitmentItem AND ( FinMgmtAreaFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear OR _CommitmentItem.FinMgmtAreaFiscalYear = '0000' )  -- association [1..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem1 ON FinancialManagementArea = _CommitmentItem1.FinancialManagementArea AND PostedCommitmentItem = _CommitmentItem1.CommitmentItem AND CommitmentItemFiscalYear = _CommitmentItem1.FinMgmtAreaFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND PostedFundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_Grant AS _Grant ON PostedGrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND PostedFundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON PostedFunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FinMgmtFiscalYear ON FinancialManagementArea = _FinMgmtFiscalYear.FinancialManagementArea AND CommitmentItemFiscalYear = _FinMgmtFiscalYear.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON ReferenceDocument = _PurchasingDocumentItem.PurchasingDocument AND FundsMgmtReferenceDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_PurgDocAccountAssignment AS _PurgDocAccountAssignment ON ReferenceDocument = _PurgDocAccountAssignment.PurchasingDocument AND FundsMgmtReferenceDocumentItem = _PurgDocAccountAssignment.PurchasingDocumentItem AND AccountAssignmentNumber = _PurgDocAccountAssignment.AccountAssignmentNumber  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FinancialManagementAreaCrcy ON FinancialManagementAreaCrcy = _FinancialManagementAreaCrcy.Currency  -- association [0..1]
;