R_BatchCharacteristicTP

DDL: R_BATCHCHARACTERISTICTP Type: view_entity TRANSACTIONAL

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 (I_BatchDistinct, I_ClfnObjectCharcForKeyDate) and exposes 10 fields with key fields Material, BatchIdentifyingPlant, Batch, CharcInternalID. It has 1 association to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_BatchDistinct 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 (10)

KeyFieldSource TableSource FieldDescription
KEY Material I_BatchDistinct Material
KEY BatchIdentifyingPlant I_BatchDistinct Plant
KEY Batch I_BatchDistinct Batch
KEY CharcInternalID ObjectCharc CharcInternalID
_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   I_BatchDistinct                                              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,

      case when Batch.LastChangeDateTime = 0 or Batch.LastChangeDateTime is null
        then cast('20170331120000' as lobm_last_changed)
        else Batch.LastChangeDateTime
      end         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')
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BATCHDISTINCT",
"I_CLFNOBJECTCHARCFORKEYDATE"
],
"ASSOCIATED":
[
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_CLFNCLASSFORKEYDATE",
"R_BATCHCHARACTERISTICVALUETP",
"R_BATCHTP"
],
"BASE":
[
"I_CLFNOBJECTCHARCFORKEYDATE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More