EDOARINV

Transparent Table Application Table

eDocument Aregentina Invoice

EDOARINV is an SAP database table in S/4HANA. eDocument Aregentina Invoice. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_AR_ElectronicDocInvoice view_entity from BASIC eDocument Aregentina Invoice

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY edoc_guid edoc_guid eDocument GUID
brnch j_1abrnch Branch number
cae_ref j_1acaeref CAE ref doc
cae_refyr gjahr Fiscal Year
cae_reftyp j_1acaereftyp CAE ref type
budat budat Posting Date
doccls j_1adoccl_ Document Class
j_1aprtchr j_1apchar Prnt. Character
ref_num xblnr Reference
kunnr kunnr Customer
anx3_date j_1aanx3dt Anx.3 date
cae_status j_1acaestatus CAE Status
cae_reason j_1acaereason CAE reason
rej_reason j_1arejreason Rej.Reason
cae_num j_1acaenum CAE number
cae_duedate j_1acaeduedate CAE duedate
ei_flag j_1aeiflag Annexure 5 Flag
cust_ei_flag j_1acust_ei Customer EI
sales_serv_ind j_1asalserind Goods or Services
unique_exp_code unique_exp_code Uniq Exp Code
reason_conting j_1aconresaon Con.Reason
contin_brnch j_1aconbrnch Cont. Branch
odn edoc_ar_num_cmp Receipt number

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 Aregentina Invoice
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDOARINV (
    MANDT,            -- Client [mandt]
    EDOC_GUID,        -- eDocument GUID [edoc_guid]
    BRNCH,            -- Branch number [j_1abrnch]
    CAE_REF,          -- CAE ref doc [j_1acaeref]
    CAE_REFYR,        -- Fiscal Year [gjahr]
    CAE_REFTYP,       -- CAE ref type [j_1acaereftyp]
    BUDAT,            -- Posting Date [budat]
    DOCCLS,           -- Document Class [j_1adoccl_]
    J_1APRTCHR,       -- Prnt. Character [j_1apchar]
    REF_NUM,          -- Reference [xblnr]
    KUNNR,            -- Customer [kunnr]
    ANX3_DATE,        -- Anx.3 date [j_1aanx3dt]
    CAE_STATUS,       -- CAE Status [j_1acaestatus]
    CAE_REASON,       -- CAE reason [j_1acaereason]
    REJ_REASON,       -- Rej.Reason [j_1arejreason]
    CAE_NUM,          -- CAE number [j_1acaenum]
    CAE_DUEDATE,      -- CAE duedate [j_1acaeduedate]
    EI_FLAG,          -- Annexure 5 Flag [j_1aeiflag]
    CUST_EI_FLAG,     -- Customer EI [j_1acust_ei]
    SALES_SERV_IND,   -- Goods or Services [j_1asalserind]
    UNIQUE_EXP_CODE,  -- Uniq Exp Code [unique_exp_code]
    REASON_CONTING,   -- Con.Reason [j_1aconresaon]
    CONTIN_BRNCH,     -- Cont. Branch [j_1aconbrnch]
    ODN,              -- Receipt number [edoc_ar_num_cmp]
    PRIMARY KEY (MANDT, EDOC_GUID)
);