I_FundsCenterText

DDL: I_FUNDSCENTERTEXT SQL: IFUNDSCENTERTEXT Type: view BASIC

Funds Center - Text

I_FundsCenterText is a Basic CDS View that provides data about "Funds Center - Text" in SAP S/4HANA. It reads from 1 data source (fmfctrt) and exposes 11 fields with key fields Language, FinancialManagementArea, FundsCenter, ValidityEndDate. It has 3 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
fmfctrt fmfctrt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_FinancialManagementArea _FinMgmtArea $projection.FinancialManagementArea = _FinMgmtArea.FinancialManagementArea
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_FundsCenter _FundsCenterForAuthzn $projection.FinancialManagementArea = _FundsCenterForAuthzn.FinancialManagementArea and $projection.FundsCenter = _FundsCenterForAuthzn.FundsCenter and $projection.ValidityEndDate = _FundsCenterForAuthzn.ValidityEndDate

Annotations (15)

NameValueLevelField
EndUserText.label Funds Center - Text view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey FundsCenter view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IFUNDSCENTERTEXT view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Language spras
KEY FinancialManagementArea fikrs
KEY FundsCenter fictr
KEY ValidityEndDate
ValidityStartDate
FundsCenterName
FundsCenterDescription
FundsCenterSearchTerm mctxt
_FinMgmtArea _FinMgmtArea
_Language _Language
_FundsCenterForAuthzn _FundsCenterForAuthzn 
@EndUserText.label: 'Funds Center - Text'
@Analytics: { 
              dataExtraction.enabled: true, 
              internalName: #LOCAL 
            }
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
  representativeKey: 'FundsCenter',
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #M
  },
  supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT,#EXTRACTION_DATA_SOURCE],
  dataCategory: #TEXT
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IFUNDSCENTERTEXT'
define view I_FundsCenterText
  as select from fmfctrt
  association [1..1] to I_FinancialManagementArea as _FinMgmtArea          on  $projection.FinancialManagementArea = _FinMgmtArea.FinancialManagementArea
  association [0..1] to I_Language                as _Language             on  $projection.Language = _Language.Language
  association [0..1] to I_FundsCenter             as _FundsCenterForAuthzn on  $projection.FinancialManagementArea = _FundsCenterForAuthzn.FinancialManagementArea
                                                                           and $projection.FundsCenter             = _FundsCenterForAuthzn.FundsCenter
                                                                           and $projection.ValidityEndDate         = _FundsCenterForAuthzn.ValidityEndDate
{

      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key spras                                                                                                      as Language,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_FinMgmtAreaStdVH',
                     element: 'FinancialManagementArea' }
        }]
      @ObjectModel.foreignKey.association: '_FinMgmtArea'
  key fikrs                                                                                                      as FinancialManagementArea,
  key fictr                                                                                                      as FundsCenter,
      @Semantics.businessDate.to: true
  key cast( datbis as fmis_fc_validityenddate preserving type )                                                  as ValidityEndDate,
      @Semantics.businessDate.from: true
      cast( datab as fmis_fc_validitystartdate preserving type)                                                  as ValidityStartDate,
      @Semantics.text: true
      cast( bezeich as fmis_fc_name preserving type )                                                            as FundsCenterName,
      @Semantics.text: true
      cast( beschr as fmis_fc_description preserving type )                                                      as FundsCenterDescription,
      @Semantics.text: true
      mctxt                                                                                                      as FundsCenterSearchTerm,

      _FinMgmtArea,
      _Language,
      _FundsCenterForAuthzn

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FMFCTRT"
],
"ASSOCIATED":
[
"I_FINANCIALMANAGEMENTAREA",
"I_FUNDSCENTER",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More