I_JITOutbRtgAssemblySeqData

DDL: I_JITOUTBRTGASSEMBLYSEQDATA SQL: IJITREMASMSEQD Type: view COMPOSITE
35 Fields 1 Data Sources 1 Associations

Complex Component Assembly Sequence Data

I_JITOutbRtgAssemblySeqData is a Composite CDS View that provides data about "Complex Component Assembly Sequence Data" in SAP S/4HANA. It reads from 1 data source (I_JITOutbRtgAssemblySeqBasic) and exposes 35 fields with key fields JustInTimeRoutingSequence, BillOfOperationsGroup, BillOfOperationsType, BillOfOperationsVariant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITOutbRtgAssemblySeqBasic _RtgAsmSeqBsc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_JITOutbRtgAssemblySeqBasic _Extension $projection.JustInTimeRoutingSequence = _Extension.JustInTimeRoutingSequence and $projection.BillOfOperationsGroup = _Extension.BillOfOperationsGroup and $projection.BillOfOperationsType = _Extension.BillOfOperationsType and $projection.BillOfOperationsVariant = _Extension.BillOfOperationsVariant

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IJITREMASMSEQD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Complex Component Assembly Sequence Data view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY JustInTimeRoutingSequence I_JITOutbRtgAssemblySeqBasic JustInTimeRoutingSequence Sequence ID
KEY BillOfOperationsGroup I_JITOutbRtgAssemblySeqBasic BillOfOperationsGroup Group
KEY BillOfOperationsType I_JITOutbRtgAssemblySeqBasic BillOfOperationsType Task List Type
KEY BillOfOperationsVariant I_JITOutbRtgAssemblySeqBasic BillOfOperationsVariant Group Counter
BOOOperationInternalID I_JITOutbRtgAssemblySeqBasic BOOOperationInternalID Task list node
BOOOpInternalVersionCounter I_JITOutbRtgAssemblySeqBasic BOOOpInternalVersionCounter Counter
Plant I_JITOutbRtgAssemblySeqBasic Plant Valuation Area
PlannedOrder I_JITOutbRtgAssemblySeqBasic PlannedOrder Planned Order
Material I_JITOutbRtgAssemblySeqBasic Material Vehicle Model
JustInTimeTakt I_JITOutbRtgAssemblySeqBasic JustInTimeTakt Takt ID
JustInTimeAssemblyLineType I_JITOutbRtgAssemblySeqBasic JustInTimeAssemblyLineType Line Type
JustInTimeAssemblyLineCategory I_JITOutbRtgAssemblySeqBasic JustInTimeAssemblyLineCategory Line Category
JITPreviousReportingPoint I_JITOutbRtgAssemblySeqBasic JITPreviousReportingPoint Prev. Rptg. Pt.
JustInTimeNextReportingPoint I_JITOutbRtgAssemblySeqBasic JustInTimeNextReportingPoint
JITAssemblyStatus I_JITOutbRtgAssemblySeqBasic JITAssemblyStatus Assy. Status
JustInTimeRoutingProductionID I_JITOutbRtgAssemblySeqBasic JustInTimeRoutingProductionID Production ID
ConfirmationEntryQuantity I_JITOutbRtgAssemblySeqBasic ConfirmationEntryQuantity Quantity in UnE
BaseUnit I_JITOutbRtgAssemblySeqBasic BaseUnit Unit of Measure
JITAssemblyConfDateTime I_JITOutbRtgAssemblySeqBasic JITAssemblyConfDateTime Conf. DateTime
JITSequenceCreationDateTime I_JITOutbRtgAssemblySeqBasic JITSequenceCreationDateTime Crtn. DateTime
JITSequenceLastChangeDateTime I_JITOutbRtgAssemblySeqBasic JITSequenceLastChangeDateTime Chd. DateTime
BillOfOperationsRefType I_JITOutbRtgAssemblySeqBasic BillOfOperationsRefType Ref TList type
BillOfOperationsRefGroup I_JITOutbRtgAssemblySeqBasic BillOfOperationsRefGroup
BillOfOperationsRefVariant I_JITOutbRtgAssemblySeqBasic BillOfOperationsRefVariant
BOORefOperationInternalID I_JITOutbRtgAssemblySeqBasic BOORefOperationInternalID Nodes
BOORefOpInternalVersion I_JITOutbRtgAssemblySeqBasic BOORefOpInternalVersion Counter
JustInTimeTaktOperationNumber I_JITOutbRtgAssemblySeqBasic JustInTimeTaktOperationNumber
JITTaktOperationNumberDesc
JITAssemblyLineTypeDesc
JITAssemblyLineCategoryDesc
JITAssemblyStatusDesc
_JITOutbAssemblyStatus I_JITOutbRtgAssemblySeqBasic _JITOutbAssemblyStatus
_JITOutbAssemblyLineCat I_JITOutbRtgAssemblySeqBasic _JITOutbAssemblyLineCat
_JITOutbAssemblyLineType I_JITOutbRtgAssemblySeqBasic _JITOutbAssemblyLineType
_Material I_JITOutbRtgAssemblySeqBasic _Material

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_JITOutbRtgAssemblySeqData.
-- 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: IJITREMASMSEQD

