VALLEADINGITEMWITHGROUPID

@AbapCatalog.sqlViewName: 'VALLEADGROUPID'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
                usageType.serviceQuality: #D,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
define view VALLEADINGITEMWITHGROUPID
  as select from fins_cls_wl          as wl
    inner join            VALUATIONLEADINGITEM as invoiceList on  invoiceList.accountingdocument             = wl.accountingdocument
                                                              and invoiceList.ledgergllineitem               = wl.ledgergllineitem
                                                              and invoiceList.ledger                         = wl.ledger
                                                              and invoiceList.companycode                    = wl.companycode
                                                              and invoiceList.fiscalyear                     = wl.fiscalyear
                                                              and invoiceList.jrnlperiodendclosingrunloguuid = wl.jrnlperiodendclosingrunloguuid
{
      //select group id from item which has the minimal docln in one splitted document group

      //e.g.

      // groupID/accountingdocument/accountingdocumentitem/docln

      // ABC/1/1/1

      // DEF/1/1/2

      // With this data set the first line(ABC/1/1/1) will be selected

  key wl.accountingdocument,
  key invoiceList.accountingdocumentitem,
  key wl.ledger,
  key wl.companycode,
  key wl.fiscalyear,
      wl.group_id,
      wl.grouping_rule,
      wl.grouping_rule_step,
      wl.jrnlperiodendclosingrunloguuid,
      wl.ledgergllineitem,
      wl.marked_for_deletion,
      wl.valuation_rule_step,
      wl.clearingdate,
      wl.clearingaccountingdocument,
      wl.clearingdocfiscalyear,
      wl.is_cleared_at_keydate as IsClearedAtKeyDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VALUATIONLEADINGITEM",
"FINS_CLS_WL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/