C_JITCallComponentGroup

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_JITCallComponentGroup.
-- 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_JITCallComponentGroup AS
SELECT
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITHeaderUUID,
  JITDelivSqncGrpUUID,
  _JITSupplyControlHeader.SupplyAreaUUID AS SupplyAreaUUID,
  SupplyControlUUID,
  _JITInboundCall.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITInboundCall.ShipToParty AS ShipToParty,
  JITIntProcessingStatus,
  _JITInternalStatus._Text[1:Language = $session.system_language].JITInternalStatusText AS JITInternalStatusText,
  CompGrpMatl,
  _ProductCompGrp._Text[1: Language=$session.system_language].ProductName AS ProductName,
  RequirementDateTime,
  Plant,
  _Plant.PlantName AS PlantName,
  _JITInboundCall.SalesOrganization AS SalesOrganization,
  ShippingPoint,
  SupplyControlID,
  _JITSupplyControlHeader._Description[1:Language=$session.system_language].SupplyControlDesc AS SupplyControlDesc,
  CustSupplyArea,
  _JITSupplyControlHeader._JITCustomerSupplyArea._JITCustomerSupplyAreaDesc[1: Language=$session.system_language].SupplyAreaDesc AS SupplyAreaDesc,
  UnloadingPointName,
  JITActionCtrl,
  CustAssemblyLoc,
  DeliveryCreationDate,
  JITExtSequenceNumber,
  JITExtStatusAtSupplier,
  _SupplierExtStatus._JITExternalStatusText[1: Language=$session.system_language].JITExternalStatusText AS JITExternalStatusText,
  ExtCompGrpNumber,
  _JITInboundCall.JITCallType AS JITCallType,
  _JITInboundCall._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  _JITInboundCall.JITLifecycleStatus AS JITLifecycleStatus,
  _JITInboundCall._JITLifecycleStatus._Text[1:Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  NumberOfItems,
  _JITPckgGrpItemRef._JITPckgGrpItem._JITPckgGrpHeader.JITPckgGrpID AS JITPckgGrpID,
  _JITPckgGrpItemRef._JITPckgGrpItem._JITPckgGrpHeader.JITPackageLevel AS JITPackageLevel,
  _JITPckgGrpItemRef._JITPckgGrpItem._JITPckgGrpHeader.JITAltvHndlgUnitID AS JITAltvHndlgUnitID,
  _JITPckgGrpItemRef._JITPckgGrpItem.JITPckgGrpCellNumber AS JITPckgGrpCellNumber,
  JITSuperPckgGrpUUID,
  _JITPckgGrpHeader.JITPckgGrpID AS JITSuperPckgGrpID,
  _JITPckgGrpHeader.JITAltvHndlgUnitID AS JITAltvHndlgUnitIDShrt,
  JITSuperPckgGrpUUID AS JITPckgGrpUUID,
  _ProductionVersion.ProductionLine AS ProductionLine,
  PlannedShippingDateTime,
  cast(JITExtStatusUpdtdOn as tzntstmps) AS JITExtStatusUpdtdOn,
  cast(JITIntStatusUpdtdOn as tzntstmps) AS JITIntStatusUpdtdOn,
  _JITInboundCall.SoldToParty AS SoldToParty,
  _JITInboundCall.VehicleIdentificationNumber AS VehicleIdentificationNumber,
  cast(_JITInboundCall.CreationDateTime as tzntstmps) AS CreationDateTime,
  _JITInboundCall.LastChangedByUser AS LastChangedByUser,
  cast(_JITInboundCall.LastChangeDateTime as tzntstmps) AS LastChangeDateTime,
  _JITPckgGrpHeader.JITDelivSqncGrpID AS JITDelivSqncGrpID,
  _JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  _JITInboundCall.JITComponentIsReordered AS JITComponentIsReordered,
  _JITInboundCall.VehicleModel AS JITVehicleModel,
  _JITCompGrpEnhanced.HandlingUnitExternalID AS HandlingUnitExternalID,
  _JITCompGrpEnhanced.OutboundDelivery AS OutboundDelivery,
  _JITCompGrpEnhanced.Material AS Material,
  _JITCompGrpEnhanced.SerialNumber AS SerialNumber
FROM I_JITCallCompGroupCube
;