I_CLFNCHARCVALDESCFORKEYDATETP

CDS View

TP for Classification Characteristic Value Description

I_CLFNCHARCVALDESCFORKEYDATETP is a CDS View in S/4HANA. TP for Classification Characteristic Value Description. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ClfnCharcValueDescForKeyDate view_entity from CONSUMPTION Characteristic Value Descriptions 
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AbapCatalog.sqlViewName: 'INGCCHR06TP'

//@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP for Classification Characteristic Value Description'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'CharcInternalID'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER

//@AbapCatalog.preserveKey: true


//@ObjectModel.createEnabled: true

//@ObjectModel.updateEnabled: true

//@ObjectModel.deleteEnabled: true

//@ObjectModel.writeActiveImplementedBy: 'ABAP:CL_NGC_RAP_CHR'

//@ObjectModel.entityChangeStateId: 'CharcLastChangedDateTime'

//@ObjectModel.transactionalProcessingEnabled: true


define view entity I_ClfnCharcValDescForKeyDateTP 
  with parameters
    // @Semantics.businessDate.at: true

    @Environment.systemField: #SYSTEM_DATE
    @Consumption.hidden: true 
    P_KeyDate :sydate
  as select from I_ClfnCharcValueDescForKeyDate( P_KeyDate: $parameters.P_KeyDate )
      association to parent I_ClfnCharcValForKeyDateTP as _CharacteristicValue
        on  $projection.CharcInternalID          = _CharacteristicValue.CharcInternalID
        and $projection.CharcValuePositionNumber = _CharacteristicValue.CharcValuePositionNumber   
      association [1..1] to I_ClfnCharcForKeyDateTP as _Characteristic 
        on $projection.CharcInternalID = _Characteristic.CharcInternalID  
{
  key CharcInternalID, 
      @ObjectModel.foreignKey.association: null 
  key CharcValuePositionNumber,
      @ObjectModel.foreignKey.association: null 
  key Language,  
      @Semantics.text: true
      CharcValueDescription, 
      ChangeNumber, 
      ValidityStartDate, 
      ValidityEndDate, 
//      @ObjectModel.readOnly: true

      $parameters.P_KeyDate as KeyDate, 
      _Characteristic( P_KeyDate: $parameters.P_KeyDate ).CharcLastChangedDateTime,
  
//      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT ]

      _CharacteristicValue,
//      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT ]

      _Characteristic
}

Learn More