I_JITOutbPPEAssemblySeqDEX

DDL: I_JITOUTBPPEASSEMBLYSEQDEX SQL: IJITPPEASMSEQDEX Type: view COMPOSITE Package: NJIT_MODEL_O
59 Fields 2 Data Sources 3 Associations

PPE Assembly Sequence Data extraction

I_JITOutbPPEAssemblySeqDEX is a Composite CDS View that provides data about "PPE Assembly Sequence Data extraction" in SAP S/4HANA. It reads from 2 data sources (I_JITOutbPPEAssemblySeqBasic, I_JITOutbPreAssemblySeqBasic) and exposes 59 fields with key fields JITFactoryLayoutSequence, JITAssemblyLineNetworkUUID, JustInTimeAssemblyLineUUID, JITAssemblyLineNetworkUUID, JustInTimeAssemblyLineUUID. It has 3 associations to related views. Part of development package NJIT_MODEL_O.

Data Sources (2)

SourceAliasJoin Type
I_JITOutbPPEAssemblySeqBasic _AsmSeqBsc from
I_JITOutbPreAssemblySeqBasic _PreAssembly union

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_JITOutbPPEAssemblySeqBasic _JITOutbPPEAssemblySeqBasic $projection.JITFctryLaytSequenceReference = _JITOutbPPEAssemblySeqBasic.JITFactoryLayoutSequence and $projection.JITAssemblyLineNetworkUUID = _JITOutbPPEAssemblySeqBasic.JITAssemblyLineNetworkUUID
[0..1] I_JITOutbAssemblyStatus _JITOutbPreAssemblyStatus $projection.JITAssemblyStatus = _JITOutbPreAssemblyStatus.JITAssemblyStatus
[0..1] I_JITOutbSupToProdnFlag _JITOutbSupToProdnFlag $projection.JITSequenceIsForPreAssembly = _JITOutbSupToProdnFlag.JITIsSupToProdnFlag

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IJITPPEASMSEQDEX 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
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PPE Assembly Sequence Data extraction view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY JITFactoryLayoutSequence I_JITOutbPPEAssemblySeqBasic JITFactoryLayoutSequence Sequence ID
KEY JITAssemblyLineNetworkUUID I_JITOutbPPEAssemblySeqBasic JITAssemblyLineNetworkUUID Line Network
KEY JustInTimeAssemblyLineUUID I_JITOutbPPEAssemblySeqBasic JustInTimeAssemblyLineUUID Line ID
JITFactoryLayoutSubSequence I_JITOutbPPEAssemblySeqBasic JITFactoryLayoutSubSequence Sub Sequence
Plant I_JITOutbPPEAssemblySeqBasic Plant Valuation Area
PlannedOrder I_JITOutbPPEAssemblySeqBasic PlannedOrder Planned Order
JITFctryLaytSequenceReference Sequence ID
VehicleIdentificationNumber I_JITOutbPPEAssemblySeqBasic VehicleIdentificationNumber VIN
JITAssemblyLineNetworkName
JITAssemblyLineName
JITAssemblyNextLineName
JITPreviousReportingPointName
JITNextReportingPointName
JustInTimeTakt I_JITOutbPPEAssemblySeqBasic JustInTimeTakt Takt ID
JITAssemblyLineSegmentName
JITAssemblyLineBufferName
JustInTimeAssemblyLineCategory I_JITOutbPPEAssemblySeqBasic JustInTimeAssemblyLineCategory Line Category
JITAssemblyStatus I_JITOutbPPEAssemblySeqBasic JITAssemblyStatus Pre Assembly Status
JITAssemblyStatusDesc
JITAssemblyConfDateTime I_JITOutbPPEAssemblySeqBasic JITAssemblyConfDateTime Conf. DateTime
JITSequenceCreationDateTime I_JITOutbPPEAssemblySeqBasic JITSequenceCreationDateTime Crtn. DateTime
JITSequenceLastChangeDateTime I_JITOutbPPEAssemblySeqBasic JITSequenceLastChangeDateTime Chd. DateTime
JITSequenceIsForPreAssembly I_JITOutbPPEAssemblySeqBasic JITSequenceIsForPreAssembly
JITSequenceForPreAssemblyDesc
JITAssemblyLineCategoryDesc
JustInTimeAssemblyNextLineUUID I_JITOutbPPEAssemblySeqBasic JustInTimeAssemblyNextLineUUID Next Line
JITPreviousReportingPointUUID I_JITOutbPPEAssemblySeqBasic JITPreviousReportingPointUUID Prev. Rptg. Pt.
JITNextReportingPointUUID I_JITOutbPPEAssemblySeqBasic JITNextReportingPointUUID Next Rptg. Pt.
JITLineSegmentUUID I_JITOutbPPEAssemblySeqBasic JITLineSegmentUUID Line Seg
JITFactoryLayoutSequence Sequence ID
KEY JITAssemblyLineNetworkUUID I_JITOutbPreAssemblySeqBasic JITAssemblyLineNetworkUUID Line Network
KEY JustInTimeAssemblyLineUUID I_JITOutbPreAssemblySeqBasic JustInTimeAssemblyLineUUID Line ID
JITFactoryLayoutSubSequence Sub Sequence
Plant _JITOutbPPEAssemblySeqBasic Plant Valuation Area
PlannedOrder I_JITOutbPreAssemblySeqBasic PlannedOrder Planned Order
JITFctryLaytSequenceReference I_JITOutbPreAssemblySeqBasic JITFctryLaytSequenceReference Sequence ID
VehicleIdentificationNumber VIN
JITAssemblyLineNetworkName
JITAssemblyLineName
JITAssemblyNextLineName
JITPreviousReportingPointName
JITNextReportingPointName
JustInTimeTakt I_JITOutbPreAssemblySeqBasic JustInTimeTakt Takt ID
JITAssemblyLineSegmentName
JITAssemblyLineBufferName
JustInTimeAssemblyLineCategory I_JITOutbPreAssemblySeqBasic JustInTimeAssemblyLineCategory Line Category
JITAssemblyStatus I_JITOutbPreAssemblySeqBasic JITPreAssemblyStatus Pre Assembly Status
JITAssemblyStatusDesc
JITAssemblyConfDateTime I_JITOutbPreAssemblySeqBasic JITAssemblyConfDateTime Conf. DateTime
JITSequenceCreationDateTime I_JITOutbPreAssemblySeqBasic JITSequenceCreationDateTime Crtn. DateTime
JITSequenceLastChangeDateTime I_JITOutbPreAssemblySeqBasic JITSequenceLastChangeDateTime Chd. DateTime
JITSequenceIsForPreAssembly I_JITOutbPreAssemblySeqBasic JITSequenceIsForPreAssembly
JITSequenceForPreAssemblyDesc
JITAssemblyLineCategoryDesc
JustInTimeAssemblyNextLineUUID I_JITOutbPreAssemblySeqBasic JustInTimeAssemblyNextLineUUID Next Line
JITPreviousReportingPointUUID I_JITOutbPreAssemblySeqBasic JITPreviousReportingPointUUID Prev. Rptg. Pt.
JITNextReportingPointUUID I_JITOutbPreAssemblySeqBasic JITNextReportingPointUUID Next Rptg. Pt.
JITLineSegmentUUID I_JITOutbPreAssemblySeqBasic JITLineSegmentUUID Line Seg
JITLineBufferUUID I_JITOutbPreAssemblySeqBasic JITLineBufferUUID Buffer

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_JITOutbPPEAssemblySeqDEX.
-- 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: IJITPPEASMSEQDEX

