SAP AFFL Work order sequence Table
Overview
AFFL is a standard SAP S/4HANA table that stores Work order sequence data. There are total 23 fields in the AFFL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFFL belongs to Production Orders (PP-SFC) module and is located in the package Application Development ERP PP Production Orders (CO).
In addition, following links provide an overview of foreign key relationships, if any, that link AFFL to other SAP tables and standard CDS views available based on AFFL table in S/4HANA 2020.
Techincal Settings of AFFL
Below are technical details of the table AFFL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFFL Fields
The following table gives you an overview of the fields available in AFFL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL | Internal counter | CIM_COUNT | NUMC | 8 | |
| PLNTY | Task List Type | PLNTY | TCA01 | CHAR | 1 |
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | |
| PLNAL | Group Counter | PLNAL | CHAR | 2 | |
| PLNFL | Sequence | PLNFOLGE | CHAR | 6 | |
| ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | |
| AENNR | Change Number | AENNR | AENR | CHAR | 12 |
| FLGAT | Sequence Category | FOLGENART | TCA07 | CHAR | 1 |
| BEZFL | Reference Sequence | BEZFL | CHAR | 6 | |
| BKNT1 | Reference node for start of a sequence | BEZKNTANF | NUMC | 8 | |
| BKNT2 | Finish reference node of a sequence | BEZKNTEND | NUMC | 8 | |
| LTXA1 | Sequence Description | FLGTEXT | CHAR | 40 | |
| TXTSP | Language Key | SPRAS | T002 | LANG | 1 |
| LOSVN | Minimum Lot Size | CP_FLGLOSV | QUAN | 13 | |
| LOSBS | Maximum Lot Size | CP_FLGLOSB | QUAN | 13 | |
| BSCHL1 | Relationship key for branch operation of parallel sequences | CP_BSCHL1 | TCA50 | CHAR | 1 |
| BSCHL2 | Relationship key for return operation of parallel sequences | CP_BSCHL2 | TCA50 | CHAR | 1 |
| AUSCHL | Alignment Key for Scheduling | CP_AUSCHL | TCA52 | CHAR | 1 |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1 | |
| CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFFL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFFL | AENNR | 1: CN | AENR |
| AFFL | AUSCHL | C: CN | TCA52 |
| AFFL | BSCHL1 | C: CN | TCA50 |
| AFFL | BSCHL2 | C: CN | TCA50 |
| AFFL | FLGAT | : | TCA07 |
| AFFL | MANDT | 1: CN | T000 |
| AFFL | OBJNR | C: 1 | ONR00 |
| AFFL | PLNTY | 1: CN | TCA01 |
| AFFL | TXTSP | C: CN | T002 |