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,
  _Plant.PlantName AS PlantName,
  JITActionCtrl,
  ReplenishmentStrategy,
  StorageLocation,
  WarehouseNumber,
  JITSourceWarehouseNumber,
  JITOutbStockTransferSts,
  JITControlCycle,
  ProductionSupplyArea,
  _ProductionSupplyArea.ProductionSupplyAreaRespPerson AS Responsible,
  EWMWarehouse,
  JITOutbDestinationStorLoc,
  CreatedByUser,
  CreationDateTime,
  JITLifecycleStatus,
  JITCallType,
  VehicleIdentificationNumber,
  VehicleModel,
  JITIntSequenceNumber,
  LastChangeDateTime,
  LastChangedByUser,
  JITCallImmediateRequest,
  JITMissingPartFlag,
  JITCallPriorityType,
  JITCallPriorityID,
  JITCallProcessingLogID,
  SourceStorageBin,
  SourceStorageType,
  StorageBin,
  StorageType,
  ReplnmtPlanningProcedure,
  JITPlanningProcedureText,
  DeliveryStatus,
  JITPlannedOrderNumber,
  JITVehicleSeqDateTime,
  JITExtSequenceNumber,
  RequestedDeliveryDateTime,
  DeliveryCreationDate,
  JITCallHasAlert,
  Material,
  concat(BufferLeadTime,concat(':', PlannedDurationInMinutes)) AS JITReplenishmentLeadTimeValue,
  ProductionSupplyAreaName,
  WarehouseName,
  JITExternalReplenishment,
  JITInternalReplenishment,
  IssuingOrReceivingStorageLoc,
  AutomotiveLoadingPoint,
  Supplier,
  SupplierName,
  BusinessPartner,
  BusinessPartner1,
  BusinessPartner2,
  SchedulingAgreement,
  JITReqQtyLowerToleranceLvl,
  JITReqQtyUpperToleranceLvl,
  cast( ' ' as njit_tolerance_flag ) AS JITOutbToleranceFlag
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]
;