C_JITPckgGrpItem

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_JITPckgGrpItem.
-- 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_JITPckgGrpItem AS
SELECT
  I_JITPckgGrpItemTP.JITPckgGrpItemUUID AS JITPckgGrpItemUUID,
  I_JITPckgGrpItemRefTP.JITPckgGrpItemRefUUID AS JITPckgGrpItemRefUUID,
  I_JITPckgGrpItemTP.JITPckgGrpUUID AS JITSubPckgGrpUUID,
  I_JITPckgGrpItemTP.JITIntPackgSqncNmbr AS JITIntPackgSqncNmbr,
  I_JITPckgGrpItemTP.JITPckgGrpCellNumber AS JITPckgGrpCellNumber,
  I_JITPckgGrpItemTP.JITPackingStatus AS JITPackingStatus,
  I_JITPckgGrpItemRefTP.ReferenceDocumentUUID AS ReferenceDocumentUUID,
  cast( '' as abap.char( 100 ) ) AS JITRefText,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic.JITCallCompGrpUUID AS JITCallCompGrpUUID,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic.JITDelivSqncGrpID AS JITDelivSqncGrpID,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic._JITDelivSqncGrpHeaderBasic.ExtJITDelivSqncGrpID AS ExtJITDelivSqncGrpID,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic._ProductionVersion.ProductionLine AS ProductionLine,
  I_JITPckgGrpItemRefTP.JITPckgCntntType AS JITPckgCntntType,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic.InternalJITCallNumber AS InternalJITCallNumber,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic.JITCompGrpDocConfToProdnSts AS JITCompGrpDocConfToProdnSts,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic.JITFormattedSequenceNumber AS JITFormattedSequenceNumber,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic._JITCallHeaderBasic.ExternalJITCallNumber AS ExternalJITCallNumber,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic._JITCallHeaderBasic.JITExtSequenceNumber AS JITExtSequenceNumber,
  I_JITPckgGrpItemRefTP._JITCallCompGroupBasic._JITCompGrpDocConfToProdnSts._ConfToProdnText[1:Language = $session.system_language].JITCompGrpDocConfToProdnStsTxt AS JITCompGrpDocConfToProdnStsTxt,
  cast( case I_JITPckgGrpItemRefTP.JITPckgCntntType when '0' then _JITSubPckgGrpHeaderTP.JITAltvHndlgUnitID else I_JITPckgGrpItemRefTP._JITCallCompGroupBasic.CompGrpMatl end as abap.char( 40 ) ) as CompGrpMatl AS char40asCompGrpMatl,
  I_JITPckgGrpItemRefTP._JITPckgGrpCntntType._Text[1:Language = $session.system_language].JITPckgCntntTypeText AS JITPckgCntntTypeText,
  case _JITPckgGrpHeaderTP.JITComponentIsReordered when 'X' then cast( '' as njit_pckg_grp_id ) when 'S' then _JITInbCallComponentGroupTP._JITPackingGroupHistlRefTP._JITSuperPackingGroupTP.JITPckgGrpID else _JITPackingGroupHistlRefTP._JITInbCallComponentGroupTP._JITPackingGroupTP.JITPckgGrpID end as JITPckgGrpID AS JITPckgGrpIDendasJITPckgGrpID,
  case _JITPckgGrpHeaderTP.JITComponentIsReordered when 'S' then _JITInbCallComponentGroupTP._JITPackingGroupHistlRefTP.JITSuperPckgGrpUUID else _JITPackingGroupHistlRefTP._JITInbCallComponentGroupTP.JITSuperPckgGrpUUID end as JITPckgGrpUUID AS JITSuperPckgGrpUUIDendasJITPckgGrpUUID,
  _JITPckgGrpHeaderTP.JITComponentIsReordered AS JITPackingGroupUsageType,
  _JITPackingStatus._Text[1:Language = $session.system_language].JITPackingStatusText AS JITPackingStatusText
FROM I_JITPckgGrpItemTP
LEFT OUTER JOIN I_JITPckgGrpHeaderTP AS _JITSubPckgGrpHeaderTP ON ReferenceDocumentUUID = _JITSubPckgGrpHeaderTP.JITPckgGrpUUID  -- association [1..1]
LEFT OUTER JOIN I_JITPckgGrpItemRefTP AS _JITPckgGrpItemRefTP ON JITPckgGrpItemUUID = _JITPckgGrpItemRefTP.JITPckgGrpItemUUID  -- association [0..1]
LEFT OUTER JOIN I_JITPackingStatus AS _JITPackingStatus ON JITPackingStatus = _JITPackingStatus.JITPackingStatus  -- association [0..1]
LEFT OUTER JOIN I_JITPckgGrpCntntType AS _JITPckgGrpCntntType ON JITPckgCntntType = _JITPckgGrpCntntType.JITPckgCntntType  -- association [0..1]
LEFT OUTER JOIN I_JITCallCompGroup AS _JITCallCompGroup ON ReferenceDocumentUUID = _JITCallCompGroup.JITCallCompGrpUUID  -- association [0..*]
LEFT OUTER JOIN I_JITPckgGrpHeaderTP AS _JITPckgGrpHeaderTP ON JITSubPckgGrpUUID = _JITPckgGrpHeaderTP.JITPckgGrpUUID  -- association [1..1]
LEFT OUTER JOIN R_JITPackingGroupHistlRefTP AS _JITPackingGroupHistlRefTP ON JITPckgGrpItemRefUUID = _JITPackingGroupHistlRefTP.JITPckgGrpItemRefUUID  -- association [0..1]
LEFT OUTER JOIN R_JITInbCallComponentGroupTP AS _JITInbCallComponentGroupTP ON ReferenceDocumentUUID = _JITInbCallComponentGroupTP.JITCallCompGrpUUID  -- association [0..1]
;