P_BankChangeDocument

DDL: P_BANKCHANGEDOCUMENT Type: view_entity BASIC Package: VDM_BF_BANK

Bank Change Document

P_BankChangeDocument is a Basic CDS View that provides data about "Bank Change Document" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocumentItem) and exposes 22 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, ChangeDocTableKey, ChangeDocDatabaseTableField. Part of development package VDM_BF_BANK.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Bank Change Document view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject
KEY ChangeDocObjectClass
KEY ChangeDocument ChangeDocument
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType
KEY DatabaseTable DatabaseTable
KEY ChangeDocItemChangeTypeText _ChangeTypeText Text
KEY DatabaseTableFieldName _FieldTextDDIC Text
KEY ChangeDocTransactionCode _ChangeDocument ChangeTransactionCode
ChangeDocPreviousFieldValue
ChangeDocNewFieldValue
CreatedByUser
CreationDate
CreationTime
ChangeDocLongTableKey _ChangeDocLongTableKey ChangeDocLongTableKey
BankCountry
BankInternalID
TransacionCode _ChangeDocument ChangeTransactionCode
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChangeDocument _ChangeDocument
_ChangeDocumentItemExtension _ChangeDocumentItemExtension 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.private: true
@VDM.viewType: #BASIC

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@EndUserText.label: 'Bank Change Document'
define view entity P_BankChangeDocument
  as select from I_ChangeDocumentItem
{
  key ChangeDocObject,
  key cast(ChangeDocObjectClass as bf_bank_change_document_object preserving type )      as ChangeDocObjectClass,
  key ChangeDocument,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,
  key cast ( ChangeDocItemChangeType  as  bf_bank_change_document_type preserving type ) as ChangeDocItemChangeType,
  key DatabaseTable,
  key _ChangeTypeText.Text                                                               as ChangeDocItemChangeTypeText,
  key _FieldTextDDIC.Text                                                                as DatabaseTableFieldName,
  key _ChangeDocument.ChangeTransactionCode                                              as ChangeDocTransactionCode,

      cast ( ChangeDocPreviousFieldValue as bf_bank_old_fieldval preserving type )       as ChangeDocPreviousFieldValue,
      cast ( ChangeDocNewFieldValue as bf_bank_new_fieldval preserving type )            as ChangeDocNewFieldValue,
      cast ( _ChangeDocument.CreatedByUser as bf_bank_changedby preserving type )        as CreatedByUser,
      cast ( _ChangeDocument.CreationDate  as bf_bank_changedon preserving type )        as CreationDate,
      cast ( _ChangeDocument.CreationTime  as bf_bank_changetime preserving type )       as CreationTime,
      _ChangeDocLongTableKey.ChangeDocLongTableKey,
      cast ( ''   as land1 )                                                             as BankCountry,
      cast ( ''   as  bankk  )                                                           as BankInternalID,
      _ChangeDocument.ChangeTransactionCode                                              as TransacionCode,

      /* Associations */
      _ChangeDocLongTableKey,
      _ChangeDocument,
      _ChangeDocumentItemExtension
}
where
      ChangeDocObjectClass = 'BANK'
  and DatabaseTable        = 'BNKA'

Learn More