P_BankAddressChangeDocument

DDL: P_BANKADDRESSCHANGEDOCUMENT Type: view_entity BASIC Package: VDM_BF_BANK
19 Fields 1 Data Sources

Address Change Document

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

Data Sources (1)

SourceAliasJoin Type
P_BankAddressChDocItem P_BankAddressChDocItem from

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 #M view
EndUserText.label Address Change Document view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocument ChangeDocument Document Number
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType
KEY ChangeDocObject ChangeDocObject Object Value
KEY ChangeDocObjectClass Change Doc. Object
KEY DatabaseTable DatabaseTable Table Name
KEY ChangeDocItemChangeTypeText _ChangeTypeText Text User Group
KEY DatabaseTableFieldName _FieldTextDDIC Text User Group
KEY ChangeDocTransactionCode TransactionCode Transaction Code
BankCountry
BankInternalID
ChangeDocPreviousFieldValue
ChangeDocNewFieldValue
CreatedByUser User Name
CreationDate Time Stamp
CreationTime Time of Change
_ChangeTypeText _ChangeTypeText
_FieldTextDDIC _FieldTextDDIC

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_BankAddressChangeDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_BankAddressChangeDocument AS
SELECT
  ChangeDocument,
  ChangeDocTableKey,
  ChangeDocDatabaseTableField,
  cast ( ChangeDocItemChangeType as bf_bank_change_document_type preserving type ) AS ChangeDocItemChangeType,
  ChangeDocObject,
  cast(ChangeDocObjectClass as bf_bank_change_document_object preserving type ) AS ChangeDocObjectClass,
  DatabaseTable,
  _ChangeTypeText.Text AS ChangeDocItemChangeTypeText,
  _FieldTextDDIC.Text AS DatabaseTableFieldName,
  TransactionCode AS ChangeDocTransactionCode,
  cast ( '' as land1 ) AS BankCountry,
  cast ( '' as bankk ) AS BankInternalID,
  cast ( ChangeDocPreviousFieldValue as bf_bank_old_fieldval preserving type ) AS ChangeDocPreviousFieldValue,
  cast ( ChangeDocNewFieldValue as bf_bank_new_fieldval preserving type ) AS ChangeDocNewFieldValue,
  cast ( CreatedByUser as bf_bank_changedby preserving type ) AS CreatedByUser,
  cast ( CreationDate as bf_bank_changedon preserving type ) AS CreationDate,
  cast ( CreationTime as bf_bank_changetime preserving type ) AS CreationTime
FROM P_BankAddressChDocItem
;

Learn More