I_PURCHASINGDOCUMENTHISTORYBSC

CDS View
55 Fields 20 CDS Views

History per Purchasing Document Item

I_PURCHASINGDOCUMENTHISTORYBSC is a CDS View in S/4HANA. History per Purchasing Document Item. It contains 55 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
C_AcctsPyblProcFlwGdsMvtVH view_entity from CONSUMPTION Goods Movement for AP Process Flow
C_PurchaseOrderHistoryDP view_entity from CONSUMPTION Purchase Order History
I_APProcessFlowDocumentVH view union COMPOSITE Document Number
I_PurchasingDocumentHistory view from COMPOSITE Purchasing Document History
I_SrvcEntrShtItmProcessFlow view_entity inner COMPOSITE Process Flow Service Entry Sheet Item
P_APProcFlowPurOrdHistQty view_entity from COMPOSITE Purchase Order History - Quantity
P_AU_PurchaseHistory view_entity from COMPOSITE Australia Purchase History
P_GoodsIssueDataSIT view_entity from COMPOSITE Private View for Goods Issue Data SIT
P_GoodsReceiptDataSIT view_entity from COMPOSITE Private View for Goods Receipt Data SIT
P_GoodsReceiptDataSITLoc view_entity from COMPOSITE Goods Receipt for Stock in Transit
P_GRAmtPerPurgDocumentItem view from CONSUMPTION GR Amount per Purchasing Document Item
P_InvcAmtPerPurgDocItem view from CONSUMPTION Invoice Amount
P_PurchasingDocReceivedQty view_entity from COMPOSITE Calc sum of the recvd quantity per pur doc item 
P_PURORDITEMHIS view from CONSUMPTION Purchase Order Item History
P_PurOrdItemHistoryCalc view_entity from COMPOSITE Purchase Order Item History Calculation
P_PurOrdItemHistoryCalc view_entity union_all COMPOSITE Purchase Order Item History Calculation
P_PurOrdItemHistoryUnion view_entity from CONSUMPTION Purchase Order Item History Union
P_PurOrdItemHistoryUnion view_entity union_all CONSUMPTION Purchase Order Item History Union
P_RFM_SlsOrdPrgrsMntrPOHist view from COMPOSITE Purchase Order History
P_SLLMINMAXRELEVANTPOITEMS view from COMPOSITE PO history for min and max order price determination

