H_NL_TimeStamp

DDL: H_NL_TIMESTAMP SQL: HNLTMSTMP Type: view

H_NL_TimeStamp is a CDS View in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 2 fields.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (1)

NameTypeDefault
P_TimeStamp char14

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName HNLTMSTMP view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
TimeStamp
P_TimeStamp82asMessageReference 
@AbapCatalog.sqlViewName: 'HNLTMSTMP'
@ObjectModel.usageType.sizeCategory: #S 
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@VDM.viewType: #CONSUMPTION

//@AccessControl.authorizationCheck: #NOT_ALLOWED

//@EndUserText.label: 'HU helper view for tag EAZON'

define view H_NL_TimeStamp
  with parameters
    P_TimeStamp           : char14
  as select from I_SAPClient
{
  left ($parameters.P_TimeStamp, 12) as TimeStamp,
   concat(right($parameters.P_TimeStamp,6),
   concat(right(left($parameters.P_TimeStamp,4),2),
   concat('2',
   concat(right(left($parameters.P_TimeStamp,8),2),'')
   )
   )
   ) as MessageReference
}

Learn More