I_SUPPLIERINVOICEAPI01

CDS View

Supplier Invoice

I_SUPPLIERINVOICEAPI01 is a CDS View in S/4HANA. Supplier Invoice. It contains 12 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_SupplierInvoiceDEX view from CONSUMPTION Data Extraction for Supplier Invoice
I_SuplrInvcEmailParameter view_entity from TRANSACTIONAL Parameters for Supplier Invoice Email Template
I_SuplrInvcHeaderWhldgTaxAPI01 view inner COMPOSITE Withholding Tax for Supplier Invoice
I_SuplrInvcItemAssetAPI01 view_entity inner COMPOSITE Asset Item of Supplier Invoice
I_SuplrInvcItemCsgnmtAPI01 view_entity inner BASIC Consignment Settlement Item
I_SuplrInvcItemMaterialAPI01 view inner BASIC Material Item of Supplier Invoice
I_SuplrInvcItemPurOrdRefAPI01 view inner COMPOSITE Purchase Order Ref of Supplier Invoice
I_SuplrInvcItmAcctAssgmtAPI01 view inner COMPOSITE Account Assignment for Supplier Invoice
I_SuplrInvcStsAndOrignAPI01 view inner COMPOSITE Supplier Invoice Status and Origin
I_SuplrInvoiceItemGLAcctAPI01 view inner COMPOSITE G/L Account Item of Supplier Invoice
I_SupplierInvoiceTaxAPI01 view inner COMPOSITE Tax for Supplier Invoice
P_IN_SuplrInvcTxAttrib view_entity from COMPOSITE India:Supplier Invoice Tax Atrributes

Fields (12)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear 2
KEY SupplierInvoice SupplierInvoice 2
BusinessPlace BusinessPlace 1
CompanyCode CompanyCode 2
CreationDate CreationDate 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 2
InvoiceGrossAmount InvoiceGrossAmount 1
InvoicingParty InvoicingParty 1
PostingDate PostingDate 1
SupplierInvoiceIDByInvcgParty SupplierInvoiceIDByInvcgParty 1
SupplierInvoiceOrigin SupplierInvoiceOrigin 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.

-- Supplier Invoice
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPPLIERINVOICEAPI01 (
    FISCALYEAR,
    SUPPLIERINVOICE,
    BUSINESSPLACE,
    COMPANYCODE,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    INVOICEGROSSAMOUNT,
    INVOICINGPARTY,
    POSTINGDATE,
    SUPPLIERINVOICEIDBYINVCGPARTY,
    SUPPLIERINVOICEORIGIN,
    PRIMARY KEY (FISCALYEAR, SUPPLIERINVOICE)
);