I_JITOutbCallCompGrpData

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_JITOutbCallCompGrpData.
-- 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: IJITOUTBCALLCGRP

CREATE VIEW I_JITOutbCallCompGrpData AS
SELECT
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  ParentDraftKey,
  CompGrpNumber,
  ExtCompGrpNumber,
  CompGrpMatl,
  CustCompGrpMatl,
  JITExtSequenceNumber,
  TransmittedExtStatusByMfr,
  JITExtStatusAtSupplier,
  JITExtStatusUpdtdOn,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOn,
  RequirementDateTime,
  _JITOutbCallCompGrp.JITSupplyDateTime AS JITSupplyDateTime,
  _JITOutbCallCompGrp.Plant AS Plant,
  CustSupplyArea,
  UnloadingPointName,
  SupplyControlID,
  SupplyControlUUID,
  _JITOutbCallCompGrp.JITActionCtrl AS JITActionCtrl,
  CustAssemblyLoc,
  ShippingPoint,
  _JITOutbCallCompGrp.StorageLocation AS StorageLocation,
  PlannedShippingDateTime,
  ActualShippingDateTime,
  MaterialAvailabilityDate,
  RequestedDeliveryDate,
  RequestedDeliveryTime,
  _JITOutbCallCompGrp.WarehouseNumber AS WarehouseNumber,
  JITSourceWarehouseNumber,
  cast(dats_tims_to_tstmp(RequestedDeliveryDate, RequestedDeliveryTime, abap_user_timezone($session.user, $session.client, 'NULL'), $session.client, 'NULL') as timestampl ) AS RequestedDeliveryDateTime,
  DeliveryStatus,
  PickingStatus,
  GoodsMovementStatus,
  JITOutbStockTransferSts,
  _JITOutbCallCompGrp.JITControlCycle AS JITControlCycle,
  _JITControlCycle.JITReqQtyLowerToleranceLvl AS JITReqQtyLowerToleranceLvl,
  _JITControlCycle.JITReqQtyUpperToleranceLvl AS JITReqQtyUpperToleranceLvl,
  _JITOutbCallCompGrp.ProductionSupplyArea AS ProductionSupplyArea,
  JITOutbDestinationStorLoc,
  _JITOutbCallHeader.CreatedByUser AS CreatedByUser,
  _JITOutbCallHeader.CreationDateTime AS CreationDateTime,
  _JITOutbCallHeader.JITLifecycleStatus AS JITLifecycleStatus,
  _JITOutbCallHeader.JITCallType AS JITCallType,
  _JITOutbCallHeader.VehicleIdentificationNumber AS VehicleIdentificationNumber,
  _JITOutbCallHeader.VehicleModel AS VehicleModel,
  _JITOutbCallHeader.JITIntSequenceNumber AS JITIntSequenceNumber,
  _JITOutbCallHeader.LastChangeDateTime AS LastChangeDateTime,
  _JITOutbCallHeader.LastChangedByUser AS LastChangedByUser,
  _JITOutbCallHeader.JITCallImmediateRequest AS JITCallImmediateRequest,
  _JITOutbCallHeader.JITMissingPartFlag AS JITMissingPartFlag,
  _JITOutbCallHeader.JITCallPriorityType AS JITCallPriorityType,
  _JITOutbCallHeader.JITCallPriorityID AS JITCallPriorityID,
  _JITOutbCallHeader.JITCallProcessingLogID AS JITCallProcessingLogID,
  _JITOutbCallHeader.JITPlannedOrderNumber AS JITPlannedOrderNumber,
  _JITOutbCallHeader.JITVehicleSeqDateTime AS JITVehicleSeqDateTime,
  cast( ' ' as matnr) AS Material,
  cast( ' ' as ebeln ) AS SchedulingAgreement,
  _JITControlCycle.ReplenishmentStrategy AS ReplenishmentStrategy,
  cast('' as /scwm/lgnum ) AS EWMWarehouse,
  _JITControlCycle.SourceStorageBin AS SourceStorageBin,
  cast('' as abap.char(5)) AS SourceStorageType,
  _JITControlCycle.StorageBin AS StorageBin,
  _JITControlCycle.StorageType AS StorageType,
  _JITControlCycle.ReplnmtPlanningProcedure AS ReplnmtPlanningProcedure,
  _JITPlngProcedure._Text[1: Language = $session.system_language].JITPlanningProcedureText AS JITPlanningProcedureText,
  _ProductionSupplyArea._Text[1: Language = $session.system_language].ProductionSupplyAreaName AS ProductionSupplyAreaName,
  cast('' as /scwm/de_desc40 ) AS WarehouseName,
  _JITControlCycle.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  _JITControlCycle._ProductionSupplyArea.AutomotiveLoadingPoint AS AutomotiveLoadingPoint,
  _JITControlCycle.Supplier AS Supplier,
  _JITControlCycle.SupplierName AS SupplierName,
  cast('' as bu_partner) AS BusinessPartner,
  cast('' as bu_partner) AS BusinessPartner1,
  cast('' as bu_partner) AS BusinessPartner2
FROM I_JITOutbCallCompGrp AS _JITOutbCallCompGrp
INNER JOIN I_JITControlCycle AS _JITControlCycle ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JITOutbCallHeader AS _JITOutbCallHeader ON ParentDraftKey = _JITOutbCallHeader.JITHeaderUUID AND InternalJITCallNumber = _JITOutbCallHeader.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_JITOutbPlngProcedure AS _JITPlngProcedure ON ReplnmtPlanningProcedure = _JITPlngProcedure.JITPlanningProcedure  -- association [0..1]
;