HISTORY

51 Fields

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

Fields (51)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 2
KEY MaterialDocument belnr,MaterialDocument 5
KEY MaterialDocumentItem buzei,MaterialDocumentItem 5
KEY MaterialDocumentYear MaterialDocumentYear 2
KEY PrepaymentAssignedDocumentUUID PrepaymentAssignedDocumentUUID 1
KEY PurchaseOrder ebeln,PurchaseOrder 3
KEY PurchaseOrderItem ebelp,PurchaseOrderItem 3
KEY PurchaseOrderTransactionType PurchaseOrderTransactionType 2
ACMSettlementDocumentType ACMSettlementDocumentType 1
ACMSettlementGroupFXVal ACMSettlementGroupFXVal 1
ConsumedAmountInSettlmtCrcy ConsumedAmountInSettlmtCrcy 1
Counterparty Counterparty 1
Currency Currency 1
GRIRClearingProcessPriority GRIRClearingProcessPriority 1
GRIRClearingProcessStatus GRIRClearingProcessStatus 1
InvoiceAmountInFrgnCurrency InvoiceAmtInDisplayCurrency 1
MaterialGroup MaterialGroup 1
PostingDate PostingDate 3
PostingDateYear PostingDateYear 1
PrepayAccrualPostedCurrency PrepayAccrualPostedCurrency 1
PrepaymentAgreement PrepaymentAgreement 1
PrepaymentAgreementAmount PrepaymentAgreementAmount 1
PrepaymentAgreementCommodity PrepaymentAgreementCommodity 1
PrepaymentAgreementCurrency PrepaymentAgreementCurrency 1
PrepaymentAgreementType PrepaymentAgreementType 1
PrepaymentAgrmtConsumedAmount PrepaymentAgrmtConsumedAmount 1
PrepaymentAgrmtEventAmount PrepaymentAgrmtEventAmount 1
PrepaymentAgrmtLinkAmount PrepaymentAgrmtLinkAmount 1
PrepaymentAgrmtRefBusObject PrepaymentAgrmtRefBusObject 1
PrepaymentAgrmtRefDocument PrepaymentAgrmtRefDocument 1
PrepaymentAgrmtRefDocumentType PrepaymentAgrmtRefDocumentType 1
PrepaymentAgrmtRefLinkUUID PrepaymentAgrmtRefLinkUUID 1
PrepaymentCreditCurrency PrepaymentCreditCurrency 1
PrepaymentUnassignedAmt PrepaymentUnassignedAmt 1
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
SettlementCurrency SettlementCurrency 1
SettlementGroupId SettlementGroupId 1
SettlementNetAmount SettlementNetAmount 1
SettlementPostingDate SettlementPostingDate 1
SettlmtDoc SettlmtDoc 1
SettlmtNetAmtInPrepaymentCrcy SettlmtNetAmtInPrepaymentCrcy 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,
    PREPAYMENTASSIGNEDDOCUMENTUUID,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEORDERTRANSACTIONTYPE,
    ACMSETTLEMENTDOCUMENTTYPE,
    ACMSETTLEMENTGROUPFXVAL,
    CONSUMEDAMOUNTINSETTLMTCRCY,
    COUNTERPARTY,
    CURRENCY,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSSTATUS,
    INVOICEAMOUNTINFRGNCURRENCY,
    MATERIALGROUP,
    POSTINGDATE,
    POSTINGDATEYEAR,
    PREPAYACCRUALPOSTEDCURRENCY,
    PREPAYMENTAGREEMENT,
    PREPAYMENTAGREEMENTAMOUNT,
    PREPAYMENTAGREEMENTCOMMODITY,
    PREPAYMENTAGREEMENTCURRENCY,
    PREPAYMENTAGREEMENTTYPE,
    PREPAYMENTAGRMTCONSUMEDAMOUNT,
    PREPAYMENTAGRMTEVENTAMOUNT,
    PREPAYMENTAGRMTLINKAMOUNT,
    PREPAYMENTAGRMTREFBUSOBJECT,
    PREPAYMENTAGRMTREFDOCUMENT,
    PREPAYMENTAGRMTREFDOCUMENTTYPE,
    PREPAYMENTAGRMTREFLINKUUID,
    PREPAYMENTCREDITCURRENCY,
    PREPAYMENTUNASSIGNEDAMT,
    PREVGRIRCLEARINGPROCESSSTATUS,
    PREVGRIRCLRGPROCPRIORITY,
    PREVRESPONSIBLEDEPARTMENT,
    PREVRESPONSIBLEPERSON,
    PURCHASEORDERAMOUNT,
    PURCHASINGDOCUMENTCATEGORY,
    PURORDAMOUNTINCOMPANYCODECRCY,
    QTYINPURCHASEORDERPRICEUNIT,
    QUANTITY,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SETTLEMENTCURRENCY,
    SETTLEMENTGROUPID,
    SETTLEMENTNETAMOUNT,
    SETTLEMENTPOSTINGDATE,
    SETTLMTDOC,
    SETTLMTNETAMTINPREPAYMENTCRCY,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR, PREPAYMENTASSIGNEDDOCUMENTUUID, PURCHASEORDER, PURCHASEORDERITEM, PURCHASEORDERTRANSACTIONTYPE)
);

Learn More