I_PurchaseContractItemAPI01
Purchase Contract Item
I_PurchaseContractItemAPI01 is a Composite CDS View that provides data about "Purchase Contract Item" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 69 fields with key fields PurchaseContract, PurchaseContractItem. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurchaseContractItem | I_PurchaseContractItem | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_PurchaseContractAPI01 | _PurchaseContractAPI01 | $projection.PurchaseContract = _PurchaseContractAPI01.PurchaseContract |
| [1..1] | I_PurchasingCategoryMatlGroup | _PurchasingCategoryMatlGroup | $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup |
| [0..1] | E_PurchasingDocumentItem | _ItemExtension | $projection.PurchaseContract = _ItemExtension.PurchasingDocument and $projection.PurchaseContractItem = _ItemExtension.PurchasingDocumentItem |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPURCONTRITEMAPI | view | |
| VDM.viewType | #COMPOSITE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Purchase Contract Item | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view |
Fields (69)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseContract | I_PurchaseContractItem | PurchaseContract | |
| KEY | PurchaseContractItem | I_PurchaseContractItem | PurchaseContractItem | |
| Material | I_PurchaseContractItem | Material | ||
| PurchaseContractItemText | I_PurchaseContractItem | PurchaseContractItemText | ||
| ContractNetPriceAmount | I_PurchaseContractItem | ContractNetPriceAmount | ||
| OrderPriceUnit | I_PurchaseContractItem | OrderPriceUnit | ||
| VolumeUnit | I_PurchaseContractItem | VolumeUnit | ||
| OrderQuantityUnit | I_PurchaseContractItem | OrderQuantityUnit | ||
| MaterialGroup | I_PurchaseContractItem | MaterialGroup | ||
| Customer | I_PurchaseContractItem | Customer | ||
| Subcontractor | I_PurchaseContractItem | Subcontractor | ||
| ReferenceDeliveryAddressID | I_PurchaseContractItem | ReferenceDeliveryAddressID | ||
| ManualDeliveryAddressID | I_PurchaseContractItem | ManualDeliveryAddressID | ||
| DeliveryAddressID | ||||
| DeliveryAddressID_2 | I_PurchaseContractItem | DeliveryAddressID | ||
| Plant | I_PurchaseContractItem | Plant | ||
| StorageLocation | I_PurchaseContractItem | StorageLocation | ||
| AccountAssignmentCategory | I_PurchaseContractItem | AccountAssignmentCategory | ||
| GoodsReceiptIsExpected | I_PurchaseContractItem | GoodsReceiptIsExpected | ||
| NetPriceQuantity | I_PurchaseContractItem | NetPriceQuantity | ||
| MultipleAcctAssgmtDistribution | I_PurchaseContractItem | MultipleAcctAssgmtDistribution | ||
| TargetQuantity | I_PurchaseContractItem | TargetQuantity | ||
| TargetAmount | I_PurchaseContractItem | TargetAmount | ||
| DocumentCurrency | I_PurchaseContractItem | DocumentCurrency | ||
| OrdPriceUnitToOrderUnitDnmntr | I_PurchaseContractItem | OrdPriceUnitToOrderUnitDnmntr | ||
| OrderPriceUnitToOrderUnitNmrtr | I_PurchaseContractItem | OrderPriceUnitToOrderUnitNmrtr | ||
| PurchasingDocumentItemCategory | I_PurchaseContractItem | PurchasingDocumentItemCategory | ||
| SupplierMaterialNumber | I_PurchaseContractItem | SupplierMaterialNumber | ||
| EvaldRcptSettlmtIsAllowed | I_PurchaseContractItem | EvaldRcptSettlmtIsAllowed | ||
| UnderdelivTolrtdLmtRatioInPct | I_PurchaseContractItem | UnderdelivTolrtdLmtRatioInPct | ||
| PriceIsToBePrinted | I_PurchaseContractItem | PriceIsToBePrinted | ||
| SupplierConfirmationControlKey | I_PurchaseContractItem | SupplierConfirmationControlKey | ||
| OverdelivTolrtdLmtRatioInPct | I_PurchaseContractItem | OverdelivTolrtdLmtRatioInPct | ||
| UnlimitedOverdeliveryIsAllowed | I_PurchaseContractItem | UnlimitedOverdeliveryIsAllowed | ||
| InvoiceIsExpected | I_PurchaseContractItem | InvoiceIsExpected | ||
| InvoiceIsGoodsReceiptBased | I_PurchaseContractItem | InvoiceIsGoodsReceiptBased | ||
| PurgDocPriceDate | I_PurchaseContractItem | PurgDocPriceDate | ||
| IsInfoRecordUpdated | I_PurchaseContractItem | IsInfoRecordUpdated | ||
| PurchasingInfoRecordUpdateCode | I_PurchaseContractItem | PurchasingInfoRecordUpdateCode | ||
| PurgDocReleaseOrderQuantity | I_PurchaseContractItem | PurgDocReleaseOrderQuantity | ||
| PurgDocOrderAcknNumber | I_PurchaseContractItem | PurgDocOrderAcknNumber | ||
| PurgDocEstimatedPrice | I_PurchaseContractItem | PurgDocEstimatedPrice | ||
| IsInfoAtRegistration | I_PurchaseContractItem | IsInfoAtRegistration | ||
| NoDaysReminder1 | I_PurchaseContractItem | NoDaysReminder1 | ||
| NoDaysReminder2 | I_PurchaseContractItem | NoDaysReminder2 | ||
| NoDaysReminder3 | I_PurchaseContractItem | NoDaysReminder3 | ||
| StockType | I_PurchaseContractItem | StockType | ||
| TaxCode | I_PurchaseContractItem | TaxCode | ||
| RequirementTracking | I_PurchaseContractItem | RequirementTracking | ||
| IsOrderAcknRqd | I_PurchaseContractItem | IsOrderAcknRqd | ||
| ShippingInstruction | I_PurchaseContractItem | ShippingInstruction | ||
| ShippingType | I_PurchaseContractItem | ShippingType | ||
| GoodsReceiptIsNonValuated | I_PurchaseContractItem | GoodsReceiptIsNonValuated | ||
| ServicePerformer | I_PurchaseContractItem | ServicePerformer | ||
| ProductType | I_PurchaseContractItem | ProductType | ||
| ProductTypeCode | I_PurchaseContractItem | ProductTypeCode | ||
| MaterialType | I_PurchaseContractItem | MaterialType | ||
| FormattedPurchaseContractItem | I_PurchaseContractItem | FormattedPurchaseContractItem | ||
| PurchaseContractItemFormatted | I_PurchaseContractItem | PurchaseContractItemFormatted | ||
| PurchasingContractDeletionCode | I_PurchaseContractItem | PurchasingContractDeletionCode | ||
| PurchaseContractItemUniqueID | I_PurchaseContractItem | PurchaseContractItemUniqueID | ||
| PurchasingParentItem | I_PurchaseContractItem | PurchasingParentItem | ||
| IsStatisticalItem | I_PurchaseContractItem | IsStatisticalItem | ||
| PurgConfigurableItemNumber | I_PurchaseContractItem | PurgConfigurableItemNumber | ||
| PurgDocAggrgdSubitemCategory | I_PurchaseContractItem | PurgDocAggrgdSubitemCategory | ||
| PurgExternalSortNumber | I_PurchaseContractItem | PurgExternalSortNumber | ||
| PurchasingCategory | ||||
| PurgCatName | ||||
| _PurchaseContractAPI01 | _PurchaseContractAPI01 |
@AbapCatalog.sqlViewName: 'IPURCONTRITEMAPI'
@VDM.viewType : #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Purchase Contract Item'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
define view I_PurchaseContractItemAPI01 as select from I_PurchaseContractItem
association [1..1] to I_PurchaseContractAPI01 as _PurchaseContractAPI01 on $projection.PurchaseContract = _PurchaseContractAPI01.PurchaseContract
association [1..1] to I_PurchasingCategoryMatlGroup as _PurchasingCategoryMatlGroup on $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup
association [0..1] to E_PurchasingDocumentItem as _ItemExtension on $projection.PurchaseContract = _ItemExtension.PurchasingDocument
and $projection.PurchaseContractItem = _ItemExtension.PurchasingDocumentItem //3404005
{
key I_PurchaseContractItem.PurchaseContract,
key I_PurchaseContractItem.PurchaseContractItem,
I_PurchaseContractItem.Material,
I_PurchaseContractItem.PurchaseContractItemText,
@Semantics.amount.currencyCode: 'DocumentCurrency'
I_PurchaseContractItem.ContractNetPriceAmount,
I_PurchaseContractItem.OrderPriceUnit,
I_PurchaseContractItem.VolumeUnit,
I_PurchaseContractItem.OrderQuantityUnit,
I_PurchaseContractItem.MaterialGroup,
I_PurchaseContractItem.Customer,
I_PurchaseContractItem.Subcontractor,
I_PurchaseContractItem.ReferenceDeliveryAddressID,
I_PurchaseContractItem.ManualDeliveryAddressID,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'DeliveryAddressID_2'
cast(I_PurchaseContractItem.DeliveryAddressID as contactcardaddress) as DeliveryAddressID,
I_PurchaseContractItem.DeliveryAddressID as DeliveryAddressID_2,
I_PurchaseContractItem.Plant,
I_PurchaseContractItem.StorageLocation,
I_PurchaseContractItem.AccountAssignmentCategory,
I_PurchaseContractItem.GoodsReceiptIsExpected,
@Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
I_PurchaseContractItem.NetPriceQuantity,
I_PurchaseContractItem.MultipleAcctAssgmtDistribution,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
I_PurchaseContractItem.TargetQuantity,
@Semantics.amount.currencyCode: 'DocumentCurrency'
I_PurchaseContractItem.TargetAmount,
I_PurchaseContractItem.DocumentCurrency,
I_PurchaseContractItem.OrdPriceUnitToOrderUnitDnmntr,
I_PurchaseContractItem.OrderPriceUnitToOrderUnitNmrtr,
I_PurchaseContractItem.PurchasingDocumentItemCategory,
I_PurchaseContractItem.SupplierMaterialNumber,
I_PurchaseContractItem.EvaldRcptSettlmtIsAllowed,
I_PurchaseContractItem.UnderdelivTolrtdLmtRatioInPct,
I_PurchaseContractItem.PriceIsToBePrinted,
I_PurchaseContractItem.SupplierConfirmationControlKey,
I_PurchaseContractItem.OverdelivTolrtdLmtRatioInPct,
I_PurchaseContractItem.UnlimitedOverdeliveryIsAllowed,
I_PurchaseContractItem.InvoiceIsExpected,
I_PurchaseContractItem.InvoiceIsGoodsReceiptBased,
I_PurchaseContractItem.PurgDocPriceDate,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'PurchasingInfoRecordUpdateCode'
I_PurchaseContractItem.IsInfoRecordUpdated,
I_PurchaseContractItem.PurchasingInfoRecordUpdateCode,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
I_PurchaseContractItem.PurgDocReleaseOrderQuantity,
I_PurchaseContractItem.PurgDocOrderAcknNumber,
I_PurchaseContractItem.PurgDocEstimatedPrice,
I_PurchaseContractItem.IsInfoAtRegistration,
I_PurchaseContractItem.NoDaysReminder1,
I_PurchaseContractItem.NoDaysReminder2,
I_PurchaseContractItem.NoDaysReminder3,
I_PurchaseContractItem.StockType,
I_PurchaseContractItem.TaxCode,
I_PurchaseContractItem.RequirementTracking,
I_PurchaseContractItem.IsOrderAcknRqd,
I_PurchaseContractItem.ShippingInstruction,
I_PurchaseContractItem.ShippingType,
I_PurchaseContractItem.GoodsReceiptIsNonValuated,
I_PurchaseContractItem.ServicePerformer,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ProductTypeCode'
I_PurchaseContractItem.ProductType,
I_PurchaseContractItem.ProductTypeCode,
I_PurchaseContractItem.MaterialType,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'PurchaseContractItemFormatted'
I_PurchaseContractItem.FormattedPurchaseContractItem,
I_PurchaseContractItem.PurchaseContractItemFormatted,
I_PurchaseContractItem.PurchasingContractDeletionCode,
I_PurchaseContractItem.PurchaseContractItemUniqueID,
//Added for item hierarchy
I_PurchaseContractItem.PurchasingParentItem,
I_PurchaseContractItem.IsStatisticalItem,
I_PurchaseContractItem.PurgConfigurableItemNumber,
I_PurchaseContractItem.PurgDocAggrgdSubitemCategory,
I_PurchaseContractItem.PurgExternalSortNumber,
_PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory,
_PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName,
_PurchaseContractAPI01
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTITEM",
"I_PURCHASINGCATEGORY",
"I_PURCHASINGCATEGORYMATLGROUP"
],
"ASSOCIATED":
[
"E_PURCHASINGDOCUMENTITEM",
"I_PURCHASECONTRACTAPI01",
"I_PURCHASINGCATEGORYMATLGROUP"
],
"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