P_PurchaseOrderItemForCIC

DDL: P_PURCHASEORDERITEMFORCIC Type: view_entity BASIC

P_PurchaseOrderItemForCIC is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocument, I_PurchasingDocumentItem) and exposes 10 fields with key fields PurchaseOrder, PurchaseOrderItem.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocument PurchaseOrder inner
I_PurchasingDocumentItem PurchaseOrderItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchasingDocumentItem PurchasingDocument
KEY PurchaseOrderItem I_PurchasingDocumentItem PurchasingDocumentItem
text I_PurchasingDocumentItem PurchasingDocumentItemText
Product I_PurchasingDocumentItem Material
quantity I_PurchasingDocumentItem OrderQuantity
plant I_PurchasingDocumentItem Plant
aspect_type I_PurchasingDocumentItem PurchasingDocumentItemCategory
ReceivingStorageLocation I_PurchasingDocumentItem StorageLocation
SupplyingStorageLocation I_PurchasingDocumentItem IssuingStorageLocation
SupplyingPlant I_PurchasingDocument SupplyingPlant 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.private: true
@VDM.viewType: #BASIC
define view entity P_PurchaseOrderItemForCIC 
as select from I_PurchasingDocumentItem as PurchaseOrderItem
 inner join  I_PurchasingDocument as PurchaseOrder on PurchaseOrderItem.PurchasingDocument = PurchaseOrder.PurchasingDocument
{
   key PurchaseOrderItem.PurchasingDocument as PurchaseOrder,
   key PurchaseOrderItem.PurchasingDocumentItem as PurchaseOrderItem,
   PurchaseOrderItem.PurchasingDocumentItemText as text, 
   PurchaseOrderItem.Material                   as Product,
   @Semantics.quantity.unitOfMeasure: 'quantity_unit'
   PurchaseOrderItem.OrderQuantity              as quantity,
   PurchaseOrderItem.OrderQuantityUnit          as quantity_unit,    
   PurchaseOrderItem.Plant                      as plant,    
   PurchaseOrderItem.PurchasingDocumentItemCategory as aspect_type,
   PurchaseOrderItem.IsCompletelyDelivered          as complete_indicator,
   PurchaseOrderItem.IsReturnsItem                  as return_indicator ,
   PurchaseOrderItem.PurchasingDocumentDeletionCode as deletion_indicator,
   PurchaseOrderItem.Plant  as                      storage_plant,
   PurchaseOrderItem.StorageLocation                as ReceivingStorageLocation,
   PurchaseOrderItem.IssuingStorageLocation         as SupplyingStorageLocation,
   PurchaseOrderItem.OrderItemQtyToBaseQtyNmrtr     as quantity_numerator,
   PurchaseOrderItem.OrderItemQtyToBaseQtyDnmntr    as quantity_denominator,
   PurchaseOrder.SupplyingPlant
}
//where PurchasingDocumentDeletionCode is initial and

//     ( PurchasingDocumentItemCategory = '3' or PurchasingDocumentItemCategory = '5' or PurchasingDocumentItemCategory = 'A' ) 

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More