I_JITOutbCallCompGrp

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_JITOutbCallCompGrp.
-- 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_JITOutbCallCompGrp AS
SELECT
  db_key AS JITCallCompGrpUUID,
  int_call_num AS InternalJITCallNumber,
  comp_grp_num AS CompGrpNumber,
  parent_key AS ParentDraftKey,
  ext_comp_grp_num AS ExtCompGrpNumber,
  comp_grp_mat AS CompGrpMatl,
  cust_comp_grp_mat AS CustCompGrpMatl,
  ext_sequence_num AS JITExtSequenceNumber,
  ext_stat_trans AS TransmittedExtStatusByMfr,
  ext_stat AS JITExtStatusAtSupplier,
  ext_stat_updated_on AS JITExtStatusUpdtdOn,
  int_stat AS JITIntProcessingStatus,
  int_stat_updated_on AS JITIntStatusUpdtdOn,
  requirement_dt AS RequirementDateTime,
  supply_date_time AS JITSupplyDateTime,
  werks AS Plant,
  cust_sup_area AS CustSupplyArea,
  ablad AS UnloadingPointName,
  njit_call_d_cgrp.supply_cntrl AS SupplyControlID,
  njit_call_d_cgrp.supplycontroluuid AS SupplyControlUUID,
  action_cntrl AS JITActionCtrl,
  fldpo AS CustAssemblyLoc,
  vstel AS ShippingPoint,
  lgort AS StorageLocation,
  planned_shipping_dt AS PlannedShippingDateTime,
  actual_shipping_dt AS ActualShippingDateTime,
  material_availability_date AS MaterialAvailabilityDate,
  wldat AS RequestedDeliveryDate,
  wluhr AS RequestedDeliveryTime,
  ewm_lgnum AS WarehouseNumber,
  src_lgnum AS JITSourceWarehouseNumber,
  ledat AS DeliveryCreationDate,
  prodn_start_date AS ProductionStartDate,
  deli_crea_stat AS DeliveryStatus,
  pick_stat AS PickingStatus,
  goods_mvmt_stat AS GoodsMovementStatus,
  stk_trnsfr_stat AS JITOutbStockTransferSts,
  control_cycle AS JITControlCycle,
  prod_sup_area AS ProductionSupplyArea,
  dest_storage_loc AS JITOutbDestinationStorLoc,
  GoodsReceivingPoint,
  cast('' as productdescription) AS ProductName,
  delivery_date_time AS JITDeliveryDateTime,
  jit_callissetrelevant AS JITCallIsSetRelevant
FROM njit_call_d_cgrp
LEFT OUTER JOIN I_Product AS _ProductCompGrp ON CompGrpMatl = _ProductCompGrp.Product  -- association [1..1]
LEFT OUTER JOIN I_JITInternalStatus AS _JITInternalStatus ON JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
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_JITStockTransferSts AS _JITStockTransferSts ON JITOutbStockTransferSts = _JITStockTransferSts.JITOutbStockTransferSts  -- association [0..1]
LEFT OUTER JOIN I_JITOutbCallHeader AS _JITOutbCallHeader ON ParentDraftKey = _JITOutbCallHeader.JITHeaderUUID AND InternalJITCallNumber = _JITOutbCallHeader.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_JITControlCycle AS _JITControlCycle ON JITControlCycle = _JITControlCycle.JITControlCycle  -- association [1..1]
LEFT OUTER JOIN I_JITOutbCallCompMatl AS _JITOutbCallCompMatl ON InternalJITCallNumber = _JITOutbCallCompMatl.InternalJITCallNumber AND CompGrpNumber = _JITOutbCallCompMatl.CompGrpNumber AND ParentDraftKey = _JITOutbCallCompMatl.RootDraftKey  -- association [0..*]
;