C_JITCallCompMatlBasicObjPg

DDL: C_JITCALLCOMPMATLBASICOBJPG SQL: CJITCOMPOBJPG Type: view CONSUMPTION
25 Fields 1 Data Sources 1 Associations

JIT Component Details in Object Page

C_JITCallCompMatlBasicObjPg is a Consumption CDS View that provides data about "JIT Component Details in Object Page" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompMaterialBasic) and exposes 25 fields with key field JITCallComponentUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompMaterialBasic I_JITCallCompMaterialBasic from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_JITSupplyControlHeader _JITSupplyControlHeader $projection.SupplyControlUUID = _JITSupplyControlHeader.SupplyControlUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CJITCOMPOBJPG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey JITCallComponentUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label JIT Component Details in Object Page view
UI.headerInfo.typeNamePlural Items view
UI.headerInfo.title.value Material view
UI.headerInfo.title.label Items view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY JITCallComponentUUID JITCallComponentUUID NodeID
JITCallCompGrpUUID JITCallCompGrpUUID NodeID
JITHeaderUUID JITHeaderUUID NodeID
SupplyControlUUID SupplyControlUUID NodeID
InternalJITCallNumber InternalJITCallNumber Internal JIT Call Number
CompGrpNumber CompGrpNumber Component Group No
JITCallItemNumber JITCallItemNumber Call Item Number
Material Material Component Material
ProductName
MaterialByCustomer MaterialByCustomer Customer Material
ExtJITCallItemNumber ExtJITCallItemNumber Extl Call Item No.
SalesOrder SalesOrder Sales Document
SalesOrderItem SalesOrderItem Sales Document Item
Division Division Internal Division ID
RequestedQuantity RequestedQuantity Requested Quantity
ActualDeliveredQuantity ActualDeliveredQuantity Delivered Quantity
QuantityUnit QuantityUnit Unit of measure
JITIntProcessingStatus JITIntProcessingStatus Internal Processing Status
MaterialGroup MaterialGroup Product Group
MaterialGroupName
JITUnderDeliveryToleranceInPct _JITSupplyControlHeader JITUnderDeliveryToleranceInPct Underdelivery Tolerance (%)
JITOverDeliveryToleranceInPct _JITSupplyControlHeader JITOverDeliveryToleranceInPct Overdelivery Tolerance (%)
_JITCallDocRefBasic _JITCallDocRefBasic
_JITSupplyControlHeader _JITSupplyControlHeader
_JITCallCompGroupBasic _JITCallCompGroupBasic

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 C_JITCallCompMatlBasicObjPg.
-- 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: CJITCOMPOBJPG

CREATE VIEW C_JITCallCompMatlBasicObjPg AS
SELECT
  JITCallComponentUUID,
  JITCallCompGrpUUID,
  JITHeaderUUID,
  SupplyControlUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITCallItemNumber,
  Material,
  _ProductCompMatl._Text[1: Language=$session.system_language].ProductName AS ProductName,
  MaterialByCustomer,
  ExtJITCallItemNumber,
  SalesOrder,
  SalesOrderItem,
  Division,
  RequestedQuantity,
  ActualDeliveredQuantity,
  QuantityUnit,
  JITIntProcessingStatus,
  MaterialGroup,
  _ProductCompMatl._ProductGroup._Text[1:Language=$session.system_language].MaterialGroupName AS MaterialGroupName,
  _JITSupplyControlHeader.JITUnderDeliveryToleranceInPct AS JITUnderDeliveryToleranceInPct,
  _JITSupplyControlHeader.JITOverDeliveryToleranceInPct AS JITOverDeliveryToleranceInPct
FROM I_JITCallCompMaterialBasic
LEFT OUTER JOIN I_JITSupplyControlHeader AS _JITSupplyControlHeader ON SupplyControlUUID = _JITSupplyControlHeader.SupplyControlUUID  -- association [0..1]
;

Learn More