SAP TXI_AFVC Table in S/4 HANA - Operation within an order
TXI_AFVC is a standard SAP Table which is used to store Operation within an order data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TXI_AFVC table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: TXI_AFVC
TXI_AFVC table structure field list
Below is the full TXI_AFVC field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10(0) | AUFPL | |||||
APLZL | General counter for order | CO_APLZL | NUMC | 8(0) | Assigned to domain | CO_APLZL | ||||
PLNFL | Sequence | PLNFOLGE | CHAR | 6(0) | ALPHA | PLNFOLGE | ||||
PLNKN | Number of the Task List Node | PLNKN | NUMC | 8(0) | KNTNR | |||||
PLNAL | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
PLNTY | Task List Type | PLNTY | CHAR | 1(0) | TCA01 | PLNTY | PTY | H_TCA01 | PLNTY | |
VINTV | Increment between referenced operations | VINTV | DEC | 3(0) | VINTV | |||||
PLNNR | Key for Task List Group | PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4(0) | NUMCV | VORNR | VGN | |||
STEUS | Control key | STEUS | CHAR | 4(0) | T430 | STEUS | ||||
ARBID | Object ID of the resource | CR_OBJID | NUMC | 8(0) | CRID | CR_OBJID | ||||
PDEST | Printer for shop papers | CR_PDEST | CHAR | 4(0) | TSP03 | SPDEV | RSPOPNAME | |||
WERKS | Plant | WERKS_D | CHAR | 4(0) | T001W | WERKS | WRK | H_T001W_C | WERKS | |
KTSCH | Standard Text Key | KTSCH | CHAR | 7(0) | T435 | KTSCH | ||||
LTXA1 | Operation short text | LTXA1 | CHAR | 40(0) | TEXT40 | |||||
LTXA2 | Second line of the description | LTXA2 | CHAR | 40(0) | TEXT40 | |||||
TXTSP | Language Key | SPRAS | LANG | 1(0) | T002 | ISOLA | SPRAS | SPR | H_T002 | SPRAS |
VPLTY | Type of the referenced task list | VPLNTY | CHAR | 1(0) | TCA01 | PLNTY | ||||
VPLNR | Group of the referenced task list | VPLNNR | CHAR | 8(0) | ALPHA | PLNNR | ||||
VPLAL | Group counter of the referenced task list | VPLNAL | CHAR | 2(0) | ALPHA | ALTNR | ||||
VPLFL | Referenced sequence in routing | VPLBFL | CHAR | 6(0) | ALPHA | PLNFOLGE | ||||
VGWTS | Standard Value Key | VORGSCHL | CHAR | 4(0) | TC21 | VORGSCHL | ||||
LAR01 | Activity Type | LSTAR | CHAR | 6(0) | CSLA | LSTAR | LAR | LART_EMPTY | LSTAR | |
LAR02 | Activity Type | LSTAR | CHAR | 6(0) | CSLA | LSTAR | LAR | LART_EMPTY | LSTAR | |
LAR03 | Activity Type | LSTAR | CHAR | 6(0) | CSLA | LSTAR | LAR | LART_EMPTY | LSTAR | |
LAR04 | Activity Type | LSTAR | CHAR | 6(0) | CSLA | LSTAR | LAR | LART_EMPTY | LSTAR | |
LAR05 | Activity Type | LSTAR | CHAR | 6(0) | CSLA | LSTAR | LAR | LART_EMPTY | LSTAR | |
LAR06 | Activity Type | LSTAR | CHAR | 6(0) | CSLA | LSTAR | LAR | LART_EMPTY | LSTAR | |
ZERMA | Type of Standard Value Determination | DZERMA | CHAR | 5(0) | T429 | ZERMA | ||||
ZGDAT | Date when the standard value was calculated | DZGDAT | CHAR | 4(0) | GJAHR | CJAHR | ||||
ZCODE | Reference number for standard value code | DZCODE | CHAR | 6(0) | ZCODE | |||||
ZULNR | Basis for Determination of Standard Value | DZULNR | CHAR | 5(0) | ZULNR | |||||
LOANZ | Number of Time Tickets | LOHNANZ | DEC | 3(0) | LOHNANZ | |||||
LOART | Wage type | LOHNART | CHAR | 4(0) | LOART | |||||
RSANZ | Number of Confirmation Slips | CR_RS_ANZ | NUMC | 3(0) | NUM03 | |||||
QUALF | Suitability | QUALF | CHAR | 2(0) | T423 | QUALF | ||||
ANZMA | Number of employees | ANZMS | DEC | 5(2) | ANZMA | |||||
RFGRP | Setup group category | RUEFAGRP | CHAR | 10(0) | T426 | RUEFAGRP | ||||
RFSCH | Setup group key | RUEFASCHLU | CHAR | 10(0) | T425 | RUEFASCHLU | ||||
RASCH | Setup Type Key | RUEARSCHLU | CHAR | 2(0) | T428 | RUEARSCHLU | ||||
AUFAK | Scrap factor | AUSCHUFAK | DEC | 5(3) | AUSCHUFAK | |||||
LOGRP | Wage Group | LOHNGRP | CHAR | 3(0) | T421 | LOHNGRP | ||||
UEMUS | Required Overlapping | UEMUSKZ | CHAR | 1(0) | XFELD | |||||
UEKAN | Optional Overlapping | UEKANKZ | CHAR | 1(0) | XFELD | |||||
FLIES | Flow Manufacturing | FLIESSKZ | CHAR | 1(0) | XFELD | |||||
SPMUS | Splitting Required | SPLITTUNG | CHAR | 1(0) | XFELD | |||||
SPLIM | Maximum Number of Splits | SPLITTANZ | DEC | 3(0) | SPLITTANZ | |||||
ABLIPKZ | Teardown and Wait Occur in Parallel | ABLIPKZ | CHAR | 1(0) | FLAG | |||||
RSTRA | Reduction Strategy per Operation | RSTRA | CHAR | 2(0) | T499Q | RSTRA | ||||
SUMNR | Node Number of the Superior Operation | SUMKNTNR | NUMC | 8(0) | KNTNR | |||||
SORTL | Sort Term for Non-Stock Info Records | SORTI | CHAR | 10(0) | CHAR10 | |||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | LIF | KRED_C | LIFNR |
PREIS | Price | PREIS | CURR | 11(2) | WERT11 | |||||
PEINH | Price unit | PEINH | DEC | 5(0) | PACK3 | |||||
SAKTO | Cost Element | KSTAR | CHAR | 10(0) | CSKA | ALPHA | KSTAR | KAT | ||
WAERS | Currency Key | WAERS | CUKY | 5(0) | TCURC | WAERS | FWS | |||
INFNR | Number of purchasing info record | INFNR | CHAR | 10(0) | EINA | ALPHA | INFNR | INF | MEIN_C | INFNR |
ESOKZ | Purchasing info record category | ESOKZ | CHAR | 1(0) | ESOKZ | ESO | ||||
EKORG | Purchasing organization | EKORG | CHAR | 4(0) | T024E | EKORG | EKO | |||
EKGRP | Purchasing Group for External Processing Activity | VG_EKGRP | CHAR | 3(0) | T024 | EKGRP | ||||
KZLGF | Indicator: Lot-Size-Independent External Processing | KZLGF | CHAR | 1(0) | XFELD | |||||
KZWRTF | Indicator: Fixed price for external processing | KZWRTF | CHAR | 1(0) | XFELD | |||||
MATKL | Material Group | MATKL | CHAR | 9(0) | T023 | MATKL | MKL | S_WBWG | MATKL | |
DDEHN | Indicator: flexible duration | DAUDEHN | CHAR | 1(0) | X | |||||
ANZZL | Number of capacities required | ANZKAP | INT1 | 3(0) | INT1 | |||||
PRZNT | Work percentage | APROZENT | INT1 | 3(0) | INT1 | |||||
MLSTN | Usage | MILESTONE | CHAR | 5(0) | T433 | MILESTONE | ||||
PPRIO | Priority | PRIORITAET | CHAR | 2(0) | PRIORITAET | |||||
BUKRS | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
ANFKO | Requesting Cost Center | ANFKO | CHAR | 10(0) | CSKS | ALPHA | KOSTL | |||
ANFKOKRS | Controlling area of the requesting cost center | ANFKOKRS | CHAR | 4(0) | TKA01 | CACCD | ||||
INDET | Key for calculation | INDET | CHAR | 1(0) | INDET | |||||
LARNT | Activity Type | LSTAR | CHAR | 6(0) | CSLA | LSTAR | LAR | LART_EMPTY | LSTAR | |
PRKST | Costs in the activity | PRKST | CURR | 11(2) | PRKST | |||||
APLFL | Sequence | PLNFOLGE | CHAR | 6(0) | ALPHA | PLNFOLGE | ||||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10(0) | CO_RUECK | RCK | ||||
RMZHL | Confirmation counter | CO_RMZHL | NUMC | 8(0) | CIM_COUNT | RZL | ||||
PROJN | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8(0) | PRPS | KONPR | PS_POSNR | |||
OBJNR | Object number | J_OBJNR | CHAR | 22(0) | ONR00 | J_OBJNR | ONR | |||
SPANZ | Actual number of splits | SPLITTERM | DEC | 3(0) | DEC3 | |||||
BEDID | ID of the Capacity Requirements Record | BEDID | NUMC | 12(0) | Assigned to domain | BEDID | ||||
BEDZL | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
BANFN | Purchase Requisition Number | CO_BANFN | CHAR | 10(0) | ALPHA | BANFN | ||||
BNFPO | Item Number of Purchase Requisition in Order | CO_BNFPO | NUMC | 5(0) | EBAN | BNFPO | ||||
LEK01 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
LEK02 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
LEK03 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
LEK04 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
LEK05 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
LEK06 | Indicator: No Remaining Activity Expected | CO_LEIKZ | CHAR | 1(0) | XFELD | |||||
SELKZ | Selection indicator for costing line items | CO_SELKZ | CHAR | 1(0) | TCK08 | CK_SELKZ | ||||
KALID | Factory Calendar | WFCID | CHAR | 2(0) | TFACD | WFCID | FCI | |||
FRSP | Earliest possible activity / Latest possible activity | FRSP | CHAR | 1(0) | FRSP | |||||
STDKN | Node of operation within reference operation set | STDKN | NUMC | 8(0) | KNTNR | |||||
ANLZU | System Condition | ANLZU | CHAR | 1(0) | T357M | ANLZU | ||||
ISTRU | Assembly | ISTRU | CHAR | 40(0) | MARA | MATN1 | MATNR | |||
ISTTY | BOM category | STLTY | CHAR | 1(0) | STLTY | |||||
ISTNR | Bill of Material | STNUM | CHAR | 8(0) | NUMCV | STNUM | STLNR | STLNR | ||
ISTKN | BOM item node number | STLKN | NUMC | 8(0) | KNTNR | |||||
ISTPO | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
IUPOZ | Subitem Number | UPOSZ | CHAR | 4(0) | NUMCV | SPOSN | ||||
EBORT | Installation Point for Subitem | EBORT | CHAR | 20(0) | TEXT20 | |||||
VERTL | Distr.cap.reqmts (plant maint.,process order, network) | CR_VERTN | CHAR | 8(0) | TC29 | CR_VERTL | ||||
LEKNW | Indicator: No Remaining Work Expected | LEKNW | CHAR | 1(0) | XFELD | |||||
NPRIO | Priority | NW_PRIO | CHAR | 1(0) | TCN07 | NW_PRIO | ||||
PVZKN | General counter for order | CO_APLZL | NUMC | 8(0) | Assigned to domain | CO_APLZL | ||||
PHFLG | Indicator: Phase | PHFLG | CHAR | 1(0) | XFELD | |||||
PHSEQ | Control Recipe Destination | PHSEQ | CHAR | 2(0) | TC52 | PHSEQ | ||||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18(0) | KNOBJ | |||||
ERFSICHT | Recording View | QERFSICHT | CHAR | 2(0) | QERFSICHT | QER | ||||
QPPKTABS | Flow Variants for Inspection Point Completion | QPPKTABS | CHAR | 1(0) | QPPKTABS | |||||
OTYPE | Object Type | OTYPE | CHAR | 2(0) | T778O | OTYPE | POT | |||
OBJEKTID | Object ID | OBJEKTID | NUMC | 8(0) | NUM08 | PON | ||||
QLKAPAR | Capacity category | QL_KAPART | CHAR | 3(0) | TC26 | KAPART | CAA | |||
RSTUF | Reduction Level Which Reduces Operation Lead Time | RSTUF | NUMC | 1(0) | REDST | |||||
NPTXTKY | Internal text number (12-character) | TXTKY | CHAR | 12(0) | CHAR12 | |||||
SUBSYS | Subsystem Identifier for QM Subsystem Interface | QEIFSUBSYS | CHAR | 6(0) | Assigned to domain | QEIFSUBSYS | ||||
PSPNR | Standard WBS element | PS_SPS_ELE | NUMC | 8(0) | Assigned to domain | KONPT | PS_SPSNR | |||
PACKNO | Package number | PACKNO | NUMC | 10(0) | Assigned to domain | PACKNO | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15(0) | TTXJ | TXJCD | TXJ | |||
SCOPE | Object Class | SCOPE_CV | CHAR | 2(0) | SCOPE | SCOPE_CV | PCO | |||
GSBER | Business Area | GSBER | CHAR | 4(0) | TGSB | GSBER | GSB | |||
PRCTR | Profit Center | PRCTR | CHAR | 10(0) | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR |
NO_DISP | Effective for Materials Planning | NO_DISP_PLUS | CHAR | 1(0) | NO_DISP_PLUS | |||||
QKZPRZEIT | Interval = Time (Time-Related) | QKZPRZEIT | CHAR | 1(0) | QKZ | |||||
QKZZTMG1 | Quantity Confirmation for Each Partial Lot | QKZZTMG1 | CHAR | 1(0) | QKZ | |||||
QKZPRMENG | Inspection Cycle = Quantity (Quantity-Reference) | QKZPRMENG | CHAR | 1(0) | QKZ | |||||
QKZPRFREI | Interval Without Reference to Time or Quantity | QKZPRFREI | CHAR | 1(0) | QKZ | |||||
KZFEAT | Indicator Is Not Used Currently | QKZFEAT | CHAR | 1(0) | QKZFEAT | |||||
QKZTLSBEST | Operation with Stock-Related Partial Lot Assignment | QKZTLSBEST | CHAR | 1(0) | QKZ | |||||
AENNR | Change Number | AENNR | CHAR | 12(0) | AENR | AENNR | AENNR | AEN | ||
CUOBJ_ARB | Configuration (internal object number) | CUOBJ | NUMC | 18(0) | CUOBJ | CUX | ||||
EVGEW | Aggregation weight for POC (PS progress) | EV_WEIGHTD | DEC | 8(0) | DEC8 | |||||
ARBII | Actual operating resources object identification | CR_OBJID_I | NUMC | 8(0) | CRID | CR_OBJID | ||||
WERKI | Actual plant | WERKS_I | CHAR | 4(0) | T001W | WERKS | WRK | |||
CY_SEQNRV | Sequence number operation | CY_SEQNRV | NUMC | 14(0) | CY_SEQNR | |||||
KAPT_PUFFR | Operation floats after finite scheduling (in seconds) | KAPT_PUFFR | INT4 | 10(0) | INT4 | |||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10(0) | EKKO | ALPHA | EBELN | BES | MEKK_C | EBELN |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | EKPO | EBELP | BSP | |||
WEMPF | Goods recipient | WEMPF | CHAR | 12(0) | WEMPF | |||||
ABLAD | Unloading Point | ABLAD | CHAR | 25(0) | TEXT25 | |||||
CLASF | Ind.: Respect Activity for Project Summarization | CLASF | CHAR | 1(0) | XFELD | |||||
FRUNV | Indicator: External procurement data incomplete | FRUNV | CHAR | 1(0) | KREUZ | |||||
ZSCHL | Overhead key | AUFZSCHL | CHAR | 6(0) | CHAR6 | |||||
KALSM | Costing Sheet | AUFKALSM | CHAR | 6(0) | Assigned to domain | KALSM | ||||
SCHED_END | Ind.: Purchase requisition at activity finish date | SCEND_ACT | CHAR | 1(0) | XFELD | |||||
NETZKONT | Indicator for the account assignment of a network(hdr/act.) | NETZKONT | CHAR | 1(0) | NETZKONT | |||||
OWAER | Object currency for network activity | OWAERS | CUKY | 5(0) | TCURC | WAERS | ||||
AFNAM | Name of requisitioner/requester | AFNAM | CHAR | 12(0) | AFNAM | |||||
BEDNR | Requirement Tracking Number | BEDNR | CHAR | 10(0) | CHAR10 | |||||
KZFIX | Data of Purchasing Info Record Is Fixed | CN_KZFIX | CHAR | 1(0) | XFELD | |||||
PERNR | Personnel number | CO_PERNR | NUMC | 8(0) | PERNR | PER | ||||
FRDLB | Indicator: External Processing Operation with Subcontracting | CO_FRDLB | CHAR | 1(0) | CHAR1 | |||||
QPART | Inspection Type | QPART | CHAR | 8(0) | TQ30 | QPART | QLA | |||
LOEKZ | Deletion Flag | AUFLOEKZ | CHAR | 1(0) | XFELD | |||||
WKURS | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | ||||
PROD_ACT | Indicator: Activity is a production activity | PROD_ACT | CHAR | 1(0) | XFELD | |||||
FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10(0) | Assigned to domain | FPLNR | ||||
OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1(0) | OCM_OBJ_TYPE | |||||
CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1(0) | OCM_CH_PROC | |||||
KLVAR | Costing Variant | CK_KLVAR | CHAR | 4(0) | Assigned to domain | KLVAR | KRT | |||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12(0) | Assigned to domain | CK_KALNR | KNR | |||
FORDN | Framework Order | SFORDN | CHAR | 10(0) | Assigned to domain | ALPHA | EBELN | |||
FORDP | Item of framework order | FORDP | NUMC | 5(0) | Assigned to domain | EBELP | ||||
MAT_PRKST | Material planning in networks: primary costs | MAT_PRKST | CURR | 11(2) | PRKST | |||||
PRZ01 | Business Process | CO_PRZNR | CHAR | 12(0) | Assigned to domain | ALPHA | CO_PRZNR | KWP | ||
RFPNT | Reference point for BOM transfer | CN_RFPNT | CHAR | 20(0) | TCNRFP | CN_RFPNT | ||||
FUNC_AREA | Functional Area | FKBER | CHAR | 16(0) | TFKB | FKBER | FBE | |||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12(0) | TECHS | |||||
ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40(0) | ADDCOMPARE_CORE | ADCP | ADPSP | |||
RFIPPNT | Reference Point for Relationship Between iPPE and PS | CN_RPIP | CHAR | 20(0) | TCNRPIP | CN_RFPNT | ||||
MES_OPERID | Key of an Operation from an ME System | CO_MES_INT_OPERID | CHAR | 48(0) | CHAR48 | |||||
MES_STEPID | Key of a Step in a Routing (SAP ME) | CO_MES_INT_STEPID | CHAR | 6(0) | CHAR6 | |||||
OAN_INST_ID_SETUP | Operation Activity Network: Instance ID | MPE_OAN_INSTANCE_ID | INT4 | 10(0) | ||||||
OAN_INST_ID_PRODUCE | Operation Activity Network: Instance ID | MPE_OAN_INSTANCE_ID | INT4 | 10(0) | ||||||
OAN_INST_ID_TEARDOWN | Operation Activity Network: Instance ID | MPE_OAN_INSTANCE_ID | INT4 | 10(0) | ||||||
TL_VERSN | Routing Version | PLNVERSN | CHAR | 4(0) | ALPHA | PLNVERSN | ||||
DUMMY_AFVC_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1(0) | DUMMY | |||||
.INCLU--AP | 0(0) | |||||||||
/CUM/CUGUID | UUID in X form (binary) | SYSUUID_X | RAW | 16(0) | /CUM/AFCU | SYSUUID | ||||
.INCLU--AP | 0(0) | |||||||||
/ISDFPS/OBJNR | Object number | J_OBJNR | CHAR | 22(0) | Assigned to domain | J_OBJNR | ONR | |||
.INCLU--AP | 0(0) | |||||||||
MILL_OC_AUFNR_MO | Number of Combined Order | MILL_OC_AUFNR_MO | CHAR | 12(0) | Assigned to domain | ALPHA | AUFNR | |||
.INCLU--AP | 0(0) | |||||||||
WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1(0) | WTYSC_WTY_INDICATOR | |||||
TPLNR | Functional Location | TPLNR | CHAR | 30(0) | TPLNR | TPLNR | IFL | IFLM | TPLNR | |
EQUNR | Equipment Number | EQUNR | CHAR | 18(0) | ALPHA | EQUNR | EQN | EQUI | EQUNR | |
.INCLU--AP | 0(0) | |||||||||
CPD_UPDAT | Time Stamp | /CPD/PFP_SC_TSTMP | DEC | 15(0) | TSTLC | /CPD/PFP_SC_TSTMP | ||||
PREIS_CY | CUKY for SYST | SYCUKY | CUKY | 5(0) | SYCUKY | |||||
PRKST_CY | CUKY for SYST | SYCUKY | CUKY | 5(0) | SYCUKY | |||||
MAT_PRKST_CY | CUKY for SYST | SYCUKY | CUKY | 5(0) | SYCUKY |
Search for further information about these or an SAP related objects