P_ProdAllocAgingData

DDL: P_PRODALLOCAGINGDATA SQL: PALAGING Type: view COMPOSITE
12 Fields 4 Data Sources

P_ProdAllocAgingData is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (paplng_daag_c, I_ProductAllocationObject, I_ProdAllocQuantityAssignment, I_ProdAllocObjectTimeSeries) and exposes 12 fields.

Data Sources (4)

SourceAliasJoin Type
paplng_daag_c cust left_outer
I_ProductAllocationObject pao left_outer
I_ProdAllocQuantityAssignment qa left_outer
I_ProdAllocObjectTimeSeries ts from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PALAGING view
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
ProdAllocationTimeSeriesUUID I_ProdAllocObjectTimeSeries ProdAllocationTimeSeriesUUID Product Allocation Time SeriesUUID
ProdAllocAssignedOrder I_ProdAllocQuantityAssignment ProdAllocAssignedOrder Assigned Order
ProdAllocAssignedOrderItem I_ProdAllocQuantityAssignment ProdAllocAssignedOrderItem Assigned Order Item
ProdAllocAssignedOrderType I_ProdAllocQuantityAssignment ProdAllocAssignedOrderType Order Type
ProdAllocPerdStartUTCDateTime I_ProdAllocQuantityAssignment ProdAllocPerdStartUTCDateTime Period Start Date Time
ConfirmationUTCDateTime I_ProdAllocQuantityAssignment ConfirmationUTCDateTime Confirmation Date Time
AssignmentSequenceNumberValue I_ProdAllocQuantityAssignment AssignmentSequenceNumberValue Assignment Sequence Number
ProdAllocPeriodEndDate
CharcValueCombinationUUID I_ProdAllocQuantityAssignment CharcValueCombinationUUID Characteristic Value Combination UUID
ProductAllocationObjectUUID I_ProductAllocationObject ProductAllocationObjectUUID Product Allocation Object UUID
ProductAllocationObject I_ProductAllocationObject ProductAllocationObject Allocation Object
ProdAllocObjPeriodAgedToDate I_ProductAllocationObject ProdAllocObjPeriodAgedToDate Periods Aged Until Date

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 P_ProdAllocAgingData.
-- 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: PALAGING

CREATE VIEW P_ProdAllocAgingData AS
SELECT
  ts.ProdAllocationTimeSeriesUUID AS ProdAllocationTimeSeriesUUID,
  qa.ProdAllocAssignedOrder AS ProdAllocAssignedOrder,
  qa.ProdAllocAssignedOrderItem AS ProdAllocAssignedOrderItem,
  qa.ProdAllocAssignedOrderType AS ProdAllocAssignedOrderType,
  qa.ProdAllocPerdStartUTCDateTime AS ProdAllocPerdStartUTCDateTime,
  qa.ConfirmationUTCDateTime AS ConfirmationUTCDateTime,
  qa.AssignmentSequenceNumberValue AS AssignmentSequenceNumberValue,
  tstmp_to_dats(ts.ProdAllocPeriodEndUTCDateTime, ts.ProdAllocPeriodEndTimeZone, $session.client, 'NULL') AS ProdAllocPeriodEndDate,
  qa.CharcValueCombinationUUID AS CharcValueCombinationUUID,
  pao.ProductAllocationObjectUUID AS ProductAllocationObjectUUID,
  pao.ProductAllocationObject AS ProductAllocationObject,
  pao.ProdAllocObjPeriodAgedToDate AS ProdAllocObjPeriodAgedToDate
FROM I_ProdAllocObjectTimeSeries AS ts
LEFT OUTER JOIN I_ProductAllocationObject AS pao ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN paplng_daag_c AS cust ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdAllocQuantityAssignment AS qa ON /* join condition not captured in parsed metadata */
;

Learn More