R_LU_SAFTBankAccountDetail

DDL: R_LU_SAFTBANKACCOUNTDETAIL Type: view_entity COMPOSITE
10 Fields 1 Data Sources

SAFT LU Bank Account Detail

R_LU_SAFTBankAccountDetail is a Composite CDS View that provides data about "SAFT LU Bank Account Detail" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerBank) and exposes 10 fields with key fields BusinessPartnerNumber, BankIdentification.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerBank BPBank from

Annotations (9)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label SAFT LU Bank Account Detail view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerNumber I_BusinessPartnerBank BusinessPartner Issuing Authority
KEY BankIdentification I_BusinessPartnerBank BankIdentification Bank Details
CompanyCode
BankCountry I_BusinessPartnerBank BankCountryKey Bank Ctry/Reg.
Bank I_BusinessPartnerBank BankNumber Bank Key
BankAccount I_BusinessPartnerBank BankAccount Bank acct
BankControlKey I_BusinessPartnerBank BankControlKey Control Key
BankAccountHolderName I_BusinessPartnerBank BankAccountHolderName Account Holder
BankDetailReference I_BusinessPartnerBank BankAccountReferenceText Reference
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 R_LU_SAFTBankAccountDetail.
-- 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_LU_SAFTBankAccountDetail AS
SELECT
  BPBank.BusinessPartner AS BusinessPartnerNumber,
  BPBank.BankIdentification AS BankIdentification,
  cast('AA00' as fis_bukrs) AS CompanyCode,
  BPBank.BankCountryKey AS BankCountry,
  BPBank.BankNumber AS Bank,
  BPBank.BankAccount AS BankAccount,
  BPBank.BankControlKey AS BankControlKey,
  BPBank.BankAccountHolderName AS BankAccountHolderName,
  BPBank.BankAccountReferenceText AS BankDetailReference,
  coalesce(Iban.IBAN, '') AS IBAN
FROM I_BusinessPartnerBank AS BPBank
;

Learn More