R_BatchCharacteristicTP

DDL: R_BATCHCHARACTERISTICTP Type: view_entity TRANSACTIONAL Package: LO_BM_BATCH_BO_RAP

Batch Characteristic

R_BatchCharacteristicTP is a Transactional CDS View that provides data about "Batch Characteristic" in SAP S/4HANA. It reads from 2 data sources (R_Batch, I_ClfnObjectCharcForKeyDate) and exposes 11 fields with key fields Material, BatchIdentifyingPlant, Batch, CharcInternalID. It has 1 association to related views. Part of development package LO_BM_BATCH_BO_RAP.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
R_Batch Batch inner
I_ClfnObjectCharcForKeyDate I_ClfnObjectCharcForKeyDate from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_BatchCharacteristicValueTP _BatchCharacteristicValueTP

Annotations (9)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Material R_Batch Material
KEY BatchIdentifyingPlant R_Batch Plant
KEY Batch R_Batch Batch
KEY CharcInternalID ObjectCharc CharcInternalID
LastChangeDateTime R_Batch LastChangeDateTime
_BatchTP _BatchTP
_BatchCharacteristicValueTP _BatchCharacteristicValueTP
ClassInternalID
ClassType ObjectCharc ClassType
_Characteristic ObjectCharc _Characteristic
_Class ObjectCharc _Class 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@EndUserText.label: 'Batch Characteristic'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}

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

define view entity R_BatchCharacteristicTP
  as select from I_ClfnObjectCharcForKeyDate(P_KeyDate: $session.system_date) as ObjectCharc
    inner join R_Batch as Batch
      on ObjectCharc.ClfnObjectInternalID = Batch.ClfnObjectInternalID

  composition [0..*] of R_BatchCharacteristicValueTP as _BatchCharacteristicValueTP

  association to parent 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 ObjectCharc.CharcInternalID,
  Batch.LastChangeDateTime as LastChangeDateTime,

  _BatchTP,
  _BatchCharacteristicValueTP,

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

Learn More