I_SUPLRINVCITEMLOGSUNION

CDS View

SI Item union of batch and online items

I_SUPLRINVCITEMLOGSUNION is a CDS View in S/4HANA. SI Item union of batch and online items. It contains 8 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_APProcessFlowSupplierInvoice view from CONSUMPTION AP Process Flow Supplier Invoice
C_SuplrInvcItemPurOrdRefTaskUI view from CONSUMPTION SIV Items with PO Ref wo Acct Assgnmnt
P_MY_SupplierInvoiceItem view from COMPOSITE Supplier Invoice Item for MY GAF
P_StRpSupplierInvoiceItem view from COMPOSITE Supplier Invoice Item with Tax for Statutory Reporting

Fields (8)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear 2
KEY SupplierInvoice SupplierInvoice 2
KEY SupplierInvoiceItem SupplierInvoiceItem 2
_Currency _Currency 1
DocumentCurrency DocumentCurrency 2
Plant Plant 1
PurchaseOrderItemMaterial Material 1
TaxCode TaxCode 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.

-- SI Item union of batch and online items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPLRINVCITEMLOGSUNION (
    FISCALYEAR,
    SUPPLIERINVOICE,
    SUPPLIERINVOICEITEM,
    _CURRENCY,
    DOCUMENTCURRENCY,
    PLANT,
    PURCHASEORDERITEMMATERIAL,
    TAXCODE,
    PRIMARY KEY (FISCALYEAR, SUPPLIERINVOICE, SUPPLIERINVOICEITEM)
);