What is C_DFS_AssgmtFeToProdList in SAP S/4HANA?

C_DFS_AssgmtFeToProdList is a consumption CDS view in SAP S/4HANA. Consumption view - FE to Product List It contains 46 fields.

Which tables does C_DFS_AssgmtFeToProdList read from?

C_DFS_AssgmtFeToProdList reads data from: I_DFS_UniversalAssignmentUnion.

What VDM layer is C_DFS_AssgmtFeToProdList?

C_DFS_AssgmtFeToProdList is classified as a Consumption view optimized for specific business scenarios and reporting.

C_DFS_AssgmtFeToProdList

DDL: C_DFS_ASSGMTFETOPRODLIST SQL: CDFSASSGMTPRODL Type: view CONSUMPTION

46 Fields 1 Data Sources 7 Associations

Consumption view - FE to Product List

C_DFS_AssgmtFeToProdList is a Consumption CDS View that provides data about "Consumption view - FE to Product List" in SAP S/4HANA. It reads from 1 data source (I_DFS_UniversalAssignmentUnion) and exposes 46 fields with key fields DfsAssgmtUUID, DraftUUID. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_DFS_UniversalAssignmentUnion	I_DFS_UniversalAssignmentUnion	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..1]	C_FrcElmntSuplmntyAttribAssgmt	_SrceFrcElmntOrgTP	`$projection.ForceElementOrgSrceID = _SrceFrcElmntOrgTP.ForceElementOrgID`
[0..1]	C_Product	_Product	`$projection.Product = _Product.Product`
[0..1]	I_DFS_StatusAttributes	_StatusAttributes	`$projection.DfsAssgmtStatusCode = _StatusAttributes.SystemStatus`
[0..*]	I_DFS_TechnicalStatusText	_TechnicalStatusText	`$projection.DfsAssgmtActiveDraft = _TechnicalStatusText.DfsAssgmtTechnicalStatus`
[0..1]	C_DFS_TimeZoneVH	_AssgmtTimeZoneValueHelp	`$projection.DfsAssgmtValdtyTimeZone = _AssgmtTimeZoneValueHelp.TimeZoneID`
[0..1]	I_ProductStdVH	_MaterialVH	`$projection.Product = _MaterialVH.Product`
[0..1]	I_DFS_AllwncPlan	_AllwncPlan	`$projection.DfsAssgmtSourceObjectUUID = _AllwncPlan.DfsAllwncPlanUUID`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CDFSASSGMTPRODL	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Consumption view - FE to Product List	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
Search.searchable	true	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	DfsAssgmtUUID	FeToSupFe	DfsAssgmtUUID	Assigment GUID
KEY	DraftUUID	FeToSupFe	DraftUUID	UUID
	DfsAssgmtActiveDraft	FeToSupFe	DfsAssgmtActiveDraft
	HasActiveEntity	FeToSupFe	HasActiveEntity	TRUE
	HasDraftEntity	FeToSupFe	HasDraftEntity	Has Draft
	DfsAssgmtCreationDateTime	FeToSupFe	DfsAssgmtCreationDateTime	Created On
	DfsAssgmtCreatedByUser	FeToSupFe	DfsAssgmtCreatedByUser	Created By
	DfsAssgmtChangeDateTime	FeToSupFe	DfsAssgmtChangeDateTime	Changed On
	DfsAssgmtLastChgdByUser	FeToSupFe	DfsAssgmtLastChgdByUser	Changed By
	DfsAssgmtValdtyStrtDate	FeToSupFe	DfsAssgmtValdtyStrtDate	Valid Start Date
	DfsAssgmtValdtyStrtTime	FeToSupFe	DfsAssgmtValdtyStrtTime	Valid Start Time
	DfsAssgmtValdtyEndDate	FeToSupFe	DfsAssgmtValdtyEndDate	Valid End Date
	DfsAssgmtValdtyEndTime	FeToSupFe	DfsAssgmtValdtyEndTime	Valid End Time
	DfsAssgmtValdtyTimeZone	FeToSupFe	DfsAssgmtValdtyTimeZone	Time Zone
	DfsAssgmtSourceType	FeToSupFe	DfsAssgmtSourceType	Source Type
	DfsAssgmtType	FeToSupFe	DfsAssgmtType	Assignment Type
	DfsAssgmtIsDefaultAssignment	FeToSupFe	DfsAssgmtIsDefaultAssignment	Default Assignment
	DfsAssgmtExternalProductGroup	FeToSupFe	DfsAssgmtExternalProductGroup	Product List
	ForceElementOrgTargetUUID	FeToSupFe	ForceElementOrgTargetUUID	Target UUID
	ForceElementOrgSrceUUID	FeToSupFe	ForceElementOrgSrceUUID	Source UUID
	DfsAssgmtStatusObject	FeToSupFe	DfsAssgmtStatusObject	Status Object
	DfsAssgmtStatusCode	FeToSupFe	DfsAssgmtStatusCode	Status Code
	Status
	TimeZoneText	_AssgmtTimeZoneValueHelp	TimeZoneText	Time Zone Text
	DfsAssgmtSourceObjectUUID	FeToSupFe	DfsAssgmtSourceObjectUUID	Source UUID
	DfsAllwncPlanID	_AllwncPlan	DfsAllwncPlanID	Plan ID
	DfsAllwncPlanUUID	_AllwncPlan	DfsAllwncPlanUUID	Allowance Plan UUID
	DfsAssgmtUsageType		DfsAssgmtUsageType	Usage Type
	DfsAssgmtNmbrOfAssgdMatl		DfsAssgmtNmbrOfAssgdMatl	Quantity
	Product	FeToSupFe	Product	Product Sold
	MaterialName
	DfsAssgmtInitialSupplyStatus	FeToSupFe	DfsAssgmtInitialSupplyStatus	Initial Supply Status
	DfsAssgmtIsOwnProvision	FeToSupFe	DfsAssgmtIsOwnProvision	Initial Supply Relevance
	ForceElementOrgSrceID		ForceElementOrgSrceID	Object ID
	DfsAssgmtPlanOperationCode		DfsAssgmtPlanOperationCode	Planned Op. Code
	DfsAssgmtPlanOperationCodeDesc
	DfsAssgmtPlanStatusObject		DfsAssgmtPlanStatusObject	Planning status
	DfsAssgmtPlanDelimitDate		DfsAssgmtPlanDelimitDate	Planned Del. Date
	DfsAssgmtPlanOperationStatus
	DfsAssgmtPlanOpStsCriticality	_PlanStatusObjectActiveStatus	StatusCriticality
	_SrceFrcElmntOrgTP		_SrceFrcElmntOrgTP
	_Product		_Product
	_StatusAttributes		_StatusAttributes
	_TechnicalStatusText		_TechnicalStatusText
	_AllwncPlan		_AllwncPlan
	_PlannedOperation		_PlannedOperation

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_DFS_AssgmtFeToProdList.
-- 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: CDFSASSGMTPRODL

