P_MaterialPRTPlantRegnControl

DDL: P_MATERIALPRTPLANTREGNCONTROL Type: view_entity COMPOSITE

P_MaterialPRTPlantRegnControl is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_MaterialPlantPRTRegnControl, I_MaterialPRTByInternalKey) and exposes 12 fields with key fields ProductionResourceType, ProductionResourceInternalID.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_MaterialPlantPRTRegnControl MaterialPlantPRTRegnControl inner
I_MaterialPRTByInternalKey MaterialPRT from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProductionResourceType I_MaterialPRTByInternalKey ProductionResourceType
KEY ProductionResourceInternalID I_MaterialPRTByInternalKey ProductionResourceInternalID
Plant I_MaterialPRTByInternalKey Plant
Material I_MaterialPRTByInternalKey Material
SerialNumberProfile I_MaterialPlantPRTRegnControl SerialNumberProfile
SerialNumberProcedure I_MaterialPlantPRTRegnControl SerialNumberProcedure
SerialNumberUsageInAssignment I_MaterialPlantPRTRegnControl SerialNumberUsageInAssignment
SerialNumberEquipCreationRqmt I_MaterialPlantPRTRegnControl SerialNumberEquipCreationRqmt
PRTRegistrationControl I_MaterialPlantPRTRegnControl PRTRegistrationControl
_Material I_MaterialPRTByInternalKey _Material
_Plant I_MaterialPRTByInternalKey _Plant
_PRTRegistrationControl I_MaterialPlantPRTRegnControl _PRTRegistrationControl 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{ serviceQuality: #B,sizeCategory: #L,dataClass: #MIXED }
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_MaterialPRTPlantRegnControl
  as select from I_MaterialPRTByInternalKey    as MaterialPRT
    inner join   I_MaterialPlantPRTRegnControl as MaterialPlantPRTRegnControl on  MaterialPlantPRTRegnControl.Product = MaterialPRT.Material
                                                                              and MaterialPlantPRTRegnControl.Plant   = MaterialPRT.Plant

{
  key MaterialPRT.ProductionResourceType                        as ProductionResourceType,
  key MaterialPRT.ProductionResourceInternalID                  as ProductionResourceInternalID,
      MaterialPRT.Plant                                         as Plant,
      MaterialPRT.Material                                      as Material,
      MaterialPlantPRTRegnControl.SerialNumberProfile           as SerialNumberProfile,
      MaterialPlantPRTRegnControl.SerialNumberProcedure         as SerialNumberProcedure,
      MaterialPlantPRTRegnControl.SerialNumberUsageInAssignment as SerialNumberUsageInAssignment,
      MaterialPlantPRTRegnControl.SerialNumberEquipCreationRqmt as SerialNumberEquipCreationRqmt,
      MaterialPlantPRTRegnControl.PRTRegistrationControl        as PRTRegistrationControl,

      MaterialPRT._Material,
      MaterialPRT._Plant,
      MaterialPlantPRTRegnControl._PRTRegistrationControl
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALPLANTPRTREGNCONTROL",
"I_MATERIALPRTBYINTERNALKEY"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_PLANT",
"I_PRTREGISTRATIONCONTROL"
],
"BASE":
[
"I_MATERIALPLANTPRTREGNCONTROL",
"I_MATERIALPRTBYINTERNALKEY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More