R_BATCHCHARACTERISTICVALUETP

CDS View

Batch Characteristics Valuation

R_BATCHCHARACTERISTICVALUETP is a CDS View in S/4HANA. Batch Characteristics Valuation. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_BatchCharcValue view_entity projection CONSUMPTION Batch Characteristics Valuation
I_BatchCharacteristicValueTP_2 view_entity projection TRANSACTIONAL Batch Characteristics Valuation 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@EndUserText.label: 'Batch Characteristics Valuation'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view entity R_BatchCharacteristicValueTP
  as select from I_ClfnObjectCharcValForKeyDate(P_KeyDate: $session.system_date) as ObjectCharcValue
    inner join   I_BatchDistinct                                                 as Batch on ObjectCharcValue.ClfnObjectInternalID = Batch.ClfnObjectInternalID

  association to parent R_BatchCharacteristicTP as _BatchCharacteristicTP on  $projection.Material              = _BatchCharacteristicTP.Material
                                                                          and $projection.BatchIdentifyingPlant = _BatchCharacteristicTP.BatchIdentifyingPlant
                                                                          and $projection.Batch                 = _BatchCharacteristicTP.Batch
                                                                          and $projection.CharcInternalID       = _BatchCharacteristicTP.CharcInternalID

  -- needed for dependent locking in BDEF
  association to R_BatchTP                      as _BatchTP               on  $projection.Material              = _BatchTP.Material
                                                                          and $projection.BatchIdentifyingPlant = _BatchTP.BatchIdentifyingPlant
                                                                          and $projection.Batch                 = _BatchTP.Batch

{
  key Batch.Material,
  key Batch.Plant                               as BatchIdentifyingPlant,
  key Batch.Batch,
  key ObjectCharcValue.CharcInternalID,
  key ObjectCharcValue.CharcValuePositionNumber as ClfnCharcValuePositionNumber,

      ObjectCharcValue.CharcValueDependency     as CharcValueIntervalType,
      ObjectCharcValue.CharcValue,
      ObjectCharcValue.CharcFromNumericValue,
      ObjectCharcValue.CharcFromNumericValueUnit,
      ObjectCharcValue.CharcToNumericValue,
      ObjectCharcValue.CharcToNumericValueUnit,
      ObjectCharcValue.CharcFromDecimalValue,
      ObjectCharcValue.CharcToDecimalValue,
      @Semantics.amount.currencyCode: 'Currency'
      ObjectCharcValue.CharcFromAmount,
      @Semantics.amount.currencyCode: 'Currency'
      ObjectCharcValue.CharcToAmount,
      ObjectCharcValue.Currency,
      ObjectCharcValue.CharcFromDate,
      ObjectCharcValue.CharcToDate,
      ObjectCharcValue.CharcFromTime,
      ObjectCharcValue.CharcToTime,
      ObjectCharcValue.CharacteristicAuthor     as CharcAuthor,

      case when Batch.LastChangeDateTime = 0 or Batch.LastChangeDateTime is null
        then cast('20170331120000' as lobm_last_changed)
        else Batch.LastChangeDateTime
      end                                       as LastChangeDateTime,

      _BatchCharacteristicTP,
      _BatchTP,

      --Needed for DCL inheritance
      @Consumption.hidden: true
      ObjectCharcValue.ClassType,
      @Consumption.hidden: true
      ObjectCharcValue._Characteristic as _ClfnCharacteristic
}
where
       ObjectCharcValue.ClfnObjectType  = 'O'
  and(
       ObjectCharcValue.ClfnObjectTable = 'MCH1'
    or ObjectCharcValue.ClfnObjectTable = 'MCHA'
  )

Learn More