I_JITOutbCallsCompGrpDataTP

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_JITOutbCallsCompGrpDataTP.
-- 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: IJITOUTBCGHTP

CREATE VIEW I_JITOutbCallsCompGrpDataTP AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallCompGrpUUID,
  ParentDraftKey,
  CompGrpNumber AS CompGrpNumberForEdit,
  CompGrpMatl,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOn,
  RequirementDateTime,
  JITSupplyDateTime,
  Plant,
  cast('' as name1) AS PlantName,
  JITActionCtrl,
  ReplenishmentStrategy,
  StorageLocation,
  WarehouseNumber,
  JITSourceWarehouseNumber,
  JITOutbStockTransferSts,
  JITControlCycle,
  ProductionSupplyArea,
  EWMWarehouse,
  JITOutbDestinationStorLoc,
  CreatedByUser,
  CreationDateTime,
  JITLifecycleStatus,
  UnloadingPointName,
  GoodsReceivingPoint,
  JITCallType,
  VehicleIdentificationNumber,
  VehicleModel,
  JITIntSequenceNumber,
  LastChangeDateTime,
  LastChangedByUser,
  JITCallImmediateRequest,
  JITMissingPartFlag,
  JITCallPriorityType,
  JITCallPriorityID,
  JITCallProcessingLogID,
  SourceStorageBin,
  SourceStorageType,
  StorageBin,
  StorageType,
  ReplnmtPlanningProcedure,
  cast('' as ddtext) AS JITPlanningProcedureText,
  DeliveryStatus,
  JITPlannedOrderNumber,
  JITVehicleSeqDateTime,
  JITExtSequenceNumber,
  RequestedDeliveryDateTime,
  DeliveryCreationDate,
  JITCallHasAlert,
  Material,
  concat(BufferLeadTime,concat(':', PlannedDurationInMinutes)) AS JITReplenishmentLeadTimeValue,
  cast('' as pvbtx) AS ProductionSupplyAreaName,
  cast('' as /scwm/de_desc40 ) AS WarehouseName,
  JITExternalReplenishment,
  JITInternalReplenishment,
  IssuingOrReceivingStorageLoc,
  cast('' as /scmtms/loading_point_id ) AS AutomotiveLoadingPoint,
  Supplier,
  cast('' as md_supplier_name) AS SupplierName,
  BusinessPartner,
  BusinessPartner1,
  BusinessPartner2,
  SchedulingAgreement,
  JITReqQtyLowerToleranceLvl,
  JITReqQtyUpperToleranceLvl,
  cast( ' ' as njit_tolerance_flag ) AS JITOutbToleranceFlag,
  JITProductionOrderNumber,
  JITDeliveryDateTime,
  JITCallIsSetRelevant
FROM I_JITOutbCallCompGrpData
LEFT OUTER JOIN I_JITOutbCallsCompMatlDataTP AS _JITOutbCallsCompMatlDataTP ON InternalJITCallNumber = _JITOutbCallsCompMatlDataTP.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN I_JITOutbCallsRefTextTP AS _JITOutbCallsRefTextTP ON InternalJITCallNumber = _JITOutbCallsRefTextTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITOutbMissingFlag AS _JITOutbMissingPartFlag ON JITMissingPartFlag = _JITOutbMissingPartFlag.JITMaterialStockIsMissing  -- association [1..1]
LEFT OUTER JOIN E_JITCompGroup AS _JITOutbCallsCompGrpExtn ON InternalJITCallNumber = _JITOutbCallsCompGrpExtn.InternalJITCallNumber AND CompGrpNumber = _JITOutbCallsCompGrpExtn.CompGrpNumber  -- association [0..1]
LEFT OUTER JOIN I_JITStockTransferSts AS _JITStockTransferSts ON JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts  -- association [0..1]
LEFT OUTER JOIN I_JITOutbStorageBin AS _JITOutbStorageBin ON StorageBin = _JITOutbStorageBin.StorageBin AND WarehouseNumber = _JITOutbStorageBin.WarehouseNumber  -- association [0..1]
LEFT OUTER JOIN I_JITInternalStatus AS _JITInternalStatus ON JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_JITOutbPlngProcedure AS _JITPlngProcedure ON ReplnmtPlanningProcedure = _JITPlngProcedure.JITPlanningProcedure  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _ProductionSupplyArea ON Plant = _ProductionSupplyArea.Plant AND ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN I_JustInTimeInboundDelivery AS _JITInboundDelivery ON JITCallCompGrpUUID = _JITInboundDelivery.JITCallCompGrpUUID AND InternalJITCallNumber = _JITInboundDelivery.InternalJITCallNumber  -- association [0..1]
;