INVOICEITEM

18 Fields

INVOICEITEM is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,InvoiceReference 2
KEY AccountingDocumentItem InvoiceItemReference 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear,InvoiceReferenceFiscalYear 2
KEY PortugueseMaterialWithVersion PortugueseMaterialWithVersion 1
KEY Supplier Supplier 1
ClearingItem ClearingItem 1
ClearingJournalEntry ClearingJournalEntry 1
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 1
CompanyCodeCurrency CompanyCodeCurrency 2
DebitCreditCode DebitCreditCode 1
ebeln PurchasingDocument 1
ebelp PurchasingDocumentItem 1
FinancialAccountType FinancialAccountType 1
Material Material 1
MaterialName ProductDescription 1
Product Product 1
TransactionCurrency TransactionCurrency 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE INVOICEITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    PORTUGUESEMATERIALWITHVERSION,
    SUPPLIER,
    CLEARINGITEM,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECURRENCY,
    DEBITCREDITCODE,
    EBELN,
    EBELP,
    FINANCIALACCOUNTTYPE,
    MATERIAL,
    MATERIALNAME,
    PRODUCT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, PORTUGUESEMATERIALWITHVERSION, SUPPLIER)
);

Learn More