I_ATPSourceOfSupply

DDL: I_ATPSOURCEOFSUPPLY Type: view_entity COMPOSITE Package: ATP_TPOP_SOURCES_OF_SUPPLY
10 Fields 2 Data Sources 2 Associations

ATP Source of Supply

I_ATPSourceOfSupply is a Composite CDS View that provides data about "ATP Source of Supply" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseContractItem, I_PurchasingInfoRecord) and exposes 10 fields with key fields ATPSourceOfSupplyType, ATPSourceOfSupplyDocument, ATPSourceOfSupplyDocumentItem, ATPSourceOfSupplyDocument, ATPSourceOfSupplyDocumentItem. It has 2 associations to related views. Part of development package ATP_TPOP_SOURCES_OF_SUPPLY.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseContractItem I_PurchaseContractItem from
I_PurchasingInfoRecord I_PurchasingInfoRecord union

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Supplier _Supplier $projection.supplier = _Supplier.Supplier
[1..1] I_ATPSourceOfSupplyType _SourceOfSupplyType $projection.ATPSourceOfSupplyType = _SourceOfSupplyType.ATPSourceOfSupplyType

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label ATP Source of Supply view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ATPSourceOfSupplyType
KEY ATPSourceOfSupplyDocument Info Record
KEY ATPSourceOfSupplyDocumentItem Item
Supplier _PurchaseContract Supplier Supplier
_Supplier _Supplier
KEY ATPSourceOfSupplyDocument Info Record
KEY ATPSourceOfSupplyDocumentItem Item
Supplier Supplier Supplier
_Supplier _Supplier
_SourceOfSupplyType _SourceOfSupplyType

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_ATPSourceOfSupply.
-- 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.

CREATE VIEW I_ATPSourceOfSupply AS
SELECT
  cast('C' as src_supply_type preserving type) AS ATPSourceOfSupplyType,
  cast(PurchaseContract as src_supply_id preserving type) AS ATPSourceOfSupplyDocument,
  cast(PurchaseContractItem as src_supply_item preserving type) AS ATPSourceOfSupplyDocumentItem,
  _PurchaseContract.Supplier AS Supplier
FROM I_PurchaseContractItem
LEFT OUTER JOIN I_Supplier AS _Supplier ON supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_ATPSourceOfSupplyType AS _SourceOfSupplyType ON ATPSourceOfSupplyType = _SourceOfSupplyType.ATPSourceOfSupplyType  -- association [1..1]
-- UNION with additional select branch(es): I_PurchasingInfoRecord
;

Learn More