C_RFDYSurplusBucket

DDL: C_RFDYSURPLUSBUCKET Type: view_entity CONSUMPTION
11 Fields 1 Data Sources 2 Associations

Release for Delivery Surplus Bucket

C_RFDYSurplusBucket is a Consumption CDS View that provides data about "Release for Delivery Surplus Bucket" in SAP S/4HANA. It reads from 1 data source (I_RFDYSurplusBucket) and exposes 11 fields with key field RFDYSurplusBucketUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RFDYSurplusBucket I_RFDYSurplusBucket from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_RFDYMaterialWithTotals _RFDYMaterial $projection.RFDYMaterialUUID = _RFDYMaterial.RFDYMaterialUUID
[1..1] C_RFDYPrsnlWorklistWithTotQts _RFDYWorklist $projection.RFDYWorklistUUID = _RFDYWorklist.RFDYWorklistUUID

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Release for Delivery Surplus Bucket view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY RFDYSurplusBucketUUID RFDYSurplusBucketUUID Surplus ID
RFDYMaterialUUID RFDYMaterialUUID Material ID
RFDYWorklistUUID RFDYWorklistUUID Worklist ID
SupplyingStorageLocation SupplyingStorageLocation Location
Batch Batch Lot No.
PeriodStartUTCDateTime PeriodStartUTCDateTime Time Stamp
SurplusQuantityInBaseUnit SurplusQuantityInBaseUnit Surplus Quantity
UnconsideredQuantityInBaseUnit UnconsideredQuantityInBaseUnit Unconsidered Qty
BaseUnit BaseUnit Unit of Measure
_RFDYMaterial _RFDYMaterial
_RFDYWorklist _RFDYWorklist

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 C_RFDYSurplusBucket.
-- 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 C_RFDYSurplusBucket AS
SELECT
  RFDYSurplusBucketUUID,
  RFDYMaterialUUID,
  RFDYWorklistUUID,
  SupplyingStorageLocation,
  Batch,
  PeriodStartUTCDateTime,
  SurplusQuantityInBaseUnit,
  UnconsideredQuantityInBaseUnit,
  BaseUnit
FROM I_RFDYSurplusBucket
LEFT OUTER JOIN C_RFDYMaterialWithTotals AS _RFDYMaterial ON RFDYMaterialUUID = _RFDYMaterial.RFDYMaterialUUID  -- association [1..1]
LEFT OUTER JOIN C_RFDYPrsnlWorklistWithTotQts AS _RFDYWorklist ON RFDYWorklistUUID = _RFDYWorklist.RFDYWorklistUUID  -- association [1..1]
;

Learn More