I_JITCallCompGroup

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_JITCallCompGroup.
-- 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_JITCallCompGroup AS
SELECT
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITHeaderUUID,
  ExtCompGrpNumber,
  CompGrpMatl,
  CustCompGrpMatl,
  JITExtSequenceNumber,
  TransmittedExtStatusByMfr,
  JITExtStatusAtSupplier,
  JITExtStatusUpdtdOn,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOn,
  RequirementDateTime,
  Plant,
  CustSupplyArea,
  UnloadingPointName,
  SupplyControlUUID,
  SupplyControlID,
  JITActionCtrl,
  CustAssemblyLoc,
  ShippingPoint,
  StorageLocation,
  PlannedShippingDateTime,
  ActualShippingDateTime,
  MaterialAvailabilityDate,
  MaterialAvailabilityTime,
  RequestedDeliveryDate,
  RequestedDeliveryTime,
  WarehouseNumber,
  DeliveryCreationDate,
  DeliveryCreationTime,
  DeliveryStatus,
  PickingStatus,
  GoodsMovementStatus,
  JITCompGrpDocRelToProdnSts,
  JITCompGrpDocConfToProdnSts,
  JITCompGrpDocPckgGrpSts,
  _JITCallHeaderBasic.JITCallType AS JITCallType,
  _JITCallHeaderBasic.ShipToParty AS ShipToParty,
  _JITCallHeaderBasic.SalesOrganization AS SalesOrganization,
  _JITCallHeaderBasic.DistributionChannel AS DistributionChannel,
  _JITCallHeaderBasic.Division AS Division,
  _JITCallHeaderBasic.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITCallHeaderBasic.JITComponentIsReordered AS JITComponentIsReordered,
  _ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
  ProductionStartDate,
  ProductionEndDate,
  ProductionVersion,
  I_JITCallCompGroupBasic._JITPckgGrpItemRef.JITPckgGrpUUID AS JITPckgGrpUUID,
  concat( InternalJITCallNumber,CompGrpNumber) AS ExternalDocumentID,
  TransmittedExtStsUpdtdDteTme,
  tstmp_seconds_between(( cast(RequirementDateTime as abap.dec( 15, 0))) ,tstmp_current_utctimestamp(),'NULL') AS TimeUnitDurationInSeconds,
  JITFormattedSequenceNumber,
  JITDelivSqncGrpID,
  JITDelivSqncGrpUUID,
  JITDelivConfControl,
  JITSuperPckgGrpUUID,
  JITProductionStartTime
FROM I_JITCallCompGroupBasic
LEFT OUTER JOIN I_JITCallHeaderBasic AS _JITCallHeaderBasic ON JITHeaderUUID = _JITCallHeaderBasic.JITHeaderUUID AND InternalJITCallNumber = _JITCallHeaderBasic.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion ON CompGrpMatl = _ProductionVersion.Material AND Plant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_JITCustHeaderTP AS _JITCustHeaderTP ON shiptoparty = _JITCustHeaderTP.ShipToParty  -- association [0..1]
LEFT OUTER JOIN I_JITCompGrpEnhanced AS _JITCompGrpEnhanced ON JITCallCompGrpUUID = _JITCompGrpEnhanced.JITCallCompGrpUUID AND InternalJITCallNumber = _JITCompGrpEnhanced.InternalJITCallNumber AND CompGrpNumber = _JITCompGrpEnhanced.CompGrpNumber  -- association [1..1]
LEFT OUTER JOIN I_JITDelivSqncGrpHeaderBasic AS _JITDelivSqncGrpHeaderBasic ON JITDelivSqncGrpUUID = _JITDelivSqncGrpHeaderBasic.JITDelivSqncGrpUUID  -- association [1..1]
;