EDOARINV

Transparent Table Application Table
24 Fields 1 CDS Views

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)
);

Learn More