- Home
- Resources
- SAP Tables
- J_1ACAE - Argentina electronic invoice CAE track table
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.
Source: J_1ACAE (Argentina electronic invoice CAE track table)
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |