P_PurchaseContractItem
P_PurchaseContractItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 98 fields with key fields PurchaseContract, PurchaseContractItem. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurchaseContractItem | I_PurchaseContractItem | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_PurchasingCategoryMatlGroup | _PurchasingCategoryMatlGroup | $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PPURCONTRITM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view |
Fields (98)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseContract | PurchaseContract | ||
| KEY | PurchaseContractItem | PurchaseContractItem | ||
| CompanyCode | CompanyCode | |||
| PurchaseContractType | PurchaseContractType | |||
| Material | Material | |||
| 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 | |||
| IsToBeAcceptedAtOrigin | IsToBeAcceptedAtOrigin | |||
| NetPriceQuantity | NetPriceQuantity | |||
| MultipleAcctAssgmtDistribution | MultipleAcctAssgmtDistribution | |||
| PartialInvoiceDistribution | PartialInvoiceDistribution | |||
| TargetQuantity | TargetQuantity | |||
| TargetAmount | TargetAmount | |||
| DocumentCurrency | DocumentCurrency | |||
| OrdPriceUnitToOrderUnitDnmntr | OrdPriceUnitToOrderUnitDnmntr | |||
| OrderPriceUnitToOrderUnitNmrtr | OrderPriceUnitToOrderUnitNmrtr | |||
| PurchasingDocumentItemCategory | PurchasingDocumentItemCategory | |||
| SupplierMaterialNumber | SupplierMaterialNumber | |||
| EvaldRcptSettlmtIsAllowed | EvaldRcptSettlmtIsAllowed | |||
| UnderdelivTolrtdLmtRatioInPct | UnderdelivTolrtdLmtRatioInPct | |||
| PriceIsToBePrinted | PriceIsToBePrinted | |||
| ConfirmationControl | ConfirmationControl | |||
| OverdelivTolrtdLmtRatioInPct | OverdelivTolrtdLmtRatioInPct | |||
| UnlimitedOverdeliveryIsAllowed | UnlimitedOverdeliveryIsAllowed | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| IncotermsLocation2 | IncotermsLocation2 | |||
| IncotermsSupChnLoc1AddlUUID | IncotermsSupChnLoc1AddlUUID | |||
| IncotermsSupChnLoc2AddlUUID | IncotermsSupChnLoc2AddlUUID | |||
| IncotermsSupChnDvtgLocAddlUUID | IncotermsSupChnDvtgLocAddlUUID | |||
| InvoiceIsExpected | InvoiceIsExpected | |||
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased | |||
| PurgDocPriceDate | PurgDocPriceDate | |||
| IsInfoRecordUpdated | IsInfoRecordUpdated | |||
| PurchasingInfoRecord | PurchasingInfoRecord | |||
| PurgDocReleaseOrderQuantity | PurgDocReleaseOrderQuantity | |||
| PurgDocOrderAcknNumber | PurgDocOrderAcknNumber | |||
| PurgDocEstimatedPrice | 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 | |||
| ProductType | ProductType | |||
| MaterialType | MaterialType | |||
| FormattedPurchaseContractItem | FormattedPurchaseContractItem | |||
| PurchasingContractDeletionCode | PurchasingContractDeletionCode | |||
| PurchaseRequisition | PurchaseRequisition | |||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| PurchasingCategory | ||||
| PurgCatName | ||||
| PurchasingParentItem | PurchasingParentItem | |||
| IsStatisticalItem | IsStatisticalItem | |||
| IsActiveEntity | ||||
| PurgConfigurableItemNumber | PurgConfigurableItemNumber | |||
| PurgDocAggrgdSubitemCategory | PurgDocAggrgdSubitemCategory | |||
| PurgExternalSortNumber | PurgExternalSortNumber | |||
| PurContractItmReplnmtElmntType | PurContractItmReplnmtElmntType | |||
| PurgProdCmplncSupplierStatus | PurgProdCmplncSupplierStatus | |||
| PurgProductMarketabilityStatus | PurgProductMarketabilityStatus | |||
| PurgSafetyDataSheetStatus | PurgSafetyDataSheetStatus | |||
| PurgProdCmplncDngrsGoodsStatus | PurgProdCmplncDngrsGoodsStatus | |||
| Associations_PurchaseContract | ||||
| _PurCtrAccount | _PurCtrAccount | |||
| _PurCtrAddress | _PurCtrAddress | |||
| _Purctritnotes | _Purctritnotes | |||
| _PurCtrCndItem | _PurCtrCndItem | |||
| _PurchaseContractHistory | _PurchaseContractHistory | |||
| _MaterialGroup | _MaterialGroup | |||
| _Plant | _Plant | |||
| _StorageLocation | _StorageLocation | |||
| _Material | _Material | |||
| _OrderQuantityUnit | _OrderQuantityUnit | |||
| _VolumeUnit | _VolumeUnit | |||
| _OrderPriceUnit | _OrderPriceUnit | |||
| _DocumentCurrency | _DocumentCurrency |
@AbapCatalog.sqlViewName: 'PPURCONTRITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.semanticKey:['PurchaseContract', 'PurchasecontractItem']
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_PurchaseContractItem
as select from I_PurchaseContractItem
association [1..1] to I_PurchasingCategoryMatlGroup as _PurchasingCategoryMatlGroup on $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup
{
key PurchaseContract,
key PurchaseContractItem,
CompanyCode,
PurchaseContractType,
Material,
PurchaseContractItemText,
ContractNetPriceAmount,
OrderPriceUnit,
VolumeUnit,
OrderQuantityUnit,
MaterialGroup,
Customer,
Subcontractor,
ReferenceDeliveryAddressID,
ManualDeliveryAddressID,
DeliveryAddressID,
Plant,
StorageLocation,
AccountAssignmentCategory,
GoodsReceiptIsExpected,
IsToBeAcceptedAtOrigin,
NetPriceQuantity,
MultipleAcctAssgmtDistribution,
PartialInvoiceDistribution,
TargetQuantity,
TargetAmount,
DocumentCurrency,
OrdPriceUnitToOrderUnitDnmntr, // price conversion from
OrderPriceUnitToOrderUnitNmrtr, // price conversion to
PurchasingDocumentItemCategory,
SupplierMaterialNumber,
EvaldRcptSettlmtIsAllowed,
UnderdelivTolrtdLmtRatioInPct,
PriceIsToBePrinted,
ConfirmationControl,
//SupplierConfirmationControlKey,
OverdelivTolrtdLmtRatioInPct,
UnlimitedOverdeliveryIsAllowed,
IncotermsClassification,
IncotermsLocation1,
IncotermsLocation2,
IncotermsSupChnLoc1AddlUUID,
IncotermsSupChnLoc2AddlUUID,
IncotermsSupChnDvtgLocAddlUUID,
InvoiceIsExpected,
InvoiceIsGoodsReceiptBased,
PurgDocPriceDate,
IsInfoRecordUpdated,
PurchasingInfoRecord,
PurgDocReleaseOrderQuantity,
PurgDocOrderAcknNumber,
PurgDocEstimatedPrice,
IsInfoAtRegistration,
NoDaysReminder1,
NoDaysReminder2,
NoDaysReminder3,
PlannedDeliveryDurationInDays,
StockType,
TaxCode,
TaxCountry,
TaxDeterminationDate,
RequirementTracking,
IsOrderAcknRqd,
ShippingInstruction,
GoodsReceiptIsNonValuated,
ServicePerformer,
ProductType,
MaterialType,
FormattedPurchaseContractItem,
PurchasingContractDeletionCode,
PurchaseRequisition,
PurchaseRequisitionItem,
@ObjectModel.text.element: ['PurgCatName']
@Consumption.labelElement: 'PurgCatName'
_PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory,
@Semantics.text: true
_PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName,
//Added for complex service hierarchy
PurchasingParentItem,
IsStatisticalItem,
cast( 'X' as sdraft_is_active preserving type ) as IsActiveEntity,
// Additional Fields for hierarchy implementation
PurgConfigurableItemNumber,
PurgDocAggrgdSubitemCategory,
PurgExternalSortNumber,
PurContractItmReplnmtElmntType,
// fields from product compliance
PurgProdCmplncSupplierStatus,
PurgProductMarketabilityStatus,
PurgSafetyDataSheetStatus,
PurgProdCmplncDngrsGoodsStatus,
--- Associations
_PurchaseContract,
_PurCtrAccount,
_PurCtrAddress,
_Purctritnotes,
_PurCtrCndItem,
_PurchaseContractHistory,
_MaterialGroup,
_Plant,
_StorageLocation,
_Material,
_OrderQuantityUnit,
_VolumeUnit,
_OrderPriceUnit,
_DocumentCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTITEM",
"I_PURCHASINGCATEGORY",
"I_PURCHASINGCATEGORYMATLGROUP"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTHISTORY",
"I_PURCHASINGCATEGORYMATLGROUP",
"I_PURCTRACCOUNT",
"I_PURCTRADDRESS",
"I_PURCTRCNDITEM",
"I_PURCTRITNOTES",
"I_STORAGELOCATION",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_PURCHASECONTRACTITEM"
],
"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