P_PURCHASINGDOCHISTORY
P_PURCHASINGDOCHISTORY is a CDS View in S/4HANA. 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 | |
| P_PurReqnProcFlowInvc | view | inner | COMPOSITE |
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
}