C_JITCallCompMatlObjPg

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_JITCallCompMatlObjPg.
-- 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_JITCallCompMatlObjPg AS
SELECT
  JITCallComponentUUID,
  JITCallCompGrpUUID,
  JITHeaderUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  ExtJITCallItemNumber,
  Material,
  _ProductCompMatl._Text[1:Language=$session.system_language].ProductName AS MaterialName,
  MaterialByCustomer,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  Division,
  SalesOrder AS SalesSchedulingAgreement,
  SalesOrderItem AS SalesSchedulingAgreementItem,
  JITCallCompMatlBackflushStatus,
  _JITCallHeaderBasic.JITCallType AS JITCallType,
  _JITCallHeaderBasic._JITCallType._Text[1:Language=$session.system_language].JITCallTypeText AS JITCallTypeText,
  _JITCallHeaderBasic.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITCallHeaderBasic.ShipToParty AS ShipToParty,
  _JITCallHeaderBasic.SoldToParty AS SoldToParty,
  _JITCallHeaderBasic.JITExtSequenceNumber AS JITExtSequenceNumber,
  _JITCallHeaderBasic.JITComponentIsReordered AS JITComponentIsReordered,
  _JITCallHeaderBasic._JITComponentIsReordered._Text[1:Language = $session.system_language].JITComponentIsReorderedText AS JITComponentIsReorderedText,
  _JITCallCompGrpEnhanced.ExtCompGrpNumber AS ExtCompGrpNumber,
  _JITCallCompGrpEnhanced.JITFormattedSequenceNumber AS JITFormattedSequenceNumber,
  _JITCallCompGrpEnhanced.Plant AS Plant,
  _JITCallCompGrpEnhanced.JITActionCtrl AS JITActionCtrl,
  _JITCallCompGrpEnhanced.PlannedShippingDateTime AS PlannedShippingDateTime,
  _JITCallCompGrpEnhanced.ActualShippingDateTime AS ActualShippingDateTime,
  _JITCallCompGrpEnhanced.JITPlannedDeliveryCrtnDateTime AS JITPlannedDeliveryCrtnDateTime,
  _JITCallCompGrpEnhanced.RequirementDateTime AS RequirementDateTime,
  _JITCallCompGrpEnhanced.MaterialAvailabilityDateTime AS MaterialAvailabilityDateTime,
  _JITCallCompGrpEnhanced.JITProductionStartDateTime AS JITProductionStartDateTime,
  _JITCallCompGrpEnhanced._JITPackingConfStatus._Text[1:Language = $session.system_language].JITPackingConfirmationStsTxt AS JITPackingConfirmationStsTxt,
  _JITCallCompGrpEnhanced._JITHndlgUnitCrtnStatus._Text[1:Language = $session.system_language].HandlingUnitStatusText AS HandlingUnitStatusText,
  _JITCallCompGrpEnhanced._JITDeliveryStatus._Text[1:Language = $session.system_language].DeliveryStatusText AS DeliveryStatusText,
  _JITCallCompGrpEnhanced._JITPackingGrpCreationStatus._Text[1:Language = $session.system_language].JITPackingGroupCreationStsText AS JITPackingGroupCreationStsText,
  _JITCallCompGrpEnhanced._JITReleaseToProductionStatus._Text[1:Language = $session.system_language].JITReleaseToProductionStsText AS JITReleaseToProductionStsText,
  _JITCallCompGrpEnhanced._JITGoodsMovementStatus._Text[1:Language = $session.system_language].GoodsMovementStatusDesc AS GoodsMovementStatusDesc,
  _JITCallCompGrpEnhanced._JITProdnConfirmationStatus._Text[1:Language = $session.system_language].JITProdnConfirmationStatusText AS JITProdnConfirmationStatusText,
  _JITCallCompGrpEnhanced._JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  _JITCallCompGrpEnhanced.JITDelivSqncGrpID AS JITDelivSqncGrpID,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader._ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader._ProductionVersion.ProductionLine AS ProductionLine,
  _JITCallCompGrpEnhanced.CustSupplyArea AS CustSupplyArea,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader._JITProdnConfirmationControl._Text[1: Language=$session.system_language].JITProdnConfControlText AS JITProdnConfControlText,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader._JITRepetitiveMfg._Text[1:Language = $session.system_language].RepetitiveMfgIsAllwdText AS JITRepetitiveMfgAllwdText,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader._ProductionVersion.IssuingStorageLocation AS IssuingStorageLocation,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader._ProductionVersion.ReceivingStorageLocation AS ReceivingStorageLocation,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader._JITPartialDelivery._Text [1: Language = $session.system_language ].PartialDeliveryIsAllowedText AS PartialDeliveryIsAllowedText,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader.JITUnlimitedOverDelivIsAllowed AS JITUnlimitedOverDelivIsAllowed,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader.JITUnderDeliveryToleranceInPct AS JITUnderDeliveryToleranceInPct,
  _JITCallCompGrpEnhanced._JITSupplyControlHeader.JITOverDeliveryToleranceInPct AS JITOverDeliveryToleranceInPct
FROM I_JITCallCompMaterialBasic
LEFT OUTER JOIN C_JITCallCompMaterial AS _JITCallCompMaterial ON JITCallComponentUUID = _JITCallCompMaterial.JITCallComponentUUID  -- association [1..1]
LEFT OUTER JOIN C_JITInbCallCompRefText AS _JITCallReferenceText ON JITCallComponentUUID = _JITCallReferenceText.ParentDraftKey  -- association [1..*]
LEFT OUTER JOIN C_JITCallDocRefObjPg AS _JITCallDocRef ON InternalJITCallNumber = _JITCallDocRef.InternalJITCallNumber  -- association [1..*]
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 [1..*]
LEFT OUTER JOIN C_JITCallCompGrpActionLog AS _JITCompGrpActionLog ON JITCallCompGrpUUID = _JITCompGrpActionLog.JITCallCompGrpUUID  -- association [1..*]
LEFT OUTER JOIN C_JITCallComponentMatlDocRef AS _JITCallComponentMatlDocRef ON JITCallComponentUUID = _JITCallComponentMatlDocRef.JITCallComponentUUID  -- association [0..*]
LEFT OUTER JOIN C_JITInbCallEDIMsgReference AS _JITInbCallEDIMsgReference ON externaljitcallnumber = _JITInbCallEDIMsgReference.ExternalJITCallNumber AND extcompgrpnumber = _JITInbCallEDIMsgReference.ExtCompGrpNumber  -- association [0..*]
LEFT OUTER JOIN C_JITInbCompGrpHndlgUnitRef AS _JITInbCompGrpHndlgUnitRef ON JITCallCompGrpUUID = _JITInbCompGrpHndlgUnitRef.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITInbCallDeliveryDocRef AS _JITInbCallDeliveryDocRef ON InternalJITCallNumber = _JITInbCallDeliveryDocRef.InternalJITCallNumber AND CompGrpNumber = _JITInbCallDeliveryDocRef.CompGrpNumber  -- association [0..*]
LEFT OUTER JOIN I_JITCompGrpEnhanced AS _JITCallCompGrpEnhanced ON JITCallCompGrpUUID = _JITCallCompGrpEnhanced.JITCallCompGrpUUID  -- association [0..1]
LEFT OUTER JOIN C_JITInbCallFwdngCompRef AS _JITInbCallFwdngCompRef ON JITCallComponentUUID = _JITInbCallFwdngCompRef.ReferenceJITComponentUUID  -- association [0..*]
;