P_BankAddressChDocItem

DDL: P_BANKADDRESSCHDOCITEM Type: view_entity CONSUMPTION Package: VDM_BF_BANK

Bank Address Change Doc. Item

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

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Bank Address Change Doc. Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject
KEY ChangeDocObjectClass ChangeDocObjectClass
KEY ChangeDocument ChangeDocument
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType ChangeDocItemChangeType
KEY DatabaseTable DatabaseTable
ChangeDocNewFieldValue ChangeDocNewFieldValue
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue
CreatedByUser _ChangeDocument CreatedByUser
CreationDate _ChangeDocument CreationDate
CreationTime _ChangeDocument CreationTime
ChangeDocLanguage _ChangeDocument ChangeDocLanguage
TransactionCode _ChangeDocument ChangeTransactionCode
_FieldTextDDIC _FieldTextDDIC
_ChangeTypeText _ChangeTypeText
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChangeDocument _ChangeDocument
_ChangeDocumentItemExtension _ChangeDocumentItemExtension 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Bank Address Change Doc. Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #C,
    sizeCategory: #M,
    dataClass: #TRANSACTIONAL
}
define view entity P_BankAddressChDocItem
  as select from I_ChangeDocumentItem
{
  key ChangeDocObject,
  key ChangeDocObjectClass,
  key ChangeDocument,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,
  key ChangeDocItemChangeType,
  key DatabaseTable,

      ChangeDocNewFieldValue,
      ChangeDocPreviousFieldValue,
      _ChangeDocument.CreatedByUser,
      _ChangeDocument.CreationDate,
      _ChangeDocument.CreationTime,
      _ChangeDocument.ChangeDocLanguage,
      _ChangeDocument.ChangeTransactionCode as TransactionCode,

      /* Associations */
      _FieldTextDDIC,
      _ChangeTypeText,
      _ChangeDocLongTableKey,
      _ChangeDocument,
      _ChangeDocumentItemExtension
}
where
          ChangeDocObjectClass          =  'ADRESSE'
  and(
          DatabaseTable                 =  'ADRC'
    and   not(
        ChangeDocDatabaseTableField     =  'KEY'
        and length( ChangeDocTableKey ) =  21
      )
    and   not(
        ChangeDocItemChangeType         =  'E'
        and ChangeDocDatabaseTableField <> 'ADDRORIGIN'
      )
  )

Learn More