SAP Table J_1ACAE

Argentina electronic invoice CAE track table

J_1ACAE (Argentina electronic invoice CAE track table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J_1ACAE to other SAP tables.

J_1ACAE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BRNCH Branch Number J_1ABRNCH J_1BBRANCH CHAR 4 0
CAE_REF Reference document for CAE invoices J_1ACAEREF CHAR 10 0
CAE_REFYR Fiscal Year GJAHR NUMC 4 0
CAE_REFTYP CAE reference document type J_1ACAEREFTYP CHAR 1 0
A Accounting document (FI invoice)
B Billing document (SD invoice)
BUDAT Posting Date in the Document BUDAT DATS 8 0
DOCCLS Document Class J_1ADOCCL_ J_1ADOCCLS CHAR 1 0
J_1APRTCHR Character to be printed on the document J_1APCHAR J_1APRTCHR CHAR 1 0
XBLNR Reference Document Number XBLNR CHAR 16 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
ANX3_DATE Date of Annexure III generation J_1AANX3DT DATS 8 0
CAE_STATUS CAE Invoice Status J_1ACAESTATUS CHAR 1 0
I Sent to AFIP
A Approved
P Approved with Reservations
R Rejected
N New Document
C Contingency
E Validation Error
O Observations
CAE_REASON Reason for CAE status J_1ACAEREASON CHAR 8 0
REJ_REASON Reason for rejection of CAE invoice J_1AREJREASON CHAR 11 0
CAE_NUM CAE number of invoice J_1ACAENUM CHAR 14 0
CAE_DUEDATE CAE invoice due date J_1ACAEDUEDATE DATS 8 0
EI_FLAG Flag to mark creation of EI in Annexure V format J_1AEIFLAG CHAR 1 0
X Generated Annexure V for invoice
NULL Not generated Annexure V for invoice
CAE_AENAM Name of Person Who Changed Object J_1AAENAM CHAR 12 0
CAE_AEDAT Date of Last Change J_1AAEDAT DATS 8 0
CUST_EI_FLAG Flag to indicate electronic invoicing applicable for custome J_1ACUST_EI CHAR 1 0
SALES_SERV_IND Goods or Service Invoices J_1ASALSERIND CHAR 1 0
S Goods
V Service
1 Export of Goods
2 Export of Services
4 Export others
3 Goods or Services
UNIQUE_EXP_CODE Unique Code to Identify Export Documents UNIQUE_EXP_CODE NUMC 10 0
REASON_CONTING Contingency Reason for CAE Invoice J_1ACONRESAON CHAR 20 0
CONTING_FLAG Processing Contingency Document J_1ACONFLAG CHAR 1 0
CONTING_TIME Contingency Time J_1ACONTIME TIMS 6 0
CONTING_DATE Contingency Date J_1ACONDATE DATS 8 0
CONTIN_BRNCH Contingency Branch J_1ACONBRNCH CHAR 4 0
RFC_SENT_DATE RFC Sent Date J_1ARFCSENTDATE DATS 8 0
RFC_SENT_TIME RFC Sent Time J_1ARFCSENTTIME TIMS 6 0
RFC_SENT_LOCK RFC Sent Lock J_1ARFCSENTLOCK CHAR 1 0
X Locked for RFC processing
NULL No Lock
XMLMESSAGEID XML Message ID J_1A_WS_XMLMSGID CHAR 32 0
UNIQ_EXP_WS_ID AR: WS Unique Code to Identify Export Documents J_1A_WS_UNIQEXPID NUMC 15 0

J_1ACAE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1ACAE BRNCH J_1ACAE MANDT J_1BBRANCH Business Place MANDT
J_1ACAE BRNCH J_1ACAE BUKRS J_1BBRANCH Business Place BUKRS
J_1ACAE BRNCH J_1ACAE BRNCH J_1BBRANCH Business Place BRANCH
J_1ACAE BUKRS J_1ACAE MANDT T001 Company Codes MANDT
J_1ACAE BUKRS J_1ACAE BUKRS T001 Company Codes BUKRS
J_1ACAE DOCCLS J_1ACAE MANDT J_1ADOCCLS Official document class for Argentina MANDT
J_1ACAE DOCCLS J_1ACAE DOCCLS J_1ADOCCLS Official document class for Argentina J_1ACOCCLS
J_1ACAE J_1APRTCHR J_1ACAE MANDT J_1APRTCHR Printing characters for Argentina MANDT
J_1ACAE J_1APRTCHR J_1ACAE J_1APRTCHR J_1APRTCHR Printing characters for Argentina J_1APRTCHR
J_1ACAE KUNNR J_1ACAE MANDT KNA1 General Data in Customer Master MANDT
J_1ACAE KUNNR J_1ACAE KUNNR KNA1 General Data in Customer Master KUNNR
J_1ACAE MANDT J_1ACAE MANDT T000 Clients MANDT