I_ExpsrScenGenDataTP

DDL: I_EXPSRSCENGENDATATP Type: view TRANSACTIONAL

General Data - TP

I_ExpsrScenGenDataTP is a Transactional CDS View that provides data about "General Data - TP" in SAP S/4HANA. It reads from 1 data source (I_ExpsrScenGenData) and exposes 10 fields with key field PCESGeneralDataUUID. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_ExpsrScenGenData I_ExpsrScenGenData from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CmplRqRsltPCESAssmtTP _CmplRqRslt $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ICRRESGENTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label General Data - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence ehsdsw_es_gen view
ObjectModel.writeActivePersistence ehsdsv_es_gen view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.entityChangeStateId LastChangeDateTime view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PCESGeneralDataUUID PCESGeneralDataUUID
ComplianceAssessmentUUIDCmplRqRsltUUID
VersionDatePCESVersionDate
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
_CmplRqRslt _CmplRqRslt
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@AbapCatalog:
{
  sqlViewName: 'ICRRESGENTP',
  compiler.compareFilter: true,
  preserveKey: true
}

@EndUserText.label: 'General Data - TP'

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

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  modelCategory: #BUSINESS_OBJECT,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true,
  writeDraftPersistence: 'ehsdsw_es_gen',
  writeActivePersistence: 'ehsdsv_es_gen',
  semanticKey:  [ 'PCESGeneralDataUUID' ],
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
  },
  entityChangeStateId: 'LastChangeDateTime'
}
define view I_ExpsrScenGenDataTP
  as select from I_ExpsrScenGenData

  association [1..1] to I_CmplRqRsltPCESAssmtTP as _CmplRqRslt on $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID
{

  key PCESGeneralDataUUID,

      --Compliance Assessment UUID
      @ObjectModel.mandatory: true
      CmplRqRsltUUID,

      --Version Date
      PCESVersionDate,

      --General Data - Short Title1
      @ObjectModel.mandatory: true
      PCESShortTitlePhrs1UUID,

      --General Data - Short Title2
      PCESShortTitlePhrs2UUID,

      --General Data - Short Title3
      PCESShortTitlePhrs3UUID,

      --General Data - Short Title4
      PCESShortTitlePhrs4UUID,

      --General Data - Short Title5
      PCESShortTitlePhrs5UUID,

      --General Data - Short Title6
      PCESShortTitlePhrs6UUID,

      --General Data - Life cycle stages
      @ObjectModel.mandatory: true
      PCESLifeCycleStagePhrsUUID,

      --General Data - Sector of use1
      PCESSectorOfUsePhrs1UUID,

      --General Data - Sector of use2
      PCESSectorOfUsePhrs2UUID,

      --General Data - Sector of use3
      PCESSectorOfUsePhrs3UUID,

      --General Data - Sector of use4
      PCESSectorOfUsePhrs4UUID,

      --General Data - Sector of use5
      PCESSectorOfUsePhrs5UUID,

      --General Data - Sector of use6
      PCESSectorOfUsePhrs6UUID,

      @ObjectModel.readOnly: true
      CreationDateTime,

      @ObjectModel.readOnly: true
      CreatedByUser,

      @ObjectModel.readOnly: true
      LastChangeDateTime,

      @ObjectModel.readOnly: true
      LastChangedByUser,


      /* Associations */
      //      _RegisteredBy,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _CmplRqRslt,

      _CreatedByUser,
      _LastChangedByUser

}

Learn More