R_CntrlPurContrItemDistrTP

DDL: R_CNTRLPURCONTRITEMDISTRTP Type: view_entity TRANSACTIONAL
61 Fields 1 Data Sources 3 Associations

CCTR Item Distribution

R_CntrlPurContrItemDistrTP is a Transactional CDS View that provides data about "CCTR Item Distribution" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrDistribution) and exposes 61 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrDistribution I_CntrlPurContrDistribution from

Associations (3)

CardinalityTargetAliasCondition
[1..1] E_CntrlPurContrDistribution _CntrlPurContrItmDistExtension $projection.CentralPurchaseContract = _CntrlPurContrItmDistExtension.PurchasingDocument and $projection.CentralPurchaseContractItem = _CntrlPurContrItmDistExtension.PurchasingDocumentItem and $projection.DistributionKey = _CntrlPurContrItmDistExtension.DistributionKey
[0..1] I_UnitOfMeasure _OrderQuantityUnit $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
[0..*] R_CntrlPurContrItmDistrPartTP _CntrlPurContrItemPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label CCTR Item Distribution 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 (61)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
KEY DistributionKey DistributionKey Distr. Number
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
DocumentCurrency DocumentCurrency Document Currency
PurchasingGroup PurchasingGroup Purchasing Group
StorageLocation StorageLocation StorageLocation
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
CntrlPurContrDistributionPct CntrlPurContrDistributionPct
TargetQuantity TargetQuantity Target Quantity
TargetAmount TargetAmount Target Value
PurgDocItemDistributionStatus PurgDocItemDistributionStatus
IsDeleted TRUE
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderQuantityUnitISOCode _OrderQuantityUnit UnitOfMeasureISOCode
DistributionType DistributionType Distribution Type
DistrResponseMessageUUID DistrResponseMessageUUID GUID
ItemDistributionIsRelevant Is Relevant
ReferenceHeaderDistributionKey ReferenceHeaderDistributionKey
CntrlPurContrItmDistrIsBlocked
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
ProcmtHubDelivAddressTypeCode ProcmtHubDelivAddressTypeCode
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode InfoUpdate
ProcmtHubPurchaseRequisition ProcmtHubPurchaseRequisition Purchase Req.
ProcmtHubPurRequisitionItem ProcmtHubPurRequisitionItem Requisn. item
SourceListIsUpdated SourceListIsUpdated Sourcelist Updated
SourceListRestriction SourceListRestriction SrcListRstrcn
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID Grouping ID
OutlineAgrmtItmIsBlocked OutlineAgrmtItmIsBlocked OA Blocked Ind
PurgDocItmBlkRsnCode PurgDocItmBlkRsnCode Block Reason ID
IncotermsClassification IncotermsClassification Incoterms
IncotermsLocation1 IncotermsLocation1 Inco. Location1
ShippingInstruction ShippingInstruction Shipping Instr.
ProcmtHubSubcontractor ProcmtHubSubcontractor Supplier
ProcmtHubSuplrIsSubcontractor ProcmtHubSuplrIsSubcontractor SC Supplier
ReferenceDeliveryAddressID ReferenceDeliveryAddressID Reference Address
FormOfAddress FormOfAddress Title Key
ProcmtHubBusinessPartnerName1 ProcmtHubBusinessPartnerName1 Name
ProcmtHubBusinessPartnerName2 ProcmtHubBusinessPartnerName2 Name 2
ProcmtHubBusinessPartnerName3 ProcmtHubBusinessPartnerName3 Name 3
ProcmtHubBusinessPartnerName4 ProcmtHubBusinessPartnerName4 Name 4
ProcmtHubStreetName ProcmtHubStreetName Street
ProcmtHubHouseNumber ProcmtHubHouseNumber House Number
ProcmtHubPostalCode ProcmtHubPostalCode Postal Code
ProcmtHubCityName ProcmtHubCityName City
ProcmtHubCountry ProcmtHubCountry Country/Reg.
ProcmtHubRegion ProcmtHubRegion Region
LastChangeDateTime _CntrlPurContract LastChangeDateTime Timestamp
_CntrlPurContract _CntrlPurContract
_CntrlPurchaseContractItem _CntrlPurchaseContractItem
_CntrlPurContrItemPartner _CntrlPurContrItemPartner

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_CntrlPurContrItemDistrTP.
-- 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_CntrlPurContrItemDistrTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  DocumentCurrency,
  PurchasingGroup,
  StorageLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  CntrlPurContrDistributionPct,
  TargetQuantity,
  TargetAmount,
  PurgDocItemDistributionStatus,
  cast ( IsDeleted as xfeld ) AS IsDeleted,
  OrderQuantityUnit,
  _OrderQuantityUnit.UnitOfMeasureISOCode AS OrderQuantityUnitISOCode,
  DistributionType,
  DistrResponseMessageUUID,
  cast ( ItemDistributionIsRelevant as xfeld ) AS ItemDistributionIsRelevant,
  ReferenceHeaderDistributionKey,
  cast ( CntrlPurContrItmDistrIsBlocked as xfeld ) AS CntrlPurContrItmDistrIsBlocked,
  ManualDeliveryAddressID,
  ProcmtHubDelivAddressTypeCode,
  ProcurementHubSourceSystem,
  PurchasingInfoRecordUpdateCode,
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  SourceListIsUpdated,
  SourceListRestriction,
  ProcmtHubCompanyCodeGroupingID,
  OutlineAgrmtItmIsBlocked,
  PurgDocItmBlkRsnCode,
  IncotermsClassification,
  IncotermsLocation1,
  ShippingInstruction,
  ProcmtHubSubcontractor,
  ProcmtHubSuplrIsSubcontractor,
  ReferenceDeliveryAddressID,
  FormOfAddress,
  ProcmtHubBusinessPartnerName1,
  ProcmtHubBusinessPartnerName2,
  ProcmtHubBusinessPartnerName3,
  ProcmtHubBusinessPartnerName4,
  ProcmtHubStreetName,
  ProcmtHubHouseNumber,
  ProcmtHubPostalCode,
  ProcmtHubCityName,
  ProcmtHubCountry,
  ProcmtHubRegion,
  _CntrlPurContract.LastChangeDateTime AS LastChangeDateTime
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN E_CntrlPurContrDistribution AS _CntrlPurContrItmDistExtension ON CentralPurchaseContract = _CntrlPurContrItmDistExtension.PurchasingDocument AND CentralPurchaseContractItem = _CntrlPurContrItmDistExtension.PurchasingDocumentItem AND DistributionKey = _CntrlPurContrItmDistExtension.DistributionKey  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN R_CntrlPurContrItmDistrPartTP AS _CntrlPurContrItemPartner ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More