I_JITOutbCallStockTransfBasic

DDL: I_JITOUTBCALLSTOCKTRANSFBASIC SQL: ISTKTNSRJITOBAS Type: view BASIC Package: NJIT_MODEL_O
39 Fields 1 Data Sources 3 Associations

Basic view of JIT outbound for stock transfer

I_JITOutbCallStockTransfBasic is a Basic CDS View that provides data about "Basic view of JIT outbound for stock transfer" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallHeader) and exposes 39 fields with key fields InternalJITCallNumber, CompGrpNumber, JITCallItemNumber. It has 3 associations to related views. Part of development package NJIT_MODEL_O.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallHeader I_JITOutbCallHeader from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_JITOutbCallCompGrp _JITOutbCallCompGrp $projection.JITHeaderUUID = _JITOutbCallCompGrp.ParentDraftKey and $projection.InternalJITCallNumber = _JITOutbCallCompGrp.InternalJITCallNumber
[1..*] I_JITOutbCallCompMatl _JITOutbCallCompMatl $projection.JITHeaderUUID = _JITOutbCallCompMatl.RootDraftKey and $projection.InternalJITCallNumber = _JITOutbCallCompMatl.InternalJITCallNumber
[0..1] I_JITStockTransferSts _JITStockTransferSts $projection.jitoutbstocktransfersts = _JITStockTransferSts.JITOutbStockTransferSts

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISTKTNSRJITOBAS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic view of JIT outbound for stock transfer view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey InternalJITCallNumber view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber _JITOutbCallCompGrp CompGrpNumber Component Group No.
KEY JITCallItemNumber _JITOutbCallCompMatl JITCallItemNumber Call Item Number
JITHeaderUUID JITHeaderUUID NodeID
JITCallType JITCallType Call Type
ExternalJITCallNumber ExternalJITCallNumber Ext. JIT Call Number
JITCallCreationMode JITCallCreationMode JIT- Creation Mode
JITLifecycleStatus JITLifecycleStatus Life Cycle Status
CreationDateTime CreationDateTime Timestamp
JITCallPriorityType JITCallPriorityType Priority Type
JITCallPriorityID JITCallPriorityID Delivery Prior.
JITCallImmediateRequest JITCallImmediateRequest Immediate Request
JITControlCycle _JITOutbCallCompGrp JITControlCycle Control Cycle
Plant _JITOutbCallCompGrp Plant Valuation Area
ProductionSupplyArea _JITOutbCallCompGrp ProductionSupplyArea Supply Area
RequirementDateTime _JITOutbCallCompGrp RequirementDateTime Time Stamp
StorageLocation _JITOutbCallCompGrp StorageLocation StorageLocation
JITSupplyDateTime _JITOutbCallCompGrp JITSupplyDateTime Supply Date & Time
JITOutbDestinationStorLoc _JITOutbCallCompGrp JITOutbDestinationStorLoc Dest. Storage Loc
JITActionCtrl _JITOutbCallCompGrp JITActionCtrl Action Control
JITSourceWarehouseNumber _JITOutbCallCompGrp JITSourceWarehouseNumber Source Warehouse No.
Material _JITOutbCallCompMatl Material Vehicle Model
QuantityUnit _JITOutbCallCompMatl QuantityUnit Unit of measure
RequestedQuantity _JITOutbCallCompMatl RequestedQuantity Requested Quantity
ActualDeliveredQuantity _JITOutbCallCompMatl ActualDeliveredQuantity Delivered Quantity
JITOutbTransferredQuantity _JITOutbCallCompMatl JITOutbTransferredQuantity Transferred Qty
JITOutbOpenQuantity _JITOutbCallCompMatl JITOutbOpenQuantity Open Qty
JITOutbMinimumQuantity _JITOutbCallCompMatl JITOutbMinimumQuantity Minimum Qty
JITOutbPickedQuantity _JITOutbCallCompMatl JITOutbPickedQuantity Picked Quantity
ShortfallQuantity _JITOutbCallCompMatl ShortfallQuantity
JITIntProcessingStatus _JITOutbCallCompMatl JITIntProcessingStatus Transmitted Status
JITIntStatusUpdtdOnDteTme _JITOutbCallCompMatl JITIntStatusUpdtdOnDteTme Int Status Updtd On
JITOutbStockTransferSts _JITOutbCallCompMatl JITOutbStockTransferSts Stock Trnsfr Status
_JITStockTransferSts _JITStockTransferSts
_JITCallType _JITCallType
_ProductCompMatl _JITOutbCallCompMatl _ProductCompMatl
_StorageLocation _JITOutbCallCompGrp _StorageLocation
_DeliveryPriority _DeliveryPriority
_JITInternalStatus _JITOutbCallCompMatl _JITInternalStatus

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_JITOutbCallStockTransfBasic.
-- 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: ISTKTNSRJITOBAS

