I_JITInboundCall

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_JITInboundCall.
-- 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_JITInboundCall AS
SELECT
  db_key AS JITHeaderUUID,
  int_call_num AS InternalJITCallNumber,
  njit_scenario AS JITScenario,
  ext_call_num AS ExternalJITCallNumber,
  CustomerUUID,
  kunnr AS ShipToParty,
  kunag AS SoldToParty,
  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,
  call_type AS JITCallType,
  lifecycle_stat AS JITLifecycleStatus,
  vhcle_model AS VehicleModel,
  vhvin AS VehicleIdentificationNumber,
  ext_sequence_num AS JITExtSequenceNumber,
  int_sequence_num AS JITIntSequenceNumber,
  JITComponentIsReordered,
  crea_date_time AS CreationDateTime,
  crea_uname AS CreatedByUser,
  lchg_date_time AS LastChangeDateTime,
  lchg_uname AS LastChangedByUser
FROM njit_call_d_hdr
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerToBusinessPartner ON CustomerUUID = _CustomerToBusinessPartner.BusinessPartnerUUID  -- 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 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_UserDescription AS _LastChangedByUserDescription ON LastChangedByUser = _LastChangedByUserDescription.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserDescription AS _CreatedByUserDescription ON CreatedByUser = _CreatedByUserDescription.UserID  -- 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_BusinessPartner AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_JITCallHdrRefTextEnhcd AS _JITCallHdrRefTextEnhcd ON JITHeaderUUID = _JITCallHdrRefTextEnhcd.JITObjectUUID  -- association [0..1]
LEFT OUTER JOIN E_JITInboundCall AS _Extension ON JITHeaderUUID = _Extension.JITHeaderUUID  -- association [1]
LEFT OUTER JOIN I_JITInbCallComponentGroup AS _JITInbCallComponentGroup ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITInbCallComponent AS _JITInbCallComponent ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITInbCallReferenceText AS _JITInbCallReferenceText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_JITInbCallDocReference AS _JITInbCallDocReference ON /* condition not available in parsed metadata */  -- association [0..*]
;