P_Qm_Headerwithoperations

DDL: P_QM_HEADERWITHOPERATIONS SQL: PQMHEADWITHOPERS Type: view BASIC
20 Fields 4 Data Sources

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.

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 Inspection Lot
Material I_InspectionLot Material Vehicle Model
Batch I_InspectionLot Batch Lot No.
InspectionLotEndDate I_InspectionLot InspectionLotEndDate End Date
Plant I_InspectionLot Plant Valuation Area
PlantName I_Plant PlantName Plant Name
ManufacturingOrder I_InspectionLot ManufacturingOrder Order
InspectionLotText I_InspectionLot InspectionLotText
InspectionLotType I_InspectionLot InspectionLotType Inspection Type
InspectionLotQuantity I_InspectionLot InspectionLotQuantity
InspectionLotQuantityUnit I_InspectionLot InspectionLotQuantityUnit Sample UOM
InspectionLotStartDate I_InspectionLot InspectionLotStartDate Start Date
MaterialName
InspSubsetFieldCombination I_InspectionLot InspSubsetFieldCombination Field Combinat.
InspPlanOperationInternalID I_InspectionOperation InspPlanOperationInternalID Node Number
InspectionOperation I_InspectionOperation InspectionOperation Operation
OperationText I_InspectionOperation OperationText Description
WorkCenterInternalID I_InspectionOperation WorkCenterInternalID Work Center
WorkCenterText
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup QM Matl Auth.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_Qm_Headerwithoperations.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PQMHEADWITHOPERS

CREATE VIEW P_Qm_Headerwithoperations AS
SELECT
  I_InspectionLot.InspectionLot AS InspectionLot,
  I_InspectionLot.Material AS Material,
  I_InspectionLot.Batch AS Batch,
  I_InspectionLot.InspectionLotEndDate AS InspectionLotEndDate,
  I_InspectionLot.Plant AS Plant,
  I_Plant.PlantName AS PlantName,
  I_InspectionLot.ManufacturingOrder AS ManufacturingOrder,
  I_InspectionLot.InspectionLotText AS InspectionLotText,
  I_InspectionLot.InspectionLotType AS InspectionLotType,
  I_InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
  I_InspectionLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  I_InspectionLot.InspectionLotStartDate AS InspectionLotStartDate,
  I_InspectionLot._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  I_InspectionLot.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  I_InspectionOperation.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  I_InspectionOperation.InspectionOperation AS InspectionOperation,
  I_InspectionOperation.OperationText AS OperationText,
  I_InspectionOperation.WorkCenterInternalID AS WorkCenterInternalID,
  I_WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  I_InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_InspectionLot
LEFT OUTER JOIN I_InspectionOperation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenter ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant ON /* join condition not captured in parsed metadata */
;

Learn More