I_FundsCenterBasic

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_FundsCenterBasic.
-- 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: IFUNDSCENTERB

CREATE VIEW I_FundsCenterBasic AS
SELECT
  fikrs AS FinancialManagementArea,
  cast( fictr as fm_fictr 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 LastChangeUser,
  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,
  prctr AS ProfitCenter
FROM fmfctr
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FundsCenterText AS _Text ON FinancialManagementArea = _Text.FinancialManagementArea AND FundsCenter = _Text.FundsCenter AND ValidityEndDate = _Text.ValidityEndDate  -- 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_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangeUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _FundsCenterManager ON FundsCenterManager = _FundsCenterManager.UserID  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterHierarchyNode AS _FundsCenterHierarchyNode ON FinancialManagementArea = _FundsCenterHierarchyNode.FinancialManagementArea AND FundsCenter = _FundsCenterHierarchyNode.FundsCenter  -- association [0..*]
;