R_CashBankServiceMappingTP

DDL: R_CASHBANKSERVICEMAPPINGTP Type: view_entity TRANSACTIONAL

Bank Service Mapping TP

R_CashBankServiceMappingTP is a Transactional CDS View that provides data about "Bank Service Mapping TP" in SAP S/4HANA. It reads from 1 data source (I_BankFeeServiceMapping) and exposes 21 fields with key fields BankCountry, BankInternalID, BankFeeService, PaymentTransactionTypeGroup.

Data Sources (1)

SourceAliasJoin Type
I_BankFeeServiceMapping ServiceMapping from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Service Mapping TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BankCountry I_BankFeeServiceMapping BankCountry
KEY BankInternalID I_BankFeeServiceMapping Bank
KEY BankFeeService I_BankFeeServiceMapping BankFeeService
KEY PaymentTransactionTypeGroup I_BankFeeServiceMapping PaymentTransactionTypeGroup
PaymentExternalTransacType I_BankFeeServiceMapping PaymentExternalTransacType
BkSrvcMappgCreatedByUser CreatedByUser
BkSrvcMappgCreatedDate CreationDate
BkSrvcMappgCreatedTime CreationTime
BkSrvcMappgCreatedDateTime BkSrvcMappgCreatedDateTime
BkSrvcMappgLastChgdByUser LastChangedByUser
BkSrvcMappgLastChgdDate LastChangeDate
BkSrvcMappgLastChgdTime LastChangeTime
BkSrvcMappgLastChgdDateTime BkSrvcMappgLastChgdDateTime
_Bank _Bank
_BankDetails _BankDetails
_TransactionTypeDesc _TransactionTypeDesc
_CountryText _CountryText
_CreatedBy _CreatedBy
_LastChangedBy _LastChangedBy
_UserContactCardCreation _UserContactCardCreation
_UserContactCardChange _UserContactCardChange
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck:#CHECK
@AccessControl.privilegedAssociations: ['_UserContactCardCreation' ,'_UserContactCardChange']
@EndUserText.label: 'Bank Service Mapping TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MASTER
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view entity R_CashBankServiceMappingTP as select from I_BankFeeServiceMapping as ServiceMapping
  association to parent R_CashBankTP        as _Bank                 on $projection.BankCountry        = _Bank.BankCountry
                                                                     and $projection.BankInternalID    = _Bank.BankInternalID
{
  key ServiceMapping.BankCountry                   as BankCountry,
  key ServiceMapping.Bank                          as BankInternalID,
  key ServiceMapping.BankFeeService                as BankFeeService,
  key ServiceMapping.PaymentTransactionTypeGroup   as PaymentTransactionTypeGroup,
      ServiceMapping.PaymentExternalTransacType    as PaymentExternalTransacType,
      @Semantics.user.createdBy: true
      CreatedByUser                                as BkSrvcMappgCreatedByUser,
      // @Semantics.systemDate.createdAt: true

      CreationDate                                 as BkSrvcMappgCreatedDate,
     // @Semantics.systemTime.createdAt: true

      CreationTime                                 as BkSrvcMappgCreatedTime,
      @Semantics.systemDateTime.createdAt: true
      BkSrvcMappgCreatedDateTime                   as BkSrvcMappgCreatedDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser                            as BkSrvcMappgLastChgdByUser,
     // @Semantics.systemDate.lastChangedAt: true

      LastChangeDate                               as BkSrvcMappgLastChgdDate,
     // @Semantics.systemTime.lastChangedAt: true

      LastChangeTime                               as BkSrvcMappgLastChgdTime,
      @Semantics.systemDateTime.lastChangedAt: true
      BkSrvcMappgLastChgdDateTime                  as BkSrvcMappgLastChgdDateTime,

      /* Associations */
      _Bank,
      _BankDetails,
      _TransactionTypeDesc,
      _CountryText,
      _CreatedBy,
      _LastChangedBy,
      _UserContactCardCreation,
      _UserContactCardChange

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKFEESERVICEMAPPING"
],
"ASSOCIATED":
[
"I_BANK_2",
"I_COUNTRYTEXT",
"I_PAYMENTTRANSACTIONTYPEGROUPT",
"I_USER",
"I_USERCONTACTCARD",
"R_CASHBANKTP"
],
"BASE":
[
"I_BANKFEESERVICEMAPPING"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/