R_ATPBscProcdRqmtBasicMethRslt

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 R_ATPBscProcdRqmtBasicMethRslt.
-- 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: RATPBSCPRBMRSLT

CREATE VIEW R_ATPBscProcdRqmtBasicMethRslt AS
SELECT
  ATPProcdRqmtBscMethReqRsltUUID,
  ATPProcdRqmtBasicMethodReqUUID,
  ATPRequirementUUID,
  ATPCheckIterationUUID,
  ATPCheckUUID,
  ATPCheckVersion,
  AvailableQuantityInBaseUnit,
  BaseUnit,
  BaseToCommonBaseQtyNumerator,
  BaseToCommonBaseQtyDenominator,
  ProductAvailabilityUTCDateTime,
  ProductAvailabilityTimeZone,
  TranspPlanningUTCDateTime,
  TransportationPlanningTimeZone,
  LoadingUTCDateTime,
  LoadingTimeZone,
  GoodsIssueUTCDateTime,
  GoodsIssueTimeZone,
  DeliveryUTCDateTime,
  DeliveryTimeZone,
  UnloadingUTCDateTime,
  UnloadingTimeZone,
  DatesRsltgFrmSchedgRunReqUUID
FROM atp_pr_bm_rslt
LEFT OUTER JOIN R_ATPBscProcdRqmtBasicMethReq AS _Request ON ATPProcdRqmtBasicMethodReqUUID = _Request.ATPProcdRqmtBasicMethodReqUUID  -- association [1..1]
LEFT OUTER JOIN R_ATPProcdBasicRequirement AS _ProcessedRequirement ON ATPRequirementUUID = _ProcessedRequirement.ATPRequirementUUID  -- association [1..1]
LEFT OUTER JOIN I_ATPCheck AS _Check ON ATPCheckUUID = _Check.ATPCheckUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SchedulingRunRequest AS _DatesRsltgFrmSchedulingRunReq ON DatesRsltgFrmSchedgRunReqUUID = _DatesRsltgFrmSchedulingRunReq.SchedulingRunRequestUUID  -- association [0..1]
;