C_JITOutbFwdSqncCallCompGrp

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_JITOutbFwdSqncCallCompGrp.
-- 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_JITOutbFwdSqncCallCompGrp AS
SELECT
  JITCallCompGrpUUID,
  JITHeaderUUID,
  InternalJITCallNumber,
  JITCallComponentGrpItemNumber,
  CompGrpNumber,
  ExtCompGrpNumber,
  CompGrpMatl,
  _ProductCompGrp._Text[1: Language = $session.system_language].ProductName AS ProductName,
  RequirementDateTime,
  JITSupplyDateTime,
  Plant,
  _JITPlant.PlantName AS PlantName,
  UnloadingPointName,
  JITActionCtrl,
  StorageLocation,
  _ProductionSupplyArea._StorageLocation.StorageLocationName AS StorageLocationName,
  _JITControlCycle.JITOutbCommunicationGroup AS JITOutbCommunicationGroup,
  JITSourceWarehouseNumber,
  JITControlCycle,
  _ShippingPointText[1:Language = $session.system_language].ShippingPointName AS ShippingPointName,
  GoodsReceivingPoint,
  ProductionSupplyArea,
  _ProductionSupplyArea._Text[1: Language = $session.system_language].ProductionSupplyAreaName AS ProductionSupplyAreaName,
  _JITControlCycle._ProductionSupplyArea.AutomotiveLoadingPoint AS AutomotiveLoadingPoint,
  _JITInternalStatus._Text[1: Language = $session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITInternalStatus.JITIntProcessingStatusType AS JITIntProcessingStatusType,
  JITOutbDestinationStorLoc,
  ReferenceJITComponentGroupUUID,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOnDteTme,
  _JITOutboundCallTP.ActiveSupplier AS Supplier,
  _JITOutboundCallTP._SupplierToBusinessPartner._Supplier.SupplierName AS SupplierName,
  DeliveryStatus,
  _JITDeliveryStatus._Text[1: Language = $session.system_language].DeliveryStatusText AS DeliveryStatusText,
  PickingStatus,
  _JITControlCycle.ExtProcurementReplnmtStrgy AS ExtProcurementReplnmtStrgy,
  _JITControlCycle.DestinationStorageBin AS EWMStorageBin,
  _JITControlCycle.StorageTypeName AS StorageTypeName,
  _JITInternalStatus._Text[1: Language = $session.system_language].JITInternalStatusText AS OverallPickingStatusDesc,
  GoodsMovementStatus,
  _JITGoodsMovementStatus._Text[1: Language = $session.system_language].GoodsMovementStatusDesc AS GoodsMovementStatusDesc,
  JITOutbStockTransferSts,
  _JITStockTransferSts._Text[1: Language = $session.system_language].JITStockTransferStsText AS JITOutbStockTransferStsText,
  _JITOutboundCallTP._SupplierToBusinessPartner._Supplier.BusinessPartnerName1 AS BusinessPartnerName1,
  _JITOutboundCallTP._SupplierToBusinessPartner._Supplier.BusinessPartnerName2 AS BusinessPartnerName2,
  _JITOutboundCallTP._SupplierToBusinessPartner._Supplier.BusinessPartnerName3 AS BusinessPartnerName3,
  JITDeliveryDateTime,
  JITCompGroupMessageStatus,
  JITCompGrpIntSequenceNumber,
  _JITOutboundCall.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITOutboundCall.JITLifecycleStatus AS JITLifecycleStatus,
  _JITOutboundCall._JITLifecycleStatus._Text[1:Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  _JITInbCallComponentGroupTP.JITDelivSqncGrpID AS JITDelivSqncGrpID,
  _JITInbCallComponentGroupTP.InternalJITCallNumber AS ReferenceJustInTimeCallNumber,
  _JITOutboundCall.ReferenceJITCallUUID AS ReferenceJITCallUUID,
  _JITInbCallComponentGroupTP._JITInboundCallTP.ShipToParty AS ShipToParty,
  JITDeliveryDocCrtnDateTime,
  JITAdvncShipgNotifDocDateTime,
  JITGoodsRcptDocCrtnDateTime,
  JITRdyForWarehouseDocDateTime,
  JITStockTransferDocDateTime,
  JITAdvanceShippingNotifStatus,
  _JITAdvanceShipNotifSts._Text[1: Language = $session.system_language].JITAdvanceShippingNotifStsText AS JITAdvanceShippingNotifStsText,
  JITReadyForWarehouseStatus,
  _JITReadyForWarehouseStatus._Text[1: Language = $session.system_language].JITReadyForWarehouseStatusText AS JITReadyForWarehouseStatusText,
  _JITOutboundCall.JITCallCreationMode AS JITCallCreationMode,
  virtual JITInternalStatusCriticality : abap.int1 AS int1,
  virtual RespyMgmtTeamName : rsm_de_team_name AS virtualRespyMgmtTeamNamersm_de_team_name,
  virtual Material : matnr AS virtualMaterialmatnr,
  virtual EWMStorageType : /scwm/lgtyp AS virtualEWMStorageTypescwmlgtyp,
  virtual EWMWarehouse : njit_dest_lgnum AS virtualEWMWarehousenjit_dest_lgnum,
  virtual JustInTimeInboundDelivery : vbeln_vl AS virtualJustInTimeInboundDeliveryvbeln_vl,
  virtual HandlingUnitExternalID : exidv AS virtualHandlingUnitExternalIDexidv,
  _JITOutboundCall._ReferenceReorderJISCall.InternalJITCallNumber AS ReorderReferenceJITCallNumber,
  _JITInbCallComponentGroupTP._JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  _JITOutboundCall.ReorderReferenceJITCallUUID AS ReorderReferenceJITCallUUID,
  _JITOutboundCall.VehicleIdentificationNumber AS VehicleIdentificationNumber,
  _JITOutboundCall.JITVehicleModel AS JITVehicleModel,
  _JITOutboundCall.CreationDateTime AS CreationDateTime,
  _JITOutboundCall.CreatedByUser AS CreatedByUser,
  _JITOutboundCall._CreatedByUser.FullName AS CreatedByUserDescription,
  _JITOutboundCall.LastChangeDateTime AS LastChangeDateTime,
  _JITOutboundCall.LastChangedByUser AS LastChangedByUser,
  _JITOutboundCall._LastChangedByUser.FullName AS LastChangedByUserDescription,
  _JITOutboundCall.JITIsReorderedExternally AS JITIsReorderedExternally,
  _JITOutboundCall.JITIntSequenceNumber AS JITIntSequenceNumber,
  JITComponentGroupIsCancelled,
  JITCompGrpExternalStatus,
  _JITInbCallComponentGroupTP.CustCompGrpMatl AS CustCompGrpMatl,
  TransportationMgmtControlKey,
  JITCompGrpChangeDateTime,
  JITCompGrpCreationDateTime,
  JITCompMatlStorageLocation
FROM R_JITOutbCallComponentGroupTP
LEFT OUTER JOIN C_JITOutbFwdSqncEDIMsgRef AS _JITOutbSqncCallEDIMsgRef ON InternalJITCallNumber = _JITOutbSqncCallEDIMsgRef.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN C_JITOutbSqncCompGrpProcFlow AS _JITOutbSqncCompGrpProcFlow ON JITCallCompGrpUUID = _JITOutbSqncCompGrpProcFlow.JITCallCompGrpUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbSqncCallReorder AS _JITOutbSqncCallReorder ON JITHeaderUUID = _JITOutbSqncCallReorder.JITHeaderUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbFwdSqncCompGrpDoc AS _JITOutbFwdSqncCompGrpDoc ON JITCallCompGrpUUID = _JITOutbFwdSqncCompGrpDoc.JITCallCompGrpUUID  -- association [1..*]
LEFT OUTER JOIN C_JustInTimeInboundDelivery AS _JustInTimeInboundDelivery ON JITCallCompGrpUUID = _JustInTimeInboundDelivery.JITCallCompGrpUUID AND JITCallComponentGrpItemNumber = _JustInTimeInboundDelivery.BusinessTransactionDocItem  -- association [0..1]
LEFT OUTER JOIN C_JITOutbReorderJISCallCompGrp AS _JITOutbReorderJISCallCompGrp ON JITHeaderUUID = _JITOutbReorderJISCallCompGrp.ReorderReferenceJITCallUUID AND CompGrpMatl = _JITOutbReorderJISCallCompGrp.CompGrpMatl  -- association [0..*]
;