I_AuthzdAccogPartFlxMtPlObjDet

DDL: I_AUTHZDACCOGPARTFLXMTPLOBJDET Type: view_entity COMPOSITE
13 Fields 1 Data Sources 2 Associations

Acc Part details for FMPO FE assignment

I_AuthzdAccogPartFlxMtPlObjDet is a Composite CDS View that provides data about "Acc Part details for FMPO FE assignment" in SAP S/4HANA. It reads from 1 data source (I_DFS_UniversalAssignmentSub) and exposes 13 fields with key field DfsAssgmtNode. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DFS_UniversalAssignmentSub AssgmtSub from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_AuthzdActlFlxMtPlObjVarInfo _FlxMtPlObjVariant $projection.FlxblMatlPlngObjectUUID = _FlxMtPlObjVariant.FlxblMatlPlngObjectUUID and AssgmtSub.FlxMtPlObjVarAccogPrtRefVarID = _FlxMtPlObjVariant.FlxblMatlPlngObjVariantID
[1..1] I_FlxMtPlObjDescription _FlxMtPlObjDescription $projection.FlxblMatlPlngObjectUUID = _FlxMtPlObjDescription.FlxblMatlPlngObjectUUID and _FlxMtPlObjDescription.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Acc Part details for FMPO FE assignment view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DfsAssgmtNode I_DFS_UniversalAssignmentSub DfsAssgmtSubUUID Assigment GUID
FlxblMatlPlngObjectID I_DFS_UniversalAssignmentSub FlxMtPlObjVarAccogPrtRefObjID FMPO ID
FlxblMatlPlngObjVariantID I_DFS_UniversalAssignmentSub FlxMtPlObjVarAccogPrtRefVarID Variant ID
DfsAssgmtUUID I_DFS_UniversalAssignmentSub DfsAssgmtUUID Assigment GUID
FlxblMatlPlngObjectUUID _FlxMtPlObj FlxblMatlPlngObjectUUID FMPO UUID
FlxblMatlPlngObjVariantUUID _FlxMtPlObjVariant FlxblMatlPlngObjVariantUUID Variant UUID
DfsAssgmtCorrectionValue I_DFS_UniversalAssignmentSub DfsAssgmtCorrectionValue Adjustment Value
DfsAssgmtNmbrOfAssgdMatl
AdjustedAuthzdNmbrOfAssgdMatl
FlxblMatlPlngObjDescription _FlxMtPlObjDescription FlxblMatlPlngObjDescription FMPO Description
FlxblMatlPlngObjVariantDesc _FlxMtPlObjVariant FlxblMatlPlngObjVariantDesc Variant Description
_FlxMtPlObjVariant _FlxMtPlObjVariant
_FlxMtPlObjDescription _FlxMtPlObjDescription

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_AuthzdAccogPartFlxMtPlObjDet.
-- 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 I_AuthzdAccogPartFlxMtPlObjDet AS
SELECT
  AssgmtSub.DfsAssgmtSubUUID AS DfsAssgmtNode,
  AssgmtSub.FlxMtPlObjVarAccogPrtRefObjID AS FlxblMatlPlngObjectID,
  AssgmtSub.FlxMtPlObjVarAccogPrtRefVarID AS FlxblMatlPlngObjVariantID,
  AssgmtSub.DfsAssgmtUUID AS DfsAssgmtUUID,
  _FlxMtPlObj.FlxblMatlPlngObjectUUID AS FlxblMatlPlngObjectUUID,
  _FlxMtPlObjVariant.FlxblMatlPlngObjVariantUUID AS FlxblMatlPlngObjVariantUUID,
  AssgmtSub.DfsAssgmtCorrectionValue AS DfsAssgmtCorrectionValue,
  cast(AssgmtSub.FlxMtPlObjVarAccogPrtAuthzdVal as abap.int8) AS DfsAssgmtNmbrOfAssgdMatl,
  cast( cast(AssgmtSub.FlxMtPlObjVarAccogPrtAuthzdVal as abap.int4) + AssgmtSub.DfsAssgmtCorrectionValue as abap.int4) AS AdjustedAuthzdNmbrOfAssgdMatl,
  _FlxMtPlObjDescription.FlxblMatlPlngObjDescription AS FlxblMatlPlngObjDescription,
  _FlxMtPlObjVariant.FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVariantDesc
FROM I_DFS_UniversalAssignmentSub AS AssgmtSub
LEFT OUTER JOIN I_AuthzdActlFlxMtPlObjVarInfo AS _FlxMtPlObjVariant ON FlxblMatlPlngObjectUUID = _FlxMtPlObjVariant.FlxblMatlPlngObjectUUID AND AssgmtSub.FlxMtPlObjVarAccogPrtRefVarID = _FlxMtPlObjVariant.FlxblMatlPlngObjVariantID  -- association [0..1]
LEFT OUTER JOIN I_FlxMtPlObjDescription AS _FlxMtPlObjDescription ON FlxblMatlPlngObjectUUID = _FlxMtPlObjDescription.FlxblMatlPlngObjectUUID AND _FlxMtPlObjDescription.Language = $session.system_language  -- association [1..1]
;

Learn More