CREATE VIEW C_DFS_AssgmtFeToProdList AS
SELECT
  FeToSupFe.DfsAssgmtUUID AS DfsAssgmtUUID,
  FeToSupFe.DraftUUID AS DraftUUID,
  FeToSupFe.DfsAssgmtActiveDraft AS DfsAssgmtActiveDraft,
  FeToSupFe.HasActiveEntity AS HasActiveEntity,
  FeToSupFe.HasDraftEntity AS HasDraftEntity,
  FeToSupFe.DfsAssgmtCreationDateTime AS DfsAssgmtCreationDateTime,
  FeToSupFe.DfsAssgmtCreatedByUser AS DfsAssgmtCreatedByUser,
  FeToSupFe.DfsAssgmtChangeDateTime AS DfsAssgmtChangeDateTime,
  FeToSupFe.DfsAssgmtLastChgdByUser AS DfsAssgmtLastChgdByUser,
  FeToSupFe.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  FeToSupFe.DfsAssgmtValdtyStrtTime AS DfsAssgmtValdtyStrtTime,
  FeToSupFe.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  FeToSupFe.DfsAssgmtValdtyEndTime AS DfsAssgmtValdtyEndTime,
  FeToSupFe.DfsAssgmtValdtyTimeZone AS DfsAssgmtValdtyTimeZone,
  FeToSupFe.DfsAssgmtSourceType AS DfsAssgmtSourceType,
  FeToSupFe.DfsAssgmtType AS DfsAssgmtType,
  FeToSupFe.DfsAssgmtIsDefaultAssignment AS DfsAssgmtIsDefaultAssignment,
  FeToSupFe.DfsAssgmtExternalProductGroup AS DfsAssgmtExternalProductGroup,
  FeToSupFe.ForceElementOrgTargetUUID AS ForceElementOrgTargetUUID,
  FeToSupFe.ForceElementOrgSrceUUID AS ForceElementOrgSrceUUID,
  FeToSupFe.DfsAssgmtStatusObject AS DfsAssgmtStatusObject,
  FeToSupFe.DfsAssgmtStatusCode AS DfsAssgmtStatusCode,
  _StatusAttributes._SystemStatusText[1:Language = $session.system_language].SystemStatusName AS Status,
  _AssgmtTimeZoneValueHelp.TimeZoneText AS TimeZoneText,
  FeToSupFe.DfsAssgmtSourceObjectUUID AS DfsAssgmtSourceObjectUUID,
  _AllwncPlan.DfsAllwncPlanID AS DfsAllwncPlanID,
  _AllwncPlan.DfsAllwncPlanUUID AS DfsAllwncPlanUUID,
  DfsAssgmtUsageType,
  DfsAssgmtNmbrOfAssgdMatl,
  FeToSupFe.Product AS Product,
  _MaterialVH._Text[1:Language = $session.system_language].ProductName AS MaterialName,
  FeToSupFe.DfsAssgmtInitialSupplyStatus AS DfsAssgmtInitialSupplyStatus,
  FeToSupFe.DfsAssgmtIsOwnProvision AS DfsAssgmtIsOwnProvision,
  ForceElementOrgSrceID,
  DfsAssgmtPlanOperationCode,
  _PlannedOperation._Text[1:Language = $session.system_language].DfsAssgmtPlanOperationCodeDesc AS DfsAssgmtPlanOperationCodeDesc,
  DfsAssgmtPlanStatusObject,
  DfsAssgmtPlanDelimitDate,
  _PlanStatusObjectActiveStatus._StatusCode._StatusCodeText[1:Language = $session.system_language].StatusName AS DfsAssgmtPlanOperationStatus,
  _PlanStatusObjectActiveStatus.StatusCriticality AS DfsAssgmtPlanOpStsCriticality
