What is C_DFS_PosToFlxMtPlObjAssgmt in SAP S/4HANA?

C_DFS_PosToFlxMtPlObjAssgmt is a consumption CDS view in SAP S/4HANA. Consumption view - POS to FMPO List It contains 55 fields.

Which tables does C_DFS_PosToFlxMtPlObjAssgmt read from?

C_DFS_PosToFlxMtPlObjAssgmt reads data from: I_DFS_UniversalAssignmentUnion.

What VDM layer is C_DFS_PosToFlxMtPlObjAssgmt?

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

C_DFS_PosToFlxMtPlObjAssgmt

DDL: C_DFS_POSTOFLXMTPLOBJASSGMT SQL: CDFSPOSTOFMPOASS Type: view CONSUMPTION

55 Fields 1 Data Sources 9 Associations

Consumption view - POS to FMPO List

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

Data Sources (1)

Source	Alias	Join Type
I_DFS_UniversalAssignmentUnion	I_DFS_UniversalAssignmentUnion	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..1]	C_DFS_PositionSuplmntyAttrib	_PositionSuplmntyAttrib	`$projection.DfsPositionSourceID = _PositionSuplmntyAttrib.DfsPositionID`
[1..1]	C_FlxMtPlObjTP	_FlxMtPlObj	`$projection.FlxblMatlPlngObjectUUID = _FlxMtPlObj.FlxblMatlPlngObjectUUID`
[1..1]	C_FlxMtPlObjVariantTP	_Variant	`$projection.FlxblMatlPlngObjVariantUUID = _Variant.FlxblMatlPlngObjVariantUUID`
[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]	C_DFS_AssgmtProvisionsVH	_AssgmtProvisionsVH	`$projection.DfsAssgmtIsOwnProvision = _AssgmtProvisionsVH.DfsAssgmtIsOwnProvision`
[0..1]	C_DFS_AssgmtInitialSupplyStsVH	_AssgmtInitialVH	`$projection.DfsAssgmtInitialSupplyStatus = _AssgmtInitialVH.DfsAssgmtInitialSupplyStatus`
[0..1]	I_FrcElmntOrgUsageType	_UsageType	`$projection.DfsAssgmtUsageType = _UsageType.FrcElmntOrgUsageType`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CDFSPOSTOFMPOASS	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Consumption view - POS to FMPO 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 (55)

