ECROSSREFNO

Transparent Table Application Table
15 Fields 1 CDS Views

Reference Number for IDoc

ECROSSREFNO is an SAP database table in S/4HANA. Reference Number for IDoc. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
/UCOM/I_CROSSREFNO view from BASIC Interface View for Cross Reference Number

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY int_crossrefno INT_CROSSREFNO Int. cross ref. no.
KEY int_ui INT_UI PoD
keydate ENDABRPE End bill. per.
crossrefno CROSSREFNO IDE: crossrefno
abrdats ABRDATS Sch. Bill. Date
cancel KENNZX Indicators
created_from CREATED_FROM Created by
vertrag VERTRAG Contract
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
belnr E_BELNR Billing Doc.No.
crn_rev CROSSREFNO IDE: crossrefno

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.

-- Reference Number for IDoc
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ECROSSREFNO (
    MANDT,           -- Client [MANDT]
    INT_CROSSREFNO,  -- Int. cross ref. no. [INT_CROSSREFNO]
    INT_UI,          -- PoD [INT_UI]
    KEYDATE,         -- End bill. per. [ENDABRPE]
    CROSSREFNO,      -- IDE: crossrefno [CROSSREFNO]
    ABRDATS,         -- Sch. Bill. Date [ABRDATS]
    CANCEL,          -- Indicators [KENNZX]
    CREATED_FROM,    -- Created by [CREATED_FROM]
    VERTRAG,         -- Contract [VERTRAG]
    ERDAT,           -- Created On [ERDAT]
    ERNAM,           -- Created By [ERNAM]
    AEDAT,           -- Changed On [AEDAT]
    AENAM,           -- Changed By [AENAM]
    BELNR,           -- Billing Doc.No. [E_BELNR]
    CRN_REV,         -- IDE: crossrefno [CROSSREFNO]
    PRIMARY KEY (MANDT, INT_CROSSREFNO, INT_UI)
);

Learn More