I_PurchaseOrderHistoryBasic

DDL: I_PURCHASEORDERHISTORYBASIC SQL: IMMPURORDHIST Type: view COMPOSITE

Purchase Order History

I_PurchaseOrderHistoryBasic is a Composite CDS View that provides data about "Purchase Order History" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentHistory, R_PurchaseOrder) and exposes 59 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber, PurchasingHistoryDocumentType, PurchasingHistoryDocumentYear. It has 2 associations to related views.

2 data source(s) 59 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentHistory history from
R_PurchaseOrder PurchaseOrder inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrder _PurchaseOrder history.PurchasingDocument = _PurchaseOrder.PurchaseOrder
[1..1] R_PurchaseOrderItem _PurchaseOrderItem history.PurchasingDocument = _PurchaseOrderItem.PurchaseOrder and history.PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMMPURORDHIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Order History view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchasingDocument
KEY PurchaseOrderItem PurchasingDocumentItem
KEY AccountAssignmentNumber AccountAssignmentNumber
KEY PurchasingHistoryDocumentType PurchasingHistoryDocumentType
KEY PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear
KEY PurchasingHistoryDocument PurchasingHistoryDocument
KEY PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem
PurchasingHistoryCategory PurchasingHistoryCategory
GoodsMovementType GoodsMovementType
PostingDate PostingDate
Currency Currency
DebitCreditCode DebitCreditCode
IsCompletelyDelivered IsCompletelyDelivered
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear
ReferenceDocument ReferenceDocument
ReferenceDocumentItem ReferenceDocumentItem
Material Material
Plant Plant
RvslOfGoodsReceiptIsAllowed RvslOfGoodsReceiptIsAllowed
PricingDocument I_PurchasingDocumentHistory PricingDocument
TaxCode TaxCode
DocumentDate DocumentDate
CreatedByUser I_PurchasingDocumentHistory CreatedByUser
InventoryValuationType InventoryValuationType
DocumentReferenceID DocumentReferenceID
DeliveryQuantityUnit DeliveryQuantityUnit
ManufacturerMaterial ManufacturerMaterial
AccountingDocumentCreationDate AccountingDocumentCreationDate
PurgHistDocumentCreationTime PurgHistDocumentCreationTime
Quantity Quantity
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy
PurchaseOrderAmount PurchaseOrderAmount
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit
GRIRAcctClrgAmtInCoCodeCrcy GRIRAcctClrgAmtInCoCodeCrcy
GdsRcptBlkdStkQtyInOrdQtyUnit GdsRcptBlkdStkQtyInOrdQtyUnit
GdsRcptBlkdStkQtyInOrdPrcUnit GdsRcptBlkdStkQtyInOrdPrcUnit
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy
ShipgInstrnSupplierCompliance ShipgInstrnSupplierCompliance
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency
QuantityInDeliveryQtyUnit QuantityInDeliveryQtyUnit
GRIRAcctClrgAmtInTransacCrcy GRIRAcctClrgAmtInTransacCrcy
QuantityInBaseUnit QuantityInBaseUnit
Batch Batch
GRIRAcctClrgAmtInOrdTrnsacCrcy GRIRAcctClrgAmtInOrdTrnsacCrcy
InvoiceAmtInPurOrdTransacCrcy InvoiceAmtInPurOrdTransacCrcy
VltdGdsRcptBlkdStkQtyInOrdUnit VltdGdsRcptBlkdStkQtyInOrdUnit
VltdGdsRcptBlkdQtyInOrdPrcUnit VltdGdsRcptBlkdQtyInOrdPrcUnit
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin
ExchangeRateDifferenceAmount ExchangeRateDifferenceAmount
ExchangeRate I_PurchasingDocumentHistory ExchangeRate
DeliveryDocument DeliveryDocument
DeliveryDocumentItem DeliveryDocumentItem
OrderPriceUnit OrderPriceUnit
PurchaseOrderQuantityUnit OrderQuantityUnit
BaseUnit BaseUnit
DocumentCurrency I_PurchasingDocumentHistory DocumentCurrency
CompanyCodeCurrency I_PurchasingDocumentHistory CompanyCodeCurrency
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem 
@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