I_JITInbCallComponentGroup

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_JITInbCallComponentGroup.
-- 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_JITInbCallComponentGroup AS
SELECT
  db_key AS JITCallCompGrpUUID,
  parent_key AS JITHeaderUUID,
  int_call_num AS InternalJITCallNumber,
  JITCallComponentGrpItemNumber,
  comp_grp_num AS CompGrpNumber,
  JITPredecessorCompGrpItmNmbr,
  ext_comp_grp_num AS ExtCompGrpNumber,
  comp_grp_mat AS CompGrpMatl,
  cust_comp_grp_mat AS CustCompGrpMatl,
  cust_sup_area AS CustSupplyArea,
  ablad AS UnloadingPointName,
  werks AS Plant,
  fldpo AS CustAssemblyLoc,
  vstel AS ShippingPoint,
  lgort AS StorageLocation,
  ProductionVersion,
  JITDelivConfControl,
  JITSuperPckgGrpUUID,
  ext_stat_trans AS TransmittedExtStatusByMfr,
  TransmittedExtStsUpdtdDteTme,
  ext_stat AS JITExtStatusAtSupplier,
  ext_stat_updated_on AS JITExtStatusUpdtdOn,
  int_stat AS JITIntProcessingStatus,
  int_stat_updated_on AS JITIntStatusUpdtdOn,
  supply_cntrl AS SupplyControlID,
  SupplyControlUUID,
  action_cntrl AS JITActionCtrl,
  requirement_dt AS RequirementDateTime,
  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,
  prodn_start_date AS ProductionStartDate,
  JITProductionStartTime,
  prodn_end_date AS ProductionEndDate,
  DeliveryCreationTime,
  int_sequence_num AS JITIntSequenceNumber,
  ext_sequence_num AS JITExtSequenceNumber,
  formatted_sequence_num AS JITFormattedSequenceNumber,
  formatted_sequence_num_prefix AS JITFormattedSequenceNmbrPrefix,
  interval_range AS JITFrmtdSqncNmbrIntervalRange,
  JITDelivSqncGrpID,
  JITDelivSqncGrpUUID,
  deli_crea_stat AS DeliveryStatus,
  pick_stat AS PickingStatus,
  goods_mvmt_stat AS GoodsMovementStatus,
  pkg_grp_stat AS JITCompGrpDocPckgGrpSts,
  r2p_stat AS JITCompGrpDocRelToProdnSts,
  cp_stat AS JITCompGrpDocConfToProdnSts,
  bill_stat AS OverallBillingStatus,
  hu_stat AS HandlingUnitStatus,
  pack_stat AS JITPackingConfirmationStatus,
  r2pck_stat AS JITReleaseForPackingStatus,
  cancellationstatus AS JITCallCompGrpCancellationSts,
  RequestedQuantity,
  QuantityUnit,
  NetWeight,
  GrossWeight,
  WeightUnit,
  LocalLastChangeDateTime,
  JITCallForwardingStatus
FROM njit_call_d_cgrp
LEFT OUTER JOIN I_JITInbCallComponent AS _JITInbCallComponent ON JITCallCompGrpUUID = _JITInbCallComponent.JITCallCompGrpUUID  -- association [0..*]
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_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_JITPckgGrpItemRef AS _JITPckgGrpItemRef ON JITCallCompGrpUUID = _JITPckgGrpItemRef.ReferenceDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCallCompGrpCanclnStatus AS _JITCallCompGrpCanclnStatus ON JITCallCompGrpCancellationSts = _JITCallCompGrpCanclnStatus.JITCallCompGrpCancellationSts  -- 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_JITPackingGrpCreationStatus AS _JITPackingGrpCreationStatus ON JITCompGrpDocPckgGrpSts = _JITPackingGrpCreationStatus.JITPackingGroupCreationStatus  -- 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_JITBillingStatus AS _JITBillingStatus ON OverallBillingStatus = _JITBillingStatus.JITBillingStatus  -- 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_JITPckgGrpStatus AS _JITPckgGrpStatus ON PickingStatus = _JITPckgGrpStatus.JITPckgGrpStatus  -- association [0..1]
LEFT OUTER JOIN I_JITPckgGrpHeader AS _JITPckgGrpHeader ON JITSuperPckgGrpUUID = _JITPckgGrpHeader.JITPckgGrpUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCompGrpEnhanced AS _JITCompGrpEnhanced ON JITCallCompGrpUUID = _JITCompGrpEnhanced.JITCallCompGrpUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCallCompGrpRefTextEnhcd AS _JITCallCompGrpRefTextEnhcd ON JITCallCompGrpUUID = _JITCallCompGrpRefTextEnhcd.JITObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCallHdrRefTextEnhcd AS _JITCallHdrRefTextEnhcd ON JITHeaderUUID = _JITCallHdrRefTextEnhcd.JITObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_JITDelivSqncGrpHeaderBasic AS _JITDelivSqncGrpHeaderBasic ON JITDelivSqncGrpUUID = _JITDelivSqncGrpHeaderBasic.JITDelivSqncGrpUUID  -- association [0..1]
LEFT OUTER JOIN I_JITActionCtrl AS _JITActionCtrl ON JITActionCtrl = _JITActionCtrl.JITActionCtrl  -- association [0..1]
LEFT OUTER JOIN I_JITDelivConfControl AS _JITDelivConfControl ON JITDelivConfControl = _JITDelivConfControl.JITDelivConfControl  -- association [0..1]
LEFT OUTER JOIN I_JITCallForwardingStatus AS _JITCallForwardingStatus ON JITCallForwardingStatus = _JITCallForwardingStatus.JITCallForwardingStatus  -- association [0..1]
LEFT OUTER JOIN E_JITInbCallComponentGroup AS _Extension ON JITCallCompGrpUUID = _Extension.JITCallCompGrpUUID  -- association [1]
LEFT OUTER JOIN I_JITInbCallActionLog AS _JITInbCallActionLog ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITInbCallCompGrpRefText AS _JITInbCallCompGrpRefText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITInbCallCompGrpDocRef AS _JITInbCallCompGrpDocRef ON /* condition not available in parsed metadata */  -- association [0..*]
;