C_JITOutbSqncCallCompGrpDetTP

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_JITOutbSqncCallCompGrpDetTP.
-- 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_JITOutbSqncCallCompGrpDetTP AS
SELECT
  JITCallCompGrpUUID,
  JITHeaderUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  CompGrpMatl,
  _ProductCompGrp._Text[1: Language = $session.system_language].ProductName AS ProductName,
  JITIntStatusUpdtdOnDteTme,
  RequirementDateTime,
  JITSupplyDateTime,
  JITDeliveryDateTime,
  Plant,
  _JITPlant.PlantName AS PlantName,
  UnloadingPointName,
  JITActionCtrl,
  JITControlCycle,
  ProductionSupplyArea,
  JITOutbDestinationStorLoc,
  _ProductionSupplyArea._Text[1: Language = $session.system_language].ProductionSupplyAreaName AS ProductionSupplyAreaName,
  _JITControlCycle._ProductionSupplyArea.AutomotiveLoadingPoint AS AutomotiveLoadingPoint,
  Supplier,
  _SupplierToBusinessPartner._Supplier.SupplierName AS SupplierName,
  _JITControlCycle.ExtProcurementReplnmtStrgy AS ExtProcurementReplnmtStrgy,
  _JITControlCycle.StorageBin AS EWMStorageBin,
  JITIntProcessingStatus,
  _JITInternalStatus._Text[1: Language = $session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITInternalStatus.JITIntProcessingStatusType AS JITIntProcessingStatusType,
  DeliveryStatus,
  _JITDeliveryStatus._Text[1: Language = $session.system_language].DeliveryStatusText AS DeliveryStatusText,
  JITAdvanceShippingNotifStatus,
  _JITAdvanceShipNotifSts._Text[1: Language = $session.system_language].JITAdvanceShippingNotifStsText AS JITAdvanceShippingNotifStsText,
  PickingStatus,
  _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,
  JITReadyForWarehouseStatus,
  _JITReadyForWarehouseStatus._Text[1: Language = $session.system_language].JITReadyForWarehouseStatusText AS JITReadyForWarehouseStatusText,
  JITDeliveryDocCrtnDateTime,
  JITAdvncShipgNotifDocDateTime,
  JITGoodsRcptDocCrtnDateTime,
  JITRdyForWarehouseDocDateTime,
  JITStockTransferDocDateTime,
  _SupplierToBusinessPartner._Supplier.BusinessPartnerName1 AS BusinessPartnerName1,
  _SupplierToBusinessPartner._Supplier.BusinessPartnerName2 AS BusinessPartnerName2,
  _SupplierToBusinessPartner._Supplier.BusinessPartnerName3 AS BusinessPartnerName3,
  virtual JITInternalStatusCriticality : abap.int1 AS int1,
  virtual EWMStorageType : /scwm/lgtyp AS virtualEWMStorageTypescwmlgtyp,
  virtual EWMWarehouse : njit_dest_lgnum AS virtualEWMWarehousenjit_dest_lgnum,
  _ProductionSupplyArea.StorageLocation AS StorageLocation,
  _ProductionSupplyArea._StorageLocation.StorageLocationName AS StorageLocationName,
  _JITControlCycle.JITOutbCommunicationGroup AS JITOutbCommunicationGroup,
  ExtCompGrpNumber,
  JITCompGroupMessageStatus,
  JITComponentGroupIsCancelled,
  _JITOutboundCall.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITOutboundCall.JITLifecycleStatus AS JITLifecycleStatus,
  _JITInbCallComponentGroupTP._JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  _JITOutboundCall.CreationDateTime AS CreationDateTime,
  _JITOutboundCall.LastChangeDateTime AS LastChangeDateTime,
  _ShippingPointText[1:Language = $session.system_language].ShippingPointName AS ShippingPointName,
  GoodsReceivingPoint,
  _JITInbCallComponentGroupTP.CustCompGrpMatl AS CustCompGrpMatl,
  JITCompGrpExternalStatus,
  TransportationMgmtControlKey,
  JITCompGrpChangeDateTime,
  JITCompGrpCreationDateTime,
  JITCompMatlStorageLocation
FROM R_JITOutbCallComponentGroupTP
LEFT OUTER JOIN C_JITOutbSqncCompGrpProcFlow AS _JITOutbSqncCompGrpProcFlow ON JITCallCompGrpUUID = _JITOutbSqncCompGrpProcFlow.JITCallCompGrpUUID  -- association [1..*]
LEFT OUTER JOIN C_JITOutbCallCompGrpDoc AS _JITOutbCallCompGrpDoc ON JITCallCompGrpUUID = _JITOutbCallCompGrpDoc.JITCallCompGrpUUID  -- association [1..*]
;