P_WorkCenterCapMaxMinDte

DDL: P_WORKCENTERCAPMAXMINDTE SQL: PWCCAPMINMAXDTE Type: view COMPOSITE

P_WorkCenterCapMaxMinDte is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, P_CapOpMaxMinDte) and exposes 2 fields with key fields P_fromdateendasOperationMinimumDate, datsendasOperationMaximumDate.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate date from
P_CapOpMaxMinDte P_CapOpMaxMinDte left_outer

Parameters (4)

NameTypeDefault
p_sapclient abap.clnt
P_fromdate datum
P_todate datum
P_HorizonFlag abap.char( 1 )

Annotations (6)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY P_fromdateendasOperationMinimumDate
KEY datsendasOperationMaximumDate 
@AbapCatalog.sqlViewName: 'PWCCAPMINMAXDTE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM: {
  private: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_WorkCenterCapMaxMinDte 
with parameters        p_sapclient : abap.clnt,
                       P_fromdate: datum,
                       P_todate: datum,
                       P_HorizonFlag: abap.char( 1 )
      as select from I_CalendarDate as date
      left outer join P_CapOpMaxMinDte(p_sapclient : $session.client,
                                      P_fromdate : $parameters.P_fromdate,
                                      P_todate : $parameters.P_todate) as orders
                                on orders.mandt = $session.client
{
      key case $parameters.P_HorizonFlag
        when 'Y' then
            cast( $parameters.P_fromdate as abap.dats)
        else
           coalesce( orders.OperationMinimumDate, $parameters.P_fromdate)
        end as OperationMinimumDate,
        
      key case $parameters.P_HorizonFlag
        when 'Y' then
            cast( dats_add_days($parameters.P_todate,1,'FAIL') as abap.dats)
        else
          coalesce( orders.OperationMaximumDate, cast( dats_add_days($parameters.P_todate,1,'FAIL') as abap.dats))
        end as OperationMaximumDate
       
}
where 
      date.CalendarDate = $session.system_date

Learn More