I_AuthzdAccogPrtWarTimePers

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_AuthzdAccogPrtWarTimePers.
-- 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_AuthzdAccogPrtWarTimePers AS
SELECT
  _Position.DfsAssgmtUUID AS DfsAssgmtNode,
  cast(_Position.DfsPositionID as abap.char(45)) AS DfsPositionRelatedObjectID,
  cast(_PosPersStrucRelshp.DfsPositionRelatedObjectID as abap.numc(8)) AS EmployeePersonnelNumber,
  cast(_Position.ForceElementOrgSrceID as abap.numc(8)) AS ForceElementOrgSrceID,
  DfsObjectPlngStatus,
  _Position.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  _Position.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  _PosPersStrucRelshp.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  _PosPersStrucRelshp.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,
  _PosPersStrucRelshp.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_AuthzdPosWarTimeAssgdInfo AS _Position
INNER JOIN I_AuthzdPosWarTimeAssgdInfo AS _Position ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AuthzdActlPosPersStrucRelshp AS _PosPersStrucRelshp ON _Position.DfsPositionID = _PosPersStrucRelshp.DfsObjectID  -- association [0..*]
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
;