C_JITPckgGrpDefCellTP

DDL: C_JITPCKGGRPDEFCELLTP Type: view_entity CONSUMPTION Package: NJIT_APP_PACKG_GRP_SPEC
21 Fields 1 Data Sources 4 Associations

Consumption View for Package Group Cell

C_JITPckgGrpDefCellTP is a Consumption CDS View that provides data about "Consumption View for Package Group Cell" in SAP S/4HANA. It reads from 1 data source (I_JITPckgGrpDefCellTP) and exposes 21 fields with key field JITPckgGrpCellUUID. It has 4 associations to related views. Part of development package NJIT_APP_PACKG_GRP_SPEC.

Data Sources (1)

SourceAliasJoin Type
I_JITPckgGrpDefCellTP I_JITPckgGrpDefCellTP from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_JITPckgGrpDefTP _JITPackageGroupDefinitionTP $projection.JITPckgGrpDefUUID = _JITPackageGroupDefinitionTP.JITPckgGrpDefUUID
[0..*] C_JITPckgGrpDefSlotGrpCntntTP _JITPckgGrpDefSlotGrpCntntTP $projection.JITPckgGrpCellUUID = _JITPckgGrpDefSlotGrpCntntTP.JITPckgGrpCellUUID
[1..1] C_JITMaterialValueHelp _JITMaterialValueHelp $projection.CompGrpMatl = _JITMaterialValueHelp.Product
[1..1] I_Material _Material $projection.CompGrpMatl = _Material.Material

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Analytics.technicalName CJITPGDCELLTP view
EndUserText.label Consumption View for Package Group Cell 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.representativeKey JITPckgGrpCellUUID view
Search.searchable true view
UI.headerInfo.typeName Slot Group Content view
UI.headerInfo.title.value JITPckgRowSqnc view
VDM.viewType #CONSUMPTION view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY JITPckgGrpCellUUID JITPckgGrpCellUUID NodeID
JITPckgGrpDefUUID JITPckgGrpDefUUID NodeID
JITPckg1stCellID JITPckg1stCellID First Slot ID
JITPckgLastCellID JITPckgLastCellID Last Slot ID
JITPckgCellIncrmtValue JITPckgCellIncrmtValue Increment
JITPckgRowSqnc JITPckgRowSqnc Slot ID
JITPckgQtyPerCell JITPckgQtyPerCell Quantity per Slot
QuantityUnit QuantityUnit Quantity Unit
JITPckgCntntType JITPckgCntntType Content Type
JITPckgCntntTypeText
JITPckgGrpDefID JITPckgGrpDefID Packing Group Specification ID
CompGrpMatl CompGrpMatl Material
MaterialName Component Group Material Description
JITIntPackgSortSqnc JITIntPackgSortSqnc Packing Sort Sequence
JITIntPackgSortSqncText
JITPckgSortSqnc JITPckgSortSqnc Withdrawal Sort Sequence
JITPckgSortSqncText
_JITPackageGroupDefinitionTP _JITPackageGroupDefinitionTP
_JITPckgGrpDefSlotGrpCntntTP _JITPckgGrpDefSlotGrpCntntTP
_QuantityUnitOfMeasure _QuantityUnitOfMeasure
_Material _Material

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_JITPckgGrpDefCellTP.
-- 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_JITPckgGrpDefCellTP AS
SELECT
  JITPckgGrpCellUUID,
  JITPckgGrpDefUUID,
  JITPckg1stCellID,
  JITPckgLastCellID,
  JITPckgCellIncrmtValue,
  JITPckgRowSqnc,
  JITPckgQtyPerCell,
  QuantityUnit,
  JITPckgCntntType,
  _JITPackageGroupContentType._Text[1: Language = $session.system_language].JITPckgCntntTypeText AS JITPckgCntntTypeText,
  JITPckgGrpDefID,
  CompGrpMatl,
  _Material._Text[1: Language= $session.system_language].MaterialName AS MaterialName,
  JITIntPackgSortSqnc,
  _JITPackageCellGrpSortSequence._Text[1: Language= $session.system_language].JITPckgSortSqncText AS JITIntPackgSortSqncText,
  JITPckgSortSqnc,
  _JITPackageCellGrpSortSequence._Text[1: Language= $session.system_language].JITPckgSortSqncText AS JITPckgSortSqncText
FROM I_JITPckgGrpDefCellTP
LEFT OUTER JOIN C_JITPckgGrpDefTP AS _JITPackageGroupDefinitionTP ON JITPckgGrpDefUUID = _JITPackageGroupDefinitionTP.JITPckgGrpDefUUID  -- association [1..1]
LEFT OUTER JOIN C_JITPckgGrpDefSlotGrpCntntTP AS _JITPckgGrpDefSlotGrpCntntTP ON JITPckgGrpCellUUID = _JITPckgGrpDefSlotGrpCntntTP.JITPckgGrpCellUUID  -- association [0..*]
LEFT OUTER JOIN C_JITMaterialValueHelp AS _JITMaterialValueHelp ON CompGrpMatl = _JITMaterialValueHelp.Product  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON CompGrpMatl = _Material.Material  -- association [1..1]
;

Learn More