I_JITCallCompMatlCube

DDL: I_JITCALLCOMPMATLCUBE Type: view_entity COMPOSITE
30 Fields 1 Data Sources 1 Associations

Monitor JIT Call Component - Cube

I_JITCallCompMatlCube is a Composite CDS View (Cube) that provides data about "Monitor JIT Call Component - Cube" in SAP S/4HANA. It reads from 1 data source (I_JITInbCallComponent) and exposes 30 fields with key field JITCallComponentUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITInbCallComponent I_JITInbCallComponent from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_JITCompGrpEnhanced _JITCallCompGrpEnhanced $projection.JITCallCompGrpUUID = _JITCallCompGrpEnhanced.JITCallCompGrpUUID

Annotations (10)

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

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY JITCallComponentUUID JITCallComponentUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpNumber CompGrpNumber Component Group No.
JITCallItemNumber JITCallItemNumber Call Item Number
JITCallCompGrpUUID JITCallCompGrpUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
Material Material Vehicle Model
MaterialByCustomer MaterialByCustomer Customer Mat.
ExtJITCallItemNumber ExtJITCallItemNumber Extl Call Item No.
SalesSchedulingAgreement SalesSchedulingAgreement Sales Document
SalesSchedulingAgreementItem SalesSchedulingAgreementItem Item
Division Division Internal Division ID
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
QuantityUnit QuantityUnit Unit of measure
JITCallCompMatlBackflushStatus JITCallCompMatlBackflushStatus BackFlush Status
JITCallCompMatlBackflushType JITCallCompMatlBackflushType BackFlush Type
JITCallCompBackflushStsUpdtdOn JITCallCompBackflushStsUpdtdOn BFlsh Status Updt On
NumberOfComponents
_JITInboundCall _JITInboundCall
_JITInbCallComponentGroup _JITInbCallComponentGroup
_JITCallCompGrpEnhanced _JITCallCompGrpEnhanced
_JITCallCompMatlRefTextEnhcd _JITCallCompMatlRefTextEnhcd
_JITCallCompGrpRefTextEnhcd _JITCallCompGrpRefTextEnhcd
_JITCallHdrRefTextEnhcd _JITCallHdrRefTextEnhcd
_SalesSchedgAgrmt _SalesSchedgAgrmt
_SalesSchedgAgrmtItem _SalesSchedgAgrmtItem
_Division _Division
_JITBackflushStatus _JITBackflushStatus
_ProductCompMatl _ProductCompMatl

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_JITCallCompMatlCube.
-- 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_JITCallCompMatlCube AS
SELECT
  JITCallComponentUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  JITCallCompGrpUUID,
  JITHeaderUUID,
  Material,
  MaterialByCustomer,
  ExtJITCallItemNumber,
  SalesSchedulingAgreement,
  SalesSchedulingAgreementItem,
  Division,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  JITCallCompMatlBackflushStatus,
  JITCallCompMatlBackflushType,
  JITCallCompBackflushStsUpdtdOn,
  cast(1 as abap.int4) AS NumberOfComponents
FROM I_JITInbCallComponent
LEFT OUTER JOIN I_JITCompGrpEnhanced AS _JITCallCompGrpEnhanced ON JITCallCompGrpUUID = _JITCallCompGrpEnhanced.JITCallCompGrpUUID  -- association [0..1]
;

Learn More