R_CntrlPurContrItmDistrPartTP

DDL: R_CNTRLPURCONTRITMDISTRPARTTP Type: view_entity TRANSACTIONAL
12 Fields 1 Data Sources

CCTR Item Distribution Partner

R_CntrlPurContrItmDistrPartTP is a Transactional CDS View that provides data about "CCTR Item Distribution Partner" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurchaseContractPartner) and exposes 12 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey, PartnerCounter.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurchaseContractPartner I_CntrlPurchaseContractPartner from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label CCTR Item Distribution Partner view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

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
PartnerFunction PartnerFunction Partner Functn
ExtPlantForPurg ExtPlantForPurg Plant
Supplier Supplier Supplier
SupplierSubrange SupplierSubrange Suppl. Subrange
PurchasingOrganization PurchasingOrganization Purchasing Organization
LastChangeDateTime _CntrlPurContract LastChangeDateTime Timestamp
_CntrlPurContract _CntrlPurContract
_CntrlPurContrItmDist _CntrlPurContrItmDist

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 R_CntrlPurContrItmDistrPartTP.
-- 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 R_CntrlPurContrItmDistrPartTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  PartnerCounter,
  PartnerFunction,
  ExtPlantForPurg,
  Supplier,
  SupplierSubrange,
  PurchasingOrganization,
  _CntrlPurContract.LastChangeDateTime AS LastChangeDateTime
FROM I_CntrlPurchaseContractPartner
;

Learn More