C_CashBankServiceMappingTP

DDL: C_CASHBANKSERVICEMAPPINGTP Type: view_entity CONSUMPTION Package: FCLM_MANAGEBANKS
21 Fields 1 Data Sources 2 OData Services

Bank Service Mapping

C_CashBankServiceMappingTP is a Consumption CDS View that provides data about "Bank Service Mapping" in SAP S/4HANA. It reads from 1 data source (R_CashBankServiceMappingTP) and exposes 21 fields with key fields BankCountry, BankInternalID, BankFeeService, PaymentTransactionTypeGroup. It is exposed through 2 OData services (ASQL_F1574A, UI_CASHBANK_MANAGE). Part of development package FCLM_MANAGEBANKS.

Data Sources (1)

SourceAliasJoin Type
R_CashBankServiceMappingTP R_CashBankServiceMappingTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Bank Service Mapping view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F1574A ASQL_F1574A C2 NOT_RELEASED
UI_CASHBANK_MANAGE UI_CASHBANK_MANAGE V4 C1 NOT_RELEASED

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID BankInternalID Bank Key
KEY BankFeeService BankFeeService
KEY PaymentTransactionTypeGroup PaymentTransactionTypeGroup Payment Transaction Type Group
PaymentExternalTransacType PaymentExternalTransacType
BkSrvcMappgCreatedByUser BkSrvcMappgCreatedByUser User Name
BkSrvcMappgCreatedDate BkSrvcMappgCreatedDate Time Stamp
BkSrvcMappgCreatedTime BkSrvcMappgCreatedTime Time of Change
BkSrvcMappgCreatedDateTime BkSrvcMappgCreatedDateTime
BkSrvcMappgLastChgdByUser BkSrvcMappgLastChgdByUser User Name
BkSrvcMappgLastChgdDate BkSrvcMappgLastChgdDate Time Stamp
BkSrvcMappgLastChgdTime BkSrvcMappgLastChgdTime Time changed
BkSrvcMappgLastChgdDateTime BkSrvcMappgLastChgdDateTime
PaymentTransacTypeGroupName _TransactionTypeDesc PaymentTransacTypeGroupName
CountryName _CountryText CountryName Country
BankName _Bank LongBankName
CreatedByUserFullName _CreatedBy UserDescription Full Name
LastChangedByUserFullName _LastChangedBy UserDescription Full Name
_BankredirectedtoparentC_CashBankTP
_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 C_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 C_CashBankServiceMappingTP AS
SELECT
  BankCountry,
  BankInternalID,
  BankFeeService,
  PaymentTransactionTypeGroup,
  PaymentExternalTransacType,
  BkSrvcMappgCreatedByUser,
  BkSrvcMappgCreatedDate,
  BkSrvcMappgCreatedTime,
  BkSrvcMappgCreatedDateTime,
  BkSrvcMappgLastChgdByUser,
  BkSrvcMappgLastChgdDate,
  BkSrvcMappgLastChgdTime,
  BkSrvcMappgLastChgdDateTime,
  _TransactionTypeDesc.PaymentTransacTypeGroupName AS PaymentTransacTypeGroupName,
  _CountryText.CountryName AS CountryName,
  _Bank.LongBankName AS BankName,
  _CreatedBy.UserDescription AS CreatedByUserFullName,
  _LastChangedBy.UserDescription AS LastChangedByUserFullName
FROM R_CashBankServiceMappingTP
;

Learn More