SAP VSAFFL_CN Version: Order sequences PP orders Table
Overview
VSAFFL_CN is a standard SAP S/4HANA table that stores Version: Order sequences PP orders data. There are total 24 fields in the VSAFFL_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSAFFL_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).
In addition, following links provide an overview of foreign key relationships, if any, that link VSAFFL_CN to other SAP tables and standard CDS views available based on VSAFFL_CN table in S/4HANA 2020.
Techincal Settings of VSAFFL_CN
Below are technical details of the table VSAFFL_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSAFFL_CN Fields
The following table gives you an overview of the fields available in VSAFFL_CN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VSNMR | Number or description of a version | VSNMR | CHAR | 12 | |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL | Internal counter | CIM_COUNT | NUMC | 8 | |
| PLNTY | Task List Type | PLNTY | TCA01 | CHAR | 1 |
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | |
| PLNAL | Group Counter | PLNAL | CHAR | 2 | |
| PLNFL | Sequence | PLNFOLGE | CHAR | 6 | |
| ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | |
| AENNR | Change Number | AENNR | AENR | CHAR | 12 |
| FLGAT | Sequence Category | FOLGENART | TCA07 | CHAR | 1 |
| BEZFL | Reference Sequence | BEZFL | CHAR | 6 | |
| BKNT1 | Reference node for start of a sequence | BEZKNTANF | NUMC | 8 | |
| BKNT2 | Finish reference node of a sequence | BEZKNTEND | NUMC | 8 | |
| LTXA1 | Sequence Description | FLGTEXT | CHAR | 40 | |
| TXTSP | Language Key | SPRAS | T002 | LANG | 1 |
| LOSVN | Minimum Lot Size | CP_FLGLOSV | QUAN | 13 | |
| LOSBS | Maximum Lot Size | CP_FLGLOSB | QUAN | 13 | |
| BSCHL1 | Relationship key for branch operation of parallel sequences | CP_BSCHL1 | TCA50 | CHAR | 1 |
| BSCHL2 | Relationship key for return operation of parallel sequences | CP_BSCHL2 | TCA50 | CHAR | 1 |
| AUSCHL | Alignment Key for Scheduling | CP_AUSCHL | TCA52 | CHAR | 1 |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1 | |
| CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VSAFFL_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSAFFL_CN | AENNR | 1: CN | AENR |
| VSAFFL_CN | AUSCHL | C: CN | TCA52 |
| VSAFFL_CN | BSCHL1 | C: CN | TCA50 |
| VSAFFL_CN | BSCHL2 | C: CN | TCA50 |
| VSAFFL_CN | FLGAT | : | TCA07 |
| VSAFFL_CN | MANDT | 1: CN | T000 |
| VSAFFL_CN | OBJNR | C: 1 | ONR00 |
| VSAFFL_CN | PLNTY | 1: CN | TCA01 |
| VSAFFL_CN | TXTSP | C: CN | T002 |