C_NO_SAFTGenLedgerSuplrBkAcct

DDL: C_NO_SAFTGENLEDGERSUPLRBKACCT SQL: CNOSAFTGLSBKACCT Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_NO

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. Part of development package GLO_FIN_IS_SAFT_NO.

2 data source(s) 12 fields

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
KEY Creditor I_SupplierBankDetails Supplier
KEY BankCountry I_SupplierBankDetails BankCountry
KEY Bank I_SupplierBankDetails Bank
KEY BankAccountInternalID BankAcct BankAccountInternalID
KEY BankAccount I_SupplierBankDetails BankAccount
SWIFTCode I_Bank SWIFTCode
IBAN I_SupplierBankDetails IBAN
BankAccountHolderName BankAcct BankAccountHolderName
_Supplier I_SupplierBankDetails _Supplier
_Country I_SupplierBankDetails _Country
_BankAccount I_SupplierBankDetails _BankAccount 
@AbapCatalog.sqlViewName: 'CNOSAFTGLSBKACCT'
@AbapCatalog.compiler.compareFilter: 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_Bank                as Bank on  Bank.BankCountry    = BankDetails.BankCountry
                                               and Bank.BankInternalID = BankDetails.Bank

  association [1..1] to I_SupplierCompany as SupplierCompany on  $projection.companycode  = SupplierCompany.CompanyCode
                                                             and SupplierCompany.Supplier = BankDetails.Supplier

  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_BankAccount     as BankAcct        on  BankDetails.BankCountry = BankAcct.BankCountry
                                                             and BankDetails.Bank        = BankAcct.Bank
                                                             and BankDetails.BankAccount = BankAcct.BankAccountNumber


{
  key SupplierCompany.CompanyCode,
      @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
}
where
     BankAcct.BankAccountStatus is null
  or BankAcct.BankAccountStatus = '02' //Active

Learn More