I_ATPExcldRequirementLegacyTP

DDL: I_ATPEXCLDREQUIREMENTLEGACYTP SQL: IATPEXCLDRQMTLTP Type: view TRANSACTIONAL Package: ATP_RESULT
6 Fields 1 Data Sources 2 Associations

Excluded ATP Requirement Legacy Transactional Processing

I_ATPExcldRequirementLegacyTP is a Transactional CDS View that provides data about "Excluded ATP Requirement Legacy Transactional Processing" in SAP S/4HANA. It reads from 1 data source (I_ATPExcludedRequirement) and exposes 6 fields with key field ATPRequirementUUID. It has 2 associations to related views. Part of development package ATP_RESULT.

Data Sources (1)

SourceAliasJoin Type
I_ATPExcludedRequirement I_ATPExcludedRequirement from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ATPSeldRequirementLegacyTP _SelectedRequirement $projection.ATPRequirementUUID = _SelectedRequirement.ATPRequirementUUID
[1..1] I_ATPCheckLegacyTP _Check $projection.ATPCheckUUID = _Check.ATPCheckUUID

Annotations (15)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.sqlViewName IATPEXCLDRQMTLTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.writeDraftPersistence ATPLD_EXCLD_RQMT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Excluded ATP Requirement Legacy Transactional Processing view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ATPRequirementUUID ATPRequirementUUID Requirement UUID
ATPCheckUUID ATPCheckUUID Check ID
ATPCheckVersion ATPCheckVersion ATP Check Version
ATPProcessingExclusionReason ATPProcessingExclusionReason
_SelectedRequirement _SelectedRequirement
_Check _Check

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_ATPExcldRequirementLegacyTP.
-- 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: IATPEXCLDRQMTLTP

CREATE VIEW I_ATPExcldRequirementLegacyTP AS
SELECT
  ATPRequirementUUID,
  ATPCheckUUID,
  ATPCheckVersion,
  ATPProcessingExclusionReason
FROM I_ATPExcludedRequirement
LEFT OUTER JOIN I_ATPSeldRequirementLegacyTP AS _SelectedRequirement ON ATPRequirementUUID = _SelectedRequirement.ATPRequirementUUID  -- association [1..1]
LEFT OUTER JOIN I_ATPCheckLegacyTP AS _Check ON ATPCheckUUID = _Check.ATPCheckUUID  -- association [1..1]
;

Learn More