I_FndsMgmtFunctionalAreaCoreTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_FundsMgmtFunctionalArea | funcnlarea | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | FunctionalArea | I_FundsMgmtFunctionalArea | FunctionalArea | |
| FunctionalAreaForEdit | I_FundsMgmtFunctionalArea | FunctionalArea | ||
| FunctionalAreaAuthznGrp | I_FundsMgmtFunctionalArea | FunctionalAreaAuthznGrp | ||
| ValidityStartDate | I_FundsMgmtFunctionalArea | ValidityStartDate | ||
| ValidityEndDate | I_FundsMgmtFunctionalArea | ValidityEndDate | ||
| ExpirationDate | I_FundsMgmtFunctionalArea | ExpirationDate | ||
| CreatedByUser | I_FundsMgmtFunctionalArea | CreatedByUser | ||
| UserDescriptionendasCreatedByUserName | ||||
| CreationDate | I_FundsMgmtFunctionalArea | CreationDate | ||
| CreationTime | I_FundsMgmtFunctionalArea | CreationTime | ||
| LastChangedByUser | I_FundsMgmtFunctionalArea | LastChangedByUser | ||
| UserDescriptionendasLastChangeByUserName | ||||
| LastChangeDate | I_FundsMgmtFunctionalArea | LastChangeDate | ||
| LastChangeTime | I_FundsMgmtFunctionalArea | LastChangeTime | ||
| FunctionalAreaName | ||||
| _FunctionalArea | I_FundsMgmtFunctionalArea | _FunctionalArea | ||
| _UserCreated | _UserCreated | |||
| _UserChanged | _UserChanged |
@AbapCatalog.sqlViewName: 'IFMFUNCNLACORETP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_UserCreated', '_UserChanged']
@EndUserText.label: 'Manage Functional Area'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.sapObjectNodeType.name: 'FunctionalArea'
@ObjectModel: {
modelCategory: #BUSINESS_OBJECT,
compositionRoot: true,
transactionalProcessingEnabled: true,
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
representativeKey: 'FunctionalArea',
semanticKey: [ 'FunctionalArea' ],
draftEnabled: true,
writeDraftPersistence: 'FMC_D_FUNCAR_DFT',
entityChangeStateId: 'EXTERNAL_CALCULATION',
lifecycle.draft.expiryBehavior: #RELATIVE_TO_PROCESSING_START,
lifecycle.draft.expiryInterval: 'P5D',
usageType: {
dataClass: #MASTER,
serviceQuality: #C,
sizeCategory: #L
}
}
// Comment added to check BO sync errors - remove later
define view I_FndsMgmtFunctionalAreaCoreTP
as select from I_FundsMgmtFunctionalArea as funcnlarea
association [0..1] to E_FndsMgmtFunctionalArea as _Extension on $projection.FunctionalArea = _Extension.FunctionalArea
association [0..1] to I_User as _UserCreated on $projection.CreatedByUser = _UserCreated.UserID
association [0..1] to I_User as _UserChanged on $projection.LastChangedByUser = _UserChanged.UserID
{
//funcnlarea
@ObjectModel.readOnly: true
key funcnlarea.FunctionalArea,
@ObjectModel.enabled: 'EXTERNAL_CALCULATION'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
funcnlarea.FunctionalArea as FunctionalAreaForEdit,
@ObjectModel.enabled: 'EXTERNAL_CALCULATION'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
funcnlarea.FunctionalAreaAuthznGrp,
@ObjectModel.enabled: 'EXTERNAL_CALCULATION'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
funcnlarea.ValidityStartDate,
@ObjectModel.enabled: 'EXTERNAL_CALCULATION'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
funcnlarea.ValidityEndDate,
@ObjectModel.enabled: 'EXTERNAL_CALCULATION'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
funcnlarea.ExpirationDate,
@Semantics.user.createdBy: true
@ObjectModel.readOnly: true
funcnlarea.CreatedByUser,
@ObjectModel.readOnly: true
case
when _UserCreated.UserDescription is initial then funcnlarea.CreatedByUser
else _UserChanged.UserDescription end as CreatedByUserName,
//@Semantics.systemDate.createdAt: true
@Semantics.businessDate.createdAt: true
// @Semantics.systemDate.createdAt: true
@ObjectModel.readOnly: true
funcnlarea.CreationDate,
//@Semantics.systemTime.createdAt: true
@ObjectModel.readOnly: true
funcnlarea.CreationTime,
@Semantics.user.lastChangedBy: true
@ObjectModel.readOnly: true
funcnlarea.LastChangedByUser,
@ObjectModel.readOnly: true
case
when _UserCreated.UserDescription is initial then funcnlarea.LastChangedByUser
else _UserChanged.UserDescription end as LastChangeByUserName,
@Semantics.systemDate.lastChangedAt: true
@ObjectModel.readOnly: true
funcnlarea.LastChangeDate,
//@Semantics.systemTime.lastChangedAt: true
@ObjectModel.readOnly: true
funcnlarea.LastChangeTime,
//Text
@ObjectModel.enabled: 'EXTERNAL_CALCULATION'
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
cast( funcnlarea._Text[1:Language=$session.system_language].FunctionalAreaName as fis_fkbtx preserving type ) as FunctionalAreaName,
/* Associations */
//funcnlarea
funcnlarea._FunctionalArea,
@Consumption.filter.hidden: true
@UI.hidden: true
_UserCreated,
@Consumption.filter.hidden: true
@UI.hidden: true
_UserChanged
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNCTIONALAREATEXT",
"I_FUNDSMGMTFUNCTIONALAREA",
"I_USER"
],
"ASSOCIATED":
[
"E_FNDSMGMTFUNCTIONALAREA",
"I_FUNCTIONALAREA",
"I_USER"
],
"BASE":
[
"I_FUNDSMGMTFUNCTIONALAREA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA