SAP table DFKKEXTDOC (Official Document Number with Attributes)
SAP table DFKKEXTDOC has 3 primary key fields being MANDT,EXKEY,EXKID.
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
EXKEY
Official Document Number Key
CHAR
40
0
EXKEY_KK
EXKID
Key Identification
CHAR
2
0
EXKID_KK
01
Posting Document in Contract A/R and A/P
02
Not Used
03
Invoicing Document in FI-CA
R4
IS-U Invoicing Document
EXBEL
Official Document Number
CHAR
16
0
EXBEL_KK
CANCEL
Status of Official Document Number
CHAR
1
0
EXSTA_KK
Other document
C
Reversed document
T
Transfer Posting Document
GPART
Business Partner Number
CHAR
10
0
*
GPART_KK
BRANCH
Branch
CHAR
4
0
*
BRANCH_KK
ATTRIBUTE1
Attribute For Official Document Number
CHAR
8
0
ATTRIBUTE_KK
ATTRIBUTE2
Attribute For Official Document Number
CHAR
8
0
ATTRIBUTE_KK
ATTRIBUTE3
Attribute For Official Document Number
CHAR
8
0
ATTRIBUTE_KK
ATTRIBUTE4
Attribute For Official Document Number
CHAR
20
0
ATTRIBUTE20_KK
ATTRIBUTE5
Attribute For Official Document Number
CHAR
20
0
ATTRIBUTE20_KK
OBJECT
Number Range Object
CHAR
10
0
*
NROBJ
SUBOBJECT
Number range object subobject value
CHAR
6
0
NRSOBJ
NRRANGENR
Number range number
CHAR
2
0
NRNR
TOYEAR
To fiscal year
NUMC
4
0
NRYEAR
DOCCLS
Document Class for Official Document Numbers
CHAR
4
0
*
DOCCLS_KK
PT_DOC_DATE
Document Date in Document
DATS
8
0
BLDAT
PT_SYS_DATE
Day On Which Accounting Document Was Entered
DATS
8
0
CPUDT
PT_SYS_TIME
Time of Entry
TIMS
6
0
CPUTM
PT_TOTAL_AMOUNT
Digital Signature PT: Total Amount in Local Currency