I_PurchasingDocHistory

DDL: I_PURCHASINGDOCHISTORY SQL: IPURGDOCHIST Type: view BASIC

Purchase Document History

I_PurchasingDocHistory is a Basic CDS View that provides data about "Purchase Document History" in SAP S/4HANA. It reads from 1 data source (ekbe) and exposes 11 fields with key fields PurchasingDocument, PurchasingDocumentItem, PurchaseOrderTransactionType, MaterialDocumentYear, MaterialDocument.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
ekbe ekbe from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPURGDOCHIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Document History view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor P_PurchasingDocHistory view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ebeln
KEY PurchasingDocumentItem ebelp
KEY PurchaseOrderTransactionType vgabe
KEY MaterialDocumentYear gjahr
KEY MaterialDocument belnr
KEY MaterialDocumentItem buzei
ReferenceDocument lfbnr
ReferenceDocumentItem lfpos
GoodsMovementType bwart
FiscalYear lfgja
Quantity menge 
@AbapCatalog.sqlViewName: 'IPURGDOCHIST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Purchase Document History' 
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'P_PurchasingDocHistory'

define view I_PurchasingDocHistory as 
select from ekbe 
{
  key ebeln as PurchasingDocument,
  key ebelp as PurchasingDocumentItem,
  key vgabe as PurchaseOrderTransactionType, 
  key gjahr as MaterialDocumentYear, 
  key belnr as MaterialDocument,
  key buzei as MaterialDocumentItem,
      lfbnr as ReferenceDocument,
      lfpos as ReferenceDocumentItem,
      bwart as GoodsMovementType,     
      lfgja as FiscalYear,
      menge as Quantity 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EKBE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More