C_JITInboundCallTP

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 C_JITInboundCallTP.
-- 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 C_JITInboundCallTP AS
SELECT
  JITHeaderUUID,
  InternalJITCallNumber,
  JITScenario,
  ExternalJITCallNumber,
  CustomerUUID,
  ShipToParty,
  SoldToParty,
  SalesOrganization,
  DistributionChannel,
  Division,
  UnloadingPointName,
  CustomerPartnerDescription,
  MatlUsageIndicator,
  ActiveSupplier,
  JITCallType,
  JITLifecycleStatus,
  VehicleModel,
  VehicleIdentificationNumber,
  JITExtSequenceNumber,
  ApplLogHighestMessageSeverity,
  JITComponentIsReordered,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  JITCallProcessingMode,
  _Customer.CustomerName AS BusinessPartnerName,
  _SoldToParty.OrganizationBPName1 AS OrganizationBPName1,
  _MatlUsageIndicator._Text.MatlUsageIndicatorText : localized AS MatlUsageIndicatorTextlocalized,
  _JITCallType._Text.JITCallTypeText : localized AS JITCallTypeTextlocalized,
  _JITLifecycleStatus._Text.JITLifecycleStatusText : localized AS JITLifecycleStatusTextlocalized,
  _JITComponentIsReordered._Text.JITComponentIsReorderedText : localized AS JITComponentIsReorderedTextlocalized,
  _LastChangedByUserDescription.UserDescription AS UserDescription,
  virtual JITLifeCycleStatusCriticality : abap.int1 AS int1,
  virtual CompGrpMatl : matnr AS virtualCompGrpMatlmatnr,
  virtual Plant : werks_d AS virtualPlantwerks_d,
  virtual Material : matnr AS virtualMaterialmatnr,
  virtual ActiveDivision : spart AS virtualActiveDivisionspart,
  virtual DeliveryCreationDate : ledat AS virtualDeliveryCreationDateledat,
  virtual MaterialAvailabilityDate : mbdat AS virtualMaterialAvailabilityDatembdat,
  virtual OutboundDelivery : vbeln_vl AS virtualOutboundDeliveryvbeln_vl,
  virtual JITRefType : njit_refty AS virtualJITRefTypenjit_refty,
  virtual JITRefText : njit_reftx AS virtualJITRefTextnjit_reftx,
  virtual JITActionCtrl : njit_act_cntrl AS virtualJITActionCtrlnjit_act_cntrl,
  virtual CustAssemblyLoc : njit_fldpo AS virtualCustAssemblyLocnjit_fldpo,
  virtual CustSupplyArea : njit_cs_area AS virtualCustSupplyAreanjit_cs_area,
  virtual HandlingUnitNumber : exidv AS virtualHandlingUnitNumberexidv,
  virtual JITPckgGrpID : njit_pckg_grp_id AS virtualJITPckgGrpIDnjit_pckg_grp_id,
  virtual JITPckgGrpCellNumber : posnr AS virtualJITPckgGrpCellNumberposnr,
  virtual ProductionLine : sa_line1 AS virtualProductionLinesa_line1,
  virtual SerialNumber : gernr AS virtualSerialNumbergernr,
  virtual ShippingPoint : vstel AS virtualShippingPointvstel,
  virtual SupplyControlID : njit_sc_id AS virtualSupplyControlIDnjit_sc_id,
  virtual VarianceReasonCode : co_agrnd AS virtualVarianceReasonCodeco_agrnd,
  virtual JITResultHdrText : val_text AS virtualJITResultHdrTextval_text
FROM R_JITInboundCallTP
LEFT OUTER JOIN C_JITCustContactPersonTP AS _JITContactPerson ON CustomerUUID = _JITContactPerson.CustomerUUID  -- association [0..*]
LEFT OUTER JOIN C_JITShipToPartyQuickView AS _JITShipToPartyQuickView ON ShipToParty = _JITShipToPartyQuickView.ShipToParty  -- association [0..1]
LEFT OUTER JOIN C_JITInbCallEDIMsgReference AS _JITInbCallEDIMsgReference ON ExternalJITCallNumber = _JITInbCallEDIMsgReference.ExternalJITCallNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallCompGrpProcg AS _JITCallCompGrpProcg ON JITHeaderUUID = _JITCallCompGrpProcg.JITHeaderUUID  -- association [0..*]
;