CREATE VIEW I_JITOutbCallStockTransfBasic AS
SELECT
  InternalJITCallNumber,
  _JITOutbCallCompGrp.CompGrpNumber AS CompGrpNumber,
  _JITOutbCallCompMatl.JITCallItemNumber AS JITCallItemNumber,
  JITHeaderUUID,
  JITCallType,
  ExternalJITCallNumber,
  JITCallCreationMode,
  JITLifecycleStatus,
  CreationDateTime,
  JITCallPriorityType,
  JITCallPriorityID,
  JITCallImmediateRequest,
  _JITOutbCallCompGrp.JITControlCycle AS JITControlCycle,
  _JITOutbCallCompGrp.Plant AS Plant,
  _JITOutbCallCompGrp.ProductionSupplyArea AS ProductionSupplyArea,
  _JITOutbCallCompGrp.RequirementDateTime AS RequirementDateTime,
  _JITOutbCallCompGrp.StorageLocation AS StorageLocation,
  _JITOutbCallCompGrp.JITSupplyDateTime AS JITSupplyDateTime,
  _JITOutbCallCompGrp.JITOutbDestinationStorLoc AS JITOutbDestinationStorLoc,
  _JITOutbCallCompGrp.JITActionCtrl AS JITActionCtrl,
  _JITOutbCallCompGrp.JITSourceWarehouseNumber AS JITSourceWarehouseNumber,
  _JITOutbCallCompMatl.Material AS Material,
  _JITOutbCallCompMatl.QuantityUnit AS QuantityUnit,
  _JITOutbCallCompMatl.RequestedQuantity AS RequestedQuantity,
  _JITOutbCallCompMatl.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  _JITOutbCallCompMatl.JITOutbTransferredQuantity AS JITOutbTransferredQuantity,
  _JITOutbCallCompMatl.JITOutbOpenQuantity AS JITOutbOpenQuantity,
  _JITOutbCallCompMatl.JITOutbMinimumQuantity AS JITOutbMinimumQuantity,
  _JITOutbCallCompMatl.JITOutbPickedQuantity AS JITOutbPickedQuantity,
  _JITOutbCallCompMatl.ShortfallQuantity AS ShortfallQuantity,
  _JITOutbCallCompMatl.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITOutbCallCompMatl.JITIntStatusUpdtdOnDteTme AS JITIntStatusUpdtdOnDteTme,
  _JITOutbCallCompMatl.JITOutbStockTransferSts AS JITOutbStockTransferSts,
  _JITOutbCallCompMatl._ProductCompMatl AS _ProductCompMatl,
  _JITOutbCallCompGrp._StorageLocation AS _StorageLocation,
  _JITOutbCallCompMatl._JITInternalStatus AS _JITInternalStatus
FROM I_JITOutbCallHeader
LEFT OUTER JOIN I_JITOutbCallCompGrp AS _JITOutbCallCompGrp ON JITHeaderUUID = _JITOutbCallCompGrp.ParentDraftKey AND InternalJITCallNumber = _JITOutbCallCompGrp.InternalJITCallNumber  -- association [0..1]
LEFT OUTER JOIN I_JITOutbCallCompMatl AS _JITOutbCallCompMatl ON JITHeaderUUID = _JITOutbCallCompMatl.RootDraftKey AND InternalJITCallNumber = _JITOutbCallCompMatl.InternalJITCallNumber  -- association [1..*]
LEFT OUTER JOIN I_JITStockTransferSts AS _JITStockTransferSts ON jitoutbstocktransfersts = _JITStockTransferSts.JITOutbStockTransferSts  -- association [0..1]
;

Learn More