INVOICEHEADER

21 Fields

INVOICEHEADER is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 1
KEY SupplierInvoice SupplierInvoice 1
_CompanyCode _CompanyCode 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CreatedByUser CreatedByUser 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 1
DocumentHeaderText DocumentHeaderText 1
DueCalculationBaseDate DueCalculationBaseDate 1
InvoiceGrossAmount InvoiceGrossAmount 1
InvoiceStatusAndOrigin InvoiceStatusAndOrigin 1
InvoicingParty InvoicingParty 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
PostingDate PostingDate 1
SupplierInvoiceIDByInvcgParty SupplierInvoiceIDByInvcgParty 1
SupplierInvoiceOrigin SupplierInvoiceOrigin 1
SupplierInvoiceStatus SupplierInvoiceStatus 1
SupplierInvoiceUUID SupplierInvoiceUUID 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 INVOICEHEADER (
    COMPANYCODE,
    FISCALYEAR,
    SUPPLIERINVOICE,
    _COMPANYCODE,
    AMOUNTINTRANSACTIONCURRENCY,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CREATEDBYUSER,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTHEADERTEXT,
    DUECALCULATIONBASEDATE,
    INVOICEGROSSAMOUNT,
    INVOICESTATUSANDORIGIN,
    INVOICINGPARTY,
    ISENDOFPURPOSEBLOCKED,
    POSTINGDATE,
    SUPPLIERINVOICEIDBYINVCGPARTY,
    SUPPLIERINVOICEORIGIN,
    SUPPLIERINVOICESTATUS,
    SUPPLIERINVOICEUUID,
    PRIMARY KEY (COMPANYCODE, FISCALYEAR, SUPPLIERINVOICE)
);

Learn More