I_FundsMgmtFunctionalAreaTP

DDL: I_FUNDSMGMTFUNCTIONALAREATP SQL: IFMFUNCAREATP Type: view TRANSACTIONAL
22 Fields 1 Data Sources 1 Associations

Manage Functional Area

I_FundsMgmtFunctionalAreaTP 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 22 fields with key field FunctionalArea. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FundsMgmtFunctionalArea iFmFunctionalArea from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_FndsMgmtFunctionalArea _Extension $projection.FunctionalArea = _Extension.FunctionalArea

Annotations (23)

NameValueLevelField
AbapCatalog.sqlViewName IFMFUNCAREATP 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.modelCategory #BUSINESS_OBJECT view
ObjectModel.createEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.representativeKey FunctionalArea view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence FMFUNCAREA_DRAFT view
ObjectModel.entityChangeStateId EXTERNAL_CALCULATION view
ObjectModel.lifecycle.draft.expiryBehavior #RELATIVE_TO_PROCESSING_START view
ObjectModel.lifecycle.draft.expiryInterval P5D view
ObjectModel.sapObjectNodeType.name FunctionalArea view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (22)

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
CreationDate I_FundsMgmtFunctionalArea CreationDate Time Stamp
CreationTime I_FundsMgmtFunctionalArea CreationTime Time of Change
LastChangedByUser I_FundsMgmtFunctionalArea LastChangedByUser User Name
LastChangeDate I_FundsMgmtFunctionalArea LastChangeDate Time Stamp
LastChangeTime I_FundsMgmtFunctionalArea LastChangeTime Time changed
FunctionalAreaSubdivisionID I_FundsMgmtFunctionalArea FunctionalAreaSubdivisionID Farea Subdivision ID
FunctionalArea1Subdivision I_FundsMgmtFunctionalArea FunctionalArea1Subdivision FN Substring 1
FunctionalArea2Subdivision I_FundsMgmtFunctionalArea FunctionalArea2Subdivision FN Substring 2
FunctionalArea3Subdivision I_FundsMgmtFunctionalArea FunctionalArea3Subdivision FN Substring 3
FunctionalAreaName
_FunctionalAreaSubdivisionID I_FundsMgmtFunctionalArea _FunctionalAreaSubdivisionID
_FuncArea1Subdivision I_FundsMgmtFunctionalArea _FuncArea1Subdivision
_FuncArea2Subdivision I_FundsMgmtFunctionalArea _FuncArea2Subdivision
_FuncArea3Subdivision I_FundsMgmtFunctionalArea _FuncArea3Subdivision
_FunctionalArea I_FundsMgmtFunctionalArea _FunctionalArea

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_FundsMgmtFunctionalAreaTP.
-- 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: IFMFUNCAREATP

CREATE VIEW I_FundsMgmtFunctionalAreaTP AS
SELECT
  iFmFunctionalArea.FunctionalArea AS FunctionalArea,
  iFmFunctionalArea.FunctionalArea AS FunctionalAreaForEdit,
  iFmFunctionalArea.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  iFmFunctionalArea.ValidityStartDate AS ValidityStartDate,
  iFmFunctionalArea.ValidityEndDate AS ValidityEndDate,
  iFmFunctionalArea.ExpirationDate AS ExpirationDate,
  iFmFunctionalArea.CreatedByUser AS CreatedByUser,
  iFmFunctionalArea.CreationDate AS CreationDate,
  iFmFunctionalArea.CreationTime AS CreationTime,
  iFmFunctionalArea.LastChangedByUser AS LastChangedByUser,
  iFmFunctionalArea.LastChangeDate AS LastChangeDate,
  iFmFunctionalArea.LastChangeTime AS LastChangeTime,
  iFmFunctionalArea.FunctionalAreaSubdivisionID AS FunctionalAreaSubdivisionID,
  iFmFunctionalArea.FunctionalArea1Subdivision AS FunctionalArea1Subdivision,
  iFmFunctionalArea.FunctionalArea2Subdivision AS FunctionalArea2Subdivision,
  iFmFunctionalArea.FunctionalArea3Subdivision AS FunctionalArea3Subdivision,
  iFmFunctionalArea._Text[1:Language=$session.system_language].FunctionalAreaName AS FunctionalAreaName,
  iFmFunctionalArea._FunctionalAreaSubdivisionID AS _FunctionalAreaSubdivisionID,
  iFmFunctionalArea._FuncArea1Subdivision AS _FuncArea1Subdivision,
  iFmFunctionalArea._FuncArea2Subdivision AS _FuncArea2Subdivision,
  iFmFunctionalArea._FuncArea3Subdivision AS _FuncArea3Subdivision,
  iFmFunctionalArea._FunctionalArea AS _FunctionalArea
FROM I_FundsMgmtFunctionalArea AS iFmFunctionalArea
LEFT OUTER JOIN E_FndsMgmtFunctionalArea AS _Extension ON FunctionalArea = _Extension.FunctionalArea  -- association [1..1]
;

Learn More