FACVD_GLMC_OIT_02

CDS View

Payment reference for bank account in G/L clearing

FACVD_GLMC_OIT_02 is a CDS View in S/4HANA. Payment reference for bank account in G/L clearing. It contains 1 fields.

1 fields

Fields (1)

KeyField CDS FieldsUsed in Views
PaymentReference PaymentReference 1 
@AbapCatalog: {sqlViewName: 'FACV_GLMC_OIT_02', preserveKey: true}
@EndUserText.label: 'Payment reference for bank account in G/L clearing'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P

define view FACVD_GLMC_OIT_02
  as select from reguh
    inner join   FACVD_GLMC_OIT_03 on  PaymentRunDate           = reguh.laufd
                                   and PaymentRunIdentification = reguh.laufi
                                   and IsProposalRun            = reguh.xvorl
{
  key reguh.zbukr                               as CompanyCode,
  key reguh.vblnr                               as AccountingDocument,
  key reguh.hktid                               as HouseBankAccount,
  key reguh.hbkid                               as HouseBank,
  key reguh.ubhkt                               as GLAccount,
      max( FACVD_GLMC_OIT_03.PaymentReference ) as PaymentReference

}
where
  reguh.xvorl = ''

group by
  reguh.zbukr,
  reguh.vblnr,
  reguh.hktid,
  reguh.hbkid,
  reguh.ubhkt

Learn More