I_PURCHASEORDERHISTORYBASIC

CDS View
10 Fields 20 CDS Views

Purchase Order History

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

CDS Views using this table (20)

ViewTypeJoinVDMDescription
I_PPS_PurOrdItmDocHistC view_entity from COMPOSITE PPS Pur Ord Item Document History - Cube
I_PurchaseOrderHistoryAPI01 view from COMPOSITE Purchase Order History
I_PurchaseOrderProcessFlow view inner COMPOSITE Purchase Order Business Process Flow
P_BSQPMPurOrdToSuplrInvc view_entity from COMPOSITE Purchase Order to Supplier Invoice
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
P_CO_DIANInvoiceReceiptHistory view from CONSUMPTION
P_GRItm view from CONSUMPTION Goods Receipt document details
P_GRItmOverview view from CONSUMPTION GR Item Overview
P_MngProjDmndPurOrdItmHis view from COMPOSITE
P_MX_JournalEntryGRHistory view inner COMPOSITE
P_PayReqnPONumber view from COMPOSITE
P_PL_SAFTTransferToStock view from COMPOSITE
P_POItemIRCalc1 view from CONSUMPTION PO Item Invoice Receipt Calc1
P_PurchaseOrderHistoryBasic2 view_entity from CONSUMPTION
P_RU_ReltdSupplierInvoiceItem1 view from CONSUMPTION
P_RU_ReltdSupplierInvoiceItem1 view inner CONSUMPTION
P_SrvcOrdFUPPurOrdProcessFlow view inner CONSUMPTION Solution Order Purchase Requisition Flow
R_PPS_PurOrdDocumentHistory view_entity from TRANSACTIONAL Purchase Order Document History

Fields (10)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 2
KEY PurchaseOrder CFinPurchasingDocument,PrecedingDocument,PurchaseOrder 6
KEY PurchaseOrderItem CFinPurchasingDocumentItem,PurchaseOrderItem 3
KEY PurchasingHistoryDocument CentralFinanceSupplierInvoice,PurchasingHistoryDocument,RelatedCFinSupplierInvoice,SubsequentDocument 8
KEY PurchasingHistoryDocumentItem CFinSupplierInvoiceItem,PurchasingHistoryDocumentItem,RelatedCFinSupplierInvoiceItem 3
ExchangeRate ExchangeRate 1
PurchasingHistoryCategory PurchasingHistoryCategory,RelatedPurchHistoryCategory 1
PurchasingHistoryDocumentYear FiscalYear,MaterialDocumentYear,RelatedFiscalYear 2
ReferenceDocument ReferenceDocument 3
ReferenceDocumentItem ReferenceDocumentItem 2

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,
    EXCHANGERATE,
    PURCHASINGHISTORYCATEGORY,
    PURCHASINGHISTORYDOCUMENTYEAR,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, PURCHASEORDER, PURCHASEORDERITEM, PURCHASINGHISTORYDOCUMENT, PURCHASINGHISTORYDOCUMENTITEM)
);

Learn More