I_JITOutbCallCompGrpEnhcd

DDL: I_JITOUTBCALLCOMPGRPENHCD SQL: IJITOUTBCOMPGRP Type: view COMPOSITE

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 29 fields with key fields JITCallCompGrpUUID, InternalJITCallNumber, CompGrpNumber, ParentDraftKey. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCallCompGrp _JITOutbCallCompGrp from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_JITLifecycleStatus _JITLifecycleStatus $projection.jitlifecyclestatus = _JITLifecycleStatus.JITLifecycleStatus

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 (29)

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
ReplenishmentStrategy
ProductName ProductName Description
_JITInternalStatus I_JITOutbCallCompGrp _JITInternalStatus
_JITLifecycleStatus _JITLifecycleStatus
_JITControlCycle I_JITOutbCallCompGrp _JITControlCycle
_ProductCompGrp _ProductCompGrp
_JITOutbCallHeader _JITOutbCallHeader
_Plant _Plant
_ProductionSupplyArea _ProductionSupplyArea

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.ReplenishmentStrategy AS ReplenishmentStrategy,
  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]
;