C_JITPckgGrpDefTP

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_JITPckgGrpDefTP.
-- 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.
-- SQL view name: CJITPGDEFTP

CREATE VIEW C_JITPckgGrpDefTP AS
SELECT
  JITPckgGrpDefUUID,
  JITPckgGrpDefID,
  _JITPackageGroupDefCurDescTP.JITPckgGrpDesc AS JITPckgGrpDesc,
  JITPckgRackSize,
  NumberRangeInterval,
  PackagingMaterial,
  _Product._Text[1: Language = $session.system_language].ProductName AS ProductName,
  JITPckgLoadCarr,
  StatusCriticality,
  JITPckgGrpDefStatus,
  _JITPckgGrpDefStatus._Text[1:Language = $session.system_language].JITPckgGrpDefStatusText AS JITPckgGrpDefStatusText,
  CreationDateTime,
  CreatedByUser,
  _CreatedByUser.FullName AS CreatedByUserDescription,
  _CreatedByUser.FirstName AS CreatedByUserFirstName,
  _CreatedByUser.LastName AS CreatedByUserLastName,
  LastChangeDateTime,
  LastChangedByUser,
  _ChangedByUser.FirstName AS LastChangedByUserDescription,
  _ChangedByUser.FirstName AS FirstName,
  _ChangedByUser.LastName AS LastName,
  CompGrpMatl,
  PckgGrpDefReorder,
  _JITPckgGrpDefReorder._Text[1:Language = $session.system_language].PckgGrpDefReorderText AS PckgGrpDefReorderText,
  JITHandlingUnitRelevance,
  _JITHandlingUnitRelevance._Text[1:Language = $session.system_language].JITHandlingUnitRelevanceText AS JITHandlingUnitRelevanceText,
  cast('' as char1) AS ProcessingStatus,
  JITPckgGrpDefIsNested
FROM I_JITPckgGrpDefTP
LEFT OUTER JOIN C_JITPckgGrpDefCellTP AS _JITPackageGroupDefCellTP ON JITPckgGrpDefUUID = _JITPackageGroupDefCellTP.JITPckgGrpDefUUID  -- association [0..*]
LEFT OUTER JOIN C_JITPckgGrpDefHierTP AS _JITPackageGroupDefHierarchyTP ON JITPckgGrpDefUUID = _JITPackageGroupDefHierarchyTP.JITPckgGrpDefUUID  -- association [0..*]
LEFT OUTER JOIN C_JITPckgGrpDefTxtTP AS _JITPackageGroupDefDescTP ON JITPckgGrpDefUUID = _JITPackageGroupDefDescTP.JITPckgGrpDefUUID  -- association [0..*]
LEFT OUTER JOIN C_JITPckgGrpDefTxtTP AS _JITPackageGroupDefCurDescTP ON JITPckgGrpDefUUID = _JITPackageGroupDefCurDescTP.JITPckgGrpDefUUID AND _JITPackageGroupDefCurDescTP.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_JITPckgGrpDefSlotGrpCntntTP AS _JITPckgGrpDefSlotGrpCntntTP ON JITPckgGrpDefUUID = _JITPckgGrpDefSlotGrpCntntTP.JITPckgGrpDefUUID  -- association [0..*]
;