P_AllocRcvrTracingRefCount

DDL: P_ALLOCRCVRTRACINGREFCOUNT SQL: PALORCVRREFCNT Type: view CONSUMPTION
6 Fields 2 Data Sources

P_AllocRcvrTracingRefCount is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_AllocationKeyField, I_AllocTopDwnDistrRefFld) and exposes 6 fields with key fields AllocationCycle, AllocationType, AllocationCycleStartDate, AllocationCycleSegment, AllocDocumentSequenceNumber.

Data Sources (2)

SourceAliasJoin Type
I_AllocationKeyField kf from
I_AllocTopDwnDistrRefFld ref inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PALORCVRREFCNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AllocationCycle I_AllocationKeyField AllocationCycle Cycle
KEY AllocationType I_AllocationKeyField AllocationType Table
KEY AllocationCycleStartDate I_AllocationKeyField AllocationCycleStartDate Valid From
KEY AllocationCycleSegment I_AllocationKeyField AllocationCycleSegment Segment Number
KEY AllocDocumentSequenceNumber I_AllocationKeyField AllocDocumentSequenceNumber Table position
RefCount

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_AllocRcvrTracingRefCount.
-- 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: PALORCVRREFCNT

CREATE VIEW P_AllocRcvrTracingRefCount AS
SELECT
  kf.AllocationCycle AS AllocationCycle,
  kf.AllocationType AS AllocationType,
  kf.AllocationCycleStartDate AS AllocationCycleStartDate,
  kf.AllocationCycleSegment AS AllocationCycleSegment,
  kf.AllocDocumentSequenceNumber AS AllocDocumentSequenceNumber,
  count( * ) AS RefCount
FROM I_AllocationKeyField AS kf
INNER JOIN I_AllocTopDwnDistrRefFld AS ref ON /* join condition not captured in parsed metadata */
;

Learn More