I_JITCallCompGroupCube

DDL: I_JITCALLCOMPGROUPCUBE Type: view_entity COMPOSITE Package: NJIT_APP_REUSE_LIBRARY
63 Fields 1 Data Sources 3 Associations

JIT Call Component Group - Cube

I_JITCallCompGroupCube is a Composite CDS View (Cube) that provides data about "JIT Call Component Group - Cube" in SAP S/4HANA. It reads from 1 data source (I_JITInbCallComponentGroup) and exposes 63 fields with key field JITCallCompGrpUUID. It has 3 associations to related views. Part of development package NJIT_APP_REUSE_LIBRARY.

Data Sources (1)

SourceAliasJoin Type
I_JITInbCallComponentGroup I_JITInbCallComponentGroup from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_JITCallCompGrpRefTextEnhcd _JITCallCompGrpRefTextEnhcd $projection.JITCallCompGrpUUID = _JITCallCompGrpRefTextEnhcd.JITObjectUUID
[0..1] I_JITCallHdrRefTextEnhcd _JITCallHdrRefTextEnhcd $projection.JITHeaderUUID = _JITCallHdrRefTextEnhcd.JITObjectUUID
[1..1] I_JITCompGrpEnhanced _JITCompGrpEnhanced $projection.JITCallCompGrpUUID = _JITCompGrpEnhanced.JITCallCompGrpUUID

Annotations (12)

NameValueLevelField
Analytics.dataCategory #CUBE view
Analytics.technicalName IJITCALLCGCUBE view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT Call Component Group - Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpNumber CompGrpNumber Component Group No.
CompGrpMatl CompGrpMatl Comp. Group Matl.
ExtCompGrpNumber ExtCompGrpNumber Extl Comp. Group No.
CustCompGrpMatl CustCompGrpMatl Cust Comp. Grp. Matl
JITExtSequenceNumber JITExtSequenceNumber Ext.Seq. Number
Plant Plant Valuation Area
CustSupplyArea CustSupplyArea Cust. Supply Area
UnloadingPointName UnloadingPointName Unloading Point Name
CustAssemblyLoc CustAssemblyLoc Assembly Location
ShippingPoint ShippingPoint Shipping Point
StorageLocation StorageLocation StorageLocation
WarehouseNumber WarehouseNumber Whse Number
SupplyControlUUID SupplyControlUUID NodeID
SupplyControlID SupplyControlID Supply Control ID
JITDelivSqncGrpUUID JITDelivSqncGrpUUID NodeID
JITActionCtrl JITActionCtrl Action Control
ProductionVersion ProductionVersion Version ID
JITSuperPckgGrpUUID JITSuperPckgGrpUUID NodeID
TransmittedExtStatusByMfr TransmittedExtStatusByMfr Transmitted Status
JITExtStatusAtSupplier JITExtStatusAtSupplier External Status
JITIntProcessingStatus JITIntProcessingStatus Transmitted Status
DeliveryStatus DeliveryStatus Delivery Status
PickingStatus PickingStatus Status Value
JITCompGrpDocPckgGrpSts JITCompGrpDocPckgGrpSts Package Group Status
JITCompGrpDocRelToProdnSts JITCompGrpDocRelToProdnSts R2PStatus
JITCompGrpDocConfToProdnSts JITCompGrpDocConfToProdnSts Confirm Prod. Status
GoodsMovementStatus GoodsMovementStatus Gds Movemt Status
DeliveryCreationDate DeliveryCreationDate Delivery Date
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
RequestedDeliveryTime RequestedDeliveryTime Req. dely time
ProductionStartDate ProductionStartDate Start of Production
PlannedShippingDateTime PlannedShippingDateTime Pl. Shippg Date Time
RequirementDateTime RequirementDateTime Time Stamp
MaterialAvailabilityDate MaterialAvailabilityDate Mat.Avail.Date
MaterialAvailabilityTime MaterialAvailabilityTime Matl Staging Tme
ActualShippingDateTime ActualShippingDateTime Actl Shppg Date Time
JITIntStatusUpdtdOn JITIntStatusUpdtdOn Int Status Updtd On
JITExtStatusUpdtdOn JITExtStatusUpdtdOn Ext. Status Updtd
NumberOfItems
_JITInboundCall _JITInboundCall
_JITInbCallComponent _JITInbCallComponent
_JITCallHdrRefTextEnhcd _JITCallHdrRefTextEnhcd
_JITCallCompGrpRefTextEnhcd _JITCallCompGrpRefTextEnhcd
_JITCompGrpEnhanced _JITCompGrpEnhanced
_Plant _Plant
_ShippingPoint _ShippingPoint
_ProductionVersion _ProductionVersion
_StorageLocation _StorageLocation
_ProductCompGrp _ProductCompGrp
_JITSupplyControlHeader _JITSupplyControlHeader
_JITDelivSqncGrpHeaderBasic _JITDelivSqncGrpHeaderBasic
_JITPckgGrpHeader _JITPckgGrpHeader
_JITPckgGrpItemRef _JITPckgGrpItemRef
_JITInternalStatus _JITInternalStatus
_SupplierExtStatus _SupplierExtStatus
_JITPackingGrpCreationStatus _JITPackingGrpCreationStatus
_JITDeliveryStatus _JITDeliveryStatus
_JITGoodsMovementStatus _JITGoodsMovementStatus
_JITReleaseToProductionStatus _JITReleaseToProductionStatus
_JITProdnConfirmationStatus _JITProdnConfirmationStatus

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_JITCallCompGroupCube.
-- 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_JITCallCompGroupCube AS
SELECT
  JITCallCompGrpUUID,
  JITHeaderUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  CompGrpMatl,
  ExtCompGrpNumber,
  CustCompGrpMatl,
  JITExtSequenceNumber,
  Plant,
  CustSupplyArea,
  UnloadingPointName,
  CustAssemblyLoc,
  ShippingPoint,
  StorageLocation,
  WarehouseNumber,
  SupplyControlUUID,
  SupplyControlID,
  JITDelivSqncGrpUUID,
  JITActionCtrl,
  ProductionVersion,
  JITSuperPckgGrpUUID,
  TransmittedExtStatusByMfr,
  JITExtStatusAtSupplier,
  JITIntProcessingStatus,
  DeliveryStatus,
  PickingStatus,
  JITCompGrpDocPckgGrpSts,
  JITCompGrpDocRelToProdnSts,
  JITCompGrpDocConfToProdnSts,
  GoodsMovementStatus,
  DeliveryCreationDate,
  RequestedDeliveryDate,
  RequestedDeliveryTime,
  ProductionStartDate,
  PlannedShippingDateTime,
  RequirementDateTime,
  MaterialAvailabilityDate,
  MaterialAvailabilityTime,
  ActualShippingDateTime,
  JITIntStatusUpdtdOn,
  JITExtStatusUpdtdOn,
  cast(1 as abap.int4) AS NumberOfItems
FROM I_JITInbCallComponentGroup
LEFT OUTER JOIN I_JITCallCompGrpRefTextEnhcd AS _JITCallCompGrpRefTextEnhcd ON JITCallCompGrpUUID = _JITCallCompGrpRefTextEnhcd.JITObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCallHdrRefTextEnhcd AS _JITCallHdrRefTextEnhcd ON JITHeaderUUID = _JITCallHdrRefTextEnhcd.JITObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCompGrpEnhanced AS _JITCompGrpEnhanced ON JITCallCompGrpUUID = _JITCompGrpEnhanced.JITCallCompGrpUUID  -- association [1..1]
;

Learn More