C_JITOutbCallHdrTP

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_JITOutbCallHdrTP.
-- 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: CJITOUTBHEADTP

CREATE VIEW C_JITOutbCallHdrTP AS
SELECT
  JITHeaderUUID,
  InternalJITCallNumber,
  JITLifecycleStatus,
  _JITLifecycleStatusValueHelp.JITLifecycleStatusText AS JITLifecycleStatusText,
  JITLifeCycleStatusCriticality,
  JITCallType,
  _JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  JITCallImmediateRequest,
  JITCallPriorityID,
  JITCallPriorityType,
  _DeliveryPriority._Text[1:Language = $session.system_language].DeliveryPriorityDesc AS JITCallPriorityTypeText,
  JITMissingPartFlag,
  JITMissingPrtCriticality,
  CreationDateTime,
  LastChangeDateTime,
  LastChangedByUser,
  LastChangedByUserDescription,
  JITCallCreationMode,
  _JITCallCreationMode._Text[1:Language = $session.system_language].JITCallCreationModeText AS JITCallCreationModeText,
  Plant,
  WarehouseNumber,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOn,
  _JITControlCycleTP.ReplenishmentStrategy AS ReplenishmentStrategy,
  _JITControlCycleTP.ReplenishmentLeadTime AS JITReplenishmentLeadTimeValue,
  JITActionCtrl,
  Material,
  RequirementDateTime,
  JITSupplyDateTime,
  JITControlCycle,
  Responsible,
  CreatedByUser,
  CreatedByUserDescription,
  StorageLocation,
  JITCallProcessingLogID,
  ProductionSupplyArea,
  JITOutbDestinationStorLoc,
  _JITOutbCallCompGrpDataTP.StorageBin AS StorageBin,
  _JITOutbCallCompGrpDataTP.StorageType AS StorageType,
  _JITOutbCallCompGrpDataTP.CompGrpNumber AS CompGrpNumber,
  CompGrpMatl
FROM I_JITOutbCallHdrTP AS _JITOutbCallHdrTP
LEFT OUTER JOIN C_JITOutbCallCompGrpDataTP AS _JITOutbCallCompGrpDataTP ON JITHeaderUUID = _JITOutbCallCompGrpDataTP.ParentDraftKey AND InternalJITCallNumber = _JITOutbCallCompGrpDataTP.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN C_JITOutbCallRefTextHdrTP AS _JITOutbCallRefTextHdrTP ON JITHeaderUUID = _JITOutbCallRefTextHdrTP.ParentDraftKey AND InternalJITCallNumber = _JITOutbCallRefTextHdrTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN C_JITOutbCallRefTextCompGrpTP AS _JITOutbCallRefTextCompGrpTP ON JITHeaderUUID = _JITOutbCallRefTextCompGrpTP.RootDraftKey AND InternalJITCallNumber = _JITOutbCallRefTextCompGrpTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallTypeValueHelp AS _JITCallTypeValueHelp ON JITCallType = _JITCallTypeValueHelp.JITCallType  -- association [0..1]
LEFT OUTER JOIN C_JITLifecycleStatusValueHelp AS _JITLifecycleStatusValueHelp ON JITLifecycleStatus = _JITLifecycleStatusValueHelp.JITLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_JITOutbCallApplicationLog AS _JITOutbCallApplicationLog ON JITCallProcessingLogID = _JITOutbCallApplicationLog.JITCallProcessingLogID  -- association [0..*]
LEFT OUTER JOIN I_JITControlCycleTP AS _JITControlCycleTP ON JITControlCycle = _JITControlCycleTP.JITControlCycle  -- association [0..1]
;