P_CharcCtlgClfnCValueDesc

DDL: P_CHARCCTLGCLFNCVALUEDESC Type: view_entity COMPOSITE Package: PROD_ALLOC_CHARC_CATALOG

Charac Catalog Classification Charac Value Descriptions

P_CharcCtlgClfnCValueDesc is a Composite CDS View that provides data about "Charac Catalog Classification Charac Value Descriptions" in SAP S/4HANA. It reads from 1 data source (I_ClfnCharcValueDesc) and exposes 4 fields. Part of development package PROD_ALLOC_CHARC_CATALOG.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnCharcValueDesc descr from

Annotations (6)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view

Fields (4)

KeyFieldSource TableSource FieldDescription
CharcInternalID value CharcInternalID
CharcValue value CharcValue
IsDeleted value IsDeleted
CharcValueDescription I_ClfnCharcValueDesc CharcValueDescription 
@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_CharcCtlgClfnCValueDesc
  as select from I_ClfnCharcValueDesc          as descr
    join         P_CharcCtlgClfnCValueInclDel1 as value on  value.CharcInternalID          = descr.CharcInternalID
                                                        and value.CharcValuePositionNumber = descr.CharcValuePositionNumber
{
  value.CharcInternalID,
  value.CharcValue,
  value.IsDeleted,
  descr.CharcValueDescription
}
where
          value.IsDeleted         =  descr.IsDeleted
  and     descr.Language          = $session.system_language
  and(
    (
          value.ValidityStartDate <= $session.system_date
      and descr.ValidityEndDate   >= $session.system_date
      and descr.ValidityStartDate <= $session.system_date
    )
    or(
          value.ValidityStartDate > $session.system_date
      and descr.ValidityEndDate   >= value.ValidityStartDate
      and descr.ValidityStartDate <= value.ValidityStartDate
    )
  )

Learn More