I_JITCallCompGrpRelToProdn

DDL: I_JITCALLCOMPGRPRELTOPRODN Type: view_entity COMPOSITE
50 Fields 1 Data Sources 3 Associations

JIT Release To Production

I_JITCallCompGrpRelToProdn is a Composite CDS View that provides data about "JIT Release To Production" in SAP S/4HANA. It reads from 1 data source (I_JITInbCallComponent) and exposes 50 fields with key field JITCallComponentUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITInbCallComponent I_JITInbCallComponent from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.plant = _Plant.Plant
[0..1] I_JITInbCallComponent _JITInbCallComponent $projection.JITCallComponentUUID = _JITInbCallComponent.JITCallComponentUUID
[0..1] I_JITCustomerSupplyArea _JITCustSupplyArea $projection.shiptoparty = _JITCustSupplyArea.ShipToParty and $projection.custsupplyarea = _JITCustSupplyArea.CustSupplyArea and $projection.unloadingpointname = _JITCustSupplyArea.UnloadingPointName

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT Release To Production view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY JITCallComponentUUID JITCallComponentUUID NodeID
JITCallCompGrpUUID JITCallCompGrpUUID NodeID
InternalJITCallNumber InternalJITCallNumber JIT Call Number
CompGrpNumber CompGrpNumber Component Group No.
JITHeaderUUID JITHeaderUUID NodeID
ProductName
RequestedQuantity RequestedQuantity Requested Quantity
QuantityUnit QuantityUnit Unit of measure
CompGrpMatl _JITInbCallComponentGroup CompGrpMatl Comp. Group Matl.
RequirementDateTime _JITInbCallComponentGroup RequirementDateTime Time Stamp
MaterialAvailabilityDateTime
Plant _JITInbCallComponentGroup Plant Valuation Area
PlantName
UnloadingPointName _JITInbCallComponentGroup UnloadingPointName Unloading Point Name
CustSupplyArea _JITInbCallComponentGroup CustSupplyArea Cust. Supply Area
JITActionCtrl _JITInbCallComponentGroup JITActionCtrl Action Control
JITIntProcessingStatus _JITInbCallComponentGroup JITIntProcessingStatus Transmitted Status
JITExtStatusAtSupplier _JITInbCallComponentGroup JITExtStatusAtSupplier External Status
PlannedShippingDateTime _JITInbCallComponentGroup PlannedShippingDateTime Pl. Shippg Date Time
ProductionStartDate _JITInbCallComponentGroup ProductionStartDate Start of Production
JITExternalStatusText
ProductionEndDate _JITInbCallComponentGroup ProductionEndDate Production End Date
JITInternalStatusText
ProductionVersion _JITInbCallComponentGroup ProductionVersion Version ID
ProductionVersionText
ProductionLine
SupplyControlUUID _JITInbCallComponentGroup SupplyControlUUID NodeID
ShippingPoint _JITInbCallComponentGroup ShippingPoint Shipping Point
StorageLocation _JITInbCallComponentGroup StorageLocation StorageLocation
RepetitiveManufacturingIsAllwd
CustAssemblyLoc _JITInbCallComponentGroup CustAssemblyLoc Assembly Location
ShipToParty _JITInboundCall ShipToParty Ship-To Party (obsolete)
CustomerName
ExternalJITCallNumber _JITInboundCall ExternalJITCallNumber Ext. JIT Call Number
JITCallTypeText
JITLifecycleStatusText
MatlUsageIndicatorText
JITCallType _JITInboundCall JITCallType Call Type
_JITCallCompMaterialBasic _JITInbCallComponent
_JITCallHeaderBasic _JITInboundCall
_JITCallCompGroupBasic _JITInbCallComponentGroup
_JITCustSupplyArea _JITCustSupplyArea
_JITInternalStatus _JITInbCallComponentGroup _JITInternalStatus
_JITSupplyControlHeader _JITInbCallComponentGroup _JITSupplyControlHeader
_Plant _Plant
_ProductCompGrp _JITInbCallComponentGroup _ProductCompGrp
_ShippingPoint _JITInbCallComponentGroup _ShippingPoint
_StorageLocation _JITInbCallComponentGroup _StorageLocation
_SupplierExtStatus _JITInbCallComponentGroup _SupplierExtStatus
_ProductionVersion _JITInbCallComponentGroup _ProductionVersion

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_JITCallCompGrpRelToProdn.
-- 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_JITCallCompGrpRelToProdn AS
SELECT
  JITCallComponentUUID,
  JITCallCompGrpUUID,
  InternalJITCallNumber,
  CompGrpNumber,
  JITHeaderUUID,
  _ProductCompMatl._Text[1:Language = $session.system_language].ProductName AS ProductName,
  RequestedQuantity,
  QuantityUnit,
  _JITInbCallComponentGroup.CompGrpMatl AS CompGrpMatl,
  _JITInbCallComponentGroup.RequirementDateTime AS RequirementDateTime,
  cast( dats_tims_to_tstmp(_JITInbCallComponentGroup.MaterialAvailabilityDate, _JITInbCallComponentGroup.MaterialAvailabilityTime, 'UTC', $session.client, 'NULL') as tzntstmps preserving type) AS MaterialAvailabilityDateTime,
  _JITInbCallComponentGroup.Plant AS Plant,
  _JITInbCallComponentGroup._Plant.PlantName AS PlantName,
  _JITInbCallComponentGroup.UnloadingPointName AS UnloadingPointName,
  _JITInbCallComponentGroup.CustSupplyArea AS CustSupplyArea,
  _JITInbCallComponentGroup.JITActionCtrl AS JITActionCtrl,
  _JITInbCallComponentGroup.JITIntProcessingStatus AS JITIntProcessingStatus,
  _JITInbCallComponentGroup.JITExtStatusAtSupplier AS JITExtStatusAtSupplier,
  _JITInbCallComponentGroup.PlannedShippingDateTime AS PlannedShippingDateTime,
  _JITInbCallComponentGroup.ProductionStartDate AS ProductionStartDate,
  _JITInbCallComponentGroup._SupplierExtStatus._JITExternalStatusText[1: Language=$session.system_language].JITExternalStatusText AS JITExternalStatusText,
  _JITInbCallComponentGroup.ProductionEndDate AS ProductionEndDate,
  _JITInbCallComponentGroup._JITInternalStatus._Text[1: Language=$session.system_language].JITInternalStatusText AS JITInternalStatusText,
  _JITInbCallComponentGroup.ProductionVersion AS ProductionVersion,
  _JITInbCallComponentGroup._JITSupplyControlHeader._ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _JITInbCallComponentGroup._ProductionVersion.ProductionLine AS ProductionLine,
  _JITInbCallComponentGroup.SupplyControlUUID AS SupplyControlUUID,
  _JITInbCallComponentGroup.ShippingPoint AS ShippingPoint,
  _JITInbCallComponentGroup.StorageLocation AS StorageLocation,
  _JITInbCallComponentGroup._JITSupplyControlHeader.RepetitiveManufacturingIsAllwd AS RepetitiveManufacturingIsAllwd,
  _JITInbCallComponentGroup.CustAssemblyLoc AS CustAssemblyLoc,
  _JITInboundCall.ShipToParty AS ShipToParty,
  _JITInboundCall._Customer.CustomerName AS CustomerName,
  _JITInboundCall.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITInboundCall._JITCallType._Text[1:Language = $session.system_language].JITCallTypeText AS JITCallTypeText,
  _JITInboundCall._JITLifecycleStatus._Text[1:Language = $session.system_language].JITLifecycleStatusText AS JITLifecycleStatusText,
  _JITInboundCall._MatlUsageIndicator._Text[1:Language = $session.system_language].MatlUsageIndicatorText AS MatlUsageIndicatorText,
  _JITInboundCall.JITCallType AS JITCallType,
  _JITInbCallComponentGroup._JITInternalStatus AS _JITInternalStatus,
  _JITInbCallComponentGroup._JITSupplyControlHeader AS _JITSupplyControlHeader,
  _JITInbCallComponentGroup._ProductCompGrp AS _ProductCompGrp,
  _JITInbCallComponentGroup._ShippingPoint AS _ShippingPoint,
  _JITInbCallComponentGroup._StorageLocation AS _StorageLocation,
  _JITInbCallComponentGroup._SupplierExtStatus AS _SupplierExtStatus,
  _JITInbCallComponentGroup._ProductionVersion AS _ProductionVersion
FROM I_JITInbCallComponent
LEFT OUTER JOIN I_Plant AS _Plant ON plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_JITInbCallComponent AS _JITInbCallComponent ON JITCallComponentUUID = _JITInbCallComponent.JITCallComponentUUID  -- association [0..1]
LEFT OUTER JOIN I_JITCustomerSupplyArea AS _JITCustSupplyArea ON shiptoparty = _JITCustSupplyArea.ShipToParty AND custsupplyarea = _JITCustSupplyArea.CustSupplyArea AND unloadingpointname = _JITCustSupplyArea.UnloadingPointName  -- association [0..1]
;

Learn More