I_PurchasingDocumentHistory

DDL: I_PURCHASINGDOCUMENTHISTORY SQL: IMMPURDOCHIST Type: view COMPOSITE

Purchasing Document History

I_PurchasingDocumentHistory is a Composite CDS View that provides data about "Purchasing Document History" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentHistoryBsc, I_PurgDocRemovedHistory) and exposes 113 fields with key fields PurchasingDocument, PurchasingDocumentItem, AccountAssignmentNumber, PurchasingHistoryDocumentType, PurchasingHistoryDocumentYear. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentHistoryBsc HistoryBsc from
I_PurgDocRemovedHistory RemovedHistory union_all

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocument _PurchasingDocument $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
[1..1] I_PurchasingDocumentItem _PurchasingDocumentItem $projection.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMMPURDOCHIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchasing Document History view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (113)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentHistoryBsc PurchasingDocument
KEY PurchasingDocumentItem I_PurchasingDocumentHistoryBsc PurchasingDocumentItem
KEY AccountAssignmentNumber I_PurchasingDocumentHistoryBsc AccountAssignmentNumber
KEY PurchasingHistoryDocumentType I_PurchasingDocumentHistoryBsc PurchasingHistoryDocumentType
KEY PurchasingHistoryDocumentYear I_PurchasingDocumentHistoryBsc PurchasingHistoryDocumentYear
KEY PurchasingHistoryDocument I_PurchasingDocumentHistoryBsc PurchasingHistoryDocument
KEY PurchasingHistoryDocumentItem I_PurchasingDocumentHistoryBsc PurchasingHistoryDocumentItem
PurchasingHistoryCategory I_PurchasingDocumentHistoryBsc PurchasingHistoryCategory
GoodsMovementType I_PurchasingDocumentHistoryBsc GoodsMovementType
PostingDate I_PurchasingDocumentHistoryBsc PostingDate
Currency I_PurchasingDocumentHistoryBsc Currency
DebitCreditCode I_PurchasingDocumentHistoryBsc DebitCreditCode
IsCompletelyDelivered I_PurchasingDocumentHistoryBsc IsCompletelyDelivered
ReferenceDocumentFiscalYear I_PurchasingDocumentHistoryBsc ReferenceDocumentFiscalYear
ReferenceDocument I_PurchasingDocumentHistoryBsc InvtryMgmtReferenceDocument
ReferenceDocumentItem I_PurchasingDocumentHistoryBsc InvtryMgmtRefDocumentItem
Material I_PurchasingDocumentHistoryBsc Material
Plant I_PurchasingDocumentHistoryBsc Plant
RvslOfGoodsReceiptIsAllowed I_PurchasingDocumentHistoryBsc RvslOfGoodsReceiptIsAllowed
PricingDocument I_PurchasingDocumentHistoryBsc PricingDocument
TaxCode I_PurchasingDocumentHistoryBsc TaxCode
DocumentDate I_PurchasingDocumentHistoryBsc DocumentDate
CreatedByUser I_PurchasingDocumentHistoryBsc CreatedByUser
InventoryValuationType I_PurchasingDocumentHistoryBsc InventoryValuationType
DocumentReferenceID I_PurchasingDocumentHistoryBsc DocumentReferenceID
DeliveryQuantityUnit I_PurchasingDocumentHistoryBsc DeliveryQuantityUnit
ManufacturerMaterial I_PurchasingDocumentHistoryBsc ManufacturerMaterial
AccountingDocumentCreationDate I_PurchasingDocumentHistoryBsc AccountingDocumentCreationDate
PurgHistDocumentCreationTime I_PurchasingDocumentHistoryBsc PurgHistDocumentCreationTime
Quantity I_PurchasingDocumentHistoryBsc Quantity
PurOrdAmountInCompanyCodeCrcy I_PurchasingDocumentHistoryBsc PurOrdAmountInCompanyCodeCrcy
PurchaseOrderAmount I_PurchasingDocumentHistoryBsc PurchaseOrderAmount
QtyInPurchaseOrderPriceUnit I_PurchasingDocumentHistoryBsc QtyInPurchaseOrderPriceUnit
GRIRAcctClrgAmtInCoCodeCrcy I_PurchasingDocumentHistoryBsc GRIRAcctClrgAmtInCoCodeCrcy
GdsRcptBlkdStkQtyInOrdQtyUnit I_PurchasingDocumentHistoryBsc GdsRcptBlkdStkQtyInOrdQtyUnit
GdsRcptBlkdStkQtyInOrdPrcUnit I_PurchasingDocumentHistoryBsc GdsRcptBlkdStkQtyInOrdPrcUnit
InvoiceAmtInCoCodeCrcy I_PurchasingDocumentHistoryBsc InvoiceAmtInCoCodeCrcy
ShipgInstrnSupplierCompliance I_PurchasingDocumentHistoryBsc ShipgInstrnSupplierCompliance
InvoiceAmountInFrgnCurrency I_PurchasingDocumentHistoryBsc InvoiceAmountInFrgnCurrency
QuantityInDeliveryQtyUnit I_PurchasingDocumentHistoryBsc QuantityInDeliveryQtyUnit
GRIRAcctClrgAmtInTransacCrcy I_PurchasingDocumentHistoryBsc GRIRAcctClrgAmtInTransacCrcy
QuantityInBaseUnit I_PurchasingDocumentHistoryBsc QuantityInBaseUnit
Batch I_PurchasingDocumentHistoryBsc Batch
GRIRAcctClrgAmtInOrdTrnsacCrcy I_PurchasingDocumentHistoryBsc GRIRAcctClrgAmtInOrdTrnsacCrcy
InvoiceAmtInPurOrdTransacCrcy I_PurchasingDocumentHistoryBsc InvoiceAmtInPurOrdTransacCrcy
VltdGdsRcptBlkdStkQtyInOrdUnit I_PurchasingDocumentHistoryBsc VltdGdsRcptBlkdStkQtyInOrdUnit
VltdGdsRcptBlkdQtyInOrdPrcUnit I_PurchasingDocumentHistoryBsc VltdGdsRcptBlkdQtyInOrdPrcUnit
IsToBeAcceptedAtOrigin I_PurchasingDocumentHistoryBsc IsToBeAcceptedAtOrigin
ExchangeRateDifferenceAmount I_PurchasingDocumentHistoryBsc ExchangeRateDifferenceAmount
ExchangeRate I_PurchasingDocumentHistoryBsc ExchangeRate
DeliveryDocument I_PurchasingDocumentHistoryBsc DeliveryDocument
DeliveryDocumentItem I_PurchasingDocumentHistoryBsc DeliveryDocumentItem
OrderPriceUnit OrderPriceUnit
OrderQuantityUnit OrderQuantityUnit
BaseUnit BaseUnit
DocumentCurrency PurchasingDocumentCurrency
PurchasingDocument
KEY PurchasingDocumentItem I_PurgDocRemovedHistory PurchasingDocumentItem
KEY AccountAssignmentNumber I_PurgDocRemovedHistory AccountAssignmentNumber
KEY PurchasingHistoryDocumentType I_PurgDocRemovedHistory PurchasingHistoryDocumentType
KEY PurchasingHistoryDocumentYear I_PurgDocRemovedHistory PurchasingHistoryDocumentYear
KEY PurchasingHistoryDocument I_PurgDocRemovedHistory PurchasingHistoryDocument
KEY PurchasingHistoryDocumentItem I_PurgDocRemovedHistory PurchasingHistoryDocumentItem
PurchasingHistoryCategory I_PurgDocRemovedHistory PurchasingHistoryCategory
GoodsMovementType I_PurgDocRemovedHistory GoodsMovementType
PostingDate I_PurgDocRemovedHistory PostingDate
Currency I_PurgDocRemovedHistory Currency
DebitCreditCode I_PurgDocRemovedHistory DebitCreditCode
IsCompletelyDelivered I_PurgDocRemovedHistory IsCompletelyDelivered
ReferenceDocumentFiscalYear I_PurgDocRemovedHistory ReferenceDocumentFiscalYear
ReferenceDocument I_PurgDocRemovedHistory InvtryMgmtReferenceDocument
ReferenceDocumentItem I_PurgDocRemovedHistory InvtryMgmtRefDocumentItem
Material I_PurgDocRemovedHistory Material
Plant I_PurgDocRemovedHistory Plant
RvslOfGoodsReceiptIsAllowed I_PurgDocRemovedHistory RvslOfGoodsReceiptIsAllowed
PricingDocument I_PurgDocRemovedHistory PricingDocument
TaxCode I_PurgDocRemovedHistory TaxCode
DocumentDate I_PurgDocRemovedHistory DocumentDate
CreatedByUser I_PurgDocRemovedHistory CreatedByUser
InventoryValuationType I_PurgDocRemovedHistory InventoryValuationType
DocumentReferenceID I_PurgDocRemovedHistory DocumentReferenceID
DeliveryQuantityUnit I_PurgDocRemovedHistory DeliveryQuantityUnit
ManufacturerMaterial I_PurgDocRemovedHistory ManufacturerMaterial
AccountingDocumentCreationDate I_PurgDocRemovedHistory AccountingDocumentCreationDate
PurgHistDocumentCreationTime I_PurgDocRemovedHistory PurgHistDocumentCreationTime
Quantity I_PurgDocRemovedHistory Quantity
PurOrdAmountInCompanyCodeCrcy I_PurgDocRemovedHistory PurOrdAmountInCompanyCodeCrcy
PurchaseOrderAmount I_PurgDocRemovedHistory PurchaseOrderAmount
QtyInPurchaseOrderPriceUnit I_PurgDocRemovedHistory QtyInPurchaseOrderPriceUnit
GRIRAcctClrgAmtInCoCodeCrcy I_PurgDocRemovedHistory GRIRAcctClrgAmtInCoCodeCrcy
GdsRcptBlkdStkQtyInOrdQtyUnit I_PurgDocRemovedHistory GdsRcptBlkdStkQtyInOrdQtyUnit
GdsRcptBlkdStkQtyInOrdPrcUnit I_PurgDocRemovedHistory GdsRcptBlkdStkQtyInOrdPrcUnit
InvoiceAmtInCoCodeCrcy I_PurgDocRemovedHistory InvoiceAmtInCoCodeCrcy
ShipgInstrnSupplierCompliance I_PurgDocRemovedHistory ShipgInstrnSupplierCompliance
InvoiceAmountInFrgnCurrency I_PurgDocRemovedHistory InvoiceAmountInFrgnCurrency
QuantityInDeliveryQtyUnit I_PurgDocRemovedHistory QuantityInDeliveryQtyUnit
GRIRAcctClrgAmtInTransacCrcy I_PurgDocRemovedHistory GRIRAcctClrgAmtInTransacCrcy
QuantityInBaseUnit I_PurgDocRemovedHistory QuantityInBaseUnit
Batch I_PurgDocRemovedHistory Batch
GRIRAcctClrgAmtInOrdTrnsacCrcy I_PurgDocRemovedHistory GRIRAcctClrgAmtInOrdTrnsacCrcy
InvoiceAmtInPurOrdTransacCrcy I_PurgDocRemovedHistory InvoiceAmtInPurOrdTransacCrcy
VltdGdsRcptBlkdStkQtyInOrdUnit I_PurgDocRemovedHistory VltdGdsRcptBlkdStkQtyInOrdUnit
VltdGdsRcptBlkdQtyInOrdPrcUnit I_PurgDocRemovedHistory VltdGdsRcptBlkdQtyInOrdPrcUnit
IsToBeAcceptedAtOrigin I_PurgDocRemovedHistory IsToBeAcceptedAtOrigin
ExchangeRateDifferenceAmount I_PurgDocRemovedHistory ExchangeRateDifferenceAmount
ExchangeRate I_PurgDocRemovedHistory ExchangeRate
DeliveryDocument I_PurgDocRemovedHistory DeliveryDocument
DeliveryDocumentItem I_PurgDocRemovedHistory DeliveryDocumentItem
OrderPriceUnit OrderPriceUnit
OrderQuantityUnit OrderQuantityUnit
BaseUnit BaseUnit
DocumentCurrency PurchasingDocumentCurrency
CompanyCodeCurrency CompanyCodeCurrency
@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":""
}
}*/