I_DFS_FlxMtPlObjAssignmentData

DDL: I_DFS_FLXMTPLOBJASSIGNMENTDATA SQL: IFMPOASSGMT Type: view COMPOSITE

Intf for drft assgmt fmpo data

I_DFS_FlxMtPlObjAssignmentData is a Composite CDS View that provides data about "Intf for drft assgmt fmpo data" in SAP S/4HANA. It reads from 2 data sources (I_DFS_UniversalAssgmtSubDrft, I_DFS_UniversalAssignmentDraft) and exposes 13 fields with key field DfsAssgmtUUID. It has 2 associations to related views.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_DFS_UniversalAssgmtSubDrft _UniversalAssgmtSubDrft union_all
I_DFS_UniversalAssignmentDraft _UniversalAssignment from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FlxMtPlObj _FlxMtPlObj $projection.FlxblMatlPlngObjectID = _FlxMtPlObj.FlxblMatlPlngObjectID
[1..*] I_FlxMtPlObjVariant _FlxMtPlObjVariant $projection.FlxblMatlPlngObjVariantUUID = _FlxMtPlObjVariant.FlxblMatlPlngObjVariantUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFMPOASSGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Intf for drft assgmt fmpo data view
ObjectModel.representativeKey DfsAssgmtUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DfsAssgmtUUID I_DFS_UniversalAssignmentDraft DraftUUID
ForceElementOrgSrceID ForceElementOrgSrceID
DfsPositionSourceID DfsPositionSourceID
FlxblMatlPlngObjectUUID _FlxMtPlObj FlxblMatlPlngObjectUUID
FlxblMatlPlngObjectID I_DFS_UniversalAssignmentDraft FlxblMatlPlngObjectID
FlxblMatlPlngObjVariantUUID FlxblMatlPlngObjVariantUUID
DfsAssgmtUUIDasDfsAssgmtUUID
ForceElementOrgSrceID I_DFS_UniversalAssignmentDraft ForceElementOrgSrceID
DfsPositionSourceID I_DFS_UniversalAssignmentDraft DfsPositionSourceID
FlxblMatlPlngObjectUUID _FlxMtPlObj FlxblMatlPlngObjectUUID
FlxblMatlPlngObjectID I_DFS_UniversalAssgmtSubDrft FlxMtPlObjVarAccogPrtRefObjID
FlxblMatlPlngObjVariantUUID _FlxMtPlObjVariant FlxblMatlPlngObjVariantUUID
FlxblMatlPlngObjVariantID I_DFS_UniversalAssgmtSubDrft FlxMtPlObjVarAccogPrtRefVarID 
@AbapCatalog.sqlViewName: 'IFMPOASSGMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Intf for drft assgmt fmpo data'
@ObjectModel.representativeKey: 'DfsAssgmtUUID'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_DFS_FlxMtPlObjAssignmentData
  as select from I_DFS_UniversalAssignmentDraft as _UniversalAssignment
  association [1..1] to I_FlxMtPlObj        as _FlxMtPlObj        on $projection.FlxblMatlPlngObjectID = _FlxMtPlObj.FlxblMatlPlngObjectID
  association [1..*] to I_FlxMtPlObjVariant as _FlxMtPlObjVariant on $projection.FlxblMatlPlngObjVariantUUID = _FlxMtPlObjVariant.FlxblMatlPlngObjVariantUUID
{
  key _UniversalAssignment.DraftUUID                 as DfsAssgmtUUID,
      ForceElementOrgSrceID,
      DfsPositionSourceID,
      _FlxMtPlObj.FlxblMatlPlngObjectUUID,
      _UniversalAssignment.FlxblMatlPlngObjectID     as FlxblMatlPlngObjectID,
      FlxblMatlPlngObjVariantUUID,
      _UniversalAssignment.FlxblMatlPlngObjVariantID as FlxblMatlPlngObjVariantID
}
union all select from    I_DFS_UniversalAssgmtSubDrft   as _UniversalAssgmtSubDrft
  left outer to one join I_DFS_UniversalAssignmentDraft as _UniversalAssignment on _UniversalAssgmtSubDrft.DfsAssgmtUUID = _UniversalAssignment.DraftUUID
  left outer to one join I_FlxMtPlObj                   as _FlxMtPlObj          on _UniversalAssgmtSubDrft.FlxMtPlObjVarAccogPrtRefObjID = _FlxMtPlObj.FlxblMatlPlngObjectID
association [1..*] to I_FlxMtPlObjVariant as _FlxMtPlObjVariant on  $projection.FlxblMatlPlngObjectUUID                   = _FlxMtPlObjVariant.FlxblMatlPlngObjectUUID
                                                                and _UniversalAssgmtSubDrft.FlxMtPlObjVarAccogPrtRefVarID = _FlxMtPlObjVariant.FlxblMatlPlngObjVariantID

{
  key _UniversalAssgmtSubDrft.DfsAssgmtUUID                 as DfsAssgmtUUID,
      _UniversalAssignment.ForceElementOrgSrceID            as ForceElementOrgSrceID,
      _UniversalAssignment.DfsPositionSourceID              as DfsPositionSourceID,
      _FlxMtPlObj.FlxblMatlPlngObjectUUID                   as FlxblMatlPlngObjectUUID,
      _UniversalAssgmtSubDrft.FlxMtPlObjVarAccogPrtRefObjID as FlxblMatlPlngObjectID,
      _FlxMtPlObjVariant.FlxblMatlPlngObjVariantUUID        as FlxblMatlPlngObjVariantUUID,
      _UniversalAssgmtSubDrft.FlxMtPlObjVarAccogPrtRefVarID as FlxblMatlPlngObjVariantID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DFS_UNIVERSALASSGMTSUBDRFT",
"I_DFS_UNIVERSALASSIGNMENTDRAFT",
"I_FLXMTPLOBJ",
"I_FLXMTPLOBJVARIANT"
],
"ASSOCIATED":
[
"I_FLXMTPLOBJ",
"I_FLXMTPLOBJVARIANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More