C_JITCallCompGrpItmRelToProdn

DDL: C_JITCALLCOMPGRPITMRELTOPRODN Type: view_entity CONSUMPTION Package: NJIT_APP_RELTOPRODN_SUMJC
22 Fields 1 Data Sources 2 Associations

Component Grp Item R2P: Consumption View

C_JITCallCompGrpItmRelToProdn is a Consumption CDS View that provides data about "Component Grp Item R2P: Consumption View" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompGrpRelToProdn) and exposes 22 fields with key field JITCallComponentUUID. It has 2 associations to related views. Part of development package NJIT_APP_RELTOPRODN_SUMJC.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompGrpRelToProdn I_JITCallCompGrpRelToProdn from

Associations (2)

CardinalityTargetAliasCondition
[0..1] E_JITCompGroup _JITCompGroupExtension $projection.InternalJITCallNumber = _JITCompGroupExtension.InternalJITCallNumber and $projection.CompGrpNumber = _JITCompGroupExtension.CompGrpNumber
[0..1] C_JITInternalStatusVH _JITInternalStatusVH $projection.JITIntProcessingStatus = _JITInternalStatusVH.JITIntProcessingStatus

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Component Grp Item R2P: Consumption View view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Release to Production: Summarized call view
UI.headerInfo.typeNamePlural Component Group view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value CompGrpMatl view
VDM.viewType #CONSUMPTION view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY JITCallComponentUUID JITCallComponentUUID NodeID
JITCallCompGrpUUID JITCallCompGrpUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpNumber CompGrpNumber Component Group No.
CompGrpMatl CompGrpMatl Comp. Group Matl.
JITHeaderUUID JITHeaderUUID NodeID
Plant Plant Valuation Area
ShippingPoint ShippingPoint Shipping Point
ShipToParty ShipToParty Ship-To-Party
CustomerName CustomerName Name of Customer
JITIntProcessingStatus Internal Processing Status
JITInternalStatusText _JITInternalStatusVH JITInternalStatusText
CustSupplyArea CustSupplyArea Customer Supply Area
SupplyAreaDesc
PlannedShippingDateTime PlannedShippingDateTime Planned delivery date and time
ProductionEndDate ProductionEndDate Production End Date
ProductionVersion ProductionVersion Production Version
UnloadingPointName UnloadingPointName Unloading Point
_JITCallHeaderBasic _JITCallHeaderBasic
_Plant _Plant
_ShippingPoint _ShippingPoint
_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_JITCallCompGrpItmRelToProdn.
-- 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 C_JITCallCompGrpItmRelToProdn AS
SELECT
  JITCallComponentUUID,
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  CompGrpMatl,
  JITHeaderUUID,
  Plant,
  ShippingPoint,
  ShipToParty,
  CustomerName,
  / / JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITInternalStatusVH.JITInternalStatusText AS JITInternalStatusText,
  CustSupplyArea,
  _JITCustSupplyArea._JITCustomerSupplyAreaDesc[1: Language=$session.system_language].SupplyAreaDesc AS SupplyAreaDesc,
  PlannedShippingDateTime,
  ProductionEndDate,
  ProductionVersion,
  UnloadingPointName
FROM I_JITCallCompGrpRelToProdn
LEFT OUTER JOIN E_JITCompGroup AS _JITCompGroupExtension ON InternalJITCallNumber = _JITCompGroupExtension.InternalJITCallNumber AND CompGrpNumber = _JITCompGroupExtension.CompGrpNumber  -- association [0..1]
LEFT OUTER JOIN C_JITInternalStatusVH AS _JITInternalStatusVH ON JITIntProcessingStatus = _JITInternalStatusVH.JITIntProcessingStatus  -- association [0..1]
;

Learn More