I_JITInbCallCompGrpBySemKey

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_JITInbCallCompGrpBySemKey.
-- 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_JITInbCallCompGrpBySemKey AS
SELECT
  int_call_num AS InternalJITCallNumber,
  comp_grp_num AS CompGrpNumber,
  db_key AS JITCallCompGrpUUID,
  parent_key AS JITHeaderUUID,
  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,
  TransmittedExtStsUpdtdDteTme,
  ext_stat_updated_on AS JITExtStatusUpdtdOn,
  int_stat AS JITIntProcessingStatus,
  int_stat_updated_on AS JITIntStatusUpdtdOn,
  requirement_dt AS RequirementDateTime,
  werks AS Plant,
  cust_sup_area AS CustSupplyArea,
  ablad AS UnloadingPointName,
  supply_cntrl AS SupplyControlID,
  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,
  material_availability_time AS MaterialAvailabilityTime,
  wldat AS RequestedDeliveryDate,
  wluhr AS RequestedDeliveryTime,
  lgnum AS WarehouseNumber,
  ledat AS DeliveryCreationDate,
  DeliveryCreationTime,
  formatted_sequence_num AS JITFormattedSequenceNumber,
  JITDelivSqncGrpID,
  JITDelivSqncGrpUUID,
  deli_crea_stat AS DeliveryStatus,
  pick_stat AS PickingStatus,
  goods_mvmt_stat AS GoodsMovementStatus,
  prodn_start_date AS ProductionStartDate,
  prodn_end_date AS ProductionEndDate,
  ProductionVersion,
  r2p_stat AS JITCompGrpDocRelToProdnSts,
  cp_stat AS JITCompGrpDocConfToProdnSts,
  pkg_grp_stat AS JITCompGrpDocPckgGrpSts,
  JITDelivConfControl
FROM njit_call_d_cgrp
LEFT OUTER JOIN I_Product AS _ProductCompGrp ON CompGrpMatl = _ProductCompGrp.Product  -- association [1..1]
LEFT OUTER JOIN I_SupplierExtStatus AS _SupplierExtStatus ON JITExtStatusAtSupplier = _SupplierExtStatus.JITExtStatusAtSupplier  -- association [0..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_JITSupplyControlHeader AS _JITSupplyControlHeader ON SupplyControlUUID = _JITSupplyControlHeader.SupplyControlUUID  -- association [0..1]
LEFT OUTER JOIN I_JITSupplyControlTolLvl AS _JITSupplyControlTolLvl ON SupplyControlUUID = _JITSupplyControlTolLvl.SupplyControlUUID  -- association [0..*]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- 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_JITInbCallCompMatlBySemKey AS _JITInbCallCompMatlBySemKey ON InternalJITCallNumber = _JITInbCallCompMatlBySemKey.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITInbCallBySemKey AS _JITInbCallBySemKey ON InternalJITCallNumber = _JITInbCallBySemKey.InternalJITCallNumber  -- association [1..1]
LEFT OUTER JOIN I_JITPckgGrpItemRef AS _JITPckgGrpItemRef ON JITCallCompGrpUUID = _JITPckgGrpItemRef.ReferenceDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCompGrpDocStatus AS _JITCompGrpDocStatus ON DeliveryStatus = _JITCompGrpDocStatus.JITCompGrpDocStatus  -- association [0..*]
LEFT OUTER JOIN I_JITCompGrpDocStatus AS _JITCompGrpDocRelToProdnStatus ON JITCompGrpDocRelToProdnSts = _JITCompGrpDocRelToProdnStatus.JITCompGrpDocRelToProdnSts  -- association [0..*]
LEFT OUTER JOIN I_JITCompGrpDocStatus AS _JITCompGrpDocConfToProdnSts ON JITCompGrpDocConfToProdnSts = _JITCompGrpDocConfToProdnSts.JITCompGrpDocConfToProdnSts  -- association [0..*]
LEFT OUTER JOIN I_JITCompGrpDocStatus AS _JITCompGrpDocGdsMvtSts ON GoodsMovementStatus = _JITCompGrpDocGdsMvtSts.JITCompGrpDocGdsMvtSts  -- association [0..*]
LEFT OUTER JOIN I_JITCompGrpDocStatus AS _JITCompGrpDocPckgGrpSts ON JITCompGrpDocPckgGrpSts = _JITCompGrpDocPckgGrpSts.JITCompGrpDocPckgGrpSts  -- association [0..*]
;