SAP Table CFIN_AIF_IDX_OBJ (Central Finance: AIF Message Key Fields For Cost Object)
SAP table CFIN_AIF_IDX_OBJ has 2 primary key fields being MANDT,MSGGUID.
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
MANDT
MSGGUID
GUID in 'CHAR' Format in Uppercase
CHAR
32
0
GUID_32
NS
Namespace
CHAR
6
0
/AIF/T_NS
/AIF/NS
IFNAME
Interface Name
CHAR
10
0
/AIF/T_FINF
/AIF/IFNAME
IFVER
Interface Version
CHAR
5
0
/AIF/T_FINF
/AIF/IFVERSION
NUMBEROFABORTS
Abort Number
INT4
10
0
/AIF/NUMBEROFABORTS
NUMBEROFERRORS
Error Number
INT4
10
0
/AIF/NUMBEROFERRORS
NUMBEROFWARNINGS
Warning Number
INT4
10
0
/AIF/NUMBEROFWARNINGS
NUMBEROFSUCCESS
Success Number
INT4
10
0
/AIF/NUMBEROFSUCCESS
NUMBEROFINFOS
Information Number
INT4
10
0
/AIF/NUMBEROFINFOS
NSRECIP
Namespace
CHAR
6
0
*
/AIF/NS
RECIPIENT
Alert Management Recipient
CHAR
30
0
*
/AIF/ALRT_REC
STATUS
Processing Status
CHAR
1
0
/AIF/PROC_STATUS
A
Technical Error
C
Canceled
E
Application Error
I
In Process
S
Successful
W
Successful with Warnings
SUB_STATUS
Sub status for 'In Process' status
CHAR
1
0
/AIF/PROC_SUB_STATUS
No sub status
A
Automatic Reprocessing
B
Blocked by predecessor
E
Error in job processing
P
Processing
W
Waiting to be processed
AIF_LOCATION
Message Location
CHAR
1
0
/AIF/MESSAGE_LOCATION
1
Before AIF process
2
In AIF mapping process
3
In AIF action process
4
In Proxy Framework process
5
In PI process
6
In AIF outbound buffer
7
After AIF process
8
Intermediate (before calling standard IDoc function)
LOGNUMBER
Application Log: Log Number
CHAR
20
0
*
BALOGNR
TRACE_LEVEL
AIF Trace Level
CHAR
1
0
/AIF/TRACE_LEVEL
Not defined
0
Level 0
1
Level 1
2
Level 2
3
Level 3
TL_EXP_DATE
Expiration Date
DATS
8
0
/AIF/EXP_DATE
TL_EXP_TIME
Expiration Time
TIMS
6
0
/AIF/EXP_TIME
CREATE_USER
Create User
CHAR
12
0
/AIF/CREATE_USER
CREATE_DATE
Creation Date
DATS
8
0
/AIF/CREATE_DATE
CREATE_TIME
Creation Time
TIMS
6
0
/AIF/CREATE_TIME
LAST_USER
Last User
CHAR
12
0
/AIF/LAST_USER
LAST_DATE
Last Date
DATS
8
0
/AIF/LAST_DATE
LAST_TIME
Last Time
TIMS
6
0
/AIF/LAST_TIME
END_USER
End User
CHAR
12
0
/AIF/END_USER
END_DATE
End Date
DATS
8
0
/AIF/END_DATE
END_TIME
End Time
TIMS
6
0
/AIF/END_TIME
AIF_ALERT_ID
External ID for an Alert
NUMC
5
0
SALRTEXTID
AIF_VARIANT_NS
Variant Namespace
CHAR
6
0
/AIF/VARIANT_NS
AIF_VARIANT_NAME
Name of Interface Variant
CHAR
20
0
/AIF/VARIANT_NAME
EXTERNAL_MESSAGE
Indicates source of message: internal or extenal (e.g CPI)
NUMC
2
0
/AIF/EXTERNAL_MESSAGE
00
internal message
10
CPI error message
TIME_ZONE
Time Zone
CHAR
6
0
*
TZNZONE
PROCESSING_END_TSTMP
Message Processing Timestamp in UTC Timezone
DEC
15
0
/AIF/PROCESSING_TSTMP
PID
Integration Engine: Pipeline ID
CHAR
40
0
SXMSPID
LOGSYS
Logical system
CHAR
10
0
LOGSYS
AUFNR
Order Number
CHAR
12
0
AUFNR
AUFTYP
Order category
NUMC
2
0
AUFTYP
01
Internal Order (Controlling)
02
Accrual Calculation Order (Controlling)
03
Model Order (Controlling)
04
CO Production Order
05
Product Cost Collector
06
QM Order
10
PP Production Order
20
Network
30
Maintenance order
40
Process Order
50
Inspection Lot
60
Personnel Order
70
Shipping deadlines
99
Master Planned order
AUFART
Order Type
CHAR
4
0
AUFART
SUCCESS
Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')