R_CashBankServiceMappingTP

DDL: R_CASHBANKSERVICEMAPPINGTP Type: view_entity TRANSACTIONAL Package: FCLM_MANAGEBANKS
21 Fields 1 Data Sources

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. Part of development package FCLM_MANAGEBANKS.

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 Bank Ctry/Rgn. Key
KEY BankInternalID I_BankFeeServiceMapping Bank Bank Number
KEY BankFeeService I_BankFeeServiceMapping BankFeeService Web Service ID
KEY PaymentTransactionTypeGroup I_BankFeeServiceMapping PaymentTransactionTypeGroup Payment Transaction Type Group
PaymentExternalTransacType I_BankFeeServiceMapping PaymentExternalTransacType External Trans
BkSrvcMappgCreatedByUser CreatedByUser User Name
BkSrvcMappgCreatedDate CreationDate Time Stamp
BkSrvcMappgCreatedTime CreationTime Time of Change
BkSrvcMappgCreatedDateTime BkSrvcMappgCreatedDateTime
BkSrvcMappgLastChgdByUser LastChangedByUser User Name
BkSrvcMappgLastChgdDate LastChangeDate Time Stamp
BkSrvcMappgLastChgdTime LastChangeTime Time changed
BkSrvcMappgLastChgdDateTime BkSrvcMappgLastChgdDateTime
_Bank _Bank
_BankDetails _BankDetails
_TransactionTypeDesc _TransactionTypeDesc
_CountryText _CountryText
_CreatedBy _CreatedBy
_LastChangedBy _LastChangedBy
_UserContactCardCreation _UserContactCardCreation
_UserContactCardChange _UserContactCardChange

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 R_CashBankServiceMappingTP.
-- 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 R_CashBankServiceMappingTP AS
SELECT
  ServiceMapping.BankCountry AS BankCountry,
  ServiceMapping.Bank AS BankInternalID,
  ServiceMapping.BankFeeService AS BankFeeService,
  ServiceMapping.PaymentTransactionTypeGroup AS PaymentTransactionTypeGroup,
  ServiceMapping.PaymentExternalTransacType AS PaymentExternalTransacType,
  CreatedByUser AS BkSrvcMappgCreatedByUser,
  CreationDate AS BkSrvcMappgCreatedDate,
  CreationTime AS BkSrvcMappgCreatedTime,
  BkSrvcMappgCreatedDateTime,
  LastChangedByUser AS BkSrvcMappgLastChgdByUser,
  LastChangeDate AS BkSrvcMappgLastChgdDate,
  LastChangeTime AS BkSrvcMappgLastChgdTime,
  BkSrvcMappgLastChgdDateTime
FROM I_BankFeeServiceMapping AS ServiceMapping
;

Learn More