P_BankChainChangeDocumentItem

DDL: P_BANKCHAINCHANGEDOCUMENTITEM Type: view_entity BASIC Package: ODATA_MANAGE_BANK_CHAINS

Bank Chain Change Document Item

P_BankChainChangeDocumentItem is a Basic CDS View that provides data about "Bank Chain Change Document Item" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocumentItem) and exposes 18 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. It has 2 associations to related views. Part of development package ODATA_MANAGE_BANK_CHAINS.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_BankChainChangeDocument _BankChainChangeDocument $projection.ChangeDocObject = _BankChainChangeDocument.ChangeDocObject and $projection.ChangeDocObjectClass = _BankChainChangeDocument.ChangeDocObjectClass and $projection.ChangeDocument = _BankChainChangeDocument.ChangeDocument
[0..1] I_ChangeDocChangeIndT _ChgDocItemChangeTypeText _ChgDocItemChangeTypeText.Value = $projection.ChangeDocItemChangeType and _ChgDocItemChangeTypeText.Language = $session.system_language

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 #L view
EndUserText.label Bank Chain Change Document Item view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocumentItem ChangeDocObject
KEY ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType
Text _ChgDocItemChangeTypeText Text
ChangeDocPreviousUnit I_ChangeDocumentItem ChangeDocPreviousUnit
ChangeDocNewUnit I_ChangeDocumentItem ChangeDocNewUnit
ChangeDocPreviousCurrency I_ChangeDocumentItem ChangeDocPreviousCurrency
ChangeDocNewCurrency I_ChangeDocumentItem ChangeDocNewCurrency
ChangeDocPreviousFieldValue
ChangeDocNewFieldValue
ObjectDatabaseTable
_BankChainChangeDocument _BankChainChangeDocument
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChgDocItemChangeTypeText _ChgDocItemChangeTypeText 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Bank Chain Change Document Item'
define view entity P_BankChainChangeDocumentItem
  as select from I_ChangeDocumentItem

  association [0..1] to P_BankChainChangeDocument as _BankChainChangeDocument  on  $projection.ChangeDocObject      = _BankChainChangeDocument.ChangeDocObject
                                                                               and $projection.ChangeDocObjectClass = _BankChainChangeDocument.ChangeDocObjectClass
                                                                               and $projection.ChangeDocument       = _BankChainChangeDocument.ChangeDocument

  association [0..1] to I_ChangeDocChangeIndT     as _ChgDocItemChangeTypeText on  _ChgDocItemChangeTypeText.Value    = $projection.ChangeDocItemChangeType
                                                                               and _ChgDocItemChangeTypeText.Language = $session.system_language
{
  key I_ChangeDocumentItem.ChangeDocObject,
  key I_ChangeDocumentItem.ChangeDocObjectClass,
  key I_ChangeDocumentItem.ChangeDocument,
  key I_ChangeDocumentItem.DatabaseTable,
  key I_ChangeDocumentItem.ChangeDocTableKey,
  key I_ChangeDocumentItem.ChangeDocDatabaseTableField,
  key cast ( I_ChangeDocumentItem.ChangeDocItemChangeType  as fap_change_document_type preserving type ) as ChangeDocItemChangeType,

      _ChgDocItemChangeTypeText.Text,
      I_ChangeDocumentItem.ChangeDocPreviousUnit,
      I_ChangeDocumentItem.ChangeDocNewUnit,
      I_ChangeDocumentItem.ChangeDocPreviousCurrency,
      I_ChangeDocumentItem.ChangeDocNewCurrency,

      cast ( I_ChangeDocumentItem.ChangeDocPreviousFieldValue as fap_cc_old_fieldval preserving type )   as ChangeDocPreviousFieldValue,
      cast ( I_ChangeDocumentItem.ChangeDocNewFieldValue as fap_cc_new_fieldval preserving type )        as ChangeDocNewFieldValue,

      // Records with ChangeDocDatabaseTableField = KEY must be change to CHAINNO => for right display of a text which is used in UI

      case I_ChangeDocumentItem.ChangeDocDatabaseTableField
               when 'KEY'
                 then  'CHAINNO'
                 else cast ( I_ChangeDocumentItem.ChangeDocDatabaseTableField as fieldname preserving type )
               end                                                                                       as DatabaseTableFieldName,

      cast( 'ITBCHAIN' as tabelle )                                                                      as ObjectDatabaseTable,

      _BankChainChangeDocument,
      _ChangeDocLongTableKey,
      _ChgDocItemChangeTypeText
}
where
  I_ChangeDocumentItem.ChangeDocObjectClass = 'BCHAINP'

Learn More