I_AuthzdAccogPrtOpPerson

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_AuthzdAccogPrtOpPerson.
-- 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.
-- Parameters: P_DfsPositionValdtyStartDate : syst_datum

CREATE VIEW I_AuthzdAccogPrtOpPerson AS
SELECT
  _Position.DfsAssgmtUUID AS DfsAssgmtNode,
  cast(_Position.DfsPositionID as abap.char(45)) AS DfsPositionRelatedObjectID,
  _Position.EmployeePersonnelNumber AS EmployeePersonnelNumber,
  _Position.ForceElementOrgSrceID AS ForceElementOrgSrceID,
  DfsObjectPlngStatus,
  _Position.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  _Position.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  _Position.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  _Position.DfsPositionValdtyEndDate AS DfsPositionValdtyEndDate,
  _Position.DfsAssgmtUsageType AS DfsAssgmtUsageType,
  _Position.DfsObjectType AS DfsObjectType,
  _Position.DfsObjectSubType AS DfsObjectSubType,
  _Position.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  _Position.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  _Position.DfsAssgmtStatusCode AS DfsAssgmtStatusCode,
  _Position.DfsAssgmtType AS DfsAssgmtType,
  _Position.DfsAssgmtUUID AS DfsAssgmtUUID,
  _Position.DfsObjectRelatedObjectType AS DfsPositionRelatedObjectType,
  _Position.DfsPositionSourceUUID AS DfsPositionSourceUUID,
  _FlxMtPlObjTP.FlxblMatlPlngObjectUUID AS FlxblMatlPlngObjectUUID,
  _Position.DfsPositionSourceID AS DfsPositionSourceID,
  _Position.FlxblMatlPlngObjectID AS FlxblMatlPlngObjectID,
  _Position.FlxblMatlPlngObjVariantUUID AS FlxblMatlPlngObjVariantUUID,
  _Position.FlxblMatlPlngObjVariantID AS FlxblMatlPlngObjVariantID,
  _Position.DfsAssgmtSourceType AS DfsAssgmtSourceType,
  _Position.DfsAssgmtIsUsedForMassMatlPlng AS DfsAssgmtIsUsedForMassMatlPlng,
  cast(_Position.DfsAssgmtNmbrOfAssgdMatl as abap.int8) AS DfsAssgmtNmbrOfAssgdMatl,
  _Position.DfsAssgmtMinNmbrOfAssgdMatl AS DfsAssgmtMinNmbrOfAssgdMatl,
  _Position.DfsAssgmtMaxNmbrOfAssgdMatl AS DfsAssgmtMaxNmbrOfAssgdMatl,
  _Position.DfsAssgmtMaterialIndicatorCode AS DfsAssgmtMaterialIndicatorCode,
  _Position.DfsAssgmtMaterialIndicatorDesc AS DfsAssgmtMaterialIndicatorDesc,
  _Position.DfsAssgmtCorrectionValue AS DfsAssgmtCorrectionValue,
  _Position.DfsAssgmtMaterialCategory AS DfsAssgmtMaterialCategory,
  _Position.DfsAssgmtMaterialCategoryDesc AS DfsAssgmtMaterialCategoryDesc,
  _Position.DfsAssgmtMaterialWeightingRate AS DfsAssgmtMaterialWeightingRate,
  _FlxMtPlObjVariant.PackingInstructionSystemUUID AS PackingInstructionSystemUUID,
  _Position.EmployeeName AS EmployeeName,
  _Position._AssignmentType AS _AssignmentType,
  _Position._MaterialCategory AS _MaterialCategory,
  _Position._MaterialIndicator AS _MaterialIndicator,
  _Position._PositionObject AS _PositionObject,
  _Position._UsageType AS _UsageType,
  _Position._ValdtyEndDate AS _ValdtyEndDate,
  _Position._ValdtyStrtDate AS _ValdtyStrtDate,
  _Position._StatusAttributes AS DfsAssgmtSubUUIDasDfsAssgmtNode,
  _Position._StatusAttributes AS _StatusAttributes
FROM I_AuthzdPosOpAssgdInfo
INNER JOIN I_AuthzdPosOpAssgdInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FlxMtPlObj AS _FlxMtPlObjTP ON FlxblMatlPlngObjectID = _FlxMtPlObjTP.FlxblMatlPlngObjectID  -- association [1..1]
LEFT OUTER JOIN I_AuthzdActlFlxMtPlObjVarInfo AS _FlxMtPlObjVariant ON FlxblMatlPlngObjVariantUUID = _FlxMtPlObjVariant.FlxblMatlPlngObjVariantUUID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_DFS_UniversalAssignmentSub
;