C_PurchaseOrderItemSolution

DDL: C_PURCHASEORDERITEMSOLUTION SQL: CPURCHORDTEMSOL Type: view CONSUMPTION

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)

SourceAliasJoin Type
I_PurchaseOrderItem PurchaseOrderItem from

Associations (3)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/