P_CASecDepOpDateTime

DDL: P_CASECDEPOPDATETIME SQL: PSECDEPOPDATETME Type: view COMPOSITE Package: ODATA_O2C_FICA_SCRTY_DEP_MNG

Sec Dep OP Date Time

P_CASecDepOpDateTime is a Composite CDS View that provides data about "Sec Dep OP Date Time" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocument) and exposes 6 fields with key fields ChangeDocObjectClass, ChangeDocObject, ChangeDocument. Part of development package ODATA_O2C_FICA_SCRTY_DEP_MNG.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocument I_ChangeDocument from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PSECDEPOPDATETME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObjectClass ChangeDocObjectClass
KEY ChangeDocObject ChangeDocObject
KEY ChangeDocument ChangeDocument
CreationDate CreationDate
CreationTime CreationTime
clientNULLascdcreatedasCreatedOn 
// a view to get creation date and creation time for each 

// change of FKK_SEC. In addition, do a time-zone adaption.


@AbapCatalog.sqlViewName: 'PSECDEPOPDATETME'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_CASecDepOpDateTime 
    as select from I_ChangeDocument {
  key ChangeDocObjectClass,
  key ChangeDocObject,
  key ChangeDocument,

      CreationDate as CreationDate,
      CreationTime as CreationTime,                                   

      cast(dats_tims_to_tstmp ( CreationDate, 
                                CreationTime, 
                                abap_system_timezone( $session.client,  'NULL' ),
                                $session.client, 
                                'NULL' ) as cdcreated ) as CreatedOn
}
where ChangeDocObjectClass = 'FKK_SEC'

Learn More