I_JITOutbCallComponentGroupDet

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 I_JITOutbCallComponentGroupDet.
-- 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 I_JITOutbCallComponentGroupDet AS
SELECT
  db_key AS JITCallCompGrpUUID,
  parent_key AS JITHeaderUUID,
  int_call_num AS InternalJITCallNumber,
  comp_grp_num AS CompGrpNumber,
  JITCallComponentGrpItemNumber,
  ext_comp_grp_num AS ExtCompGrpNumber,
  comp_grp_mat AS CompGrpMatl,
  requirement_dt AS RequirementDateTime,
  supply_date_time AS JITSupplyDateTime,
  werks AS Plant,
  ablad AS UnloadingPointName,
  action_cntrl AS JITActionCtrl,
  lgort AS StorageLocation,
  jit_compmatlstoragelocation AS JITCompMatlStorageLocation,
  ewm_lgnum AS EWMWarehouse,
  src_lgnum AS JITSourceWarehouseNumber,
  control_cycle AS JITControlCycle,
  prod_sup_area AS ProductionSupplyArea,
  dest_storage_loc AS JITOutbDestinationStorLoc,
  referencecompgrpuuid AS ReferenceJITComponentGroupUUID,
  int_stat AS JITIntProcessingStatus,
  int_stat_updated_on AS JITIntStatusUpdtdOnDteTme,
  ext_stat AS JITCompGrpExternalStatus,
  reference_scheduling_date_time AS JITRefSchedulingDateTime,
  deli_crea_stat AS DeliveryStatus,
  pick_stat AS PickingStatus,
  goods_mvmt_stat AS GoodsMovementStatus,
  stk_trnsfr_stat AS JITOutbStockTransferSts,
  asn_stat AS JITAdvanceShippingNotifStatus,
  ready_for_warehouse_stat AS JITReadyForWarehouseStatus,
  delivery_date_time AS JITDeliveryDateTime,
  jitcompgrpmsgstatus AS JITCompGroupMessageStatus,
  int_sequence_num AS JITCompGrpIntSequenceNumber,
  RequestedQuantity,
  cancellationstatus AS JITComponentGroupIsCancelled,
  QuantityUnit,
  GoodsReceivingPoint,
  GrossWeight,
  WeightUnit,
  NetWeight,
  TransportationMgmtControlKey,
  JITDeliveryDocCrtnDateTime,
  JITAdvncShipgNotifDocDateTime,
  JITGoodsRcptDocCrtnDateTime,
  JITRdyForWarehouseDocDateTime,
  JITStockTransferDocDateTime,
  locallastchangedatetime AS JITCompGrpChangeDateTime,
  JITCompGrpCreationDateTime
FROM njit_call_d_cgrp AS JITOutbCallComponentGroupDet
LEFT OUTER JOIN I_ProductionSupplyArea AS _ProductionSupplyArea ON ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea AND Plant = _ProductionSupplyArea.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_JITControlCycle AS _JITControlCycle ON JITControlCycle = _JITControlCycle.JITControlCycle  -- association [0..1]
LEFT OUTER JOIN I_Product AS _ProductCompGrp ON CompGrpMatl = _ProductCompGrp.Product  -- association [1..1]
LEFT OUTER JOIN I_JITPlant AS _JITPlant ON Plant = _JITPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_JITInternalStatus AS _JITInternalStatus ON JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITStockTransferSts AS _JITStockTransferSts ON JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts  -- association [0..1]
LEFT OUTER JOIN I_JITDeliveryStatus AS _JITDeliveryStatus ON DeliveryStatus = _JITDeliveryStatus.DeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_JITGoodsMovementStatus AS _JITGoodsMovementStatus ON GoodsMovementStatus = _JITGoodsMovementStatus.GoodsMovementStatus  -- association [0..1]
LEFT OUTER JOIN I_JustInTimeOutboundCall AS _JITOutboundCall ON JITHeaderUUID = _JITOutboundCall.JITHeaderUUID  -- association [1..1]
LEFT OUTER JOIN I_JITOutbCallComponent AS _JITOutbCallComponent ON JITCallCompGrpUUID = _JITOutbCallComponent.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN I_ShippingPointText AS _ShippingPointText ON GoodsReceivingPoint = _ShippingPointText.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_JITAdvanceShipNotifSts AS _JITAdvanceShipNotifSts ON JITAdvanceShippingNotifStatus = _JITAdvanceShipNotifSts.JITAdvanceShippingNotifStatus  -- association [0..1]
LEFT OUTER JOIN I_JITReadyForWarehouseStatus AS _JITReadyForWarehouseStatus ON JITReadyForWarehouseStatus = _JITReadyForWarehouseStatus.JITReadyForWarehouseStatus  -- association [0..1]
LEFT OUTER JOIN E_JITOutbCallComponentGroup AS _ExtentionJITOutbCompGrp ON JITCallCompGrpUUID = _ExtentionJITOutbCompGrp.JITCallCompGrpUUID  -- association [0..1]
;