C_QltyInProcurementManage

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 C_QltyInProcurementManage.
-- 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: CQLTYINPROCMNG

CREATE VIEW C_QltyInProcurementManage AS
SELECT
  Material,
  QltyInProcmtIntID,
  Plant,
  ProductForEdit,
  MaterialRevisionLevel,
  Supplier,
  QltyInProcmtReleaseValidTo,
  _QltyInProcmtManageCalc.QualityMgmtCtrlKeyText AS QualityMgmtCtrlKeyText,
  ReleasedQuantity,
  OrderedQuantity,
  BaseUnit,
  QltyInProcmtResetOnDate,
  cast( SupplierProcurementBlock as vdm_qsupplierblock ) AS SupplierProcurementBlock,
  ProcurementBlock,
  BlockReason,
  cast( IsDeleted as vdm_qltyinforecordddeleted ) AS IsDeleted,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  HasNoQltyInfoRec,
  MaterialHasQualityInfoRecord,
  _QltyInProcmtManageCalc.QualityInfoRecordCriticality AS QualityInfoRecordCriticality,
  _QltyInProcurementManage._Plant.PlantName AS PlantName,
  _QltyInProcurementManage._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  _QltyInProcurementManage._Supplier.SupplierName AS SupplierName,
  _ProcurementBlock._ProcurementBlockText[1: Language=$session.system_language].ProcurementBlockText AS ProcurementBlockText,
  _SupProcurementBlockText[1: Language=$session.system_language].ProcurementBlockText AS SupplierProcmtBlockText,
  _QltyInProcmtManageCalc.QltyInfoRecdBlkSts AS QltyInfoRecdBlkSts,
  QltyInProcmtRelQtyIsActive,
  _QltyInProcmtManageCalc.QualityMgmtCtrlKey AS QualityMgmtCtrlKey,
  cast ( _QltyInProcmtManageCalc.PurchaseInfoRecordIsCreated as vdm_qeinf ) AS PurchaseInfoRecordIsCreated,
  QltyInProcmtInspControl,
  ProdnPieceApprovalIsRequired,
  ProductionPieceApproval,
  ProductionPieceApprovalLevel,
  _ProdnPieceApprvlLvlTxt.ProdnPieceApprovalLevelText AS ProdnPieceApprovalLevelText,
  ProductionPieceApprovalStatus,
  _ProdAppStsTxt.ProdnPieceApprovalStatusText AS ProdnPieceApprovalStatusText,
  Language,
  cast('' as abap.sstring(1333)) AS CollaborationRoomURL,
  cast(' ' as abap_boolean ) AS IsCloudSystem,
  cast(' ' as abap_boolean ) AS DgtlMfgIntegIsActive,
  QualityManagementSystem,
  QltyInProcmtCertfnValidTo,
  SuplrQualityManagementSystem,
  SuplrQltyInProcmtCertfnValidTo,
  InspectionLotType,
  QltyInProcmtLotCrtnLeadTime,
  QltyInProcmtNoFurtherInsp,
  QltyInProcmtCertificateCtrl,
  _QltyInProcurementManage._Material AS _Material,
  _QltyInProcurementManage._Plant AS _Plant,
  _QltyInProcurementManage._Supplier AS _Supplier,
  _QltyInProcurementManage._ProcurementBlock AS _ProcurementBlock
FROM I_QualityInProcurementTP AS _QltyInProcurementManage
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_QltyInProcmtManageCalc AS _QltyInProcmtManageCalc ON Material = _QltyInProcmtManageCalc.Material AND QltyInProcmtIntID = _QltyInProcmtManageCalc.QltyInProcmtIntID AND Plant = _QltyInProcmtManageCalc.Plant  -- association [0..1]
LEFT OUTER JOIN C_QltyFirstArticleInsp AS _QltyFirstArticleInspTP ON Material = _QltyFirstArticleInspTP.Material AND QltyInProcmtIntID = _QltyFirstArticleInspTP.QltyInProcmtIntID  -- association [0..*]
LEFT OUTER JOIN I_ProdnPieceApprvlStsTxt AS _ProdAppStsTxt ON ProductionPieceApprovalStatus = _ProdAppStsTxt.ProductionPieceApprovalStatus AND _ProdAppStsTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ProdnPieceApprvlLvlTxt AS _ProdnPieceApprvlLvlTxt ON ProductionPieceApprovalLevel = _ProdnPieceApprvlLvlTxt.ProductionPieceApprovalLevel AND _ProdnPieceApprvlLvlTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_QltyInProcurementLongText AS _QltyInProcurementLongTextTP ON Material = _QltyInProcurementLongTextTP.Material AND QltyInProcmtIntID = _QltyInProcurementLongTextTP.QltyInProcmtIntID AND _QltyInProcurementLongTextTP.Language = $session.system_language AND _QltyInProcurementLongTextTP.ItemCounter = 1  -- association [0..1]
;