I_AuthzdActlPosOrgStructure

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_AuthzdActlPosOrgStructure.
-- 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: IAUTHZDPOSFMPO
-- Parameters: P_date : syst_datum

CREATE VIEW I_AuthzdActlPosOrgStructure AS
SELECT
  DfsAssgmtNode,
  _AuthzdAccogPartsOrgStrucPos.ForceElementOrgSrceID AS ForceElementOrgSrceID,
  _AuthzdAccogPartsOrgStrucPos.DfsPositionID AS DfsPositionID,
  DfsObjectValdtyStartDate,
  _AuthzdAccogPartsOrgStrucPos.DfsAssgmtUsageType AS DfsAssgmtUsageType,
  DfsObjectValdtyEndDate,
  _AuthzdAccogPartsOrgStrucPos.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  _AuthzdAccogPartsOrgStrucPos.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  _AuthzdAccogPartsOrgStrucPos.DfsAssgmtStatusCode AS DfsAssgmtStatusCode,
  DfsAssgmtType,
  _AuthzdAccogPartsOrgStrucPos.DfsAssgmtUUID AS DfsAssgmtUUID,
  DfsPositionRelatedObjectType,
  DfsObjectPlngStatus,
  DfsPositionSourceUUID,
  FlxblMatlPlngObjectUUID,
  _FlxMtPlObjDescription.FlxblMatlPlngObjDescription AS FlxblMatlPlngObjDescription,
  _FlxMtPlObjVarDescription.FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVariantDesc,
  DfsPositionSourceID,
  _AuthzdAccogPartsOrgStrucPos.FlxblMatlPlngObjectID AS FlxblMatlPlngObjectID,
  FlxblMatlPlngObjVariantUUID,
  _AuthzdAccogPartsOrgStrucPos.FlxblMatlPlngObjVariantID AS FlxblMatlPlngObjVariantID,
  DfsAssgmtSourceType,
  cast(DfsAssgmtNmbrOfAssgdMatl + DfsAssgmtCorrectionValue as abap.int4) AS AdjustedAuthzdNmbrOfAssgdMatl,
  DfsAssgmtNmbrOfAssgdMatl,
  _ActlFlxMtPlObjOrgPosAggrgd.ActualFlxMtPlObjVarAvailVal AS ActualFlxMtPlObjVarAvailVal,
  _TotActlFlxMtPlObjIssToOrgPos.BaseUnit AS BaseUnit,
  _TotActlFlxMtPlObjIssToOrgPos.GoodsIssueQtyInBaseUnit AS GoodsIssueQtyInBaseUnit,
  _TotalReqdAuthzdMatlOrgPos.RequestedQuantity AS RequestedQuantity,
  _TotalOrddAuthzdMatlOrgPos.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _TotalOrddAuthzdMatlOrgPos.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_AuthzdAccogPartsOrgStrucPos AS _AuthzdAccogPartsOrgStrucPos
LEFT OUTER JOIN I_ActlFlxMtPlObjOrgPosAggrgd AS _ActlFlxMtPlObjOrgPosAggrgd ON _AuthzdAccogPartsOrgStrucPos.DfsAssgmtNode = _ActlFlxMtPlObjOrgPosAggrgd.DfsAssgmtUUID AND _AuthzdAccogPartsOrgStrucPos.ForceElementOrgSrceID = _ActlFlxMtPlObjOrgPosAggrgd.ForceElementOrgSrceID AND _AuthzdAccogPartsOrgStrucPos.DfsPositionID = _ActlFlxMtPlObjOrgPosAggrgd.DfsPositionID AND _AuthzdAccogPartsOrgStrucPos.FlxblMatlPlngObjectID = _ActlFlxMtPlObjOrgPosAggrgd.FlxblMatlPlngObjectID AND _AuthzdAccogPartsOrgStrucPos.DfsObjectValdtyStartDate = _ActlFlxMtPlObjOrgPosAggrgd.DfsObjectValdtyStartDate AND _AuthzdAccogPartsOrgStrucPos.DfsObjectValdtyEndDate = _ActlFlxMtPlObjOrgPosAggrgd.DfsObjectValdtyEndDate  -- association [0..1]
LEFT OUTER JOIN I_TotalOrddAuthzdMatlOrgPos AS _TotalOrddAuthzdMatlOrgPos ON _AuthzdAccogPartsOrgStrucPos.DfsAssgmtNode = _TotalOrddAuthzdMatlOrgPos.DfsAssgmtUUID AND _AuthzdAccogPartsOrgStrucPos.ForceElementOrgSrceID = _TotalOrddAuthzdMatlOrgPos.ForceElementOrgSrceID AND _AuthzdAccogPartsOrgStrucPos.DfsPositionID = _TotalOrddAuthzdMatlOrgPos.DfsPositionID AND _AuthzdAccogPartsOrgStrucPos.FlxblMatlPlngObjectID = _TotalOrddAuthzdMatlOrgPos.FlxblMatlPlngObjectID AND _AuthzdAccogPartsOrgStrucPos.DfsObjectValdtyStartDate = _TotalOrddAuthzdMatlOrgPos.DfsObjectValdtyStartDate AND _AuthzdAccogPartsOrgStrucPos.DfsObjectValdtyEndDate = _TotalOrddAuthzdMatlOrgPos.DfsObjectValdtyEndDate  -- association [0..1]
LEFT OUTER JOIN I_TotalReqdAuthzdMatlOrgPos AS _TotalReqdAuthzdMatlOrgPos ON _AuthzdAccogPartsOrgStrucPos.DfsAssgmtNode = _TotalReqdAuthzdMatlOrgPos.DfsAssgmtUUID AND _AuthzdAccogPartsOrgStrucPos.ForceElementOrgSrceID = _TotalReqdAuthzdMatlOrgPos.ForceElementOrgSrceID AND _AuthzdAccogPartsOrgStrucPos.DfsPositionID = _TotalReqdAuthzdMatlOrgPos.DfsPositionID AND _AuthzdAccogPartsOrgStrucPos.FlxblMatlPlngObjectID = _TotalReqdAuthzdMatlOrgPos.FlxblMatlPlngObjectID AND _AuthzdAccogPartsOrgStrucPos.DfsObjectValdtyStartDate = _TotalReqdAuthzdMatlOrgPos.DfsObjectValdtyStartDate AND _AuthzdAccogPartsOrgStrucPos.DfsObjectValdtyEndDate = _TotalReqdAuthzdMatlOrgPos.DfsObjectValdtyEndDate  -- association [0..1]
LEFT OUTER JOIN I_FlxMtPlObjDescription AS _FlxMtPlObjDescription ON _AuthzdAccogPartsOrgStrucPos.FlxblMatlPlngObjectUUID = _FlxMtPlObjDescription.FlxblMatlPlngObjectUUID AND _FlxMtPlObjDescription.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FlxMtPlObjVarDescription AS _FlxMtPlObjVarDescription ON _AuthzdAccogPartsOrgStrucPos.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]
;