Which CDS Views use I_PURCHASEORDERHISTORY?

I_PURCHASEORDERHISTORY is used by 48 CDS view(s), including: C_Purdoclistgrquantity, C_Purdoclistgrreference, C_Purdoclistpoitemstatusekbe, C_PurgDocGRSts, C_ServiceEntrySheetProcessFlow, C_ServiceEntrySheetProcessFlow, I_GoodsInvoiceHistory, I_PlantOfGRBlockStock_VH, I_StorLocOfGRBlockStock_VH, P_GetGRPostingDate.

How many fields does I_PURCHASEORDERHISTORY have?

I_PURCHASEORDERHISTORY has 27 fields. Key fields: AccountAssignmentNumber, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear, PurchaseOrder, PurchaseOrderItem, PurchaseOrderTransactionType.

I_PURCHASEORDERHISTORY

CDS View

Purchase Order History

I_PURCHASEORDERHISTORY is a CDS View in S/4HANA. Purchase Order History. It contains 27 fields. 48 CDS views read from this table.

CDS Views using this table (48)

View	Type	Join	VDM	Description
C_Purdoclistgrquantity	view	inner	CONSUMPTION	GR Quantity
C_Purdoclistgrreference	view	inner	CONSUMPTION	GR Reference
C_Purdoclistpoitemstatusekbe	view	from	CONSUMPTION	Helper for PO History in PO Item Status
C_PurgDocGRSts	view	from	CONSUMPTION	Goods Receipt document status
C_ServiceEntrySheetProcessFlow	view	from	CONSUMPTION	Process Flow For Service Entry Sheet
C_ServiceEntrySheetProcessFlow	view	union_all	CONSUMPTION	Process Flow For Service Entry Sheet
I_GoodsInvoiceHistory	view	from	COMPOSITE	Goods Invoice History Data
I_PlantOfGRBlockStock_VH	view	inner	TRANSACTIONAL	Value Help for Plant of GR Blocked Stock
I_StorLocOfGRBlockStock_VH	view	inner	TRANSACTIONAL	Value Help for Storage Location of GR Blocked Stock
P_GetGRPostingDate	view	from	TRANSACTIONAL
P_GRBlockedStockTotal	view	from	TRANSACTIONAL
P_GrInvQtyInd	view	from	CONSUMPTION
P_GRItmOvw	view	from	CONSUMPTION	Overview of Goods Receipt Items
P_HistoryMigration	view	from	CONSUMPTION	PO History for Migration Report
P_InvoicePriceVariance1	view	from	CONSUMPTION
P_MPPurchaseOrder	view	from	COMPOSITE
P_MPSESData	view	from	COMPOSITE
P_POandSAdocs	view	from	CONSUMPTION	Union of PO and SA History
P_POHistInDateRange	view	from	CONSUMPTION	PO History in date range
P_POHistory	view	from	CONSUMPTION	PO History for Invoice Price
P_POHistoryForGR	view	from	CONSUMPTION
P_POHistoryForInvoice	view	from	CONSUMPTION
P_POItemDwnPaytCalc1	view	from	CONSUMPTION	Down Payment done Calc for PO Item
P_POItemGRHistory	view	from	CONSUMPTION
P_PriceAndQuantityVariance	view	from	CONSUMPTION	Price And Quantity Variance
P_PriceVariance4	view	from	CONSUMPTION	Price Variance 4
P_PurchaseOrderHistDetail	view	from	CONSUMPTION	PurchaseOrderHistDetail
P_PurchaseOrderHisTimVar	view	from	CONSUMPTION	Purchase Order History for time Variance
P_PurchaseOrderItemHistory	view	from	CONSUMPTION	Purchase Order Item History
P_PurOrdDeliveredQty	view	inner	CONSUMPTION	Purchase Order Delivered Quantity
P_PurOrdGRAndInvoices	view	from	CONSUMPTION	Purchase Order Item GR and Invoices
P_PurOrdHistDelivCost	view	from	CONSUMPTION	Purchase Order History Delivery Cost
P_PurOrdItemGRAndInvoices	view	from	CONSUMPTION	Purchase Order Item GR and Invoices
P_PurOrdServiceInvoice1	view	from	CONSUMPTION	Purchase Order Service Invoice
P_PurReqTrkGRInv	view	from	CONSUMPTION	GR and Invoices without parameter
P_RU_GtdFromPOMM3	view	from	COMPOSITE
P_RU_GtdFromPOMM4	view	from	COMPOSITE
P_RU_GtdFromPOMM4	view	inner	COMPOSITE
P_RU_MaterialRcptDateMM2	view	from	CONSUMPTION
P_RU_MaterialRcptDateMM3	view	inner	CONSUMPTION
P_RU_MaterialReceiptDateMM2	view	from	COMPOSITE
P_RU_MaterialReceiptDateMM2	view	inner	COMPOSITE
P_RU_MaterialReceiptDateMM3	view	from	COMPOSITE
P_RU_MaterialReceiptDateMM3	view	left_outer	COMPOSITE
P_RU_MaterialReceiptDateMM4	view	left_outer	COMPOSITE
P_RU_MaterialReceiptDateMM5	view	from	COMPOSITE
P_RU_MaterialReceiptDateMM5	view	inner	COMPOSITE
P_SuplrEvalByQltyNotif1	view	from	CONSUMPTION	Supplier Eval By Quality Notification

