Which CDS Views use I_PURCHASEORDERITEM?

I_PURCHASEORDERITEM is used by 140 CDS view(s), including: C_APProcessFlowPoItem, C_ChgImpactPurOrdItem, C_InApprovalPurchaseOrderItem, C_MassUpdtPurOrdVH, C_MpPurReqHistoryItem, C_POItemChangeCount, C_POItemCountForSuplrCube, C_POItemInternalOrdStsVislFltr, C_POItemNextDeliveryCalc, C_POItemQtyAndValueCalc.

How many fields does I_PURCHASEORDERITEM have?

I_PURCHASEORDERITEM has 102 fields. Key fields: Material, MaterialGroup, Plant, PurchaseContract, PurchaseContractItem, PurchaseOrder, PurchaseOrderItem, PurchaseOrderItemCategory, Subcontractor.

I_PURCHASEORDERITEM

CDS View

Purchase Order Item

I_PURCHASEORDERITEM is a CDS View in S/4HANA. Purchase Order Item. It contains 102 fields. 140 CDS views read from this table.

CDS Views using this table (140)

View	Type	Join	VDM	Description
C_APProcessFlowPoItem	view	from	CONSUMPTION	AP Process Flow Purchase Order Item
C_ChgImpactPurOrdItem	view	from	CONSUMPTION	Purchase Order Item Details
C_InApprovalPurchaseOrderItem	view	from	CONSUMPTION	In Approval Purchase Order Items
C_MassUpdtPurOrdVH	view	from	CONSUMPTION	Purchase Order Value Help
C_MpPurReqHistoryItem	view	inner	CONSUMPTION	Master Proj Pur Req History Item
C_POItemChangeCount	view	left_outer	CONSUMPTION	Purchase Order Item Changes
C_POItemCountForSuplrCube	view	inner	CONSUMPTION	PO and Item Count for Total Supplier - Cube
C_POItemInternalOrdStsVislFltr	view	from	CONSUMPTION	Internal Ord Status Visual Filter
C_POItemNextDeliveryCalc	view	from	CONSUMPTION	PO Item Next Delivery Calc Fields
C_POItemQtyAndValueCalc	view	from	CONSUMPTION	PO Item Qty and Value Calc Fields
C_Purcatvalhelp	view	from	CONSUMPTION	Purchasing Category Value Help
C_Purchaseorderitemcount	view	from	CONSUMPTION	Count of Purchase Order Item
C_PurchaseOrderItemMassUpdate	view	from	CONSUMPTION	Mass Changes to Purchase Orders
C_PurchaseOrderItemSolution	view	from	CONSUMPTION	Purchase Order Item Solution
C_Purdoclistcalfieldspo	view	from	CONSUMPTION	Calculated Fields for PO
C_PurDocListInvoiceDetails	view	left_outer	CONSUMPTION	Invoice Details
C_Purdoclistpditemstatus	view	from	CONSUMPTION	Purchasing Document Status
C_Purdoclistpoitemstatus	view	from	CONSUMPTION	PO Item Status
c_purdoclistqtymismatchbase	view	inner	CONSUMPTION	Quantity Mismatch Base
C_PurgDataForTimeSheet	view	from	CONSUMPTION	Purchasing Data for Time Sheet
C_PurOrdItmGR	view	from	CONSUMPTION	Purchase Order Item Post Goods Receipt
C_PurOrdItmMntrGRAndInvcCalc	view	from	CONSUMPTION	Pur Ord Item GR and Invc Calc Fields
C_PurOrdItmSts	view	from	CONSUMPTION	Purchase Order Item Status
C_PurOrdRefDocPO	view	from	CONSUMPTION	Reference Documents for PO Creation - Purchase Order Items
C_SuplrEvalByQuality	view	inner	CONSUMPTION	Supplier Evaluation by Quality
FAC_AUDIT_Z3_PURCHASEORDERITEM	view	from		Purchase Order Item
I_FldLogsPurOrdItmIDVH	view_entity	from	COMPOSITE	Pur Order Item ID
I_FldLogsPurOrdItmUnqIDVH	view	from	COMPOSITE	Value Help for Pur Order Item Unique ID
I_KW_PurchaseOrderTotalAmount	view_entity	inner	COMPOSITE	Purchase Order Total Net Amount
I_MstrProjPurOrdItem	view	inner	COMPOSITE	View for Master Project Purchase Order Item
I_MstrProjPurOrdItemSimple	view	inner	COMPOSITE	Simplified PO Items for Master Project
I_PurchaseOrderItemCalcFields	view	from	COMPOSITE	Collection of calculated fields on PO item level
I_PurchaseOrderItemCount	view	from	COMPOSITE	Count of purchase order items
I_PurchaseOrderItemStatus	view	from	COMPOSITE	Purchase Order Item Status
I_PurchaseOrderItemStdVH	view	from	COMPOSITE	Purchase Order Item
I_PurchaseOrderNetAmount	view	from	COMPOSITE	Calculation of net amount on purchase order header level
I_PurOrdAccountAssignment	view	inner	COMPOSITE	Purchase Order Account Assignment
I_PurOrdItemDeliveryAddress	view	from	COMPOSITE	Delivery Address in Purchase Order Item
I_SAFTPurchaseOrderItem	view	from	BASIC	Purchase order item info
I_SAFTPurchaseOrderItem_2	view_entity	from	COMPOSITE	Purchase order item info
I_StockTransportOrderItem	view	from	BASIC	Stock Transport Order Item
P_AlternateSupplierPOSituation	view	from	CONSUMPTION	Alternate Suppliers for a Purchase Order Situation
P_AltSuplrPOItemSituation	view	from	CONSUMPTION	Purchase Order Item for Alternate Supplier Situation
P_BusSolnOrdSrvcOrdFlwLvl22	view	inner	CONSUMPTION	Solution OrderService Order Flow: Level 22
P_DeliveryCostBasedOnPOItm	view	inner	CONSUMPTION	Calcuated IR and GR Amount
P_FixedAssetPurchaseOrderOvw	view	from	CONSUMPTION	Fixed Asset Purchase Order Overview
P_InfoRecordsPurOrdSpend	view	left_outer	CONSUMPTION	Purchase Order Spend from Info Records
P_InspLotPurgOrdDocs	view	inner	CONSUMPTION	Inspectionlot for purchase orders
P_InvoicesCreatedBeforePO	view	inner	CONSUMPTION	Invoices created before Purchase Orders
P_MngProjDmndPOItem	view	from	COMPOSITE	Legacy purchase order items
P_OverdueNotReleased	view	from	CONSUMPTION	P_OverdueNotReleased
P_PDOCITEMWITHOUTACCTASSGMT	view	inner	CONSUMPTION	Purchase Order Item Account Assignment
P_PODOWNPAYTSTSCALCFINAL	view	left_outer	CONSUMPTION	Private View for Status Calculation
P_POHistInDateRange	view	inner	CONSUMPTION	PO History in date range
P_POHistoryForGR	view	inner	CONSUMPTION	PO History for Goods Receipts
P_POHistoryForInvoice	view	inner	CONSUMPTION	PO History for Invoice Receipts
P_POIDeliveryCostGR	view	inner	CONSUMPTION	PO Item Delivery Cost for Goods Receipts
P_POIDeliveryCostInvoice	view	inner	CONSUMPTION	PO Item Delivery Cost for Invoice Receipts
P_POItemClsdSchdLnCumltvQty	view	inner	CONSUMPTION	PO Item Closed Sched Line Cummulative Qty
P_POItemDelivDurnVislFltr	view	from	CONSUMPTION	PO Item Delivery Duration
P_POItemDwnPaytAmountCalc	view	from	CONSUMPTION	Down Payment Calc Fields for PO Item
P_POItemDwnPaytCalc1	view	inner	CONSUMPTION	Down Payment done Calc for PO Item
P_POItemDwnPaytDuDteIntvlCalc1	view	from	CONSUMPTION	Due Date Interval Calc1
P_POItemDwnPaytDueDateInterval	view	from	CONSUMPTION	Due Date Interval for PO Item Dwn Pymt
P_PoItemFiltered	view	from	CONSUMPTION	Filtered PO Item
P_POItemInvoicePrice	view	inner	CONSUMPTION	PO Item for Invoice Price
P_POItemMonitorReqFields	view_entity	from	COMPOSITE	PO Item Monitor Required Fields
P_POItemQtyAndValueCalc	view	from	CONSUMPTION	PO Item Qty and Value Calc field
P_POItemReqFields	view	inner	CONSUMPTION	Legacy PO Items
P_POItmNextDelivStsVislFltr	view	from	CONSUMPTION	Next Delivery Status
P_PROJMGRCATSBYPO	view	left_outer	COMPOSITE	CATS with activiy type derived from PO
P_PRToFirstPurchasOrder	view	inner	CONSUMPTION	First Purchas Order created to a PR
P_PRToFirstPurchasOrder1	view	inner	CONSUMPTION	First Purchase Order created to a PR
P_Purcatvalhelp	view	from	CONSUMPTION	Purchasing Category Value Help
P_PurcContractLeakagePC1	view	from	CONSUMPTION	P_PurcContractLeakagePC1
P_PurchaseContractLeakage	view	from	CONSUMPTION	P_PurchaseContractLeakage
P_PurchaseContractleakage1	view	from	CONSUMPTION	Purchase Contract Leakage 1
P_Purchasecontractleakage3	view	from	CONSUMPTION	Purchase contract leakage 3
P_PurchaseOrderItem	view	from	CONSUMPTION	Puchaser Order Item for change document
P_PurchaseOrderItemAmt	view	from	CONSUMPTION	Purchase Order Item
P_PurchaseOrderItemDateRange	view	from	CONSUMPTION	Purchage Order Item for Date Range
P_PurchaseOrderItemMonitor	view_entity	from	COMPOSITE	Purchase Order Item Monitor
P_PurchaseOrderItemPAI	view	from	CONSUMPTION	P_PurchaseOrderItemPAI
P_PurchaseOrderItemPAI_04	view	left_outer	CONSUMPTION	P_PurchaseOrderItemPAI_04
P_PurchaseOrderItemsImpacted	view	from	CONSUMPTION	Purchase Order Items Impacted
P_PurchaseOrderItemStatus	view	from	CONSUMPTION	Status of a purchase order item
P_PurchaseOrderMassUpdate	view	union	CONSUMPTION	Mass Update of Purchase Orders
P_PurchaseOrderMigration	view	from	CONSUMPTION	Purchase Order for Migration Report
P_PurchaseOrderNetAmountP01	view_entity	inner	CONSUMPTION	Calculate Net Amount of Purchase Order
P_PurchaseOrderPriceVariance	view	from	CONSUMPTION	Purchase Order Price Variance
P_PurchaseOrderQuantity	view	inner	CONSUMPTION	Purchase Order Quantity
P_PURCHASEORDERSENDTOSUPPLR	view	inner	CONSUMPTION	Purchase order send to supplier
P_PURCHASEORDERWITHSTOFILTER	view	inner	CONSUMPTION	Purchase Orders without STO
P_PurchaseRequisitionItm	view	inner	CONSUMPTION	Purchase Requisition Item
P_PurchasingSpndComparison1	view	inner	CONSUMPTION	Purchasing Spend Comparison 1
P_PurchOrdReleased	view	from	CONSUMPTION	Purchase Order Items released
P_PurDocInfoNtwkGraph	view	from	CONSUMPTION	Purchasing Document Information at Network Graph
P_PurDocStat	view	from	CONSUMPTION	PO Item Status
P_PurFutureSpend	view	from	CONSUMPTION	Purchasing Future Spend
P_PurOrdDownPaymentMntr	view	from	CONSUMPTION	Monitor Purchase Order Down Payments
P_PurOrderItemCalculation	view	from	CONSUMPTION	PO Item Calculated fields
P_PurOrderItemCalculation	view	union_all	CONSUMPTION	PO Item Calculated fields
P_PurOrderItemCastedNetAmount	view	from	CONSUMPTION	Purchase Order Item Casted NetAmount
P_PurOrdItemAcctAssgmt	view	from	CONSUMPTION	Purchase Order Item Account Assignment
P_PurOrdItemCastedAmounts	view	inner	CONSUMPTION	Purchase Order Items with Casted amounts
P_PurOrdItemDeliveryAddress	view	from	COMPOSITE	Delivery Address in Purchase Order Item
P_PurOrdItemHistCrcyCnvrsn	view	from	CONSUMPTION	Purchase Order Item History Currency Conversion
P_PurOrdItmAcctAssgmt1	view	from	CONSUMPTION	Purchase Order Item Account Assignment1
P_PURORDITMACCTASSGMT2	view	inner	CONSUMPTION	Purchase Order Item Account Assignment
P_PurOrdItmAcctAssgmtDualStack	view	inner	CONSUMPTION	Purchase order item from Dual stack
P_PurOrdItmCastAmount	view	inner	CONSUMPTION	Purchase Order Items Amount fields cast
P_PurOrdItmOverview	view	from	CONSUMPTION	Purchase Order Item Overview
P_PurOrdItmOvw	view	from	CONSUMPTION	Overview of Purchase Order Items
P_PurOrdItmServiceSpnd	view	from	CONSUMPTION	Purchase Order Item - Service Spend
P_PurOrdItmsForConf	view	from	COMPOSITE	PO items for confirmation
P_PurOrdMaintainItemActCalcPrc	view	from	CONSUMPTION	PO Maintenance: PO Item Calculation Procedures (Active)
P_PurOrdMaintainItemActive	view	from	CONSUMPTION	PO Maintenance: Purchase Order Items (Active)
P_PurOrdMaintainItemList	view	from	CONSUMPTION	Manage Purchase Order: Item List
P_PurOrdNextSchdLn	view	inner	CONSUMPTION	Next Delivery Calculations
P_PurOrdSchedAcct1	view	from	CONSUMPTION	Scheduled Purchase Orders
P_PurOrdServiceInvoice1	view	inner	CONSUMPTION	Purchase Order Service Invoice
P_PurReqnAvgApprvlCrcyConvrsn	view	inner	CONSUMPTION	Purchase requisiton currency conversion
P_PurReqnCurrencyConvrsn	view	inner	CONSUMPTION	Requisition Currency Conversion
P_QltyNotifPurgDocs1	view	from	CONSUMPTION	Supplier Eval by Quality Notification
P_ReqnToOrderCycleTime1	view	inner	CONSUMPTION	Requisition To Order Cycle Time 1
P_RequirementTrackingPurOrd	view_entity	from	CONSUMPTION	P view for Purchase Orders by Requirement Tracking
P_SlsDocFlfmtProcHierarchyD22	view	from	CONSUMPTION	SOF Hierarchy: Number of PO Items
P_SlsDocFlfmtProcHierarchyD31	view	inner	CONSUMPTION	SOF Hierarchy: Purchase Order
P_SrvcOrdFUPPurOrdProcessFlow	view	inner	CONSUMPTION	Solution Order Purchase Order Flow
P_Subcontrg3rdPtyDocsMntr	view	from	CONSUMPTION	P view 3rd Party Purchasing Docs
P_SuplrEvalByQltyNotif2	view	from	CONSUMPTION	PO
P_SuplrEvalByQltyNotif2	view	union_all	CONSUMPTION	PO
P_SupplierMaterialGroupSpend	view	from	CONSUMPTION	Supplier Material Group Spend
P_SupplierPurchasingSpend	view	from	CONSUMPTION	Purchasing Spend for Supplier
P_SustPurchaseOrderItemStorLoc	view_entity	from	CONSUMPTION	Purchase Order Item Storage Locaction Address
P_ThirdPartyAvaily	view	from	CONSUMPTION	Third Party Availability
P_ThirdPartyPurOrdAvaily	view	from	CONSUMPTION	Third Party Pur Ord Availability
P_WrkflwPurchaseOrderItem	view	from	CONSUMPTION	P View of Purchase Order item Workflow
R_PurchaseOrderScheduleLine	view	inner	BASIC	Purchase Order Schedule Line
RFM_SCC_STOCKTRANSFER_ORD	view	from		Manage Completeness Data Selection STO

