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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCDESC",
"I_CLFNCHARCTIMEINDEP",
"P_CHARCCTLGCLFNCMAXRELDESC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More