EDOESSII_ICP

Transparent Table Application Table

eDocument Spain SII Single Document for Incoming Cash

EDOESSII_ICP is an SAP database table in S/4HANA. eDocument Spain SII Single Document for Incoming Cash. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ES_ElectronicDocSIIIncgCash view from BASIC Spain SII Single Incoming Cash Payment

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY edoc_guid EDOC_GUID eDocument GUID
reporting_year EDOC_ESSII_YEAR Year
declarer_nif EDOC_ESSII_DECLARER_NIF Declarer NIF
partner_tax_id EDOC_ESSII_PARTNER_TAX_ID Partner ID Number
partner_tax_id_type EDOC_ESSII_PARTNER_TAX_ID_TYPE Partner ID Type
partner_tax_id_country EDOC_ESSII_PARTNER_TAX_ID_CTRY ID Ctry/Reg
partner_name EDOC_ESSII_PARTNER_NAME Partner Name
payment_amount EDOC_ESSII_PAYMENT_AMOUNT Payment Amount
payment_currency EDOC_ESSII_PAYMENT_CURRENCY Payment Currency

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.

-- eDocument Spain SII Single Document for Incoming Cash
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDOESSII_ICP (
    MANDT,                   -- Client [MANDT]
    EDOC_GUID,               -- eDocument GUID [EDOC_GUID]
    REPORTING_YEAR,          -- Year [EDOC_ESSII_YEAR]
    DECLARER_NIF,            -- Declarer NIF [EDOC_ESSII_DECLARER_NIF]
    PARTNER_TAX_ID,          -- Partner ID Number [EDOC_ESSII_PARTNER_TAX_ID]
    PARTNER_TAX_ID_TYPE,     -- Partner ID Type [EDOC_ESSII_PARTNER_TAX_ID_TYPE]
    PARTNER_TAX_ID_COUNTRY,  -- ID Ctry/Reg [EDOC_ESSII_PARTNER_TAX_ID_CTRY]
    PARTNER_NAME,            -- Partner Name [EDOC_ESSII_PARTNER_NAME]
    PAYMENT_AMOUNT,          -- Payment Amount [EDOC_ESSII_PAYMENT_AMOUNT]
    PAYMENT_CURRENCY,        -- Payment Currency [EDOC_ESSII_PAYMENT_CURRENCY]
    PRIMARY KEY (MANDT, EDOC_GUID)
);