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.

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 R_Batch 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,
  Batch.LastChangeDateTime as LastChangeDateTime,

  @Consumption.hidden: true
  ObjectClass.ClassType,
  @Consumption.hidden: true
  ObjectClass._Class,

  _BatchTP
}
where
  ObjectClass.ClfnObjectTable = 'MCH1' or ObjectClass.ClfnObjectTable = 'MCHA'