P_MPEInspOpUsageDecision

DDL: P_MPEINSPOPUSAGEDECISION Type: view_entity COMPOSITE

Usage Decision on Operation Level

P_MPEInspOpUsageDecision is a Composite CDS View that provides data about "Usage Decision on Operation Level" in SAP S/4HANA. It reads from 1 data source (I_InspOperationUsageDecision) and exposes 11 fields with key fields InspectionLot, InspPlanOperationInternalID.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_InspOperationUsageDecision UsageDescision from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Usage Decision on Operation Level view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspOperationUsageDecision InspectionLot
KEY InspPlanOperationInternalID I_InspOperationUsageDecision InspPlanOperationInternalID
InspOpUsageDecisionValuation I_InspOperationUsageDecision InspOpUsageDecisionValuation
UsageDecisionCodeGroup I_InspOperationUsageDecision UsageDecisionCodeGroup
UsageDecisionCode I_InspOperationUsageDecision UsageDecisionCode
OrderInternalBillOfOperations inspOp OrderInternalBillOfOperations
OrderOperationInternalID inspOp OrderOperationInternalID
_InspectionLot I_InspOperationUsageDecision _InspectionLot
_InspectionOperation I_InspOperationUsageDecision _InspectionOperation
_UsageDecisionCodeGroup I_InspOperationUsageDecision _UsageDecisionCodeGroup
_UsageDecisionCode I_InspOperationUsageDecision _UsageDecisionCode 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Usage Decision on Operation Level'
@VDM: {
    viewType: #COMPOSITE,
    private: true
}
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, sizeCategory: #L, serviceQuality: #A }
define view entity P_MPEInspOpUsageDecision
  as select from I_InspOperationUsageDecision as UsageDescision
  left outer to one join I_InspectionOperation as inspOp on UsageDescision.InspectionLot = inspOp.InspectionLot 
                                                        and UsageDescision.InspPlanOperationInternalID = inspOp.InspPlanOperationInternalID
{
  key UsageDescision.InspectionLot,
  key UsageDescision.InspPlanOperationInternalID,

      UsageDescision.InspOpUsageDecisionValuation,
      UsageDescision.UsageDecisionCodeGroup,
      UsageDescision.UsageDecisionCode,
      inspOp.OrderInternalBillOfOperations,
      inspOp.OrderOperationInternalID,
      // Associations

      UsageDescision._InspectionLot,
      UsageDescision._InspectionOperation,
      UsageDescision._UsageDecisionCodeGroup,
      UsageDescision._UsageDecisionCode
}
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONOPERATION",
"I_INSPOPERATIONUSAGEDECISION"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION",
"I_USAGEDECISIONCODE",
"I_USAGEDECISIONCODEGROUP"
],
"BASE":
[
"I_INSPOPERATIONUSAGEDECISION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More