SAP Table AFFV
Order - Process Instruction Values
AFFV (Order - Process Instruction Values) 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 AFFV to other SAP tables.
AFFV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||
|
AUFPL
Routing number of operations in the order
|
CO_AUFPL |
NUMC
|
10 | 0 | ||||||||||||||||
|
APLZL
General counter for order
|
CO_APLZL | AFVC |
NUMC
|
8 | 0 | |||||||||||||||
|
APHZL
Internal Sub-Calculation Number
|
PLNPH |
NUMC
|
8 | 0 | ||||||||||||||||
|
AFTZL
Internal process instruction number
|
PLNFT |
NUMC
|
8 | 0 | ||||||||||||||||
|
AFVZL
Internal PI characteristic/characteristic value number
|
PLNFV |
NUMC
|
8 | 0 | ||||||||||||||||
|
PLNTY
Task List Type
|
PLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||||||||
|
PLNNR
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||||||||
|
PLNKN
Number of the task list node
|
PLNKN |
NUMC
|
8 | 0 | ||||||||||||||||
|
PLNPH
Internal Sub-Calculation Number
|
PLNPH |
NUMC
|
8 | 0 | ||||||||||||||||
|
PLNFT
Internal process instruction number
|
PLNFT |
NUMC
|
8 | 0 | ||||||||||||||||
|
PLNFV
Internal PI characteristic/characteristic value number
|
PLNFV |
NUMC
|
8 | 0 | ||||||||||||||||
|
ZAEHL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||||||||
|
FVLNR
Line Number of Process Instruction Characteristic
|
R_FVNR |
CHAR
|
4 | 0 | ||||||||||||||||
|
ATINN
Internal characteristic
|
ATINN |
NUMC
|
10 | 0 | ||||||||||||||||
|
ATZHL
Int counter
|
ATZHL |
NUMC
|
4 | 0 | ||||||||||||||||
|
ATWRT
Characteristic Value
|
ATWRT |
CHAR
|
30 | 0 | ||||||||||||||||
|
ATFLV
Internal floating point from
|
ATFLV |
FLTP
|
16 | 16 | ||||||||||||||||
|
ATFLB
Internal floating point value to
|
ATFLB |
FLTP
|
16 | 16 | ||||||||||||||||
|
ATCOD
Code for value dependency
|
ATCOD |
CHAR
|
1 | 0 | ||||||||||||||||
|
ATAWE
Alternative unit
|
ATAWE | T006 |
UNIT
|
3 | 0 | |||||||||||||||
|
ATAW1
Alternative unit
|
ATAWE | T006 |
UNIT
|
3 | 0 | |||||||||||||||
|
ATFOR
Data type of characteristic
|
ATFOR |
CHAR
|
4 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
WRTKZ
Indicator: Characteristic value assigned
|
CO_WRTKZ |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
TXTSP
Language Key
|
LANGU | T002 |
LANG
|
1 | 0 | |||||||||||||||
|
AENNR
Change Number
|
AENNR |
CHAR
|
12 | 0 | ||||||||||||||||
AFFV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| AFFV | APLZL | AFFV | MANDT |
AFVC
Operation within an order
|
MANDT |
| AFFV | APLZL | AFFV | AUFPL |
AFVC
Operation within an order
|
AUFPL |
| AFFV | APLZL | AFFV | APLZL |
AFVC
Operation within an order
|
APLZL |
| AFFV | ATAW1 | AFFV | ATAW1 |
T006
Units of Measurement
|
MSEHI |
| AFFV | ATAW1 | AFFV | MANDT |
T006
Units of Measurement
|
MANDT |
| AFFV | ATAWE | AFFV | MANDT |
T006
Units of Measurement
|
MANDT |
| AFFV | ATAWE | AFFV | ATAWE |
T006
Units of Measurement
|
MSEHI |
| AFFV | MANDT | AFFV | MANDT |
T000
Clients
|
MANDT |
| AFFV | PLNTY | AFFV | MANDT |
TCA01
Task list types
|
MANDT |
| AFFV | PLNTY | AFFV | PLNTY |
TCA01
Task list types
|
PLNTY |
| AFFV | TXTSP | AFFV | TXTSP |
T002
Language Keys (Component BC-I18)
|
SPRAS |