I_FundsCenterBasicNoValidTo

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_FundsCenterBasicNoValidTo.
-- 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.

CREATE VIEW I_FundsCenterBasicNoValidTo AS
SELECT
  fikrs AS FinancialManagementArea,
  cast( fictr as fistl preserving type ) AS FundsCenter,
  cast( datbis as fmis_fc_validityenddate preserving type ) AS ValidityEndDate,
  cast( datab as fmis_fc_validitystartdate preserving type ) AS ValidityStartDate,
  cast( erfname as fmis_fc_createdbyuser preserving type ) AS CreatedByUser,
  cast( erfdat as fmis_fc_creationdate preserving type ) AS CreationDate,
  cast( aenname as fmis_fc_lastchangeuser preserving type ) AS LastChangeByUser,
  cast( aendat as fmis_fc_lastchangedate preserving type ) AS LastChangeDate,
  cast( date_exp as fmis_fc_expirationdate preserving type ) AS FundsCenterExpirationDate,
  bossid AS FundsCenterResponsible,
  cast( bossid as fmis_fundscentermanager preserving type ) AS FundsCenterManager,
  bossname AS FundsCenterResponsibleName,
  fincode AS FundsCenterDefaultFund,
  augrp AS FundsCenterAuthznGrp,
  bukrs AS CompanyCode,
  gsber AS BusinessArea,
  _CompanyCode.ControllingArea AS ControllingArea,
  cast( prctr as fis_prctr preserving type ) AS ProfitCenter,
  _Text.FundsCenterName AS FundsCenterName,
  _Text.FundsCenterDescription AS FundsCenterDescription
FROM fmfctr
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FundsCenterNoValidToText AS _Text ON FinancialManagementArea = _Text.FinancialManagementArea AND FundsCenter = _Text.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND FundsCenterDefaultFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea AND _ProfitCenter.ValidityEndDate >= $session.system_date AND _ProfitCenter.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangeByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _FundsCenterManager ON FundsCenterManager = _FundsCenterManager.UserID  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter2HierarchyNode AS _FundsCenterHierarchyNode ON FinancialManagementArea = _FundsCenterHierarchyNode.FinancialManagementArea AND FundsCenter = _FundsCenterHierarchyNode.FundsCenter  -- association [0..*]
;