I_BOOSequenceChangeState

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_BOOSequenceChangeState.
-- 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: IPPBOOSEQUENCECS

CREATE VIEW I_BOOSequenceChangeState AS
SELECT
  plfl.plnty AS BillOfOperationsType,
  plfl.plnnr AS BillOfOperationsGroup,
  plfl.plnal AS BillOfOperationsVariant,
  plfl.plnfl AS BillOfOperationsSequence,
  plfl.zaehl AS BOOSqncInternalVersionCounter,
  plfl.versn AS BillOfOperationsVersion,
  plfl.loekz AS IsDeleted,
  plfl.loekz_inherited AS IsImplicitlyDeleted,
  plfl.ltxa1 AS SequenceText,
  plfl.auschl AS SequenceSchedulingAlignment,
  plfl.bknt1 AS BOOSqncBranchOpInternalID,
  plfl.bknt2 AS BOOSqncReturnOpInternalID,
  plfl.losvn AS MinimumLotSizeQuantity,
  plfl.losbs AS MaximumLotSizeQuantity,
  cast(plfl.datuv as pph_begda preserving type) AS ValidityStartDate,
  cast(plfl.valid_to as pph_endda preserving type) AS ValidityEndDate,
  plfl.andat AS CreationDate,
  cast(plfl.annam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  plfl.aedat AS LastChangeDate,
  cast(plfl.aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser
FROM plfl
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsSequence AS _BillOfOperationsSequence ON BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant AND BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsSequenceCat AS _BillOfOperationsSequenceCat ON BillOfOperationsSequenceCat = _BillOfOperationsSequenceCat.BillOfOperationsSequenceCat  -- association [1..1]
LEFT OUTER JOIN I_SequenceSchedulingAlignment AS _SequenceSchedulingAlignment ON SequenceSchedulingAlignment = _SequenceSchedulingAlignment.SequenceSchedulingAlignment  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsSequence AS _BillOfOperationsRefSequence ON BillOfOperationsType = _BillOfOperationsRefSequence.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsRefSequence.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsRefSequence.BillOfOperationsVariant AND BillOfOperationsRefSequence = _BillOfOperationsRefSequence.BillOfOperationsSequence  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsOperation AS _BOOOperationsBranchOperation ON BillOfOperationsType = _BOOOperationsBranchOperation.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationsBranchOperation.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOOperationsBranchOperation.BillOfOperationsVariant AND BillOfOperationsRefSequence = _BOOOperationsBranchOperation.BillOfOperationsSequence AND BOOSqncBranchOpInternalID = _BOOOperationsBranchOperation.BOOOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsOperation AS _BOOOperationsReturnOperation ON BillOfOperationsType = _BOOOperationsReturnOperation.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationsReturnOperation.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOOperationsReturnOperation.BillOfOperationsVariant AND BillOfOperationsRefSequence = _BOOOperationsReturnOperation.BillOfOperationsSequence AND BOOSqncReturnOpInternalID = _BOOOperationsReturnOperation.BOOOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
;