I_JITPckgGrpDefCellTP

DDL: I_JITPCKGGRPDEFCELLTP SQL: IJITPGDCELLTP Type: view TRANSACTIONAL

Package Group Cell Transacl View

I_JITPckgGrpDefCellTP is a Transactional CDS View that provides data about "Package Group Cell Transacl View" in SAP S/4HANA. It reads from 1 data source (I_JITPckgGrpDefCell) and exposes 25 fields with key field JITPckgGrpCellUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITPckgGrpDefCell I_JITPckgGrpDefCell from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_JITPckgGrpDefTP _JITPackageGroupDefinitionTP $projection.JITPckgGrpDefUUID = _JITPackageGroupDefinitionTP.JITPckgGrpDefUUID
[0..*] I_JITPckgGrpDefSlotGrpCntntTP _JITPckgGrpDefSlotGrpCntntTP $projection.JITPckgGrpCellUUID = _JITPckgGrpDefSlotGrpCntntTP.JITPckgGrpCellUUID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IJITPGDCELLTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Package Group Cell Transacl View view
VDM.viewType #TRANSACTIONAL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.writeDraftPersistence NJIT_PGD_CELL_D view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.representativeKey JITPckgGrpCellUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY JITPckgGrpCellUUID JITPckgGrpCellUUID NodeID
JITPckgGrpDefUUID JITPckgGrpDefUUID NodeID
JITPackingDefSlotGroupID JITPackingDefSlotGroupID
JITPckg1stCellID JITPckg1stCellID First Slot ID
JITPckgLastCellID JITPckgLastCellID Last Slot ID
JITPckgCellIncrmtValue JITPckgCellIncrmtValue Increment
JITPckgRowSqnc JITPckgRowSqnc Row ID
JITPckgQtyPerCell JITPckgQtyPerCell Quantity per Slot
QuantityUnit QuantityUnit Unit of measure
JITPckgCntntType JITPckgCntntType Content Type
JITPckgGrpDefID JITPckgGrpDefID Package Grp Spec ID
CompGrpMatl CompGrpMatl Comp. Group Matl.
JITPackingGroupNumberOfSlots JITPackingGroupNumberOfSlots
JITPackingGroupNumberOfLayers JITPackingGroupNumberOfLayers
JITPackgGrpNmbrOfSlotsPerLayer JITPackgGrpNmbrOfSlotsPerLayer
JITPackgGrpSlotHasEmptyPcggMat JITPackgGrpSlotHasEmptyPcggMat
JITIntPackgSortSqnc JITIntPackgSortSqnc PckgSeqc
JITPckgSortSqnc JITPckgSortSqnc Sort Sequence
_JITIntPckgCellGrpSortSequence _JITIntPckgCellGrpSortSequence
_JITPackageCellGrpSortSequence _JITPackageCellGrpSortSequence
_JITPackageGroupContentType _JITPackageGroupContentType
_JITPackageGroupDefinitionTP _JITPackageGroupDefinitionTP
_JITPckgGrpDefSlotGrpCntntTP _JITPckgGrpDefSlotGrpCntntTP
_QuantityUnitOfMeasure _QuantityUnitOfMeasure
_JITChildPckgGrpDef _JITChildPckgGrpDef

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 I_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.
-- SQL view name: IJITPGDCELLTP

CREATE VIEW I_JITPckgGrpDefCellTP AS
SELECT
  JITPckgGrpCellUUID,
  JITPckgGrpDefUUID,
  JITPackingDefSlotGroupID,
  JITPckg1stCellID,
  JITPckgLastCellID,
  JITPckgCellIncrmtValue,
  JITPckgRowSqnc,
  JITPckgQtyPerCell,
  QuantityUnit,
  JITPckgCntntType,
  JITPckgGrpDefID,
  CompGrpMatl,
  JITPackingGroupNumberOfSlots,
  JITPackingGroupNumberOfLayers,
  JITPackgGrpNmbrOfSlotsPerLayer,
  JITPackgGrpSlotHasEmptyPcggMat,
  JITIntPackgSortSqnc,
  JITPckgSortSqnc
FROM I_JITPckgGrpDefCell
LEFT OUTER JOIN I_JITPckgGrpDefTP AS _JITPackageGroupDefinitionTP ON JITPckgGrpDefUUID = _JITPackageGroupDefinitionTP.JITPckgGrpDefUUID  -- association [1..1]
LEFT OUTER JOIN I_JITPckgGrpDefSlotGrpCntntTP AS _JITPckgGrpDefSlotGrpCntntTP ON JITPckgGrpCellUUID = _JITPckgGrpDefSlotGrpCntntTP.JITPckgGrpCellUUID  -- association [0..*]
;