I_PURCHASINGDOCUMENTHISTORY
Purchasing Document History
I_PURCHASINGDOCUMENTHISTORY is a CDS View in S/4HANA. Purchasing Document History. It contains 66 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IN_STOHistory | view | inner | COMPOSITE | Stock Transport Order History |
| I_PurchaseOrderHistoryBasic | view | from | COMPOSITE | Purchase Order History |
| I_SchedulingAgreementHistory | view | from | COMPOSITE | Scheduling Agreement History |
| P_GRIRPurchaseOrderHistory1 | view_entity | from | CONSUMPTION | GR/IR Purchase Order History |
| P_PL_SAFTPOSupplierInvoice | view | from | COMPOSITE | SAFT PL Purchase Order Supplier Invoice |
| P_POItemHistoryCalc | view | from | CONSUMPTION | Purchase Order History Calculation |
| P_PurchaseOrderHistCastAmt | view | from | CONSUMPTION | Purchase Order History Cast aMount |
| P_RU_GtdFromPOMM34 | view | inner | COMPOSITE | s |
| P_RU_PurchaseOrderHistoryGR | view | from | CONSUMPTION | FI RU PurchaseOrder History GR |
| P_RU_PurchaseOrderHistoryIR | view | from | CONSUMPTION | FI RU PurchaseOrder History IR |
| R_PurgDocGdsReceiptAmountCalc | view | from | COMPOSITE | R view for Goods Receipt Amount |
Fields (66)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountAssignmentNumber | AccountAssignmentNumber | 3 |
| KEY | PurchasingDocument | PurchaseOrder,PurchasingDocument,SchedulingAgreement | 5 |
| KEY | PurchasingDocumentItem | PurchaseOrderItem,PurchasingDocumentItem,SchedulingAgreementItem | 6 |
| KEY | PurchasingHistoryDocument | MaterialDocument,PurchasingHistoryDocument | 6 |
| KEY | PurchasingHistoryDocumentItem | MaterialDocumentItem,PurchasingHistoryDocumentItem | 5 |
| KEY | PurchasingHistoryDocumentType | PurchaseOrderTransactionType,PurchasingHistoryDocumentType | 3 |
| KEY | PurchasingHistoryDocumentYear | MaterialDocumentYear,PurchasingHistoryDocumentYear | 5 |
| _BaseUnitText | _BaseUnitText | 1 | |
| _CompanyCodeCurrencyText | _CompanyCodeCurrencyText | 1 | |
| _CurrencyText | _CurrencyText | 1 | |
| _DebitCreditCodeText | _DebitCreditCodeText | 1 | |
| _DeliveryQuantityUnitText | _DeliveryQuantityUnitText | 1 | |
| _DocumentCurrencyText | _DocumentCurrencyText | 1 | |
| _GoodsMovementTypeText | _GoodsMovementTypeText | 1 | |
| _OrderPriceUnitText | _OrderPriceUnitText | 1 | |
| _OrderQuantityUnitText | _OrderQuantityUnitText | 1 | |
| AccountingDocumentCreationDate | AccountingDocumentCreationDate | 2 | |
| BaseUnit | BaseUnit | 1 | |
| Batch | Batch | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 2 | |
| CreatedByUser | CreatedByUser | 2 | |
| Currency | Currency | 2 | |
| DebitCreditCode | DebitCreditCode | 4 | |
| DeliveryDocument | DeliveryDocument | 1 | |
| DeliveryDocumentItem | DeliveryDocumentItem | 1 | |
| DeliveryQuantityUnit | DeliveryQuantityUnit | 2 | |
| DocumentCurrency | DocumentCurrency | 1 | |
| DocumentDate | DocumentDate | 4 | |
| DocumentReferenceID | DocumentReferenceID | 2 | |
| ExchangeRate | ExchangeRate | 2 | |
| ExchangeRateDifferenceAmount | ExchangeRateDifferenceAmount | 2 | |
| GdsRcptBlkdStkQtyInOrdPrcUnit | GdsRcptBlkdStkQtyInOrdPrcUnit | 2 | |
| GdsRcptBlkdStkQtyInOrdQtyUnit | GdsRcptBlkdStkQtyInOrdQtyUnit | 2 | |
| GoodsMovementType | GoodsMovementType | 2 | |
| GRIRAcctClrgAmtInCoCodeCrcy | GRIRAcctClrgAmtInCoCodeCrcy | 2 | |
| GRIRAcctClrgAmtInOrdTrnsacCrcy | GRIRAcctClrgAmtInOrdTrnsacCrcy | 2 | |
| GRIRAcctClrgAmtInTransacCrcy | GRIRAcctClrgAmtInTransacCrcy | 2 | |
| InventoryValuationType | InventoryValuationType | 2 | |
| InvoiceAmountInFrgnCurrency | InvoiceAmountInFrgnCurrency | 2 | |
| InvoiceAmtInCoCodeCrcy | InvoiceAmtInCoCodeCrcy | 1 | |
| InvoiceAmtInPurOrdTransacCrcy | InvoiceAmtInPurOrdTransacCrcy | 2 | |
| IsCompletelyDelivered | IsCompletelyDelivered | 2 | |
| IsToBeAcceptedAtOrigin | IsToBeAcceptedAtOrigin | 1 | |
| ManufacturerMaterial | ManufacturerMaterial | 1 | |
| Material | Material | 2 | |
| OrderPriceUnit | OrderPriceUnit | 1 | |
| OrderQuantityUnit | OrderQuantityUnit | 1 | |
| Plant | Plant | 4 | |
| PostingDate | PostingDate | 4 | |
| PricingDocument | PricingDocument | 2 | |
| PurchaseOrderAmount | PurchaseOrderAmount | 2 | |
| PurchasingHistoryCategory | PurchaseOrderHistCategory,PurchasingHistoryCategory | 5 | |
| PurgHistDocumentCreationTime | PurgHistDocumentCreationTime | 1 | |
| PurOrdAmountInCompanyCodeCrcy | PurOrdAmountInCompanyCodeCrcy | 2 | |
| QtyInPurchaseOrderPriceUnit | QtyInPurchaseOrderPriceUnit | 2 | |
| Quantity | Quantity | 2 | |
| QuantityInBaseUnit | QuantityInBaseUnit | 2 | |
| QuantityInDeliveryQtyUnit | QuantityInDeliveryQtyUnit | 2 | |
| ReferenceDocument | ReferenceDocument | 4 | |
| ReferenceDocumentFiscalYear | ReferenceDocumentFiscalYear | 3 | |
| ReferenceDocumentItem | ReferenceDocumentItem | 4 | |
| RvslOfGoodsReceiptIsAllowed | RvslOfGoodsReceiptIsAllowed | 1 | |
| ShipgInstrnSupplierCompliance | ShipgInstrnSupplierCompliance | 1 | |
| TaxCode | TaxCode | 1 | |
| VltdGdsRcptBlkdQtyInOrdPrcUnit | VltdGdsRcptBlkdQtyInOrdPrcUnit | 2 | |
| VltdGdsRcptBlkdStkQtyInOrdUnit | VltdGdsRcptBlkdStkQtyInOrdUnit | 2 |
@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,
// Text associations for CustomUI
_GoodsMovementTypeText,
_CurrencyText,
_DebitCreditCodeText,
_DeliveryQuantityUnitText,
_OrderPriceUnitText,
_OrderQuantityUnitText,
_BaseUnitText,
_DocumentCurrencyText,
_CompanyCodeCurrencyText
}
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,
// Text associations for CustomUI
_GoodsMovementTypeText,
_CurrencyText,
_DebitCreditCodeText,
_DeliveryQuantityUnitText,
_OrderPriceUnitText,
_OrderQuantityUnitText,
_BaseUnitText,
_DocumentCurrencyText,
_CompanyCodeCurrencyText
}