SAP Table TIVCDCALCEXT

External Calculation Formula

TIVCDCALCEXT (External Calculation Formula) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TIVCDCALCEXT to other SAP tables.

TIVCDCALCEXT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
CALCRULEEXT External Calculation Formula RECDCALCRULEEXT CHAR 4 0
CALCRULEINT Internal Calculation Formula RECDCALCRULEINT TIVCDCALCINT NUMC 4 0
CALCRULEPARA1 Untypified Parameter for a Calculation Formula RECDCALCRULEPARA CHAR 70 0
CALCRULEPAMOCU1 Field Modification Calculation and Distrib. Rule-Customizing RECDRULESMODCUST CHAR 1 0
0 No entry allowed
1 Entry allowed
CALCRULEPAMOAP1 Field Modification Calculation and Distrib. Rule-Application RECDRULESMODAPPL CHAR 1 0
0 Required Entry
1 Optional Entry
2 Display
3 Hide
CALCRULEPARA2 Untypified Parameter for a Calculation Formula RECDCALCRULEPARA CHAR 70 0
CALCRULEPAMOCU2 Field Modification Calculation and Distrib. Rule-Customizing RECDRULESMODCUST CHAR 1 0
0 No entry allowed
1 Entry allowed
CALCRULEPAMOAP2 Field Modification Calculation and Distrib. Rule-Application RECDRULESMODAPPL CHAR 1 0
0 Required Entry
1 Optional Entry
2 Display
3 Hide
CALCRULENODIST Distribution Formula Independent of Calculation Formula? RECDCALCRULENODIST CHAR 1 0
X Yes
NULL No
DISTRULEEXT External Distribution Formula RECDDISTRULEEXT TIVCDDISTEXT CHAR 4 0
CALCRULEMOD Modifiable Calculation Factors RECDCALCRULEMOD CHAR 1 0
X Yes
NULL No
ROUNDTYPE Rounding Category of Unit Price RECDROUNDTYPE NUMC 1 0
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 RECDROUNDDECIMAL INT2 5 0
ROUNDUNIT Unit to be rounded up to RECDROUNDUNIT NUMC 4 0
CAROUNDTYPE Rounding Category of Condition Amount RECDROUNDCDTYPE NUMC 1 0
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 RECDROUNDDECIMAL INT2 5 0
CAROUNDUNIT Unit to be rounded up to RECDROUNDUNIT NUMC 4 0
CAROUNDGRNE Gross or Net Rounding RECDROUNDGRNE NUMC 1 0
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 RECDDISTCOMPLETE CHAR 1 0
NULL No Distribution of Rounding Differences
1 First Object Receives Difference
2 Last Object Receives Difference
X Random Distribution

TIVCDCALCEXT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TIVCDCALCEXT CALCRULEINT TIVCDCALCEXT CALCRULEINT TIVCDCALCINT Internal Calculation Formula CALCRULEINT
TIVCDCALCEXT DISTRULEEXT TIVCDCALCEXT MANDT TIVCDDISTEXT External Distribution Formula MANDT
TIVCDCALCEXT DISTRULEEXT TIVCDCALCEXT DISTRULEEXT TIVCDDISTEXT External Distribution Formula DISTRULEEXT