A_PurchaseContractPartners_2

DDL: A_PURCHASECONTRACTPARTNERS_2 SQL: APURCTRPRTNRS2 Type: view COMPOSITE Package: ODATA_MM_PUR_CON_API
11 Fields 1 Data Sources 2 Associations

Purchase Contract Partner

A_PurchaseContractPartners_2 is a Composite CDS View that provides data about "Purchase Contract Partner" in SAP S/4HANA. It reads from 1 data source (I_Purctrpartners) and exposes 11 fields with key fields PurchaseContract, PurchaseContractItem, PurchasingOrganization, PartnerFunction, Plant. It has 2 associations to related views. Part of development package ODATA_MM_PUR_CON_API.

Data Sources (1)

SourceAliasJoin Type
I_Purctrpartners I_Purctrpartners from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_PurchaseContract_2 _PurchaseContract $projection.PurchaseContract = _PurchaseContract.PurchaseContract
[1..1] A_PurchaseContractItem_2 _PurchaseContractItem $projection.PurchaseContract = _PurchaseContractItem.PurchaseContract and $projection.PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName APURCTRPRTNRS2 view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Contract Partner view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
OData.entitySet.name A_PurCtrPartners view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_Purctrpartners PurchaseContract Purchasing Doc.
KEY PurchaseContractItem I_Purctrpartners PurchaseContractItem Item
KEY PurchasingOrganization I_Purctrpartners PurchasingOrganization Purchasing Organization
KEY PartnerFunction PartnerFunction Partner Functn
KEY Plant I_Purctrpartners Plant Valuation Area
KEY SupplierSubrange I_Purctrpartners SupplierSubrange Suppl. Subrange
KEY PartnerCounter I_Purctrpartners PartnerCounter Partner counter
Supplier I_Purctrpartners Supplier Supplier
DefaultPartner I_Purctrpartners DefaultPartner Default Partner
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem

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 A_PurchaseContractPartners_2.
-- 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: APURCTRPRTNRS2

CREATE VIEW A_PurchaseContractPartners_2 AS
SELECT
  I_Purctrpartners.PurchaseContract AS PurchaseContract,
  I_Purctrpartners.PurchaseContractItem AS PurchaseContractItem,
  I_Purctrpartners.PurchasingOrganization AS PurchasingOrganization,
  PartnerFunction,
  I_Purctrpartners.Plant AS Plant,
  I_Purctrpartners.SupplierSubrange AS SupplierSubrange,
  I_Purctrpartners.PartnerCounter AS PartnerCounter,
  I_Purctrpartners.Supplier AS Supplier,
  I_Purctrpartners.DefaultPartner AS DefaultPartner
FROM I_Purctrpartners
LEFT OUTER JOIN A_PurchaseContract_2 AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN A_PurchaseContractItem_2 AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract AND PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem  -- association [1..1]
;

Learn More