I_JITInbCallBySemKey

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_JITInbCallBySemKey.
-- 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_JITInbCallBySemKey AS
SELECT
  int_call_num AS InternalJITCallNumber,
  db_key AS JITHeaderUUID,
  ext_call_num AS ExternalJITCallNumber,
  njit_scenario AS JITScenario,
  CustomerUUID,
  kunnr AS ShipToParty,
  kunag AS SoldToParty,
  lifecycle_stat AS JITLifecycleStatus,
  call_type AS JITCallType,
  vhvin AS VehicleIdentificationNumber,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  ablad AS UnloadingPointName,
  knref AS CustomerPartnerDescription,
  abrvw AS MatlUsageIndicator,
  cast( lifnr as abap.char( 10 ) ) AS ActiveSupplier,
  ext_sequence_num AS JITExtSequenceNumber,
  crea_date_time AS CreationDateTime,
  crea_uname AS CreatedByUser,
  lchg_date_time AS LastChangeDateTime,
  lchg_uname AS LastChangedByUser,
  JITComponentIsReordered
FROM njit_call_d_hdr
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerToBusinessPartner ON ShipToParty = _CustomerToBusinessPartner.Customer  -- association [1..1]
LEFT OUTER JOIN I_JITLifecycleStatus AS _JITLifecycleStatus ON JITLifecycleStatus = _JITLifecycleStatus.JITLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_JITCallType AS _JITCallType ON JITCallType = _JITCallType.JITCallType  -- association [0..1]
LEFT OUTER JOIN I_JITCustomer AS _JITCustomer ON ShipToParty = _JITCustomer.ShipToParty AND CustomerUUID = _JITCustomer.CustomerUUID  -- association [1..1]
LEFT OUTER JOIN I_MatlUsageIndicator AS _MatlUsageIndicator ON MatlUsageIndicator = _MatlUsageIndicator.MatlUsageIndicator  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON ShipToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_JITComponentIsReordered AS _JITComponentIsReordered ON JITComponentIsReordered = _JITComponentIsReordered.JITComponentIsReordered  -- association [0..1]
LEFT OUTER JOIN I_JITInbCallCompGrpBySemKey AS _JITInbCallCompGrpBySemKey ON InternalJITCallNumber = _JITInbCallCompGrpBySemKey.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN I_JITInbCallCompMatlBySemKey AS _JITInbCallCompMatlBySemKey ON InternalJITCallNumber = _JITInbCallCompMatlBySemKey.InternalJITCallNumber  -- association [0..*]
;