C_JITPackingGroupSlotsForScan

DDL: C_JITPACKINGGROUPSLOTSFORSCAN Type: view_entity CONSUMPTION Package: NJIT_APP_SCANNING

Slot Info of Packing Group being scanned

C_JITPackingGroupSlotsForScan is a Consumption CDS View that provides data about "Slot Info of Packing Group being scanned" in SAP S/4HANA. It reads from 1 data source (R_JITPackingGroupItemRefTP) and exposes 23 fields with key field JITPckgGrpItemRefUUID. It is exposed through 1 OData service (NJIT_UI_JITPACKINGGROUPFORSCAN). Part of development package NJIT_APP_SCANNING.

Data Sources (1)

SourceAliasJoin Type
R_JITPackingGroupItemRefTP R_JITPackingGroupItemRefTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Slot Info of Packing Group being scanned view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Slot view
UI.headerInfo.typeNamePlural Slots view
UI.headerInfo.title.value _JITPackingGroupItemTP.JITPckgGrpCellNumber view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.description.value view

OData Services (1)

ServiceBindingVersionContractRelease
NJIT_UI_JITPACKINGGROUPFORSCAN NJIT_UI_JITPCKGGRPFORSCAN V2 C1 NOT_RELEASED

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY JITPckgGrpItemRefUUID JITPckgGrpItemRefUUID NodeID
JITPckgGrpItemUUID JITPckgGrpItemUUID UUID
JITPckgGrpUUID JITPckgGrpUUID NodeID
JITPckgGrpID _JITPckgGrpHeader JITPckgGrpID Package Group ID
JITPckgGrpCellNumber _JITPackingGroupItemTP JITPckgGrpCellNumber Slot Number
CompGrpMatl _JITCallCompGroupBasic CompGrpMatl Comp. Group Matl.
InternalJITCallNumber _JITCallCompGroupBasic InternalJITCallNumber JIT Call Number
JITExtSequenceNumber _JITCallCompGroupBasic JITExtSequenceNumber Ext.Seq. Number
JITPackingStatus _JITPackingGroupItemTP JITPackingStatus Packing Status
CompGrpNumber _JITCallCompGroupBasic CompGrpNumber Component Group No.
CustAssemblyLoc _JITCallCompGroupBasic CustAssemblyLoc Assembly Location
VehicleModel
OutboundDelivery
JITPackingStatusText
JITPackingGroupIsNested _JITSubPckgGrpHeader JITPackingGroupIsNested Packing Nested Ind.
JITSubPckgGrpUUID ReferenceDocumentUUID NodeID
JITSubPckgGrpID _JITSubPckgGrpHeader JITPckgGrpID Package Group ID
dec133
virtualQuantityUnitmeins
virtualJITPackingStatusCriticalityint1
JITPckgCntntType JITPckgCntntType Content Type
_JITPackingGroupItemTP _JITPackingGroupItemTP
_JITCallCompGroupBasic _JITCallCompGroupBasic

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_JITPackingGroupSlotsForScan.
-- 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_JITPackingGroupSlotsForScan AS
SELECT
  JITPckgGrpItemRefUUID,
  JITPckgGrpItemUUID,
  JITPckgGrpUUID,
  _JITPckgGrpHeader.JITPckgGrpID AS JITPckgGrpID,
  _JITPackingGroupItemTP.JITPckgGrpCellNumber AS JITPckgGrpCellNumber,
  _JITCallCompGroupBasic.CompGrpMatl AS CompGrpMatl,
  _JITCallCompGroupBasic.InternalJITCallNumber AS InternalJITCallNumber,
  _JITCallCompGroupBasic.JITExtSequenceNumber AS JITExtSequenceNumber,
  _JITPackingGroupItemTP.JITPackingStatus AS JITPackingStatus,
  _JITCallCompGroupBasic.CompGrpNumber AS CompGrpNumber,
  _JITCallCompGroupBasic.CustAssemblyLoc AS CustAssemblyLoc,
  _JITCallCompGroupBasic._JITCallHeaderBasic.VehicleModel AS VehicleModel,
  _JITCallCompGroupBasic._JITPckgGrpItemRef._JITPckgGrpHeader._JITPckgGrpDeliveryRef.OutboundDelivery AS OutboundDelivery,
  _JITPackingGroupItemTP._JITPackingStatus._Text[1: Language=$session.system_language].JITPackingStatusText AS JITPackingStatusText,
  _JITSubPckgGrpHeader.JITPackingGroupIsNested AS JITPackingGroupIsNested,
  ReferenceDocumentUUID AS JITSubPckgGrpUUID,
  _JITSubPckgGrpHeader.JITPckgGrpID AS JITSubPckgGrpID,
  virtual RequestedQuantity : abap.dec( 13, 3 ) AS dec133,
  virtual QuantityUnit : meins AS virtualQuantityUnitmeins,
  virtual JITPackingStatusCriticality : int1 AS virtualJITPackingStatusCriticalityint1,
  JITPckgCntntType
FROM R_JITPackingGroupItemRefTP
;