R_CashBankTP

DDL: R_CASHBANKTP Type: view_entity TRANSACTIONAL
38 Fields 1 Data Sources 15 Associations

Cash Transactional Bank TP

R_CashBankTP is a Transactional CDS View that provides data about "Cash Transactional Bank TP" in SAP S/4HANA. It reads from 1 data source (I_Bank_2) and exposes 38 fields with key fields BankCountry, BankInternalID. It has 15 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Bank_2 Bank from

Associations (15)

CardinalityTargetAliasCondition
[1..1] R_BankTP _Bank $projection.BankCountry = _Bank.BankCountry and $projection.BankInternalID = _Bank.BankInternalID
[0..1] I_RiskBusinessPartner _RiskBP $projection.BankCountry = _RiskBP.BankCountry and $projection.BankInternalID = _RiskBP.BankInternalID and _RiskBP.ValidFrom <= $session.system_date and _RiskBP.ValidTo >= $session.system_date
[0..1] I_NumberOfCashBankUsage _BankUsage $projection.BankCountry = _BankUsage.BankCountry and $projection.BankInternalID = _BankUsage.BankInternalID
[0..1] I_CashBankHierarchyRootName _BankHierarchy $projection.BankCountry = _BankHierarchy.BankCountry and $projection.BankInternalID = _BankHierarchy.BankInternalID
[0..1] I_User _CreatedBy $projection.createdbyuser = _CreatedBy.UserID
[1..1] I_CshBkCatWithSEPAValueHelp _BankCategory $projection.BankCategory = _BankCategory.BankCategory
[0..1] I_Region _Region $projection.addressregion = _Region.Region and $projection.BankCountry = _Region.Country
[0..1] I_Country _Country $projection.BankCountry = _Country.Country
[0..1] I_UserContactCard _UserContactCardCreation $projection.createdbyuser = _UserContactCardCreation.ContactCardID
[0..*] R_CashBankHouseBankTP _HouseBank
[0..*] R_CashBankServiceMappingTP _BankServiceMapping
[0..*] R_CashBankNettingPartnerTP _NettingBusinessPartner
[0..*] R_CashBankRelatedBranchTP _RelatedBranch
[0..1] R_BankIntradayStatementRuleTP _BankIntradayStatementRule
[0..1] R_BankRiskBusinessPartnerTP _RiskBusinessPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cash Transactional Bank TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable false view
ObjectModel.sapObjectNodeType.name Bank view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY BankCountry I_Bank_2 BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID I_Bank_2 BankInternalID Bank Key
CreatedByUser _Bank CreatedByUser User Name
BankNetworkGrouping _Bank BankNetworkGrouping Bank group
BankNumber _Bank BankNumber Bank Key
SWIFTCode _Bank SWIFTCode SWIFT/BIC
IsMarkedForDeletion _Bank IsMarkedForDeletion Purch.org. data
BankHierarchyGroupName _BankHierarchy BankHierarchyGroupName
LastChangeDateTime _Bank LastChangeDateTime Timestamp
LongBankName _Bank LongBankName
LongBankBranch _Bank LongBankBranch
StreetName _Bank StreetName Text
CityName _Bank CityName Name
AddressRegion _Bank AddressRegion Region
BankIsInternal _Bank BankIsInternal
CashBankKeyForDisplay _Bank BankInternalID Bank Key
AddressID _Bank AddressID Ship-to address
BankIsStandard _Bank BankIsStandard
LongBankBranchIsHidden _Bank LongBankBranchIsHidden
BankNumberIsHidden _Bank BankNumberIsHidden
SWIFTCodeIsHidden _Bank SWIFTCodeIsHidden
BankNetworkGroupingIsHidden _Bank BankNetworkGroupingIsHidden
BankAddressIsHidden _Bank BankAddressIsHidden
BankScriptedAddressIsHidden _Bank BankScriptedAddressIsHidden
_BankCategory _BankCategory
_BankUsage _BankUsage
_Country _Country
_Region _Region
_CreatedBy _CreatedBy
_BankHierarchy _BankHierarchy
_RiskBP _RiskBP
_HouseBank _HouseBank
_BankServiceMapping _BankServiceMapping
_NettingBusinessPartner _NettingBusinessPartner
_RelatedBranch _RelatedBranch
_UserContactCardCreation _UserContactCardCreation
_BankIntradayStatementRule _BankIntradayStatementRule
_RiskBusinessPartner _RiskBusinessPartner

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_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 R_CashBankTP AS
SELECT
  Bank.BankCountry AS BankCountry,
  Bank.BankInternalID AS BankInternalID,
  _Bank.CreatedByUser AS CreatedByUser,
  _Bank.BankNetworkGrouping AS BankNetworkGrouping,
  _Bank.BankNumber AS BankNumber,
  _Bank.SWIFTCode AS SWIFTCode,
  _Bank.IsMarkedForDeletion AS IsMarkedForDeletion,
  _BankHierarchy.BankHierarchyGroupName AS BankHierarchyGroupName,
  _Bank.LastChangeDateTime AS LastChangeDateTime,
  _Bank.LongBankName AS LongBankName,
  _Bank.LongBankBranch AS LongBankBranch,
  _Bank.StreetName AS StreetName,
  _Bank.CityName AS CityName,
  _Bank.AddressRegion AS AddressRegion,
  _Bank.BankIsInternal AS BankIsInternal,
  _Bank.BankInternalID AS CashBankKeyForDisplay,
  _Bank.AddressID AS AddressID,
  _Bank.BankIsStandard AS BankIsStandard,
  _Bank.LongBankBranchIsHidden AS LongBankBranchIsHidden,
  _Bank.BankNumberIsHidden AS BankNumberIsHidden,
  _Bank.SWIFTCodeIsHidden AS SWIFTCodeIsHidden,
  _Bank.BankNetworkGroupingIsHidden AS BankNetworkGroupingIsHidden,
  _Bank.BankAddressIsHidden AS BankAddressIsHidden,
  _Bank.BankScriptedAddressIsHidden AS BankScriptedAddressIsHidden
FROM I_Bank_2 AS Bank
LEFT OUTER JOIN R_BankTP AS _Bank ON BankCountry = _Bank.BankCountry AND BankInternalID = _Bank.BankInternalID  -- association [1..1]
LEFT OUTER JOIN I_RiskBusinessPartner AS _RiskBP ON BankCountry = _RiskBP.BankCountry AND BankInternalID = _RiskBP.BankInternalID AND _RiskBP.ValidFrom <= $session.system_date AND _RiskBP.ValidTo >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_NumberOfCashBankUsage AS _BankUsage ON BankCountry = _BankUsage.BankCountry AND BankInternalID = _BankUsage.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_CashBankHierarchyRootName AS _BankHierarchy ON BankCountry = _BankHierarchy.BankCountry AND BankInternalID = _BankHierarchy.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedBy ON createdbyuser = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_CshBkCatWithSEPAValueHelp AS _BankCategory ON BankCategory = _BankCategory.BankCategory  -- association [1..1]
LEFT OUTER JOIN I_Region AS _Region ON addressregion = _Region.Region AND BankCountry = _Region.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON BankCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCardCreation ON createdbyuser = _UserContactCardCreation.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_CashBankHouseBankTP AS _HouseBank ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CashBankServiceMappingTP AS _BankServiceMapping ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CashBankNettingPartnerTP AS _NettingBusinessPartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CashBankRelatedBranchTP AS _RelatedBranch ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_BankIntradayStatementRuleTP AS _BankIntradayStatementRule ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_BankRiskBusinessPartnerTP AS _RiskBusinessPartner ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More