I_TimeSheetProcgStatusText

DDL: I_TIMESHEETPROCGSTATUSTEXT Type: view_entity BASIC Package: VDM_TIMESHEET_CORE

TimeSheet Processing Status - Text

I_TimeSheetProcgStatusText is a Basic CDS View that provides data about "TimeSheet Processing Status - Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields Language, TimeSheetProcessingStatus. Part of development package VDM_TIMESHEET_CORE.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label TimeSheet Processing Status - Text view
ObjectModel.representativeKey TimeSheetProcessingStatus view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language ddlanguage
KEY TimeSheetProcessingStatus
TimeSheetProcessingStatusText
_TimeSheetProcgStatus _TimeSheetProcgStatus
_Language _Language
@AccessControl.authorizationCheck:  #NOT_REQUIRED

@VDM.viewType: #BASIC
@EndUserText.label: 'TimeSheet Processing Status - Text'

@ObjectModel: {
   representativeKey: 'TimeSheetProcessingStatus',
   dataCategory: #TEXT,
   usageType: {
     serviceQuality: #B,
     sizeCategory:   #M,
     dataClass:      #MASTER
   }
 }

//@ObjectModel.modelingPattern:         #LANGUAGE_DEPENDENT_TEXT

//@ObjectModel.supportedCapabilities: [ #LANGUAGE_DEPENDENT_TEXT,

//                                      #EXTRACTION_DATA_SOURCE,

//                                      #CDS_MODELING_DATA_SOURCE,

//                                      #CDS_MODELING_ASSOCIATION_TARGET,

//                                      #SQL_DATA_SOURCE ]


//@Analytics.dataExtraction.enabled: true


define view entity I_TimeSheetProcgStatusText
  as select from dd07t
     association[0..1] to I_TimeSheetProcgStatus as _TimeSheetProcgStatus      
      on $projection.TimeSheetProcessingStatus = _TimeSheetProcgStatus.TimeSheetProcessingStatus
     association[0..1] to I_Language             as _Language                  
      on $projection.Language = _Language.Language
{

      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key ddlanguage                                                             as Language,

      @ObjectModel.foreignKey.association: '_TimeSheetProcgStatus'
      @ObjectModel.text.element: ['TimeSheetProcessingStatusText']
  key cast( substring(dd07t.domvalue_l,1,2) as tims_status preserving type ) as TimeSheetProcessingStatus,

      @Semantics.text: true
      cast( ddtext as catsstatustext preserving type )                       as TimeSheetProcessingStatusText,
      
     //Associations

    _TimeSheetProcgStatus,
    _Language

}
where
      domname  = 'TIMS_STATUS'
  and as4local = 'A'