I_AuthzdActlPositionPeaceTime

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_AuthzdActlPositionPeaceTime.
-- 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: IAUTHPOSPEACEFE
-- Parameters: P_date : syst_datum

CREATE VIEW I_AuthzdActlPositionPeaceTime AS
SELECT
  DfsAssgmtNode,
  _AuthzdAccogPartsPeaceTimePos.ForceElementOrgSrceID AS ForceElementOrgSrceID,
  _AuthzdAccogPartsPeaceTimePos.DfsPositionID AS DfsPositionID,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtUsageType AS DfsAssgmtUsageType,
  DfsObjectValdtyStartDate,
  DfsObjectValdtyEndDate,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtUUID AS DfsAssgmtUUID,
  DfsObjectType,
  DfsObjectSubType,
  DfsObjectRelatedObjectType,
  DfsObjectPlngStatus,
  DfsPositionSourceUUID,
  DfsPositionSourceID,
  _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjectID AS FlxblMatlPlngObjectID,
  FlxblMatlPlngObjectUUID,
  _FlxMtPlObjDescription.FlxblMatlPlngObjDescription AS FlxblMatlPlngObjDescription,
  _FlxMtPlObjVarDescription.FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVariantDesc,
  FlxblMatlPlngObjVariantUUID,
  _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjVariantID AS FlxblMatlPlngObjVariantID,
  DfsAssgmtSourceType,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtStatusCode AS DfsAssgmtStatusCode,
  DfsAssgmtType,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  cast(DfsAssgmtNmbrOfAssgdMatl + DfsAssgmtCorrectionValue as abap.int4) AS AdjustedAuthzdNmbrOfAssgdMatl,
  DfsAssgmtNmbrOfAssgdMatl,
  _ActlFlxMtPlObjPeacePosAggrgd.ActualFlxMtPlObjVarAvailVal AS ActualFlxMtPlObjVarAvailVal,
  _TotActlFlxMtPlObjIssToPeace.BaseUnit AS BaseUnit,
  _TotActlFlxMtPlObjIssToPeace.GoodsIssueQtyInBaseUnit AS GoodsIssueQtyInBaseUnit,
  _TotalReqdAuthzdMatlPeacePos.RequestedQuantity AS RequestedQuantity,
  _TotalOrddAuthzdMatlPeacePos.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _TotalOrddAuthzdMatlPeacePos.OrderQuantity AS OrderQuantity,
  DfsAssgmtMaterialIndicatorCode,
  DfsAssgmtMaterialIndicatorDesc,
  DfsAssgmtCorrectionValue,
  DfsAssgmtMaterialCategory,
  DfsAssgmtMaterialCategoryDesc,
  DfsAssgmtIsUsedForMassMatlPlng,
  DfsAssgmtMaterialWeightingRate,
  cast('' as stext) AS FrcElmntOrgName,
  cast('' as istat_d) AS FrcElmntOrgPlngStatus,
  cast('' as pstext) AS FrcElmntOrgPlngStatusName,
  _UsageType.FrcElmntOrgUsageTypeDesc AS FrcElmntOrgUsageTypeDesc,
  _FrcElmntOrg.FrcElmntOrgStockPlant AS FrcElmntOrgStockPlant,
  _FrcElmntOrg.FrcElmntOrgStockStorageLoc AS FrcElmntOrgStockStorageLoc,
  _StatusAttributes._SystemStatusText[1:Language = $session.system_language].SystemStatusName AS SystemStatusName
FROM I_AuthzdAccogPartsPeaceTimePos AS _AuthzdAccogPartsPeaceTimePos
LEFT OUTER JOIN I_ActlFlxMtPlObjPeacePosAggrgd AS _ActlFlxMtPlObjPeacePosAggrgd ON _AuthzdAccogPartsPeaceTimePos.DfsAssgmtNode = _ActlFlxMtPlObjPeacePosAggrgd.DfsAssgmtUUID AND _AuthzdAccogPartsPeaceTimePos.ForceElementOrgSrceID = _ActlFlxMtPlObjPeacePosAggrgd.ForceElementOrgSrceID AND _AuthzdAccogPartsPeaceTimePos.DfsPositionID = _ActlFlxMtPlObjPeacePosAggrgd.DfsPositionID AND _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjectID = _ActlFlxMtPlObjPeacePosAggrgd.FlxblMatlPlngObjectID AND _AuthzdAccogPartsPeaceTimePos.DfsObjectValdtyStartDate = _ActlFlxMtPlObjPeacePosAggrgd.DfsObjectValdtyStartDate AND _AuthzdAccogPartsPeaceTimePos.DfsObjectValdtyEndDate = _ActlFlxMtPlObjPeacePosAggrgd.DfsObjectValdtyEndDate  -- association [0..1]
LEFT OUTER JOIN I_TotalOrddAuthzdMatlPeacePos AS _TotalOrddAuthzdMatlPeacePos ON _AuthzdAccogPartsPeaceTimePos.DfsAssgmtNode = _TotalOrddAuthzdMatlPeacePos.DfsAssgmtUUID AND _AuthzdAccogPartsPeaceTimePos.ForceElementOrgSrceID = _TotalOrddAuthzdMatlPeacePos.ForceElementOrgSrceID AND _AuthzdAccogPartsPeaceTimePos.DfsPositionID = _TotalOrddAuthzdMatlPeacePos.DfsPositionID AND _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjectID = _TotalOrddAuthzdMatlPeacePos.FlxblMatlPlngObjectID AND _AuthzdAccogPartsPeaceTimePos.DfsObjectValdtyStartDate = _TotalOrddAuthzdMatlPeacePos.DfsObjectValdtyStartDate AND _AuthzdAccogPartsPeaceTimePos.DfsObjectValdtyEndDate = _TotalOrddAuthzdMatlPeacePos.DfsObjectValdtyEndDate  -- association [0..1]
LEFT OUTER JOIN I_TotalReqdAuthzdMatlPeacePos AS _TotalReqdAuthzdMatlPeacePos ON _AuthzdAccogPartsPeaceTimePos.DfsAssgmtNode = _TotalReqdAuthzdMatlPeacePos.DfsAssgmtUUID AND _AuthzdAccogPartsPeaceTimePos.ForceElementOrgSrceID = _TotalReqdAuthzdMatlPeacePos.ForceElementOrgSrceID AND _AuthzdAccogPartsPeaceTimePos.DfsPositionID = _TotalReqdAuthzdMatlPeacePos.DfsPositionID AND _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjectID = _TotalReqdAuthzdMatlPeacePos.FlxblMatlPlngObjectID AND _AuthzdAccogPartsPeaceTimePos.DfsObjectValdtyStartDate = _TotalReqdAuthzdMatlPeacePos.DfsObjectValdtyStartDate AND _AuthzdAccogPartsPeaceTimePos.DfsObjectValdtyEndDate = _TotalReqdAuthzdMatlPeacePos.DfsObjectValdtyEndDate  -- association [0..1]
LEFT OUTER JOIN I_FlxMtPlObjDescription AS _FlxMtPlObjDescription ON _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjectUUID = _FlxMtPlObjDescription.FlxblMatlPlngObjectUUID AND _FlxMtPlObjDescription.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FlxMtPlObjVarDescription AS _FlxMtPlObjVarDescription ON _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjVariantUUID = _FlxMtPlObjVarDescription.FlxblMatlPlngObjVariantUUID AND _FlxMtPlObjVarDescription.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FrcElmntOrg AS _FrcElmntOrg ON ForceElementOrgSrceID = _FrcElmntOrg.ForceElementOrgID  -- association [1..1]
;