HISTORY

24 Fields

HISTORY is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 2
KEY MaterialDocument belnr,MaterialDocument 5
KEY MaterialDocumentItem buzei,MaterialDocumentItem 5
KEY MaterialDocumentYear MaterialDocumentYear 2
KEY PurchaseOrder ebeln,PurchaseOrder 3
KEY PurchaseOrderItem ebelp,PurchaseOrderItem 3
KEY PurchaseOrderTransactionType PurchaseOrderTransactionType 2
Currency Currency 1
GRIRClearingProcessPriority GRIRClearingProcessPriority 1
GRIRClearingProcessStatus GRIRClearingProcessStatus 1
InvoiceAmountInFrgnCurrency InvoiceAmtInDisplayCurrency 1
MaterialGroup MaterialGroup 1
PostingDate PostingDate 3
PrevGRIRClearingProcessStatus PrevGRIRClearingProcessStatus 1
PrevGRIRClrgProcPriority PrevGRIRClrgProcPriority 1
PrevResponsibleDepartment PrevResponsibleDepartment 1
PrevResponsiblePerson PrevResponsiblePerson 1
PurchaseOrderAmount PurchaseOrderAmount 1
PurchasingDocumentCategory PurchasingDocumentCategory 2
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy 1
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit 1
Quantity Quantity 2
ResponsibleDepartment ResponsibleDepartment 1
ResponsiblePerson ResponsiblePerson 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HISTORY (
    ACCOUNTASSIGNMENTNUMBER,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEORDERTRANSACTIONTYPE,
    CURRENCY,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSSTATUS,
    INVOICEAMOUNTINFRGNCURRENCY,
    MATERIALGROUP,
    POSTINGDATE,
    PREVGRIRCLEARINGPROCESSSTATUS,
    PREVGRIRCLRGPROCPRIORITY,
    PREVRESPONSIBLEDEPARTMENT,
    PREVRESPONSIBLEPERSON,
    PURCHASEORDERAMOUNT,
    PURCHASINGDOCUMENTCATEGORY,
    PURORDAMOUNTINCOMPANYCODECRCY,
    QTYINPURCHASEORDERPRICEUNIT,
    QUANTITY,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR, PURCHASEORDER, PURCHASEORDERITEM, PURCHASEORDERTRANSACTIONTYPE)
);

Learn More