P_MfgOrderCompProductPlant

DDL: P_MFGORDERCOMPPRODUCTPLANT SQL: PMPEOACPRDPLNT Type: view BASIC

P_MfgOrderCompProductPlant is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (marc, I_ReservationItem) and exposes 5 fields with key fields Reservation, ReservationItem, RecordType.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
marc ProductPlant inner
I_ReservationItem ReservationItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMPEOACPRDPLNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_ReservationItem Reservation
KEY ReservationItem I_ReservationItem ReservationItem
KEY RecordType I_ReservationItem RecordType
SerialNumberProfile marc sernp
IsBatchManagementRequired marc xchpf 
@AbapCatalog.sqlViewName: 'PMPEOACPRDPLNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #BASIC
@VDM.private: true
define view P_MfgOrderCompProductPlant
  as select from I_ReservationItem as ReservationItem
    inner join   marc              as ProductPlant on  ReservationItem.Material = ProductPlant.matnr
                                                   and ReservationItem.Plant    = ProductPlant.werks
{
  key ReservationItem.Reservation,
  key ReservationItem.ReservationItem,
  key ReservationItem.RecordType,
      ProductPlant.sernp as SerialNumberProfile,
      ProductPlant.xchpf as IsBatchManagementRequired
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESERVATIONITEM",
"MARC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More