FROM I_DFS_UniversalAssignmentUnion
LEFT OUTER JOIN C_FrcElmntSuplmntyAttribAssgmt AS _SrceFrcElmntOrgTP ON ForceElementOrgSrceID = _SrceFrcElmntOrgTP.ForceElementOrgID  -- association [0..1]
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_DFS_StatusAttributes AS _StatusAttributes ON DfsAssgmtStatusCode = _StatusAttributes.SystemStatus  -- association [0..1]
LEFT OUTER JOIN I_DFS_TechnicalStatusText AS _TechnicalStatusText ON DfsAssgmtActiveDraft = _TechnicalStatusText.DfsAssgmtTechnicalStatus  -- association [0..*]
LEFT OUTER JOIN C_DFS_TimeZoneVH AS _AssgmtTimeZoneValueHelp ON DfsAssgmtValdtyTimeZone = _AssgmtTimeZoneValueHelp.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_ProductStdVH AS _MaterialVH ON Product = _MaterialVH.Product  -- association [0..1]
LEFT OUTER JOIN I_DFS_AllwncPlan AS _AllwncPlan ON DfsAssgmtSourceObjectUUID = _AllwncPlan.DfsAllwncPlanUUID  -- association [0..1]
;

Depth:

C_DFS_AssgmtFeToProdList view

I_DFS_UniversalAssignmentUnion view