I_JITOutbCalls

DDL: I_JITOUTBCALLS SQL: IJITOUTBCALLS Type: view COMPOSITE
35 Fields 1 Data Sources 2 Associations

Composite View for JIT Outbound Calls

I_JITOutbCalls is a Composite CDS View that provides data about "Composite View for JIT Outbound Calls" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallCompMatl) and exposes 35 fields with key fields InternalJITCallNumber, CompGrpNumber, JITCallItemNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallCompMatl _JITOutbCallCompMatl from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_JITInternalStatus _JITInternalStatus $projection.JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus
[1..1] I_UnitOfMeasure _UnitOfMeasures $projection.QuantityUnit = _UnitOfMeasures.UnitOfMeasure

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IJITOUTBCALLS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Composite View for JIT Outbound Calls view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY InternalJITCallNumber I_JITOutbCallCompMatl InternalJITCallNumber JIT Call Number
KEY CompGrpNumber I_JITOutbCallCompMatl CompGrpNumber Component Group No.
KEY JITCallItemNumber I_JITOutbCallCompMatl JITCallItemNumber Call Item Number
JITLifecycleStatus _JITOutbCallHeader JITLifecycleStatus Life Cycle Status
CreationDateTime _JITOutbCallHeader CreationDateTime Timestamp
JITCallType _JITOutbCallHeader JITCallType Call Type
Plant _JITOutbCallCompGrp Plant Valuation Area
StorageLocation _JITOutbCallCompGrp StorageLocation StorageLocation
RequirementDateTime _JITOutbCallCompGrp RequirementDateTime Time Stamp
JITIntProcessingStatus I_JITOutbCallCompMatl JITIntProcessingStatus Transmitted Status
ProductionSupplyArea _JITOutbCallCompGrp ProductionSupplyArea Supply Area
JITControlCycle _JITOutbCallCompGrp JITControlCycle Control Cycle
JITOutbDestinationStorLoc _JITOutbCallCompGrp JITOutbDestinationStorLoc Dest. Storage Loc
Material I_JITOutbCallCompMatl Material Vehicle Model
JITOutbPickedQuantity JITOutbPickedQuantity Picked Quantity
UnitOfMeasureNumberOfDecimals
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
QuantityUnit I_JITOutbCallCompMatl QuantityUnit Unit of measure
JITOutbTransferredQuantity JITOutbTransferredQuantity Transferred Qty
Responsible
PlannedOrder _JITOutbCallHeader JITPlannedOrderNumber JIT Planned Order
StorageBin _ControlCycle StorageBin Storage Bin
DestinationStorageBin _ControlCycle DestinationStorageBin
Supplier _ControlCycle Supplier Supplier
ProductName
_JITInternalStatus _JITInternalStatus
_UnitOfMeasures _UnitOfMeasures
_ProductCompMatl I_JITOutbCallCompMatl _ProductCompMatl
_JITCallType _JITOutbCallHeader _JITCallType
_JITLifecycleStatus _JITOutbCallHeader _JITLifecycleStatus
_Plant _JITOutbCallCompGrp _Plant
_StorageLocation _JITOutbCallCompGrp _StorageLocation
_UnitOfMeasure I_JITOutbCallCompMatl _UnitOfMeasure
JITProductionOrderNumber _JITOutbCallHeader JITProductionOrderNumber Order

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_JITOutbCalls.
-- 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: IJITOUTBCALLS

CREATE VIEW I_JITOutbCalls AS
SELECT
  _JITOutbCallCompMatl.InternalJITCallNumber AS InternalJITCallNumber,
  _JITOutbCallCompMatl.CompGrpNumber AS CompGrpNumber,
  _JITOutbCallCompMatl.JITCallItemNumber AS JITCallItemNumber,
  _JITOutbCallHeader.JITLifecycleStatus AS JITLifecycleStatus,
  _JITOutbCallHeader.CreationDateTime AS CreationDateTime,
  _JITOutbCallHeader.JITCallType AS JITCallType,
  _JITOutbCallCompGrp.Plant AS Plant,
  _JITOutbCallCompGrp.StorageLocation AS StorageLocation,
  _JITOutbCallCompGrp.RequirementDateTime AS RequirementDateTime,
  _JITOutbCallCompMatl.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITOutbCallCompGrp.ProductionSupplyArea AS ProductionSupplyArea,
  _JITOutbCallCompGrp.JITControlCycle AS JITControlCycle,
  _JITOutbCallCompGrp.JITOutbDestinationStorLoc AS JITOutbDestinationStorLoc,
  _JITOutbCallCompMatl.Material AS Material,
  JITOutbPickedQuantity,
  _JITOutbCallCompMatl._UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  RequestedQuantity,
  ActualDeliveredQuantity,
  _JITOutbCallCompMatl.QuantityUnit AS QuantityUnit,
  JITOutbTransferredQuantity,
  _JITOutbCallCompGrp._ProductionSupplyArea.ProductionSupplyAreaRespPerson AS Responsible,
  _JITOutbCallHeader.JITPlannedOrderNumber AS PlannedOrder,
  _ControlCycle.StorageBin AS StorageBin,
  _ControlCycle.DestinationStorageBin AS DestinationStorageBin,
  _ControlCycle.Supplier AS Supplier,
  _JITOutbCallCompMatl._ProductCompMatl._Text[1:Language = $session.system_language].ProductName AS ProductName,
  _JITOutbCallCompMatl._ProductCompMatl AS _ProductCompMatl,
  _JITOutbCallHeader._JITCallType AS _JITCallType,
  _JITOutbCallHeader._JITLifecycleStatus AS _JITLifecycleStatus,
  _JITOutbCallCompGrp._Plant AS _Plant,
  _JITOutbCallCompGrp._StorageLocation AS _StorageLocation,
  _JITOutbCallCompMatl._UnitOfMeasure AS _UnitOfMeasure,
  _JITOutbCallHeader.JITProductionOrderNumber AS JITProductionOrderNumber
FROM I_JITOutbCallCompMatl AS _JITOutbCallCompMatl
LEFT OUTER JOIN I_JITInternalStatus AS _JITInternalStatus ON JITIntProcessingStatus = _JITInternalStatus.JITIntProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasures ON QuantityUnit = _UnitOfMeasures.UnitOfMeasure  -- association [1..1]
;

Learn More