A_JITCallHeader

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 A_JITCallHeader.
-- 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.
-- SQL view name: AJITCALLHEADER

CREATE VIEW A_JITCallHeader AS
SELECT
  cast( InternalJITCallNumber as njit_api_int_call_num preserving type ) AS InternalJITCallNumber,
  ExternalJITCallNumber,
  JITCallType,
  ShipToParty,
  cast ( SoldToParty as abap.char( 10 ) ) AS SoldToParty,
  CustomerPartnerDescription,
  ActiveSupplier,
  UnloadingPointName,
  MatlUsageIndicator,
  SalesOrganization,
  DistributionChannel,
  Division,
  JITLifecycleStatus,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  JITExtSequenceNumber,
  VehicleIdentificationNumber,
  VehicleModel,
  Plant,
  cast( ' ' as njit_ext_stat) AS JITExtStatusAtSupplier,
  JITIntProcessingStatus,
  CompGrpMatl,
  Material,
  cast( ' ' as kdmat) AS MaterialByCustomer,
  DeliveryCreationDate,
  RequirementDateTime,
  PlannedShippingDateTime,
  MaterialAvailabilityDate,
  cast( PlannedShippingDateTime as njit_ext_stat_updated_on) AS JITExtStatusUpdtdOn,
  cast( PlannedShippingDateTime as njit_int_stat_updated_on) AS JITIntStatusUpdtdOn,
  cast('' as njit_ext_stat_trans) AS TransmittedExtStatusByMfr,
  cast(0 as njit_tran_ext_stat_updated_on) AS TransmittedExtStsUpdtdDteTme
FROM I_JITCallHeaderDataTP
LEFT OUTER JOIN A_JITCallCompGrp AS _JITCallCompGrpDataTP ON InternalJITCallNumber = _JITCallCompGrpDataTP.InternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN A_Customer AS _Customer ON ShipToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN A_JITCallRefTextHdr AS _JITCallRefTextHdrTP ON InternalJITCallNumber = _JITCallRefTextHdrTP.InternalJITCallNumber  -- association [0..*]
;