I_ARLockbox

DDL: I_ARLOCKBOX SQL: IARLOCKBOX Type: view COMPOSITE

Lockboxes at our House Banks

I_ARLockbox is a Composite CDS View that provides data about "Lockboxes at our House Banks" in SAP S/4HANA. It reads from 1 data source (P_Arlockboxbatch) and exposes 7 fields with key fields Lockbox, CompanyCode, HouseBank, HouseBankAccount. It has 3 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
P_Arlockboxbatch P_Arlockboxbatch from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Housebank _HouseBank $projection.HouseBank = _HouseBank.HouseBank and $projection.CompanyCode = _HouseBank.CompanyCode
[0..1] I_HouseBankAccountVH _HouseBankAccountVH _HouseBankAccountVH.CompanyCode = $projection.CompanyCode and _HouseBankAccountVH.HouseBank = $projection.HouseBank and _HouseBankAccountVH.HouseBankAccount = $projection.HouseBankAccount

Annotations (10)

NameValueLevelField
EndUserText.label Lockboxes at our House Banks view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName IARLOCKBOX view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Lockbox
KEY CompanyCode CompanyCode
KEY HouseBank HouseBank
KEY HouseBankAccount HouseBankAccount House Bank Account
_CompanyCode _CompanyCode
_HouseBank _HouseBank
_HouseBankAccountVH _HouseBankAccountVH 
@EndUserText.label: 'Lockboxes at our House Banks' 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED //only company data

@AbapCatalog.sqlViewName: 'IARLOCKBOX'
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.sizeCategory: #S 
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@Search.searchable: true


define view I_ARLockbox 
   as select from P_Arlockboxbatch  
  association [1..1] to I_CompanyCode         as _CompanyCode         on $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_Housebank           as _HouseBank           on  $projection.HouseBank   = _HouseBank.HouseBank
                                                                      and $projection.CompanyCode = _HouseBank.CompanyCode
  association [0..1] to I_HouseBankAccountVH  as _HouseBankAccountVH  on  _HouseBankAccountVH.CompanyCode       = $projection.CompanyCode 
                                                                      and _HouseBankAccountVH.HouseBank         = $projection.HouseBank
                                                                      and _HouseBankAccountVH.HouseBankAccount  = $projection.HouseBankAccount { 
  //no default search element: otherwise dump

  key cast(Lockbox as far_lbnum) as Lockbox,
        @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
  @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
  @ObjectModel.foreignKey.association: '_HouseBank'
  key HouseBank,
  @Consumption.valueHelp: '_HouseBankAccountVH'
  //default search element: otherwise ATC

  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @EndUserText.label: 'House Bank Account' 
  key HouseBankAccount,
//  //no default search element: otherwise dump

//  key cast(Lockbox as far_lbnum) as Lockbox,

  _CompanyCode,
  _HouseBank,
  _HouseBankAccountVH
} group by CompanyCode, HouseBank, HouseBankAccount, Lockbox

Learn More