Key	Field	Source Table	Source Field	Description
KEY	DfsAssgmtUUID	PosToSupPos	DfsAssgmtUUID	Assigment GUID
KEY	DraftUUID	PosToSupPos	DraftUUID	UUID
	DfsAssgmtActiveDraft	PosToSupPos	DfsAssgmtActiveDraft
	HasActiveEntity	PosToSupPos	HasActiveEntity	TRUE
	HasDraftEntity	PosToSupPos	HasDraftEntity	Has Draft
	DfsAssgmtCreationDateTime	PosToSupPos	DfsAssgmtCreationDateTime	Created On
	DfsAssgmtCreatedByUser	PosToSupPos	DfsAssgmtCreatedByUser	Created By
	DfsAssgmtChangeDateTime	PosToSupPos	DfsAssgmtChangeDateTime	Changed On
	DfsAssgmtLastChgdByUser	PosToSupPos	DfsAssgmtLastChgdByUser	Changed By
	DfsAssgmtValdtyStrtDate	PosToSupPos	DfsAssgmtValdtyStrtDate	Valid From (Date)
	DfsAssgmtValdtyStrtTime	PosToSupPos	DfsAssgmtValdtyStrtTime	Valid From (Time)
	DfsAssgmtValdtyEndDate	PosToSupPos	DfsAssgmtValdtyEndDate	Valid To (Date)
	DfsAssgmtValdtyEndTime	PosToSupPos	DfsAssgmtValdtyEndTime	Valid To (Time)
	DfsAssgmtValdtyTimeZone	PosToSupPos	DfsAssgmtValdtyTimeZone	Valid Time Zone
	DfsAssgmtSourceType	PosToSupPos	DfsAssgmtSourceType	Source Object Type
	DfsAssgmtType	PosToSupPos	DfsAssgmtType	Assignment Type
	FlxblMatlPlngObjectUUID	PosToSupPos	FlxblMatlPlngObjectUUID	FMPO UUID
	FlxblMatlPlngObjVariantUUID	PosToSupPos	FlxblMatlPlngObjVariantUUID	Variant UUID
	DfsAssgmtStatusObject	PosToSupPos	DfsAssgmtStatusObject	Object Number
	DfsAssgmtStatusCode	PosToSupPos	DfsAssgmtStatusCode	Status
	Status
	TimeZoneText	_AssgmtTimeZoneValueHelp	TimeZoneText	Time Zone Text
	DfsAssgmtIsUsedForMassMatlPlng	PosToSupPos	DfsAssgmtIsUsedForMassMatlPlng	Mass Creation Ind
	DfsAssgmtUsageType	PosToSupPos	DfsAssgmtUsageType	Usage Type
	FrcElmntOrgUsageTypeDesc	_UsageType	FrcElmntOrgUsageTypeDesc
	DfsAssgmtMaterialWeightingRate	PosToSupPos	DfsAssgmtMaterialWeightingRate	Weighting Factor
	DfsAssgmtMaterialCategory	PosToSupPos	DfsAssgmtMaterialCategory	Matl Category
	DfsAssgmtMaterialIndicatorCode	PosToSupPos	DfsAssgmtMaterialIndicatorCode	Material Indicator
	DfsAssgmtIsMandForRdnssCalc	PosToSupPos	DfsAssgmtIsMandForRdnssCalc	Readiness Mandatory Indicator
	DfsAssgmtCorrectionValue	PosToSupPos	DfsAssgmtCorrectionValue	Adjustment Value
	DfsAssgmtCorrectionReason	PosToSupPos	DfsAssgmtCorrectionReason	Adjustment Reason
	DfsAssgmtNmbrOfAssgdMatl	PosToSupPos	DfsAssgmtNmbrOfAssgdMatl	Quantity
	DfsAssgmtMinNmbrOfAssgdMatl	PosToSupPos	DfsAssgmtMinNmbrOfAssgdMatl	Minimum Quantity
	DfsAssgmtMaxNmbrOfAssgdMatl	PosToSupPos	DfsAssgmtMaxNmbrOfAssgdMatl	Maximum Quantity
	DfsAssgmtInitialSupplyStatus	PosToSupPos	DfsAssgmtInitialSupplyStatus	Initial Supply Status
	DfsAssgmtInitialSupplyStsDesc	_AssgmtInitialVH	DfsAssgmtInitialSupplyStsDesc
	DfsAssgmtIsOwnProvision	PosToSupPos	DfsAssgmtIsOwnProvision	Initial Supply Relevance
	DfsAssgmtIsOwnProvisionDesc	_AssgmtProvisionsVH	DfsAssgmtIsOwnProvisionDesc
	DfsPositionSourceID		DfsPositionSourceID	Object ID
	FlxblMatlPlngObjectID		FlxblMatlPlngObjectID	FMPO ID
	FlxblMatlPlngObjVariantID		FlxblMatlPlngObjVariantID	Variant ID
	FlxblMatlPlngObjDescription	_FlxMtPlObj	FlxblMatlPlngObjDescription	FMPO Description
	FlxblMatlPlngObjVariantDesc	_Variant	FlxblMatlPlngObjVariantDesc	Variant Description
	DfsAssgmtPlanOperationCode		DfsAssgmtPlanOperationCode	Planned Op. Code
	DfsAssgmtPlanOperationCodeDesc
	DfsAssgmtPlanStatusObject		DfsAssgmtPlanStatusObject	Planning status
	DfsAssgmtPlanDelimitDate		DfsAssgmtPlanDelimitDate	Planned Del. Date
	DfsAssgmtPlanOperationStatus
	DfsAssgmtPlanOpStsCriticality	_PlanStatusObjectActiveStatus	StatusCriticality
	_PositionSuplmntyAttrib		_PositionSuplmntyAttrib
	_FlxMtPlObj		_FlxMtPlObj
	_Variant		_Variant
	_StatusAttributes		_StatusAttributes
	_TechnicalStatusText		_TechnicalStatusText
	_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_PosToFlxMtPlObjAssgmt.
-- 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: CDFSPOSTOFMPOASS

