SAP table AFFLB (Order: Document table structure for AFFL)

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
Normal object
+ Object created
- Object is to be deleted
0 Zero Object
C Object changed
M Object reassigned
CH_PROC Process that has lead to the change of an object CHAR 1 0 OCM_CH_PROC
Not changed
1 Manually changed
2 Change sales order
3 Release of change number
4 Change assembly order
5 Change number supplement
6 Change number shift
7 Direct assignment
VBKZ Update indicator CHAR 1 0 VBKZ
FLG_SEL Selection flag CHAR 1 0 SELKZ
Not selected
* Selected and processed
X Selected but not yet processed
AUFNR_T Order Number CHAR 12 0 * AUFNR
FLG_CALCUL Indicator: Order (network etc.) still to be calculated CHAR 1 0 FLG_CALC
COMP_RES OCM: Result of comparison of two order objects CHAR 1 0 OCM_COMP_RES
A '+' object also exists
D '<>' Object differs from comparison object
E '=' Objects are equal
M '-' Object missing
VSNMR Number or description of a version CHAR 12 0 VSNMR

AFFLB foreign key relationships

Table Field Check Table Check Field
0 AFFLB AENNR AENR Change Master AENNR
1 AFFLB AUSCHL TCA52 Alignment key used for scheduling parallel sequences AUSCHL
0 AFFLB BSCHL1 TCA50 Relationship key for ref. operations of parallel sequences TSCHL
1 AFFLB BSCHL2 TCA50 Relationship key for ref. operations of parallel sequences TSCHL
0 AFFLB FLGAT TCA07 Sequence categories FLGAT
1 AFFLB MANDT T000 Clients MANDT
0 AFFLB OBJNR ONR00 General Object Number MANDT
1 AFFLB PLNTY TCA01 Task list types MANDT
0 AFFLB TXTSP T002 Language Keys (Component BC-I18) SPRAS