C_JITScanHistoryForPckgGrp

DDL: C_JITSCANHISTORYFORPCKGGRP Type: view_entity CONSUMPTION
27 Fields 1 Data Sources 4 Associations

Scan Packing Groups

C_JITScanHistoryForPckgGrp is a Consumption CDS View that provides data about "Scan Packing Groups" in SAP S/4HANA. It reads from 1 data source (R_JITScanHistoryTP) and exposes 27 fields with key field JITScanUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_JITScanHistoryTP R_JITScanHistoryTP projection

Associations (4)

CardinalityTargetAliasCondition
[0..1] C_JITPackingGroupForScan _JITPackingGroupForScan $projection.JITObjectUUID = _JITPackingGroupForScan.JITPckgGrpUUID
[0..*] C_JITPackingGroupSlotsForScan _PackingGroupSlots $projection.JITObjectUUID = _PackingGroupSlots.JITPckgGrpUUID
[0..*] C_JITNestedPackgGrpSlots _NestedPackingGroupSlots $projection.JITObjectUUID = _NestedPackingGroupSlots.JITPckgGrpUUID
[0..*] C_JITScanPackingGroupSlot _ScanPackingGroupSlot $projection.JITObjectUUID = _ScanPackingGroupSlot.JITPckgGrpUUID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Scan Packing Groups view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Packing Group view
UI.headerInfo.typeNamePlural Packing Groups view
UI.headerInfo.title.value JITAltvHndlgUnitID view
UI.headerInfo.description.value JITPckgGrpID view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY JITScanUUID JITScanUUID NodeID
RespyMgmtTeamID RespyMgmtTeamID Team ID
RespyMgmtFunction RespyMgmtFunction Function
JITObjectUUID JITObjectUUID NodeID
JITPckgGrpID JITPckgGrpID Package Group ID
JITAltvHndlgUnitID JITAltvHndlgUnitID Alt. PG ID Short
VerificatPrflHasConfScan VerificatPrflHasConfScan TRUE
VerificatPrflHasSortVariant VerificatPrflHasSortVariant TRUE
JITPckgGrpCellNumber JITPckgGrpCellNumber Slot Number
JITPckgGrpContentID JITPckgGrpContentID Pckg Grp Content ID
JITPackgGrpSlotIsHidden JITPackgGrpSlotIsHidden TRUE
JITPackgGrpProdIsHidden JITPackgGrpProdIsHidden TRUE
JITNestedSlotFacetIsHidden JITNestedSlotFacetIsHidden TRUE
JITNonNestedSlotFacetIsHidden JITNonNestedSlotFacetIsHidden TRUE
JITUniversalScanField JITUniversalScanField Scan Value
JITNextToScanObjectIdentifier JITNextToScanObjectIdentifier Obj ID for Conf Scan
JITNextToScanValue JITNextToScanValue Logical System
JITScanProgressInPercent JITScanProgressInPercent
JITScanProgressText JITScanProgressText Character Field with Length 10
JITActionIsProcessed JITActionIsProcessed TRUE
JITAutomateProcess JITAutomateProcess Automated Process
JITNumberOfScanEntryUnits JITNumberOfScanEntryUnits JITScanEntrUnts
JITCurrentScanEntryUnitValue JITCurrentScanEntryUnitValue JITScanEntrUnts
_PackingGroupSlots _PackingGroupSlots
_NestedPackingGroupSlots _NestedPackingGroupSlots
_JITPackingGroupForScan _JITPackingGroupForScan
_ScanPackingGroupSlot _ScanPackingGroupSlot

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_JITScanHistoryForPckgGrp.
-- 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_JITScanHistoryForPckgGrp AS
SELECT
  JITScanUUID,
  RespyMgmtTeamID,
  RespyMgmtFunction,
  JITObjectUUID,
  JITPckgGrpID,
  JITAltvHndlgUnitID,
  VerificatPrflHasConfScan,
  VerificatPrflHasSortVariant,
  JITPckgGrpCellNumber,
  JITPckgGrpContentID,
  JITPackgGrpSlotIsHidden,
  JITPackgGrpProdIsHidden,
  JITNestedSlotFacetIsHidden,
  JITNonNestedSlotFacetIsHidden,
  JITUniversalScanField,
  JITNextToScanObjectIdentifier,
  JITNextToScanValue,
  JITScanProgressInPercent,
  JITScanProgressText,
  JITActionIsProcessed,
  JITAutomateProcess,
  JITNumberOfScanEntryUnits,
  JITCurrentScanEntryUnitValue
FROM R_JITScanHistoryTP
LEFT OUTER JOIN C_JITPackingGroupForScan AS _JITPackingGroupForScan ON JITObjectUUID = _JITPackingGroupForScan.JITPckgGrpUUID  -- association [0..1]
LEFT OUTER JOIN C_JITPackingGroupSlotsForScan AS _PackingGroupSlots ON JITObjectUUID = _PackingGroupSlots.JITPckgGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITNestedPackgGrpSlots AS _NestedPackingGroupSlots ON JITObjectUUID = _NestedPackingGroupSlots.JITPckgGrpUUID  -- association [0..*]
LEFT OUTER JOIN C_JITScanPackingGroupSlot AS _ScanPackingGroupSlot ON JITObjectUUID = _ScanPackingGroupSlot.JITPckgGrpUUID  -- association [0..*]
;

Learn More