P_PurchasingDocumentHistory

DDL: P_PURCHASINGDOCUMENTHISTORY SQL: PPURGDOCHIS Type: view BASIC Package: ODATA_MM_PUR_MYPURGDOCITEMS

Purchasing Document history

P_PurchasingDocumentHistory is a Basic CDS View that provides data about "Purchasing Document history" in SAP S/4HANA. It reads from 2 data sources (ekbe, ekbeh) and exposes 24 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber, PurchaseOrderTransactionType, MaterialDocumentYear. Part of development package ODATA_MM_PUR_MYPURGDOCITEMS.

2 data source(s) 24 fields

Data Sources (2)

SourceAliasJoin Type
ekbe ekbe from
ekbeh ekbeh union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPURGDOCHIS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder ebeln
KEY PurchaseOrderItem ebelp
KEY AccountAssignmentNumber zekkn
KEY PurchaseOrderTransactionType vgabe
KEY MaterialDocumentYear gjahr
KEY MaterialDocument belnr
KEY MaterialDocumentItem buzei
PurOrdAmountInCompanyCodeCrcy
PurchaseOrderAmount
InvoiceAmtInCoCodeCrcy reewr
InvoiceAmtInPurOrdTransacCrcy rewrb
DebitCreditCode shkzg
KEY PurchaseOrderItem ebelp
KEY AccountAssignmentNumber zekkn
KEY PurchaseOrderTransactionType vgabe
KEY MaterialDocumentYear gjahr
KEY MaterialDocument belnr
KEY MaterialDocumentItem buzei
PurOrdAmountInCompanyCodeCrcy
PurchaseOrderAmount wrbtr
InvoiceAmtInCoCodeCrcy reewr
InvoiceAmtInPurOrdTransacCrcy rewrb
DebitCreditCode shkzg
Quantity menge 
@AbapCatalog.sqlViewName: 'PPURGDOCHIS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType : #BASIC
@VDM.private: true

define view P_PurchasingDocumentHistory
  as select from ekbe
{
  key ebeln as PurchaseOrder,
  key ebelp as PurchaseOrderItem,
  key zekkn as AccountAssignmentNumber,
  key vgabe as PurchaseOrderTransactionType,
  key gjahr as MaterialDocumentYear,
  key belnr as MaterialDocument,
  key buzei as MaterialDocumentItem,
      cast(dmbtr as abap.curr(21,5)) as PurOrdAmountInCompanyCodeCrcy,
      cast(wrbtr as abap.curr(21,5)) as PurchaseOrderAmount,
      reewr as InvoiceAmtInCoCodeCrcy,
      rewrb as InvoiceAmtInPurOrdTransacCrcy, 
      shkzg as DebitCreditCode, 
      menge as Quantity 
}
where
      belnr != ''
  and vgabe = '2'

union all

select from ekbeh
{
  key ebeln as PurchaseOrder,
  key ebelp as PurchaseOrderItem,
  key zekkn as AccountAssignmentNumber,
  key vgabe as PurchaseOrderTransactionType,
  key gjahr as MaterialDocumentYear,
  key belnr as MaterialDocument,
  key buzei as MaterialDocumentItem,
      cast(dmbtr as abap.curr(21,5)) as PurOrdAmountInCompanyCodeCrcy,
      wrbtr as PurchaseOrderAmount,
      reewr as InvoiceAmtInCoCodeCrcy,
      rewrb as InvoiceAmtInPurOrdTransacCrcy, 
      shkzg as DebitCreditCode, 
      menge as Quantity
}
where
  vgabe = '2';

Learn More