Fields (102)

Key	Field	CDS Fields	Used in Views
KEY	Material	Material	35
KEY	MaterialGroup	MaterialGroup	33
KEY	Plant	Plant,PurOrderItemPlant	49
KEY	PurchaseContract	PurchaseContract,PurchaseOutlineAgreement,RefPurchaseOutlineAgreement	12
KEY	PurchaseContractItem	PurchaseContractItem,RefPurchOutlineAgrmtItem	9
KEY	PurchaseOrder	ProcessFlowNodeDocument,PurchaseOrder,PurchasingDocument,SubsequentDocument	48
KEY	PurchaseOrderItem	ProcessFlowNodeDocumentItem,PurchaseOrderItem,PurchasingDocumentItem	60
KEY	PurchaseOrderItemCategory	PurchaseOrderItemCategory	14
KEY	Subcontractor	Subcontractor	2
	_CompanyCode	_CompanyCode	1
	_Material	_Material	1
	_MaterialGroup	_MaterialGroup	1
	_Plant	_Plant	3
	_PurchaseRequisition	_PurchaseRequisition	2
	_PurchaseRequisitionItem	_PurchaseRequisitionItem	2
	AccountAssignmentCategory	AccountAssignmentCategory,AcctAssignmentCategory	19
	ArticleCategory	ArticleCategory	1
	BaseUnit	BaseUnit	6
	CommodityCode	CommodityCode	1
	CompanyCode	CompanyCode,ReceivingCompanyCode	22
	CostCenter	CostCenter	1
	CreatedByUser	CreatedByUser	2
	CreationDate	CreationDate	2
	CreationTime	CreationTime	1
	Customer	Customer	4
	DocumentCurrency	Currency,DocumentCurrency,OriginalCurrency,PurOrdTransactionCurrency	25
	DownPaymentDueDate	DownPaymentDueDate	1
	DownPaymentPercentageOfTotAmt	DownPaymentPercentageOfTotAmt	1
	DownPaymentType	DownPaymentType	1
	EarmarkedFunds	EarmarkedFunds	1
	EarmarkedFundsItem	EarmarkedFundsItem	1
	EffectiveAmount	EffectiveAmount,PurOrderEffectiveItemAmount	4
	EvaldRcptSettlmtIsAllowed	EvaldRcptSettlmtIsAllowed	2
	ExpectedOverallLimitAmount	ExpectedOverallLimitAmount	2
	GoodsReceiptIsExpected	GoodsReceiptIsExpected	5
	GoodsReceiptIsNonValuated	GoodsReceiptIsNonValuated	4
	IncotermsClassification	IncotermsClassification,ItemIncotermsClassification	4
	IncotermsLocation1	IncotermsLocation1	4
	IncotermsLocation2	IncotermsLocation2	4
	IncotermsTransferLocation	IncotermsTransferLocation,ItemIncotermsTransferLocation	4
	InternationalArticleNumber	InternationalArticleNumber	2
	IntrastatServiceCode	IntrastatServiceCode	1
	InvoiceIsExpected	InvoiceIsExpected	6
	InvoiceIsGoodsReceiptBased	InvoiceIsGoodsReceiptBased	5
	IsCompletelyDelivered	IsCompletelyDelivered	11
	IsFinallyInvoiced	IsFinallyInvoiced	7
	IsReturnsItem	IsReturnsItem	10
	IsStatisticalItem	IsStatisticalItem,ItemIsStatistical	3
	ItemNetWeight	ItemNetWeight	2
	ItemVolume	ItemVolume	2
	ItemVolumeUnit	ItemVolumeUnit	2
	ItemWeightUnit	ItemWeightUnit	2
	ManualDeliveryAddressID	ManualDeliveryAddressID	1
	Manufacturer	Manufacturer	1
	ManufacturerMaterial	ManufacturerMaterial	4
	ManufacturerPartNmbr	ManufacturerPartNmbr,MfrPartNumber	3
	MaterialType	MaterialType	4
	MultipleAcctAssgmtDistribution	MultipleAcctAssgmtDistribution	9
	NetAmount	NetAmount,netwr,PurchaseOrderNetAmount,PurOrdNetAmount	19
	NetPriceAmount	NetPriceAmount,PurchaseOrderNetPriceAmount	12
	NetPriceQuantity	NetPriceQuantity,PurchaseOrderNetPriceQuantity	13
	OrderItemQtyToBaseQtyDnmntr	OrderItemQtyToBaseQtyDnmntr	6
	OrderItemQtyToBaseQtyNmrtr	OrderItemQtyToBaseQtyNmrtr	6
	OrderPriceUnit	OrderPriceUnit,PurchaseOrderPriceUnit	10
	OrderPriceUnitToOrderUnitNmrtr	OrderPriceUnitToOrderUnitNmrtr	5
	OrderQuantity	menge,OrderQuantity,PurchaseOrderQty,Quantity,TotalQuantity	23
	OrdPriceUnitToOrderUnitDnmntr	OrdPriceUnitToOrderUnitDnmntr	5
	OverallLimitAmount	OverallLimitAmount	2
	OverdelivTolrtdLmtRatioInPct	OverdelivTolrtdLmtRatioInPct	5
	PartialInvoiceDistribution	PartialInvoiceDistribution	2
	PriceIsToBePrinted	PriceIsToBePrinted	2
	PricingDateControl	PricingDateControl	2
	ProductType	ProductType	13
	ProfitCenter	ProfitCenter	3
	PurchaseOrderCategory	PurchaseOrderCategory,PurchasingDocumentCategory	12
	PurchaseOrderDate	PurchaseOrderDate	2
	PurchaseOrderItemText	MaterialName,PurchaseOrderItemText,PurchasingDocumentItemText	11
	PurchaseOrderItemUniqueID	PurchaseOrderItemUniqueID	1
	PurchaseOrderQuantityUnit	OrderQuantityUnit,PurchaseOrderQuantityUnit	19
	PurchaseOrderType	PurchaseOrderType	2
	PurchaseRequisition	PurchaseRequisition	12
	PurchaseRequisitionItem	PurchaseRequisitionItem	12
	PurchasingDocumentDeletionCode	IsDeleted,IsDeletedItem,PurchasingDocumentDeletionCode	11
	PurchasingGroup	PurchasingGroup	2
	PurchasingInfoRecord	PurchasingInfoRecord,RefPurOrderInfoRecord	6
	PurchasingOrganization	PurchasingOrganization	2
	PurgDocHdrCompanyCode	PurgDocHdrCompanyCode	2
	ReferenceDeliveryAddressID	ReferenceDeliveryAddressID	2
	RequisitionerName	RequisitionerName	2
	ServicePackage	ServicePackage	3
	ServicePerformer	ServicePerformer	15
	StorageLocation	StorageLocation	6
	Supplier	Supplier	2
	SupplierConfirmationControlKey	SupplierConfirmationControlKey	1
	SupplierIsSubcontractor	SupplierIsSubcontractor	1
	SupplierMaterialNumber	SupplierMaterialNumber	4
	SupplierSubrange	SupplierSubrange	2
	TaxCode	TaxCode	3
	TaxJurisdiction	TaxJurisdiction	3
	UnderdelivTolrtdLmtRatioInPct	UnderdelivTolrtdLmtRatioInPct	4
	UnlimitedOverdeliveryIsAllowed	UnlimitedOverdeliveryIsAllowed	5
	ValuationType	ValuationType	1

