I_LatestUtilsInvcgDocReleased

DDL: I_LATESTUTILSINVCGDOCRELEASED SQL: IELTSTUINVDOCREL Type: view COMPOSITE

Latest Invoicing Document is Released

I_LatestUtilsInvcgDocReleased is a Composite CDS View that provides data about "Latest Invoicing Document is Released" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesInvoicingDocument) and exposes 4 fields with key field UtilitiesInvoicingDocument. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_UtilitiesInvoicingDocument UtilitiesInvoicingDocument from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UtilitiesInvoicingDocument _UtilitiesInvoicingDocument $projection.UtilitiesInvoicingDocument = _UtilitiesInvoicingDocument.UtilitiesInvoicingDocument

Annotations (8)

NameValueLevelField
EndUserText.label Latest Invoicing Document is Released view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IELTSTUINVDOCREL 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
DocumentDate
ContractAccount I_UtilitiesInvoicingDocument ContractAccount
_UtilitiesInvoicingDocument _UtilitiesInvoicingDocument 
@EndUserText.label: 'Latest Invoicing Document is Released'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IELTSTUINVDOCREL'
@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_LatestUtilsInvcgDocReleased
  as select from I_UtilitiesInvoicingDocument as UtilitiesInvoicingDocument
  association [1..1] to I_UtilitiesInvoicingDocument as _UtilitiesInvoicingDocument on $projection.UtilitiesInvoicingDocument = _UtilitiesInvoicingDocument.UtilitiesInvoicingDocument
{
  key max( UtilitiesInvoicingDocument.UtilitiesInvoicingDocument ) as UtilitiesInvoicingDocument,

      max( UtilitiesInvoicingDocument.DocumentDate )               as DocumentDate,

      UtilitiesInvoicingDocument.ContractAccount,

      _UtilitiesInvoicingDocument
}
where

      UtilitiesInvoicingDocument.UtilsInvcgDocIsNotReleased = '' //Released

  and UtilitiesInvoicingDocument.UtilsInvcgDocIsReversed    = '' //Not Reversed

  and UtilitiesInvoicingDocument.UtilsInvcgDocIsSimulated   = '' //Not Simulated


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

Learn More