C_PurchaseOrderItemSolution
Purchase Order Item Solution
C_PurchaseOrderItemSolution is a Consumption CDS View that provides data about "Purchase Order Item Solution" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 28 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurchaseOrderItem | PurchaseOrderItem | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | C_PurchaseOrderSolution | _PurchaseOrder | _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder |
| [0..*] | C_PurOrdAcctAsgmntSolution | _PurOrdAcctAssignment | _PurOrdAcctAssignment.PurchaseOrder = $projection.PurchaseOrder and _PurOrdAcctAssignment.PurchaseOrderItem = $projection.PurchaseOrderItem |
| [0..*] | C_PurOrdSchedLineSolution | _PurchaseOrderScheduleLine | _PurchaseOrderScheduleLine.PurchaseOrder = $projection.PurchaseOrder and _PurchaseOrderScheduleLine.PurchaseOrderItem = $projection.PurchaseOrderItem |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | CPURCHORDTEMSOL | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Purchase Order Item Solution | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | PurchaseOrderItem | view | |
| VDM.viewType | #CONSUMPTION | view |
Fields (28)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | ||
| KEY | PurchaseOrderItem | PurchaseOrderItem | ||
| AccountAssignmentCategory | AccountAssignmentCategory | |||
| PurchaseContract | PurchaseContract | |||
| PurchaseContractItem | PurchaseContractItem | |||
| MaterialGoodsReceiptDuration | ||||
| PurchasingInfoRecord | PurchasingInfoRecord | |||
| PurchaseOrderItemCategory | PurchaseOrderItemCategory | |||
| Material | Material | |||
| ReceivingPlant | ||||
| PurchaseOrderQuantityUnit | PurchaseOrderQuantityUnit | |||
| OrderQuantity | OrderQuantity | |||
| PurchaseRequisition | PurchaseRequisition | |||
| SupplyingStorageLocation | ||||
| ReceivingStorageLocation | ||||
| DocumentCurrency | DocumentCurrency | |||
| _PurchaseOrderPricingElement | _PurchaseOrderPricingElement | |||
| _PurchaseOrder | _PurchaseOrder | |||
| _PurchaseOrderItemCalcFields | _PurchaseOrderItemCalcFields | |||
| _PurOrdAcctAssignment | _PurOrdAcctAssignment | |||
| _PurchaseOrderScheduleLine | _PurchaseOrderScheduleLine | |||
| _Material | _Material | |||
| _PurgDocumentItemCategory | _PurgDocumentItemCategory | |||
| _PurchasingInfoRecord | _PurchasingInfoRecord | |||
| _PurchaseRequisition | _PurchaseRequisition | |||
| _PurchaseContract | _PurchaseContract | |||
| _PurchaseContractItem | _PurchaseContractItem | |||
| _OrderQuantityUnit | _OrderQuantityUnit |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CPURCHORDTEMSOL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Order Item Solution'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'PurchaseOrderItem'
@VDM.viewType: #CONSUMPTION
define view C_PurchaseOrderItemSolution
as select from I_PurchaseOrderItem as PurchaseOrderItem
association [1..1] to C_PurchaseOrderSolution as _PurchaseOrder on _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder
association [0..*] to C_PurOrdAcctAsgmntSolution as _PurOrdAcctAssignment on _PurOrdAcctAssignment.PurchaseOrder = $projection.PurchaseOrder
and _PurOrdAcctAssignment.PurchaseOrderItem = $projection.PurchaseOrderItem
association [0..*] to C_PurOrdSchedLineSolution as _PurchaseOrderScheduleLine on _PurchaseOrderScheduleLine.PurchaseOrder = $projection.PurchaseOrder
and _PurchaseOrderScheduleLine.PurchaseOrderItem = $projection.PurchaseOrderItem
{
@ObjectModel.foreignKey.association: '_PurchaseOrder'
key PurchaseOrder,
key PurchaseOrderItem,
AccountAssignmentCategory,
@ObjectModel.foreignKey.association: '_PurchaseContract'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PurchaseContractStdVH', element: 'PurchaseContract' } } ]
PurchaseContract,
@ObjectModel.foreignKey.association: '_PurchaseContractItem'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PurchaseContractItemStdVH', element: 'PurchaseContractItem' } } ]
PurchaseContractItem,
cast( 0 as pph_webaz ) as MaterialGoodsReceiptDuration,
@ObjectModel.foreignKey.association: '_PurchasingInfoRecord'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PurchasingInfoRecordStdVH', element: 'PurchasingInfoRecord' } } ]
PurchasingInfoRecord,
@ObjectModel.foreignKey.association: '_PurgDocumentItemCategory'
PurchaseOrderItemCategory,
@ObjectModel.foreignKey.association: '_Material'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MaterialStdVH', element: 'Material' } } ]
Material,
cast( '' as werks_d ) as ReceivingPlant,
@Semantics.unitOfMeasure:true
@ObjectModel.foreignKey.association: '_OrderQuantityUnit'
PurchaseOrderQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
@DefaultAggregation: #NONE
OrderQuantity,
@ObjectModel.foreignKey.association: '_PurchaseRequisition'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PurchaserequisitionStdVH', element: 'PurchaseRequisition' } } ]
PurchaseRequisition,
cast( '' as lgort_d ) as SupplyingStorageLocation,
cast( '' as lgort_d ) as ReceivingStorageLocation,
@Semantics.currencyCode: true
DocumentCurrency,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_PurchaseOrderPricingElement,
_PurchaseOrder,
_PurchaseOrderItemCalcFields,
_PurOrdAcctAssignment,
_PurchaseOrderScheduleLine,
_Material,
_PurgDocumentItemCategory,
_PurchasingInfoRecord,
_PurchaseRequisition,
_PurchaseContract,
_PurchaseContractItem,
_OrderQuantityUnit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"C_PURCHASEORDERSOLUTION",
"C_PURORDACCTASGMNTSOLUTION",
"C_PURORDSCHEDLINESOLUTION",
"I_MATERIAL",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_PURCHASEORDERITEMCALCFIELDS",
"I_PURCHASEREQUISITION",
"I_PURCHASINGINFORECORDAPI01",
"I_PURGDOCUMENTITEMCATEGORY",
"I_PURORDPRICINGELEMENT",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_PURCHASEORDERITEM"
],
"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