P_BANKADDRESSCHDOCITEM

CDS View

Bank Address Change Doc. Item

P_BANKADDRESSCHDOCITEM is a CDS View in S/4HANA. Bank Address Change Doc. Item. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_BankAddressChangeDocument view_entity from BASIC Address Change Document 
@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