SAP VSAFVC_CN Version: Operation in order Table
Overview
VSAFVC_CN is a standard SAP S/4HANA table that stores Version: Operation in order data. There are total 194 fields in the VSAFVC_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSAFVC_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 VSAFVC_CN to other SAP tables and standard CDS views available based on VSAFVC_CN table in S/4HANA 2020.
Techincal Settings of VSAFVC_CN
Below are technical details of the table VSAFVC_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSAFVC_CN Fields
The following table gives you an overview of the fields available in VSAFVC_CN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | 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 | General counter for order | CO_APLZL | AFVC | NUMC | 8 |
| PLNFL | Sequence | PLNFOLGE | CHAR | 6 | |
| PLNKN | Number of the Task List Node | PLNKN | NUMC | 8 | |
| PLNAL | Group Counter | PLNAL | CHAR | 2 | |
| PLNTY | Task List Type | PLNTY | TCA01 | CHAR | 1 |
| VINTV | Increment between referenced operations | VINTV | DEC | 3 | |
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | |
| ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | |
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | |
| STEUS | Control key | STEUS | T430 | CHAR | 4 |
| ARBID | Object ID of the resource | CR_OBJID | CRID | NUMC | 8 |
| PDEST | Printer for shop papers | CR_PDEST | TSP03 | CHAR | 4 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| KTSCH | Standard text key | KTSCH_CHG | T435 | CHAR | 7 |
| LTXA1 | Operation short text | LTXA1 | CHAR | 40 | |
| LTXA2 | Second line of the description | LTXA2 | CHAR | 40 | |
| TXTSP | Language Key | SPRAS | T002 | LANG | 1 |
| VPLTY | Type of the referenced task list | VPLNTY | TCA01 | CHAR | 1 |
| VPLNR | Group of the referenced task list | VPLNNR | CHAR | 8 | |
| VPLAL | Group counter of the referenced task list | VPLNAL | CHAR | 2 | |
| VPLFL | Referenced sequence in routing | VPLBFL | CHAR | 6 | |
| VGWTS | Standard Value Key | VORGSCHL | TC21 | CHAR | 4 |
| LAR01 | Activity Type | LSTAR | CSLA | CHAR | 6 |
| LAR02 | Activity Type | LSTAR | CSLA | CHAR | 6 |
| LAR03 | Activity Type | LSTAR | CSLA | CHAR | 6 |
| LAR04 | Activity Type | LSTAR | CSLA | CHAR | 6 |
| LAR05 | Activity Type | LSTAR | CSLA | CHAR | 6 |
| LAR06 | Activity Type | LSTAR | CSLA | CHAR | 6 |
| ZERMA | Type of Standard Value Determination | DZERMA | T429 | CHAR | 5 |
| ZGDAT | Date when the standard value was calculated | DZGDAT | CHAR | 4 | |
| ZCODE | Reference number for standard value code | DZCODE | CHAR | 6 | |
| ZULNR | Basis for Determination of Standard Value | DZULNR | CHAR | 5 | |
| LOANZ | Number of Time Tickets | LOHNANZ | DEC | 3 | |
| LOART | Wage type | LOHNART | CHAR | 4 | |
| RSANZ | Number of Confirmation Slips | CR_RS_ANZ | NUMC | 3 | |
| QUALF | Suitability | QUALF | T423 | CHAR | 2 |
| ANZMA | Number of employees | ANZMS | DEC | 5 | |
| RFGRP | Setup group category | RUEFAGRP | T426 | CHAR | 10 |
| RFSCH | Setup group key | RUEFASCHLU | T425 | CHAR | 10 |
| RASCH | Setup Type Key | RUEARSCHLU | T428 | CHAR | 2 |
| AUFAK | Scrap factor | AUSCHUFAK | DEC | 5 | |
| LOGRP | Wage Group | LOHNGRP | T421 | CHAR | 3 |
| UEMUS | Required Overlapping | UEMUSKZ | CHAR | 1 | |
| UEKAN | Optional Overlapping | UEKANKZ | CHAR | 1 | |
| FLIES | Flow Manufacturing | FLIESSKZ | CHAR | 1 | |
| SPMUS | Splitting Required | SPLITTUNG | CHAR | 1 | |
| SPLIM | Maximum Number of Splits | SPLITTANZ | DEC | 3 | |
| ABLIPKZ | Teardown and Wait Occur in Parallel | ABLIPKZ | CHAR | 1 | |
| RSTRA | Reduction Strategy per Operation | RSTRA | T499Q | CHAR | 2 |
| SUMNR | Node Number of the Superior Operation | SUMKNTNR | NUMC | 8 | |
| SORTL | Sort Term for Non-Stock Info Records | SORTI | CHAR | 10 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| PREIS | Price | PREIS | CURR | 11 | |
| PEINH | Price unit | PEINH | DEC | 5 | |
| SAKTO | Cost Element | KSTAR | CSKA | CHAR | 10 |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| INFNR | Number of purchasing info record | INFNR | EINA | CHAR | 10 |
| ESOKZ | Purchasing info record category | ESOKZ | CHAR | 1 | |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group for External Processing Activity | VG_EKGRP | T024 | CHAR | 3 |
| KZLGF | Indicator: Lot-Size-Independent External Processing | KZLGF | CHAR | 1 | |
| KZWRTF | Indicator: Fixed price for external processing | KZWRTF | CHAR | 1 | |
| MATKL | Material Group | MATKL | T023 | CHAR | 9 |
| DDEHN | Indicator: flexible duration | DAUDEHN | CHAR | 1 | |
| ANZZL | Number of capacities required | ANZKAP | INT1 | 3 | |
| PRZNT | Work percentage | APROZENT | INT1 | 3 | |
| MLSTN | Usage | MILESTONE | T433 | CHAR | 5 |
| PPRIO | Priority | PRIORITAET | CHAR | 2 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| ANFKO | Requesting Cost Center | ANFKO | CSKS | CHAR | 10 |
| ANFKOKRS | Controlling area of the requesting cost center | ANFKOKRS | TKA01 | CHAR | 4 |
| INDET | Key for calculation | INDET | CHAR | 1 | |
| LARNT | Activity Type | LSTAR | CSLA | CHAR | 6 |
| PRKST | Costs in the activity | PRKST | CURR | 11 | |
| APLFL | Sequence | PLNFOLGE | CHAR | 6 | |
| RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | |
| RMZHL | Confirmation counter | CO_RMZHL | NUMC | 8 | |
| PROJN | Work breakdown structure element (WBS element) | PS_PSP_ELE | PRPS | NUMC | 8 |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| SPANZ | Actual number of splits | SPLITTERM | DEC | 3 | |
| BEDID | ID of the Capacity Requirements Record | BEDID | * | NUMC | 12 |
| BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | |
| BANFN | Purchase Requisition Number | CO_BANFN | CHAR | 10 | |
| BNFPO | Item Number of Purchase Requisition in Order | CO_BNFPO | EBAN | NUMC | 5 |
| LEK01 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| LEK02 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| LEK03 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| LEK04 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| LEK05 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| LEK06 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1 | |
| SELKZ | Selection indicator for costing line items | CO_SELKZ | TCK08 | CHAR | 1 |
| KALID | Factory Calendar | WFCID | TFACD | CHAR | 2 |
| FRSP | Earliest possible activity / Latest possible activity | FRSP | CHAR | 1 | |
| STDKN | Node of operation within reference operation set | STDKN | NUMC | 8 | |
| ANLZU | System Condition | ANLZU | T357M | CHAR | 1 |
| ISTRU | Assembly | ISTRU | MARA | CHAR | 40 |
| ISTTY | BOM category | STLTY | CHAR | 1 | |
| ISTNR | Bill of Material | STNUM | CHAR | 8 | |
| ISTKN | BOM item node number | STLKN | NUMC | 8 | |
| ISTPO | Internal counter | CIM_COUNT | NUMC | 8 | |
| IUPOZ | Subitem Number | UPOSZ | CHAR | 4 | |
| EBORT | Installation Point for Subitem | EBORT | CHAR | 20 | |
| VERTL | Distr.cap.reqmts (plant maint.process order network) | CR_VERTN | TC29 | CHAR | 8 |
| LEKNW | Indicator: No Remaining Work Expected | LEKNW | CHAR | 1 | |
| NPRIO | Priority | NW_PRIO | TCN07 | CHAR | 1 |
| PVZKN | General counter for order | CO_APLZL | * | NUMC | 8 |
| PHFLG | Indicator: Phase | PHFLG | CHAR | 1 | |
| PHSEQ | Control Recipe Destination | PHSEQ | TC52 | CHAR | 2 |
| KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18 | |
| ERFSICHT | Recording View | QERFSICHT | CHAR | 2 | |
| QPPKTABS | Flow Variants for Inspection Point Completion | QPPKTABS | CHAR | 1 | |
| OTYPE | Object Type | OTYPE | T778O | CHAR | 2 |
| OBJEKTID | Object ID | OBJEKTID | NUMC | 8 | |
| QLKAPAR | Capacity category | QL_KAPART | TC26 | CHAR | 3 |
| RSTUF | Reduction Level Which Reduces Operation Lead Time | RSTUF | NUMC | 1 | |
| NPTXTKY | Internal text number (12-character) | TXTKY | CHAR | 12 | |
| SUBSYS | Subsystem Identifier for QM Subsystem Interface | QEIFSUBSYS | * | CHAR | 6 |
| PSPNR | Standard WBS element | PS_SPS_ELE | * | NUMC | 8 |
| PACKNO | Package number | PACKNO | * | NUMC | 10 |
| TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR | 15 |
| SCOPE | Object Class | SCOPE_CV | CHAR | 2 | |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 |
| NO_DISP | Effective for Materials Planning | NO_DISP_PLUS | CHAR | 1 | |
| QKZPRZEIT | Interval = Time (Time-Related) | QKZPRZEIT | CHAR | 1 | |
| QKZZTMG1 | Quantity Confirmation for Each Partial Lot | QKZZTMG1 | CHAR | 1 | |
| QKZPRMENG | Inspection Cycle = Quantity (Quantity-Reference) | QKZPRMENG | CHAR | 1 | |
| QKZPRFREI | Interval Without Reference to Time or Quantity | QKZPRFREI | CHAR | 1 | |
| KZFEAT | Indicator Is Not Used Currently | QKZFEAT | CHAR | 1 | |
| QKZTLSBEST | Operation with Stock-Related Partial Lot Assignment | QKZTLSBEST | CHAR | 1 | |
| AENNR | Change Number | AENNR | AENR | CHAR | 12 |
| CUOBJ_ARB | Configuration (internal object number) | CUOBJ | NUMC | 18 | |
| EVGEW | Aggregation weight for POC (PS progress) | EV_WEIGHTD | DEC | 8 | |
| ARBII | Actual operating resources object identification | CR_OBJID_I | CRID | NUMC | 8 |
| WERKI | Actual plant | WERKS_I | T001W | CHAR | 4 |
| CY_SEQNRV | Sequence number operation | CY_SEQNRV | NUMC | 14 | |
| KAPT_PUFFR | Operation floats after finite scheduling (in seconds) | KAPT_PUFFR | INT4 | 10 | |
| EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 |
| EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 |
| WEMPF | Goods Recipient | WEMPF | CHAR | 12 | |
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | |
| CLASF | Ind.: Respect Activity for Project Summarization | CLASF | CHAR | 1 | |
| FRUNV | Indicator: External procurement data incomplete | FRUNV | CHAR | 1 | |
| ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | |
| KALSM | Costing Sheet | AUFKALSM | * | CHAR | 6 |
| SCHED_END | Ind.: Purchase requisition at activity finish date | SCEND_ACT | CHAR | 1 | |
| NETZKONT | Indicator for the account assignment of a network(hdr/act.) | NETZKONT | CHAR | 1 | |
| OWAER | Object currency for network activity | OWAERS | TCURC | CUKY | 5 |
| AFNAM | Name of requisitioner/requester | AFNAM | CHAR | 12 | |
| BEDNR | Requirement Tracking Number | BEDNR | CHAR | 10 | |
| KZFIX | Data of Purchasing Info Record Is Fixed | CN_KZFIX | CHAR | 1 | |
| PERNR | Personnel number | CO_PERNR | NUMC | 8 | |
| FRDLB | Indicator: External Processing Operation with Subcontracting | CO_FRDLB | CHAR | 1 | |
| QPART | Inspection Type | QPART | TQ30 | CHAR | 8 |
| LOEKZ | Deletion Flag | AUFLOEKZ | CHAR | 1 | |
| WKURS | Exchange Rate | WKURS | DEC | 9 | |
| PROD_ACT | Indicator: Activity is a production activity | PROD_ACT | CHAR | 1 | |
| FPLNR | Billing plan number / invoicing plan number | FPLNR | * | CHAR | 10 |
| 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 | |
| KLVAR | Costing Variant | CK_KLVAR | * | CHAR | 4 |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | * | NUMC | 12 |
| FORDN | Framework Order | SFORDN | * | CHAR | 10 |
| FORDP | Item of framework order | FORDP | * | NUMC | 5 |
| MAT_PRKST | Material planning in networks: primary costs | MAT_PRKST_CHG | CURR | 11 | |
| PRZ01 | Business Process | CO_PRZNR | * | CHAR | 12 |
| RFPNT | Reference point for BOM transfer | CN_RFPNT | TCNRFP | CHAR | 20 |
| FUNC_AREA | Functional Area | FKBER | TFKB | CHAR | 16 |
| TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | |
| ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40 | |
| RFIPPNT | Reference Point for Relationship Between iPPE and PS | CN_RPIP | TCNRPIP | CHAR | 20 |
| MES_OPERID | Key of an Operation from an ME System | CO_MES_INT_OPERID | CHAR | 48 | |
| MES_STEPID | Key of a Step in a Routing (SAP ME) | CO_MES_INT_STEPID | CHAR | 6 | |
| TL_VERSN | Routing Version | PLNVERSN | CHAR | 4 | |
| VERSN_TRACK_GUID | Task List GUID | CP_GUID | RAW | 16 | |
| DUMMY_AFVC_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| /CUM/CUGUID | UUID in X form (binary) | SYSUUID_X | /CUM/AFCU | RAW | 16 |
| /ISDFPS/OBJNR | Object number | J_OBJNR | * | CHAR | 22 |
| AFVC_STATUS | Status Combination | ACTCMB_DELE | ACTCMB_TAB | INT1 | 3 |
| ADRNR | Addresses: Address Number | CADNR | * | CHAR | 10 |
| ADRN2 | Address Number | AD_ADDRNUM | * | CHAR | 10 |
| KUNN2 | Account Number of Customer | QKUNUM | * | CHAR | 10 |
| FLDLOGSDELIVISHELDONSHORE | Hold On-Shore | FLOG_HOLD | CHAR | 1 | |
| MILL_OC_AUFNR_MO | Number of Combined Order | MILL_OC_AUFNR_MO | * | CHAR | 12 |
| WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1 | |
| ORGAUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| ORGAPLZL | General counter for order | CO_APLZL | * | NUMC | 8 |
| INACT | Version inactive indicator | VSINACT | CHAR | 1 | |
| CPD_UPDAT | Time Stamp | /CPD/PFP_TSTMP | DEC | 15 | |
| TPLNR | Functional Location | TPLNR | CHAR | 30 | |
| EQUNR | Equipment Number | EQUNR | CHAR | 18 |
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 VSAFVC_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSAFVC_CN | /CUM/CUGUID | 1: CN | /CUM/AFCU |
| VSAFVC_CN | AENNR | : | AENR |
| VSAFVC_CN | AFVC_STATUS | : | ACTCMB_TAB |
| VSAFVC_CN | ANFKO | : | CSKS |
| VSAFVC_CN | ANFKOKRS | : | TKA01 |
| VSAFVC_CN | ANLZU | : | T357M |
| VSAFVC_CN | APLZL | 1: 1 | AFVC |
| VSAFVC_CN | ARBID | : | CRID |
| VSAFVC_CN | ARBII | : | CRID |
| VSAFVC_CN | BNFPO | : | EBAN |
| VSAFVC_CN | BUKRS | : | T001 |
| VSAFVC_CN | EBELN | : | EKKO |
| VSAFVC_CN | EBELP | : | EKPO |
| VSAFVC_CN | EKGRP | : | T024 |
| VSAFVC_CN | EKORG | : | T024E |
| VSAFVC_CN | FUNC_AREA | C: CN | TFKB |
| VSAFVC_CN | GSBER | : | TGSB |
| VSAFVC_CN | INFNR | : | EINA |
| VSAFVC_CN | ISTRU | : | MARA |
| VSAFVC_CN | KALID | : | TFACD |
| VSAFVC_CN | KTSCH | : | T435 |
| VSAFVC_CN | LAR01 | : | CSLA |
| VSAFVC_CN | LAR02 | : | CSLA |
| VSAFVC_CN | LAR03 | : | CSLA |
| VSAFVC_CN | LAR04 | : | CSLA |
| VSAFVC_CN | LAR05 | : | CSLA |
| VSAFVC_CN | LAR06 | : | CSLA |
| VSAFVC_CN | LARNT | : | CSLA |
| VSAFVC_CN | LIFNR | : | LFA1 |
| VSAFVC_CN | LOGRP | : | T421 |
| VSAFVC_CN | MATKL | : | T023 |
| VSAFVC_CN | MLSTN | : | T433 |
| VSAFVC_CN | NPRIO | : | TCN07 |
| VSAFVC_CN | OBJNR | : | ONR00 |
| VSAFVC_CN | OTYPE | : | T778O |
| VSAFVC_CN | OWAER | : | TCURC |
| VSAFVC_CN | PDEST | : | TSP03 |
| VSAFVC_CN | PHSEQ | : | TC52 |
| VSAFVC_CN | PLNTY | : | TCA01 |
| VSAFVC_CN | PRCTR | : | CEPC |
| VSAFVC_CN | PROJN | : | PRPS |
| VSAFVC_CN | QLKAPAR | : | TC26 |
| VSAFVC_CN | QPART | : | TQ30 |
| VSAFVC_CN | QUALF | : | T423 |
| VSAFVC_CN | RASCH | : | T428 |
| VSAFVC_CN | RFGRP | : | T426 |
| VSAFVC_CN | RFIPPNT | C: CN | TCNRPIP |
| VSAFVC_CN | RFPNT | C: CN | TCNRFP |
| VSAFVC_CN | RFSCH | : | T425 |
| VSAFVC_CN | RSTRA | : | T499Q |
| VSAFVC_CN | SAKTO | : | CSKA |
| VSAFVC_CN | SELKZ | : | TCK08 |
| VSAFVC_CN | STEUS | : | T430 |
| VSAFVC_CN | TXJCD | : | TTXJ |
| VSAFVC_CN | TXTSP | : | T002 |
| VSAFVC_CN | VERTL | : | TC29 |
| VSAFVC_CN | VGWTS | : | TC21 |
| VSAFVC_CN | VPLTY | : | TCA01 |
| VSAFVC_CN | WAERS | : | TCURC |
| VSAFVC_CN | WERKI | : | T001W |
| VSAFVC_CN | WERKS | : | T001W |
| VSAFVC_CN | ZERMA | : | T429 |