C_ChgRecdPLMEPDCollabn

DDL: C_CHGRECDPLMEPDCOLLABN SQL: CCHGRECPLMEPDCLB Type: view CONSUMPTION

Change Record PLM EPD Collaboration

C_ChgRecdPLMEPDCollabn is a Consumption CDS View that provides data about "Change Record PLM EPD Collaboration" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdPLMEPDCollabn) and exposes 8 fields with key fields ChgRecdPLMEPDCollabnUUID, ChangeRecordUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdPLMEPDCollabn EPDCollaboration from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_ChangeRecordObjPg _ChangeRecordObjPg $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCHGRECPLMEPDCLB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Change Record PLM EPD Collaboration view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChgRecdPLMEPDCollabnUUID ChgRecdPLMEPDCollabnUUID
KEY ChangeRecordUUID ChangeRecordUUID
ChgRecdPLMEPDCollabnType ChgRecdPLMEPDCollabnType
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
_ChangeRecordObjPg _ChangeRecordObjPg
PLMEPDCollabnURL
ChgRecdPLMEPDCollabnID ChgRecdPLMEPDCollabnID
@AbapCatalog.sqlViewName: 'CCHGRECPLMEPDCLB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Change Record PLM EPD Collaboration'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L}

@Metadata.allowExtensions: true

define view C_ChgRecdPLMEPDCollabn
  as select from I_ChgRecdPLMEPDCollabn as EPDCollaboration
  //  association [0..1] to I_UserContactCard   as _CreatedByUserContactCard on $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID

  association [0..1] to C_ChangeRecordObjPg as _ChangeRecordObjPg on $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
{
  key ChgRecdPLMEPDCollabnUUID,
  key ChangeRecordUUID,
      ChgRecdPLMEPDCollabnType,
      CreationDateTime,
      //      @ObjectModel.text.element: ['CreatedByUserFullName']

      CreatedByUser,
      //      _CreatedByUserContactCard.FullName as CreatedByUserFullName,

      _ChangeRecordObjPg,
      //      _CreatedByUserContactCard

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_PLMI_EPD_COLLABN_GET_URL'
      cast( '' as engcollabnchgrecd_url ) as PLMEPDCollabnURL,
      ChgRecdPLMEPDCollabnID

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