P_BANKADDRESSCHDOCITEM

CDS View

Bank Address Change Doc. Item

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

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_BankAddressChangeDocument view_entity inner CONSUMPTION Address Change Document

Fields (7)

KeyField CDS FieldsUsed in Views
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField 1
KEY ChangeDocObject ChangeDocObject 1
KEY ChangeDocObjectClass ChangeDocObjectClass 1
KEY ChangeDocTableKey ChangeDocTableKey 1
KEY ChangeDocument ChangeDocument 1
KEY DatabaseTable DatabaseTable 1
KEY TransactionCode ChangeDocTransactionCode 1 
//@AbapCatalog.viewEnhancementCategory: [#NONE]

@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,
  
  cast ( substring(ChangeDocObject, 5, 10) as ad_addrnum ) as BankAddressID,
  
  _ChangeDocument.ChangeTransactionCode                    as TransactionCode,

  /* Associations */
  _ChangeDocLongTableKey,
  _ChangeDocument,
  _ChangeDocumentItemExtension

} where ChangeDocObjectClass = 'ADRESSE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_CHANGEDOCLONGTABLEKEY",
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEMEXTENSION"
],
"BASE":
[
"I_CHANGEDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More