J_1ACAE

Transparent Table Application Table
33 Fields 2 CDS Views

Argentina electronic invoice CAE track table

J_1ACAE is an SAP database table in S/4HANA. Argentina electronic invoice CAE track table. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
argentina_eInvoice_j_1acae view from Output Manag. Parameters for Argentina eInvoice
I_AR_ElectronicInvoice view from BASIC AR Electronic Invoice CAE Tracking

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY brnch J_1ABRNCH Branch number
KEY cae_ref J_1ACAEREF CAE ref doc
KEY cae_refyr GJAHR Fiscal Year
KEY cae_reftyp J_1ACAEREFTYP CAE ref type
KEY budat BUDAT Posting Date
doccls J_1ADOCCL_ Document Class
j_1aprtchr J_1APCHAR Prnt. Character
xblnr 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
cae_aenam J_1AAENAM Changed by
cae_aedat J_1AAEDAT Changed on
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
conting_flag J_1ACONFLAG Cont Flag
conting_time J_1ACONTIME Cont. Time
conting_date J_1ACONDATE Cont. Date
contin_brnch J_1ACONBRNCH Cont. Branch
rfc_sent_date J_1ARFCSENTDATE RFC Sent date
rfc_sent_time J_1ARFCSENTTIME RFC Sent time
rfc_sent_lock J_1ARFCSENTLOCK RFC Sent lock
xmlmessageid J_1A_WS_XMLMSGID Message ID
uniq_exp_ws_id J_1A_WS_UNIQEXPID Unique ID

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.

-- Argentina electronic invoice CAE track table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1ACAE (
    MANDT,            -- Client [MANDT]
    BUKRS,            -- Company Code [BUKRS]
    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]
    XBLNR,            -- 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]
    CAE_AENAM,        -- Changed by [J_1AAENAM]
    CAE_AEDAT,        -- Changed on [J_1AAEDAT]
    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]
    CONTING_FLAG,     -- Cont Flag [J_1ACONFLAG]
    CONTING_TIME,     -- Cont. Time [J_1ACONTIME]
    CONTING_DATE,     -- Cont. Date [J_1ACONDATE]
    CONTIN_BRNCH,     -- Cont. Branch [J_1ACONBRNCH]
    RFC_SENT_DATE,    -- RFC Sent date [J_1ARFCSENTDATE]
    RFC_SENT_TIME,    -- RFC Sent time [J_1ARFCSENTTIME]
    RFC_SENT_LOCK,    -- RFC Sent lock [J_1ARFCSENTLOCK]
    XMLMESSAGEID,     -- Message ID [J_1A_WS_XMLMSGID]
    UNIQ_EXP_WS_ID,   -- Unique ID [J_1A_WS_UNIQEXPID]
    PRIMARY KEY (MANDT, BUKRS, BRNCH, CAE_REF, CAE_REFYR, CAE_REFTYP, BUDAT)
);

Learn More