I_UtilsInvcgDocOutsrtgDataRsn

DDL: I_UTILSINVCGDOCOUTSRTGDATARSN SQL: IEINVDOCOUTRSN Type: view COMPOSITE

First Record for Manually Outsorted Invoicing Document

I_UtilsInvcgDocOutsrtgDataRsn is a Composite CDS View that provides data about "First Record for Manually Outsorted Invoicing Document" in SAP S/4HANA. It reads from 2 data sources (I_UtilitiesInvoicingDocument, I_UtilsInvcgDocOutsrtgData) and exposes 4 fields with key field UtilitiesInvoicingDocument. It has 1 association to related views.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_UtilitiesInvoicingDocument UtilitiesInvoicingDocument inner
I_UtilsInvcgDocOutsrtgData UtilsInvcgDocOutsrtgData from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UtilsInvcgDocOutsrtgData _UtilsInvcgDocOutsrtgData $projection.UtilitiesInvoicingDocument = _UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument and $projection.UtilsInvcgDocSqncNmbrOutsrtg = _UtilsInvcgDocOutsrtgData.UtilsInvcgDocSqncNmbrOutsrtg

Annotations (8)

NameValueLevelField
EndUserText.label First Record for Manually Outsorted Invoicing Document view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IEINVDOCOUTRSN view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesInvoicingDocument I_UtilsInvcgDocOutsrtgData UtilitiesInvoicingDocument
UtilsInvcgDocSqncNmbrOutsrtg
_UtilitiesInvoicingDocument I_UtilsInvcgDocOutsrtgData _UtilitiesInvoicingDocument
_UtilsInvcgDocOutsrtgData _UtilsInvcgDocOutsrtgData 
@EndUserText.label: 'First Record for Manually Outsorted Invoicing Document'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IEINVDOCOUTRSN'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_UtilsInvcgDocOutsrtgDataRsn
  as select from I_UtilsInvcgDocOutsrtgData   as UtilsInvcgDocOutsrtgData
    inner join   I_UtilitiesInvoicingDocument as UtilitiesInvoicingDocument on UtilitiesInvoicingDocument.UtilitiesInvoicingDocument = UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument
  association [1..1] to I_UtilsInvcgDocOutsrtgData as _UtilsInvcgDocOutsrtgData on  $projection.UtilitiesInvoicingDocument   = _UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument
                                                                                and $projection.UtilsInvcgDocSqncNmbrOutsrtg = _UtilsInvcgDocOutsrtgData.UtilsInvcgDocSqncNmbrOutsrtg
{
      @ObjectModel.foreignKey.association: '_UtilitiesInvoicingDocument'
  key UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument,

      min(UtilsInvcgDocOutsrtgData.UtilsInvcgDocSqncNmbrOutsrtg) as UtilsInvcgDocSqncNmbrOutsrtg,

      /* Associations */
      UtilsInvcgDocOutsrtgData._UtilitiesInvoicingDocument,
      _UtilsInvcgDocOutsrtgData
}
where
      UtilsInvcgDocOutsrtgData.UtilsInvcgDocReleasedByUser   = '' //Not Released by User

  and UtilsInvcgDocOutsrtgData.UtilitiesInvoicingCheck       = '' //Not Automatically Outsorted

  and UtilitiesInvoicingDocument.UtilsInvcgDocIsNotReleased  = 'X' //Not Released

  and UtilitiesInvoicingDocument.UtilsInvcgDocIsReversed     = ''  //Not Reversed

  and UtilitiesInvoicingDocument.UtilsInvcgDocIsSimulated    = ''  //Not Simulated

  and UtilsInvcgDocOutsrtgData.UtilsInvcgDocIsReldBackground = '' // Not released

group by
  UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILITIESINVOICINGDOCUMENT",
"I_UTILSINVCGDOCOUTSRTGDATA"
],
"ASSOCIATED":
[
"I_UTILITIESINVOICINGDOCUMENT",
"I_UTILSINVCGDOCOUTSRTGDATA"
],
"BASE":
[
"I_UTILSINVCGDOCOUTSRTGDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More