C_CashBankTP

DDL: C_CASHBANKTP Type: view_entity CONSUMPTION Package: FCLM_MANAGEBANKS
45 Fields 1 Data Sources 5 Associations 2 OData Services

Cash Transactional Bank Consumption

C_CashBankTP is a Consumption CDS View that provides data about "Cash Transactional Bank Consumption" in SAP S/4HANA. It reads from 1 data source (R_CashBankTP) and exposes 45 fields with key fields BankCountry, BankInternalID. It has 5 associations to related views. It is exposed through 2 OData services (ASQL_F1574A, UI_CASHBANK_MANAGE). Part of development package FCLM_MANAGEBANKS.

Data Sources (1)

SourceAliasJoin Type
R_CashBankTP R_CashBankTP projection

Associations (5)

CardinalityTargetAliasCondition
[0..1] C_CashBankAddress _BankAddress $projection.BankCountry = _BankAddress.BankCountry and $projection.BankInternalID = _BankAddress.BankInternalID
[0..*] C_CashBankScriptedAddress _BankScriptedAddress $projection.BankCountry = _BankScriptedAddress.BankCountry and $projection.BankInternalID = _BankScriptedAddress.BankInternalID
[0..*] C_CashBankContactPerson _ContactPerson $projection.BankCountry = _ContactPerson.BankCountry and $projection.BankInternalID = _ContactPerson.BankInternalID
[0..*] C_CashBankBusinessPartnerUsed _BusinessPartnerUsed $projection.BankCountry = _BusinessPartnerUsed.BankCountry and $projection.BankInternalID = _BusinessPartnerUsed.BankInternalID
[0..*] C_CashBankCompanyCodeUsed _CompanyCodeUsed $projection.BankCountry = _CompanyCodeUsed.BankCountry and $projection.BankInternalID = _CompanyCodeUsed.BankInternalID

Annotations (8)

NameValueLevelField
EndUserText.label Cash Transactional Bank Consumption view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F1574A ASQL_F1574A C2 NOT_RELEASED
UI_CASHBANK_MANAGE UI_CASHBANK_MANAGE V4 C1 NOT_RELEASED

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID BankInternalID Bank Key
CashBankKeyForDisplay CashBankKeyForDisplay Bank Key
CreatedByUser CreatedByUser User Name
LongBankName LongBankName
LongBankBranch LongBankBranch
AddressRegion AddressRegion Region
CityName CityName Name
StreetName StreetName Text
BankIsInternal BankIsInternal
BankIsStandard BankIsStandard
SWIFTCode SWIFTCode SWIFT/BIC
BankNetworkGrouping BankNetworkGrouping
BankNumber BankNumber Bank Key
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
BankCategory BankCategory
BankCategoryDescription _BankCategory BankCategoryDescription
BankIsMyBank BankIsMyBank
BankHasHouseBanks BankHasHouseBanks
BankHasBankAccounts BankHasBankAccounts
LastChangeDateTime LastChangeDateTime Created On
LongBankBranchIsHidden LongBankBranchIsHidden
BankNumberIsHidden BankNumberIsHidden
SWIFTCodeIsHidden SWIFTCodeIsHidden
BankNetworkGroupingIsHidden BankNetworkGroupingIsHidden
BankAddressIsHidden BankAddressIsHidden
BankScriptedAddressIsHidden BankScriptedAddressIsHidden
NumberOfBankAccounts _BankUsage NumberOfBankAccounts
NumberOfHouseBanks _BankUsage NumberOfHouseBanks
NumberOfBusinessPartnerUsed _BankUsage NumberOfBusinessPartnerUsed
NumberOfCompanyUsed _BankUsage NumberOfCompanyUsed
BankCountryName
RegionName
CreatedByUserFullName _CreatedBy UserDescription Full Name
BankHierarchyGroupName _BankHierarchy BankHierarchyGroupName
virtualHouseBanksIsHiddenabap_boolean
virtualChangeDocObjectcdobjectv
_BankAddress _BankAddress
_BankScriptedAddress _BankScriptedAddress
_ContactPerson _ContactPerson
_BusinessPartnerUsed _BusinessPartnerUsed
_CompanyCodeUsed _CompanyCodeUsed
_BankCategory _BankCategory
_Country _Country
_UserContactCardCreation _UserContactCardCreation

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_CashBankTP.
-- 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_CashBankTP AS
SELECT
  BankCountry,
  BankInternalID,
  CashBankKeyForDisplay,
  CreatedByUser,
  LongBankName,
  LongBankBranch,
  AddressRegion,
  CityName,
  StreetName,
  BankIsInternal,
  BankIsStandard,
  SWIFTCode,
  BankNetworkGrouping,
  BankNumber,
  IsMarkedForDeletion,
  BankCategory,
  _BankCategory.BankCategoryDescription AS BankCategoryDescription,
  BankIsMyBank,
  BankHasHouseBanks,
  BankHasBankAccounts,
  LastChangeDateTime,
  LongBankBranchIsHidden,
  BankNumberIsHidden,
  SWIFTCodeIsHidden,
  BankNetworkGroupingIsHidden,
  BankAddressIsHidden,
  BankScriptedAddressIsHidden,
  _BankUsage.NumberOfBankAccounts AS NumberOfBankAccounts,
  _BankUsage.NumberOfHouseBanks AS NumberOfHouseBanks,
  _BankUsage.NumberOfBusinessPartnerUsed AS NumberOfBusinessPartnerUsed,
  _BankUsage.NumberOfCompanyUsed AS NumberOfCompanyUsed,
  _Country._Text[1:Language = $session.system_language].CountryShortName AS BankCountryName,
  _Region._RegionText[1:Language = $session.system_language].RegionName AS RegionName,
  _CreatedBy.UserDescription AS CreatedByUserFullName,
  _BankHierarchy.BankHierarchyGroupName AS BankHierarchyGroupName,
  virtual HouseBanksIsHidden :abap_boolean AS virtualHouseBanksIsHiddenabap_boolean,
  virtual ChangeDocObject :cdobjectv AS virtualChangeDocObjectcdobjectv
FROM R_CashBankTP
LEFT OUTER JOIN C_CashBankAddress AS _BankAddress ON BankCountry = _BankAddress.BankCountry AND BankInternalID = _BankAddress.BankInternalID  -- association [0..1]
LEFT OUTER JOIN C_CashBankScriptedAddress AS _BankScriptedAddress ON BankCountry = _BankScriptedAddress.BankCountry AND BankInternalID = _BankScriptedAddress.BankInternalID  -- association [0..*]
LEFT OUTER JOIN C_CashBankContactPerson AS _ContactPerson ON BankCountry = _ContactPerson.BankCountry AND BankInternalID = _ContactPerson.BankInternalID  -- association [0..*]
LEFT OUTER JOIN C_CashBankBusinessPartnerUsed AS _BusinessPartnerUsed ON BankCountry = _BusinessPartnerUsed.BankCountry AND BankInternalID = _BusinessPartnerUsed.BankInternalID  -- association [0..*]
LEFT OUTER JOIN C_CashBankCompanyCodeUsed AS _CompanyCodeUsed ON BankCountry = _CompanyCodeUsed.BankCountry AND BankInternalID = _CompanyCodeUsed.BankInternalID  -- association [0..*]
;

Learn More