I_JITScanHistoryDraft

DDL: I_JITSCANHISTORYDRAFT Type: view_entity BASIC
37 Fields 1 Data Sources

JIT Scan History - Draft

I_JITScanHistoryDraft is a Basic CDS View that provides data about "JIT Scan History - Draft" in SAP S/4HANA. It reads from 1 data source (njit_scan_hdr_d) and exposes 37 fields with key field JITScanUUID.

Data Sources (1)

SourceAliasJoin Type
njit_scan_hdr_d njit_scan_hdr_d from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label JIT Scan 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 (37)

KeyFieldSource TableSource FieldDescription
KEY JITScanUUID jitscanuuid NodeID
RespyMgmtTeamID respymgmtteamid Team ID
RespyMgmtFunction respymgmtfunction Function
JITObjectUUID jitobjectuuid NodeID
JITUniversalScanField jituniversalscanfield Scan Value
VerificatPrflHasConfScan verificatprflhasconfscan TRUE
VerificatPrflHasSortVariant verificatprflhassortvariant TRUE
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
JITPckgGrpCellNumber jitpckggrpcellnumber Slot Number
AssemblyLocation assemblylocation Assembly Location
OutboundDelivery outbounddelivery LE Delivery
CompGrpNumber compgrpnumber Component Group No.
SerialNumber serialnumber Serial Number
ExternalJITCallNumber externaljitcallnumber Ext. JIT Call Number
InternalJITCallNumber internaljitcallnumber JIT Call Number
JITPckgGrpID jitpckggrpid Package Group ID
JITAltvHndlgUnitID jitaltvhndlgunitid Alt. PG ID Short
Material material Vehicle Model
CompGrpMatl compgrpmatl Comp. Group Matl.
JITLastScannedSequence jitlastscannedsequence Scan Sequence
JITNextToScanObjectIdentifier jitnexttoscanobjectidentifier Obj ID for Conf Scan
JITNextToScanValue jitnexttoscanvalue Logical System
JITScanProgressInPercent jitscanprogressinpercent
JITScanProgressText jitscanprogresstext Character Field with Length 10
JITActionIsProcessed jitactionisprocessed TRUE
JITPackageLevel jitpackagelevel Packing Level
JITPckgCntntType jitpckgcntnttype Content Type
NmbrOfAssignedSerialNumbers nmbrofassignedserialnumbers INT4
JITPckgGrpContentID jitpckggrpcontentid Pckg Grp Content ID
JITAutomateProcess jitautomateprocess Automated Process
JITNumberOfScanEntryUnits jitnumberofscanentryunits JITScanEntrUnts
JITCurrentScanEntryUnitValue jitcurrentscanentryunitvalue JITScanEntrUnts
JITRespyMgmtAltvFunction jitrespymgmtaltvfunction Function
JITCompletedScanEntryUnitValue jitcompletedscanentryunitvalue JITScanEntrUnts

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_JITScanHistoryDraft.
-- 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_JITScanHistoryDraft AS
SELECT
  JITScanUUID,
  RespyMgmtTeamID,
  RespyMgmtFunction,
  JITObjectUUID,
  JITUniversalScanField,
  VerificatPrflHasConfScan,
  VerificatPrflHasSortVariant,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  JITPckgGrpCellNumber,
  AssemblyLocation,
  OutboundDelivery,
  CompGrpNumber,
  SerialNumber,
  ExternalJITCallNumber,
  InternalJITCallNumber,
  JITPckgGrpID,
  JITAltvHndlgUnitID,
  Material,
  CompGrpMatl,
  JITLastScannedSequence,
  JITNextToScanObjectIdentifier,
  JITNextToScanValue,
  JITScanProgressInPercent,
  JITScanProgressText,
  JITActionIsProcessed,
  JITPackageLevel,
  JITPckgCntntType,
  NmbrOfAssignedSerialNumbers,
  JITPckgGrpContentID,
  JITAutomateProcess,
  JITNumberOfScanEntryUnits,
  JITCurrentScanEntryUnitValue,
  JITRespyMgmtAltvFunction,
  JITCompletedScanEntryUnitValue
FROM njit_scan_hdr_d
;

Learn More