R_PurchaseContractItemTP
Purchase Contract Item
R_PurchaseContractItemTP is a Transactional CDS View that provides data about "Purchase Contract Item" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 82 fields with key fields PurchaseContract, PurchaseContractItem. It has 5 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurchaseContractItem | I_PurchaseContractItem | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | E_PurchasingDocumentItem | _PurchasingDocumentItem | $projection.PurchaseContract = _PurchasingDocumentItem.PurchasingDocument and $projection.PurchaseContractItem = _PurchasingDocumentItem.PurchasingDocumentItem |
| [0..*] | R_PurContrAccountTP | _PurCtrAccount | |
| [0..1] | R_PurContrAddressTP | _PurCtrAddress | |
| [0..*] | R_PurContrItemNotesTP | _PurCtrItNotes | |
| [1..*] | R_PurContrItemCndnValdtyTP | _PurContrItemCndnValdty | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Purchase Contract Item | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.representativeKey | PurchaseContractItem | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (82)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseContract | PurchaseContract | ||
| KEY | PurchaseContractItem | PurchaseContractItem | ||
| PurchaseContractItemUniqueID | PurchaseContractItemUniqueID | |||
| CompanyCode | CompanyCode | |||
| Material | Material | |||
| ManufacturerMaterial | ManufacturerMaterial | |||
| PurchaseContractItemText | PurchaseContractItemText | |||
| ContractNetPriceAmount | ContractNetPriceAmount | |||
| OrderPriceUnit | OrderPriceUnit | |||
| VolumeUnit | VolumeUnit | |||
| OrderQuantityUnit | OrderQuantityUnit | |||
| MaterialGroup | MaterialGroup | |||
| Customer | Customer | |||
| Subcontractor | Subcontractor | |||
| ReferenceDeliveryAddressID | ReferenceDeliveryAddressID | |||
| ManualDeliveryAddressID | ManualDeliveryAddressID | |||
| DeliveryAddressID | DeliveryAddressID | |||
| Plant | Plant | |||
| StorageLocation | StorageLocation | |||
| AccountAssignmentCategory | AccountAssignmentCategory | |||
| GoodsReceiptIsExpected | GoodsReceiptIsExpected | |||
| NetPriceQuantity | NetPriceQuantity | |||
| MultipleAcctAssgmtDistribution | MultipleAcctAssgmtDistribution | |||
| TargetQuantity | TargetQuantity | |||
| TargetAmount | TargetAmount | |||
| DocumentCurrency | DocumentCurrency | |||
| OrdPriceUnitToOrderUnitDnmntr | OrdPriceUnitToOrderUnitDnmntr | |||
| OrderPriceUnitToOrderUnitNmrtr | OrderPriceUnitToOrderUnitNmrtr | |||
| PurchasingDocumentItemCategory | PurchasingDocumentItemCategory | |||
| SupplierMaterialNumber | SupplierMaterialNumber | |||
| EvaldRcptSettlmtIsAllowed | EvaldRcptSettlmtIsAllowed | |||
| UnderdelivTolrtdLmtRatioInPct | UnderdelivTolrtdLmtRatioInPct | |||
| PriceIsToBePrinted | PriceIsToBePrinted | |||
| SupplierConfirmationControlKey | SupplierConfirmationControlKey | |||
| OverdelivTolrtdLmtRatioInPct | OverdelivTolrtdLmtRatioInPct | |||
| UnlimitedOverdeliveryIsAllowed | UnlimitedOverdeliveryIsAllowed | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| InvoiceIsExpected | InvoiceIsExpected | |||
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased | |||
| PurgDocPriceDate | PurgDocPriceDate | |||
| PurchasingInfoRecordUpdateCode | PurchasingInfoRecordUpdateCode | |||
| PurgDocReleaseOrderQuantity | PurgDocReleaseOrderQuantity | |||
| PurgDocOrderAcknNumber | PurgDocOrderAcknNumber | |||
| PurchasingPriceIsEstimated | PurgDocEstimatedPrice | |||
| IsInfoAtRegistration | IsInfoAtRegistration | |||
| NoDaysReminder1 | NoDaysReminder1 | |||
| NoDaysReminder2 | NoDaysReminder2 | |||
| NoDaysReminder3 | NoDaysReminder3 | |||
| PlannedDeliveryDurationInDays | PlannedDeliveryDurationInDays | |||
| StockType | StockType | |||
| TaxCode | TaxCode | |||
| TaxCountry | TaxCountry | |||
| TaxDeterminationDate | TaxDeterminationDate | |||
| RequirementTracking | RequirementTracking | |||
| IsOrderAcknRqd | IsOrderAcknRqd | |||
| ShippingInstruction | ShippingInstruction | |||
| GoodsReceiptIsNonValuated | GoodsReceiptIsNonValuated | |||
| ServicePerformer | ServicePerformer | |||
| ProductTypeCode | ProductTypeCode | |||
| MaterialType | MaterialType | |||
| PurchaseContractItemFormatted | PurchaseContractItemFormatted | |||
| PurchasingContractDeletionCode | PurchasingContractDeletionCode | |||
| PurchaseRequisition | PurchaseRequisition | |||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| PartialInvoiceDistribution | PartialInvoiceDistribution | |||
| ManufacturerPartNmbr | ManufacturerPartNmbr | |||
| Manufacturer | Manufacturer | |||
| PurContractItmReplnmtElmntType | PurContractItmReplnmtElmntType | |||
| PurchasingCategory | PurchasingCategory | |||
| PurgCatName | PurgCatName | |||
| PurchaseContractType | PurchaseContractType | |||
| PurchasingOrganization | PurchasingOrganization | |||
| PurchasingGroup | PurchasingGroup | |||
| PurgProdCmplncSupplierStatus | PurgProdCmplncSupplierStatus | |||
| PurchasingIsCatalogRelevant | PurchasingIsCatalogRelevant | |||
| LastChangeDateTime | _PurchaseContract | LastChangeDateTime | ||
| _PurchaseContract | _PurchaseContract | |||
| _PurCtrAccount | _PurCtrAccount | |||
| _PurCtrAddress | _PurCtrAddress | |||
| _PurCtrItNotes | _PurCtrItNotes | |||
| _PurContrItemCndnValdty | _PurContrItemCndnValdty |
//@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Purchase Contract Item'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey: [ 'PurchaseContract','PurchaseContractItem' ]
@ObjectModel.representativeKey: 'PurchaseContractItem'
@ObjectModel.usageType:{
serviceQuality: #B,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
@Metadata.ignorePropagatedAnnotations: true
define view entity R_PurchaseContractItemTP
as select from I_PurchaseContractItem
composition [0..*] of R_PurContrAccountTP as _PurCtrAccount
composition [0..1] of R_PurContrAddressTP as _PurCtrAddress
composition [0..*] of R_PurContrItemNotesTP as _PurCtrItNotes
composition [1..*] of R_PurContrItemCndnValdtyTP as _PurContrItemCndnValdty
association to parent R_PurchaseContractTP as _PurchaseContract on $projection.PurchaseContract = _PurchaseContract.PurchaseContract
----Extension Association
association [1..1] to E_PurchasingDocumentItem as _PurchasingDocumentItem on $projection.PurchaseContract = _PurchasingDocumentItem.PurchasingDocument
and $projection.PurchaseContractItem = _PurchasingDocumentItem.PurchasingDocumentItem
{
@ObjectModel.foreignKey.association: '_PurchaseContract'
key PurchaseContract,
key PurchaseContractItem,
PurchaseContractItemUniqueID,
CompanyCode,
Material,
ManufacturerMaterial,
PurchaseContractItemText,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ContractNetPriceAmount,
OrderPriceUnit,
VolumeUnit,
OrderQuantityUnit,
MaterialGroup,
Customer,
Subcontractor,
ReferenceDeliveryAddressID,
ManualDeliveryAddressID,
DeliveryAddressID,
Plant,
StorageLocation,
AccountAssignmentCategory,
GoodsReceiptIsExpected,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
NetPriceQuantity,
MultipleAcctAssgmtDistribution,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
TargetQuantity,
@Semantics.amount.currencyCode: 'DocumentCurrency'
TargetAmount,
DocumentCurrency,
OrdPriceUnitToOrderUnitDnmntr,
OrderPriceUnitToOrderUnitNmrtr,
PurchasingDocumentItemCategory,
SupplierMaterialNumber,
EvaldRcptSettlmtIsAllowed,
UnderdelivTolrtdLmtRatioInPct,
PriceIsToBePrinted,
SupplierConfirmationControlKey,
OverdelivTolrtdLmtRatioInPct,
UnlimitedOverdeliveryIsAllowed,
IncotermsClassification,
IncotermsLocation1,
InvoiceIsExpected,
InvoiceIsGoodsReceiptBased,
PurgDocPriceDate,
PurchasingInfoRecordUpdateCode,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
PurgDocReleaseOrderQuantity,
PurgDocOrderAcknNumber,
PurgDocEstimatedPrice as PurchasingPriceIsEstimated,
IsInfoAtRegistration,
NoDaysReminder1,
NoDaysReminder2,
NoDaysReminder3,
PlannedDeliveryDurationInDays,
StockType,
TaxCode,
TaxCountry,
TaxDeterminationDate,
RequirementTracking,
IsOrderAcknRqd,
ShippingInstruction,
GoodsReceiptIsNonValuated,
ServicePerformer,
ProductTypeCode,
MaterialType,
PurchaseContractItemFormatted,
PurchasingContractDeletionCode,
cast ( case PurchasingContractDeletionCode
when 'L' then 'X'
else ' '
end as boolean ) as TextIsDeleted,
cast ( case PurchasingContractDeletionCode
when 'S' then 'X'
else ' '
end as boolean ) as OutlineAgrmtItmBlockedText,
PurchaseRequisition,
PurchaseRequisitionItem,
PartialInvoiceDistribution,
ManufacturerPartNmbr,
Manufacturer,
PurContractItmReplnmtElmntType,
PurchasingCategory,
PurgCatName,
PurchaseContractType,
PurchasingOrganization,
PurchasingGroup,
PurgProdCmplncSupplierStatus,
PurchasingIsCatalogRelevant,
@Semantics.systemDateTime.lastChangedAt: true
_PurchaseContract.LastChangeDateTime as LastChangeDateTime,
/* Associations */
_PurchaseContract,
_PurCtrAccount,
_PurCtrAddress,
_PurCtrItNotes,
_PurContrItemCndnValdty
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTITEM",
"R_PURCHASECONTRACTTP"
],
"ASSOCIATED":
[
"R_PURCHASECONTRACTTP",
"R_PURCONTRACCOUNTTP",
"R_PURCONTRADDRESSTP",
"R_PURCONTRITEMCNDNVALDTYTP",
"R_PURCONTRITEMNOTESTP"
],
"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