P_BankAddressChDocItem

DDL: P_BANKADDRESSCHDOCITEM Type: view_entity CONSUMPTION

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 18 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, ChangeDocTableKey, ChangeDocDatabaseTableField.

1 data source(s) 18 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 (18)

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
BankAddressID
TransactionCode _ChangeDocument ChangeTransactionCode
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChangeDocument _ChangeDocument
_ChangeDocumentItemExtension _ChangeDocumentItemExtension 
//@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