SAP AFVC Operation within an order Table
Overview
AFVC is a standard SAP S/4HANA table that stores Operation within an order data. There are total 191 fields in the AFVC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFVC belongs to Production Orders (PP-SFC) module and is located in the package Application Development ERP PP Production Orders (CO).
In addition, following links provide an overview of foreign key relationships, if any, that link AFVC to other SAP tables and standard CDS views available based on AFVC table in S/4HANA 2020.
Techincal Settings of AFVC
Below are technical details of the table AFVC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFVC Fields
The following table gives you an overview of the fields available in AFVC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL | General counter for order | CO_APLZL | 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 | |
| TPLNR | Functional Location | TPLNR | CHAR | 30 | |
| EQUNR | Equipment Number | EQUNR | CHAR | 18 | |
| MAINTOPEXECUTIONPHASECODE | PRE MAIN POST | EAM_PREMAINPOST | * | CHAR | 10 |
| CPD_UPDAT | Time Stamp | /CPD/PFP_SC_TSTMP | DEC | 15 |
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 AFVC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFVC | /CUM/CUGUID | 1: CN | /CUM/AFCU |
| AFVC | AENNR | : | AENR |
| AFVC | AFVC_STATUS | : | ACTCMB_TAB |
| AFVC | ANFKO | : | CSKS |
| AFVC | ANFKOKRS | : | TKA01 |
| AFVC | ANLZU | : | T357M |
| AFVC | ARBID | : | CRID |
| AFVC | ARBII | : | CRID |
| AFVC | BNFPO | : | EBAN |
| AFVC | BUKRS | : | T001 |
| AFVC | EBELN | : | EKKO |
| AFVC | EBELP | : | EKPO |
| AFVC | EKGRP | : | T024 |
| AFVC | EKORG | : | T024E |
| AFVC | FUNC_AREA | C: CN | TFKB |
| AFVC | GSBER | : | TGSB |
| AFVC | INFNR | : | EINA |
| AFVC | ISTRU | : | MARA |
| AFVC | KALID | : | TFACD |
| AFVC | KTSCH | : | T435 |
| AFVC | LAR01 | : | CSLA |
| AFVC | LAR02 | : | CSLA |
| AFVC | LAR03 | : | CSLA |
| AFVC | LAR04 | : | CSLA |
| AFVC | LAR05 | : | CSLA |
| AFVC | LAR06 | : | CSLA |
| AFVC | LARNT | : | CSLA |
| AFVC | LIFNR | : | LFA1 |
| AFVC | LOGRP | : | T421 |
| AFVC | MANDT | : | T000 |
| AFVC | MATKL | : | T023 |
| AFVC | MLSTN | : | T433 |
| AFVC | NPRIO | : | TCN07 |
| AFVC | OBJNR | : | ONR00 |
| AFVC | OTYPE | : | T778O |
| AFVC | OWAER | : | TCURC |
| AFVC | PDEST | : | TSP03 |
| AFVC | PHSEQ | : | TC52 |
| AFVC | PLNTY | : | TCA01 |
| AFVC | PRCTR | : | CEPC |
| AFVC | PROJN | : | PRPS |
| AFVC | QLKAPAR | : | TC26 |
| AFVC | QPART | : | TQ30 |
| AFVC | QUALF | : | T423 |
| AFVC | RASCH | : | T428 |
| AFVC | RFGRP | : | T426 |
| AFVC | RFIPPNT | C: CN | TCNRPIP |
| AFVC | RFPNT | C: CN | TCNRFP |
| AFVC | RFSCH | : | T425 |
| AFVC | RSTRA | : | T499Q |
| AFVC | SAKTO | : | CSKA |
| AFVC | SELKZ | : | TCK08 |
| AFVC | STEUS | : | T430 |
| AFVC | TXJCD | : | TTXJ |
| AFVC | TXTSP | : | T002 |
| AFVC | VERTL | : | TC29 |
| AFVC | VGWTS | : | TC21 |
| AFVC | VPLTY | : | TCA01 |
| AFVC | WAERS | : | TCURC |
| AFVC | WERKI | : | T001W |
| AFVC | WERKS | : | T001W |
| AFVC | ZERMA | : | T429 |