I_JITControlCycleActiveCall

DDL: I_JITCONTROLCYCLEACTIVECALL Type: view_entity COMPOSITE

Active JIT Calls for the Control Cycle

I_JITControlCycleActiveCall is a Composite CDS View that provides data about "Active JIT Calls for the Control Cycle" in SAP S/4HANA. It reads from 2 data sources (I_JITOutbCallComponentGroupDet, I_JITOutbCallCompQtyByCompGrp) and exposes 48 fields with key field JITCallCompGrpUUID.

Data Sources (2)

SourceAliasJoin Type
I_JITOutbCallComponentGroupDet _JITOutbCallComponentGroupDet from
I_JITOutbCallCompQtyByCompGrp _JITOutbCallCompQtyByCompGrp inner

Annotations (7)

NameValueLevelField
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Active JIT Calls for the Control Cycle view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID I_JITOutbCallComponentGroupDet JITCallCompGrpUUID NodeID
ParentDraftKey I_JITOutbCallComponentGroupDet JITHeaderUUID NodeID
InternalJITCallNumber I_JITOutbCallComponentGroupDet InternalJITCallNumber JIT Call Number
CompGrpNumber I_JITOutbCallComponentGroupDet CompGrpNumber Component Group No.
ExtCompGrpNumber I_JITOutbCallComponentGroupDet ExtCompGrpNumber Extl Comp. Group No.
CompGrpMatl I_JITOutbCallComponentGroupDet CompGrpMatl Comp. Group Matl.
RequirementDateTime I_JITOutbCallComponentGroupDet RequirementDateTime Time Stamp
JITSupplyDateTime I_JITOutbCallComponentGroupDet JITSupplyDateTime Supply Date & Time
Plant I_JITOutbCallComponentGroupDet Plant Valuation Area
UnloadingPointName I_JITOutbCallComponentGroupDet UnloadingPointName Unloading Point Name
JITActionCtrl I_JITOutbCallComponentGroupDet JITActionCtrl Action Control
StorageLocation I_JITOutbCallComponentGroupDet StorageLocation StorageLocation
EWMWarehouse I_JITOutbCallComponentGroupDet EWMWarehouse Warehouse No.
JITSourceWarehouseNumber I_JITOutbCallComponentGroupDet JITSourceWarehouseNumber Source Warehouse No.
JITControlCycle I_JITOutbCallComponentGroupDet JITControlCycle Control Cycle
ProductionSupplyArea I_JITOutbCallComponentGroupDet ProductionSupplyArea Supply Area
JITOutbDestinationStorLoc I_JITOutbCallComponentGroupDet JITOutbDestinationStorLoc Dest. Storage Loc
ReferenceJITComponentGroupUUID I_JITOutbCallComponentGroupDet ReferenceJITComponentGroupUUID Ref Comp Grp UUID
JITIntProcessingStatus I_JITOutbCallComponentGroupDet JITIntProcessingStatus Transmitted Status
JITIntStatusUpdtdOnDteTme I_JITOutbCallComponentGroupDet JITIntStatusUpdtdOnDteTme Int Status Updtd On
DeliveryStatus I_JITOutbCallComponentGroupDet DeliveryStatus Delivery Status
PickingStatus I_JITOutbCallComponentGroupDet PickingStatus Status Value
GoodsMovementStatus I_JITOutbCallComponentGroupDet GoodsMovementStatus Gds Movemt Status
JITOutbStockTransferSts I_JITOutbCallComponentGroupDet JITOutbStockTransferSts Stock Trnsfr Status
JITDeliveryDateTime I_JITOutbCallComponentGroupDet JITDeliveryDateTime Delivery Date Time
JITCompGroupMessageStatus I_JITOutbCallComponentGroupDet JITCompGroupMessageStatus JIT Msg Is Transm
JITCompGrpIntSequenceNumber I_JITOutbCallComponentGroupDet JITCompGrpIntSequenceNumber Internal Sequence No
JITLifecycleStatus
JITLifecycleStatusText
CreatedByUser
CreationDateTime
JITMissingPartFlag
JITMaterialStockMissingText
JITInternalStatusText
JITStockTransferStsText
RequestedQuantity I_JITOutbCallCompQtyByCompGrp RequestedQuantity Requested Quantity
QuantityUnit I_JITOutbCallCompQtyByCompGrp QuantityUnit Unit of measure
_JITControlCycle I_JITOutbCallComponentGroupDet _JITControlCycle
_JITDeliveryStatus I_JITOutbCallComponentGroupDet _JITDeliveryStatus
_JITGoodsMovementStatus I_JITOutbCallComponentGroupDet _JITGoodsMovementStatus
_JITInternalStatus I_JITOutbCallComponentGroupDet _JITInternalStatus
_JITOutbCallComponent I_JITOutbCallComponentGroupDet _JITOutbCallComponent
_JITOutboundCall I_JITOutbCallComponentGroupDet _JITOutboundCall
_JITPlant I_JITOutbCallComponentGroupDet _JITPlant
_JITStockTransferSts I_JITOutbCallComponentGroupDet _JITStockTransferSts
_ProductCompGrp I_JITOutbCallComponentGroupDet _ProductCompGrp
_ProductionSupplyArea I_JITOutbCallComponentGroupDet _ProductionSupplyArea
_StorageLocation I_JITOutbCallComponentGroupDet _StorageLocation

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_JITControlCycleActiveCall.
-- 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_JITControlCycleActiveCall AS
SELECT
  _JITOutbCallComponentGroupDet.JITCallCompGrpUUID AS JITCallCompGrpUUID,
  _JITOutbCallComponentGroupDet.JITHeaderUUID AS ParentDraftKey,
  _JITOutbCallComponentGroupDet.InternalJITCallNumber AS InternalJITCallNumber,
  _JITOutbCallComponentGroupDet.CompGrpNumber AS CompGrpNumber,
  _JITOutbCallComponentGroupDet.ExtCompGrpNumber AS ExtCompGrpNumber,
  _JITOutbCallComponentGroupDet.CompGrpMatl AS CompGrpMatl,
  _JITOutbCallComponentGroupDet.RequirementDateTime AS RequirementDateTime,
  _JITOutbCallComponentGroupDet.JITSupplyDateTime AS JITSupplyDateTime,
  _JITOutbCallComponentGroupDet.Plant AS Plant,
  _JITOutbCallComponentGroupDet.UnloadingPointName AS UnloadingPointName,
  _JITOutbCallComponentGroupDet.JITActionCtrl AS JITActionCtrl,
  _JITOutbCallComponentGroupDet.StorageLocation AS StorageLocation,
  _JITOutbCallComponentGroupDet.EWMWarehouse AS EWMWarehouse,
  _JITOutbCallComponentGroupDet.JITSourceWarehouseNumber AS JITSourceWarehouseNumber,
  _JITOutbCallComponentGroupDet.JITControlCycle AS JITControlCycle,
  _JITOutbCallComponentGroupDet.ProductionSupplyArea AS ProductionSupplyArea,
  _JITOutbCallComponentGroupDet.JITOutbDestinationStorLoc AS JITOutbDestinationStorLoc,
  _JITOutbCallComponentGroupDet.ReferenceJITComponentGroupUUID AS ReferenceJITComponentGroupUUID,
  _JITOutbCallComponentGroupDet.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITOutbCallComponentGroupDet.JITIntStatusUpdtdOnDteTme AS JITIntStatusUpdtdOnDteTme,
  _JITOutbCallComponentGroupDet.DeliveryStatus AS DeliveryStatus,
  _JITOutbCallComponentGroupDet.PickingStatus AS PickingStatus,
  _JITOutbCallComponentGroupDet.GoodsMovementStatus AS GoodsMovementStatus,
  _JITOutbCallComponentGroupDet.JITOutbStockTransferSts AS JITOutbStockTransferSts,
  _JITOutbCallComponentGroupDet.JITDeliveryDateTime AS JITDeliveryDateTime,
  _JITOutbCallComponentGroupDet.JITCompGroupMessageStatus AS JITCompGroupMessageStatus,
  _JITOutbCallComponentGroupDet.JITCompGrpIntSequenceNumber AS JITCompGrpIntSequenceNumber,
  _JITOutbCallComponentGroupDet._JITOutboundCall.JITLifecycleStatus AS JITLifecycleStatus,
  _JITOutbCallComponentGroupDet._JITOutboundCall._JITLifecycleStatus._Text[1: Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  _JITOutbCallComponentGroupDet._JITOutboundCall.CreatedByUser AS CreatedByUser,
  _JITOutbCallComponentGroupDet._JITOutboundCall.CreationDateTime AS CreationDateTime,
  _JITOutbCallComponentGroupDet._JITOutboundCall.JITMissingPartFlag AS JITMissingPartFlag,
  _JITOutbCallComponentGroupDet._JITOutboundCall._JITOutbMissingPartFlag._Text[1: Language = $session.system_language].JITMaterialStockMissingText AS JITMaterialStockMissingText,
  _JITOutbCallComponentGroupDet._JITInternalStatus._Text[1: Language = $session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITOutbCallComponentGroupDet._JITStockTransferSts._Text[1: Language = $session.system_language].JITStockTransferStsText AS JITStockTransferStsText,
  _JITOutbCallCompQtyByCompGrp.RequestedQuantity AS RequestedQuantity,
  _JITOutbCallCompQtyByCompGrp.QuantityUnit AS QuantityUnit,
  _JITOutbCallComponentGroupDet._JITControlCycle AS _JITControlCycle,
  _JITOutbCallComponentGroupDet._JITDeliveryStatus AS _JITDeliveryStatus,
  _JITOutbCallComponentGroupDet._JITGoodsMovementStatus AS _JITGoodsMovementStatus,
  _JITOutbCallComponentGroupDet._JITInternalStatus AS _JITInternalStatus,
  _JITOutbCallComponentGroupDet._JITOutbCallComponent AS _JITOutbCallComponent,
  _JITOutbCallComponentGroupDet._JITOutboundCall AS _JITOutboundCall,
  _JITOutbCallComponentGroupDet._JITPlant AS _JITPlant,
  _JITOutbCallComponentGroupDet._JITStockTransferSts AS _JITStockTransferSts,
  _JITOutbCallComponentGroupDet._ProductCompGrp AS _ProductCompGrp,
  _JITOutbCallComponentGroupDet._ProductionSupplyArea AS _ProductionSupplyArea,
  _JITOutbCallComponentGroupDet._StorageLocation AS _StorageLocation
FROM I_JITOutbCallComponentGroupDet AS _JITOutbCallComponentGroupDet
INNER JOIN I_JITOutbCallCompQtyByCompGrp AS _JITOutbCallCompQtyByCompGrp ON /* join condition not captured in parsed metadata */
;