Which CDS Views use I_PURCHASEORDERITEM?

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

How many fields does I_PURCHASEORDERITEM have?

I_PURCHASEORDERITEM has 101 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 101 fields. 134 CDS views read from this table.

CDS Views using this table (134)

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_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
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_RequirementTrackingPurOrd	view	from	CONSUMPTION	Purchase Orders by Requirement Tracking
C_SuplrEvalByQuality	view	inner	CONSUMPTION	Supplier Evaluation by Quality
FAC_AUDIT_Z3_PURCHASEORDERITEM	view	from		Purchase Order Item
I_DFS_PurOrdOnPlntStorLocLvl	view_entity	from	COMPOSITE	Ordered Qty on Plant and SLoc Level
I_FldLogsPurOrdItmIDVH	view_entity	from	COMPOSITE	Pur Order Item ID
I_FldLogsPurOrdItmUnqIDVH	view	from	COMPOSITE	Value Help for Pur Order Item Unique ID
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_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_BSQPMPurReqnToPurOrd	view_entity	from		Purchase Requisition to Purchase Order
P_DeliveryCostBasedOnPOItm	view	inner	CONSUMPTION
P_FixedAssetPurchaseOrderOvw	view	from	CONSUMPTION
P_InApprovalPurchaseOrderItem	view	from	CONSUMPTION	In Approval Purchase Order Items
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
P_MngProjDmndPOItem	view	from	COMPOSITE
P_OverdueNotReleased	view	from	CONSUMPTION
P_PDOCITEMWITHOUTACCTASSGMT	view	inner	CONSUMPTION
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
P_POHistoryForInvoice	view	inner	CONSUMPTION
P_POIDeliveryCostGR	view	inner	CONSUMPTION
P_POIDeliveryCostInvoice	view	inner	CONSUMPTION
P_POItemClsdSchdLnCumltvQty	view	inner	CONSUMPTION
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_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
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_PurchaseContractleakage1	view	from	CONSUMPTION	Purchase Contract Leakage 1
P_Purchasecontractleakage3	view	from	CONSUMPTION
P_PurchaseOrderItem	view	from	CONSUMPTION
P_PurchaseOrderItemDateRange	view	from	CONSUMPTION	Purchage Order Item for Date Range
P_PurchaseOrderItemPAI	view	from	CONSUMPTION
P_PurchaseOrderItemPAI_04	view	left_outer	CONSUMPTION
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_PurchaseOrderPriceVariance	view	from	CONSUMPTION
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
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
P_PurOrdItemHistCrcyCnvrsn	view	from	CONSUMPTION	Purchase Order Item History Currency Conversion
P_PurOrdItmAcctAssgmt1	view	from	CONSUMPTION
P_PURORDITMACCTASSGMT2	view	inner	CONSUMPTION
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
P_PurOrdMaintainItemActCalcPrc	view	from	CONSUMPTION
P_PurOrdMaintainItemActive	view	from	CONSUMPTION
P_PurOrdMaintainItemList	view	from	CONSUMPTION
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
P_QltyNotifPurgDocs1	view	from	CONSUMPTION	Supplier Eval by Quality Notification
P_ReqnToOrderCycleTime1	view	inner	CONSUMPTION
P_SlsDocFlfmtProcHierarchyD22	view	from	CONSUMPTION
P_SlsDocFlfmtProcHierarchyD31	view	inner	CONSUMPTION
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_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_PPS_PurOrdItmDelivAddr	view	from	COMPOSITE
R_PurchaseOrderScheduleLine	view	inner	BASIC	Purchase Order Schedule Line
RFM_SCC_STOCKTRANSFER_ORD	view	from		Manage Completeness Data Selection STO

Fields (101)

Key	Field	CDS Fields	Used in Views
KEY	Material	Material	34
KEY	MaterialGroup	MaterialGroup	33
KEY	Plant	Plant,PurOrderItemPlant	48
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,PurchasingDocumentCategory	15
KEY	Subcontractor	Subcontractor	1
	_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	21
	CostCenter	CostCenter	1
	CreatedByUser	CreatedByUser	2
	CreationDate	CreationDate	1
	CreationTime	CreationTime	1
	Customer	Customer	4
	DocumentCurrency	Currency,DocumentCurrency,OriginalCurrency,PurOrdTransactionCurrency	22
	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	3
	IncotermsLocation1	IncotermsLocation1	3
	IncotermsLocation2	IncotermsLocation2	3
	IncotermsTransferLocation	IncotermsTransferLocation	3
	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	2
	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	11
	PurchaseOrderDate	PurchaseOrderDate	2
	PurchaseOrderItemText	MaterialName,PurchaseOrderItemText,PurchasingDocumentItemText	11
	PurchaseOrderItemUniqueID	PurchaseOrderItemUniqueID	1
	PurchaseOrderQuantityUnit	OrderQuantityUnit,PurchaseOrderQuantityUnit	18
	PurchaseOrderType	PurchaseOrderType	2
	PurchaseRequisition	PurchaseRequisition	11
	PurchaseRequisitionItem	PurchaseRequisitionItem	11
	PurchasingDocumentDeletionCode	IsDeleted,IsDeletedItem,PurchasingDocumentDeletionCode	10
	PurchasingGroup	PurchasingGroup	2
	PurchasingInfoRecord	PurchasingInfoRecord,RefPurOrderInfoRecord	6
	PurchasingOrganization	PurchasingOrganization	2
	PurgDocHdrCompanyCode	PurgDocHdrCompanyCode	2
	ReferenceDeliveryAddressID	ReferenceDeliveryAddressID	3
	RequisitionerName	RequisitionerName	2
	ServicePackage	ServicePackage	3
	ServicePerformer	ServicePerformer	15
	StorageLocation	StorageLocation	7
	Supplier	Supplier	2
	SupplierConfirmationControlKey	SupplierConfirmationControlKey	1
	SupplierMaterialNumber	SupplierMaterialNumber	4
	SupplierSubrange	SupplierSubrange	1
	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
@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,
      
      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

      ExpectedOverallLimitAmount,
      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

}
where 
  PurchasingDocumentCategory = 'F' 
  and IsEndOfPurposeBlocked = '' 
  
  
  
  
  
  
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PURCHASINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESS_2",
"I_ALLOCATIONTABLE",
"I_ALLOCATIONTABLEITEM",
"I_BR_CFOPCATEGORY",
"I_BR_MATERIALORIGIN",
"I_BR_MATERIALUSAGE",
"I_BR_NCM",
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_CONSUMPTIONPOSTING",
"I_CURRENCY",
"I_CUSTOMER",
"I_INCOTERMSCLASSIFICATION",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_ORGANIZATIONADDRESS",
"I_PLANT",
"I_PRODUCTTYPECODE",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_PURCHASEORDER",
"I_PURCHASEORDERITEMCALCFIELDS",
"I_PURCHASEREQUISITION",
"I_PURCHASEREQUISITIONITEM",
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURCHASINGINFORECORDAPI01",
"I_PURGDOCUMENTITEMCATEGORY",
"I_PURORDPRICINGELEMENT",
"I_RETAILPROMOTION",
"I_STORAGELOCATION",
"I_SUPPLIER",
"I_UNITOFMEASURE"
],
"BASE":
[
"R_PURCHASINGDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_PURCHASEORDERITEM

CDS Views using this table (134)

Fields (101)

Learn More