I_BankAccountTextRev

DDL: I_BANKACCOUNTTEXTREV SQL: IFIBANKACCTTREV Type: view BASIC

Bank Account description with Revisions

I_BankAccountTextRev is a Basic CDS View that provides data about "Bank Account description with Revisions" in SAP S/4HANA. It reads from 1 data source (fclm_bam_amd_t) and exposes 5 fields with key fields BankAccountInternalID, BankAccountRevision, Language.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
fclm_bam_amd_t fclm_bam_amd_t from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName IFIBANKACCTTREV view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
EndUserText.label Bank Account description with Revisions view
ObjectModel.representativeKey BankAccountInternalID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID acc_id
KEY BankAccountRevision revision
KEY Language langu
BankAccountDescription description
_Language _Language 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY //#NOT_REQUIRED //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'IFIBANKACCTTREV'
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@EndUserText.label: 'Bank Account description with Revisions'
@ObjectModel.representativeKey: 'BankAccountInternalID'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ClientHandling.algorithm: #SESSION_VARIABLE 
define view I_BankAccountTextRev as select from fclm_bam_amd_t
association[0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
    key acc_id as BankAccountInternalID,
    @ObjectModel.foreignKey.association: null
    key revision as BankAccountRevision,
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language : true
    key langu as Language,
    @Semantics.text : true
    description as BankAccountDescription,
//    @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]

    _Language
   
}     
where deleted_flag <> 'X'  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_AMD_T"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More