I_PURCHASEORDERHISTORYBASIC

CDS View

Purchase Order History

I_PURCHASEORDERHISTORYBASIC is a CDS View in S/4HANA. Purchase Order History. It contains 10 fields. 19 CDS views read from this table.

Used by 19 CDS view(s) 10 fields

CDS Views using this table (19)

ViewTypeJoinVDMDescription
I_PPS_PurOrdItmDocHistC view_entity from COMPOSITE PPS Pur Ord Item Document History - Cube
I_PurchaseOrderHistoryAPI01 view from COMPOSITE Purchase Order History
I_PurchaseOrderProcessFlow view inner COMPOSITE Purchase Order Business Process Flow
P_BSQPMPurOrdToSuplrInvc view_entity from COMPOSITE Purchase Order to Supplier Invoice
P_BUSSOLNORDSLSORDFLWLVL13 view inner CONSUMPTION Solution Order Sales Order Flow Level 13
P_BUSSOLNORDSLSORDFLWLVL14 view inner CONSUMPTION Solution Order Sales Order Flow Level 14
P_CO_DIANGoodsReceiptHistory view from CONSUMPTION
P_CO_DIANInvoiceReceiptHistory view from CONSUMPTION
P_GRItm view from CONSUMPTION Goods Receipt document details
P_GRItmOverview view from CONSUMPTION GR Item Overview
P_MngProjDmndPurOrdItmHis view from COMPOSITE
P_MX_JournalEntryGRHistory view inner COMPOSITE
P_PayReqnPONumber view from COMPOSITE
P_PL_SAFTTransferToStock view from COMPOSITE
P_POItemIRCalc1 view from CONSUMPTION PO Item Invoice Receipt Calc1
P_RU_ReltdSupplierInvoiceItem1 view from CONSUMPTION
P_RU_ReltdSupplierInvoiceItem1 view inner CONSUMPTION
P_SrvcOrdFUPPurOrdProcessFlow view inner CONSUMPTION Solution Order Purchase Requisition Flow
R_PPS_PurOrdDocumentHistory view_entity from TRANSACTIONAL Purchase Order Document History

Fields (10)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 2
KEY PurchaseOrder CFinPurchasingDocument,PrecedingDocument,PurchaseOrder 6
KEY PurchaseOrderItem CFinPurchasingDocumentItem,PurchaseOrderItem 3
KEY PurchasingHistoryDocument CentralFinanceSupplierInvoice,PurchasingHistoryDocument,RelatedCFinSupplierInvoice,SubsequentDocument 9
KEY PurchasingHistoryDocumentItem CFinSupplierInvoiceItem,PurchasingHistoryDocumentItem,RelatedCFinSupplierInvoiceItem 3
KEY PurchasingHistoryDocumentYear FiscalYear,MaterialDocumentYear,RelatedFiscalYear 3
ExchangeRate ExchangeRate 1
PurchasingHistoryCategory PurchasingHistoryCategory,RelatedPurchHistoryCategory 1
ReferenceDocument ReferenceDocument 3
ReferenceDocumentItem ReferenceDocumentItem 2 
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMMPURORDHIST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Order History'
@VDM.viewType : #COMPOSITE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurchaseOrderHistoryBasic as select from I_PurchasingDocumentHistory as history

       inner join R_PurchaseOrder                        as PurchaseOrder         on  history.PurchasingDocument      = PurchaseOrder.PurchaseOrder
       association [1..1] to R_PurchaseOrder             as _PurchaseOrder        on  history.PurchasingDocument      = _PurchaseOrder.PurchaseOrder
       association [1..1] to R_PurchaseOrderItem         as _PurchaseOrderItem    on  history.PurchasingDocument      = _PurchaseOrderItem.PurchaseOrder
                                                                                  and history.PurchasingDocumentItem  = _PurchaseOrderItem.PurchaseOrderItem

{

  key PurchasingDocument                as PurchaseOrder,

  key PurchasingDocumentItem            as PurchaseOrderItem,

  key AccountAssignmentNumber,

  key PurchasingHistoryDocumentType,

  key PurchasingHistoryDocumentYear,

  key PurchasingHistoryDocument,

  key PurchasingHistoryDocumentItem,

      PurchasingHistoryCategory,

      GoodsMovementType,

      PostingDate,

      Currency,

      DebitCreditCode,

      IsCompletelyDelivered,

      ReferenceDocumentFiscalYear,

      ReferenceDocument,

      ReferenceDocumentItem,

      Material,

      Plant,
      
      RvslOfGoodsReceiptIsAllowed,      
      
      history.PricingDocument,
      
      TaxCode,              

      DocumentDate,
      
      history.CreatedByUser,

      InventoryValuationType,

      DocumentReferenceID,
      @Semantics.unitOfMeasure: true
      DeliveryQuantityUnit,
      
      ManufacturerMaterial,         

      AccountingDocumentCreationDate,
      
      PurgHistDocumentCreationTime,

      Quantity,

      PurOrdAmountInCompanyCodeCrcy,

      PurchaseOrderAmount,

      QtyInPurchaseOrderPriceUnit,
      
      GRIRAcctClrgAmtInCoCodeCrcy,

      GdsRcptBlkdStkQtyInOrdQtyUnit,

      GdsRcptBlkdStkQtyInOrdPrcUnit,

      InvoiceAmtInCoCodeCrcy,
      
      ShipgInstrnSupplierCompliance,      

      InvoiceAmountInFrgnCurrency,

      QuantityInDeliveryQtyUnit,

      GRIRAcctClrgAmtInTransacCrcy,

      QuantityInBaseUnit,
      
      Batch,

      GRIRAcctClrgAmtInOrdTrnsacCrcy,

      InvoiceAmtInPurOrdTransacCrcy,

      VltdGdsRcptBlkdStkQtyInOrdUnit,

      VltdGdsRcptBlkdQtyInOrdPrcUnit,
      
      IsToBeAcceptedAtOrigin,        

      ExchangeRateDifferenceAmount,
      
      history.ExchangeRate,
      
      DeliveryDocument,
      
      DeliveryDocumentItem,

      OrderPriceUnit,
      OrderQuantityUnit as PurchaseOrderQuantityUnit,
      BaseUnit,
      history.DocumentCurrency,
      history.CompanyCodeCurrency,
      
      _PurchaseOrder,
      
      _PurchaseOrderItem
          
}

where PurchaseOrder.IsEndOfPurposeBlocked = ''

Learn More