I_PURCHASEORDERHISTORYBASIC

CDS View
19 Fields 17 CDS Views

Purchase Order History

I_PURCHASEORDERHISTORYBASIC is a CDS View in S/4HANA. Purchase Order History. It contains 19 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
I_PurchaseOrderHistoryAPI01 view from COMPOSITE Purchase Order History
I_PurchaseOrderProcessFlow view inner COMPOSITE Purchase Order Business Process Flow
P_BusSolnOrdSlsOrdFlwLvl13 view inner CONSUMPTION Solution Order Sales Order Flow Level 13
P_BusSolnOrdSlsOrdFlwLvl14 view inner CONSUMPTION Solution Order Sales Order Flow Level 14
P_CO_DIANGoodsReceiptHistory view from CONSUMPTION All Formats - Goods Receipt History
P_CO_DIANInvoiceReceiptHistory view from CONSUMPTION All Formats - Invoice Receipt History
P_CO_ServiceEntrySheetHistory view_entity inner CONSUMPTION Service Entry Sheet History for Colombia
P_GRItm view from CONSUMPTION Goods Receipt document details
P_GRItmOverview view from CONSUMPTION GR Item Overview
P_MngProjDmndPurOrdItmHis view from COMPOSITE Private view for PO item history
P_MX_JournalEntryGRHistory view inner COMPOSITE Journal Entry Goods Receipt History
P_PayReqnPONumber view from COMPOSITE Private view for purchasing order lines
P_PL_SAFTTransferToStock view from COMPOSITE SAFT PT Transfer to Stock
P_POItemIRCalc1 view from CONSUMPTION PO Item Invoice Receipt Calc1
P_RU_ReltdSupplierInvoiceItem1 view from CONSUMPTION Related Supplier Invoice Items from the same Purch Doc-1
P_RU_ReltdSupplierInvoiceItem1 view inner CONSUMPTION Related Supplier Invoice Items from the same Purch Doc-1
P_SrvcOrdFUPPurOrdProcessFlow view inner CONSUMPTION Solution Order Purchase Order Flow

Fields (19)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 3
KEY PurchaseOrder CFinPurchasingDocument,PurchaseOrder 5
KEY PurchaseOrderItem CFinPurchasingDocumentItem,PurchaseOrderItem 3
KEY PurchasingHistoryDocument CentralFinanceSupplierInvoice,PurchasingHistoryDocument,RelatedCFinSupplierInvoice,SubsequentDocument 9
KEY PurchasingHistoryDocumentItem CFinSupplierInvoiceItem,PurchasingHistoryDocumentItem,RelatedCFinSupplierInvoiceItem,SubsequentDocumentItem 5
KEY PurchasingHistoryDocumentYear FiscalYear,MaterialDocumentYear,RelatedFiscalYear 2
_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
ExchangeRate ExchangeRate 1
PurchasingHistoryCategory PurchasingHistoryCategory,RelatedPurchHistoryCategory 1
ReferenceDocument ReferenceDocument 4
ReferenceDocumentItem ReferenceDocumentItem 3

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.

-- Purchase Order History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASEORDERHISTORYBASIC (
    ACCOUNTASSIGNMENTNUMBER,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASINGHISTORYDOCUMENT,
    PURCHASINGHISTORYDOCUMENTITEM,
    PURCHASINGHISTORYDOCUMENTYEAR,
    _BASEUNITTEXT,
    _COMPANYCODECURRENCYTEXT,
    _CURRENCYTEXT,
    _DEBITCREDITCODETEXT,
    _DELIVERYQUANTITYUNITTEXT,
    _DOCUMENTCURRENCYTEXT,
    _GOODSMOVEMENTTYPETEXT,
    _ORDERPRICEUNITTEXT,
    _ORDERQUANTITYUNITTEXT,
    EXCHANGERATE,
    PURCHASINGHISTORYCATEGORY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, PURCHASEORDER, PURCHASEORDERITEM, PURCHASINGHISTORYDOCUMENT, PURCHASINGHISTORYDOCUMENTITEM, PURCHASINGHISTORYDOCUMENTYEAR)
);

Learn More