C_RO_SAFTSupplierBankAccount

DDL: C_RO_SAFTSUPPLIERBANKACCOUNT SQL: CROSAFTSUPBNKACC Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_RO
7 Fields 1 Data Sources

RO SAFT Supplier Bank Account Details

C_RO_SAFTSupplierBankAccount is a Consumption CDS View that provides data about "RO SAFT Supplier Bank Account Details" in SAP S/4HANA. It reads from 1 data source (I_SupplierBankDetails) and exposes 7 fields with key fields BusinessPartnerNumber, BankCountry, Bank, BankAccount. Part of development package GLO_FIN_IS_SAFT_RO.

Data Sources (1)

SourceAliasJoin Type
I_SupplierBankDetails SupBank from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTSUPBNKACC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label RO SAFT Supplier Bank Account Details view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerNumber I_SupplierBankDetails Supplier Supplier
KEY BankCountry I_SupplierBankDetails BankCountry Bank Ctry/Rgn. Key
KEY Bank I_SupplierBankDetails Bank Bank Number
KEY BankAccount I_SupplierBankDetails BankAccount Bank acct
BankAccountHolderName I_SupplierBankDetails BankAccountHolderName Account Holder
BankControlKey I_SupplierBankDetails BankControlKey Control Key
IBAN

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_RO_SAFTSupplierBankAccount.
-- 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.
-- SQL view name: CROSAFTSUPBNKACC

CREATE VIEW C_RO_SAFTSupplierBankAccount AS
SELECT
  SupBank.Supplier AS BusinessPartnerNumber,
  SupBank.BankCountry AS BankCountry,
  SupBank.Bank AS Bank,
  SupBank.BankAccount AS BankAccount,
  SupBank.BankAccountHolderName AS BankAccountHolderName,
  SupBank.BankControlKey AS BankControlKey,
  coalesce(Iban.IBAN, '') AS IBAN
FROM I_SupplierBankDetails AS SupBank
;

Learn More