I_LglCntntMDocAggregation

DDL: I_LGLCNTNTMDOCAGGREGATION SQL: ILCMDOCAGGR Type: view COMPOSITE

Aggregation view for I_LcmDocument

I_LglCntntMDocAggregation is a Composite CDS View that provides data about "Aggregation view for I_LcmDocument" in SAP S/4HANA. It reads from 1 data source (I_LegalDocument) and exposes 9 fields with key field LglCntntMDocumentUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LegalDocument _Document from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LegalDocument _DocumentAuth $projection.LglCntntMDocumentUUID = _DocumentAuth.LglCntntMDocumentUUID
[1..1] I_LglCntntMSgntrParam _LglCntntMSgntrParam _LglCntntMSgntrParam.LglCntntMSgntrParameter = 'ACTIVATE_ESIGN'

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ILCMDOCAGGR view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey LglCntntMDocumentUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Aggregation view for I_LcmDocument view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMDocumentUUID LglCntntMDocumentUUID
ChangeDocObject
LglCntntMCreatedUTCDateTime LglCntntMCreatedUTCDateTime
LglCntntMChangedUTCDateTime LglCntntMChangedUTCDateTime
LglCntntMDocIsVersCreateEnable
LglCntntMDocumentHasStamp
LglCntntMNumerator
BusinessPartner
_DocumentAuth _DocumentAuth
@AbapCatalog.sqlViewName: 'ILCMDOCAGGR'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType : #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter:true 

@ObjectModel: {
  representativeKey: 'LglCntntMDocumentUUID',
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #L,
  usageType.dataClass: #MIXED
}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Aggregation view for I_LcmDocument'
@AccessControl.privilegedAssociations: [ '_DocumentAuth']

define view I_LglCntntMDocAggregation
  as select from I_LegalDocument as _Document  
  
  //Authorization

  association [1..1] to I_LegalDocument       as _DocumentAuth        on $projection.LglCntntMDocumentUUID = _DocumentAuth.LglCntntMDocumentUUID
  association [1..1] to I_LglCntntMSgntrParam as _LglCntntMSgntrParam on _LglCntntMSgntrParam.LglCntntMSgntrParameter = 'ACTIVATE_ESIGN'
{
      @ObjectModel.readOnly: true
      @UI.hidden: true
  key LglCntntMDocumentUUID,

      @ObjectModel.readOnly: true
      @UI.hidden: true
      case InternalDocumentStatus
        when 'AV' then 2
        when 'AC' then 3
        else 0
        end                                 as LglCntntMDocStsCriticality,

      @ObjectModel.readOnly: true
      @UI.hidden: true
      concat('DOCUMENT', LglCntntMDocument) as ChangeDocObject,

      //      //      @ObjectModel.readOnly: true

      //            tstmp_to_dats( LglCntntMCreatedUTCDateTime,

      //                          abap_user_timezone( $session.user, $session.client,'NULL' ),

      //                          $session.client,

      //                          'NULL' )                                                                                            as  LglCntntMCreatedUTCDateTime,

      //      //      @ObjectModel.readOnly: true

      //            tstmp_to_dats( LglCntntMChangedUTCDateTime,

      //                          abap_user_timezone( $session.user, $session.client,'NULL' ),

      //                          $session.client,

      //                          'NULL' )                                                                                            as  LglCntntMChangedUTCDateTime,

      LglCntntMCreatedUTCDateTime,
      LglCntntMChangedUTCDateTime,
      @Semantics.booleanIndicator: true
      ''                                    as LglCntntMDocIsVersCreateEnable,
      @Semantics.booleanIndicator: true
      ''                                    as LglCntntMDocumentHasStamp,
      
      @UI.hidden: true
      @ObjectModel.readOnly: true
      cast( 1 as abap.int8 )                as LglCntntMNumerator,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Semantics.booleanIndicator: true
      case _LglCntntMSgntrParam.LglCntntMSgntrParamValueIsChkd
      when 'X' then ''
      when '' then 'X'
      end                                   as LglCntntMSgntrIsDisabled,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      cast( 1 as bu_partner)                as BusinessPartner,
      
      //Authorization

      _DocumentAuth

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEGALDOCUMENT",
"I_LGLCNTNTMSGNTRPARAM"
],
"ASSOCIATED":
[
"I_LEGALDOCUMENT",
"I_LGLCNTNTMSGNTRPARAM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/