J_1ACAE SAP (Argentina electronic invoice CAE track table) Table details
Dictionary Type: Table
Description: Argentina electronic invoice CAE track table
Description: Argentina electronic invoice CAE track table
Table field list including key, data, relationships and ABAP select examples
J_1ACAE is a standard SAP Table which is used to store Argentina electronic invoice CAE track table data and is available within R/3 SAP systems depending on the version and release level.
The J_1ACAE table consists of various fields, each holding specific information or linking keys about Argentina electronic invoice CAE track table data available in SAP. These include BUKRS (Company Code), BRNCH (Branch Number), CAE_REF (Reference document for CAE invoices), CAE_REFYR (Fiscal Year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP J_1ACAE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BRNCH | Branch Number | J_1ABRNCH | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | JEA | ||
CAE_REF | Reference document for CAE invoices | J_1ACAEREF | CHAR | 10 | ALPHA | J_1ACAEREF | |||
CAE_REFYR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
CAE_REFTYP | CAE reference document type | J_1ACAEREFTYP | CHAR | 1 | J_1ACAEREFTYP | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
DOCCLS | Document Class | J_1ADOCCL_ | CHAR | 1 | J_1ADOCCLS | J_1ADOCCLS | |||
J_1APRTCHR | Character to be printed on the document | J_1APCHAR | CHAR | 1 | J_1APRTCHR | J_1APCHAR | |||
XBLNR | Reference Document Number | XBLNR | CHAR | 16 | XBLNR | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
ANX3_DATE | Date of Annexure III generation | J_1AANX3DT | DATS | 8 | DATUM | ||||
CAE_STATUS | CAE Invoice Status | J_1ACAESTATUS | CHAR | 1 | J_1ACAESTATUS | ||||
CAE_REASON | Reason for CAE status | J_1ACAEREASON | CHAR | 8 | |||||
REJ_REASON | Reason for rejection of CAE invoice | J_1AREJREASON | CHAR | 11 | CHAR11 | ||||
CAE_NUM | CAE number of invoice | J_1ACAENUM | CHAR | 14 | J_1ACAENUM | ||||
CAE_DUEDATE | CAE invoice due date | J_1ACAEDUEDATE | DATS | 8 | DATUM | ||||
EI_FLAG | Flag to mark creation of EI in Annexure V format | J_1AEIFLAG | CHAR | 1 | J_1AEIFLAG | ||||
CAE_AENAM | Name of Person Who Changed Object | J_1AAENAM | CHAR | 12 | USNAM | ||||
CAE_AEDAT | Date of Last Change | J_1AAEDAT | DATS | 8 | DATUM | ||||
CUST_EI_FLAG | Flag to indicate electronic invoicing applicable for custome | J_1ACUST_EI | CHAR | 1 | J_1ACUST_EI | ||||
SALES_SERV_IND | Goods or Service Invoices | J_1ASALSERIND | CHAR | 1 | J_1ASALSERIND | ||||
UNIQUE_EXP_CODE | Unique Code to Identify Export Documents | UNIQUE_EXP_CODE | NUMC | 10 | UNIQUE_EXP_CODE | ||||
REASON_CONTING | Contingency Reason for CAE Invoice | J_1ACONRESAON | CHAR | 20 | CHAR20 | ||||
CONTING_FLAG | Processing Contingency Document | J_1ACONFLAG | CHAR | 1 | |||||
CONTING_TIME | Contingency Time | J_1ACONTIME | TIMS | 6 | TIME8 | ||||
CONTING_DATE | Contingency Date | J_1ACONDATE | DATS | 8 | DATUM | ||||
CONTIN_BRNCH | Contingency Branch | J_1ACONBRNCH | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
RFC_SENT_DATE | RFC Sent Date | J_1ARFCSENTDATE | DATS | 8 | DATUM | ||||
RFC_SENT_TIME | RFC Sent Time | J_1ARFCSENTTIME | TIMS | 6 | TIME8 | ||||
RFC_SENT_LOCK | RFC Sent Lock | J_1ARFCSENTLOCK | CHAR | 1 | J_1ARFCSENTLOCK | ||||
XMLMESSAGEID | XML Message ID | J_1A_WS_XMLMSGID | CHAR | 32 | J_1A_WS_XMLMSGID | ||||
UNIQ_EXP_WS_ID | AR: WS Unique Code to Identify Export Documents | J_1A_WS_UNIQEXPID | NUMC | 15 | J_1A_WS_UNIQEXPID |
Key field | Non-key field |
How do I retrieve data from SAP table J_1ACAE using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_1ACAE to SELECT all data from the tableDATA: WA_J_1ACAE TYPE J_1ACAE.
SELECT SINGLE *
FROM J_1ACAE
INTO CORRESPONDING FIELDS OF WA_J_1ACAE
WHERE...
How to access SAP table J_1ACAE
Within an ECC or HANA version of SAP you can also view further information about J_1ACAE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects