P_PurchasingDocHistory

DDL: P_PURCHASINGDOCHISTORY SQL: PPURGDOCHIST Type: view BASIC

P_PurchasingDocHistory is a Basic CDS View 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 (10)

NameValueLevelField
AbapCatalog.sqlViewName PPURGDOCHIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE 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: 'PPURGDOCHIST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #BASIC
@VDM.private: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_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