C_JITInbCallComponentTP

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_JITInbCallComponentTP.
-- 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_JITInbCallComponentTP AS
SELECT
  JITCallComponentUUID,
  JITHeaderUUID,
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  Material,
  MaterialByCustomer,
  ExtJITCallItemNumber,
  SalesSchedulingAgreement,
  SalesSchedulingAgreementItem,
  Division,
  Plant,
  StorageLocation,
  ShippingPoint,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  JITCallCompMatlBackflushStatus,
  JITCallCompMatlBackflushType,
  _JITBackflushType._Text[1:Language = $session.system_language].JITBackflushTypeText AS JITBackflushTypeText,
  _JITBackflushStatus._Text[1:Language = $session.system_language].JITBackflushStatusText AS JITBackflushStatusText,
  JITCallCompBackflushStsUpdtdOn,
  _ProductCompMatl._Text[1: Language=$session.system_language].ProductName AS ProductName,
  TransmittedExtStatusByMfr,
  _JITInboundCallTP.ShipToParty AS ShipToParty,
  RequirementDateTime,
  PlannedShippingDateTime,
  UnloadingPointName,
  CustAssemblyLoc,
  CustSupplyArea,
  ExtCompGrpNumber,
  LocalLastChangeDateTime,
  _JITInboundCallTP.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITInbCallComponentGroupTP.DeliveryStatus AS DeliveryStatus,
  virtual UICT_JITReqdAndDlvrdQtyCritlty : abap.char(3) AS char3,
  VarianceReasonCode,
  CustCompGrpMatl,
  JITExtSequenceNumber,
  JITExtStatusUpdtdOn,
  JITPredecessorCompGrpItmNmbr,
  JITDelivConfQuantity,
  JITInbCallCompDelivConfStatus,
  _JITInbCallCompDlvConfSts._Text.JITCompDelivConfStatusText: localized AS JITCompDelivConfStatusTextlocalized,
  virtual JITCompGrpIsDlvConfRlvt : boolean AS virtualJITCompGrpIsDlvConfRlvtboolean
FROM R_JITInbCallComponentTP
LEFT OUTER JOIN C_JITInbCallDeliveryDocRef AS _JITInbCallDeliveryDocRef ON InternalJITCallNumber = _JITInbCallDeliveryDocRef.InternalJITCallNumber AND CompGrpNumber = _JITInbCallDeliveryDocRef.CompGrpNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallDelivConfRefDoc AS _JITCallDelivConfRefDoc ON InternalJITCallNumber = _JITCallDelivConfRefDoc.BusinessTransactionDocument AND JITCallItemNumber = _JITCallDelivConfRefDoc.BusinessTransactionDocItem  -- association [0..*]
LEFT OUTER JOIN C_JITCallComponentMatlDocRef AS _JITCallComponentMatlDocRef ON JITCallComponentUUID = _JITCallComponentMatlDocRef.JITCallComponentUUID  -- association [0..*]
LEFT OUTER JOIN C_JITInbCallCompSerialNumber AS _JITInbCallCompSerialNumber ON InternalJITCallNumber = _JITInbCallCompSerialNumber.InternalJITCallNumber AND CompGrpNumber = _JITInbCallCompSerialNumber.CompGrpNumber AND JITCallItemNumber = _JITInbCallCompSerialNumber.JITCallItemNumber  -- association [0..*]
LEFT OUTER JOIN C_JITInbCallFwdngCompRef AS _JITInbCallFwdngCompRef ON JITCallComponentUUID = _JITInbCallFwdngCompRef.ReferenceJITComponentUUID  -- association [0..*]
;