@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Purchase Order Item'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IMMPURCHORDRITEM'
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'PurchaseOrderItem'
@ObjectModel.uniqueIdField: 'PurchaseOrderItemUniqueID'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations:true
@AccessControl.privilegedAssociations:  [ '_ManualDeliveryAddress', '_ReferenceDeliveryAddress', '_ManualDeliveryAddress_2', '_ReferenceDeliveryAddress_2' ]

define view I_PurchaseOrderItem
  as select from R_PurchasingDocumentItem 

  association [1..1] to I_PurchaseOrder               as _PurchaseOrder               on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association [1..*] to I_PurOrdPricingElement        as _PurchaseOrderPricingElement on  $projection.PurchaseOrder     = _PurchaseOrderPricingElement.PurchaseOrder
                                                                                      and $projection.PurchaseOrderItem = _PurchaseOrderPricingElement.PurchaseOrderItem
  association [1..1] to I_PurchaseOrderItemCalcFields as _PurchaseOrderItemCalcFields on  $projection.PurchaseOrder     = _PurchaseOrderItemCalcFields.PurchaseOrder
                                                                                      and $projection.PurchaseOrderItem = _PurchaseOrderItemCalcFields.PurchaseOrderItem
  association [0..1] to I_Material                   as _Material                 on  $projection.Material = _Material.Material
 