CREATE VIEW C_DFS_PosToFlxMtPlObjAssgmt AS
SELECT
  PosToSupPos.DfsAssgmtUUID AS DfsAssgmtUUID,
  PosToSupPos.DraftUUID AS DraftUUID,
  PosToSupPos.DfsAssgmtActiveDraft AS DfsAssgmtActiveDraft,
  PosToSupPos.HasActiveEntity AS HasActiveEntity,
  PosToSupPos.HasDraftEntity AS HasDraftEntity,
  PosToSupPos.DfsAssgmtCreationDateTime AS DfsAssgmtCreationDateTime,
  PosToSupPos.DfsAssgmtCreatedByUser AS DfsAssgmtCreatedByUser,
  PosToSupPos.DfsAssgmtChangeDateTime AS DfsAssgmtChangeDateTime,
  PosToSupPos.DfsAssgmtLastChgdByUser AS DfsAssgmtLastChgdByUser,
  PosToSupPos.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  PosToSupPos.DfsAssgmtValdtyStrtTime AS DfsAssgmtValdtyStrtTime,
  PosToSupPos.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  PosToSupPos.DfsAssgmtValdtyEndTime AS DfsAssgmtValdtyEndTime,
  PosToSupPos.DfsAssgmtValdtyTimeZone AS DfsAssgmtValdtyTimeZone,
  PosToSupPos.DfsAssgmtSourceType AS DfsAssgmtSourceType,
  PosToSupPos.DfsAssgmtType AS DfsAssgmtType,
  PosToSupPos.FlxblMatlPlngObjectUUID AS FlxblMatlPlngObjectUUID,
  PosToSupPos.FlxblMatlPlngObjVariantUUID AS FlxblMatlPlngObjVariantUUID,
  PosToSupPos.DfsAssgmtStatusObject AS DfsAssgmtStatusObject,
  PosToSupPos.DfsAssgmtStatusCode AS DfsAssgmtStatusCode,
  _StatusAttributes._SystemStatusText[1:Language = $session.system_language].SystemStatusName AS Status,
  _AssgmtTimeZoneValueHelp.TimeZoneText AS TimeZoneText,
  PosToSupPos.DfsAssgmtIsUsedForMassMatlPlng AS DfsAssgmtIsUsedForMassMatlPlng,
  PosToSupPos.DfsAssgmtUsageType AS DfsAssgmtUsageType,
  _UsageType.FrcElmntOrgUsageTypeDesc AS FrcElmntOrgUsageTypeDesc,
  PosToSupPos.DfsAssgmtMaterialWeightingRate AS DfsAssgmtMaterialWeightingRate,
  PosToSupPos.DfsAssgmtMaterialCategory AS DfsAssgmtMaterialCategory,
  PosToSupPos.DfsAssgmtMaterialIndicatorCode AS DfsAssgmtMaterialIndicatorCode,
  PosToSupPos.DfsAssgmtIsMandForRdnssCalc AS DfsAssgmtIsMandForRdnssCalc,
  PosToSupPos.DfsAssgmtCorrectionValue AS DfsAssgmtCorrectionValue,
  PosToSupPos.DfsAssgmtCorrectionReason AS DfsAssgmtCorrectionReason,
  PosToSupPos.DfsAssgmtNmbrOfAssgdMatl AS DfsAssgmtNmbrOfAssgdMatl,
  PosToSupPos.DfsAssgmtMinNmbrOfAssgdMatl AS DfsAssgmtMinNmbrOfAssgdMatl,
  PosToSupPos.DfsAssgmtMaxNmbrOfAssgdMatl AS DfsAssgmtMaxNmbrOfAssgdMatl,
  PosToSupPos.DfsAssgmtInitialSupplyStatus AS DfsAssgmtInitialSupplyStatus,
  _AssgmtInitialVH.DfsAssgmtInitialSupplyStsDesc AS DfsAssgmtInitialSupplyStsDesc,
  PosToSupPos.DfsAssgmtIsOwnProvision AS DfsAssgmtIsOwnProvision,
  _AssgmtProvisionsVH.DfsAssgmtIsOwnProvisionDesc AS DfsAssgmtIsOwnProvisionDesc,
  DfsPositionSourceID,
  FlxblMatlPlngObjectID,
  FlxblMatlPlngObjVariantID,
  _FlxMtPlObj.FlxblMatlPlngObjDescription AS FlxblMatlPlngObjDescription,
  _Variant.FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVariantDesc,
  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_DFS_PositionSuplmntyAttrib AS _PositionSuplmntyAttrib ON DfsPositionSourceID = _PositionSuplmntyAttrib.DfsPositionID  -- association [0..1]
LEFT OUTER JOIN C_FlxMtPlObjTP AS _FlxMtPlObj ON FlxblMatlPlngObjectUUID = _FlxMtPlObj.FlxblMatlPlngObjectUUID  -- association [1..1]
LEFT OUTER JOIN C_FlxMtPlObjVariantTP AS _Variant ON FlxblMatlPlngObjVariantUUID = _Variant.FlxblMatlPlngObjVariantUUID  -- association [1..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 C_DFS_AssgmtProvisionsVH AS _AssgmtProvisionsVH ON DfsAssgmtIsOwnProvision = _AssgmtProvisionsVH.DfsAssgmtIsOwnProvision  -- association [0..1]
LEFT OUTER JOIN C_DFS_AssgmtInitialSupplyStsVH AS _AssgmtInitialVH ON DfsAssgmtInitialSupplyStatus = _AssgmtInitialVH.DfsAssgmtInitialSupplyStatus  -- association [0..1]
LEFT OUTER JOIN I_FrcElmntOrgUsageType AS _UsageType ON DfsAssgmtUsageType = _UsageType.FrcElmntOrgUsageType  -- association [0..1]
;

Depth:

C_DFS_PosToFlxMtPlObjAssgmt view

I_DFS_UniversalAssignmentUnion view

C_DFS_PosAssgmtAccogPartHier view