C_JITPackageGroup

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_JITPackageGroup.
-- 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_JITPackageGroup AS
SELECT
  JITPckgGrpUUID,
  JITPckgGrpDefUUID,
  JITPckgGrpID,
  JITAltvHndlgUnitID,
  JITPackingGroupIsNested,
  ShipToParty,
  JITPckgGrpStatus,
  _JITPckgGrpStatus._Text[1: Language = $session.system_language].JITPckgGrpStatusTxt AS JITPckgGrpStatusTxt,
  CustSupplyArea,
  cast('' as njit_pckg_grp_packing_stat preserving type ) AS JITPackingStatus,
  HandlingUnitStatus,
  CustAssemblyLoc,
  ShippingPoint,
  _ShippingPoint._Text[1: Language=$session.system_language].ShippingPointName AS ShippingPointName,
  UnloadingPointName,
  RepetitiveManufacturingIsAllwd,
  Plant,
  JITComponentIsReordered,
  concat_with_space( 'Packing Group ID:', ltrim(JITPckgGrpID,'0'), 3 ) AS JITPckgGrpDesc,
  JITPackageLevel,
  MaterialAvailabilityDateTime,
  PlannedShippingDateTime,
  RequirementDateTime,
  JITExtSequenceNumberFrom,
  JITExtSequenceNumberTo,
  JITFormattedSequenceNmbrFrom,
  JITFormattedSequenceNmbrTo,
  JITExtStatusUpdtdOn,
  JITIntStatusUpdtdOn,
  cast( case when _JITPckgGrpCnsmpnStsCnsldtd.StatusCriticality = 100 then 3 when ( _JITPckgGrpCnsmpnStsCnsldtd.StatusCriticality > 50 and _JITPckgGrpCnsmpnStsCnsldtd.StatusCriticality < 100 ) then 2 else 1 end as abap.char(3)) as JITLifeCycleStatusCriticality AS char3asJITLifeCycleStatusCriticality,
  StorageLocation,
  JITDelivSqncGrpUUID,
  JITDelivSqncGrpID,
  JITArchivingStatus,
  ' ' AS StorageLocationName,
  cast('' as hrobjid) AS RespyMgmtTeamID,
  cast('0000000000' as abap.numc( 10 )) AS TotalNumberOfPackages,
  cast('' as njit_ext_call_num ) AS ExternalJITCallNumber,
  cast('' as njit_int_stat ) AS JITIntProcessingStatus,
  cast('' as njit_comp_grp_mat ) AS CompGrpMatl,
  cast('' as pph_arbpl ) AS ProductionLine,
  cast('' as njit_ext_seqnr ) AS JITExtSequenceNumber,
  cast('' as njit_cust_comp_grp_mat ) AS CustCompGrpMatl,
  cast( '' as njit_ext_comp_grp_num ) AS ExtCompGrpNumber,
  _JITPckgGrpCnsmpnStsCnsldtd.TotalNumberOfCellCount AS TotalNumberOfCellCount,
  _JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  _JITPackingGroupIsNested._Text[1: Language = $session.system_language].JITPackingGroupIsNestedText AS JITPackingGroupIsNestedText,
  cast(_JITPckgGrpHandlingUnitRef.BusinessTransactionDocument as exidv) AS HandlingUnitExternalID,
  _JITPckgGrpHandlingUnitRef.BusinessTransactionDocument AS BusinessTransactionDocument,
  cast ( _JITPckgGrpDeliveryRef.BusinessTransactionDocument as vbeln ) AS OutboundDelivery,
  cast( dats_tims_to_tstmp(_JITPckgGrpDeliveryRef._DeliveryDocument.CreationDate, _JITPckgGrpDeliveryRef._DeliveryDocument.CreationTime, abap_user_timezone($session.user, $session.client, 'NULL'), $session.client, 'NULL') as tzntstmps preserving type ) AS SalesDocumentCreationDateTime,
  _JITPckgGrpDeliveryRef._DeliveryDocument._OverallPickingStatus._Text[1: Language=$session.system_language].OverallPickingStatusDesc AS OverallPickingStatusDesc,
  _JITPckgGrpDeliveryRef._DeliveryDocument.PlannedGoodsIssueDate AS PlannedGoodsIssueDate,
  _JITPckgGrpDeliveryRef._DeliveryDocument._OverallGoodsMovementStatus._Text[1: Language=$session.system_language].OverallGoodsMovementStatusDesc AS OverallGoodsMovementStatusDesc,
  _JITPckgGrpDeliveryRef._DeliveryDocument._OverallDelivReltdBillgStatus._Text[1: Language=$session.system_language].OverallDelivReltdBillgStsDesc AS OverallDelivReltdBillgStsDesc,
  cast( dats_tims_to_tstmp(_JITPckgGrpDeliveryRef._DeliveryDocument.ActualGoodsMovementDate, _JITPckgGrpDeliveryRef._DeliveryDocument.ActualGoodsMovementTime, abap_user_timezone($session.user, $session.client, 'NULL'), $session.client, 'NULL') as tzntstmps preserving type ) AS ActualGoodsMovementDateTime,
  _JITPckgGrpDeliveryRef._DeliveryDocument.OverallPickingStatus AS OverallPickingStatus,
  _JITPckgGrpDef.JITPckgGrpDefID AS JITPckgGrpDefID,
  _JITPckgGrpDef.PackagingMaterial AS Product,
  _JITPckgGrpDef._Product._Text[1: Language = $session.system_language].ProductName AS ProductName,
  _JITPckgGrpDef.JITPckgRackSize AS JITPckgRackSize,
  _JITPckgGrpCnsmpnStsCnsldtd.TotalNumberOfCnsmdCellCnt AS TotalNumberOfCnsmdCellCnt,
  _JITPckgGrpCnsmpnStsCnsldtd.TotalNumberOfCnsmdCellCnt AS NmbrOfFilledCell,
  _JITHndlgUnitCrtnStatus._Text[1:Language = $session.system_language].HandlingUnitStatusText AS HandlingUnitStatusText,
  _JITPackingGroupUsageType._Text[1:Language = $session.system_language].JITPackingGroupUsageTypeText AS JITComponentIsReorderedText,
  _JITRepetitiveMfg._Text[1:Language = $session.system_language].RepetitiveMfgIsAllwdText AS JITRepetitiveMfgAllwdText,
  _JITArchivingStatus._Text[1:Language = $session.system_language].JITArchivingStatusText AS JITArchivingStatusText
