I_RFDYSurplusBucket

DDL: I_RFDYSURPLUSBUCKET SQL: IRFDYSURPLUS Type: view COMPOSITE Package: ATP_RELFORDEL_VDM
12 Fields 1 Data Sources 3 Associations

Release for Delivery Surplus Bucket

I_RFDYSurplusBucket is a Composite CDS View that provides data about "Release for Delivery Surplus Bucket" in SAP S/4HANA. It reads from 1 data source (P_RFDYSurplusBucketWithWlUUID) and exposes 12 fields with key field RFDYSurplusBucketUUID. It has 3 associations to related views. Part of development package ATP_RELFORDEL_VDM.

Data Sources (1)

SourceAliasJoin Type
P_RFDYSurplusBucketWithWlUUID P_RFDYSurplusBucketWithWlUUID from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_RFDYMaterialWithTotals _RFDYMaterial $projection.RFDYMaterialUUID = _RFDYMaterial.RFDYMaterialUUID
[1..1] I_RFDYWorklistWithTotalQts _RFDYWorklist $projection.RFDYWorklistUUID = _RFDYWorklist.RFDYWorklistUUID
[0..1] I_UnitOfMeasure _BaseUnit $projection.BaseUnit = _BaseUnit.UnitOfMeasure

Annotations (15)

NameValueLevelField
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IRFDYSURPLUS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey RFDYSurplusBucketUUID view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.writeActivePersistence atp_r4d_surplus view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true 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 (12)

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
_BaseUnit _BaseUnit

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_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.
-- SQL view name: IRFDYSURPLUS

CREATE VIEW I_RFDYSurplusBucket AS
SELECT
  RFDYSurplusBucketUUID,
  RFDYMaterialUUID,
  RFDYWorklistUUID,
  SupplyingStorageLocation,
  Batch,
  PeriodStartUTCDateTime,
  SurplusQuantityInBaseUnit,
  UnconsideredQuantityInBaseUnit,
  BaseUnit
FROM P_RFDYSurplusBucketWithWlUUID
LEFT OUTER JOIN I_RFDYMaterialWithTotals AS _RFDYMaterial ON RFDYMaterialUUID = _RFDYMaterial.RFDYMaterialUUID  -- association [1..1]
LEFT OUTER JOIN I_RFDYWorklistWithTotalQts AS _RFDYWorklist ON RFDYWorklistUUID = _RFDYWorklist.RFDYWorklistUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;

Learn More