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