CREATE VIEW I_JITOutbPPEAssemblySeqDEX AS
SELECT
  _AsmSeqBsc.JITFactoryLayoutSequence AS JITFactoryLayoutSequence,
  _AsmSeqBsc.JITAssemblyLineNetworkUUID AS JITAssemblyLineNetworkUUID,
  _AsmSeqBsc.JustInTimeAssemblyLineUUID AS JustInTimeAssemblyLineUUID,
  _AsmSeqBsc.JITFactoryLayoutSubSequence AS JITFactoryLayoutSubSequence,
  _AsmSeqBsc.Plant AS Plant,
  _AsmSeqBsc.PlannedOrder AS PlannedOrder,
  cast ('' as njit_s2p_ppe_seqid) AS JITFctryLaytSequenceReference,
  _AsmSeqBsc.VehicleIdentificationNumber AS VehicleIdentificationNumber,
  _AsmSeqBsc._LineNetwork.FactoryLayoutNodeName AS JITAssemblyLineNetworkName,
  _AsmSeqBsc._Line.FactoryLayoutNodeName AS JITAssemblyLineName,
  _AsmSeqBsc._LineNext.FactoryLayoutNodeName AS JITAssemblyNextLineName,
  _AsmSeqBsc._ReportingPointPrev.ReportingPointName AS JITPreviousReportingPointName,
  _AsmSeqBsc._ReportingPointNext.ReportingPointName AS JITNextReportingPointName,
  _AsmSeqBsc.JustInTimeTakt AS JustInTimeTakt,
  _AsmSeqBsc._LineSegment.FactoryLayoutNodeName AS JITAssemblyLineSegmentName,
  _AsmSeqBsc._LineBuffer.FactoryLayoutNodeName AS JITAssemblyLineBufferName,
  _AsmSeqBsc.JustInTimeAssemblyLineCategory AS JustInTimeAssemblyLineCategory,
  _AsmSeqBsc.JITAssemblyStatus AS JITAssemblyStatus,
  _AsmSeqBsc._JITOutbAssemblyStatus._Text[1: Language = $session.system_language].JITAssemblyStatusDesc AS JITAssemblyStatusDesc,
  _AsmSeqBsc.JITAssemblyConfDateTime AS JITAssemblyConfDateTime,
  _AsmSeqBsc.JITSequenceCreationDateTime AS JITSequenceCreationDateTime,
  _AsmSeqBsc.JITSequenceLastChangeDateTime AS JITSequenceLastChangeDateTime,
  _AsmSeqBsc.JITSequenceIsForPreAssembly AS JITSequenceIsForPreAssembly,
  _AsmSeqBsc._JITOutbSupToProdnFlag._Text[1: Language = $session.system_language].JITSupToProdnFlagDesc AS JITSequenceForPreAssemblyDesc,
  _AsmSeqBsc._JITOutbAssemblyLineCat._Text[1: Language = $session.system_language].JITAssemblyLineCategoryDesc AS JITAssemblyLineCategoryDesc,
  _AsmSeqBsc.JustInTimeAssemblyNextLineUUID AS JustInTimeAssemblyNextLineUUID,
  _AsmSeqBsc.JITPreviousReportingPointUUID AS JITPreviousReportingPointUUID,
  _AsmSeqBsc.JITNextReportingPointUUID AS JITNextReportingPointUUID,
  _AsmSeqBsc.JITLineSegmentUUID AS JITLineSegmentUUID,
  _PreAssembly.JITLineBufferUUID AS JITLineBufferUUID
FROM I_JITOutbPPEAssemblySeqBasic AS _AsmSeqBsc
LEFT OUTER JOIN I_JITOutbPPEAssemblySeqBasic AS _JITOutbPPEAssemblySeqBasic ON JITFctryLaytSequenceReference = _JITOutbPPEAssemblySeqBasic.JITFactoryLayoutSequence AND JITAssemblyLineNetworkUUID = _JITOutbPPEAssemblySeqBasic.JITAssemblyLineNetworkUUID  -- association [1..1]
LEFT OUTER JOIN I_JITOutbAssemblyStatus AS _JITOutbPreAssemblyStatus ON JITAssemblyStatus = _JITOutbPreAssemblyStatus.JITAssemblyStatus  -- association [0..1]
LEFT OUTER JOIN I_JITOutbSupToProdnFlag AS _JITOutbSupToProdnFlag ON JITSequenceIsForPreAssembly = _JITOutbSupToProdnFlag.JITIsSupToProdnFlag  -- association [0..1]
-- UNION with additional select branch(es): I_JITOutbPreAssemblySeqBasic
;

Learn More