C_RFDYChangedRequirement

DDL: C_RFDYCHANGEDREQUIREMENT SQL: CRFDYCHNGDREQ Type: view CONSUMPTION
10 Fields 1 Data Sources 1 Associations

Release For Delivery Changed Requirement

C_RFDYChangedRequirement is a Consumption CDS View that provides data about "Release For Delivery Changed Requirement" in SAP S/4HANA. It reads from 1 data source (I_RFDYChangedRequirement) and exposes 10 fields with key field RFDYChangeUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_RFDYChangedRequirement I_RFDYChangedRequirement from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_RFDYRequirementWithCalcFigs _RFDYRequirement $projection.RFDYRequirementUUID = _RFDYRequirement.RFDYRequirementUUID

Annotations (12)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CRFDYCHNGDREQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.representativeKey RFDYChangeUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Release For Delivery Changed Requirement view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RFDYChangeUUID RFDYChangeUUID UUID
RFDYRequirementUUID RFDYRequirementUUID Requirement ID
RFDYWorklistUUID RFDYWorklistUUID Worklist ID
ATPRequirementChangedByUser ATPRequirementChangedByUser User ID
PrevReqdQuantityInBaseUnit PrevReqdQuantityInBaseUnit Requested Qty
PrevReqdProdAvailyUTCDateTme PrevReqdProdAvailyUTCDateTme Req. Mat. Avail. Dte
NewRequestedQuantityInBaseUnit NewRequestedQuantityInBaseUnit Requested Qty
NewReqdProdAvailyUTCDateTme NewReqdProdAvailyUTCDateTme Req. Mat. Avail. Dte
BaseUnit BaseUnit Unit of Measure
_RFDYRequirement _RFDYRequirement

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_RFDYChangedRequirement.
-- 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: CRFDYCHNGDREQ

CREATE VIEW C_RFDYChangedRequirement AS
SELECT
  RFDYChangeUUID,
  RFDYRequirementUUID,
  RFDYWorklistUUID,
  ATPRequirementChangedByUser,
  PrevReqdQuantityInBaseUnit,
  PrevReqdProdAvailyUTCDateTme,
  NewRequestedQuantityInBaseUnit,
  NewReqdProdAvailyUTCDateTme,
  BaseUnit
FROM I_RFDYChangedRequirement
LEFT OUTER JOIN C_RFDYRequirementWithCalcFigs AS _RFDYRequirement ON RFDYRequirementUUID = _RFDYRequirement.RFDYRequirementUUID  -- association [1..1]
;

Learn More