P_ProcOrderConfBatchCharc

DDL: P_PROCORDERCONFBATCHCHARC Type: view_entity COMPOSITE

P_ProcOrderConfBatchCharc is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MfgOrderConfMatlDocItem) and exposes 13 fields with key fields ConfirmationGroup, ConfirmationCount, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderConfMatlDocItem MatlDoc from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ConfirmationGroup I_MfgOrderConfMatlDocItem MfgOrderConfirmationGroup
KEY ConfirmationCount I_MfgOrderConfMatlDocItem MfgOrderConfirmation
KEY MaterialDocument I_MfgOrderConfMatlDocItem MaterialDocument
KEY MaterialDocumentItem I_MfgOrderConfMatlDocItem MaterialDocumentItem
KEY MaterialDocumentYear I_MfgOrderConfMatlDocItem MaterialDocumentYear
KEY Plant Batch Plant
KEY Material Batch Material
KEY Batch Batch Batch
KEY CharcInternalID CharcVal CharcInternalID
Characteristic
CharcValue CharcVal CharcValue
ClassType CharcVal ClassType
_Characteristic CharcVal _Characteristic 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}

@VDM.viewType: #COMPOSITE
@VDM.private: true
@Metadata.ignorePropagatedAnnotations: true

define view entity P_ProcOrderConfBatchCharc
  as select from    I_MfgOrderConfMatlDocItem                                       as MatlDoc
    left outer to one join I_Batch                                                         as Batch    on  Batch.Plant    = MatlDoc.Plant
                                                                                                and Batch.Material = MatlDoc.Material
                                                                                                and Batch.Batch    = MatlDoc.Batch
                                                                                                and Batch.ClfnObjectInternalID != '000000000000000000'
    left outer to many join I_ClfnObjectCharcValForKeyDate(P_KeyDate: $session.system_date) as CharcVal on  Batch.ClfnObjectInternalID = CharcVal.ClfnObjectInternalID
                                                                                                and CharcVal.ClfnObjectInternalID != '000000000000000000'
 {
  key MatlDoc.MfgOrderConfirmationGroup as ConfirmationGroup,
  key MatlDoc.MfgOrderConfirmation      as ConfirmationCount,
  key MatlDoc.MaterialDocument,
  key MatlDoc.MaterialDocumentItem,
  key MatlDoc.MaterialDocumentYear,
  key Batch.Plant,
  key Batch.Material,
  key Batch.Batch,
  key CharcVal.CharcInternalID,
      CharcVal._Characteristic(P_KeyDate: $session.system_date).Characteristic,
      CharcVal.CharcValue,
      @Consumption.hidden: true 
      CharcVal.ClassType,
      @Consumption.hidden: true      
      CharcVal._Characteristic

}
where  MatlDoc.ManufacturingOrderCategory = '40'
  and  CharcVal.ClfnObjectType  = 'O'
  and(
       CharcVal.ClassType       = '022'
    or CharcVal.ClassType       = '023'
  )
  and(
       CharcVal.ClfnObjectTable = 'MCH1'
    or CharcVal.ClfnObjectTable = 'MCHA'
  )

Learn More