SAP table TIVCDCALCEXT (External Calculation Formula)

SAP table TIVCDCALCEXT has 2 primary key fields being MANDT,CALCRULEEXT.

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
CALCRULEEXT External Calculation Formula CHAR 4 0 RECDCALCRULEEXT
CALCRULEINT Internal Calculation Formula NUMC 4 0 TIVCDCALCINT RECDCALCRULEINT
CALCRULEPARA1 Untypified Parameter for a Calculation Formula CHAR 70 0 RECDCALCRULEPARA
CALCRULEPAMOCU1 Field Modification Calculation and Distrib. Rule-Customizing CHAR 1 0 RECDRULESMODCUST
0 No entry allowed
1 Entry allowed
CALCRULEPAMOAP1 Field Modification Calculation and Distrib. Rule-Application CHAR 1 0 RECDRULESMODAPPL
0 Required Entry
1 Optional Entry
2 Display
3 Hide
CALCRULEPARA2 Untypified Parameter for a Calculation Formula CHAR 70 0 RECDCALCRULEPARA
CALCRULEPAMOCU2 Field Modification Calculation and Distrib. Rule-Customizing CHAR 1 0 RECDRULESMODCUST
0 No entry allowed
1 Entry allowed
CALCRULEPAMOAP2 Field Modification Calculation and Distrib. Rule-Application CHAR 1 0 RECDRULESMODAPPL
0 Required Entry
1 Optional Entry
2 Display
3 Hide
CALCRULENODIST Distribution Formula Independent of Calculation Formula? CHAR 1 0 RECDCALCRULENODIST
DISTRULEEXT External Distribution Formula CHAR 4 0 TIVCDDISTEXT RECDDISTRULEEXT
CALCRULEMOD Modifiable Calculation Factors CHAR 1 0 RECDCALCRULEMOD
ROUNDTYPE Rounding Category of Unit Price NUMC 1 0 RECDROUNDTYPE
0 No Rounding
1 Currency Rounding
2 Round Down
3 Round Up
4 Arithmetic Rounding
8 Arithmetic (0.5 Rounded Down)
ROUNDDECIMAL No. of decimal places to which rounding should be performed INT2 5 0 RECDROUNDDECIMAL
ROUNDUNIT Unit to be rounded up to NUMC 4 0 RECDROUNDUNIT
CAROUNDTYPE Rounding Category of Condition Amount NUMC 1 0 RECDROUNDCDTYPE
0 No Rounding
1 Currency Rounding
2 Round Down After Currency Rounding
3 Round Up After Currency Rounding
4 Arithmetic After Currency Rounding
5 Round Down Directly
6 Round Up Directly
7 Direct Arithmetic
8 Direct Arithmetic (0.5 Rounded Down)
CAROUNDDECIMAL No. of decimal places to which rounding should be performed INT2 5 0 RECDROUNDDECIMAL
CAROUNDUNIT Unit to be rounded up to NUMC 4 0 RECDROUNDUNIT
CAROUNDGRNE Gross or Net Rounding NUMC 1 0 RECDROUNDGRNE
0 Based on Gross/Net Indicator
1 Round Net for Net Conditions
2 Round Gross for Gross Conditions
3 Always Round Net
4 Always Round Gross
DISTCOMPLETE Full Distribution Is Mandatory CHAR 1 0 RECDDISTCOMPLETE
No Distribution of Rounding Differences
1 First Object Receives Difference
2 Last Object Receives Difference
X Random Distribution

TIVCDCALCEXT foreign key relationships

Table Field Check Table Check Field
0 TIVCDCALCEXT CALCRULEINT TIVCDCALCINT Internal Calculation Formula CALCRULEINT
1 TIVCDCALCEXT DISTRULEEXT TIVCDDISTEXT External Distribution Formula DISTRULEEXT