C_JITCallComponent

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_JITCallComponent.
-- 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_JITCallComponent AS
SELECT
  JITCallComponentUUID,
  JITHeaderUUID,
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  Material,
  MaterialByCustomer,
  ExtJITCallItemNumber,
  SalesSchedulingAgreement,
  SalesSchedulingAgreementItem,
  Division,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  JITCallCompMatlBackflushStatus,
  JITCallCompMatlBackflushType,
  JITCallCompBackflushStsUpdtdOn,
  _ProductCompMatl._Text[1: Language=$session.system_language].ProductName AS ProductName,
  _JITInbCallComponentGroupTP._JITSupplyControlHeader.JITUnderDeliveryToleranceInPct AS JITUnderDeliveryToleranceInPct,
  _JITInbCallComponentGroupTP._JITSupplyControlHeader.JITOverDeliveryToleranceInPct AS JITOverDeliveryToleranceInPct,
  _JITInbCallComponentGroupTP._JITSupplyControlHeader.JITUnlimitedOverDelivIsAllowed AS JITUnlimitedOverDelivIsAllowed,
  _JITInbCallComponentGroupTP._JITSupplyControlHeader.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  _JITInbCallComponentGroupTP._JITSupplyControlHeader._JITPartialDelivery._Text [1: Language = $session.system_language ].PartialDeliveryIsAllowedText AS PartialDeliveryIsAllowedText,
  _JITBackflushStatus ._Text[1:Language = $session.system_language].JITBackflushStatusText AS JITBackflushStatusText,
  _JITInbCallComponentGroupTP.DeliveryStatus AS DeliveryStatus,
  virtual UICT_JITReqdAndDlvrdQtyCritlty : abap.char(3) AS char3,
  virtual JITDelivQtyRngeVal : stringval AS virtualJITDelivQtyRngeValstringval,
  VarianceReasonCode,
  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_JITInbCallCompSerialNumber AS _JITInbCallCompSerialNumber ON InternalJITCallNumber = _JITInbCallCompSerialNumber.InternalJITCallNumber AND CompGrpNumber = _JITInbCallCompSerialNumber.CompGrpNumber AND JITCallItemNumber = _JITInbCallCompSerialNumber.JITCallItemNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallComponentMatlDocRef AS _JITCallComponentMatlDocRef ON JITCallComponentUUID = _JITCallComponentMatlDocRef.JITCallComponentUUID  -- association [0..*]
;