I_ProdAllocationSequenceTP

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_ProdAllocationSequenceTP.
-- 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_ProdAllocationSequenceTP AS
SELECT
  Document.ProductAllocationSequenceUUID AS ProductAllocationSequenceUUID,
  Document.ProductAllocationSequence AS ProductAllocationSequence,
  Document.NumberOfBackwardCnsmpnPeriods AS NumberOfBackwardCnsmpnPeriods,
  Document.NumberOfForwardCnsmpnPeriods AS NumberOfForwardCnsmpnPeriods,
  Document.HorizontalConsumptionDirection AS HorizontalConsumptionDirection,
  Document.VerticalConsumptionDirection AS VerticalConsumptionDirection,
  Document.PastPeriodIsAllowed AS PastPeriodIsAllowed,
  Document.ProdAllocSqncConsumptionUnit AS ProdAllocSqncConsumptionUnit,
  Document.ProdAllocConsistencyStatus AS ProdAllocConsistencyStatus,
  Document.ProdAllocationLifecycleStatus AS ProdAllocationLifecycleStatus,
  Document.CreationDateTime AS CreationDateTime,
  cast(substring(cast( CreationDateTime as abap.char(32)),1,8) as pal_creationdate) AS CreationDate,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  cast(substring(cast( LastChangeDateTime as abap.char(32)),1,8) as pal_lastchangedate) AS LastChangeDate,
  Document.LastChangedByUser AS LastChangedByUser
FROM I_ProductAllocationSequence AS Document
LEFT OUTER JOIN E_ProductAllocationSequence AS _Extension ON _Extension.ProductAllocationSequenceUUID = Document.ProductAllocationSequenceUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocLifecycleStatus AS _ProdAllocLifecycleStatus ON _ProdAllocLifecycleStatus.ProdAllocationLifecycleStatus = ProdAllocationLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocConsistencyStatus AS _ProdAllocConsistencyStatus ON _ProdAllocConsistencyStatus.ProdAllocConsistencyStatus = ProdAllocConsistencyStatus  -- association [0..1]
LEFT OUTER JOIN I_HrzConsumptionDirection AS _HrzConsumptionDirection ON _HrzConsumptionDirection.HorizontalConsumptionDirection = HorizontalConsumptionDirection  -- association [0..1]
LEFT OUTER JOIN I_VerticalConsumptionDirection AS _VerticalConsumptionDirection ON _VerticalConsumptionDirection.VerticalConsumptionDirection = VerticalConsumptionDirection  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = ProdAllocSqncConsumptionUnit  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocSequenceTTP AS _ProdAllocSequenceTTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocSqncGroupTP AS _ProdAllocSqncGroupTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocSqncAssgmtTP AS _ProdAllocSqncAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
;