I_ATPProcessedRequirement

DDL: I_ATPPROCESSEDREQUIREMENT SQL: IATPPROCDRQMT Type: view BASIC Package: ATP_RESULT
20 Fields 1 Data Sources 7 Associations

ATP Processed Requirement

I_ATPProcessedRequirement is a Basic CDS View that provides data about "ATP Processed Requirement" in SAP S/4HANA. It reads from 1 data source (R_ATPProcdBasicRequirement) and exposes 20 fields with key field ATPRequirementUUID. It has 7 associations to related views. Part of development package ATP_RESULT.

Data Sources (1)

SourceAliasJoin Type
R_ATPProcdBasicRequirement R_ATPProcdBasicRequirement from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_ATPConfirmationComposition _RecommendedConfComposition $projection.RecmddATPConfCompositionUUID = _RecommendedConfComposition.ATPConfirmationCompositionUUID
[0..*] I_ATPConfirmationAfterCheck _RecommendedConfirmation $projection.RecmddATPConfCompositionUUID = _RecommendedConfirmation.ATPConfirmationCompositionUUID
[0..*] I_ATPBasicMethodRqmtCheckReq _BasicMethodRqmtCheckRequest $projection.ATPRequirementUUID = _BasicMethodRqmtCheckRequest.ATPBasicMethChkSqncExecReqUUID
[0..*] I_ATPProcdRqmtBasicMethRequest _BasicMethodRequest
[0..*] I_ATPOverruleConfCheckReq _OverruleConfCheckRequest
[0..*] I_ATPConfirmationComposition _ConfirmationComposition
[0..*] I_ATPConfAdjustmentStep _ConfirmationAdjustmentStep

Annotations (12)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ATPRequirementUUID ATPRequirementUUID Requirement UUID
ATPCheckUUID ATPCheckUUID Check ID
ATPCheckVersion ATPCheckVersion ATP Check Version
ATPRqmtIsProcessedExternally ATPRqmtIsProcessedExternally Processed Externally
ATPConfirmationsAreEditable ATPConfirmationsAreEditable Is Editable
ProcessingSequencePosition ProcessingSequencePosition Processing Position
ATPCheckingRule ATPCheckingRule Checking rule
ChosenATPConfCompositionUUID ChosenATPConfCompositionUUID Conf. Composition
RecmddATPConfCompositionUUID RecmddATPConfCompositionUUID Recommendation
_Check _Check
_ConfirmationComposition _ConfirmationComposition
_ChosenConfirmationComposition _ChosenConfirmationComposition
_ChosenConfirmation _ChosenConfirmation
_RecommendedConfComposition _RecommendedConfComposition
_RecommendedConfirmation _RecommendedConfirmation
_SelectedRequirement _SelectedRequirement
_BasicMethodRequest _BasicMethodRequest
_OverruleConfCheckRequest _OverruleConfCheckRequest
_ConfirmationAdjustmentStep _ConfirmationAdjustmentStep
_BasicMethodRqmtCheckRequest _BasicMethodRqmtCheckRequest

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_ATPProcessedRequirement.
-- 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: IATPPROCDRQMT

CREATE VIEW I_ATPProcessedRequirement AS
SELECT
  ATPRequirementUUID,
  ATPCheckUUID,
  ATPCheckVersion,
  ATPRqmtIsProcessedExternally,
  ATPConfirmationsAreEditable,
  ProcessingSequencePosition,
  ATPCheckingRule,
  ChosenATPConfCompositionUUID,
  RecmddATPConfCompositionUUID
FROM R_ATPProcdBasicRequirement
LEFT OUTER JOIN I_ATPConfirmationComposition AS _RecommendedConfComposition ON RecmddATPConfCompositionUUID = _RecommendedConfComposition.ATPConfirmationCompositionUUID  -- association [0..1]
LEFT OUTER JOIN I_ATPConfirmationAfterCheck AS _RecommendedConfirmation ON RecmddATPConfCompositionUUID = _RecommendedConfirmation.ATPConfirmationCompositionUUID  -- association [0..*]
LEFT OUTER JOIN I_ATPBasicMethodRqmtCheckReq AS _BasicMethodRqmtCheckRequest ON ATPRequirementUUID = _BasicMethodRqmtCheckRequest.ATPBasicMethChkSqncExecReqUUID  -- association [0..*]
LEFT OUTER JOIN I_ATPProcdRqmtBasicMethRequest AS _BasicMethodRequest ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ATPOverruleConfCheckReq AS _OverruleConfCheckRequest ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ATPConfirmationComposition AS _ConfirmationComposition ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ATPConfAdjustmentStep AS _ConfirmationAdjustmentStep ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More