VSAFFL_CN SAP (Version: Order sequences PP orders) Table details
Dictionary Type: Table
Description: Version: Order sequences PP orders
Description: Version: Order sequences PP orders
Table field list including key, data, relationships and ABAP select examples
VSAFFL_CN is a standard SAP Table which is used to store Version: Order sequences PP orders data and is available within R/3 SAP systems depending on the version and release level.
The VSAFFL_CN table consists of various fields, each holding specific information or linking keys about Version: Order sequences PP orders data available in SAP. These include VSNMR (Number or description of a version), AUFPL (Routing number of operations in the order), APLZL (Internal counter), PLNTY (Task List Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP VSAFFL_CN table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VSNMR | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
PLNTY | Task List Type | PLNTY | CHAR | 1 | TCA01 | PLNTY | PTY | H_TCA01 | |
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
PLNFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
FLGAT | Sequence category | FOLGENART | CHAR | 1 | TCA07 | FLGAT | |||
BEZFL | Reference sequence for a sequence | BEZFL | CHAR | 6 | ALPHA | PLNFOLGE | |||
BKNT1 | Reference node for start of a sequence | BEZKNTANF | NUMC | 8 | KNTNR | ||||
BKNT2 | Finish reference node of a sequence | BEZKNTEND | NUMC | 8 | KNTNR | ||||
LTXA1 | Sequence description | FLGTEXT | CHAR | 40 | TEXT40 | ||||
TXTSP | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
LOSVN | From lot size | CP_FLGLOSV | QUAN | 13(3) | MENG13 | ||||
LOSBS | To lot size | CP_FLGLOSB | QUAN | 13(3) | MENG13 | ||||
BSCHL1 | Relationship key for branch operation of parallel sequences | CP_BSCHL1 | CHAR | 1 | TCA50 | CP_TSCHL | |||
BSCHL2 | Relationship key for return operation of parallel sequences | CP_BSCHL2 | CHAR | 1 | TCA50 | CP_TSCHL | |||
AUSCHL | Alignment key for scheduling | CP_AUSCHL | CHAR | 1 | TCA52 | CP_AUSSCHL | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1 | OCM_OBJ_TYPE | ||||
CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1 | OCM_CH_PROC |
Key field | Non-key field |
How do I retrieve data from SAP table VSAFFL_CN using ABAP code
The following ABAP code Example will allow you to do a basic selection on VSAFFL_CN to SELECT all data from the tableDATA: WA_VSAFFL_CN TYPE VSAFFL_CN.
SELECT SINGLE *
FROM VSAFFL_CN
INTO CORRESPONDING FIELDS OF WA_VSAFFL_CN
WHERE...
How to access SAP table VSAFFL_CN
Within an ECC or HANA version of SAP you can also view further information about VSAFFL_CN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects