SAP table AFFLDGET (AFFLD structure with VBKZ)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||
| AUFPL | Routing number of operations in the order | NUMC | 10 | 0 | CO_AUFPL | ||||||||||||||||||
| APLZL | Internal counter | NUMC | 8 | 0 | CIM_COUNT | ||||||||||||||||||
| PLNTY | Task List Type | CHAR | 1 | 0 | TCA01 | PLNTY | |||||||||||||||||
| PLNNR | Key for Task List Group | CHAR | 8 | 0 | PLNNR | ||||||||||||||||||
| PLNAL | Group Counter | CHAR | 2 | 0 | PLNAL | ||||||||||||||||||
| PLNFL | Sequence | CHAR | 6 | 0 | PLNFOLGE | ||||||||||||||||||
| ZAEHL | Internal counter | NUMC | 8 | 0 | CIM_COUNT | ||||||||||||||||||
| AENNR | Change Number | CHAR | 12 | 0 | AENR | AENNR | |||||||||||||||||
| FLGAT | Sequence Category | CHAR | 1 | 0 | TCA07 | FOLGENART | |||||||||||||||||
| BEZFL | Reference Sequence | CHAR | 6 | 0 | BEZFL | ||||||||||||||||||
| BKNT1 | Reference node for start of a sequence | NUMC | 8 | 0 | BEZKNTANF | ||||||||||||||||||
| BKNT2 | Finish reference node of a sequence | NUMC | 8 | 0 | BEZKNTEND | ||||||||||||||||||
| LTXA1 | Sequence Description | CHAR | 40 | 0 | FLGTEXT | ||||||||||||||||||
| TXTSP | Language Key | LANG | 1 | 0 | T002 | SPRAS | |||||||||||||||||
| LOSVN | Minimum Lot Size | QUAN | 13 | 3 | CP_FLGLOSV | ||||||||||||||||||
| LOSBS | Maximum Lot Size | QUAN | 13 | 3 | CP_FLGLOSB | ||||||||||||||||||
| BSCHL1 | Relationship key for branch operation of parallel sequences | CHAR | 1 | 0 | TCA50 | CP_BSCHL1 | |||||||||||||||||
| BSCHL2 | Relationship key for return operation of parallel sequences | CHAR | 1 | 0 | TCA50 | CP_BSCHL2 | |||||||||||||||||
| AUSCHL | Alignment Key for Scheduling | CHAR | 1 | 0 | TCA52 | CP_AUSCHL | |||||||||||||||||
| OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR | |||||||||||||||||
| OBJTYPE | Change indicator | CHAR | 1 | 0 | OCM_OBJ_TYPE |
|
|||||||||||||||||
| CH_PROC | Process that has lead to the change of an object | CHAR | 1 | 0 | OCM_CH_PROC |
|
|||||||||||||||||
| VORNR1 | Number of the Branch Operation | CHAR | 4 | 0 | VORNR1 | ||||||||||||||||||
| VORNR2 | Number of the Return Operation | CHAR | 4 | 0 | VORNR2 | ||||||||||||||||||
| TXTKZ | Long Text Exists | CHAR | 1 | 0 | TXTKZ | ||||||||||||||||||
| INDBT | Field defined as in SY-TABIX | INT4 | 10 | 0 | TABIX_D | ||||||||||||||||||
| AUFNR | Order Number | CHAR | 12 | 0 | AUFK | AUFNR | |||||||||||||||||
| FLG_LOE | Indicator: Sequence is deleted (printing) | CHAR | 1 | 0 | FLG_SEQLOE | ||||||||||||||||||
| COMP_RES | OCM: Result of comparison of two order objects | CHAR | 1 | 0 | OCM_COMP_RES |
|
|||||||||||||||||
| VSNMR | Number or description of a version | CHAR | 12 | 0 | VSNMR | ||||||||||||||||||
| VBKZ | Update indicator | CHAR | 1 | 0 | VBKZ |
AFFLDGET foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 AFFLDGET | AENNR | AENR | Change Master | AENNR |
| 1 AFFLDGET | AUFNR | AUFK | Order master data | AUFNR |
| 0 AFFLDGET | AUSCHL | TCA52 | Alignment key used for scheduling parallel sequences | AUSCHL |
| 1 AFFLDGET | BSCHL1 | TCA50 | Relationship key for ref. operations of parallel sequences | TSCHL |
| 0 AFFLDGET | BSCHL2 | TCA50 | Relationship key for ref. operations of parallel sequences | TSCHL |
| 1 AFFLDGET | FLGAT | TCA07 | Sequence categories | FLGAT |
| 0 AFFLDGET | MANDT | T000 | Clients | MANDT |
| 1 AFFLDGET | OBJNR | ONR00 | General Object Number | MANDT |
| 0 AFFLDGET | PLNTY | TCA01 | Task list types | MANDT |
| 1 AFFLDGET | TXTSP | T002 | Language Keys (Component BC-I18) | SPRAS |