P_ProdAllocDataForAging

DDL: P_PRODALLOCDATAFORAGING SQL: PPADATAAG Type: view COMPOSITE Package: PRODUCT_ALLOCATION_OBJECT
15 Fields 1 Data Sources

Contains QAs and their time series which are to be aged

P_ProdAllocDataForAging is a Composite CDS View that provides data about "Contains QAs and their time series which are to be aged" in SAP S/4HANA. It reads from 1 data source (P_ProdAllocAgingData) and exposes 15 fields. Part of development package PRODUCT_ALLOCATION_OBJECT.

Data Sources (1)

SourceAliasJoin Type
P_ProdAllocAgingData P_ProdAllocAgingData from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPADATAAG 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 (15)

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

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_ProdAllocDataForAging.
-- 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: PPADATAAG

CREATE VIEW P_ProdAllocDataForAging AS
SELECT
  $session.client AS Client,
  ProductAllocationObjectUUID,
  ProductAllocationObject,
  ProdAllocationTimeSeriesUUID,
  ProdAllocAssignedOrder,
  ProdAllocAssignedOrderItem,
  ProdAllocAssignedOrderType,
  ProdAllocPerdStartUTCDateTime,
  ConfirmationUTCDateTime,
  AssignmentSequenceNumberValue,
  ProdAllocPeriodEndDate,
  CharcValueCombinationUUID,
  DATS_ADD_DAYS( ProdAllocPeriodEndDate, residence_time, 'NULL') AS AgingDate,
  ProdAllocObjPeriodAgedToDate,
  order_count
FROM P_ProdAllocAgingData
;

Learn More