I_FndsMAcctAssgmtDerivation

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_FndsMAcctAssgmtDerivation.
-- 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: IFMAADERIV

CREATE VIEW I_FndsMAcctAssgmtDerivation AS
SELECT
  LatestItem.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  LatestItem.ControllingArea AS ControllingArea,
  LatestItem.CompanyCode AS CompanyCode,
  LatestItem.CostCenter AS CostCenter,
  LatestItem.ProfitCenter AS ProfitCenter,
  LatestItem.GLAccount AS GLAccount,
  LatestItem.WBSElementExternalID AS WBSElementExternalID,
  LatestItem.MasterFixedAsset AS MasterFixedAsset,
  LatestItem.FixedAsset AS FixedAsset,
  LatestItem.Segment AS Segment,
  LatestItem.OrderID AS OrderID,
  LatestItem.InternalRealEstateNumber AS InternalRealEstateNumber,
  DeriveItem.FundsMgmtDerivationStrategy AS FundsMgmtDerivationStrategy,
  DeriveItem.ValidityEndDate AS ValidityEndDate,
  LatestItem.BusinessEntity AS BusinessEntity,
  LatestItem.RealEstateProperty AS RealEstateProperty,
  LatestItem.RealEstateBuilding AS RealEstateBuilding,
  LatestItem.RentalObject AS RentalObject,
  LatestItem.RealEstateContract AS RealEstateContract,
  DeriveItem.FinancialManagementArea AS FinancialManagementArea,
  DeriveItem.FundsCenter AS FundsCenter,
  DeriveItem.CommitmentItem AS CommitmentItem,
  DeriveItem.Fund AS Fund,
  DeriveItem.BudgetPeriod AS BudgetPeriod,
  DeriveItem.FundedProgram AS FundedProgram,
  DeriveItem.GrantID AS GrantID,
  DeriveItem.FunctionalArea AS FunctionalArea,
  DeriveItem.FundsManagementCustomerField AS FundsManagementCustomerField,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  DeriveItem.CreatedByUser AS CreatedByUser,
  DeriveItem.ValidityStartDate AS ValidityStartDate,
  cast( '0001' as fmis_doc_item_count ) AS NumberOfDocumentItems
FROM P_FndsMgmtAcctAssgmtDrvtnLtst AS LatestItem
INNER JOIN I_FndsMgmtAcctAssgmtDrvtnBasic AS DeriveItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND CommitmentItem = _CommitmentItem.CommitmentItem AND CommitmentItemFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND FundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [1..*]
LEFT OUTER JOIN I_FixedAssetAssgmt AS _FixedAssetAssgmt ON CompanyCode = _FixedAssetAssgmt.CompanyCode AND MasterFixedAsset = _FixedAssetAssgmt.MasterFixedAsset AND FixedAsset = _FixedAssetAssgmt.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Order AS _ReferenceOrder ON OrderID = _ReferenceOrder.OrderID  -- association [1..1]
LEFT OUTER JOIN I_REContractBasic AS _RealEstateContract ON InternalRealEstateNumber = _RealEstateContract.InternalRealEstateNumber AND RealEstateContract = _RealEstateContract.RealEstateContract AND CompanyCode = _RealEstateContract.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_RERentalObject AS _RERentalObject ON InternalRealEstateNumber = _RERentalObject.InternalRealEstateNumber  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
;