I_TimeSheetProcgStatus

DDL: I_TIMESHEETPROCGSTATUS Type: view_entity BASIC Package: VDM_TIMESHEET_CORE

TimeSheet Processing Status

I_TimeSheetProcgStatus is a Basic CDS View that provides data about "TimeSheet Processing Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field TimeSheetProcessingStatus. It has 1 association to related views. Part of development package VDM_TIMESHEET_CORE.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TimeSheetProcgStatusText _TimeSheetProcgStatusText $projection.TimeSheetProcessingStatus = _TimeSheetProcgStatusText.TimeSheetProcessingStatus

Annotations (7)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY TimeSheetProcessingStatus
_TimeSheetProcgStatusText _TimeSheetProcgStatusText
@AccessControl.authorizationCheck:  #NOT_REQUIRED

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

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

//@ObjectModel.resultSet.sizeCategory: #XS

//@ObjectModel.sapObjectNodeType.name: 'TimeSheetProcessingStatus'

//@ObjectModel.modelingPattern:         #ANALYTICAL_DIMENSION

//@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION,

//                                      #EXTRACTION_DATA_SOURCE,

//                                      #CDS_MODELING_DATA_SOURCE,

//                                      #CDS_MODELING_ASSOCIATION_TARGET,

//                                      #SQL_DATA_SOURCE,

//                                      #VALUE_HELP_PROVIDER ]


//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }


define view entity I_TimeSheetProcgStatus 
       as select from dd07l
          association [0..*] to I_TimeSheetProcgStatusText as _TimeSheetProcgStatusText 
           on $projection.TimeSheetProcessingStatus = _TimeSheetProcgStatusText.TimeSheetProcessingStatus                   
{
    @ObjectModel.text.association: '_TimeSheetProcgStatusText'
    key cast( substring(dd07l.domvalue_l,1,2) as tims_status preserving type ) as TimeSheetProcessingStatus,    
    
    //Associations

    _TimeSheetProcgStatusText
}
where 
     dd07l.domname = 'TIMS_STATUS' 
 and dd07l.as4local = 'A'