I_JITOutbCallStockTransfer

DDL: I_JITOUTBCALLSTOCKTRANSFER SQL: ISTKTNSRJITOUTB Type: view COMPOSITE Package: NJIT_MODEL_O
48 Fields 1 Data Sources 2 Associations

JIT Outbound call for stock transfer

I_JITOutbCallStockTransfer is a Composite CDS View that provides data about "JIT Outbound call for stock transfer" in SAP S/4HANA. It reads from 1 data source (P_JitOutbCallStockTransfer) and exposes 48 fields with key fields InternalJITCallNumber, CompGrpNumber, JITCallItemNumber, JITControlCycle. It has 2 associations to related views. Part of development package NJIT_MODEL_O.

Data Sources (1)

SourceAliasJoin Type
P_JitOutbCallStockTransfer P_JitOutbCallStockTransfer from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_JITOutbStockTransferInd _JITOutbStockTransferInd $projection.JITOutbCallStockTransferInd = _JITOutbStockTransferInd.JITOutbCallStockTransferInd
[1..1] I_UnitOfMeasure _UnitOfMeasure $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISTKTNSRJITOUTB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label JIT Outbound call for stock transfer view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
KEY JITCallItemNumber JITCallItemNumber Call Item Number
KEY JITControlCycle JITControlCycle Control Cycle
Material Material Vehicle Model
Plant Plant Valuation Area
JITCallType JITCallType Call Type
JITOutbStockTransferSts JITOutbStockTransferSts Stock Trnsfr Status
JITCallPriorityID JITCallPriorityID Delivery Prior.
JITCallImmediateRequest JITCallImmediateRequest Immediate Request
JITCallPriorityType JITCallPriorityType Priority Type
QuantityUnit QuantityUnit Unit of measure
JITOutbStockQuantity JITOutbStockQuantity
ProductionSupplyArea ProductionSupplyArea Supply Area
RequirementDateTime RequirementDateTime Time Stamp
StorageLocation StorageLocation StorageLocation
JITSupplyDateTime JITSupplyDateTime Supply Date & Time
JITOutbDestinationStorLoc JITOutbDestinationStorLoc Dest. Storage Loc
JITActionCtrl JITActionCtrl Action Control
JITSourceWarehouseNumber JITSourceWarehouseNumber Source Warehouse No.
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
JITOutbTransferredQuantity JITOutbTransferredQuantity Transferred Qty
JITOutbOpenQuantity JITOutbOpenQuantity Open Qty
JITOutbMinimumQuantity JITOutbMinimumQuantity Minimum Qty
JITOutbPickedQuantity JITOutbPickedQuantity Picked Quantity
ShortfallQuantity ShortfallQuantity
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
JITIntStatusUpdtdOnDteTme JITIntStatusUpdtdOnDteTme Int Status Updtd On
IsPartiallyDelivered _JITControlCycle IsPartiallyDelivered
NumberOfLoadCarriers _JITControlCycle NumberOfLoadCarriers
ProductionSupplyAreaName
PlantName
StorageLocationName
JITContainer _JITControlCycle JITContainer
JITContainerDesc
ProductName
StoringPositionName _JITControlCycle StoringPositionName
UnitOfMeasureNumberOfDecimals _UnitOfMeasure UnitOfMeasureNumberOfDecimals
JITOutbCallStockTransferInd
JITOutbCallStkTransfIndCritlty
JITOutbAvailableStockQuantity
JITOutbTransferringQuantity
_JITControlCycle _JITControlCycle
_JITOutbStockTransferInd _JITOutbStockTransferInd
_JITStockTransferSts _JITStockTransferSts
_JITCallType _JITCallType
_DeliveryPriority _DeliveryPriority

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_JITOutbCallStockTransfer.
-- 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: ISTKTNSRJITOUTB

CREATE VIEW I_JITOutbCallStockTransfer AS
SELECT
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITControlCycle,
  Material,
  Plant,
  JITCallType,
  JITOutbStockTransferSts,
  JITCallPriorityID,
  JITCallImmediateRequest,
  JITCallPriorityType,
  QuantityUnit,
  JITOutbStockQuantity,
  ProductionSupplyArea,
  RequirementDateTime,
  StorageLocation,
  JITSupplyDateTime,
  JITOutbDestinationStorLoc,
  JITActionCtrl,
  JITSourceWarehouseNumber,
  RequestedQuantity,
  ActualDeliveredQuantity,
  JITOutbTransferredQuantity,
  JITOutbOpenQuantity,
  JITOutbMinimumQuantity,
  JITOutbPickedQuantity,
  ShortfallQuantity,
  JITIntProcessingStatus,
  JITIntStatusUpdtdOnDteTme,
  _JITControlCycle.IsPartiallyDelivered AS IsPartiallyDelivered,
  _JITControlCycle.NumberOfLoadCarriers AS NumberOfLoadCarriers,
  _JITControlCycle._SourceSupplyArea._Text[1: Language = $session.system_language].ProductionSupplyAreaName AS ProductionSupplyAreaName,
  _JITControlCycle._Plant.PlantName AS PlantName,
  _JITControlCycle._StorageLocation.StorageLocationName AS StorageLocationName,
  _JITControlCycle.JITContainer AS JITContainer,
  _JITControlCycle. _JITContainer._Text[1: Language = $session.system_language].ProductName AS JITContainerDesc,
  _JITControlCycle._Product._Text[1: Language = $session.system_language].ProductName AS ProductName,
  _JITControlCycle.StoringPositionName AS StoringPositionName,
  _UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  cast('1' as njit_stk_trnsfr_ind) AS JITOutbCallStockTransferInd,
  cast(1 as int1) AS JITOutbCallStkTransfIndCritlty,
  cast(0 as behmg) AS JITOutbAvailableStockQuantity,
  cast(0 as behmg) AS JITOutbTransferringQuantity
FROM P_JitOutbCallStockTransfer
LEFT OUTER JOIN I_JITOutbStockTransferInd AS _JITOutbStockTransferInd ON JITOutbCallStockTransferInd = _JITOutbStockTransferInd.JITOutbCallStockTransferInd  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;

Learn More