C_JITOutbRtgAssemblySeqQry

DDL: C_JITOUTBRTGASSEMBLYSEQQRY SQL: CJITREMASMSEQQR Type: view CONSUMPTION
47 Fields 1 Data Sources 1 Associations 1 Fiori Apps

Complex Component Assembly Seq - Query

C_JITOutbRtgAssemblySeqQry is a Consumption CDS View that provides data about "Complex Component Assembly Seq - Query" in SAP S/4HANA. It reads from 1 data source (I_JITOutbRtgAssemblySeqCube) and exposes 47 fields with key fields JustInTimeRoutingSequence, BillOfOperationsGroup, BillOfOperationsType, BillOfOperationsVariant. It has 1 association to related views. It is used in 1 Fiori application: Monitor Assembly Sequence - Repetitive Manufacturing.

SAP Help Documentation

CategoryCDS Views for Just-In-Time Processing
Data CategoryConsumption
Corresponding DataSourceCJITREMASMSEQQR - Complex Component Assembly Seq - Query
Purpose
This CDS view can monitor the progress of complex component assemblies. The CDS view provides the following data: View summary of assembly sequence based on different filter criteria Manage views using the respective option Navigate to the Planned Orders application

Structure
Main Parameters and Filters of CDS View This view does not have any input parameters. The main filters are as follows: PlannedOrder used to filter by planned order BillOfOperationsGroup used to filter by group number JustInTimeTaktOperationNumber used to filter by operation JITAssemblyStatus used to filter by assembly status JITPreviousReportingPoint used to filter by previous reporting point JustInTimeNextReportingPoint used to filter by next reporting point Plant used to filter by plant

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_JITOutbRtgAssemblySeqCube _AssemblySeq from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_JITOutbPlannedOrderOvw _PlannedOrderOvw $projection.PlannedOrder = _PlannedOrderOvw.PlannedOrder

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CJITREMASMSEQQR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.representativeKey JustInTimeRoutingSequence view
Search.searchable false view
Analytics.query true view
Metadata.allowExtensions true view
OData.publish true view
EndUserText.label Complex Component Assembly Seq - Query view

Fiori Apps (1)

App IDApp NameTypeDescription
F6586 Monitor Assembly Sequence - Repetitive Manufacturing Analytical Monitor application to track the sequencing and position (location) of PP-REM planned orders (for example: Complex Component assemblies, engine assemblies, gearbox assemblies, etc.)

Monitor Assembly Sequence - Repetitive Manufacturing

Business Role: Production Supervisor - Lean Manufacturing

With this application, you, as Production Supervisor - Lean Manufacturing can visualize how vehicles are sequenced across an assembly line. Using this application, it is possible to identify the number of planned orders or vehicles are present in a particular assembly line with status as sequenced, in progress, or completed. In progress: moving within the assembly line Completed: on completed moving within the assembly line

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY JustInTimeRoutingSequence JustInTimeRoutingSequence
KEY BillOfOperationsGroup BillOfOperationsGroup Group
KEY BillOfOperationsType BillOfOperationsType Task List Type
KEY BillOfOperationsVariant BillOfOperationsVariant Group Counter
BOOOperationInternalID BOOOperationInternalID Task list node
BOOOpInternalVersionCounter BOOOpInternalVersionCounter Counter
Plant Plant Valuation Area
PlannedOrder PlannedOrder
Material Material Vehicle Model
JustInTimeTakt JustInTimeTakt
JITIsBufferIndicatorCode JITIsBufferIndicatorCode
JustInTimeAssemblyLineType JustInTimeAssemblyLineType
JustInTimeAssemblyLineCategory JustInTimeAssemblyLineCategory
JITPreviousReportingPoint JITPreviousReportingPoint Prev. Rptg. Pt.
JustInTimeNextReportingPoint JustInTimeNextReportingPoint
JITAssemblyStatus JITAssemblyStatus Assy. Status
JustInTimeRoutingProductionID JustInTimeRoutingProductionID
ConfirmationEntryQuantity ConfirmationEntryQuantity
BaseUnit BaseUnit Unit of Measure
JITAssemblyConfDateTime JITAssemblyConfDateTime Conf. DateTime
JITSequenceCreationDateTime JITSequenceCreationDateTime Crtn. DateTime
JITSequenceLastChangeDateTime JITSequenceLastChangeDateTime Chd. DateTime
JITAssemblyLineTypeDesc JITAssemblyLineTypeDesc
JITAssemblyLineCategoryDesc JITAssemblyLineCategoryDesc
JITAssemblyStatusDesc JITAssemblyStatusDesc
JITAssemblyStatusCriticality JITAssemblyStatusCriticality
NumberOfPlannedOrders NumberOfPlannedOrders
BillOfOperationsRefType BillOfOperationsRefType
BillOfOperationsRefGroup BillOfOperationsRefGroup
BillOfOperationsRefVariant BillOfOperationsRefVariant
BOORefOperationInternalID BOORefOperationInternalID
BOORefOpInternalVersion BOORefOpInternalVersion
JustInTimeTaktOperationNumber JustInTimeTaktOperationNumber
JITTaktOperationNumberDesc JITTaktOperationNumberDesc
_PlannedOrderOvw _PlannedOrderOvw
_JITOutbAssemblyStatus _JITOutbAssemblyStatus
_JITOutbAssemblyLineCat _JITOutbAssemblyLineCat
_JITOutbAssemblyLineType _JITOutbAssemblyLineType
_JITOutbPlantVH _JITOutbPlantVH
_JITOutbTaskListGroupVH _JITOutbTaskListGroupVH
_JITOutbPrevReportingPointVH _JITOutbPrevReportingPointVH
_JITOutbNextReportingPointVH _JITOutbNextReportingPointVH
_JITOutbTaktOperationVH _JITOutbTaktOperationVH
_Material _Material
_JITPlannedOrderVH _JITPlannedOrderVH
_JITOutbRtgTskListGrpCntrVH _JITOutbRtgTskListGrpCntrVH
_MaterialVH _MaterialVH

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_JITOutbRtgAssemblySeqQry.
-- 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: CJITREMASMSEQQR

CREATE VIEW C_JITOutbRtgAssemblySeqQry AS
SELECT
  JustInTimeRoutingSequence,
  BillOfOperationsGroup,
  BillOfOperationsType,
  BillOfOperationsVariant,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  Plant,
  PlannedOrder,
  Material,
  JustInTimeTakt,
  JITIsBufferIndicatorCode,
  JustInTimeAssemblyLineType,
  JustInTimeAssemblyLineCategory,
  JITPreviousReportingPoint,
  JustInTimeNextReportingPoint,
  JITAssemblyStatus,
  JustInTimeRoutingProductionID,
  ConfirmationEntryQuantity,
  BaseUnit,
  JITAssemblyConfDateTime,
  JITSequenceCreationDateTime,
  JITSequenceLastChangeDateTime,
  JITAssemblyLineTypeDesc,
  JITAssemblyLineCategoryDesc,
  JITAssemblyStatusDesc,
  JITAssemblyStatusCriticality,
  NumberOfPlannedOrders,
  BillOfOperationsRefType,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  BOORefOperationInternalID,
  BOORefOpInternalVersion,
  JustInTimeTaktOperationNumber,
  JITTaktOperationNumberDesc
FROM I_JITOutbRtgAssemblySeqCube AS _AssemblySeq
LEFT OUTER JOIN C_JITOutbPlannedOrderOvw AS _PlannedOrderOvw ON PlannedOrder = _PlannedOrderOvw.PlannedOrder  -- association [0..1]
;

Learn More