I_JITScanSlotHistoryDraft

DDL: I_JITSCANSLOTHISTORYDRAFT Type: view_entity BASIC Package: NJIT_APP_SCANNING
28 Fields 1 Data Sources

JIT Scan Slot History - Draft

I_JITScanSlotHistoryDraft is a Basic CDS View that provides data about "JIT Scan Slot History - Draft" in SAP S/4HANA. It reads from 1 data source (njit_scan_slot_d) and exposes 28 fields with key field JITScanHistoryItemUUID. Part of development package NJIT_APP_SCANNING.

Data Sources (1)

SourceAliasJoin Type
njit_scan_slot_d njit_scan_slot_d from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label JIT Scan Slot History - Draft view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY JITScanHistoryItemUUID jitscanhistoryitemuuid NodeID
JITScanUUID jitscanuuid NodeID
JITObjectUUID jitobjectuuid NodeID
ExternalJITCallNumber externaljitcallnumber Ext. JIT Call Number
InternalJITCallNumber internaljitcallnumber JIT Call Number
JITPckgGrpID jitpckggrpid Package Group ID
JITAltvHndlgUnitID jitaltvhndlgunitid Alt. PG ID Short
CompGrpNumber compgrpnumber Component Group No.
CompGrpMatl compgrpmatl Comp. Group Matl.
Material material Vehicle Model
SerialNumber serialnumber Serial Number
AssemblyLocation assemblylocation Assembly Location
JITPckgGrpContentID jitpckggrpcontentid Pckg Grp Content ID
JITPckgGrpCellNumber jitpckggrpcellnumber Slot Number
JITScanItemStatus jitscanitemstatus Scan Status
OutboundDelivery outbounddelivery LE Delivery
RequestedQuantity requestedquantity Requested Quantity
QuantityUnit quantityunit Unit of measure
ScannedSerialNumberQuantity scannedserialnumberquantity Scanned Quantity
SerialNumberScanIsAllowed serialnumberscanisallowed Truth Value
JITPckgCntntType jitpckgcntnttype Content Type
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
JITGroupScanUUID jitgroupscanuuid NodeID
_JITScanStatus _JITScanStatus

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_JITScanSlotHistoryDraft.
-- 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_JITScanSlotHistoryDraft AS
SELECT
  JITScanHistoryItemUUID,
  JITScanUUID,
  JITObjectUUID,
  ExternalJITCallNumber,
  InternalJITCallNumber,
  JITPckgGrpID,
  JITAltvHndlgUnitID,
  CompGrpNumber,
  CompGrpMatl,
  Material,
  SerialNumber,
  AssemblyLocation,
  JITPckgGrpContentID,
  JITPckgGrpCellNumber,
  JITScanItemStatus,
  OutboundDelivery,
  RequestedQuantity,
  QuantityUnit,
  ScannedSerialNumberQuantity,
  SerialNumberScanIsAllowed,
  JITPckgCntntType,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  DraftEntityOperationCode,
  JITGroupScanUUID
FROM njit_scan_slot_d
;

Learn More