P_PURCHASINGDOCHISTORY
Purchase Document History
P_PURCHASINGDOCHISTORY is a CDS View in S/4HANA. Purchase Document History. It contains 8 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FldLogsDocFlwGRAndGIDoc | view_entity | from | COMPOSITE | Field logistics Doc flow GI GR doc |
| P_PurReqnProcFlowGR | view | inner | COMPOSITE | Fetch GR in Pur Reqn Process flow |
| P_PurReqnProcFlowInvc | view | inner | COMPOSITE | Fetch Invoice in Pur Reqn Process flow |
Fields (8)
| Key | Field | CDS Fields | Used 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
}