C_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 C_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: CJITOUTBCGHTP

CREATE VIEW C_JITOutbCallsCompGrpDataTP AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  CompGrpNumberForEdit,
  JITCallCompGrpUUID,
  CompGrpMatl,
  Material,
  JITLifecycleStatus,
  _JITLifecycleStatusValueHelp.JITLifecycleStatusText AS JITLifecycleStatusText,
  JITLifeCycleStatusCriticality,
  UnloadingPointName,
  GoodsReceivingPoint,
  JITCallType,
  _JITOutbCallHeader._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  JITCallImmediateRequest,
  JITCallPriorityID,
  JITCallPriorityType,
  _JITOutbCallHeader._DeliveryPriority._Text[1:Language = $session.system_language].DeliveryPriorityDesc AS JITCallPriorityTypeText,
  JITMissingPartFlag,
  _JITOutbMissingPartFlag._Text[1: Language = $session.system_language].JITMaterialStockMissingText AS JITMaterialStockMissingText,
  JITMissingPrtCriticality,
  CreationDateTime,
  LastChangeDateTime,
  LastChangedByUser,
  _JITOutbCallHeader._LastChangedByUser.FullName AS LastChangedByUserDescription,
  _JITOutbCallHeader.JITCallCreationMode AS JITCallCreationMode,
  _JITOutbCallHeader._JITCallCreationMode._Text[1:Language = $session.system_language].JITCallCreationModeText AS JITCallCreationModeText,
  Plant,
  WarehouseNumber,
  JITSourceWarehouseNumber,
  JITIntStatusUpdtdOn,
  ReplenishmentStrategy,
  JITReplenishmentLeadTimeValue,
  JITActionCtrl,
  RequirementDateTime,
  JITSupplyDateTime,
  JITControlCycle,
  Responsible,
  CreatedByUser,
  _JITOutbCallHeader._CreatedByUser.FullName AS CreatedByUserDescription,
  StorageLocation,
  JITCallHasAlert,
  JITCallProcessingLogID,
  ProductionSupplyArea,
  JITOutbDestinationStorLoc,
  _ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
  _JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  PlantName,
  SupplierName,
  JITOutbStockTransferSts,
  _JITStockTransferSts._Text[1: Language = $session.system_language].JITStockTransferStsText AS JITStockTransferStsText,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  ProductionSupplyAreaName,
  EWMWarehouse,
  WarehouseName,
  _JITOutbStorageBin.StorageType AS StorageType,
  _JITOutbStorageBin.StorageTypeName AS StorageTypeName,
  StorageBin,
  ReplnmtPlanningProcedure,
  JITPlanningProcedureText,
  JITExternalReplenishment,
  RequestedDeliveryDateTime,
  DeliveryCreationDate,
  JITInternalReplenishment,
  AutomotiveLoadingPoint,
  Supplier,
  JITOutbToleranceFlag,
  BusinessPartner,
  BusinessPartner1,
  BusinessPartner2,
  cast( '' as abap.char(90) ) AS StatusDescription,
  _JITOutbCallCompIntStatInfo.JITIntProcessingStatus AS JITIntProcessingStatus
FROM I_JITOutbCallsCompGrpDataTP AS _JITOutbCallsCompGrpDataTP
LEFT OUTER JOIN C_JITOutbCallsCompMatlDataTP AS _JITOutbCallsCompMatlDataTP ON InternalJITCallNumber = _JITOutbCallsCompMatlDataTP.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN C_JITOutbCallsRefTextTP AS _JITOutbCallsRefTextTP ON InternalJITCallNumber = _JITOutbCallsRefTextTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITStockTransferSts AS _JITStockTransferSts ON JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts  -- association [0..1]
LEFT OUTER JOIN C_JITLifecycleStatusValueHelp AS _JITLifecycleStatusValueHelp ON JITLifecycleStatus = _JITLifecycleStatusValueHelp.JITLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_JITOutbStorageBin AS _JITOutbStorageBin ON StorageBin = _JITOutbStorageBin.StorageBin AND WarehouseNumber = _JITOutbStorageBin.WarehouseNumber  -- association [0..1]
LEFT OUTER JOIN C_JITOutbControlCycSchedgAgrmt AS _JITOutbControlCycSchedgAgrmt ON JITControlCycle = _JITOutbControlCycSchedgAgrmt.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN C_JITInternalStatusVH AS _JITInternalStatusVH ON JITIntProcessingStatus = _JITInternalStatusVH.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_JITOutbCallsCompGrpDocRef AS _JITOutbCallsCompGrpDocRef ON JITCallCompGrpUUID = _JITOutbCallsCompGrpDocRef.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITOutbCallsCompGrpEDIMsgRef AS _JITOutbCallsCompGrpEDIMsgRef ON InternalJITCallNumber = _JITOutbCallsCompGrpEDIMsgRef.InternalJITCallNumber  -- association [0..*]
;