SAP table J_1ACAE (Argentina electronic invoice CAE track table)

SAP table J_1ACAE has 7 primary key fields being MANDT,BUKRS,BRNCH,CAE_REF,CAE_REFYR,CAE_REFTYP,BUDAT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

J_1ACAE foreign key relationships

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