Fields (27)

Key	Field	CDS Fields	Used in Views
KEY	AccountAssignmentNumber	AccountAssignmentNumber	4
KEY	MaterialDocument	IR_MaterialDocument,MaterialDocument	12
KEY	MaterialDocumentItem	IR_MaterialDocumentItem,MaterialDocumentItem	10
KEY	MaterialDocumentYear	IR_MaterialDocumentYear,MaterialDocumentYear	12
KEY	PurchaseOrder	PurchaseOrder,PurchasingDocument	21
KEY	PurchaseOrderItem	PurchaseOrderItem,PurchasingDocumentItem	16
KEY	PurchaseOrderTransactionType	PurchaseOrderTransactionType	3
	_PurchaseOrderItem	_PurchaseOrderItem	1
	Currency	Currency	3
	DebitCreditCode	DebitCreditCode	3
	DocumentCurrency	Currency	1
	DocumentDate	DocumentDate	3
	GdsRcptBlkdStkQtyInOrdQtyUnit	GdsRcptBlkdStkQtyInOrdQtyUnit	2
	GoodsMovementType	GoodsMovementType	2
	InvoiceAmtInCoCodeCrcy	InvoiceAmtInCoCodeCrcy,PurchaseOrderAmount	2
	InvoiceAmtInPurOrdTransacCrcy	InvoiceAmtInCoCodeCrcy	1
	Material	Material	2
	Plant	Plant	1
	PostingDate	PostingDate	9
	PurchaseOrderAmount	PurchaseOrderAmount,PurOrdAmountInCompanyCodeCrcy	2
	PurchaseOrderHistCategory	IR_PurchaseOrderHistCategory,PurchaseOrderHistCategory	4
	PurchaseOrderQuantityUnit	PurchaseOrderQuantityUnit	1
	PurOrdAmountInCompanyCodeCrcy	PurOrdAmountInCompanyCodeCrcy	1
	Quantity	NetPriceQuantity,Quantity	7
	ReferenceDocument	IR_ReferenceDocument,ReferenceDocument	3
	ReferenceDocumentFiscalYear	IR_ReferenceDocumentFiscalYear,ReferenceDocumentFiscalYear	4
	ReferenceDocumentItem	IR_ReferenceDocumentItem,ReferenceDocumentItem	3

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.sqlViewName: 'IMMPURORDERHIST'
@EndUserText.label: 'Purchase Order History'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_PurchaseOrderHistoryBasic'
//@ObjectModel.representativeKey: 'MaterialDocumentItem'


define view I_PurchaseOrderHistory

  as select from P_PurchaseOrderHistory2 as union_EKBE_EKBEH

  association [1..1] to I_PurchaseOrder             as _PurchaseOrder on union_EKBE_EKBEH.ebeln = _PurchaseOrder.PurchaseOrder

  association [1..1] to I_PurchaseOrderHistCategory as _PurchaseOrderHistCategory on  $projection.PurchaseOrderHistCategory = _PurchaseOrderHistCategory.PurchaseOrderHistCategory
  association [1..1] to I_PurchaseOrderItem         as _PurchaseOrderItem         on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                                  and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem


