P_Qm_Headerwithoperations

DDL: P_QM_HEADERWITHOPERATIONS SQL: PQMHEADWITHOPERS Type: view BASIC

P_Qm_Headerwithoperations is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (I_InspectionLot, I_InspectionOperation, I_Plant, I_WorkCenter) and exposes 20 fields with key field InspectionLot.

4 data source(s) 20 fields

Data Sources (4)

SourceAliasJoin Type
I_InspectionLot I_InspectionLot from
I_InspectionOperation I_InspectionOperation left_outer
I_Plant I_Plant left_outer
I_WorkCenter I_WorkCenter left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PQMHEADWITHOPERS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #BASIC view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionLot InspectionLot
Material I_InspectionLot Material
Batch I_InspectionLot Batch
InspectionLotEndDate I_InspectionLot InspectionLotEndDate
Plant I_InspectionLot Plant
PlantName I_Plant PlantName
ManufacturingOrder I_InspectionLot ManufacturingOrder
InspectionLotText I_InspectionLot InspectionLotText
InspectionLotType I_InspectionLot InspectionLotType
InspectionLotQuantity I_InspectionLot InspectionLotQuantity
InspectionLotQuantityUnit I_InspectionLot InspectionLotQuantityUnit
InspectionLotStartDate I_InspectionLot InspectionLotStartDate
MaterialName
InspSubsetFieldCombination I_InspectionLot InspSubsetFieldCombination
InspPlanOperationInternalID I_InspectionOperation InspPlanOperationInternalID
InspectionOperation I_InspectionOperation InspectionOperation
OperationText I_InspectionOperation OperationText
WorkCenterInternalID I_InspectionOperation WorkCenterInternalID
WorkCenterText
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup 
@AbapCatalog.sqlViewName: 'PQMHEADWITHOPERS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #BASIC


define view P_Qm_Headerwithoperations 
  as select from I_InspectionLot
    left outer join I_InspectionOperation
      on I_InspectionLot.OrderInternalBillOfOperations = I_InspectionOperation.OrderInternalBillOfOperations 
    left outer join I_WorkCenter
      on I_InspectionOperation.WorkCenterInternalID = I_WorkCenter.WorkCenterInternalID
    left outer join I_Plant
      on I_InspectionLot.Plant = I_Plant.Plant  
{
   key I_InspectionLot.InspectionLot,
       I_InspectionLot.Material, 
       I_InspectionLot.Batch,
       I_InspectionLot.InspectionLotEndDate, 
       I_InspectionLot.Plant,
       I_Plant.PlantName,
       I_InspectionLot.ManufacturingOrder,
       I_InspectionLot.InspectionLotText,
       I_InspectionLot.InspectionLotType,
       I_InspectionLot.InspectionLotQuantity, 
       I_InspectionLot.InspectionLotQuantityUnit,
       I_InspectionLot.InspectionLotStartDate, 
       I_InspectionLot._Material._Text[1:Language=$session.system_language].MaterialName,
       I_InspectionLot.InspSubsetFieldCombination,
       I_InspectionOperation.InspPlanOperationInternalID,
       I_InspectionOperation.InspectionOperation,
       I_InspectionOperation.OperationText,
       I_InspectionOperation.WorkCenterInternalID,
       I_WorkCenter._Text[1:Language=$session.system_language].WorkCenterText,
        I_InspectionLot.MatlQualityAuthorizationGroup
     
}                                                 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_PLANT",
"I_WORKCENTER",
"I_WORKCENTERTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More