I_BankAccRevision

DDL: I_BANKACCREVISION SQL: IBANKACCREVISION Type: view BASIC

Bank Account Revision Status

I_BankAccRevision is a Basic CDS View that provides data about "Bank Account Revision Status" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_amd, fclm_bam_rev) and exposes 10 fields with key fields BankAccountInternalID, BankAccountRevision.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
fclm_bam_amd Account left_outer
fclm_bam_rev Revision from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IBANKACCREVISION view
VDM.viewType #BASIC view
ObjectModel.representativeKey BankAccountInternalID view
EndUserText.label Bank Account Revision Status view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID fclm_bam_rev acc_id
KEY BankAccountRevision fclm_bam_rev revision
BankAccountActivatedSequence fclm_bam_rev activated_seq
BankAccountAction acc_action
BankAccountRevisionStatus rev_status
CompanyCode fclm_bam_amd bukrs
ProfitCenter fclm_bam_amd prctr
BusinessArea fclm_bam_amd gsber
Segment fclm_bam_amd segment
BankAccountType fclm_bam_amd acc_type_id 
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'IBANKACCREVISION'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'BankAccountInternalID'
@EndUserText.label: 'Bank Account Revision Status'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #A
@ClientHandling.algorithm: #SESSION_VARIABLE 
@Metadata.allowExtensions:true
define view I_BankAccRevision as select from fclm_bam_rev as Revision 
left outer join fclm_bam_amd as Account on Account.acc_id = Revision.acc_id and Account.revision = Revision.revision
{
        key Revision.acc_id as BankAccountInternalID,
        @ObjectModel.foreignKey.association: null
        key Revision.revision as BankAccountRevision,
        Revision.activated_seq as BankAccountActivatedSequence,
        acc_action as BankAccountAction,
        rev_status as BankAccountRevisionStatus,
        Account.bukrs as CompanyCode,
        Account.prctr as ProfitCenter,
        Account.gsber as BusinessArea,
        Account.segment as Segment,
        Account.acc_type_id as BankAccountType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BAM_AMD",
"FCLM_BAM_REV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More