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