P_BankAddressChangeDocument

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.private: true
@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@EndUserText.label: 'Address Change Document'
define view entity P_BankAddressChangeDocument
as select from    bnka   as bank
    inner join P_BankAddressChDocItem  as addressChangeDoc on  bank.adrnr = addressChangeDoc.BankAddressID
                                                                

  association [0..1] to I_ChangeDocChangeIndT as _ChgDocItemChangeTypeText  
    on  $projection.ChangeDocItemChangeType = _ChgDocItemChangeTypeText.Value
    and _ChgDocItemChangeTypeText.Language = $session.system_language

  association [0..1] to I_ChangeDocFieldNames as _ChangeDocFieldNames
    on $projection.ChangeDocDatabaseTableField = _ChangeDocFieldNames.Value
    and $projection.DatabaseTable = _ChangeDocFieldNames.DatabaseTable
    and _ChangeDocFieldNames.Language = $session.system_language
/*        
  association [0..1] to I_ChangeDocTableNames as _ChangeDocTableNames
    on $projection.DatabaseTable = _ChangeDocTableNames.Value
    and _ChangeDocTableNames.Language = $session.system_language
*/
{
  key bank.banks as BankCountry,
  key bank.bankl as BankInternalID,

  key addressChangeDoc.ChangeDocument               as ChangeDocument,
  key addressChangeDoc.ChangeDocTableKey            as ChangeDocTableKey,
  key addressChangeDoc.ChangeDocDatabaseTableField  as ChangeDocDatabaseTableField,
  key cast ( addressChangeDoc.ChangeDocItemChangeType  as  bf_bank_change_document_type preserving type ) as ChangeDocItemChangeType,

  key addressChangeDoc.ChangeDocObject              as ChangeDocObject,
  key addressChangeDoc.ChangeDocObjectClass         as ChangeDocObjectClass,
  key addressChangeDoc.DatabaseTable                as DatabaseTable,
  //ChangeDocLanguage,

  key _ChgDocItemChangeTypeText.Text                                            as ChangeDocItemChangeTypeText,
  //cast( DatabaseTable as tabelle preserving type ) as DatabaseTable,

  //cast( _ChangeDocTableNames.Text as changedoctablename ) as ChangeDocumentTableName,


  key _ChangeDocFieldNames.Text                                                 as DatabaseTableFieldName,
  
  key addressChangeDoc.TransactionCode                                          as ChangeDocTransactionCode,

  cast ( addressChangeDoc.ChangeDocPreviousFieldValue as bf_bank_old_fieldval preserving type ) as ChangeDocPreviousFieldValue,     
  cast ( addressChangeDoc.ChangeDocNewFieldValue as bf_bank_new_fieldval preserving type ) as ChangeDocNewFieldValue,          

  cast ( addressChangeDoc.CreatedByUser as bf_bank_changedby preserving type )    as CreatedByUser,
  cast ( addressChangeDoc.CreationDate  as bf_bank_changedon preserving type )    as CreationDate,
  cast ( addressChangeDoc.CreationTime  as bf_bank_changetime preserving type )   as CreationTime

 
  /* Associations */
 // _ChangeDocLongTableKey,

 // _ChangeDocument,

 // _ChangeDocumentItemExtension,

 // _ChangeDocFieldNames,

 // _ChangeDocTableNames


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCCHANGEINDT",
"I_CHANGEDOCFIELDNAMES",
"P_BANKADDRESSCHDOCITEM",
"BNKA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/