C_JITCallCompGrpRelToProdn

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_JITCallCompGrpRelToProdn.
-- 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 C_JITCallCompGrpRelToProdn AS
SELECT
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallComponentUUID,
  JITHeaderUUID,
  CompGrpMatl AS Material,
  ProductName,
  Plant,
  PlantName,
  RequestedQuantity,
  QuantityUnit,
  MaterialAvailabilityDateTime,
  ProductionStartDate,
  RequirementDateTime,
  ShipToParty,
  CustomerName,
  ExternalJITCallNumber,
  UnloadingPointName,
  CustSupplyArea,
  ProductionLine,
  ProductionEndDate,
  JITIntProcessingStatus,
  _JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  ProductionVersion,
  ProductionVersionText,
  PlannedShippingDateTime,
  SupplyControlUUID,
  ShippingPoint,
  StorageLocation,
  JITCallType,
  JITActionCtrl,
  cast( ' ' as njit_action) AS JITTriggeredAction,
  _JITActionCtrlProcgStsActn.JITAction AS JITPossibleAction,
  _JITCallAlertCountBySubObj.NumberOfAlerts AS NumberOfAlerts,
  JITCallTypeText,
  JITLifecycleStatusText,
  MatlUsageIndicatorText,
  JITExternalStatusText,
  JITExtStatusAtSupplier,
  CustAssemblyLoc,
  _Customer.Country AS Country,
  _Customer.CityName AS CityName
FROM I_JITCallCompGrpRelToProdn
LEFT OUTER JOIN E_JITCompGroup AS _JITCompGroupExtension ON InternalJITCallNumber = _JITCompGroupExtension.InternalJITCallNumber AND CompGrpNumber = _JITCompGroupExtension.CompGrpNumber  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON ShipToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN C_JITCallCompGrpItmRelToProdn AS _JITCallCompGrpItmRelToProdn ON JITCallCompGrpUUID = _JITCallCompGrpItmRelToProdn.JITCallCompGrpUUID AND InternalJITCallNumber = _JITCallCompGrpItmRelToProdn.InternalJITCallNumber AND CompGrpNumber = _JITCallCompGrpItmRelToProdn.CompGrpNumber  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_JITCallCompGroupBasic AS _JITCallCompGroupBasic ON InternalJITCallNumber = _JITCallCompGroupBasic.InternalJITCallNumber AND JITCallCompGrpUUID = _JITCallCompGroupBasic.JITCallCompGrpUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCallAlertCountBySubObj AS _JITCallAlertCountBySubObj ON JITHeaderUUID = _JITCallAlertCountBySubObj.JITHeaderUUID AND InternalJITCallNumber = _JITCallAlertCountBySubObj.InternalJITCallNumber AND _JITCallAlertCountBySubObj.ApplicationLogSubobject = 'S1_JC_R2P'  -- association [1..1]
;