I_JITOutbCallHdrBasic

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_JITOutbCallHdrBasic.
-- 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: IJITOUTBHEADER

CREATE VIEW I_JITOutbCallHdrBasic AS
SELECT
  JITHeaderUUID,
  InternalJITCallNumber,
  ExternalJITCallNumber,
  ShipToParty,
  SoldToParty,
  JITLifecycleStatus,
  JITCallType,
  VehicleIdentificationNumber,
  VehicleModel,
  SalesOrganization,
  DistributionChannel,
  Division,
  UnloadingPointName,
  CustomerPartnerDescription,
  MatlUsageIndicator,
  ActiveSupplier,
  ApplLogHighestMessageSeverity,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  JITCallImmediateRequest,
  JITMissingPartFlag,
  JITCallPriorityType,
  JITCallPriorityID,
  JITCallProcessingLogID,
  JITExtSequenceNumber,
  JITCallCreationMode,
  JITPlannedOrderNumber,
  JITVehicleSeqDateTime,
  JITIntSequenceNumber,
  cast( ' ' as njit_int_stat) AS JITIntProcessingStatus,
  cast( 0 as njit_int_stat_updated_on ) AS JITIntStatusUpdtdOn,
  _JITOutbCallCompGrpData.CompGrpMatl AS CompGrpMatl,
  _JITOutbCallCompGrpData.DeliveryCreationDate AS DeliveryCreationDate,
  _JITOutbCallCompGrpData.RequirementDateTime AS RequirementDateTime,
  _JITOutbCallCompGrpData.PlannedShippingDateTime AS PlannedShippingDateTime,
  _JITOutbCallCompGrpData.MaterialAvailabilityDate AS MaterialAvailabilityDate,
  _JITOutbCallCompGrpData.WarehouseNumber AS WarehouseNumber,
  _JITOutbCallCompGrpData.Plant AS Plant,
  _JITOutbCallCompGrpData.StorageLocation AS StorageLocation,
  _JITOutbCallCompGrpData.JITActionCtrl AS JITActionCtrl,
  _JITOutbCallCompGrpData.JITControlCycle AS JITControlCycle,
  _JITOutbCallCompGrpData.ProductionSupplyArea AS ProductionSupplyArea,
  _JITOutbCallCompGrpData.JITOutbDestinationStorLoc AS JITOutbDestinationStorLoc,
  _JITOutbCallCompGrpData.JITSupplyDateTime AS JITSupplyDateTime,
  cast(' ' as abap.char(4)) AS ReplenishmentStrategy,
  cast( ' ' as matnr) AS Material
FROM I_JITOutbCallHeader
LEFT OUTER JOIN I_JITOutbCallCompGrpData AS _JITOutbCallCompGrpData ON JITHeaderUUID = _JITOutbCallCompGrpData.ParentDraftKey AND InternalJITCallNumber = _JITOutbCallCompGrpData.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_JITOutbCallCompMatl AS _JITOutbCallCompMatlData ON JITHeaderUUID = _JITOutbCallCompMatlData.RootDraftKey AND InternalJITCallNumber = _JITOutbCallCompMatlData.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN I_JITCallDate AS _JITCallDate ON InternalJITCallNumber = _JITCallDate.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _ProductionSupplyArea ON plant = _ProductionSupplyArea.Plant AND productionsupplyarea = _ProductionSupplyArea.ProductionSupplyArea  -- association [0..1]
;