I_JITScanPackingGroupSlot

DDL: I_JITSCANPACKINGGROUPSLOT Type: view_entity TRANSACTIONAL
27 Fields 4 Associations

Packing group slot to be scanned

I_JITScanPackingGroupSlot is a Transactional CDS View that provides data about "Packing group slot to be scanned" in SAP S/4HANA. It has 4 associations to related views.

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_JITScanPackingGroup _ScanPackingGroup $projection.JITPckgGrpUUID = _ScanPackingGroup.JITPckgGrpUUID
[0..1] I_JITScanPackingGroupSlotMatl _ScanPackingGroupSlotMatl $projection.JITCallCompGrpUUID = _ScanPackingGroupSlotMatl.JITCallCompGrpUUID and $projection.Material = _ScanPackingGroupSlotMatl.Material
[0..1] I_JITPckgGrpCntntType _JITPckgGrpCntntType $projection.JITPckgCntntType = _JITPckgGrpCntntType.JITPckgCntntType
[0..*] I_JITInbCallCompSerialNumber _JITSerialNumbers $projection.InternalJITCallNumber = _JITSerialNumbers.InternalJITCallNumber and $projection.CompGrpNumber = _JITSerialNumbers.CompGrpNumber and $projection.Material = _JITSerialNumbers.Material

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Packing group slot to be scanned view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY JITPckgGrpItemRefUUID _PackingGroupItem JITPckgGrpItemRefUUID NodeID
KEY Material _ScanPackingGroupSlotMatl Material Vehicle Model
JITPckgGrpItemUUID _PackingGroupItem JITPckgGrpItemUUID
JITPckgGrpUUID _PackingGroupItem JITPckgGrpUUID NodeID
JITPckgGrpID
JITPckgGrpCellNumber
JITPckgCntntType _PackingGroupItem JITPckgCntntType Content Type
char40asJITPckgGrpContentID
CompGrpMatl _JITCallCompGroup CompGrpMatl Comp. Group Matl.
JITCallCompGrpUUID _JITCallCompGroup JITCallCompGrpUUID NodeID
InternalJITCallNumber _JITCallCompGroup InternalJITCallNumber JIT Call Number
JITExtSequenceNumber _JITCallCompGroup JITExtSequenceNumber Ext.Seq. Number
CompGrpNumber _JITCallCompGroup CompGrpNumber Component Group No.
AssemblyLocation _JITCallCompGroup CustAssemblyLoc Assembly Location
VehicleModel
OutboundDelivery
JITSubPckgGrpUUID _PackingGroupItem ReferenceDocumentUUID NodeID
JITSubPckgGrpID
_JITPackingGroupItemTP _PackingGroupItem _JITPackingGroupItemTP
JITAltvHndlgUnitID _ScanPackingGroup JITAltvHndlgUnitID Alt. PG ID Short
ExternalJITCallNumber
_JITSerialNumbers _JITSerialNumbers
_JITCallCompGroupBasic _PackingGroupItem _JITCallCompGroupBasic
_JITSubPckgGrpHeader _PackingGroupItem _JITSubPckgGrpHeader
_ScanPackingGroup _ScanPackingGroup
_ScanPackingGroupSlotMatl _ScanPackingGroupSlotMatl
_JITPckgGrpCntntType _JITPckgGrpCntntType

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_JITScanPackingGroupSlot.
-- 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 I_JITScanPackingGroupSlot AS
SELECT
  _PackingGroupItem.JITPckgGrpItemRefUUID AS JITPckgGrpItemRefUUID,
  _ScanPackingGroupSlotMatl.Material AS Material,
  _PackingGroupItem.JITPckgGrpItemUUID AS JITPckgGrpItemUUID,
  _PackingGroupItem.JITPckgGrpUUID AS JITPckgGrpUUID,
  _PackingGroupItem._JITPckgGrpHeader.JITPckgGrpID AS JITPckgGrpID,
  _PackingGroupItem._JITPackingGroupItemTP.JITPckgGrpCellNumber AS JITPckgGrpCellNumber,
  _PackingGroupItem.JITPckgCntntType AS JITPckgCntntType,
  cast( case _PackingGroupItem.JITPckgCntntType when '0' then _PackingGroupItem._JITSubPckgGrpHeader.JITAltvHndlgUnitID else _JITCallCompGroup.CompGrpMatl end as abap.char(40)) as JITPckgGrpContentID AS char40asJITPckgGrpContentID,
  _JITCallCompGroup.CompGrpMatl AS CompGrpMatl,
  _JITCallCompGroup.JITCallCompGrpUUID AS JITCallCompGrpUUID,
  _JITCallCompGroup.InternalJITCallNumber AS InternalJITCallNumber,
  _JITCallCompGroup.JITExtSequenceNumber AS JITExtSequenceNumber,
  _JITCallCompGroup.CompGrpNumber AS CompGrpNumber,
  _JITCallCompGroup.CustAssemblyLoc AS AssemblyLocation,
  _JITCallCompGroup._JITCallHeaderBasic.VehicleModel AS VehicleModel,
  _JITCallCompGroup._JITPckgGrpItemRef._JITPckgGrpHeader._JITPckgGrpDeliveryRef.OutboundDelivery AS OutboundDelivery,
  _PackingGroupItem.ReferenceDocumentUUID AS JITSubPckgGrpUUID,
  _PackingGroupItem._JITSubPckgGrpHeader.JITPckgGrpID AS JITSubPckgGrpID,
  _PackingGroupItem._JITPackingGroupItemTP AS _JITPackingGroupItemTP,
  _ScanPackingGroup.JITAltvHndlgUnitID AS JITAltvHndlgUnitID,
  _JITCallCompGroup._JITCallHeaderBasic.ExternalJITCallNumber AS ExternalJITCallNumber,
  _PackingGroupItem._JITCallCompGroupBasic AS _JITCallCompGroupBasic,
  _PackingGroupItem._JITSubPckgGrpHeader AS _JITSubPckgGrpHeader
LEFT OUTER JOIN I_JITScanPackingGroup AS _ScanPackingGroup ON JITPckgGrpUUID = _ScanPackingGroup.JITPckgGrpUUID  -- association [1..1]
LEFT OUTER JOIN I_JITScanPackingGroupSlotMatl AS _ScanPackingGroupSlotMatl ON JITCallCompGrpUUID = _ScanPackingGroupSlotMatl.JITCallCompGrpUUID AND Material = _ScanPackingGroupSlotMatl.Material  -- association [0..1]
LEFT OUTER JOIN I_JITPckgGrpCntntType AS _JITPckgGrpCntntType ON JITPckgCntntType = _JITPckgGrpCntntType.JITPckgCntntType  -- association [0..1]
LEFT OUTER JOIN I_JITInbCallCompSerialNumber AS _JITSerialNumbers ON InternalJITCallNumber = _JITSerialNumbers.InternalJITCallNumber AND CompGrpNumber = _JITSerialNumbers.CompGrpNumber AND Material = _JITSerialNumbers.Material  -- association [0..*]
;

Learn More