SAP table TIVCDDISTEXT (External Distribution Formula)
SAP table TIVCDDISTEXT has 2 primary key fields being MANDT,DISTRULEEXT.
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
DISTRULEEXT
External Distribution Formula
CHAR
4
0
RECDDISTRULEEXT
DISTRULEINT
Internal Distribution Formula
NUMC
4
0
TIVCDDISTINT
RECDDISTRULEINT
DISTRULEPARA1
Untypified Parameter for a Distribution Formula
CHAR
70
0
RECDDISTRULEPARA
DISTRULEPAMOCU1
Field Modification Calculation and Distrib. Rule-Customizing
CHAR
1
0
RECDRULESMODCUST
Possible values
0
No entry allowed
1
Entry allowed
DISTRULEPAMOAP1
Field Modification Calculation and Distrib. Rule-Application
CHAR
1
0
RECDRULESMODAPPL
Possible values
0
Required Entry
1
Optional Entry
2
Display
3
Hide
DISTRULEPARA2
Untypified Parameter for a Distribution Formula
CHAR
70
0
RECDDISTRULEPARA
DISTRULEPAMOCU2
Field Modification Calculation and Distrib. Rule-Customizing
CHAR
1
0
RECDRULESMODCUST
Possible values
0
No entry allowed
1
Entry allowed
DISTRULEPAMOAP2
Field Modification Calculation and Distrib. Rule-Application
CHAR
1
0
RECDRULESMODAPPL
Possible values
0
Required Entry
1
Optional Entry
2
Display
3
Hide
OBJTYPEDIST
Object Type for Distribution
NUMC
1
0
RECDOBJTYPEDIST
OBJTYPEPOST
Object Type for Posting
NUMC
1
0
RECDOBJTYPEPOST
DISTRULEMOD
Distribution Factors Are Modifiable
CHAR
1
0
RECDDISTRULEMOD
DIRECTDIST
Direct Distribution to Object, If Object Is Unique
CHAR
1
0
RECDDIRECTDIST
CHDICOMPLETENESS
Check on Completeness of Distribution
CHAR
1
0
RECDCHDICOMPLETENESS
DISTCOMPLETE
Full Distribution Is Mandatory
CHAR
1
0
RECDDISTCOMPLETE
Possible values
No Distribution of Rounding Differences
1
First Object Receives Difference
2
Last Object Receives Difference
X
Random Distribution
TIVCDDISTEXT foreign key relationships
Table
Field
Check Table
Check Field
0 TIVCDDISTEXT
DISTRULEINT
TIVCDDISTINT
Internal Distribution Formula
DISTRULEINT