I_AuthzdAccogPartsOfWarTimePos

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_AuthzdAccogPartsOfWarTimePos.
-- 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: IAUTHACCPWARPOS

CREATE VIEW I_AuthzdAccogPartsOfWarTimePos AS
SELECT
  DfsAssgmtUUID AS DfsAssgmtNode,
  cast(ForceElementOrgSrceID as abap.numc(8)) AS ForceElementOrgSrceID,
  DfsPositionID,
  DfsAssgmtUsageType,
  DfsObjectValdtyStartDate,
  DfsObjectValdtyEndDate,
  DfsAssgmtUUID,
  DfsObjectType,
  DfsObjectSubType,
  DfsObjectRelatedObjectType,
  DfsObjectPlngStatus,
  DfsPositionSourceUUID,
  DfsPositionSourceID,
  _FlxMtPlObjTP.FlxblMatlPlngObjectUUID AS FlxblMatlPlngObjectUUID,
  FlxblMatlPlngObjectID,
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjVariantID,
  DfsAssgmtSourceType,
  DfsAssgmtStatusCode,
  DfsAssgmtType,
  DfsAssgmtValdtyStrtDate,
  DfsAssgmtValdtyEndDate,
  cast(DfsAssgmtNmbrOfAssgdMatl as abap.int8) AS DfsAssgmtNmbrOfAssgdMatl,
  DfsAssgmtMinNmbrOfAssgdMatl,
  DfsAssgmtMaxNmbrOfAssgdMatl,
  DfsAssgmtMaterialIndicatorCode,
  DfsAssgmtMaterialIndicatorDesc,
  DfsAssgmtCorrectionValue,
  DfsAssgmtMaterialCategory,
  DfsAssgmtMaterialCategoryDesc,
  DfsAssgmtMaterialWeightingRate,
  DfsAssgmtIsUsedForMassMatlPlng,
  _FlxMtPlObjVariant.PackingInstructionSystemUUID AS PackingInstructionSystemUUID,
  _Position._UsageType AS _UsageType
FROM I_AuthzdPosWarTimeAssgdInfo
INNER JOIN I_AuthzdPosWarTimeAssgdInfo AS _Position 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_FlxMtPlObjVariant AS _FlxMtPlObjVariant ON FlxblMatlPlngObjVariantUUID = _FlxMtPlObjVariant.FlxblMatlPlngObjVariantUUID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_DFS_UniversalAssignmentSub
;