P_KZ_DATE_HELPER

DDL: P_KZ_DATE_HELPER SQL: PKZDATEHELPER Type: view COMPOSITE

P_KZ_DATE_HELPER is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 1 field.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_SAPClient CompanyCode from

Parameters (1)

NameTypeDefault
ConverDate dats

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PKZDATEHELPER view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (1)

KeyFieldSource TableSource FieldDescription
ConverDate14asResultDate 
@AbapCatalog.sqlViewName: 'PKZDATEHELPER'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
@VDM.private: true
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter:true

define view P_KZ_DATE_HELPER
  with parameters
    ConverDate :dats
  as select from I_SAPClient as CompanyCode
{
  concat(substring($parameters.ConverDate, 7, 2),
     concat('.',concat(substring($parameters.ConverDate, 5, 2),
                 concat('.',substring($parameters.ConverDate, 1, 4))))) as ResultDate

}

Learn More