SAP Table AFFT
Order - Process Instructions
AFFT (Order - Process Instructions) 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 AFFT to other SAP tables.
AFFT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||
|
AUFPL
Routing number of operations in the order
|
CO_AUFPL |
NUMC
|
10 | 0 | ||||||||
|
APLZL
General counter for order
|
CO_APLZL |
NUMC
|
8 | 0 | ||||||||
|
APHZL
Internal Sub-Calculation Number
|
PLNPH |
NUMC
|
8 | 0 | ||||||||
|
AFTZL
Internal process instruction number
|
PLNFT |
NUMC
|
8 | 0 | ||||||||
|
PLNTY
Task List Type
|
PLNTY |
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 | ||||||||
|
ZAEHL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||
|
FTRNR
Line Number of Process Instruction
|
R_FTNR |
CHAR
|
4 | 0 | ||||||||
|
CSTYP
Object type: proc.message category or proc. instr. category
|
CO_CSTYP |
CHAR
|
2 | 0 | ||||||||
|
||||||||||||
|
COSTR
Process instruction category
|
R_COSTR | TC50 |
CHAR
|
8 | 0 | |||||||
|
CSKTX
Short description of process instruction
|
R_CSKTX |
CHAR
|
40 | 0 | ||||||||
|
FTTYP
Type of process instruction
|
CO_FTTYP |
CHAR
|
1 | 0 | ||||||||
|
FTRNI
Line Number of Process Instruction
|
R_FTNR |
CHAR
|
4 | 0 | ||||||||
|
AENNR
Change Number
|
AENNR |
CHAR
|
12 | 0 | ||||||||
AFFT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| AFFT | COSTR | AFFT | MANDT |
TC50
PP-PI: Proc.Message Categories/ Proc.Instruction Categories
|
MANDT |
| AFFT | COSTR | CAUFVD | WERKS |
TC50
PP-PI: Proc.Message Categories/ Proc.Instruction Categories
|
WERKS |
| AFFT | COSTR | AFFT | CSTYP |
TC50
PP-PI: Proc.Message Categories/ Proc.Instruction Categories
|
CSTYP |
| AFFT | COSTR | AFFT | COSTR |
TC50
PP-PI: Proc.Message Categories/ Proc.Instruction Categories
|
COSTR |