I_FndsMgmtFunctionalAreaCoreTP

DDL: I_FNDSMGMTFUNCTIONALAREACORETP SQL: IFMFUNCNLACORETP Type: view TRANSACTIONAL
18 Fields 1 Data Sources 3 Associations

Manage Functional Area

I_FndsMgmtFunctionalAreaCoreTP is a Transactional CDS View that provides data about "Manage Functional Area" in SAP S/4HANA. It reads from 1 data source (I_FundsMgmtFunctionalArea) and exposes 18 fields with key field FunctionalArea. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FundsMgmtFunctionalArea funcnlarea from

Associations (3)

CardinalityTargetAliasCondition
[0..1] E_FndsMgmtFunctionalArea _Extension $projection.FunctionalArea = _Extension.FunctionalArea
[0..1] I_User _UserCreated $projection.CreatedByUser = _UserCreated.UserID
[0..1] I_User _UserChanged $projection.LastChangedByUser = _UserChanged.UserID

Annotations (23)

NameValueLevelField
AbapCatalog.sqlViewName IFMFUNCNLACORETP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Functional Area view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name FunctionalArea view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.representativeKey FunctionalArea view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence FMC_D_FUNCAR_DFT view
ObjectModel.entityChangeStateId EXTERNAL_CALCULATION view
ObjectModel.lifecycle.draft.expiryBehavior #RELATIVE_TO_PROCESSING_START view
ObjectModel.lifecycle.draft.expiryInterval P5D view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY FunctionalArea I_FundsMgmtFunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaForEdit I_FundsMgmtFunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaAuthznGrp I_FundsMgmtFunctionalArea FunctionalAreaAuthznGrp Authorization Group
ValidityStartDate I_FundsMgmtFunctionalArea ValidityStartDate Validity Start Date
ValidityEndDate I_FundsMgmtFunctionalArea ValidityEndDate ValidTo
ExpirationDate I_FundsMgmtFunctionalArea ExpirationDate Expiratn Date
CreatedByUser I_FundsMgmtFunctionalArea CreatedByUser User Name
UserDescriptionendasCreatedByUserName
CreationDate I_FundsMgmtFunctionalArea CreationDate Time Stamp
CreationTime I_FundsMgmtFunctionalArea CreationTime Time of Change
LastChangedByUser I_FundsMgmtFunctionalArea LastChangedByUser User Name
UserDescriptionendasLastChangeByUserName
LastChangeDate I_FundsMgmtFunctionalArea LastChangeDate Time Stamp
LastChangeTime I_FundsMgmtFunctionalArea LastChangeTime Time changed
FunctionalAreaName
_FunctionalArea I_FundsMgmtFunctionalArea _FunctionalArea
_UserCreated _UserCreated
_UserChanged _UserChanged

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_FndsMgmtFunctionalAreaCoreTP.
-- 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: IFMFUNCNLACORETP

CREATE VIEW I_FndsMgmtFunctionalAreaCoreTP AS
SELECT
  funcnlarea.FunctionalArea AS FunctionalArea,
  funcnlarea.FunctionalArea AS FunctionalAreaForEdit,
  funcnlarea.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  funcnlarea.ValidityStartDate AS ValidityStartDate,
  funcnlarea.ValidityEndDate AS ValidityEndDate,
  funcnlarea.ExpirationDate AS ExpirationDate,
  funcnlarea.CreatedByUser AS CreatedByUser,
  case when _UserCreated.UserDescription is initial then funcnlarea.CreatedByUser else _UserChanged.UserDescription end as CreatedByUserName AS UserDescriptionendasCreatedByUserName,
  funcnlarea.CreationDate AS CreationDate,
  funcnlarea.CreationTime AS CreationTime,
  funcnlarea.LastChangedByUser AS LastChangedByUser,
  case when _UserCreated.UserDescription is initial then funcnlarea.LastChangedByUser else _UserChanged.UserDescription end as LastChangeByUserName AS UserDescriptionendasLastChangeByUserName,
  funcnlarea.LastChangeDate AS LastChangeDate,
  funcnlarea.LastChangeTime AS LastChangeTime,
  cast( funcnlarea._Text[1:Language=$session.system_language].FunctionalAreaName as fis_fkbtx preserving type ) AS FunctionalAreaName,
  funcnlarea._FunctionalArea AS _FunctionalArea
FROM I_FundsMgmtFunctionalArea AS funcnlarea
LEFT OUTER JOIN E_FndsMgmtFunctionalArea AS _Extension ON FunctionalArea = _Extension.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserCreated ON CreatedByUser = _UserCreated.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserChanged ON LastChangedByUser = _UserChanged.UserID  -- association [0..1]
;

Learn More