C_JITPckgGrpDefTP

DDL: C_JITPCKGGRPDEFTP Type: view_entity CONSUMPTION Package: NJIT_APP_PACKG_GRP_SPEC
39 Fields 1 Data Sources 5 Associations

Package Group Def data using draft

C_JITPckgGrpDefTP is a Consumption CDS View that provides data about "Package Group Def data using draft" in SAP S/4HANA. It reads from 1 data source (I_JITPckgGrpDefTP) and exposes 39 fields with key field JITPckgGrpDefUUID. It has 5 associations to related views. Part of development package NJIT_APP_PACKG_GRP_SPEC.

Data Sources (1)

SourceAliasJoin Type
I_JITPckgGrpDefTP I_JITPckgGrpDefTP from

Associations (5)

CardinalityTargetAliasCondition
[0..*] C_JITPckgGrpDefCellTP _JITPackageGroupDefCellTP $projection.JITPckgGrpDefUUID = _JITPackageGroupDefCellTP.JITPckgGrpDefUUID
[0..*] C_JITPckgGrpDefHierTP _JITPackageGroupDefHierarchyTP $projection.JITPckgGrpDefUUID = _JITPackageGroupDefHierarchyTP.JITPckgGrpDefUUID
[0..*] C_JITPckgGrpDefTxtTP _JITPackageGroupDefDescTP $projection.JITPckgGrpDefUUID = _JITPackageGroupDefDescTP.JITPckgGrpDefUUID
[0..1] C_JITPckgGrpDefTxtTP _JITPackageGroupDefCurDescTP $projection.JITPckgGrpDefUUID = _JITPackageGroupDefCurDescTP.JITPckgGrpDefUUID and _JITPackageGroupDefCurDescTP.Language = $session.system_language
[0..*] C_JITPckgGrpDefSlotGrpCntntTP _JITPckgGrpDefSlotGrpCntntTP $projection.JITPckgGrpDefUUID = _JITPckgGrpDefSlotGrpCntntTP.JITPckgGrpDefUUID

Annotations (20)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Analytics.technicalName CJITPGDEFTP view
EndUserText.label Package Group Def data using draft view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.representativeKey JITPckgGrpDefUUID view
Search.searchable true view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Just-In-Time Packing Group Specification view
UI.headerInfo.typeNamePlural Packing Group Specifications view
UI.headerInfo.title.value JITPckgGrpDefID view
UI.headerInfo.description.value JITPckgGrpDesc view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY JITPckgGrpDefUUID JITPckgGrpDefUUID NodeID
JITPckgGrpDefID JITPckgGrpDefID Packing Group Specification
JITPckgGrpDesc _JITPackageGroupDefCurDescTP JITPckgGrpDesc Packing Group Specification Description
JITPckgRackSize JITPckgRackSize Total Number of Slots
NumberRangeInterval NumberRangeInterval Package Specification Group
PackagingMaterial PackagingMaterial Packaging Material
ProductName Packaging Material Description
JITPckgLoadCarr JITPckgLoadCarr Load Carrier
StatusCriticality StatusCriticality
JITPckgGrpDefStatus JITPckgGrpDefStatus Status
JITPckgGrpDefStatusText Status
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _CreatedByUser FullName Name
CreatedByUserFirstName _CreatedByUser FirstName First Name
CreatedByUserLastName _CreatedByUser LastName Last Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _ChangedByUser FirstName First Name
FirstName _ChangedByUser FirstName First Name
LastName _ChangedByUser LastName Last Name
CompGrpMatl CompGrpMatl Component Group Material
PckgGrpDefReorder PckgGrpDefReorder Reorder Packing Group Specification
PckgGrpDefReorderText
JITHandlingUnitRelevance JITHandlingUnitRelevance Relevant for HU
JITHandlingUnitRelevanceText
ProcessingStatus
JITPckgGrpDefIsNested JITPckgGrpDefIsNested
_ChangedByUser _ChangedByUser
_CreatedByUser _CreatedByUser
_JITLoadCarrier _JITLoadCarrier
_JITPackageGroupDefCellTP _JITPackageGroupDefCellTP
_JITPackageGroupDefHierarchyTP _JITPackageGroupDefHierarchyTP
_JITPackageGroupDefDescTP _JITPackageGroupDefDescTP
_JITPckgGrpDefSlotGrpCntntTP _JITPckgGrpDefSlotGrpCntntTP
_PackageGroupDefinitionText _PackageGroupDefinitionText
_JITPackageGroupDefCurDescTP _JITPackageGroupDefCurDescTP
_JITPckgGrpDefReorder _JITPckgGrpDefReorder
_JITHandlingUnitRelevance _JITHandlingUnitRelevance

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.

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..*]
;

Learn More