C_JITOutbSqncCallDetTP

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_JITOutbSqncCallDetTP.
-- 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.

CREATE VIEW C_JITOutbSqncCallDetTP AS
SELECT
  JITHeaderUUID,
  InternalJITCallNumber,
  ExternalJITCallNumber,
  JITCallType,
  _JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  JITPlannedOrderNumber,
  JITLifecycleStatus,
  _JITLifecycleStatus._Text[1:Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  JITCallImmediateRequest,
  CreationDateTime,
  CreatedByUser,
  _CreatedByUser.FullName AS CreatedByUserDescription,
  LastChangeDateTime,
  LastChangedByUser,
  _LastChangedByUser.FullName AS LastChangedByUserDescription,
  JITCallPriorityType,
  _DeliveryPriority._Text[1:Language = $session.system_language].DeliveryPriorityDesc AS JITCallPriorityTypeText,
  JITCallPriorityID,
  JITIntSequenceNumber,
  JITCallCreationMode,
  _JITCallCreationMode._Text[1:Language = $session.system_language].JITCallCreationModeText AS JITCallCreationModeText,
  ActiveSupplier,
  _SupplierToBusinessPartner._Supplier.SupplierName AS SupplierName,
  ReferenceJITCallUUID,
  virtual JITLifeCycleStatusCriticality : abap.int1 AS int1,
  virtual JITCallHasAlert : abap.char(1) AS char1,
  virtual JITCallProcessingLogID : balnrext AS virtualJITCallProcessingLogIDbalnrext,
  virtual CompGrpMatl : matnr AS virtualCompGrpMatlmatnr,
  virtual ProductionSupplyArea : prvbe AS virtualProductionSupplyAreaprvbe,
  virtual StorageTypeName : abap.char(40) AS char40,
  virtual JITControlCycle : pknum AS virtualJITControlCyclepknum,
  virtual Material : matnr AS virtualMaterialmatnr,
  virtual SchedulingAgreement : ebeln AS virtualSchedulingAgreementebeln,
  virtual ProductDescription : abap.char( 90 ) AS char90,
  virtual JITRefType : njit_refty AS virtualJITRefTypenjit_refty,
  virtual JustInTimeInboundDelivery : vbeln_vl AS virtualJustInTimeInboundDeliveryvbeln_vl,
  virtual HandlingUnitExternalID : exidv AS virtualHandlingUnitExternalIDexidv,
  _JITInboundCallTP.InternalJITCallNumber AS ReferenceJustInTimeCallNumber,
  JITCallIsForwarded,
  JITMessageIsProcessed,
  Plant,
  _JITPlant.PlantName AS PlantName,
  JITIsReorderedExternally,
  VehicleIdentificationNumber,
  JITVehicleModel,
  _JITInboundCallTP.ShipToParty AS ShipToParty,
  ReorderReferenceJITCallUUID,
  _ReferenceReorderJISCall.InternalJITCallNumber AS ReorderReferenceJITCallNumber,
  JITProductionOrderNumber
FROM R_JITOutboundCallTP
LEFT OUTER JOIN C_JITOutbSqncCallCompDetTP AS _JITOutbCallComponentTP ON JITHeaderUUID = _JITOutbCallComponentTP.JITHeaderUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbSqncCallReorder AS _JITOutbSqncCallReorder ON JITHeaderUUID = _JITOutbSqncCallReorder.JITHeaderUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbSupplierQuickView AS _JITOutbSupplierQuickView ON ActiveSupplier = _JITOutbSupplierQuickView.Supplier  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSqncCallEDIMsgRef AS _JITOutbSqncCallEDIMsgRef ON InternalJITCallNumber = _JITOutbSqncCallEDIMsgRef.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN C_JITOutbSqncReorderJISCall AS _JITOutbSqncReorderJISCall ON JITHeaderUUID = _JITOutbSqncReorderJISCall.ReorderReferenceJITCallUUID  -- association [0..*]
;