C_JITScanHistoryForCompGrp

DDL: C_JITSCANHISTORYFORCOMPGRP Type: view_entity CONSUMPTION Package: NJIT_APP_SCANNING
25 Fields 1 Data Sources 2 Associations 1 OData Services

Scan Component Groups

C_JITScanHistoryForCompGrp is a Consumption CDS View that provides data about "Scan Component Groups" in SAP S/4HANA. It reads from 1 data source (R_JITScanHistoryTP) and exposes 25 fields with key field JITScanUUID. It has 2 associations to related views. It is exposed through 1 OData service (NJIT_UI_JITCALLCOMPGRPFORSCAN). Part of development package NJIT_APP_SCANNING.

Data Sources (1)

SourceAliasJoin Type
R_JITScanHistoryTP R_JITScanHistoryTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_JITInbCallCompGrpForScan _JITInbCallCompGrpForScan $projection.JITObjectUUID = _JITInbCallCompGrpForScan.JITCallCompGrpUUID
[0..*] C_JITInbCallCompMatlForScan _JITInbCallCompMatlForScan $projection.JITObjectUUID = _JITInbCallCompMatlForScan.JITGroupScanUUID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Scan Component Groups view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
NJIT_UI_JITCALLCOMPGRPFORSCAN NJIT_UI_JITCOMPGRPFORSCAN V2 C1 NOT_RELEASED

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY JITScanUUID JITScanUUID NodeID
RespyMgmtTeamID RespyMgmtTeamID Team ID
RespyMgmtFunction RespyMgmtFunction Function
JITObjectUUID JITObjectUUID NodeID
ExternalJITCallNumber ExternalJITCallNumber Ext. JIT Call Number
InternalJITCallNumber InternalJITCallNumber JIT Call Number
JITRespyMgmtAltvFunction JITRespyMgmtAltvFunction Function
JITRespyMgmtAltvFunctionDesc _RespyMgmtFunction RespyMgmtFunctionDescription
CompGrpNumber CompGrpNumber Component Group No.
CompGrpMatl CompGrpMatl Comp. Group Matl.
Material Material Vehicle Model
JITLastScannedSequence JITLastScannedSequence Scan Sequence
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
VerificatPrflHasConfScan VerificatPrflHasConfScan TRUE
VerificatPrflHasSortVariant VerificatPrflHasSortVariant TRUE
_JITInbCallCompGrpForScan _JITInbCallCompGrpForScan
_JITInbCallCompMatlForScan _JITInbCallCompMatlForScan

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_JITScanHistoryForCompGrp.
-- 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_JITScanHistoryForCompGrp AS
SELECT
  JITScanUUID,
  RespyMgmtTeamID,
  RespyMgmtFunction,
  JITObjectUUID,
  ExternalJITCallNumber,
  InternalJITCallNumber,
  JITRespyMgmtAltvFunction,
  _RespyMgmtFunction.RespyMgmtFunctionDescription AS JITRespyMgmtAltvFunctionDesc,
  CompGrpNumber,
  CompGrpMatl,
  Material,
  JITLastScannedSequence,
  JITUniversalScanField,
  JITNextToScanObjectIdentifier,
  JITNextToScanValue,
  JITScanProgressInPercent,
  JITScanProgressText,
  JITActionIsProcessed,
  JITAutomateProcess,
  JITNumberOfScanEntryUnits,
  JITCurrentScanEntryUnitValue,
  VerificatPrflHasConfScan,
  VerificatPrflHasSortVariant
FROM R_JITScanHistoryTP
LEFT OUTER JOIN C_JITInbCallCompGrpForScan AS _JITInbCallCompGrpForScan ON JITObjectUUID = _JITInbCallCompGrpForScan.JITCallCompGrpUUID  -- association [0..1]
LEFT OUTER JOIN C_JITInbCallCompMatlForScan AS _JITInbCallCompMatlForScan ON JITObjectUUID = _JITInbCallCompMatlForScan.JITGroupScanUUID  -- association [0..*]
;

Learn More