SAP Table TE221

Operands

TE221 (Operands) 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 TE221 to other SAP tables.

TE221 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
OPERAND Operand E_OPERAND CHAR 10 0
SPARTE Division SPARTE TESPT CHAR 2 0
OPTYP Operand category E_OPTYP TE375 CHAR 8 0
MASS Unit of Measurement E_MASS T006 UNIT 3 0
ORGWERT Indicator: second value is permitted ORGWERT CHAR 1 0
NULL Only value relevant to billing can be maintained
X Val. relevant to billing and original val. can be maintained
TAZUORD Indicator: allocation to a rate type is required TAZUORD CHAR 1 0
NULL No rate type must be specified
X Rate type must be specified
RUNDUNG Starting Point for Rounding E_RUNDUNG CHAR 2 0
NULL No rounding
-9 Rounding to 9 places before the decimal point
-8 Rounding to 8 places before the decimal point
-7 Rounding to 7 places before the decimal point
-6 Rounding to 6 places before the decimal point
-5 Rounding to 5 places before the decimal point
-4 Rounding to 4 places before the decimal point
-3 Rounding to 3 places before the decimal point
-2 Rounding to 2 places before the decimal point
-1 Rounding to 1 places before the decimal point
0 Rounding to whole numbers
+1 Rounding to 1 decimal place
+2 Rounding to 2 decimal places
+3 Rounding to 3 decimal places
+4 Rounding to 4 decimal places
+5 Rounding to 5 decimal places
+6 Rounding to 6 decimal places
+7 Rounding to 7 decimal places
+8 Rounding to 8 decimal places
+9 Rounding to 9 decimal places
RUNDART Rounding Category RUNDART CHAR 1 0
+ Round up
- Round down
X Round to nearest whole number
LEISTALL Control of which demand values are used LEISTALL CHAR 1 0
NULL Each month only the highest demand is used
X All demands are used
LEISTMONAT Control of demand validity period LEISTMONAT CHAR 1 0
NULL Demand is valid for whole billing period
X Demand is billed separately per (allocation) month
BZGART Type of reference value BZGART CHAR 1 0
1 Standard
2 Lighting
3 Heating installation
4 Container
5 Property
UMZUGKZ Control of Whether Values are Kept in Move-In/Out UMZUGKZ CHAR 1 0
0 Values become invalid on move-in/out date
1 Values for customer kept if installation is the same
2 Values in the installation kept
HISTSTEU Control of historical maintainability of operand values HISTSTEU CHAR 1 0
0 No restriction: specification for operand cat. is valid
1 Change only permitted up to start of current billing period
2 Change only permitted up to start of backbilling period
3 No historical change permitted
ABLESGRUP MR group for controlling decimal places to be read ABLESGRUP TE017 CHAR 8 0
GEWKEY Weighting key for proration of operands GEWKEY_PR TE266 CHAR 8 0
SELCONTROL Access control for operands SELCONTROL CHAR 2 0
00 All values in billing period are taken into account
01 Value at end of rate period is valid
02 Value at key date is valid
03 Value at end of billing period is valid
04 All values in month-related billing period
05 Value at start of billing period is valid
06 Value at Customer-Defined Date is Valid
PEAK_NO Number of demand peaks PEAK_NO NUMC 2 0
01 Number of peaks required for calculating average
SEASONFLAG Indicator: determination of demand is season-related SEASONFLAG CHAR 1 0
NULL Field inactive
X Field active
FRAN_TYPE Franchise Fee Category FRAN_TYPE CHAR 1 0
NULL No franchise tax
1 franchise tax: customer contribution
2 franchise tax: company contribution
REG_OPERAND Indicator: operand is a register operand REG_OPERAND CHAR 1 0
NULL Field inactive
X Field active
DEMAND_AS_IS Indicator: bill demand as it is in the facts (unchanged) DEMAND_AS_IS CHAR 1 0
NULL Field inactive
X Field active
ALLHISTORY Indicator: complete history is permissible ALLHISTORY CHAR 1 0
NULL Field inactive
X Field active
USE_UDEFVAL1 Use value 1 for operand category USERDEF USE_UDEFVAL1 CHAR 1 0
NULL Field inactive
X Field active
USE_UDEFVAL2 Use value 2 for operand category USERDEF USE_UDEFVAL2 CHAR 1 0
NULL Field inactive
X Field active
USE_UDEFVAL3 Use value 3 for operand category USERDEF USE_UDEFVAL3 CHAR 1 0
NULL Field inactive
X Field active
USE_UDEFVAL4 Use value 4 for operand category USERDEF USE_UDEFVAL4 CHAR 1 0
NULL Field inactive
X Field active
OPGROUP Operand group OPGROUP EOPGROUP CHAR 10 0
ACTFACTIND "Demand active" can be maintained in the facts ACTFACTIND CHAR 1 0
NULL Field inactive
X Field active
NODIALOGINST Not Permissible to Maintain Operand for Installation NODIALOGINST CHAR 1 0
NULL Field inactive
X Field active
NODIALOGRCAT Not Permissible to Maintain Operand for Rate Category NODIALOGRCAT CHAR 1 0
NULL Field inactive
X Field active
NODIALOGRATE Not permissible to maintain operand for rate NODIALOGRATE CHAR 1 0
NULL Field inactive
X Field active
CONREL Contract-Relevant Operand CONREL CHAR 1 0
NULL Field inactive
X Field active
RTPOPERAND Operand from RTP interface RTPOPERAND CHAR 1 0
NULL Field inactive
X Field active
PRODREL Product-Related Operand PRODREL CHAR 1 0
NULL Field inactive
X Field active
WASTEREL Operand with Special Provision of Values WASTEREL CHAR 2 0
01 Disposal-specific fact group analysis
02 Supply values via allocation operand<->field name
CONSTYPE Consumption Type E_CONSTYPE TE222 CHAR 4 0
BWREL Operand is BW-Relevant E_BWREL CHAR 1 0
NULL Operand is not BW-Relevant
X Operand is BW-Relevant
PRORATE_DAILY Daily Proration in Billing PRORATE_DAILY CHAR 1 0
NULL Field inactive
X Field active
ERCHVREL Supply Using ERCHV E_ERCHVREL CHAR 1 0
NULL Field inactive
X Field active
CONDIREL Filled During Conditional Billing E_CONDIREL CHAR 1 0
NULL Field inactive
X Field active

TE221 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TE221 ABLESGRUP TE221 MANDT TE017 Meter Reading Group MANDT
TE221 ABLESGRUP TE221 ABLESGRUP TE017 Meter Reading Group ABLESGRUP
TE221 CONSTYPE TE221 MANDT TE222 Consumption Types MANDT
TE221 CONSTYPE TE221 CONSTYPE TE222 Consumption Types CONSTYPE
TE221 GEWKEY TE221 MANDT TE266 User-Defined Weighting Keys MANDT
TE221 GEWKEY TE221 GEWKEY TE266 User-Defined Weighting Keys GEWKEY
TE221 MASS TE221 MASS T006 Units of Measurement MSEHI
TE221 MASS TE221 MANDT T006 Units of Measurement MANDT
TE221 OPGROUP TE221 MANDT EOPGROUP Operand Groups MANDT
TE221 OPGROUP TE221 OPGROUP EOPGROUP Operand Groups OPGROUP
TE221 OPTYP TE221 OPTYP TE375 Operand Categories OPTYP
TE221 SPARTE TE221 MANDT TESPT Alloc. of Div. Cat. to Div. MANDT
TE221 SPARTE TE221 SPARTE TESPT Alloc. of Div. Cat. to Div. SPARTE