{
      //Key

      @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key PurchasingDocument                                     as PurchaseOrder,
  key cast (PurchasingDocumentItem as vdm_purchaseorderitem preserving type) as PurchaseOrderItem,  
      PurchasingDocumentItemUniqueID as PurchaseOrderItemUniqueID,
      
      @ObjectModel.foreignKey.association: '_PurgDocumentCategory'
      PurchasingDocumentCategory                             as PurchaseOrderCategory,

      @Semantics.currencyCode: true
      DocumentCurrency,

      PurchasingDocumentDeletionCode,

      //Product

      @ObjectModel.foreignKey.association: '_MaterialGroup'
      MaterialGroup,

      @ObjectModel.foreignKey.association: '_Material'
      Material,
      MaterialType,
      SupplierMaterialNumber,
      SupplierSubrange,
      ManufacturerPartNmbr,
      Manufacturer,

      @ObjectModel.foreignKey.association: '_ManufacturerMaterial'
      ManufacturerMaterial,

      PurchasingDocumentItemText                             as PurchaseOrderItemText,

      @ObjectModel.foreignKey.association: '_ProductType'
      ProductType,

      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,

      @ObjectModel.foreignKey.association: '_Plant'
      Plant,

      @ObjectModel.foreignKey.association: '_ManualDeliveryAddress'
      ManualDeliveryAddressID,

      @ObjectModel.foreignKey.association: '_ReferenceDeliveryAddress'
      ReferenceDeliveryAddressID,

      @ObjectModel.foreignKey.association: '_Customer'
      Customer,
      
      @ObjectModel.foreignKey.association: '_Subcontractor'
      Subcontractor,
 
      SupplierIsSubcontractor,
            
      @ObjectModel.foreignKey.association: '_ConfigurableProduct'
      CrossPlantConfigurableProduct,
      
      //@ObjectModel.foreignKey.association: '_ProductCategory'

      ArticleCategory,
      
      PlndOrderReplnmtElmntType,
      
      @Semantics.unitOfMeasure: true
      ProductPurchasePointsQtyUnit,
      
      @Semantics.quantity.unitOfMeasure: 'ProductPurchasePointsQtyUnit'
      @DefaultAggregation: #NONE
      ProductPurchasePointsQty,            

      @ObjectModel.foreignKey.association: '_StorageLocation'
      StorageLocation,

      @Semantics.unitOfMeasure:true
      @ObjectModel.foreignKey.association: '_OrderQuantityUnit'
      OrderQuantityUnit                                      as PurchaseOrderQuantityUnit,

      OrderItemQtyToBaseQtyNmrtr,

      OrderItemQtyToBaseQtyDnmntr,

      @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
      NetPriceQuantity,

      IsCompletelyDelivered,

      IsFinallyInvoiced,

      GoodsReceiptIsExpected,
      
      OutwardDeliveryIsComplete, 
      
      InvoiceIsExpected,

      InvoiceIsGoodsReceiptBased,

      @ObjectModel.foreignKey.association: '_PurchaseContractItem'
      PurchaseContractItem,

      @ObjectModel.foreignKey.association: '_PurchaseContract'
      PurchaseContract,

      @ObjectModel.foreignKey.association: '_PurchaseRequisition'
      PurchaseRequisition,
      
      RequirementTracking,
      
      IsOrderAcknRqd,

      @ObjectModel.foreignKey.association: '_PurchaseRequisitionItem'
      PurchaseRequisitionItem,
      
      RequestForQuotation,
      
      RequestForQuotationItem,
      
      SupplierQuotation,
      
      SupplierQuotationItem,

      EvaldRcptSettlmtIsAllowed,

      UnlimitedOverdeliveryIsAllowed,

      OverdelivTolrtdLmtRatioInPct,

      UnderdelivTolrtdLmtRatioInPct,

      RequisitionerName,
      
      MRPArea,
      
      PurchasingDocumentCreationTime                        as CreationTime,
      
      PurchasingDocumentCreationDate                        as CreationDate,
       
      PlannedDeliveryDurationInDays,
      
      GoodsReceiptDurationInDays,
      
      PartialDeliveryIsAllowed,
      
      ConsumptionPosting,

      @ObjectModel.foreignKey.association: '_ServicePerformer'
      ServicePerformer,

      ServicePackage,

      @Semantics.unitOfMeasure: true
      BaseUnit,

      @ObjectModel.foreignKey.association: '_PurgDocumentItemCategory'
      PurchasingDocumentItemCategory                         as PurchaseOrderItemCategory,

      ProfitCenter,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_OrderPriceUnit'
      OrderPriceUnit,

      @Semantics.unitOfMeasure: true
      VolumeUnit                                             as ItemVolumeUnit,

      @Semantics.unitOfMeasure: true
      WeightUnit                                             as ItemWeightUnit,

      MultipleAcctAssgmtDistribution,

      PartialInvoiceDistribution,

      PricingDateControl,

      IsStatisticalItem,
      
      PurchasingParentItem,
      
      GoodsReceiptLatestCreationDate,

      IsReturnsItem,
      
      PurchasingOrderReason,

      @ObjectModel.foreignKey.association: '_IncotermsClassification'
      IncotermsClassification,

      IncotermsTransferLocation,

      IncotermsLocation1,

      IncotermsLocation2,

      @ObjectModel.foreignKey.association: '_PriorSupplier'
      PriorSupplier,

      InternationalArticleNumber,
      
      IntrastatServiceCode,
      
      CommodityCode,
      
      MaterialFreightGroup,
      
      DiscountInKindEligibility,
      
      PurgItemIsBlockedForDelivery,

      //ConfirmationControl,


      SupplierConfirmationControlKey,

      PriceIsToBePrinted,

      AccountAssignmentCategory,

      @ObjectModel.foreignKey.association: '_PurchasingInfoRecord'
      PurchasingInfoRecord,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetAmount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      GrossAmount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      EffectiveAmount,
      
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal1Amount,
     
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal2Amount,
      
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal3Amount,
      
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal4Amount,
      
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal5Amount,
      
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      Subtotal6Amount,

      //    ekpo.ktmng as TargetQuantity,


      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      OrderQuantity,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NetPriceAmount,

      //    ekpo.zwert as OutlineAgreementTargetAmount,


      @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
      ItemVolume,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      ItemGrossWeight,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      ItemNetWeight,

      OrderPriceUnitToOrderUnitNmrtr,

      OrdPriceUnitToOrderUnitDnmntr,

      GoodsReceiptIsNonValuated,

      TaxCode,

      TaxJurisdiction,

      ShippingInstruction,
      
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NonDeductibleInputTaxAmount,
      
      StockType,

      ValuationType,

      ValuationCategory,
      
      ItemIsRejectedBySupplier,
      
      PurgDocPriceDate,
      
      PurchasingInfoRecordUpdateCode                                 as IsInfoRecordUpdated,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'      
      PurgDocReleaseOrderQuantity,
      
      PurgDocOrderAcknNumber,
      
      CostCenter,
      
      GLAccount,
      
      cast (WBSElementInternalID as ps_s4_pspnr preserving type )    as WBSElementInternalID,
      
      Fund,
      
      BudgetPeriod,
      
      FundsCenter,
      
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'CommitmentItemShortID'
      CommitmentItem,
      
      cast( CommitmentItem as fmis_ci_internalname preserving type ) as CommitmentItemShortID,
      
      FunctionalArea,
      
      GrantID,

      EarmarkedFundsDocument                                         as   EarmarkedFunds,
      EarmarkedFundsDocument,
      
      EarmarkedFundsDocumentItem                                     as   EarmarkedFundsItem,
      EarmarkedFundsDocumentItem,
      
      InventorySpecialStockType,
      
      DeliveryDocumentType,
      
      IssuingStorageLocation,
      
      AllocationTable,
      
      AllocationTableItem,
      
      PurgConfigurableItemNumber,
      
      RetailPromotion,

      // Down Payment

      DownPaymentType,
      
      DownPaymentPercentageOfTotAmt,
            
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      DownPaymentAmount,
      
      DownPaymentDueDate,
      
      // S/4 Limit

      @Semantics.amount.currencyCode: 'DocumentCurrency'      
      ExpectedOverallLimitAmount,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      OverallLimitAmount,
      PurContractForOverallLimit,
      
      RequirementSegment,
      
      // Brazil Extension

      @ObjectModel.foreignKey.association: '_BR_MaterialOrigin'
      BR_MaterialOrigin,
      
      @ObjectModel.foreignKey.association: '_BR_MaterialUsage'
      BR_MaterialUsage,
      
      @ObjectModel.foreignKey.association: '_BR_CFOPCategory'
      BR_CFOPCategory,
      
      @ObjectModel.foreignKey.association: '_BR_NCM'
      BR_NCM,
      
      ConsumptionTaxCtrlCode,
      
      BR_IsProducedInHouse,
      
      ThirdPtyOrdProcgExtReference,
      
      ThirdPtyOrdProcgExtRefItem,
      
      PurgDocAggrgdSubitemCategory,
      

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _PurchaseOrderPricingElement,
      _PurchaseOrder,
      _DocumentCurrency,
      _PurchaseOrderItemCalcFields,
      _CompanyCode,
      _Plant,
      _StorageLocation,
      _Material,
      _ManufacturerMaterial,
      _MaterialGroup,
      _OrderPriceUnit,
       @VDM.lifecycle.status: #DEPRECATED
       @VDM.lifecycle.successor: '_ManualDeliveryAddress_2'
      _ManualDeliveryAddress,
      _ManualDeliveryAddress_2,
       @VDM.lifecycle.status: #DEPRECATED
       @VDM.lifecycle.successor: '_ReferenceDeliveryAddress_2'
      _ReferenceDeliveryAddress,
      _ReferenceDeliveryAddress_2,
      _PurgDocumentCategory,
      _PurgDocumentItemCategory,
      _IncotermsClassification,
      _PriorSupplier,
      _ConsumptionPosting,
      //I_PurchasingDocumentItem._ScheduleLine,

      _PurchaseRequisitionItem,
      _PurchasingInfoRecord,
      //I_PurchasingDocumentItem._Manufacturer,

      _Customer,
      _Subcontractor,
      _ConfigurableProduct,
      _PurchaseRequisition,
      _PurchaseContract,
      _PurchaseContractItem,
      _ServicePerformer,
      _OrderQuantityUnit,
      _ProductType,
      _AllocationTable,
      _AllocationTableItem,
      _RetailPromotion,
      
      //Associations for Brazilian specific fields

      _BR_MaterialOrigin,
      _BR_MaterialUsage,
      _BR_CFOPCategory,
      _BR_NCM,
      
      // Text associations for CustomUI

      _OrderQuantityUnitText

}
where 
  PurchasingDocumentCategory = 'F' 
  and IsEndOfPurposeBlocked = ''

Depth:

I_PURCHASEORDERITEM

CDS Views using this table (140)

Fields (102)

Learn More