The AFVC table in SAP ERP or S/4HANA stores Operation within an order data. There are total 191 fields in AFVC table. The Operation within an order table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of AFVC table. It is in Application Development ERP PP Production Orders (CO) ABAP package and is part of the Production Orders (PP-SFC) module.
SAP AFVC Table Fields
Following is the list of fields that are available in SAP AFVC table. The primary key fields of the table are MANDT (Client), AUFPL (Routing number of operations in the order), APLZL (General counter for order).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| 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) |
