C_JITInbCallComponentGroupTP

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_JITInbCallComponentGroupTP.
-- 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_JITInbCallComponentGroupTP AS
SELECT
  JITCallCompGrpUUID,
  JITHeaderUUID,
  InternalJITCallNumber,
  JITCallComponentGrpItemNumber,
  CompGrpNumber,
  _JITInboundCallTP.ExternalJITCallNumber AS ExternalJITCallNumber,
  ExtCompGrpNumber,
  CompGrpMatl,
  CustCompGrpMatl,
  JITPredecessorCompGrpItmNmbr,
  CustSupplyArea,
  UnloadingPointName,
  CustAssemblyLoc,
  ShippingPoint,
  Plant,
  StorageLocation,
  ProductionVersion,
  SupplyControlID,
  SupplyControlUUID,
  JITActionCtrl,
  WarehouseNumber,
  JITExtSequenceNumber,
  JITFormattedSequenceNumber,
  JITDelivSqncGrpID,
  JITDelivSqncGrpUUID,
  RequestedQuantity,
  QuantityUnit,
  GrossWeight,
  NetWeight,
  WeightUnit,
  _ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
  _JITSupplyControlHeader._JITCustomerSupplyArea._JITCustomerSupplyAreaDesc[1:Language = $session.system_language].SupplyAreaDesc AS SupplyAreaDesc,
  _Plant[1:Language = $session.system_language].PlantName AS PlantName,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _JITSupplyControlHeader._Description[1:Language=$session.system_language].SupplyControlDesc AS SupplyControlDesc,
  _JITSupplyControlHeader._JITActionCtrl._Text[1:Language=$session.system_language].JITActionCtrlText AS JITActionCtrlText,
  _JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  _JITSupplyControlHeader._JITProdnConfirmationControl._Text[1: Language=$session.system_language].JITProdnConfControlText AS JITProdnConfControlText,
  TransmittedExtStatusByMfr,
  JITExtStatusAtSupplier,
  JITIntProcessingStatus,
  _SupplierExtStatus._JITExternalStatusText[1: Language=$session.system_language].JITExternalStatusText AS JITExternalStatusText,
  _JITInternalStatus.JITIntProcessingStatusType AS JITIntProcessingStatusType,
  _JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  DeliveryStatus,
  GoodsMovementStatus,
  JITCompGrpDocPckgGrpSts,
  JITCompGrpDocRelToProdnSts,
  JITCompGrpDocConfToProdnSts,
  JITPackingConfirmationStatus,
  HandlingUnitStatus,
  JITCallCompGrpCancellationSts,
  JITCallForwardingStatus,
  _JITDeliveryStatus._Text[1:Language = $session.system_language].DeliveryStatusText AS DeliveryStatusText,
  _JITGoodsMovementStatus._Text[1:Language = $session.system_language].GoodsMovementStatusDesc AS GoodsMovementStatusDesc,
  _JITPackingGrpCreationStatus._Text[1:Language = $session.system_language].JITPackingGroupCreationStsText AS JITPackingGroupCreationStsText,
  _JITReleaseToProductionStatus._Text[1:Language = $session.system_language].JITReleaseToProductionStsText AS JITReleaseToProductionStsText,
  _JITProdnConfirmationStatus._Text[1:Language = $session.system_language].JITProdnConfirmationStatusText AS JITProdnConfirmationStatusText,
  _JITPackingConfStatus._Text[1:Language = $session.system_language].JITPackingConfirmationStsTxt AS JITPackingConfirmationStsTxt,
  _JITHndlgUnitCrtnStatus._Text[1:Language = $session.system_language].HandlingUnitStatusText AS HandlingUnitStatusText,
  _JITCallCompGrpCanclnStatus._Text[1:Language = $session.system_language].JITCallCompGrpCanclnStsText AS JITCallCompGrpCanclnStsText,
  _JITCallForwardingStatus._Text[1:Language=$session.system_language].JITCallForwardingStatusText AS JITCallForwardingStatusText,
  JITExtStatusUpdtdOn,
  JITIntStatusUpdtdOn,
  RequirementDateTime,
  PlannedShippingDateTime,
  ActualShippingDateTime,
  LocalLastChangeDateTime,
  MaterialAvailabilityDate,
  MaterialAvailabilityTime,
  RequestedDeliveryDate,
  RequestedDeliveryTime,
  DeliveryCreationDate,
  DeliveryCreationTime,
  ProductionStartDate,
  JITProductionStartTime,
  ProductionEndDate,
  _JITInboundCallTP.JITCallType AS JITCallType,
  _JITInboundCallTP.ShipToParty AS ShipToParty,
  _JITInboundCallTP.SoldToParty AS SoldToParty,
  _JITInboundCallTP.JITComponentIsReordered AS JITComponentIsReordered,
  _JITInboundCallTP._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  _JITInboundCallTP._JITComponentIsReordered._Text[1:Language = $session.system_language].JITComponentIsReorderedText AS JITComponentIsReorderedText,
  _JITSupplyControlHeader.JITUnderDeliveryToleranceInPct AS JITUnderDeliveryToleranceInPct,
  _JITSupplyControlHeader.JITOverDeliveryToleranceInPct AS JITOverDeliveryToleranceInPct,
  _JITSupplyControlHeader.JITUnlimitedOverDelivIsAllowed AS JITUnlimitedOverDelivIsAllowed,
  _JITSupplyControlHeader.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  _JITSupplyControlHeader._JITPartialDelivery._Text [1: Language = $session.system_language ].PartialDeliveryIsAllowedText AS PartialDeliveryIsAllowedText,
  _ProductionVersion.ProductionLine AS ProductionLine,
  _ProductionVersion._ProductionLine._WorkCenterTextBySemanticKey[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  _ProductionVersion.ReceivingStorageLocation AS ReceivingStorageLocation,
  _ProductionVersion.IssuingStorageLocation AS IssuingStorageLocation,
  _ProductionVersion._ReceivingStorageLocation.StorageLocationName AS ReceivingStorageLocationName,
  _ProductionVersion._IssuingStorageLocation.StorageLocationName AS IssuingStorageLocationName,
  _JITPckgGrpHeader.JITPckgGrpID AS JITPckgGrpID,
  _JITPckgGrpHeader.JITAltvHndlgUnitID AS JITAltvHndlgUnitID,
  _JITPackingGroupHistlRefTP._JITPackingGroupTP.JITPckgGrpID AS JITHistlLeafPckgGrpID,
  _JITPackingGroupHistlRefTP._JITPackingGroupTP.JITAltvHndlgUnitID AS JITHistlLeafAltvHndlgUnitID,
  _JITPckgGrpItemRef._JITPckgGrpItem._JITPckgGrpHeader.JITPckgGrpID AS JITLeafPckgGrpID,
  _JITPckgGrpItemRef._JITPckgGrpItem._JITPckgGrpHeader.JITAltvHndlgUnitID AS JITLeafAltvHndlgUnitID,
  _JITPckgGrpItemRef._JITPckgGrpItem.JITPckgGrpCellNumber AS JITPckgGrpCellNumber,
  _JITPckgGrpItemRef._JITPckgGrpItem._JITPckgGrpHeader._JITPckgGrpDef._Product._Text[1: Language = $session.system_language].ProductName AS PackagingMaterialName,
  virtual JITCallIsSequenced : boolean AS virtualJITCallIsSequencedboolean,
  virtual JITCallIsSummarized : boolean AS virtualJITCallIsSummarizedboolean,
  virtual JITInternalStatusCriticality : abap.int1 AS int1,
  virtual JITRepetitiveMfgAllwdText : abap.char(100) AS char100
FROM R_JITInbCallComponentGroupTP
LEFT OUTER JOIN C_JITInbCallDeliveryDocRef AS _JITInbCallDeliveryDocRef ON InternalJITCallNumber = _JITInbCallDeliveryDocRef.InternalJITCallNumber AND CompGrpNumber = _JITInbCallDeliveryDocRef.CompGrpNumber  -- association [0..*]
LEFT OUTER JOIN C_JITCallHndlgUnitForObjPg AS _JITCallHndlgUnitForObjPg ON JITCallCompGrpUUID = _JITCallHndlgUnitForObjPg.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITInbCompGrpHndlgUnitRef AS _JITInbCompGrpHndlgUnitRef ON JITCallCompGrpUUID = _JITInbCompGrpHndlgUnitRef.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITCallComponent AS _JITCallComponent ON JITCallCompGrpUUID = _JITCallComponent.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITInbCallFwdngCompGrpRef AS _JITInbCallFwdngCompGrpRef ON JITCallCompGrpUUID = _JITInbCallFwdngCompGrpRef.ReferenceJITComponentGroupUUID  -- association [0..*]
;