I_JITOutbCallCompGrpEnhcd

DDL: I_JITOUTBCALLCOMPGRPENHCD SQL: IJITOUTBCOMPGRP Type: view COMPOSITE
37 Fields 1 Data Sources 8 Associations

Outbound JIT Component Groups

I_JITOutbCallCompGrpEnhcd is a Composite CDS View that provides data about "Outbound JIT Component Groups" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCallCompGrp) and exposes 37 fields with key fields JITCallCompGrpUUID, InternalJITCallNumber, CompGrpNumber, ParentDraftKey. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallCompGrp _JITOutbCallCompGrp from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_JITLifecycleStatus _JITLifecycleStatus $projection.jitlifecyclestatus = _JITLifecycleStatus.JITLifecycleStatus
[0..1] I_JITOutbSqncMntrSupplierVH _JITOutbSqncMntrSupplierVH $projection.activesupplier = _JITOutbSqncMntrSupplierVH.Supplier
[0..1] I_JITOutbMntrWarehouseVH _JITOutbWarehouse $projection.EWMWarehouse = _JITOutbWarehouse.EWMWarehouse
[0..1] I_JITOutbActionControlVH _JITOutbActionControlVH $projection.JITActionCtrl = _JITOutbActionControlVH.JITActionCtrl
[0..1] I_JITOutbMntrReplnmtStrgyVH _JITOutbMntrReplnmtStrgyVH $projection.replenishmentstrategy = _JITOutbMntrReplnmtStrgyVH.JITReplenishmentStrategy
[0..1] I_JITOutbMntrDestStorLocVH _JITOutbMntrDestStorLocVH $projection.JITOutbDestinationStorLoc = _JITOutbMntrDestStorLocVH.StorageLocation
[0..1] I_JITOutbMntrSrceStorLocVH _JITOutbSrceStorageLocVH $projection.issuingorreceivingstorageloc = _JITOutbSrceStorageLocVH.IssuingOrReceivingStorageLoc
[0..1] I_JITOutbDestStorLocBinVH _JITOutbDestStorLocBinVH $projection.destinationstoragebin = _JITOutbDestStorLocBinVH.DestinationStorageBin

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IJITOUTBCOMPGRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Outbound JIT Component Groups view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID
KEY InternalJITCallNumber InternalJITCallNumber JIT Call Number
KEY CompGrpNumber CompGrpNumber Component Group No.
KEY ParentDraftKey ParentDraftKey NodeID
ActiveSupplier
VehicleModel
JITLifecycleStatus
JITIntProcessingStatus I_JITOutbCallCompGrp JITIntProcessingStatus Transmitted Status
Plant I_JITOutbCallCompGrp Plant Valuation Area
ProductionSupplyArea I_JITOutbCallCompGrp ProductionSupplyArea Supply Area
JITActionCtrl I_JITOutbCallCompGrp JITActionCtrl Action Control
RequirementDateTime Time Stamp
JITControlCycle I_JITOutbCallCompGrp JITControlCycle Control Cycle
Responsible _ProductionSupplyArea ProductionSupplyAreaRespPerson
JITOutbDestinationStorLoc JITOutbDestinationStorLoc Dest. Storage Loc
CompGrpMatl I_JITOutbCallCompGrp CompGrpMatl Comp. Group Matl.
EWMWarehouse WarehouseNumber Warehouse No.
IssuingOrReceivingStorageLoc
StorageType
StorageBin
DestinationStorageBin
ReplenishmentStrategy
ProductName
_JITInternalStatus I_JITOutbCallCompGrp _JITInternalStatus
_JITLifecycleStatus _JITLifecycleStatus
_JITControlCycle I_JITOutbCallCompGrp _JITControlCycle
_ProductCompGrp _ProductCompGrp
_JITOutbCallHeader _JITOutbCallHeader
_Plant _Plant
_ProductionSupplyArea _ProductionSupplyArea
_JITOutbSqncMntrSupplierVH _JITOutbSqncMntrSupplierVH
_JITOutbMntrDestStorLocVH _JITOutbMntrDestStorLocVH
_JITOutbWarehouse _JITOutbWarehouse
_JITOutbActionControlVH _JITOutbActionControlVH
_JITOutbMntrReplnmtStrgyVH _JITOutbMntrReplnmtStrgyVH
_JITOutbSrceStorageLocVH _JITOutbSrceStorageLocVH
_JITOutbDestStorLocBinVH _JITOutbDestStorLocBinVH

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_JITOutbCallCompGrpEnhcd.
-- 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: IJITOUTBCOMPGRP

