1. Home
  2. Resources
  3. SAP Tables
  4. AFFLB - Order: Document table structure for AFFL

SAP Table AFFLB

Order: Document table structure for AFFL

AFFLB (Order: Document table structure for AFFL) 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 AFFLB to other SAP tables.

AFFLB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL Internal counter CIM_COUNT NUMC 8 0
PLNTY Task List Type PLNTY TCA01 CHAR 1 0
PLNNR Key for Task List Group PLNNR CHAR 8 0
PLNAL Group Counter PLNAL CHAR 2 0
PLNFL Sequence PLNFOLGE CHAR 6 0
ZAEHL Internal counter CIM_COUNT NUMC 8 0
AENNR Change Number AENNR AENR CHAR 12 0
FLGAT Sequence category FOLGENART TCA07 CHAR 1 0
BEZFL Reference sequence for a sequence BEZFL CHAR 6 0
BKNT1 Reference node for start of a sequence BEZKNTANF NUMC 8 0
BKNT2 Finish reference node of a sequence BEZKNTEND NUMC 8 0
LTXA1 Sequence description FLGTEXT CHAR 40 0
TXTSP Language Key SPRAS T002 LANG 1 0
LOSVN From lot size CP_FLGLOSV QUAN 13 3
LOSBS To lot size CP_FLGLOSB QUAN 13 3
BSCHL1 Relationship key for branch operation of parallel sequences CP_BSCHL1 TCA50 CHAR 1 0
BSCHL2 Relationship key for return operation of parallel sequences CP_BSCHL2 TCA50 CHAR 1 0
AUSCHL Alignment key for scheduling CP_AUSCHL TCA52 CHAR 1 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
OBJTYPE Change indicator OCM_OBJ_TYPE CHAR 1 0
+ Object created
- Object is to be deleted
C Object changed
M Object reassigned
NULL Normal object
0 Zero Object
CH_PROC Process that has lead to the change of an object OCM_CH_PROC CHAR 1 0
NULL 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 VBKZ CHAR 1 0
I Insert
U Update
D Delete
FLG_SEL Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
AUFNR_T Order Number AUFNR CHAR 12 0
FLG_CALCUL Indicator: Order (network etc.) still to be calculated FLG_CALC CHAR 1 0
X
NULL
COMP_RES OCM: Result of comparison of two order objects OCM_COMP_RES CHAR 1 0
E '=' Objects are equal
A '+' object also exists
M '-' Object missing
D '<>' Object differs from comparison object
VSNMR Number or description of a version VSNMR CHAR 12 0

AFFLB foreign key relationships

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