C_BG_SAFTSupplierBankAccount

DDL: C_BG_SAFTSUPPLIERBANKACCOUNT Type: view_entity CONSUMPTION Package: GLO_FIN_IS_SAFT_BG
12 Fields 1 Data Sources

BG SAFT Supplier Bank Account Details

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

Data Sources (1)

SourceAliasJoin Type
I_SupplierBankDetails SupBank from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BG SAFT Supplier Bank Account Details view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Supplier 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 I_SupplierBankDetails IBAN IBAN House Bank
AuthorizationGroup I_SupplierBankDetails AuthorizationGroup AuthorizGroup
BusinessPartner I_SupplierBankDetails BusinessPartner Issuing Authority
BPBankAccountInternalID I_SupplierBankDetails BPBankAccountInternalID BP Bank Account
_Supplier I_SupplierBankDetails _Supplier
_BusinessPartnerBank I_SupplierBankDetails _BusinessPartnerBank

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_BG_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.

CREATE VIEW C_BG_SAFTSupplierBankAccount AS
SELECT
  SupBank.Supplier AS Supplier,
  SupBank.BankCountry AS BankCountry,
  SupBank.Bank AS Bank,
  SupBank.BankAccount AS BankAccount,
  SupBank.BankAccountHolderName AS BankAccountHolderName,
  SupBank.BankControlKey AS BankControlKey,
  SupBank.IBAN AS IBAN,
  SupBank.AuthorizationGroup AS AuthorizationGroup,
  SupBank.BusinessPartner AS BusinessPartner,
  SupBank.BPBankAccountInternalID AS BPBankAccountInternalID,
  SupBank._Supplier AS _Supplier,
  SupBank._BusinessPartnerBank AS _BusinessPartnerBank
FROM I_SupplierBankDetails AS SupBank
;

Learn More