I_ATPProcdRqmtBasicMethReqRslt

DDL: I_ATPPROCDRQMTBASICMETHREQRSLT SQL: IATPPRBMRSLT Type: view BASIC Package: ATP_RESULT
27 Fields 1 Data Sources 1 Associations

ATP Processed Requirement Basic Method Request Result

I_ATPProcdRqmtBasicMethReqRslt is a Basic CDS View that provides data about "ATP Processed Requirement Basic Method Request Result" in SAP S/4HANA. It reads from 1 data source (R_ATPBscProcdRqmtBasicMethRslt) and exposes 27 fields with key field ATPProcdRqmtBscMethReqRsltUUID. It has 1 association to related views. Part of development package ATP_RESULT.

Data Sources (1)

SourceAliasJoin Type
R_ATPBscProcdRqmtBasicMethRslt R_ATPBscProcdRqmtBasicMethRslt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ATPProcessedRequirement _ProcessedRequirement $projection.ATPRequirementUUID = _ProcessedRequirement.ATPRequirementUUID

Annotations (12)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.sqlViewName IATPPRBMRSLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ATPProcdRqmtBscMethReqRsltUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label ATP Processed Requirement Basic Method Request Result view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ATPProcdRqmtBscMethReqRsltUUID ATPProcdRqmtBscMethReqRsltUUID Basic Method Result
ATPProcdRqmtBasicMethodReqUUID ATPProcdRqmtBasicMethodReqUUID Basic Method Request
ATPRequirementUUID ATPRequirementUUID Requirement UUID
ATPCheckUUID ATPCheckUUID Check ID
ATPCheckVersion ATPCheckVersion ATP Check Version
AvailableQuantityInBaseUnit AvailableQuantityInBaseUnit Confirmed Qty
BaseUnit BaseUnit Unit of Measure
BaseToCommonBaseQtyNumerator BaseToCommonBaseQtyNumerator Numerator
BaseToCommonBaseQtyDenominator BaseToCommonBaseQtyDenominator Denominator
ProductAvailabilityUTCDateTime ProductAvailabilityUTCDateTime Confirmed MAD
ProductAvailabilityTimeZone ProductAvailabilityTimeZone Time Zone
TranspPlanningUTCDateTime TranspPlanningUTCDateTime Conf. Transport Plng
TransportationPlanningTimeZone TransportationPlanningTimeZone Time Zone
LoadingUTCDateTime LoadingUTCDateTime Cnf. Loading Date
LoadingTimeZone LoadingTimeZone Time Zone
GoodsIssueUTCDateTime GoodsIssueUTCDateTime Cnf. Goods Issue
GoodsIssueTimeZone GoodsIssueTimeZone Time Zone
DeliveryUTCDateTime DeliveryUTCDateTime Confirmed Del. Date
DeliveryTimeZone DeliveryTimeZone Time Zone
UnloadingUTCDateTime UnloadingUTCDateTime Confirmed Unloading
UnloadingTimeZone UnloadingTimeZone Time Zone
DatesRsltgFrmSchedgRunReqUUID DatesRsltgFrmSchedgRunReqUUID Request UUID
_Request _Request
_ProcessedRequirement _ProcessedRequirement
_Check _Check
_BaseUnit _BaseUnit
_DatesRsltgFrmSchedulingRunReq _DatesRsltgFrmSchedulingRunReq

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_ATPProcdRqmtBasicMethReqRslt.
-- 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: IATPPRBMRSLT

CREATE VIEW I_ATPProcdRqmtBasicMethReqRslt AS
SELECT
  ATPProcdRqmtBscMethReqRsltUUID,
  ATPProcdRqmtBasicMethodReqUUID,
  ATPRequirementUUID,
  ATPCheckUUID,
  ATPCheckVersion,
  AvailableQuantityInBaseUnit,
  BaseUnit,
  BaseToCommonBaseQtyNumerator,
  BaseToCommonBaseQtyDenominator,
  ProductAvailabilityUTCDateTime,
  ProductAvailabilityTimeZone,
  TranspPlanningUTCDateTime,
  TransportationPlanningTimeZone,
  LoadingUTCDateTime,
  LoadingTimeZone,
  GoodsIssueUTCDateTime,
  GoodsIssueTimeZone,
  DeliveryUTCDateTime,
  DeliveryTimeZone,
  UnloadingUTCDateTime,
  UnloadingTimeZone,
  DatesRsltgFrmSchedgRunReqUUID
FROM R_ATPBscProcdRqmtBasicMethRslt
LEFT OUTER JOIN I_ATPProcessedRequirement AS _ProcessedRequirement ON ATPRequirementUUID = _ProcessedRequirement.ATPRequirementUUID  -- association [1..1]
;

Learn More