C_DFS_PosAssgmtAccogPartOthTP

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_PosAssgmtAccogPartOthTP.
-- 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: CDFSPOSASSGMTOTP

CREATE VIEW C_DFS_PosAssgmtAccogPartOthTP AS
SELECT
  DfsAssgmtSubUUID,
  DfsAssgmtUUID,
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjectUUID,
  FlxMtPlObjVariantAccogPrtUUID,
  FlxMtPlObjVarAccogPartItem,
  _FlxMtPlObjVariantTP.FlxblMatlPlngObjectID AS FlxblMatlPlngObjectID,
  FlxMtPlObjVarAccogPrtRefObjID,
  _FlxMtPlObjTP._LangDescription.FlxblMatlPlngObjDescription AS FlxblMatlPlngObjDescription,
  FlxMtPlObjVarAccogPrtRefVarID,
  _VariantTP._LangDescription.FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVariantDesc,
  FlxMtPlObjVarAccogPrtAuthzdVal,
  FlxMtPlObjVarAccogPartAssgmt,
  DfsAssgmtCorrectionValue,
  _UniversalAssignmentTP.DfsAssgmtSourceType AS DfsAssgmtSourceType,
  _UniversalAssignmentTP.DfsAssgmtType AS DfsAssgmtType,
  _UniversalAssignmentTP.DfsAssgmtStatusCode AS DfsAssgmtStatusCode
FROM I_DFS_UniversalAssignmentSubTP
LEFT OUTER JOIN C_DFS_PosToFlxMtPlObjAssgmtTP AS _AssgmtAPOtherTP ON DfsAssgmtUUID = _AssgmtAPOtherTP.DfsAssgmtUUID  -- association [1..1]
LEFT OUTER JOIN C_FlxMtPlObjTP AS _FlxMtPlObj ON FlxblMatlPlngObjectUUID = _FlxMtPlObj.FlxblMatlPlngObjectUUID  -- association [0..1]
LEFT OUTER JOIN C_FlxMtPlObjVariantTP AS _FlxMtPlObjVariantTP ON FlxblMatlPlngObjVariantUUID = _FlxMtPlObjVariantTP.FlxblMatlPlngObjVariantUUID  -- association [1..1]
LEFT OUTER JOIN I_FlxMtPlObjTP AS _FlxMtPlObjTP ON FlxMtPlObjVarAccogPrtRefObjID = _FlxMtPlObjTP.FlxblMatlPlngObjectID  -- association [0..1]
LEFT OUTER JOIN I_FlxMtPlObjVariantTP AS _VariantTP ON FlxMtPlObjVarAccogPrtRefObjID = _VariantTP.FlxblMatlPlngObjectID AND FlxMtPlObjVarAccogPrtRefVarID = _VariantTP.FlxblMatlPlngObjVariantID  -- association [0..1]
LEFT OUTER JOIN I_FlxMtPlObjAssgmtIndTxt AS _TxtOther ON FlxMtPlObjVarAccogPartAssgmt = _TxtOther.FlxMtPlObjVarAccogPartAssgmt  -- association [0..*]
;