C_LastValidFundsCenterWST

DDL: C_LASTVALIDFUNDSCENTERWST SQL: CLVFNDSCENTERWST Type: view CONSUMPTION

Last Valid Funds Center with Session Language Texts

C_LastValidFundsCenterWST is a Consumption CDS View that provides data about "Last Valid Funds Center with Session Language Texts" in SAP S/4HANA. It reads from 1 data source (C_FundsCenterWST) and exposes 12 fields with key fields FinancialManagementArea, FundsCenter.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
C_FundsCenterWST C_FundsCenterWST from

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName CLVFNDSCENTERWST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Last Valid Funds Center with Session Language Texts view
UI.headerInfo.typeName Is Default in Funds Centers view
UI.headerInfo.typeNamePlural Is Default in Funds Centers view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea C_FundsCenterWST FinancialManagementArea Financial Management Area
KEY FundsCenter C_FundsCenterWST FundsCenter Funds Center
ValidityEndDate
ValidityStartDate C_FundsCenterWST ValidityStartDate Validity Start Date
FundsCenterResponsible C_FundsCenterWST FundsCenterResponsible Responsible Person
FundsCenterResponsibleName C_FundsCenterWST FundsCenterResponsibleName Responsible Person Name
FundsCenterDefaultFund C_FundsCenterWST FundsCenterDefaultFund Default Fund
FundsCenterAuthznGrp C_FundsCenterWST FundsCenterAuthznGrp
FndsCenterFinMgmtAreaForAuthzn C_FundsCenterWST FndsCenterFinMgmtAreaForAuthzn
FundsCenterName C_FundsCenterWST FundsCenterName Funds Center Name
FundsCenterExtendedName C_FundsCenterWST FundsCenterExtendedName
FundsCenterDescription C_FundsCenterWST FundsCenterDescription 
@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L

@AbapCatalog.sqlViewName: 'CLVFNDSCENTERWST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Last Valid Funds Center with Session Language Texts'
@UI.headerInfo: {
  typeName: 'Is Default in Funds Centers',
  typeNamePlural: 'Is Default in Funds Centers'
  
}
define view C_LastValidFundsCenterWST
  as select from C_FundsCenterWST
{
      @EndUserText.label: 'Financial Management Area'
  key C_FundsCenterWST.FinancialManagementArea,
      @Consumption.semanticObject:'FundsCenter'
      @EndUserText.label: 'Funds Center'
  key C_FundsCenterWST.FundsCenter,
      max (C_FundsCenterWST.ValidityEndDate) as ValidityEndDate,
      @EndUserText.label: 'Validity Start Date'
      C_FundsCenterWST.ValidityStartDate,
      @UI.hidden:true
      @EndUserText.label: 'Responsible Person'
      C_FundsCenterWST.FundsCenterResponsible,
      @EndUserText.label: 'Responsible Person Name'
      C_FundsCenterWST.FundsCenterResponsibleName,
      // @Consumption.hidden: true

      @EndUserText.label: 'Default Fund'
      C_FundsCenterWST.FundsCenterDefaultFund,
      @Consumption.hidden: true
      C_FundsCenterWST.FundsCenterAuthznGrp,
      @Consumption.hidden: true
      C_FundsCenterWST.FndsCenterFinMgmtAreaForAuthzn,
      @EndUserText.label: 'Funds Center Name'
      C_FundsCenterWST.FundsCenterName,
      @Consumption.hidden: true
      C_FundsCenterWST.FundsCenterExtendedName,
      @Consumption.hidden: true
      C_FundsCenterWST.FundsCenterDescription

}
group by
  FinancialManagementArea,
  FundsCenter,
  ValidityStartDate,
  FundsCenterResponsible,
  FundsCenterResponsibleName,
  FundsCenterDefaultFund,
  FundsCenterAuthznGrp,
  FndsCenterFinMgmtAreaForAuthzn,
  FundsCenterName,
  FundsCenterExtendedName,
  FundsCenterDescription 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_FUNDSCENTERWST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More