SAP ABAP Table J_1ACAE (Argentina electronic invoice CAE track table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-TAX (Application Component) Tax Determination
     ⤷ J1AF (Package) Financial Accounting Argentina

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1ACAE	Table Relationship Diagram
Short Description	Argentina electronic invoice CAE track table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	BRNCH	☑	J_1ABRNCH	J_1BBRANCH	CHAR	4	0	Branch number	J_1BBRANCH
4	CAE_REF	☑	J_1ACAEREF	J_1ACAEREF	CHAR	10	0	Reference document for CAE invoices
5	CAE_REFYR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	CAE_REFTYP	☑	J_1ACAEREFTYP	J_1ACAEREFTYP	CHAR	1	0	CAE reference document type
7	BUDAT	☑	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
8	DOCCLS	☐	J_1ADOCCL_	J_1ADOCCLS	CHAR	1	0	Document Class	J_1ADOCCLS
9	J_1APRTCHR	☐	J_1APCHAR	J_1APCHAR	CHAR	1	0	Character to be printed on the document	J_1APRTCHR
10	XBLNR	☐	XBLNR	XBLNR	CHAR	16	0	Reference Document Number
11	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
12	ANX3_DATE	☐	J_1AANX3DT	DATUM	DATS	8	0	Date of Annexure III generation
13	CAE_STATUS	☐	J_1ACAESTATUS	J_1ACAESTATUS	CHAR	1	0	CAE Invoice Status
14	CAE_REASON	☐	J_1ACAEREASON		CHAR	8	0	Reason for CAE status
15	REJ_REASON	☐	J_1AREJREASON	CHAR11	CHAR	11	0	Reason for rejection of CAE invoice
16	CAE_NUM	☐	J_1ACAENUM	J_1ACAENUM	CHAR	14	0	CAE number of invoice
17	CAE_DUEDATE	☐	J_1ACAEDUEDATE	DATUM	DATS	8	0	CAE invoice due date
18	EI_FLAG	☐	J_1AEIFLAG	J_1AEIFLAG	CHAR	1	0	Flag to mark creation of EI in Annexure V format
19	CAE_AENAM	☐	J_1AAENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
20	CAE_AEDAT	☐	J_1AAEDAT	DATUM	DATS	8	0	Date of Last Change
21	CUST_EI_FLAG	☐	J_1ACUST_EI	J_1ACUST_EI	CHAR	1	0	Flag to indicate electronic invoicing applicable for custome
22	SALES_SERV_IND	☐	J_1ASALSERIND	J_1ASALSERIND	CHAR	1	0	Goods or Service Invoices
23	UNIQUE_EXP_CODE	☐	UNIQUE_EXP_CODE	UNIQUE_EXP_CODE	NUMC	10	0	Unique Code to Identify Export Documents
24	REASON_CONTING	☐	J_1ACONRESAON	CHAR20	CHAR	20	0	Contingency Reason for CAE Invoice
25	CONTING_FLAG	☐	J_1ACONFLAG		CHAR	1	0	Processing Contingency Document
26	CONTING_TIME	☐	J_1ACONTIME	TIME8	TIMS	6	0	Contingency Time
27	CONTING_DATE	☐	J_1ACONDATE	DATUM	DATS	8	0	Contingency Date
28	CONTIN_BRNCH	☐	J_1ACONBRNCH	J_1BBRANCH	CHAR	4	0	Contingency Branch	*
29	RFC_SENT_DATE	☐	J_1ARFCSENTDATE	DATUM	DATS	8	0	RFC Sent Date
30	RFC_SENT_TIME	☐	J_1ARFCSENTTIME	TIME8	TIMS	6	0	RFC Sent Time
31	RFC_SENT_LOCK	☐	J_1ARFCSENTLOCK	J_1ARFCSENTLOCK	CHAR	1	0	RFC Sent Lock
32	XMLMESSAGEID	☐	J_1A_WS_XMLMSGID	J_1A_WS_XMLMSGID	CHAR	32	0	XML Message ID
33	UNIQ_EXP_WS_ID	☐	J_1A_WS_UNIQEXPID	J_1A_WS_UNIQEXPID	NUMC	15	0	AR: WS Unique Code to Identify Export Documents

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1ACAE	BRNCH	J_1BBRANCH	BRANCH	KEY	1	CN
2	J_1ACAE	BUKRS	T001	BUKRS	KEY	1	CN
3	J_1ACAE	DOCCLS	J_1ADOCCLS	J_1ACOCCLS		1	CN
4	J_1ACAE	J_1APRTCHR	J_1APRTCHR	J_1APRTCHR		1	CN
5	J_1ACAE	KUNNR	KNA1	KUNNR
6	J_1ACAE	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	605