I_ATPSeldRequirementLegacyTP

DDL: I_ATPSELDREQUIREMENTLEGACYTP SQL: IATPSELDREQMTLTP Type: view TRANSACTIONAL Package: ATP_RESULT
34 Fields 1 Data Sources 3 Associations

Selected ATP Requirement Legacy Transactional Processing

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

Data Sources (1)

SourceAliasJoin Type
I_ATPSelectedRequirement I_ATPSelectedRequirement from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ATPProcdRequirementLegacyTP _ProcessedRequirement $projection.ATPRequirementUUID = _ProcessedRequirement.ATPRequirementUUID
[0..1] I_ATPExcldRequirementLegacyTP _ExcludedRequirement $projection.ATPRequirementUUID = _ExcludedRequirement.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 IATPSELDREQMTLTP 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_SELD_RQMT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Selected ATP Requirement Legacy Transactional Processing view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ATPRequirementUUID ATPRequirementUUID Requirement UUID
ATPCheckUUID ATPCheckUUID Check ID
ATPCheckVersion ATPCheckVersion ATP Check Version
ATPRelevantDocumentCategory ATPRelevantDocumentCategory ATP: Category of Stock / Receipts / Issues
ATPRelevantDocument ATPRelevantDocument MRP element number
ATPRelevantDocumentItem ATPRelevantDocumentItem MRP elemnt item
ATPRelevantDocScheduleLine ATPRelevantDocScheduleLine Scheduling
Product Product Product Sold
SupplyingPlant SupplyingPlant Supplying Plant
SupplyingStorageLocation SupplyingStorageLocation Location
Batch Batch Lot No.
InventorySpecialStockType InventorySpecialStockType Special Stock Type
RequestedQuantityInBaseUnit RequestedQuantityInBaseUnit Requested Qty
BaseUnit BaseUnit Unit of Measure
ReqdProdAvailabilityUTCDateTme ReqdProdAvailabilityUTCDateTme Req. Mat. Avail. Dte
ReqdProdAvailabilityTimeZone ReqdProdAvailabilityTimeZone Time Zone
RequestedLoadingUTCDateTime RequestedLoadingUTCDateTime Req. Loading Date
RequestedLoadingTimeZone RequestedLoadingTimeZone Time Zone
RequestedGoodsIssueUTCDateTime RequestedGoodsIssueUTCDateTime Req. Goods Issue
RequestedGoodsIssueTimeZone RequestedGoodsIssueTimeZone Time Zone
RequestedDeliveryUTCDateTime RequestedDeliveryUTCDateTime Req. Delivery Date
RequestedDeliveryTimeZone RequestedDeliveryTimeZone Time Zone
MatchingABOPSegmentUUID MatchingABOPSegmentUUID BOP Segment UUID
AssgdABOPConfirmationStrategy AssgdABOPConfirmationStrategy Confirmation Strategy
_ProcessedRequirement _ProcessedRequirement
_ExcludedRequirement _ExcludedRequirement
_Check _Check
_ATPRlvtDocumentCategory _ATPRlvtDocumentCategory
_BaseUnit _BaseUnit
_Batch _Batch
_InventorySpecialStockType _InventorySpecialStockType
_Product _Product
_SupplyingPlant _SupplyingPlant
_SupplyingStorageLocation _SupplyingStorageLocation

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_ATPSeldRequirementLegacyTP.
-- 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: IATPSELDREQMTLTP

CREATE VIEW I_ATPSeldRequirementLegacyTP AS
SELECT
  ATPRequirementUUID,
  ATPCheckUUID,
  ATPCheckVersion,
  ATPRelevantDocumentCategory,
  ATPRelevantDocument,
  ATPRelevantDocumentItem,
  ATPRelevantDocScheduleLine,
  Product,
  SupplyingPlant,
  SupplyingStorageLocation,
  Batch,
  InventorySpecialStockType,
  RequestedQuantityInBaseUnit,
  BaseUnit,
  ReqdProdAvailabilityUTCDateTme,
  ReqdProdAvailabilityTimeZone,
  RequestedLoadingUTCDateTime,
  RequestedLoadingTimeZone,
  RequestedGoodsIssueUTCDateTime,
  RequestedGoodsIssueTimeZone,
  RequestedDeliveryUTCDateTime,
  RequestedDeliveryTimeZone,
  MatchingABOPSegmentUUID,
  AssgdABOPConfirmationStrategy
FROM I_ATPSelectedRequirement
LEFT OUTER JOIN I_ATPProcdRequirementLegacyTP AS _ProcessedRequirement ON ATPRequirementUUID = _ProcessedRequirement.ATPRequirementUUID  -- association [0..1]
LEFT OUTER JOIN I_ATPExcldRequirementLegacyTP AS _ExcludedRequirement ON ATPRequirementUUID = _ExcludedRequirement.ATPRequirementUUID  -- association [0..1]
LEFT OUTER JOIN I_ATPCheckLegacyTP AS _Check ON ATPCheckUUID = _Check.ATPCheckUUID  -- association [1..1]
;

Learn More