C_NO_SAFTGenLedgerSuplrBkAcct

DDL: C_NO_SAFTGENLEDGERSUPLRBKACCT SQL: CNOSAFTGLSBKACCT Type: view CONSUMPTION
12 Fields 2 Data Sources 2 Associations

SAF-T Norway GL Supplier Bank Accounts

C_NO_SAFTGenLedgerSuplrBkAcct is a Consumption CDS View that provides data about "SAF-T Norway GL Supplier Bank Accounts" in SAP S/4HANA. It reads from 2 data sources (I_Bank, I_SupplierBankDetails) and exposes 12 fields with key fields CompanyCode, Creditor, BankCountry, Bank, BankAccountInternalID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_Bank Bank inner
I_SupplierBankDetails BankDetails from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SupplierCompany SupplierCompany $projection.companycode = SupplierCompany.CompanyCode and SupplierCompany.Supplier = BankDetails.Supplier
[0..1] I_BankAccount BankAcct BankDetails.BankCountry = BankAcct.BankCountry and BankDetails.Bank = BankAcct.Bank and BankDetails.BankAccount = BankAcct.BankAccountNumber

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CNOSAFTGLSBKACCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label SAF-T Norway GL Supplier Bank Accounts view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode SupplierCompany CompanyCode Receiver Company Code
KEY Creditor I_SupplierBankDetails Supplier Supplier
KEY BankCountry I_SupplierBankDetails BankCountry Bank Ctry/Rgn. Key
KEY Bank I_SupplierBankDetails Bank Bank Number
KEY BankAccountInternalID BankAcct BankAccountInternalID Technical ID
KEY BankAccount I_SupplierBankDetails BankAccount Bank acct
SWIFTCode I_Bank SWIFTCode SWIFT/BIC
IBAN I_SupplierBankDetails IBAN IBAN House Bank
BankAccountHolderName BankAcct BankAccountHolderName Account Holder
_Supplier I_SupplierBankDetails _Supplier
_Country I_SupplierBankDetails _Country
_BankAccount I_SupplierBankDetails _BankAccount

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_NO_SAFTGenLedgerSuplrBkAcct.
-- 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: CNOSAFTGLSBKACCT

CREATE VIEW C_NO_SAFTGenLedgerSuplrBkAcct AS
SELECT
  SupplierCompany.CompanyCode AS CompanyCode,
  BankDetails.Supplier AS Creditor,
  BankDetails.BankCountry AS BankCountry,
  BankDetails.Bank AS Bank,
  BankAcct.BankAccountInternalID AS BankAccountInternalID,
  BankDetails.BankAccount AS BankAccount,
  Bank.SWIFTCode AS SWIFTCode,
  BankDetails.IBAN AS IBAN,
  BankAcct.BankAccountHolderName AS BankAccountHolderName,
  BankDetails._Supplier AS _Supplier,
  BankDetails._Country AS _Country,
  BankDetails._BankAccount AS _BankAccount
FROM I_SupplierBankDetails AS BankDetails
INNER JOIN I_Bank AS Bank ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierCompany AS SupplierCompany ON companycode = SupplierCompany.CompanyCode AND SupplierCompany.Supplier = BankDetails.Supplier  -- association [1..1]
LEFT OUTER JOIN I_BankAccount AS BankAcct ON BankDetails.BankCountry = BankAcct.BankCountry AND BankDetails.Bank = BankAcct.Bank AND BankDetails.BankAccount = BankAcct.BankAccountNumber  -- association [0..1]
;

Learn More