I_AuthzdFlxMtPlObjDetail

DDL: I_AUTHZDFLXMTPLOBJDETAIL Type: view_entity COMPOSITE
44 Fields 1 Data Sources 8 Associations

FMPO details for FMPO FE assignment

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

Data Sources (1)

SourceAliasJoin Type
I_DFS_UniversalAssignmentBasic I_DFS_UniversalAssignmentBasic from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_FrcElmntOrgUsageType _UsageType $projection.DfsAssgmtUsageType = _UsageType.FrcElmntOrgUsageType
[0..1] I_DFS_AssgmtMaterialIndicator _MaterialIndicator $projection.DfsAssgmtMaterialIndicatorCode = _MaterialIndicator.DfsAssgmtMaterialIndicatorCode
[0..1] I_DFS_AssgmtMaterialCategory _MaterialCategory $projection.DfsAssgmtMaterialCategory = _MaterialCategory.DfsAssgmtMaterialCategory
[1..1] I_DFS_AssgmtMassCreationIndT _MassCreationIndDesc $projection.DfsAssgmtIsUsedForMassMatlPlng = _MassCreationIndDesc.DfsAssgmtIsUsedForMassMatlPlng and _MassCreationIndDesc.Language = $session.system_language
[1..1] I_FrcElmntOrgBasic _FrcElmntOrg $projection.ForceElementOrgSrceID = _FrcElmntOrg.ForceElementOrgID
[1..1] I_FlxMtPlObjDescription _FlxMtPlObjDescription $projection.FlxblMatlPlngObjectUUID = _FlxMtPlObjDescription.FlxblMatlPlngObjectUUID and _FlxMtPlObjDescription.Language = $session.system_language
[1..1] I_AuthzdActlFlxMtPlObjVarInfo _FlxMtPlObjVariant $projection.FlxblMatlPlngObjVariantUUID = _FlxMtPlObjVariant.FlxblMatlPlngObjVariantUUID
[0..1] I_DFS_StatusAttributes _StatusAttributes $projection.DfsAssgmtStatusCode = _StatusAttributes.SystemStatus

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FMPO 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 (44)

