I_FundsMgmtFunctionalArea

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_FundsMgmtFunctionalArea.
-- 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: IFMFUNCAREA

CREATE VIEW I_FundsMgmtFunctionalArea AS
SELECT
  fkber AS FunctionalArea,
  authgrp AS FunctionalAreaAuthznGrp,
  cast( created_by as fmis_farea_createdbyuser preserving type ) AS CreatedByUser,
  cast( created_on as fmis_farea_creationdate preserving type ) AS CreationDate,
  cast( created_at as fmis_farea_creationtime preserving type ) AS CreationTime,
  cast( modified_by as fmis_farea_lastchangedbyuser preserving type ) AS LastChangedByUser,
  cast( modified_on as fmis_farea_lastchangedate preserving type ) AS LastChangeDate,
  cast( modified_at as fmis_farea_lastchangetime preserving type ) AS LastChangeTime,
  cast( datab as fmis_farea_validitystartdate preserving type ) AS ValidityStartDate,
  cast( datbis as fmis_farea_validityenddate preserving type ) AS ValidityEndDate,
  cast( date_exp as fmis_farea_expirationdate preserving type ) AS ExpirationDate,
  str_id AS FunctionalAreaSubdivisionID,
  fnsub1 AS FunctionalArea1Subdivision,
  fnsub2 AS FunctionalArea2Subdivision,
  fnsub3 AS FunctionalArea3Subdivision
FROM tfkb
LEFT OUTER JOIN E_FndsMgmtFunctionalArea AS _Extension ON FunctionalArea = _Extension.FunctionalArea  -- association [1..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [1..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _Text ON FunctionalArea = _Text.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_FuncAreaSubdivisionBasic AS _FunctionalAreaSubdivisionID ON FunctionalAreaSubdivisionID = _FunctionalAreaSubdivisionID.FunctionalAreaSubdivisionID  -- association [0..1]
LEFT OUTER JOIN I_FuncArea1Subdivision AS _FuncArea1Subdivision ON FunctionalAreaSubdivisionID = _FuncArea1Subdivision.FunctionalAreaSubdivisionID AND FunctionalArea1Subdivision = _FuncArea1Subdivision.FunctionalArea1Subdivision  -- association [0..1]
LEFT OUTER JOIN I_FuncArea2Subdivision AS _FuncArea2Subdivision ON FunctionalAreaSubdivisionID = _FuncArea2Subdivision.FunctionalAreaSubdivisionID AND FunctionalArea2Subdivision = _FuncArea2Subdivision.FunctionalArea2Subdivision  -- association [0..1]
LEFT OUTER JOIN I_FuncArea3Subdivision AS _FuncArea3Subdivision ON FunctionalAreaSubdivisionID = _FuncArea3Subdivision.FunctionalAreaSubdivisionID AND FunctionalArea3Subdivision = _FuncArea3Subdivision.FunctionalArea3Subdivision  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaHierNode AS _FunctionalAreaHierNode ON FunctionalArea = _FunctionalAreaHierNode.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessFeatureState AS _BusinessFeatureState ON _BusinessFeatureState.BusinessFeatureID = 'PSM_BUDGET_ACCOUNTING_CONTROL' AND _BusinessFeatureState.BusinessFeatureState = '3'  -- association [0..1]
;