R_BATCHCLASSTP

CDS View

Batch Class Assignment

R_BATCHCLASSTP is a CDS View in S/4HANA. Batch Class Assignment. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_BatchClass view_entity projection CONSUMPTION Batch Class Assignments
I_BatchClassTP_2 view_entity projection TRANSACTIONAL Batch Class Assignment 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@EndUserText.label: 'Batch Class Assignment'

@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_BatchClassTP
  as select from I_ClfnObjectClassForKeyDate(P_KeyDate: $session.system_date) as ObjectClass
    inner join I_BatchDistinct as Batch
      on ObjectClass.ClfnObjectInternalID = Batch.ClfnObjectInternalID
        
    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, 
    
    ObjectClass.ClassInternalID,
    
    case when Batch.LastChangeDateTime = 0 or Batch.LastChangeDateTime is null
      then cast('20170331120000' as lobm_last_changed)
      else Batch.LastChangeDateTime
    end as LastChangeDateTime,

    @Consumption.hidden: true
    ObjectClass.ClassType,
    @Consumption.hidden: true
    ObjectClass._Class,
        
    _BatchTP
  }
  where
    ObjectClass.ClfnObjectTable = 'MCH1' or ObjectClass.ClfnObjectTable = 'MCHA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BATCHDISTINCT",
"I_CLFNOBJECTCLASSFORKEYDATE"
],
"ASSOCIATED":
[
"I_CLFNCLASSFORKEYDATE",
"R_BATCHTP"
],
"BASE":
[
"I_CLFNOBJECTCLASSFORKEYDATE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More