KeyFieldSource TableSource FieldDescription
KEY DfsAssgmtNode DfsAssgmtUUID Assigment GUID
ForceElementOrgSrceID ForceElementOrgSrceID Object ID
FlxblMatlPlngObjectID FlxblMatlPlngObjectID FMPO ID
DfsAssgmtUsageType DfsAssgmtUsageType Usage Type
DfsAssgmtValdtyStrtDate DfsAssgmtValdtyStrtDate Valid From (Date)
DfsAssgmtValdtyEndDate DfsAssgmtValdtyEndDate Valid To (Date)
DfsAssgmtStatusCode DfsAssgmtStatusCode Status
DfsAssgmtIsUsedForMassMatlPlng DfsAssgmtIsUsedForMassMatlPlng Mass Creation Ind
DfsAssgmtUUID DfsAssgmtUUID Assigment GUID
DfsAssgmtSourceType DfsAssgmtSourceType Source Object Type
DfsAssgmtCorrectionValue DfsAssgmtCorrectionValue Adjustment Value
FlxblMatlPlngObjVariantUUID FlxblMatlPlngObjVariantUUID Variant UUID
FlxblMatlPlngObjectUUID FlxblMatlPlngObjectUUID FMPO UUID
DfsAssgmtType DfsAssgmtType Assignment Type
DfsAssgmtPriority DfsAssgmtPriority Priority
FlxblMatlPlngObjVariantID FlxblMatlPlngObjVariantID Variant ID
FlxblMatlPlngObjDescription _FlxMtPlObjDescription FlxblMatlPlngObjDescription FMPO Description
FlxblMatlPlngObjVariantDesc _FlxMtPlObjVariant FlxblMatlPlngObjVariantDesc Variant Description
DfsAssgmtNmbrOfAssgdMatl Quantity
AdjustedAuthzdNmbrOfAssgdMatl Quantity
int8endasDfsAssgmtMaxNmbrOfAssgdMatl Maximum Quantity
int8endasDfsAssgmtMinNmbrOfAssgdMatl Minimum Quantity
FrcElmntOrgUsageTypeDesc _UsageType FrcElmntOrgUsageTypeDesc
DfsAssgmtMaterialWeightingRate DfsAssgmtMaterialWeightingRate Weighting Factor
DfsAssgmtMaterialIndicatorCode DfsAssgmtMaterialIndicatorCode Material Indicator
DfsAssgmtMaterialIndicatorDesc
DfsAssgmtMaterialIndicatorType _MaterialIndicator DfsAssgmtMaterialIndicatorType
DfsAssgmtMaterialCategory DfsAssgmtMaterialCategory Matl Category
DfsAssgmtMaterialCategoryDesc
DomainText
FrcElmntOrgStockPlant _FrcElmntOrg FrcElmntOrgStockPlant Plant
FrcElmntOrgStockStorageLoc _FrcElmntOrg FrcElmntOrgStockStorageLoc Location
FrcElmntOrgInfrstrucPlant _FrcElmntOrg FrcElmntOrgInfrstrucPlant Plant
FrcElmOrgInfrStorLoc _FrcElmntOrg FrcElmOrgInfrStorLoc Location
FrcElmOrgInfrMRPArea _FrcElmntOrg FrcElmOrgInfrMRPArea Infra. MRP Area
SystemStatusName
_UsageType _UsageType
_MaterialCategory _MaterialCategory
_MaterialIndicator _MaterialIndicator
_MassCreationIndDesc _MassCreationIndDesc
_FrcElmntOrg _FrcElmntOrg
_FlxMtPlObjDescription _FlxMtPlObjDescription
_FlxMtPlObjVariant _FlxMtPlObjVariant
_StatusAttributes _StatusAttributes

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_AuthzdFlxMtPlObjDetail.
-- 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_AuthzdFlxMtPlObjDetail AS
SELECT
  DfsAssgmtUUID AS DfsAssgmtNode,
  ForceElementOrgSrceID,
  FlxblMatlPlngObjectID,
  DfsAssgmtUsageType,
  DfsAssgmtValdtyStrtDate,
  DfsAssgmtValdtyEndDate,
  DfsAssgmtStatusCode,
  DfsAssgmtIsUsedForMassMatlPlng,
  DfsAssgmtUUID,
  DfsAssgmtSourceType,
  DfsAssgmtCorrectionValue,
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjectUUID,
  DfsAssgmtType,
  DfsAssgmtPriority,
  FlxblMatlPlngObjVariantID,
  _FlxMtPlObjDescription.FlxblMatlPlngObjDescription AS FlxblMatlPlngObjDescription,
  _FlxMtPlObjVariant.FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVariantDesc,
  cast(DfsAssgmtNmbrOfAssgdMatl as abap.int8) AS DfsAssgmtNmbrOfAssgdMatl,
  cast( cast(DfsAssgmtNmbrOfAssgdMatl as abap.int8) + DfsAssgmtCorrectionValue as abap.int4 ) AS AdjustedAuthzdNmbrOfAssgdMatl,
  case cast(DfsAssgmtMaxNmbrOfAssgdMatl as abap.int8) when 0 then cast(DfsAssgmtNmbrOfAssgdMatl as abap.int8) + DfsAssgmtCorrectionValue else cast(DfsAssgmtMaxNmbrOfAssgdMatl as abap.int8) end as DfsAssgmtMaxNmbrOfAssgdMatl AS int8endasDfsAssgmtMaxNmbrOfAssgdMatl,
  case cast(DfsAssgmtMinNmbrOfAssgdMatl as abap.int8) when 0 then ( cast(DfsAssgmtNmbrOfAssgdMatl as abap.int8) + DfsAssgmtCorrectionValue) else cast(DfsAssgmtMinNmbrOfAssgdMatl as abap.int8) end as DfsAssgmtMinNmbrOfAssgdMatl AS int8endasDfsAssgmtMinNmbrOfAssgdMatl,
  _UsageType.FrcElmntOrgUsageTypeDesc AS FrcElmntOrgUsageTypeDesc,
  DfsAssgmtMaterialWeightingRate,
  DfsAssgmtMaterialIndicatorCode,
  _MaterialIndicator._Text[1:Language=$session.system_language].DfsAssgmtMaterialIndicatorDesc AS DfsAssgmtMaterialIndicatorDesc,
  _MaterialIndicator.DfsAssgmtMaterialIndicatorType AS DfsAssgmtMaterialIndicatorType,
  DfsAssgmtMaterialCategory,
  _MaterialCategory._Text[1:Language=$session.system_language].DfsAssgmtMaterialCategoryDesc AS DfsAssgmtMaterialCategoryDesc,
  _MassCreationIndDesc[1:Language=$session.system_language].DomainText AS DomainText,
  _FrcElmntOrg.FrcElmntOrgStockPlant AS FrcElmntOrgStockPlant,
  _FrcElmntOrg.FrcElmntOrgStockStorageLoc AS FrcElmntOrgStockStorageLoc,
  _FrcElmntOrg.FrcElmntOrgInfrstrucPlant AS FrcElmntOrgInfrstrucPlant,
  _FrcElmntOrg.FrcElmOrgInfrStorLoc AS FrcElmOrgInfrStorLoc,
  _FrcElmntOrg.FrcElmOrgInfrMRPArea AS FrcElmOrgInfrMRPArea,
  _StatusAttributes._SystemStatusText[1:Language = $session.system_language].SystemStatusName AS SystemStatusName
FROM I_DFS_UniversalAssignmentBasic
LEFT OUTER JOIN I_FrcElmntOrgUsageType AS _UsageType ON DfsAssgmtUsageType = _UsageType.FrcElmntOrgUsageType  -- association [0..1]
LEFT OUTER JOIN I_DFS_AssgmtMaterialIndicator AS _MaterialIndicator ON DfsAssgmtMaterialIndicatorCode = _MaterialIndicator.DfsAssgmtMaterialIndicatorCode  -- association [0..1]
LEFT OUTER JOIN I_DFS_AssgmtMaterialCategory AS _MaterialCategory ON DfsAssgmtMaterialCategory = _MaterialCategory.DfsAssgmtMaterialCategory  -- association [0..1]
LEFT OUTER JOIN I_DFS_AssgmtMassCreationIndT AS _MassCreationIndDesc ON DfsAssgmtIsUsedForMassMatlPlng = _MassCreationIndDesc.DfsAssgmtIsUsedForMassMatlPlng AND _MassCreationIndDesc.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FrcElmntOrgBasic AS _FrcElmntOrg ON ForceElementOrgSrceID = _FrcElmntOrg.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN I_FlxMtPlObjDescription AS _FlxMtPlObjDescription ON FlxblMatlPlngObjectUUID = _FlxMtPlObjDescription.FlxblMatlPlngObjectUUID AND _FlxMtPlObjDescription.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_AuthzdActlFlxMtPlObjVarInfo AS _FlxMtPlObjVariant ON FlxblMatlPlngObjVariantUUID = _FlxMtPlObjVariant.FlxblMatlPlngObjVariantUUID  -- association [1..1]
LEFT OUTER JOIN I_DFS_StatusAttributes AS _StatusAttributes ON DfsAssgmtStatusCode = _StatusAttributes.SystemStatus  -- association [0..1]
;

Learn More