P_BankAddressChangeDocument

DDL: P_BANKADDRESSCHANGEDOCUMENT Type: view_entity BASIC Package: VDM_BF_BANK

Address Change Document

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

Data Sources (1)

SourceAliasJoin Type
P_BankAddressChDocItem P_BankAddressChDocItem 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 Address Change Document view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocument ChangeDocument
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType
KEY ChangeDocObject ChangeDocObject
KEY ChangeDocObjectClass
KEY DatabaseTable DatabaseTable
KEY ChangeDocItemChangeTypeText _ChangeTypeText Text
KEY DatabaseTableFieldName _FieldTextDDIC Text
KEY ChangeDocTransactionCode TransactionCode
BankCountry
BankInternalID
ChangeDocPreviousFieldValue
ChangeDocNewFieldValue
CreatedByUser
CreationDate
CreationTime
_ChangeTypeText _ChangeTypeText
_FieldTextDDIC _FieldTextDDIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@EndUserText.label: 'Address Change Document'
define view entity P_BankAddressChangeDocument
  as select from P_BankAddressChDocItem
{
  key ChangeDocument                                                                     as ChangeDocument,
  key ChangeDocTableKey                                                                  as ChangeDocTableKey,
  key ChangeDocDatabaseTableField                                                        as ChangeDocDatabaseTableField,
  key cast ( ChangeDocItemChangeType  as  bf_bank_change_document_type preserving type ) as ChangeDocItemChangeType,
  key ChangeDocObject                                                                    as ChangeDocObject,
  key cast(ChangeDocObjectClass    as bf_bank_change_document_object preserving type )   as ChangeDocObjectClass,
  key DatabaseTable                                                                      as DatabaseTable,
  key _ChangeTypeText.Text                                                               as ChangeDocItemChangeTypeText,
  key _FieldTextDDIC.Text                                                                as DatabaseTableFieldName,
  key TransactionCode                                                                    as ChangeDocTransactionCode,

      cast ( ''   as land1 )                                                             as BankCountry,
      cast ( ''   as  bankk  )                                                           as BankInternalID,
      cast ( ChangeDocPreviousFieldValue as bf_bank_old_fieldval preserving type )       as ChangeDocPreviousFieldValue,
      cast ( ChangeDocNewFieldValue as bf_bank_new_fieldval preserving type )            as ChangeDocNewFieldValue,
      cast ( CreatedByUser as bf_bank_changedby preserving type )                        as CreatedByUser,
      cast ( CreationDate  as bf_bank_changedon preserving type )                        as CreationDate,
      cast ( CreationTime  as bf_bank_changetime preserving type )                       as CreationTime,

      /* Associations */
      _ChangeTypeText,
      _FieldTextDDIC
}