P_CHARCCTLGCLFNCFORDATEDESC

CDS View

P_CHARCCTLGCLFNCFORDATEDESC is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdAllocCharcText view left_outer COMPOSITE Product allocation characteristic text 
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MASTER
define view entity P_CharcCtlgClfnCForDateDesc
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from           I_ClfnCharcTimeIndep                                         as Characteristic
    left outer to one join P_CharcCtlgClfnCMaxRelDesc(P_KeyDate: $parameters.P_KeyDate) as MaxRelevant      on Characteristic.CharcInternalID = MaxRelevant.CharcInternalID
    left outer to one join I_ClfnCharcDesc                                              as CharcDescription on  MaxRelevant.CharcInternalID = CharcDescription.CharcInternalID
                                                                                                            and MaxRelevant.ValidityEndDate = CharcDescription.ValidityEndDate
                                                                                                            and CharcDescription.Language   = $session.system_language

{
  key Characteristic.CharcInternalID,
      MaxRelevant.ValidityEndDate,
      case
        when CharcDescription.CharcDescription <> '' then
          cast( CharcDescription.CharcDescription as charcdescription )
        else
          cast( Characteristic.Characteristic as charcdescription )
        end as CharcDescription
}

Learn More