P_Arlockboxbatchitemaggr

DDL: P_ARLOCKBOXBATCHITEMAGGR SQL: PARLOCKBOXITMAGR Type: view BASIC

P_Arlockboxbatchitemaggr is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (febep) and exposes 5 fields with key fields LockboxBatchInternalKey, LockboxBatch.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
febep febep from

Annotations (4)

NameValueLevelField
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PARLOCKBOXITMAGR view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY LockboxBatchInternalKey kukey
KEY LockboxBatch batch
Currency
NumberOfItems
int2endasNumberOfIncompleteCheques 
@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED 
@AbapCatalog.sqlViewName: 'PARLOCKBOXITMAGR'
define view P_Arlockboxbatchitemaggr 
   as select from febep
{

   key kukey                                               as LockboxBatchInternalKey,
   key batch                                               as LockboxBatch,     
//For Performance optimization over group by Currency              

   min(kwaer)                                              as Currency, 
                                     
   sum (  case epvoz 
      when 'D' then - abs(kwbtr)
      when 'S' then - abs(kwbtr)
      else kwbtr 
      end )                                                as AmountInTransactionCurrency, 
         
   count (*)                                               as NumberOfItems,
   
   sum (
        case when vb1ok = 'X' and vb2ok = 'X'
            and ( sdoc2 <> '' or estat <> '3' ) 
              then cast(0 as abap.int2)
              else cast(1 as abap.int2)  end )             as NumberOfIncompleteCheques
   
}group by kukey,                          
          batch          
          
          
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FEBEP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More