C_NO_SAFTGenLedgerSuplrBkAcct

DDL: C_NO_SAFTGENLEDGERSUPLRBKACCT SQL: CNOSAFTGLSBKACCT Type: view CONSUMPTION

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 3 data sources (I_Bank, I_BankAccount, I_SupplierBankDetails) and exposes 11 fields with key fields Creditor, BankCountry, Bank, BankAccountInternalID, BankAccount.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_Bank Bank inner
I_BankAccount BankAcct inner
I_SupplierBankDetails BankDetails from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CNOSAFTGLSBKACCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 (11)

KeyFieldSource TableSource FieldDescription
KEY Creditor I_SupplierBankDetails Supplier
KEY BankCountry I_SupplierBankDetails BankCountry
KEY Bank I_SupplierBankDetails Bank
KEY BankAccountInternalID I_BankAccount BankAccountInternalID
KEY BankAccount I_SupplierBankDetails BankAccount
SWIFTCode I_Bank SWIFTCode
IBAN I_SupplierBankDetails IBAN
BankAccountHolderName I_BankAccount BankAccountHolderName
_Supplier I_SupplierBankDetails _Supplier
_Country I_SupplierBankDetails _Country
_BankAccount I_SupplierBankDetails _BankAccount 
@AbapCatalog.sqlViewName: 'CNOSAFTGLSBKACCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'SAF-T Norway GL Supplier Bank Accounts'
define view C_NO_SAFTGenLedgerSuplrBkAcct
  as select from I_SupplierBankDetails as BankDetails

    inner join   I_BankAccount         as BankAcct on  BankAcct.BankCountry       = BankDetails.BankCountry
                                                   and BankAcct.Bank              = BankDetails.Bank
                                                   and BankAcct.BankAccountNumber = BankDetails.BankAccount
                                                   and BankAcct.BankAccountStatus = '02' //Active


    inner join   I_Bank                as Bank     on  Bank.BankCountry    = BankDetails.BankCountry
                                                   and Bank.BankInternalID = BankDetails.Bank


{
      @ObjectModel.foreignKey.association: '_Supplier'
  key BankDetails.Supplier as Creditor,
      @ObjectModel.foreignKey.association: '_Country'
  key BankDetails.BankCountry,
  key BankDetails.Bank,
  key BankAcct.BankAccountInternalID,
      @ObjectModel.foreignKey.association: '_BankAccount'
  key BankDetails.BankAccount,

      Bank.SWIFTCode,
      BankDetails.IBAN,
      BankAcct.BankAccountHolderName,

      BankDetails._Supplier,
      BankDetails._Country,
      BankDetails._BankAccount
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANK",
"I_BANKACCOUNT",
"I_SUPPLIERBANKDETAILS"
],
"ASSOCIATED":
[
"I_BANKACCOUNT",
"I_COUNTRY",
"I_SUPPLIER"
],
"BASE":
[
"I_SUPPLIERBANKDETAILS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More