I_JITOutbSqncData

DDL: I_JITOUTBSQNCDATA SQL: IJITOUTBSQNCDATA Type: view COMPOSITE Package: NJIT_MODEL_O
38 Fields 1 Data Sources

Monitor JIS call Data Selection

I_JITOutbSqncData is a Composite CDS View that provides data about "Monitor JIS call Data Selection" in SAP S/4HANA. It reads from 1 data source (I_JITOutbSqncCalls) and exposes 38 fields with key fields InternalJITCallNumber, JITCallItemNumber. Part of development package NJIT_MODEL_O.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbSqncCalls _JITOutbCalls from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IJITOUTBSQNCDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
EndUserText.label Monitor JIS call Data Selection view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY JITCallItemNumber JITCallItemNumber Call Item Number
Material Material Vehicle Model
Plant Plant Valuation Area
ProductionSupplyArea ProductionSupplyArea Supply Area
CompGrpMatl CompGrpMatl Comp. Group Matl.
JITLifecycleStatus JITLifecycleStatus Life Cycle Status
JITCallType JITCallType Call Type
StorageLocation StorageLocation StorageLocation
RequirementDateTime RequirementDateTime Time Stamp
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITControlCycle JITControlCycle Control Cycle
ProductionSupplyAreaRespPerson ProductionSupplyAreaRespPerson
JITOutbStockTransferSts JITOutbStockTransferSts Stock Trnsfr Status
JITOutbDestinationStorLoc JITOutbDestinationStorLoc Dest. Storage Loc
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
QuantityUnit QuantityUnit Unit of measure
JITOutbTransferredQuantity JITOutbTransferredQuantity Transferred Qty
JITOutbMinimumQuantity JITOutbMinimumQuantity Minimum Qty
JITPlannedOrderNumber JITPlannedOrderNumber JIT Planned Order
ProductName ProductName Description
JITExternalReplenishment
Supplier Supplier Supplier
CreationDateTime CreationDateTime Timestamp
JITSupplyDateTime JITSupplyDateTime Supply Date & Time
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
JITCallHasAlert
JITCallImmediateRequest JITCallImmediateRequest Immediate Request
VehicleIdentificationNumber VehicleIdentificationNumber VIN
JITCallCreationMode JITCallCreationMode JIT- Creation Mode
JITIntSequenceNumber JITIntSequenceNumber Internal Sequence No
_JITInternalStatus _JITInternalStatus
_JITStockTransferSts _JITStockTransferSts
_JITLifecycleStatus _JITLifecycleStatus
_ProductionSupplyArea _ProductionSupplyArea
_ProductCompMatl _ProductCompMatl

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_JITOutbSqncData.
-- 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.
-- SQL view name: IJITOUTBSQNCDATA

CREATE VIEW I_JITOutbSqncData AS
SELECT
  InternalJITCallNumber,
  JITCallItemNumber,
  Material,
  Plant,
  ProductionSupplyArea,
  CompGrpMatl,
  JITLifecycleStatus,
  JITCallType,
  StorageLocation,
  RequirementDateTime,
  JITIntProcessingStatus,
  JITControlCycle,
  ProductionSupplyAreaRespPerson,
  JITOutbStockTransferSts,
  JITOutbDestinationStorLoc,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  JITOutbTransferredQuantity,
  JITOutbMinimumQuantity,
  JITPlannedOrderNumber,
  ProductName,
  '' AS JITExternalReplenishment,
  Supplier,
  CreationDateTime,
  JITSupplyDateTime,
  LastChangeDateTime,
  LastChangedByUser,
  '' AS JITCallHasAlert,
  JITCallImmediateRequest,
  VehicleIdentificationNumber,
  JITCallCreationMode,
  JITIntSequenceNumber
FROM I_JITOutbSqncCalls AS _JITOutbCalls
;

Learn More