R_BatchCharacteristicValueTP

DDL: R_BATCHCHARACTERISTICVALUETP Type: view_entity TRANSACTIONAL Package: LO_BM_BATCH_BO_RAP

Batch Characteristics Valuation

R_BatchCharacteristicValueTP is a Transactional CDS View that provides data about "Batch Characteristics Valuation" in SAP S/4HANA. It reads from 2 data sources (R_Batch, I_ClfnObjectCharcValForKeyDate) and exposes 26 fields with key fields Material, BatchIdentifyingPlant, Batch, CharcInternalID, ClfnCharcValuePositionNumber. Part of development package LO_BM_BATCH_BO_RAP.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
R_Batch Batch inner
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Batch Characteristics Valuation view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Material R_Batch Material
KEY BatchIdentifyingPlant R_Batch Plant
KEY Batch R_Batch Batch
KEY CharcInternalID ObjectCharcValue CharcInternalID
KEY ClfnCharcValuePositionNumber ObjectCharcValue CharcValuePositionNumber
CharcValueIntervalType ObjectCharcValue CharcValueDependency
CharcValue ObjectCharcValue CharcValue
CharcFromNumericValue ObjectCharcValue CharcFromNumericValue
CharcFromNumericValueUnit ObjectCharcValue CharcFromNumericValueUnit
CharcToNumericValue ObjectCharcValue CharcToNumericValue
CharcToNumericValueUnit ObjectCharcValue CharcToNumericValueUnit
CharcFromDecimalValue ObjectCharcValue CharcFromDecimalValue
CharcToDecimalValue ObjectCharcValue CharcToDecimalValue
CharcFromAmount ObjectCharcValue CharcFromAmount
CharcToAmount ObjectCharcValue CharcToAmount
Currency ObjectCharcValue Currency
CharcFromDate ObjectCharcValue CharcFromDate
CharcToDate ObjectCharcValue CharcToDate
CharcFromTime ObjectCharcValue CharcFromTime
CharcToTime ObjectCharcValue CharcToTime
CharcAuthor ObjectCharcValue CharacteristicAuthor
LastChangeDateTime R_Batch LastChangeDateTime
_BatchCharacteristicTP _BatchCharacteristicTP
_BatchTP _BatchTP
ClassType
_ClfnCharacteristic ObjectCharcValue _Characteristic 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@EndUserText.label: 'Batch Characteristics Valuation'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: {serviceQuality: #C, 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 R_Batch 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,
  Batch.LastChangeDateTime 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