R_CntrlPurContrHdrDistrTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_CntrlPurContrDistribution | I_CntrlPurContrDistribution | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CentralPurchaseContract | CentralPurchaseContract | ||
| KEY | DistributionKey | DistributionKey | ||
| CentralPurchaseContractItem | CentralPurchaseContractItem | |||
| PurchasingDocumentCategory | PurchasingDocumentCategory | |||
| PurchasingDocumentType | PurchasingDocumentType | |||
| PurchasingOrganization | PurchasingOrganization | |||
| CompanyCode | CompanyCode | |||
| Plant | Plant | |||
| DocumentCurrency | DocumentCurrency | |||
| PurchasingGroup | PurchasingGroup | |||
| StorageLocation | StorageLocation | |||
| PaymentTerms | PaymentTerms | |||
| CashDiscount1Days | CashDiscount1Days | |||
| CashDiscount2Days | CashDiscount2Days | |||
| NetPaymentDays | NetPaymentDays | |||
| CashDiscount1Percent | CashDiscount1Percent | |||
| CashDiscount2Percent | CashDiscount2Percent | |||
| CntrlPurContrDistributionPct | CntrlPurContrDistributionPct | |||
| IsDeleted | ||||
| OrderQuantityUnit | OrderQuantityUnit | |||
| OrderQuantityUnitISOCode | _OrderQuantityUnit | UnitOfMeasureISOCode | ||
| ManualDeliveryAddressID | ManualDeliveryAddressID | |||
| ProcmtHubDelivAddressTypeCode | ProcmtHubDelivAddressTypeCode | |||
| ProcurementHubSourceSystem | ProcurementHubSourceSystem | |||
| PurchasingInfoRecordUpdateCode | PurchasingInfoRecordUpdateCode | |||
| SourceListIsUpdated | SourceListIsUpdated | |||
| SourceListRestriction | SourceListRestriction | |||
| ProcmtHubCompanyCodeGroupingID | ProcmtHubCompanyCodeGroupingID | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| ShippingInstruction | ShippingInstruction | |||
| ProcmtHubSubcontractor | ProcmtHubSubcontractor | |||
| ProcmtHubSuplrIsSubcontractor | ProcmtHubSuplrIsSubcontractor | |||
| ReferenceDeliveryAddressID | ReferenceDeliveryAddressID | |||
| FormOfAddress | FormOfAddress | |||
| ProcmtHubBusinessPartnerName1 | ProcmtHubBusinessPartnerName1 | |||
| ProcmtHubBusinessPartnerName2 | ProcmtHubBusinessPartnerName2 | |||
| ProcmtHubBusinessPartnerName3 | ProcmtHubBusinessPartnerName3 | |||
| ProcmtHubBusinessPartnerName4 | ProcmtHubBusinessPartnerName4 | |||
| ProcmtHubStreetName | ProcmtHubStreetName | |||
| ProcmtHubHouseNumber | ProcmtHubHouseNumber | |||
| ProcmtHubPostalCode | ProcmtHubPostalCode | |||
| ProcmtHubCityName | ProcmtHubCityName | |||
| ProcmtHubCountry | ProcmtHubCountry | |||
| ProcmtHubRegion | ProcmtHubRegion | |||
| LastChangeDateTime | _CentralPurchaseContract | LastChangeDateTime | ||
| _CentralPurchaseContHdrPart | _CentralPurchaseContHdrPart | |||
| _CntrlPurchaseContract | _CntrlPurchaseContract |
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Cntrl PC Header Distribution'
@VDM.viewType : #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey: [ 'CentralPurchaseContract','DistributionKey']
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations: true
define view entity R_CntrlPurContrHdrDistrTP
as select from I_CntrlPurContrDistribution
composition [0..*] of R_CntrlPurContrHdrDistrPartTP as _CentralPurchaseContHdrPart
association to parent R_CntrlPurchaseContractTP as _CntrlPurchaseContract on $projection.CentralPurchaseContract = _CntrlPurchaseContract.CentralPurchaseContract
----Extension Association
association [1..1] to E_CntrlPurContrDistribution as _CntrlPurContrDistriExtension on $projection.CentralPurchaseContract = _CntrlPurContrDistriExtension.PurchasingDocument
and $projection.DistributionKey = _CntrlPurContrDistriExtension.DistributionKey
association [0..1] to I_UnitOfMeasure as _OrderQuantityUnit on $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
{
key CentralPurchaseContract,
key 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,
@Semantics.booleanIndicator: true
SourceListIsUpdated,
SourceListRestriction,
ProcmtHubCompanyCodeGroupingID,
IncotermsClassification,
IncotermsLocation1,
ShippingInstruction,
ProcmtHubSubcontractor,
ProcmtHubSuplrIsSubcontractor,
ReferenceDeliveryAddressID,
FormOfAddress,
ProcmtHubBusinessPartnerName1,
ProcmtHubBusinessPartnerName2,
ProcmtHubBusinessPartnerName3,
ProcmtHubBusinessPartnerName4,
ProcmtHubStreetName,
ProcmtHubHouseNumber,
ProcmtHubPostalCode,
ProcmtHubCityName,
ProcmtHubCountry,
ProcmtHubRegion,
@Semantics.systemDateTime.lastChangedAt: true
_CentralPurchaseContract.LastChangeDateTime as LastChangeDateTime,
//Association
_CentralPurchaseContHdrPart,
_CntrlPurchaseContract
}
where
CentralPurchaseContractItem = '00000'
and CntrlPurContrDistributionLevel = 'H'
and _CntrlPurchaseContract.CentralPurchaseContract is not null;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CENTRALPURCHASECONTRACT",
"I_CNTRLPURCONTRDISTRIBUTION",
"I_UNITOFMEASURE",
"R_CNTRLPURCHASECONTRACTTP"
],
"ASSOCIATED":
[
"R_CNTRLPURCHASECONTRACTTP",
"R_CNTRLPURCONTRHDRDISTRPARTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA