I_ProdCmplncPhrs

DDL: I_PRODCMPLNCPHRS Type: view BASIC Package: EHFND_RAP_PHRASE

Phrase

I_ProdCmplncPhrs is a Basic CDS View that provides data about "Phrase" in SAP S/4HANA. It reads from 1 data source (ehfndd_phrs) and exposes 17 fields with key field ProdCmplncPhrsUUID. It has 4 associations to related views. Part of development package EHFND_RAP_PHRASE.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
ehfndd_phrs ehfndd_phrs from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ProdCmplncPhrsEnabledField _ProdCmplncPhrsEnabledField $projection.ProdCmplncPhrsEnabledFldUUID = _ProdCmplncPhrsEnabledField.ProdCmplncPhrsEnabledFldUUID
[0..*] I_ProdCmplncPhrsText _ProdCmplncPhrsText $projection.ProdCmplncPhrsUUID = _ProdCmplncPhrsText.ProdCmplncPhrsUUID
[0..1] I_ProdCmplncCntntUser _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_ProdCmplncCntntUser _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPCPHRS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Phrase view
ObjectModel.representativeKey ProdCmplncPhrsUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncPhrsUUID prodcmplncphrsuuid
ProdCmplncPhrsEnabledFldUUID prodcmplncphrsenabledflduuid
ContentProvider contentprovider
ProdCmplncPhrs prodcmplncphrs
ProdCmplncPhrsCode prodcmplncphrscode
ProdCmplncPhrsNote prodcmplncphrsnote
ProdCmplncPhrsIsHidden prodcmplncphrsishidden
ProdCmplncPhrsIsHistorical prodcmplncphrsishistorical
ProdCmplncPhrsSyncUUID prodcmplncphrssyncuuid
CreationDateTime creationdatetime
CreatedByUser createdbyuser
LastChangeDateTime lastchangedatetime
LastChangedByUser lastchangedbyuser
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_ProdCmplncPhrsText _ProdCmplncPhrsText
_ProdCmplncPhrsEnabledField _ProdCmplncPhrsEnabledField 
@AbapCatalog: {
  sqlViewName: 'IPCPHRS',
  compiler.compareFilter: true }

@AccessControl:
{
  authorizationCheck: #CHECK,
  privilegedAssociations: ['_CreatedByUser','_LastChangedByUser']
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Phrase'

@ObjectModel:
{
  representativeKey: 'ProdCmplncPhrsUUID',
  usageType:
  {
    serviceQuality: #A,
    sizeCategory:  #L,
    dataClass: #MASTER
  }
}

@VDM.viewType: #BASIC

define view I_ProdCmplncPhrs
  as select from ehfndd_phrs

  // to parent / to root

  association [1..1] to I_ProdCmplncPhrsEnabledField as _ProdCmplncPhrsEnabledField on $projection.ProdCmplncPhrsEnabledFldUUID = _ProdCmplncPhrsEnabledField.ProdCmplncPhrsEnabledFldUUID

  // to child

  association [0..*] to I_ProdCmplncPhrsText         as _ProdCmplncPhrsText         on $projection.ProdCmplncPhrsUUID = _ProdCmplncPhrsText.ProdCmplncPhrsUUID

  // admin fields

  association [0..1] to I_ProdCmplncCntntUser         as _CreatedByUser              on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_ProdCmplncCntntUser         as _LastChangedByUser          on $projection.LastChangedByUser = _LastChangedByUser.UserID
{

      /**** Keys ****/

  key prodcmplncphrsuuid           as ProdCmplncPhrsUUID,
      prodcmplncphrsenabledflduuid as ProdCmplncPhrsEnabledFldUUID,


      /**** Content ****/

      contentprovider              as ContentProvider,
      prodcmplncphrs               as ProdCmplncPhrs,
      prodcmplncphrscode           as ProdCmplncPhrsCode,
      prodcmplncphrsnote           as ProdCmplncPhrsNote,
      prodcmplncphrsishidden       as ProdCmplncPhrsIsHidden,
      prodcmplncphrsishistorical   as ProdCmplncPhrsIsHistorical,
      prodcmplncphrssyncuuid       as ProdCmplncPhrsSyncUUID,
     
      /**** Admin Fields ****/

      @Semantics.systemDateTime.createdAt: true
      creationdatetime             as CreationDateTime,
      @Semantics.user.createdBy: true
      createdbyuser                as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangedatetime           as LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      lastchangedbyuser            as LastChangedByUser,


      /**** Associations ****/

      _CreatedByUser,
      _LastChangedByUser,
      _ProdCmplncPhrsText,
      _ProdCmplncPhrsEnabledField
}

Learn More