P_SDMForCatsTable

DDL: P_SDMFORCATSTABLE Type: view_entity BASIC Package: CATS_S4

SDM for CATSDB to CATSDBRAP

P_SDMForCatsTable is a Basic CDS View that provides data about "SDM for CATSDB to CATSDBRAP" in SAP S/4HANA. It reads from 1 data source (I_TimeSheetRecord) and exposes 7 fields with key field TimeSheetRecord. Part of development package CATS_S4.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_TimeSheetRecord Source from

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TimeSheetRecord I_TimeSheetRecord TimeSheetRecord
PersonWorkAgreement I_TimeSheetRecord PersonWorkAgreement
clientNULLasLastChangeDateTime
TimeSheetStatus I_TimeSheetRecord TimeSheetStatus
SDMVersion
TimeSheetHasLongText I_TimeSheetRecord TimeSheetHasLongText
TimeSheetNote I_TimeSheetRecord TimeSheetNote 
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   }
}
define view entity P_SDMForCatsTable
  as select from           I_TimeSheetRecord as Source
    left outer to one join I_TimeSheet       as Target on Source.TimeSheetRecord = Target.TimeSheetRecord
{
  key Source.TimeSheetRecord,
      Source.PersonWorkAgreement,
      dats_tims_to_tstmp (Source.TimeSheetLastChangedDate, 
                          Source.TimeSheetLastChangedTime, 
                          abap_system_timezone($session.client,'NULL' ),
                          $session.client,'NULL') as LastChangeDateTime,
      Source.TimeSheetStatus,
      cast( '00' as abap.char( 2 ) ) as SDMVersion,
      Source.TimeSheetHasLongText,
      Source.TimeSheetNote
}
where
       Target.TimeSheetRecord is null
  and(
       Source.TimeSheetStatus = '10'
    or Source.TimeSheetStatus = '20'
    or Source.TimeSheetStatus = '30'
    or Source.TimeSheetStatus = '40'
  )

Learn More