I_PURCHASINGDOCUMENTHISTORY
Purchasing Document History
I_PURCHASINGDOCUMENTHISTORY is a CDS View in S/4HANA. Purchasing Document History. It contains 43 fields. 10 CDS views read from this table.
CDS Views using this table (10)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IN_STOHistory | view | inner | COMPOSITE | Stock Transport Order History |
| I_PurchaseOrderHistoryBasic | view | from | COMPOSITE | Purchase Order History |
| P_GRIRPurchaseOrderHistory1 | view | from | CONSUMPTION | GR/IR Purchase Order History |
| P_PL_SAFTPOSupplierInvoice | view | from | COMPOSITE | |
| P_POItemHistoryCalc | view | from | CONSUMPTION | |
| P_PurchaseOrderHistCastAmt | view | from | CONSUMPTION | Purchase Order History Cast aMount |
| P_RU_GtdFromPOMM34 | view | inner | COMPOSITE | |
| P_RU_PurchaseOrderHistoryGR | view | from | CONSUMPTION | |
| P_RU_PurchaseOrderHistoryIR | view | from | CONSUMPTION | |
| R_PurgDocGdsReceiptAmountCalc | view | from | COMPOSITE | R view for Goods Receipt Amount |
Fields (43)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountAssignmentNumber | AccountAssignmentNumber | 2 |
| KEY | PurchasingDocumentItem | PurchaseOrderItem,PurchasingDocumentItem | 5 |
| KEY | PurchasingHistoryDocument | MaterialDocument,PurchasingHistoryDocument | 5 |
| KEY | PurchasingHistoryDocumentItem | MaterialDocumentItem,PurchasingHistoryDocumentItem | 4 |
| KEY | PurchasingHistoryDocumentType | PurchasingHistoryDocumentType | 2 |
| KEY | PurchasingHistoryDocumentYear | MaterialDocumentYear,PurchasingHistoryDocumentYear | 4 |
| AccountingDocumentCreationDate | AccountingDocumentCreationDate | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 2 | |
| CreatedByUser | CreatedByUser | 1 | |
| Currency | Currency | 1 | |
| DebitCreditCode | DebitCreditCode | 3 | |
| DeliveryQuantityUnit | DeliveryQuantityUnit | 1 | |
| DocumentCurrency | DocumentCurrency | 1 | |
| DocumentDate | DocumentDate | 3 | |
| DocumentReferenceID | DocumentReferenceID | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| GdsRcptBlkdStkQtyInOrdPrcUnit | GdsRcptBlkdStkQtyInOrdPrcUnit | 1 | |
| GdsRcptBlkdStkQtyInOrdQtyUnit | GdsRcptBlkdStkQtyInOrdQtyUnit | 1 | |
| GoodsMovementType | GoodsMovementType | 1 | |
| GRIRAcctClrgAmtInCoCodeCrcy | GRIRAcctClrgAmtInCoCodeCrcy | 1 | |
| GRIRAcctClrgAmtInOrdTrnsacCrcy | GRIRAcctClrgAmtInOrdTrnsacCrcy | 1 | |
| GRIRAcctClrgAmtInTransacCrcy | GRIRAcctClrgAmtInTransacCrcy | 1 | |
| InventoryValuationType | InventoryValuationType | 1 | |
| InvoiceAmountInFrgnCurrency | InvoiceAmountInFrgnCurrency | 1 | |
| InvoiceAmtInPurOrdTransacCrcy | InvoiceAmtInPurOrdTransacCrcy | 1 | |
| IsCompletelyDelivered | IsCompletelyDelivered | 1 | |
| Material | Material | 1 | |
| Plant | Plant | 3 | |
| PostingDate | PostingDate | 3 | |
| PricingDocument | PricingDocument | 1 | |
| PurchaseOrderAmount | PurchaseOrderAmount | 1 | |
| PurchasingDocument | PurchaseOrder,PurchasingDocument | 4 | |
| PurchasingHistoryCategory | PurchaseOrderHistCategory,PurchasingHistoryCategory | 4 | |
| PurOrdAmountInCompanyCodeCrcy | PurOrdAmountInCompanyCodeCrcy | 1 | |
| QtyInPurchaseOrderPriceUnit | QtyInPurchaseOrderPriceUnit | 1 | |
| Quantity | Quantity | 1 | |
| QuantityInBaseUnit | QuantityInBaseUnit | 1 | |
| QuantityInDeliveryQtyUnit | QuantityInDeliveryQtyUnit | 1 | |
| ReferenceDocument | ReferenceDocument | 3 | |
| ReferenceDocumentFiscalYear | ReferenceDocumentFiscalYear | 2 | |
| ReferenceDocumentItem | ReferenceDocumentItem | 3 | |
| VltdGdsRcptBlkdQtyInOrdPrcUnit | VltdGdsRcptBlkdQtyInOrdPrcUnit | 1 | |
| VltdGdsRcptBlkdStkQtyInOrdUnit | VltdGdsRcptBlkdStkQtyInOrdUnit | 1 |
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMMPURDOCHIST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Purchasing Document History'
@VDM.viewType : #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_PurchasingDocumentHistory
as select from I_PurchasingDocumentHistoryBsc as HistoryBsc
association [1..1] to I_PurchasingDocument as _PurchasingDocument on $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
association [1..1] to I_PurchasingDocumentItem as _PurchasingDocumentItem on $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument
and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem
{
key HistoryBsc.PurchasingDocument,
key HistoryBsc.PurchasingDocumentItem,
key HistoryBsc.AccountAssignmentNumber,
key HistoryBsc.PurchasingHistoryDocumentType,
key HistoryBsc.PurchasingHistoryDocumentYear,
key HistoryBsc.PurchasingHistoryDocument,
key HistoryBsc.PurchasingHistoryDocumentItem,
HistoryBsc.PurchasingHistoryCategory,
HistoryBsc.GoodsMovementType,
HistoryBsc.PostingDate,
@Semantics.currencyCode: true
HistoryBsc.Currency,
HistoryBsc.DebitCreditCode,
HistoryBsc.IsCompletelyDelivered,
HistoryBsc.ReferenceDocumentFiscalYear,
HistoryBsc.InvtryMgmtReferenceDocument as ReferenceDocument,
HistoryBsc.InvtryMgmtRefDocumentItem as ReferenceDocumentItem,
HistoryBsc.Material,
HistoryBsc.Plant,
HistoryBsc.RvslOfGoodsReceiptIsAllowed,
HistoryBsc.PricingDocument,
HistoryBsc.TaxCode,
HistoryBsc.DocumentDate,
HistoryBsc.CreatedByUser,
HistoryBsc.InventoryValuationType,
HistoryBsc.DocumentReferenceID,
@Semantics.unitOfMeasure: true
HistoryBsc.DeliveryQuantityUnit,
HistoryBsc.ManufacturerMaterial,
HistoryBsc.AccountingDocumentCreationDate,
HistoryBsc.PurgHistDocumentCreationTime,
@Semantics.quantity.unitOfMeasure:'OrderQuantityUnit'
HistoryBsc.Quantity,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
HistoryBsc.PurOrdAmountInCompanyCodeCrcy,
@Semantics.amount.currencyCode: 'Currency'
HistoryBsc.PurchaseOrderAmount,
@Semantics.quantity.unitOfMeasure:'OrderPriceUnit'
HistoryBsc.QtyInPurchaseOrderPriceUnit,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
HistoryBsc.GRIRAcctClrgAmtInCoCodeCrcy,
@Semantics.quantity.unitOfMeasure:'OrderQuantityUnit'
HistoryBsc.GdsRcptBlkdStkQtyInOrdQtyUnit,
@Semantics.quantity.unitOfMeasure:'OrderPriceUnit'
HistoryBsc.GdsRcptBlkdStkQtyInOrdPrcUnit,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
HistoryBsc.InvoiceAmtInCoCodeCrcy,
HistoryBsc.ShipgInstrnSupplierCompliance,
@Semantics.amount.currencyCode: 'Currency'
HistoryBsc.InvoiceAmountInFrgnCurrency,
@Semantics.quantity.unitOfMeasure:'DeliveryQuantityUnit'
HistoryBsc.QuantityInDeliveryQtyUnit,
@Semantics.amount.currencyCode: 'Currency'
HistoryBsc.GRIRAcctClrgAmtInTransacCrcy,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
HistoryBsc.QuantityInBaseUnit,
HistoryBsc.Batch,
@Semantics.amount.currencyCode: 'DocumentCurrency'
HistoryBsc.GRIRAcctClrgAmtInOrdTrnsacCrcy,
@Semantics.amount.currencyCode: 'DocumentCurrency'
HistoryBsc.InvoiceAmtInPurOrdTransacCrcy,
@Semantics.quantity.unitOfMeasure:'OrderQuantityUnit'
HistoryBsc.VltdGdsRcptBlkdStkQtyInOrdUnit,
@Semantics.quantity.unitOfMeasure:'OrderPriceUnit'
HistoryBsc.VltdGdsRcptBlkdQtyInOrdPrcUnit,
HistoryBsc.IsToBeAcceptedAtOrigin,
@Semantics.amount.currencyCode: 'Currency'
HistoryBsc.ExchangeRateDifferenceAmount,
HistoryBsc.ExchangeRate,
HistoryBsc.DeliveryDocument,
HistoryBsc.DeliveryDocumentItem,
@Semantics.unitOfMeasure: true
OrderPriceUnit,
@Semantics.unitOfMeasure: true
OrderQuantityUnit,
@Semantics.unitOfMeasure: true
BaseUnit,
@Semantics.currencyCode: true
PurchasingDocumentCurrency as DocumentCurrency,
@Semantics.currencyCode: true
CompanyCodeCurrency
}
where
PurchasingHistoryDocument != ''
union all
select from I_PurgDocRemovedHistory as RemovedHistory
{
key RemovedHistory.PurchasingDocument,
key RemovedHistory.PurchasingDocumentItem,
key RemovedHistory.AccountAssignmentNumber,
key RemovedHistory.PurchasingHistoryDocumentType,
key RemovedHistory.PurchasingHistoryDocumentYear,
key RemovedHistory.PurchasingHistoryDocument,
key RemovedHistory.PurchasingHistoryDocumentItem,
RemovedHistory.PurchasingHistoryCategory,
RemovedHistory.GoodsMovementType,
RemovedHistory.PostingDate,
@Semantics.currencyCode: true
RemovedHistory.Currency,
RemovedHistory.DebitCreditCode,
RemovedHistory.IsCompletelyDelivered,
RemovedHistory.ReferenceDocumentFiscalYear,
RemovedHistory.InvtryMgmtReferenceDocument as ReferenceDocument,
RemovedHistory.InvtryMgmtRefDocumentItem as ReferenceDocumentItem,
RemovedHistory.Material,
RemovedHistory.Plant,
RemovedHistory.RvslOfGoodsReceiptIsAllowed,
RemovedHistory.PricingDocument,
RemovedHistory.TaxCode,
RemovedHistory.DocumentDate,
RemovedHistory.CreatedByUser,
RemovedHistory.InventoryValuationType,
RemovedHistory.DocumentReferenceID,
@Semantics.unitOfMeasure: true
RemovedHistory.DeliveryQuantityUnit,
RemovedHistory.ManufacturerMaterial,
RemovedHistory.AccountingDocumentCreationDate,
RemovedHistory.PurgHistDocumentCreationTime,
@Semantics.quantity.unitOfMeasure:'OrderQuantityUnit'
RemovedHistory.Quantity,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
RemovedHistory.PurOrdAmountInCompanyCodeCrcy,
@Semantics.amount.currencyCode: 'Currency'
RemovedHistory.PurchaseOrderAmount,
@Semantics.quantity.unitOfMeasure:'OrderPriceUnit'
RemovedHistory.QtyInPurchaseOrderPriceUnit,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
RemovedHistory.GRIRAcctClrgAmtInCoCodeCrcy,
@Semantics.quantity.unitOfMeasure:'OrderQuantityUnit'
RemovedHistory.GdsRcptBlkdStkQtyInOrdQtyUnit,
@Semantics.quantity.unitOfMeasure:'OrderPriceUnit'
RemovedHistory.GdsRcptBlkdStkQtyInOrdPrcUnit,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
RemovedHistory.InvoiceAmtInCoCodeCrcy,
RemovedHistory.ShipgInstrnSupplierCompliance,
@Semantics.amount.currencyCode: 'Currency'
RemovedHistory.InvoiceAmountInFrgnCurrency,
@Semantics.quantity.unitOfMeasure:'DeliveryQuantityUnit'
RemovedHistory.QuantityInDeliveryQtyUnit,
@Semantics.amount.currencyCode: 'Currency'
RemovedHistory.GRIRAcctClrgAmtInTransacCrcy,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
RemovedHistory.QuantityInBaseUnit,
RemovedHistory.Batch,
@Semantics.amount.currencyCode: 'DocumentCurrency'
RemovedHistory.GRIRAcctClrgAmtInOrdTrnsacCrcy,
@Semantics.amount.currencyCode: 'DocumentCurrency'
RemovedHistory.InvoiceAmtInPurOrdTransacCrcy,
@Semantics.quantity.unitOfMeasure:'OrderQuantityUnit'
RemovedHistory.VltdGdsRcptBlkdStkQtyInOrdUnit,
@Semantics.quantity.unitOfMeasure:'OrderPriceUnit'
RemovedHistory.VltdGdsRcptBlkdQtyInOrdPrcUnit,
RemovedHistory.IsToBeAcceptedAtOrigin,
@Semantics.amount.currencyCode: 'Currency'
RemovedHistory.ExchangeRateDifferenceAmount,
RemovedHistory.ExchangeRate,
RemovedHistory.DeliveryDocument,
RemovedHistory.DeliveryDocumentItem,
@Semantics.unitOfMeasure: true
OrderPriceUnit,
@Semantics.unitOfMeasure: true
OrderQuantityUnit,
@Semantics.unitOfMeasure: true
BaseUnit,
@Semantics.currencyCode: true
PurchasingDocumentCurrency as DocumentCurrency,
@Semantics.currencyCode: true
CompanyCodeCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENTHISTORYBSC",
"I_PURGDOCREMOVEDHISTORY"
],
"ASSOCIATED":
[
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/