I_PURCHASEORDERHISTORYBASIC

CDS View

Purchase Order History

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

Used by 16 CDS view(s) 19 fields

CDS Views using this table (16)

ViewTypeJoinVDMDescription
I_PurchaseOrderHistoryAPI01 view from COMPOSITE Purchase Order History
I_PurchaseOrderProcessFlow view inner COMPOSITE Purchase Order Business Process Flow
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 All Formats - Goods Receipt History
P_CO_DIANInvoiceReceiptHistory view from CONSUMPTION All Formats - Invoice Receipt History
P_GRItm view from CONSUMPTION Goods Receipt document details
P_GRItmOverview view from CONSUMPTION GR Item Overview
P_MngProjDmndPurOrdItmHis view from COMPOSITE Private view for PO item history
P_MX_JournalEntryGRHistory view inner COMPOSITE Journal Entry Goods Receipt History
P_PayReqnPONumber view from COMPOSITE Private view for purchasing order lines
P_PL_SAFTTransferToStock view from COMPOSITE SAFT PT Transfer to Stock
P_POItemIRCalc1 view from CONSUMPTION PO Item Invoice Receipt Calc1
P_RU_ReltdSupplierInvoiceItem1 view from CONSUMPTION Related Supplier Invoice Items from the same Purch Doc-1
P_RU_ReltdSupplierInvoiceItem1 view inner CONSUMPTION Related Supplier Invoice Items from the same Purch Doc-1
P_SrvcOrdFUPPurOrdProcessFlow view inner CONSUMPTION Solution Order Purchase Order Flow

Fields (19)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 2
KEY PurchaseOrder CFinPurchasingDocument,PurchaseOrder 5
KEY PurchaseOrderItem CFinPurchasingDocumentItem,PurchaseOrderItem 3
KEY PurchasingHistoryDocument CentralFinanceSupplierInvoice,PurchasingHistoryDocument,RelatedCFinSupplierInvoice,SubsequentDocument 8
KEY PurchasingHistoryDocumentItem CFinSupplierInvoiceItem,PurchasingHistoryDocumentItem,RelatedCFinSupplierInvoiceItem,SubsequentDocumentItem 4
KEY PurchasingHistoryDocumentYear FiscalYear,MaterialDocumentYear,RelatedFiscalYear 2
_BaseUnitText _BaseUnitText 1
_CompanyCodeCurrencyText _CompanyCodeCurrencyText 1
_CurrencyText _CurrencyText 1
_DebitCreditCodeText _DebitCreditCodeText 1
_DeliveryQuantityUnitText _DeliveryQuantityUnitText 1
_DocumentCurrencyText _DocumentCurrencyText 1
_GoodsMovementTypeText _GoodsMovementTypeText 1
_OrderPriceUnitText _OrderPriceUnitText 1
_OrderQuantityUnitText _OrderQuantityUnitText 1
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,
      
      // Text associations for CustomUI

      history._GoodsMovementTypeText,
      history._CurrencyText,
      history._DebitCreditCodeText,
      history._DeliveryQuantityUnitText,
      history._OrderPriceUnitText,
      history._OrderQuantityUnitText,
      history._BaseUnitText,
      history._DocumentCurrencyText,
      history._CompanyCodeCurrencyText
          
}

where PurchaseOrder.IsEndOfPurposeBlocked = ''

Learn More