CREATE VIEW I_JITOutbCallCompGrpEnhcd AS
SELECT
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  ParentDraftKey,
  _JITOutbCallCompGrp._JITOutbCallHeader.ActiveSupplier AS ActiveSupplier,
  _JITOutbCallCompGrp._JITOutbCallHeader.VehicleModel AS VehicleModel,
  _JITOutbCallCompGrp._JITOutbCallHeader.JITLifecycleStatus AS JITLifecycleStatus,
  _JITOutbCallCompGrp.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITOutbCallCompGrp.Plant AS Plant,
  _JITOutbCallCompGrp.ProductionSupplyArea AS ProductionSupplyArea,
  _JITOutbCallCompGrp.JITActionCtrl AS JITActionCtrl,
  cast( RequirementDateTime as /bofu/tstmp_creation_time ) AS RequirementDateTime,
  _JITOutbCallCompGrp.JITControlCycle AS JITControlCycle,
  _ProductionSupplyArea.ProductionSupplyAreaRespPerson AS Responsible,
  JITOutbDestinationStorLoc,
  _JITOutbCallCompGrp.CompGrpMatl AS CompGrpMatl,
  WarehouseNumber AS EWMWarehouse,
  _JITOutbCallCompGrp._JITControlCycle.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  _JITOutbCallCompGrp._JITControlCycle.StorageType AS StorageType,
  _JITOutbCallCompGrp._JITControlCycle.StorageBin AS StorageBin,
  _JITOutbCallCompGrp._JITControlCycle.DestinationStorageBin AS DestinationStorageBin,
  _JITOutbCallCompGrp._JITControlCycle.ReplenishmentStrategy AS ReplenishmentStrategy,
  _JITOutbCallCompGrp._ProductCompGrp._Text[1:Language = $session.system_language].ProductName AS ProductName,
  _JITOutbCallCompGrp._JITInternalStatus AS _JITInternalStatus,
  _JITOutbCallCompGrp._JITControlCycle AS _JITControlCycle
FROM I_JITOutbCallCompGrp AS _JITOutbCallCompGrp
LEFT OUTER JOIN I_JITLifecycleStatus AS _JITLifecycleStatus ON jitlifecyclestatus = _JITLifecycleStatus.JITLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_JITOutbSqncMntrSupplierVH AS _JITOutbSqncMntrSupplierVH ON activesupplier = _JITOutbSqncMntrSupplierVH.Supplier  -- association [0..1]
LEFT OUTER JOIN I_JITOutbMntrWarehouseVH AS _JITOutbWarehouse ON EWMWarehouse = _JITOutbWarehouse.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_JITOutbActionControlVH AS _JITOutbActionControlVH ON JITActionCtrl = _JITOutbActionControlVH.JITActionCtrl  -- association [0..1]
LEFT OUTER JOIN I_JITOutbMntrReplnmtStrgyVH AS _JITOutbMntrReplnmtStrgyVH ON replenishmentstrategy = _JITOutbMntrReplnmtStrgyVH.JITReplenishmentStrategy  -- association [0..1]
LEFT OUTER JOIN I_JITOutbMntrDestStorLocVH AS _JITOutbMntrDestStorLocVH ON JITOutbDestinationStorLoc = _JITOutbMntrDestStorLocVH.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_JITOutbMntrSrceStorLocVH AS _JITOutbSrceStorageLocVH ON issuingorreceivingstorageloc = _JITOutbSrceStorageLocVH.IssuingOrReceivingStorageLoc  -- association [0..1]
LEFT OUTER JOIN I_JITOutbDestStorLocBinVH AS _JITOutbDestStorLocBinVH ON destinationstoragebin = _JITOutbDestStorLocBinVH.DestinationStorageBin  -- association [0..1]
;

Learn More