R_FundsMgmtFunctionalAreaTP

DDL: R_FUNDSMGMTFUNCTIONALAREATP Type: view_entity TRANSACTIONAL

Manage Fnds Mgmt Functional Area - TP

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

Data Sources (1)

SourceAliasJoin Type
I_FundsMgmtFunctionalArea iFunctionalArea from

Associations (3)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Manage Fnds Mgmt Functional Area - TP view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FunctionalArea I_FundsMgmtFunctionalArea FunctionalArea
FunctionalAreaAuthznGrp I_FundsMgmtFunctionalArea FunctionalAreaAuthznGrp
CreatedByUser I_FundsMgmtFunctionalArea CreatedByUser
CreationDate I_FundsMgmtFunctionalArea CreationDate
CreationTime I_FundsMgmtFunctionalArea CreationTime
LastChangedByUser I_FundsMgmtFunctionalArea LastChangedByUser
LastChangeDate I_FundsMgmtFunctionalArea LastChangeDate
LastChangeTime I_FundsMgmtFunctionalArea LastChangeTime
ValidityStartDate I_FundsMgmtFunctionalArea ValidityStartDate
ValidityEndDate I_FundsMgmtFunctionalArea ValidityEndDate
ExpirationDate I_FundsMgmtFunctionalArea ExpirationDate
CreatedByUserDescription
LastChangedByUserDescription
FunctionalAreaSubdivisionID I_FundsMgmtFunctionalArea FunctionalAreaSubdivisionID
FunctionalArea1Subdivision I_FundsMgmtFunctionalArea FunctionalArea1Subdivision
FunctionalArea2Subdivision I_FundsMgmtFunctionalArea FunctionalArea2Subdivision
FunctionalArea3Subdivision I_FundsMgmtFunctionalArea FunctionalArea3Subdivision
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'Manage Fnds Mgmt Functional Area - TP'
define root view entity R_FundsMgmtFunctionalAreaTP
  as select from I_FundsMgmtFunctionalArea as iFunctionalArea

  association [0..1] to I_User                   as _user_created on $projection.CreatedByUser = _user_created.UserID
  association [0..1] to I_User                   as _user_changed on $projection.LastChangedByUser = _user_changed.UserID
  association [1..1] to E_FndsMgmtFunctionalArea as _Extension    on $projection.FunctionalArea = _Extension.FunctionalArea
{
      @ObjectModel.readOnly: true
  key iFunctionalArea.FunctionalArea,
      @Consumption.hidden: true
      iFunctionalArea.FunctionalAreaAuthznGrp,
      iFunctionalArea.CreatedByUser,
      iFunctionalArea.CreationDate,
      iFunctionalArea.CreationTime,
      iFunctionalArea.LastChangedByUser,
      iFunctionalArea.LastChangeDate,
      iFunctionalArea.LastChangeTime,
      iFunctionalArea.ValidityStartDate,
      iFunctionalArea.ValidityEndDate,
      iFunctionalArea.ExpirationDate,

      cast( _user_created.UserDescription as vdm_createdbyuserdescription preserving type )   as CreatedByUserDescription,
      @ObjectModel.readOnly: true
      cast( _user_changed.UserDescription as vdm_lastchangedbyuserdescripti preserving type ) as LastChangedByUserDescription,

      iFunctionalArea.FunctionalAreaSubdivisionID,
      iFunctionalArea.FunctionalArea1Subdivision,
      iFunctionalArea.FunctionalArea2Subdivision,
      iFunctionalArea.FunctionalArea3Subdivision

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNDSMGMTFUNCTIONALAREA",
"I_USER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/