{
  key cast( union_EKBE_EKBEH.ebeln as vdm_purchaseorder preserving type )       as PurchaseOrder,

  key cast( union_EKBE_EKBEH.ebelp as vdm_purchaseorderitem preserving type )   as PurchaseOrderItem,

  key union_EKBE_EKBEH.zekkn                                  as AccountAssignmentNumber,

  key union_EKBE_EKBEH.vgabe                                  as PurchaseOrderTransactionType,

  key union_EKBE_EKBEH.gjahr                                  as MaterialDocumentYear,

  key union_EKBE_EKBEH.belnr                                  as MaterialDocument,

  key union_EKBE_EKBEH.buzei                                  as MaterialDocumentItem,

      union_EKBE_EKBEH.bewtp                                  as PurchaseOrderHistCategory,

      _PurchaseOrderHistCategory.SubsequentDebitCreditIsAllowed,

      union_EKBE_EKBEH.bwart                                  as GoodsMovementType,

      union_EKBE_EKBEH.budat                                  as PostingDate,

      @Semantics.currencyCode: true
      union_EKBE_EKBEH.waers                                  as Currency,

      union_EKBE_EKBEH.shkzg                                  as DebitCreditCode,

      union_EKBE_EKBEH.elikz                                  as IsCompletelyDelivered,

      union_EKBE_EKBEH.lfgja                                  as ReferenceDocumentFiscalYear,

      union_EKBE_EKBEH.lfbnr                                  as ReferenceDocument,

      union_EKBE_EKBEH.lfpos                                  as ReferenceDocumentItem,

      union_EKBE_EKBEH.matnr                                  as Material,

      union_EKBE_EKBEH.werks                                  as Plant,
      
      union_EKBE_EKBEH.xwsbr                                  as RvslOfGoodsReceiptIsAllowed,      
      
      union_EKBE_EKBEH.knumv                                  as PricingDocument,
      
      union_EKBE_EKBEH.mwskz                                  as TaxCode,              

      union_EKBE_EKBEH.bldat                                  as DocumentDate,

      union_EKBE_EKBEH.bwtar                                  as InventoryValuationType,

      union_EKBE_EKBEH.xblnr                                  as DocumentReferenceID,

      @Semantics.unitOfMeasure: true
      union_EKBE_EKBEH.lsmeh                                  as DeliveryQuantityUnit,
      
      union_EKBE_EKBEH.ematn                                  as ManufacturerMaterial,         

      union_EKBE_EKBEH.cpudt                                  as AccountingDocumentCreationDate,

      @Semantics.quantity.unitOfMeasure:'PurchaseOrderQuantityUnit'
      union_EKBE_EKBEH.menge                                  as Quantity,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      union_EKBE_EKBEH.dmbtr                                  as PurOrdAmountInCompanyCodeCrcy,

      @Semantics.amount.currencyCode: 'Currency'
      union_EKBE_EKBEH.wrbtr                                  as PurchaseOrderAmount,

      @Semantics.quantity.unitOfMeasure:'OrderPriceUnit'
      union_EKBE_EKBEH.bpmng                                  as QtyInPurchaseOrderPriceUnit,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      union_EKBE_EKBEH.arewr                                  as GRIRAcctClrgAmtInCoCodeCrcy,

      @Semantics.quantity.unitOfMeasure:'PurchaseOrderQuantityUnit'
      union_EKBE_EKBEH.wesbs                                  as GdsRcptBlkdStkQtyInOrdQtyUnit,

      @Semantics.quantity.unitOfMeasure:'OrderPriceUnit' 
      union_EKBE_EKBEH.bpwes                                  as GdsRcptBlkdStkQtyInOrdPrcUnit,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency' 
      union_EKBE_EKBEH.reewr                                  as InvoiceAmtInCoCodeCrcy,
      
      union_EKBE_EKBEH.evere                                  as ShipgInstrnSupplierCompliance,      

      @Semantics.amount.currencyCode: 'Currency' 
      union_EKBE_EKBEH.refwr                                  as InvoiceAmountInFrgnCurrency,

      @Semantics.quantity.unitOfMeasure:'DeliveryQuantityUnit'
      union_EKBE_EKBEH.lsmng                                  as QuantityInDeliveryQtyUnit,
      
      @Semantics.amount.currencyCode: 'Currency'  
      union_EKBE_EKBEH.areww                                  as GRIRAcctClrgAmtInTransacCrcy,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      union_EKBE_EKBEH.bamng                                  as QuantityInBaseUnit,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      union_EKBE_EKBEH.arewb                                  as GRIRAcctClrgAmtInOrdTrnsacCrcy,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      union_EKBE_EKBEH.rewrb                                  as InvoiceAmtInPurOrdTransacCrcy,

      @Semantics.quantity.unitOfMeasure:'PurchaseOrderQuantityUnit' 
      union_EKBE_EKBEH.wesbb                                  as VltdGdsRcptBlkdStkQtyInOrdUnit,

      @Semantics.quantity.unitOfMeasure:'OrderPriceUnit'  
      union_EKBE_EKBEH.bpweb                                  as VltdGdsRcptBlkdQtyInOrdPrcUnit,
      
      union_EKBE_EKBEH.weora                                  as IsToBeAcceptedAtOrigin,        

      @Semantics.amount.currencyCode: 'Currency' 
      union_EKBE_EKBEH.kudif                                  as ExchangeRateDifferenceAmount,
      
      cast (union_EKBE_EKBEH.wkurs as fis_exchange_rate)      as ExchangeRate,       
      
      ebeln,
      ebelp,     

      _PurchaseOrderItem,


      _PurchaseOrderHistCategory,
      
      @Semantics.currencyCode: true      
      _PurchaseOrder.DocumentCurrency,
      @Semantics.unitOfMeasure: true      
      _PurchaseOrderItem.OrderPriceUnit,
      @Semantics.unitOfMeasure: true      
      _PurchaseOrderItem.PurchaseOrderQuantityUnit,
      @Semantics.unitOfMeasure: true      
      _PurchaseOrderItem.BaseUnit,
      @Semantics.currencyCode: true      
      _PurchaseOrder._CompanyCode.Currency as CompanyCodeCurrency   

}                                     
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_PURCHASEORDER",
"I_PURCHASEORDERHISTCATEGORY",
"I_PURCHASEORDERITEM",
"P_PURCHASEORDERHISTORY2"
],
"ASSOCIATED":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERHISTCATEGORY",
"I_PURCHASEORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_PURCHASEORDERHISTORY

CDS Views using this table (48)

Fields (27)

Learn More