Fields (55)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 4
KEY GoodsMovementType GoodsMovementType 3
KEY PurchasingDocument DocumentReferenceID,PurchaseOrder,PurchasingDocument 8
KEY PurchasingDocumentItem PurchaseOrderItem,PurchasingDocumentItem 7
KEY PurchasingHistoryDocument MaterialDocument,PurchasingHistoryDocument 7
KEY PurchasingHistoryDocumentItem MaterialDocumentItem,PurchasingHistoryDocumentItem 7
KEY PurchasingHistoryDocumentType PurchaseOrderTransactionType,PurchasingHistoryDocumentType 4
KEY PurchasingHistoryDocumentYear FiscalYear,MaterialDocumentYear,PurchasingHistoryDocumentYear 7
AccountingDocumentCreationDate AccountingDocumentCreationDate 1
Batch Batch 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreatedByUser CreatedByUser 1
Currency Currency,OrderCurrency 5
DebitCreditCode DebitCreditCode 5
DeliveryDocument DeliveryDocument 1
DeliveryDocumentItem DeliveryDocumentItem 1
DeliveryQuantityUnit DeliveryQuantityUnit 1
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
ExchangeRate ExchangeRate 1
ExchangeRateDifferenceAmount ExchangeRateDifferenceAmount 1
GdsRcptBlkdStkQtyInOrdPrcUnit GdsRcptBlkdStkQtyInOrdPrcUnit 1
GdsRcptBlkdStkQtyInOrdQtyUnit GdsRcptBlkdStkQtyInOrdQtyUnit 1
GRIRAcctClrgAmtInCoCodeCrcy GRIRAcctClrgAmtInCoCodeCrcy 1
GRIRAcctClrgAmtInOrdTrnsacCrcy GRIRAcctClrgAmtInOrdTrnsacCrcy 1
GRIRAcctClrgAmtInTransacCrcy GRIRAcctClrgAmtInTransacCrcy 1
InventoryValuationType InventoryValuationType 1
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency 1
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy 2
InvoiceAmtInPurOrdTransacCrcy InvoiceAmtInPurOrdTransacCrcy 1
InvtryMgmtRefDocumentItem ReferenceDocumentItem 1
InvtryMgmtReferenceDocument ReferenceDocument 1
IsCompletelyDelivered IsCompletelyDelivered 1
IsToBeAcceptedAtOrigin IsToBeAcceptedAtOrigin 1
ManufacturerMaterial ManufacturerMaterial 1
Material Material 5
OrderQuantityUnit OrderQuantityUnit 3
Plant Plant 2
PostingDate PostingDate 5
PricingDocument PricingDocument 1
PurchaseOrderAmount GoodsReceiptAmount,InvoiceReceiptAmount,PurchaseOrderAmount 3
PurchasingDocumentCurrency PurchasingDocumentCurrency 2
PurchasingHistoryCategory PurchasingHistoryCategory 1
PurgHistDocumentCreationTime PurgHistDocumentCreationTime 1
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy 2
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit 1
Quantity GoodsReceiptQuantity,InvoiceReceiptQty,Quantity,QuantityInPurchaseOrderUnit 7
QuantityInBaseUnit QuantityInBaseUnit 2
QuantityInDeliveryQtyUnit QuantityInDeliveryQtyUnit 1
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 1
RvslOfGoodsReceiptIsAllowed RvslOfGoodsReceiptIsAllowed 1
ShipgInstrnSupplierCompliance ShipgInstrnSupplierCompliance 1
TaxCode TaxCode 1
VltdGdsRcptBlkdQtyInOrdPrcUnit VltdGdsRcptBlkdQtyInOrdPrcUnit 1
VltdGdsRcptBlkdStkQtyInOrdUnit VltdGdsRcptBlkdStkQtyInOrdUnit 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- History per Purchasing Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASINGDOCUMENTHISTORYBSC (
    ACCOUNTASSIGNMENTNUMBER,
    GOODSMOVEMENTTYPE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGHISTORYDOCUMENT,
    PURCHASINGHISTORYDOCUMENTITEM,
    PURCHASINGHISTORYDOCUMENTTYPE,
    PURCHASINGHISTORYDOCUMENTYEAR,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    BATCH,
    COMPANYCODECURRENCY,
    CREATEDBYUSER,
    CURRENCY,
    DEBITCREDITCODE,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    DELIVERYQUANTITYUNIT,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    EXCHANGERATEDIFFERENCEAMOUNT,
    GDSRCPTBLKDSTKQTYINORDPRCUNIT,
    GDSRCPTBLKDSTKQTYINORDQTYUNIT,
    GRIRACCTCLRGAMTINCOCODECRCY,
    GRIRACCTCLRGAMTINORDTRNSACCRCY,
    GRIRACCTCLRGAMTINTRANSACCRCY,
    INVENTORYVALUATIONTYPE,
    INVOICEAMOUNTINFRGNCURRENCY,
    INVOICEAMTINCOCODECRCY,
    INVOICEAMTINPURORDTRANSACCRCY,
    INVTRYMGMTREFDOCUMENTITEM,
    INVTRYMGMTREFERENCEDOCUMENT,
    ISCOMPLETELYDELIVERED,
    ISTOBEACCEPTEDATORIGIN,
    MANUFACTURERMATERIAL,
    MATERIAL,
    ORDERQUANTITYUNIT,
    PLANT,
    POSTINGDATE,
    PRICINGDOCUMENT,
    PURCHASEORDERAMOUNT,
    PURCHASINGDOCUMENTCURRENCY,
    PURCHASINGHISTORYCATEGORY,
    PURGHISTDOCUMENTCREATIONTIME,
    PURORDAMOUNTINCOMPANYCODECRCY,
    QTYINPURCHASEORDERPRICEUNIT,
    QUANTITY,
    QUANTITYINBASEUNIT,
    QUANTITYINDELIVERYQTYUNIT,
    REFERENCEDOCUMENTFISCALYEAR,
    RVSLOFGOODSRECEIPTISALLOWED,
    SHIPGINSTRNSUPPLIERCOMPLIANCE,
    TAXCODE,
    VLTDGDSRCPTBLKDQTYINORDPRCUNIT,
    VLTDGDSRCPTBLKDSTKQTYINORDUNIT,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, GOODSMOVEMENTTYPE, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, PURCHASINGHISTORYDOCUMENT, PURCHASINGHISTORYDOCUMENTITEM, PURCHASINGHISTORYDOCUMENTTYPE, PURCHASINGHISTORYDOCUMENTYEAR)
);

Learn More