CREATE VIEW I_JITOutbRtgAssemblySeqData AS
SELECT
  _RtgAsmSeqBsc.JustInTimeRoutingSequence AS JustInTimeRoutingSequence,
  _RtgAsmSeqBsc.BillOfOperationsGroup AS BillOfOperationsGroup,
  _RtgAsmSeqBsc.BillOfOperationsType AS BillOfOperationsType,
  _RtgAsmSeqBsc.BillOfOperationsVariant AS BillOfOperationsVariant,
  _RtgAsmSeqBsc.BOOOperationInternalID AS BOOOperationInternalID,
  _RtgAsmSeqBsc.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  _RtgAsmSeqBsc.Plant AS Plant,
  _RtgAsmSeqBsc.PlannedOrder AS PlannedOrder,
  _RtgAsmSeqBsc.Material AS Material,
  _RtgAsmSeqBsc.JustInTimeTakt AS JustInTimeTakt,
  _RtgAsmSeqBsc.JustInTimeAssemblyLineType AS JustInTimeAssemblyLineType,
  _RtgAsmSeqBsc.JustInTimeAssemblyLineCategory AS JustInTimeAssemblyLineCategory,
  _RtgAsmSeqBsc.JITPreviousReportingPoint AS JITPreviousReportingPoint,
  _RtgAsmSeqBsc.JustInTimeNextReportingPoint AS JustInTimeNextReportingPoint,
  _RtgAsmSeqBsc.JITAssemblyStatus AS JITAssemblyStatus,
  _RtgAsmSeqBsc.JustInTimeRoutingProductionID AS JustInTimeRoutingProductionID,
  _RtgAsmSeqBsc.ConfirmationEntryQuantity AS ConfirmationEntryQuantity,
  _RtgAsmSeqBsc.BaseUnit AS BaseUnit,
  _RtgAsmSeqBsc.JITAssemblyConfDateTime AS JITAssemblyConfDateTime,
  _RtgAsmSeqBsc.JITSequenceCreationDateTime AS JITSequenceCreationDateTime,
  _RtgAsmSeqBsc.JITSequenceLastChangeDateTime AS JITSequenceLastChangeDateTime,
  _RtgAsmSeqBsc.BillOfOperationsRefType AS BillOfOperationsRefType,
  _RtgAsmSeqBsc.BillOfOperationsRefGroup AS BillOfOperationsRefGroup,
  _RtgAsmSeqBsc.BillOfOperationsRefVariant AS BillOfOperationsRefVariant,
  _RtgAsmSeqBsc.BOORefOperationInternalID AS BOORefOperationInternalID,
  _RtgAsmSeqBsc.BOORefOpInternalVersion AS BOORefOpInternalVersion,
  _RtgAsmSeqBsc.JustInTimeTaktOperationNumber AS JustInTimeTaktOperationNumber,
  _RtgAsmSeqBsc._OperationDescription.OperationText AS JITTaktOperationNumberDesc,
  _RtgAsmSeqBsc._JITOutbAssemblyLineType._Text[1: Language = $session.system_language].JITAssemblyLineTypeDesc AS JITAssemblyLineTypeDesc,
  _RtgAsmSeqBsc._JITOutbAssemblyLineCat._Text[1: Language = $session.system_language].JITAssemblyLineCategoryDesc AS JITAssemblyLineCategoryDesc,
  _RtgAsmSeqBsc._JITOutbAssemblyStatus._Text[1: Language = $session.system_language].JITAssemblyStatusDesc AS JITAssemblyStatusDesc,
  _RtgAsmSeqBsc._JITOutbAssemblyStatus AS _JITOutbAssemblyStatus,
  _RtgAsmSeqBsc._JITOutbAssemblyLineCat AS _JITOutbAssemblyLineCat,
  _RtgAsmSeqBsc._JITOutbAssemblyLineType AS _JITOutbAssemblyLineType,
  _RtgAsmSeqBsc._Material AS _Material
FROM I_JITOutbRtgAssemblySeqBasic AS _RtgAsmSeqBsc
LEFT OUTER JOIN E_JITOutbRtgAssemblySeqBasic AS _Extension ON JustInTimeRoutingSequence = _Extension.JustInTimeRoutingSequence AND BillOfOperationsGroup = _Extension.BillOfOperationsGroup AND BillOfOperationsType = _Extension.BillOfOperationsType AND BillOfOperationsVariant = _Extension.BillOfOperationsVariant  -- association [0..1]
;

Learn More