I_JITCallBackflushReprocg

DDL: I_JITCALLBACKFLUSHREPROCG Type: view_entity COMPOSITE Package: NJIT_APP_REPROCESSING_LIST

JIT Inbound Reprocess Failed Backflush

I_JITCallBackflushReprocg is a Composite CDS View that provides data about "JIT Inbound Reprocess Failed Backflush" in SAP S/4HANA. It reads from 1 data source (I_JITCallBackflushReprocgBasic) and exposes 27 fields with key field JITBackflushUUID. It has 3 associations to related views. Part of development package NJIT_APP_REPROCESSING_LIST.

Data Sources (1)

SourceAliasJoin Type
I_JITCallBackflushReprocgBasic I_JITCallBackflushReprocgBasic from

Associations (3)

CardinalityTargetAliasCondition
[0..1] C_JITProdnConfControlVH _JITProdnConfControlVH $projection.jitprodnconfirmationcontrol = _JITProdnConfControlVH.JITProdnConfirmationControl
[0..1] I_ProductSupplyPlanning _ProdConfProfile $projection.Material = _ProdConfProfile.Product and $projection.Plant = _ProdConfProfile.Plant
[0..1] I_ProductSupplyPlanning _CompGrpProdConfProfile $projection.compgrpmatl = _CompGrpProdConfProfile.Product and $projection.Plant = _CompGrpProdConfProfile.Plant

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label JIT Inbound Reprocess Failed Backflush view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY JITBackflushUUID JITBackflushUUID UUID
JITCallCompMatlMessageClass JITCallCompMatlMessageClass Message Class
JITCallCompMatlMessageType JITCallCompMatlMessageType Message Type
JITCallCompMatlMessageNumber JITCallCompMatlMessageNumber Message Number
JITCallCompMatlMessageValue1 JITCallCompMatlMessageValue1 Message Variable
JITCallCompMatlMessageValue2 JITCallCompMatlMessageValue2 Message Variable
JITCallCompMatlMessageValue3 JITCallCompMatlMessageValue3 Message Variable
JITCallCompMatlMessageValue4 JITCallCompMatlMessageValue4 Message Variable
JITHeaderUUID JITHeaderUUID NodeID
JITCallComponentUUID JITCallComponentUUID NodeID
Material _JITInbCallComponent Material Vehicle Model
RequestedQuantity _JITInbCallComponent RequestedQuantity Requested Quantity
QuantityUnit _JITInbCallComponent QuantityUnit Unit of measure
JITCallCompBackflushStsUpdtdOn _JITInbCallComponent JITCallCompBackflushStsUpdtdOn BFlsh Status Updt On
InternalJITCallNumber _JITInbCallComponent InternalJITCallNumber JIT Call Number
ShipToParty
ExternalJITCallNumber
CompGrpNumber
JITProdnConfirmationControl
Plant
ProductionVersion
CompGrpMatl
_JITProdnConfControlVH _JITProdnConfControlVH
_ProdConfProfile _ProdConfProfile
_CompGrpProdConfProfile _CompGrpProdConfProfile
_JITInboundCall _JITInboundCall
_JITInbCallComponent _JITInbCallComponent

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_JITCallBackflushReprocg.
-- 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_JITCallBackflushReprocg AS
SELECT
  JITBackflushUUID,
  JITCallCompMatlMessageClass,
  JITCallCompMatlMessageType,
  JITCallCompMatlMessageNumber,
  JITCallCompMatlMessageValue1,
  JITCallCompMatlMessageValue2,
  JITCallCompMatlMessageValue3,
  JITCallCompMatlMessageValue4,
  JITHeaderUUID,
  JITCallComponentUUID,
  _JITInbCallComponent.Material AS Material,
  _JITInbCallComponent.RequestedQuantity AS RequestedQuantity,
  _JITInbCallComponent.QuantityUnit AS QuantityUnit,
  _JITInbCallComponent.JITCallCompBackflushStsUpdtdOn AS JITCallCompBackflushStsUpdtdOn,
  _JITInbCallComponent.InternalJITCallNumber AS InternalJITCallNumber,
  _JITInbCallComponent._JITInboundCall.ShipToParty AS ShipToParty,
  _JITInbCallComponent._JITInboundCall.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITInbCallComponent._JITInbCallComponentGroup.CompGrpNumber AS CompGrpNumber,
  _JITInbCallComponent._JITInbCallComponentGroup._JITSupplyControlHeader.JITProdnConfirmationControl AS JITProdnConfirmationControl,
  _JITInbCallComponent._JITInbCallComponentGroup.Plant AS Plant,
  _JITInbCallComponent._JITInbCallComponentGroup.ProductionVersion AS ProductionVersion,
  _JITInbCallComponent._JITInbCallComponentGroup.CompGrpMatl AS CompGrpMatl
FROM I_JITCallBackflushReprocgBasic
LEFT OUTER JOIN C_JITProdnConfControlVH AS _JITProdnConfControlVH ON jitprodnconfirmationcontrol = _JITProdnConfControlVH.JITProdnConfirmationControl  -- association [0..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProdConfProfile ON Material = _ProdConfProfile.Product AND Plant = _ProdConfProfile.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _CompGrpProdConfProfile ON compgrpmatl = _CompGrpProdConfProfile.Product AND Plant = _CompGrpProdConfProfile.Plant  -- association [0..1]
;