I_LglCntntMDocAggregation
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)
| Source | Alias | Join Type |
|---|---|---|
| I_LegalDocument | _Document | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_LegalDocument | _DocumentAuth | $projection.LglCntntMDocumentUUID = _DocumentAuth.LglCntntMDocumentUUID |
| [1..1] | I_LglCntntMSgntrParam | _LglCntntMSgntrParam | _LglCntntMSgntrParam.LglCntntMSgntrParameter = 'ACTIVATE_ESIGN' |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA