I_AuthzdPosPeaceTimeStructure

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_AuthzdPosPeaceTimeStructure.
-- 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.

CREATE VIEW I_AuthzdPosPeaceTimeStructure AS
SELECT
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtNode AS DfsAssgmtNode,
  _AuthzdAccogPartsPeaceTimePos.ForceElementOrgSrceID AS ForceElementOrgSrceID,
  _AuthzdAccogPartsPeaceTimePos.DfsPositionID AS DfsPositionID,
  _AuthzdAccogPartsPeaceTimePos.DfsObjectValdtyStartDate AS DfsObjectValdtyStartDate,
  _AuthzdAccogPartsPeaceTimePos.DfsObjectValdtyEndDate AS DfsObjectValdtyEndDate,
  _AuthzdAccogPartsPeaceTimePos.DfsObjectPlngStatus AS DfsObjectPlngStatus,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtUsageType AS DfsAssgmtUsageType,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtUUID AS DfsAssgmtUUID,
  _AuthzdAccogPartsPeaceTimePos.DfsObjectType AS DfsObjectType,
  _AuthzdAccogPartsPeaceTimePos.DfsObjectSubType AS DfsObjectSubType,
  _AuthzdAccogPartsPeaceTimePos.DfsObjectRelatedObjectType AS DfsObjectRelatedObjectType,
  _AuthzdAccogPartsPeaceTimePos.DfsPositionSourceUUID AS DfsPositionSourceUUID,
  _AuthzdAccogPartsPeaceTimePos.DfsPositionSourceID AS DfsPositionSourceID,
  _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjectID AS FlxblMatlPlngObjectID,
  _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjectUUID AS FlxblMatlPlngObjectUUID,
  _FlxMtPlObjDescription.FlxblMatlPlngObjDescription AS FlxblMatlPlngObjDescription,
  _FlxMtPlObjVarDescription.FlxblMatlPlngObjVariantDesc AS FlxblMatlPlngObjVariantDesc,
  _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjVariantUUID AS FlxblMatlPlngObjVariantUUID,
  _AuthzdAccogPartsPeaceTimePos.FlxblMatlPlngObjVariantID AS FlxblMatlPlngObjVariantID,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtSourceType AS DfsAssgmtSourceType,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtStatusCode AS DfsAssgmtStatusCode,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtType AS DfsAssgmtType,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtValdtyStrtDate AS DfsAssgmtValdtyStrtDate,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtValdtyEndDate AS DfsAssgmtValdtyEndDate,
  cast(_AuthzdAccogPartsPeaceTimePos.DfsAssgmtNmbrOfAssgdMatl + _AuthzdAccogPartsPeaceTimePos.DfsAssgmtCorrectionValue as abap.int4) AS AdjustedAuthzdNmbrOfAssgdMatl,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtNmbrOfAssgdMatl AS DfsAssgmtNmbrOfAssgdMatl,
  cast (0 as abap.int8) AS ActualFlxMtPlObjVarAvailVal,
  cast (' ' as abap.unit( 3 ) ) AS BaseUnit,
  cast (0 as abap.quan( 13, 3)) AS OrderQuantity,
  cast (0 as abap.quan( 13, 3)) AS RequestedQuantity,
  cast (0 as abap.quan( 13, 3)) AS QualityInspectionStockQuantity,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtMaterialIndicatorCode AS DfsAssgmtMaterialIndicatorCode,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtMaterialIndicatorDesc AS DfsAssgmtMaterialIndicatorDesc,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtCorrectionValue AS DfsAssgmtCorrectionValue,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtMaterialCategory AS DfsAssgmtMaterialCategory,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtMaterialCategoryDesc AS DfsAssgmtMaterialCategoryDesc,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtIsUsedForMassMatlPlng AS DfsAssgmtIsUsedForMassMatlPlng,
  _AuthzdAccogPartsPeaceTimePos.DfsAssgmtMaterialWeightingRate AS DfsAssgmtMaterialWeightingRate,
  cast('' as stext) AS FrcElmntOrgName,
  cast('' as istat_d) AS FrcElmntOrgPlngStatus,
  cast('' as pstext) AS FrcElmntOrgPlngStatusName,
  _AuthzdAccogPartsPeaceTimePos._UsageType.FrcElmntOrgUsageTypeDesc AS FrcElmntOrgUsageTypeDesc,
  _FrcElmntOrg.FrcElmntOrgStockPlant AS FrcElmntOrgStockPlant,
  _FrcElmntOrg.FrcElmntOrgStockStorageLoc AS FrcElmntOrgStockStorageLoc,
  _FrcElmntOrg.FrcElmntOrgInfrstrucPlant AS FrcElmntOrgInfrstrucPlant,
  _FrcElmntOrg.FrcElmOrgInfrStorLoc AS FrcElmOrgInfrStorLoc,
  _FrcElmntOrg.FrcElmOrgInfrMRPArea AS FrcElmOrgInfrMRPArea,
  _AuthzdAccogPartsPeaceTimePos._StatusAttributes._SystemStatusText[1:Language = $session.system_language].SystemStatusName AS SystemStatusName,
  _AuthzdAccogPartsPeaceTimePos._UsageType AS _UsageType
FROM I_AuthzdAccogPartsPeaceTimePos AS _AuthzdAccogPartsPeaceTimePos
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]
;