I_JITCallCompGroupBasic

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_JITCallCompGroupBasic.
-- 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_JITCallCompGroupBasic AS
SELECT
  db_key AS JITCallCompGrpUUID,
  int_call_num AS InternalJITCallNumber,
  comp_grp_num AS CompGrpNumber,
  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,
  int_sequence_num AS JITIntSequenceNumber,
  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,
  formatted_sequence_num_prefix AS JITFormattedSequenceNmbrPrefix,
  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,
  r2pck_stat AS JITReleaseForPackingStatus,
  cp_stat AS JITCompGrpDocConfToProdnSts,
  pkg_grp_stat AS JITCompGrpDocPckgGrpSts,
  bill_stat AS OverallBillingStatus,
  hu_stat AS HandlingUnitStatus,
  pack_stat AS JITPackingConfirmationStatus,
  JITDelivConfControl,
  JITSuperPckgGrpUUID,
  JITProductionStartTime,
  interval_range AS JITFrmtdSqncNmbrIntervalRange,
  cancellationstatus AS JITCallCompGrpCancellationSts
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_JITCallCompMaterialBasic AS _JITCallCompMaterialBasic ON JITCallCompGrpUUID = _JITCallCompMaterialBasic.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN I_JITCallHeaderBasic AS _JITCallHeaderBasic ON JITHeaderUUID = _JITCallHeaderBasic.JITHeaderUUID AND InternalJITCallNumber = _JITCallHeaderBasic.InternalJITCallNumber  -- association [0..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..*]
LEFT OUTER JOIN I_JITPckgGrpHeader AS _JITPckgGrpHeader ON JITSuperPckgGrpUUID = _JITPckgGrpHeader.JITPckgGrpUUID  -- association [1..1]
LEFT OUTER JOIN I_JITDelivSqncGrpHeaderBasic AS _JITDelivSqncGrpHeaderBasic ON JITDelivSqncGrpUUID = _JITDelivSqncGrpHeaderBasic.JITDelivSqncGrpUUID  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion ON CompGrpMatl = _ProductionVersion.Material AND Plant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_JITGoodsMovementStatus AS _JITGoodsMovementStatus ON GoodsMovementStatus = _JITGoodsMovementStatus.GoodsMovementStatus  -- association [0..1]
LEFT OUTER JOIN I_JITReleaseToProductionStatus AS _JITReleaseToProductionStatus ON JITCompGrpDocRelToProdnSts = _JITReleaseToProductionStatus.JITReleaseToProductionStatus  -- association [0..1]
LEFT OUTER JOIN I_JITProdnConfirmationStatus AS _JITProdnConfirmationStatus ON JITCompGrpDocConfToProdnSts = _JITProdnConfirmationStatus.JITProdnConfirmationStatus  -- association [0..1]
LEFT OUTER JOIN I_JITReleaseToPackingStatus AS _JITReleaseToPackingStatus ON JITReleaseForPackingStatus = _JITReleaseToPackingStatus.JITReleaseToPackingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITPackingConfStatus AS _JITPackingConfStatus ON JITPackingConfirmationStatus = _JITPackingConfStatus.JITPackingConfirmationStatus  -- association [0..1]
LEFT OUTER JOIN I_JITHndlgUnitCrtnStatus AS _JITHndlgUnitCrtnStatus ON HandlingUnitStatus = _JITHndlgUnitCrtnStatus.HandlingUnitStatus  -- association [0..1]
LEFT OUTER JOIN I_JITPackingGrpCreationStatus AS _JITPackingGrpCreationStatus ON JITCompGrpDocPckgGrpSts = _JITPackingGrpCreationStatus.JITPackingGroupCreationStatus  -- association [0..1]
LEFT OUTER JOIN I_JITDeliveryStatus AS _JITDeliveryStatus ON DeliveryStatus = _JITDeliveryStatus.DeliveryStatus  -- association [0..1]
;