1. Home
  2. Resources
  3. SAP Tables
  4. AFFLDGET - AFFLD structure with VBKZ

SAP Table AFFLDGET

AFFLD structure with VBKZ

AFFLDGET (AFFLD structure with VBKZ) 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 AFFLDGET to other SAP tables.

Source: AFFLDGET (AFFLD structure with VBKZ)

AFFLDGET 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
VORNR1 Number of the branch operation VORNR1 CHAR 4 0
VORNR2 Number of the return operation VORNR2 CHAR 4 0
TXTKZ Indicator: long text exists TXTKZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
INDBT Field defined as in SY-TABIX TABIX_D INT4 10 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
FLG_LOE Indicator: Sequence is deleted (printing) FLG_SEQLOE 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
VBKZ Update indicator VBKZ CHAR 1 0
I Insert
U Update
D Delete

AFFLDGET foreign key relationships

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