I_JITOutbSqncCallCompCube

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 I_JITOutbSqncCallCompCube.
-- 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.

CREATE VIEW I_JITOutbSqncCallCompCube AS
SELECT
  _JITOutbCallComponent.JITCallComponentUUID AS JITCallComponentUUID,
  _JITOutbCallComponent.JITCallCompGrpUUID AS JITCallCompGrpUUID,
  _JITOutbCallComponent.JITHeaderUUID AS JITHeaderUUID,
  _JITOutbCallComponent.InternalJITCallNumber AS InternalJITCallNumber,
  _JITOutbCallComponent.JITCallItemNumber AS JITCallItemNumber,
  _JITInboundCall.InternalJITCallNumber AS ReferenceJustInTimeCallNumber,
  _JITOutbCallComponent.CompGrpMatl AS CompGrpMatl,
  _JITOutbCallComponent.Material AS Material,
  cast ( _JITOutbCallComponent._JITOutbCallComponentGroupDet.RequirementDateTime as njit_assembly_date_time) AS RequirementDateTime,
  _JITOutbCallComponent.RequestedQuantity AS RequestedQuantity,
  _JITOutbCallComponent.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  _JITOutbCallComponent.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITOutbCallComponent.JITLifecycleStatus AS JITLifecycleStatus,
  _JITOutbCallComponent._JITOutboundCall._JITLifecycleStatus._Text[1: Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  _JITOutbCallComponent.ActiveSupplier AS ActiveSupplier,
  _JITOutbCallComponent.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITOutbCallComponent.Plant AS Plant,
  _JITOutbCallComponent.ProductionSupplyArea AS ProductionSupplyArea,
  _JITOutbCallComponent.JITIntStatusUpdtdOnDteTme AS JITIntStatusUpdtdOnDteTme,
  _JITOutbCallComponent._JITInternalStatus._Text[1: Language = $session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITOutbCallComponent.JITOutbTransferredQuantity AS JITOutbTransferredQuantity,
  cast( _JITOutbCallComponent._JITOutboundCall.CreationDateTime as njit_assembly_date_time) AS CreationDateTime,
  _JITOutbCallComponent.QuantityUnit AS QuantityUnit,
  1 AS TotalNumberOfJITCalls,
  cast( 1 as abap.int4 ) AS NumberOfDistinctProducts,
  _JITOutbCallComponent._JITOutboundCall.JITIntSequenceNumber AS JITIntSequenceNumber,
  _JITOutbCallComponent._JITOutbCallComponentGroupDet.ExtCompGrpNumber AS ExtCompGrpNumber,
  _JITOutbCallComponent._JITOutboundCall AS _JITOutboundCall,
  _JITOutbCallComponent.ReferenceJITCallUUID AS ReferenceJITCallUUID,
  _JITOutboundCall._CreatedByUser.FullName AS CreatedByUserDescription,
  _JITOutboundCall._LastChangedByUser.FullName AS LastChangedByUserDescription,
  _JITOutboundCall.CreatedByUser AS CreatedByUser,
  _JITOutboundCall.LastChangedByUser AS LastChangedByUser
FROM I_JITOutbSqncCallCompMntr AS _JITOutbCallComponent
LEFT OUTER JOIN C_JITOutbSqncLfcycStsVH AS _JITOutbSqncLifecycleStsVH ON JITLifecycleStatus = _JITOutbSqncLifecycleStsVH.JITLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSupplierQuickView AS _JITOutbSupplierQuickView ON ActiveSupplier = _JITOutbSupplierQuickView.Supplier  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSqncExtCallNumberVH AS _JITOutbSqncExtCallNumberVH ON ExternalJITCallNumber = _JITOutbSqncExtCallNumberVH.ExternalJITCallNumber  -- association [0..1]
LEFT OUTER JOIN C_JITOutbComponentValueHelp AS _ProductVH ON Material = _ProductVH.Product  -- association [0..1]
LEFT OUTER JOIN C_JITOutbComponentValueHelp AS _ComponentGroupVH ON CompGrpMatl = _ComponentGroupVH.Product  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSqncInternalStsVH AS _JITOutbSqncInternalStsVH ON JITIntProcessingStatus = _JITOutbSqncInternalStsVH.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSqncCallNumberVH AS _JITOutbSqncCallNumberVH ON InternalJITCallNumber = _JITOutbSqncCallNumberVH.InternalJITCallNumber  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSqncPlantVH AS _JITOutbSqncPlantVH ON Plant = _JITOutbSqncPlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSqncSupplierVH AS _JITOutbSqncSupplierVH ON ActiveSupplier = _JITOutbSqncSupplierVH.Supplier  -- association [0..1]
LEFT OUTER JOIN C_JITOutbMntrProdSupAreaVH AS _JITOutbMntrProdSupAreaVH ON ProductionSupplyArea = _JITOutbMntrProdSupAreaVH.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN I_JITInboundCall AS _JITInboundCall ON ReferenceJITCallUUID = _JITInboundCall.JITHeaderUUID  -- association [0..1]
LEFT OUTER JOIN E_JITOutbCallComponent AS _Extension ON JITCallComponentUUID = _Extension.JITCallComponentUUID  -- association [0..1]
LEFT OUTER JOIN E_JustInTimeOutboundCall AS _ExtentionJITOutbHdr ON JITHeaderUUID = _ExtentionJITOutbHdr.JITHeaderUUID  -- association [0..1]
LEFT OUTER JOIN E_JITOutbCallComponentGroup AS _ExtentionJITOutbCompGrp ON JITCallCompGrpUUID = _ExtentionJITOutbCompGrp.JITCallCompGrpUUID  -- association [0..1]
LEFT OUTER JOIN C_JITOutbMntrCrtedByUsrVH AS _JITOutbMntrCrtedByUsrVH ON createdbyuser = _JITOutbMntrCrtedByUsrVH.CreatedByUser  -- association [0..1]
LEFT OUTER JOIN C_JITOutbMntrLstChgByUsrVH AS _JITOutbMntrLstChgByUsrVH ON lastchangedbyuser = _JITOutbMntrLstChgByUsrVH.UserID  -- association [0..1]
;