FROM I_JITPckgGrpHeaderTP
LEFT OUTER JOIN C_JITPckgGrpItem AS _JITPckgGrpSlot ON JITPckgGrpUUID = _JITPckgGrpSlot.JITSubPckgGrpUUID  -- association [0..*]
LEFT OUTER JOIN I_JITPckgGrpDef AS _JITPckgGrpDef ON JITPckgGrpDefUUID = _JITPckgGrpDef.JITPckgGrpDefUUID  -- association [1..1]
LEFT OUTER JOIN C_JITPckgGrpDefTxtTP AS _JITPackageGroupDefDescTP ON JITPckgGrpDefUUID = _JITPackageGroupDefDescTP.JITPckgGrpDefUUID  -- association [0..*]
LEFT OUTER JOIN I_JITComponentIsReordered AS _JITComponentIsReordered ON JITComponentIsReordered = _JITComponentIsReordered.JITComponentIsReordered  -- association [0..1]
LEFT OUTER JOIN I_JITPackingGroupIsNested AS _JITPackingGroupIsNested ON JITPackingGroupIsNested = _JITPackingGroupIsNested.JITPackingGroupIsNested  -- association [0..1]
LEFT OUTER JOIN I_JITRepetitiveMfg AS _JITRepetitiveMfg ON RepetitiveManufacturingIsAllwd = _JITRepetitiveMfg.RepetitiveManufacturingIsAllwd  -- association [0..1]
LEFT OUTER JOIN I_JITPackingStatus AS _JITPackingStatus ON JITPackingStatus = _JITPackingStatus.JITPackingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITHndlgUnitCrtnStatus AS _JITHndlgUnitCrtnStatus ON HandlingUnitStatus = _JITHndlgUnitCrtnStatus.HandlingUnitStatus  -- association [0..1]
LEFT OUTER JOIN I_JITPlant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON ShipToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN C_JITPckgGrpActionLogTP AS _JITPackingGroupActionLogTP ON JITPckgGrpUUID = _JITPackingGroupActionLogTP.JITPckgGrpUUID  -- association [0..*]
LEFT OUTER JOIN I_JITPckgGrpDocRefBasic AS _JITPckgGrpHandlingUnitRef ON JITPckgGrpUUID = _JITPckgGrpHandlingUnitRef.JITPckgGrpUUID AND _JITPckgGrpHandlingUnitRef.BusinessTransactionDocType = 'X'  -- association [0..1]
LEFT OUTER JOIN I_JITPckgGrpDocRefBasic AS _JITPckgGrpDeliveryRef ON JITPckgGrpUUID = _JITPckgGrpDeliveryRef.JITPckgGrpUUID AND _JITPckgGrpDeliveryRef.BusinessTransactionDocType = 'J'  -- association [0..1]
LEFT OUTER JOIN I_JITCallCompGroupBasic AS _JITCallCompGroup ON JITPckgGrpUUID = _JITCallCompGroup.JITSuperPckgGrpUUID  -- association [0..*]
LEFT OUTER JOIN I_JITPackingGroupUsageType AS _JITPackingGroupUsageType ON JITComponentIsReordered = _JITPackingGroupUsageType.JITPackingGroupUsageType  -- association [0..1]
LEFT OUTER JOIN I_JITArchivingStatus AS _JITArchivingStatus ON JITArchivingStatus = _JITArchivingStatus.JITArchivingStatus  -- association [0..1]
;