R_BankDepTP

DDL: R_BANKDEPTP Type: view_entity TRANSACTIONAL
29 Fields 1 Data Sources 3 Associations

Transactional Bank

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

Data Sources (1)

SourceAliasJoin Type
I_Bank_2 Bank from

Associations (3)

CardinalityTargetAliasCondition
[0..1] R_BankAddressDepTP _BankMainAddress _BankMainAddress.BankCountry = $projection.BankCountry and _BankMainAddress.BankInternalID = $projection.BankInternalID and _BankMainAddress.AddressRepresentationCode = ''
[1..1] C_BankCategoryVH _BankCategory $projection.BankCategory = _BankCategory.BankCategory
[0..*] R_BankAddressDepTP _BankAddress

Annotations (8)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable false view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transactional Bank view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID BankInternalID Bank Key
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
BankName BankName Bank Name
Region Region Venue Region
StreetName StreetName Text
ShortStreetName ShortStreetName Street/House
CityName CityName Name
ShortCityName ShortCityName Province
SWIFTCode SWIFTCode SWIFT/BIC
BankNetworkGrouping BankNetworkGrouping Bank group
IsPostBankAccount IsPostBankAccount Postbank Acct
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
Bank Bank Bank Number
PostOfficeBankAccount PostOfficeBankAccount Curr.Acct or Ref.No.
Branch Branch Repository branch
BankBranch BankBranch Business Place
CheckDigitCalculationMethod CheckDigitCalculationMethod Method
BankDataFileFormat BankDataFileFormat Variant
AddressID AddressID Ship-to address
BankCategory BankCategory Internal bank
CityNameendasAddressCity
RegionendasAddressRegion
StreetNameendasAddressStreet
_BankAddress _BankAddress
_Region _Region
_BankCategory _BankCategory
_Country _Country

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_BankDepTP.
-- 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_BankDepTP AS
SELECT
  BankCountry,
  BankInternalID,
  CreationDate,
  CreatedByUser,
  BankName,
  Region,
  StreetName,
  ShortStreetName,
  CityName,
  ShortCityName,
  SWIFTCode,
  BankNetworkGrouping,
  IsPostBankAccount,
  IsMarkedForDeletion,
  Bank,
  PostOfficeBankAccount,
  Branch,
  BankBranch,
  CheckDigitCalculationMethod,
  BankDataFileFormat,
  AddressID,
  BankCategory,
  case when _BankMainAddress.CityName is null then CityName else _BankMainAddress.CityName end as AddressCity AS CityNameendasAddressCity,
  case when _BankMainAddress.Region is null then Region else _BankMainAddress.Region end as AddressRegion AS RegionendasAddressRegion,
  case when _BankMainAddress.StreetName is null then StreetName else _BankMainAddress.StreetName end as AddressStreet AS StreetNameendasAddressStreet
FROM I_Bank_2 AS Bank
LEFT OUTER JOIN R_BankAddressDepTP AS _BankMainAddress ON _BankMainAddress.BankCountry = BankCountry AND _BankMainAddress.BankInternalID = BankInternalID AND _BankMainAddress.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN C_BankCategoryVH AS _BankCategory ON BankCategory = _BankCategory.BankCategory  -- association [1..1]
LEFT OUTER JOIN R_BankAddressDepTP AS _BankAddress ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More