P_PURCHASINGDOCHISTORY

CDS View

P_PURCHASINGDOCHISTORY is a CDS View in S/4HANA. It contains 8 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 8 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_FldLogsDocFlwGRAndGIDoc view_entity from COMPOSITE Field logistics Doc flow GI GR doc
P_PurReqnProcFlowGR view inner COMPOSITE
P_PurReqnProcFlowInvc view inner COMPOSITE

Fields (8)

KeyField CDS FieldsUsed in Views
KEY MaterialDocument MaterialDocument,SubsequentDocument 3
KEY MaterialDocumentItem MaterialDocumentItem 1
KEY PurchasingDocument PurchasingDocument 1
KEY PurchasingDocumentItem PurchasingDocumentItem 1
GoodsMovementType GoodsMovementType 1
PurchaseOrderTransactionType PurchaseOrderTransactionType,SubsequentDocumentCategory 3
ReferenceDocument ReferenceDocument 1
ReferenceDocumentItem ReferenceDocumentItem 1 
@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