C_CntrlPurContrItemPartnerTP

DDL: C_CNTRLPURCONTRITEMPARTNERTP SQL: CCPCITMPARTNERTP Type: view CONSUMPTION Package: ODATA_MM_CCTR_MAINTAIN
14 Fields 1 Data Sources 3 Associations

Consumption View for Item Distribution Partners

C_CntrlPurContrItemPartnerTP is a Consumption CDS View that provides data about "Consumption View for Item Distribution Partners" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrItemPartnerTP) and exposes 14 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey, PartnerCounter. It has 3 associations to related views. Part of development package ODATA_MM_CCTR_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrItemPartnerTP I_CntrlPurContrItemPartnerTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_CentralPurchaseContractTP _CentralPurchaseContractTP _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract
[1..1] C_CntrlPurchaseContractItemTP _CntrlPurchaseContractItemTP _CntrlPurchaseContractItemTP.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurchaseContractItemTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem
[1..1] C_CntrlPurContrDistributionTP _CntrlPurContrDistributionTP _CntrlPurContrDistributionTP.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrDistributionTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem and _CntrlPurContrDistributionTP.DistributionKey = $projection.DistributionKey

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCPCITMPARTNERTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Consumption View for Item Distribution Partners view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #REQUIRED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
KEY DistributionKey DistributionKey Distr. Number
KEY PartnerCounter PartnerCounter Partner counter
PurchasingDocumentCategory _CntrlPurContrDistributionTP PurchasingDocumentCategory Doc. Category
PurchasingDocumentType _CntrlPurContrDistributionTP PurchasingDocumentType RFQ Type
ProcurementHubSourceSystem _CntrlPurContrDistributionTP ProcmtHubLogicalSystem
PartnerFunction PartnerFunction Partner Functn
ExtPlantForPurg ExtPlantForPurg Plant
Supplier Supplier Supplier
SupplierSubrange SupplierSubrange Suppl. Subrange
PurchasingOrganization PurchasingOrganization Purchasing Organization
_CentralPurchaseContractTP _CentralPurchaseContractTP
_CntrlPurContrDistributionTP _CntrlPurContrDistributionTP

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 C_CntrlPurContrItemPartnerTP.
-- 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: CCPCITMPARTNERTP

CREATE VIEW C_CntrlPurContrItemPartnerTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  PartnerCounter,
  _CntrlPurContrDistributionTP.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _CntrlPurContrDistributionTP.PurchasingDocumentType AS PurchasingDocumentType,
  _CntrlPurContrDistributionTP.ProcmtHubLogicalSystem AS ProcurementHubSourceSystem,
  PartnerFunction,
  ExtPlantForPurg,
  Supplier,
  SupplierSubrange,
  PurchasingOrganization
FROM I_CntrlPurContrItemPartnerTP
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurchaseContractItemTP AS _CntrlPurchaseContractItemTP ON _CntrlPurchaseContractItemTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurchaseContractItemTP.CentralPurchaseContractItem = CentralPurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrDistributionTP AS _CntrlPurContrDistributionTP ON _CntrlPurContrDistributionTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrDistributionTP.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrDistributionTP.DistributionKey = DistributionKey  -- association [1..1]
;

Learn More