R_CntrlPurContrHdrDistrTP

DDL: R_CNTRLPURCONTRHDRDISTRTP Type: view_entity TRANSACTIONAL
48 Fields 1 Data Sources 3 Associations

Cntrl PC Header Distribution

R_CntrlPurContrHdrDistrTP is a Transactional CDS View that provides data about "Cntrl PC Header Distribution" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrDistribution) and exposes 48 fields with key fields CentralPurchaseContract, 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 _CntrlPurContrDistriExtension $projection.CentralPurchaseContract = _CntrlPurContrDistriExtension.PurchasingDocument and $projection.DistributionKey = _CntrlPurContrDistriExtension.DistributionKey
[0..1] I_UnitOfMeasure _OrderQuantityUnit $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
[0..*] R_CntrlPurContrHdrDistrPartTP _CentralPurchaseContHdrPart

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Cntrl PC Header 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 #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY DistributionKey DistributionKey Distr. Number
CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
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
IsDeleted TRUE
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderQuantityUnitISOCode _OrderQuantityUnit UnitOfMeasureISOCode
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
ProcmtHubDelivAddressTypeCode ProcmtHubDelivAddressTypeCode
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode InfoUpdate
SourceListIsUpdated SourceListIsUpdated Sourcelist Updated
SourceListRestriction SourceListRestriction SrcListRstrcn
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID Grouping 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 _CentralPurchaseContract LastChangeDateTime Timestamp
_CentralPurchaseContHdrPart _CentralPurchaseContHdrPart
_CntrlPurchaseContract _CntrlPurchaseContract

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_CntrlPurContrHdrDistrTP.
-- 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_CntrlPurContrHdrDistrTP AS
SELECT
  CentralPurchaseContract,
  DistributionKey,
  CentralPurchaseContractItem,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  DocumentCurrency,
  PurchasingGroup,
  StorageLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  CntrlPurContrDistributionPct,
  cast ( IsDeleted as xfeld ) AS IsDeleted,
  OrderQuantityUnit,
  _OrderQuantityUnit.UnitOfMeasureISOCode AS OrderQuantityUnitISOCode,
  ManualDeliveryAddressID,
  ProcmtHubDelivAddressTypeCode,
  ProcurementHubSourceSystem,
  PurchasingInfoRecordUpdateCode,
  SourceListIsUpdated,
  SourceListRestriction,
  ProcmtHubCompanyCodeGroupingID,
  IncotermsClassification,
  IncotermsLocation1,
  ShippingInstruction,
  ProcmtHubSubcontractor,
  ProcmtHubSuplrIsSubcontractor,
  ReferenceDeliveryAddressID,
  FormOfAddress,
  ProcmtHubBusinessPartnerName1,
  ProcmtHubBusinessPartnerName2,
  ProcmtHubBusinessPartnerName3,
  ProcmtHubBusinessPartnerName4,
  ProcmtHubStreetName,
  ProcmtHubHouseNumber,
  ProcmtHubPostalCode,
  ProcmtHubCityName,
  ProcmtHubCountry,
  ProcmtHubRegion,
  _CentralPurchaseContract.LastChangeDateTime AS LastChangeDateTime
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN E_CntrlPurContrDistribution AS _CntrlPurContrDistriExtension ON CentralPurchaseContract = _CntrlPurContrDistriExtension.PurchasingDocument AND DistributionKey = _CntrlPurContrDistriExtension.DistributionKey  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN R_CntrlPurContrHdrDistrPartTP AS _CentralPurchaseContHdrPart ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More