VIAUFK_AFVC SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
VIAUFK_AFVC is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The VIAUFK_AFVC table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include AUFNR (Order Number), AUFPL (Routing number of operations in the order), APLZL (General counter for order), TPLNR (Functional Location).. 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: Not classified
SAP VIAUFK_AFVC table view 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 | |||
| AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
| APLZL | General counter for order | CO_APLZL | NUMC | 8 | CO_APLZL | ||||
| TPLNR | Functional Location | TPLNR | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
| STRNO | Functional Location | TPLNR | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
| ARTPR | Priority Type | ARTPR | CHAR | 2 | T356A | ARTPR | |||
| PRIOK | Priority | PRIOK | CHAR | 1 | T356 | PRIOK | PRIOK | ||
| EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
| BAUTL | Assembly | BAUTL | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
| ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | ILOA | ILOAN | |||
| ILOAI | ILOA Individual | ILOAI | CHAR | 1 | X | ||||
| ANLZU | Syst.Condition | ANLZU | CHAR | 1 | T357M | ANLZU | |||
| IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T399I | WERKS | IWK | ||
| INGPR | Planner Group for Customer Service and Plant Maintenance | INGRP | CHAR | 3 | T024I | INGRP | IHG | ||
| APGRP | Responsible planner group/department | VAGRP | CHAR | 3 | T024A | VAGRP | H_T024A | ||
| PM_OBJTY | Object Type of CIM Resources for Work Center | PM_OBJTY | CHAR | 2 | CR_OBJTY | ||||
| GEWRK | Object ID of the Work Center | LGWID | NUMC | 8 | CRID | CR_OBJID | |||
| KUNUM | Customer Number | KUNUM | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
| ANING | Name of Person Reponsible for System | ANING | CHAR | 12 | USNAM | ||||
| GAUZT | Planned downtime in hours | GAUZT | FLTP | 16(16) | FLTP | ||||
| GAUEH | Unit for Breakdown Duration | MAUEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ANLBD | Date until which the system is available | ANLBD | DATS | 8 | DATUM | ||||
| ANLVD | Date from which the system is available | ANLVD | DATS | 8 | DATUM | ||||
| ANLBZ | Time until which the system is available | ANLBZ | TIMS | 6 | UHRZT | ||||
| ANLVZ | Time from Which System is Available | ANLVZ | TIMS | 6 | UHRZT | ||||
| INSPK | Name of Person Responsible for Technical Inspection | INSPK | CHAR | 12 | USNAM | ||||
| DATAN | Date of Technical Inspection | DATAN | DATS | 8 | DATUM | ||||
| WARPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
| ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | ABNUM | ||||
| WAPOS | Maintenance item | WAPOS | CHAR | 16 | ALPHA | POSNU | MPS | MPOSL | |
| LAUFN | Order number | LAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
| OBKNR | Object list number | OBJKNR | INT4 | 10 | SER00 | OBJKN | |||
| REVNR | Revision for Plant Maintenance and Customer Service | REVNI | CHAR | 8 | T352R | REVNI | |||
| ADDAT | PM Order: Reference Date | ADDAT | DATS | 8 | DATUM | ||||
| ADUHR | Time of Reference Date | ADUHR | TIMS | 6 | UZEIT | ||||
| IPHAS | Maintenance Processing Phase | PM_PHASE | CHAR | 1 | PM_PHASE | ||||
| ILART | Maintenance activity type | ILA | CHAR | 3 | T353I | ILART | H_T350I | ||
| QMNUM | Notification No | QMNUM | CHAR | 12 | QMEL | ALPHA | QMNUM | IQM | |
| HISDA | PM request: History date | HISDA | DATS | 8 | DATUM | ||||
| AKKNZ | Order Category Indicator Plant Maintenance | AKKNZ | CHAR | 1 | AKKNZ | ||||
| PLKNZ | Maintenance order planning indicator | AUF_PLKNZ | CHAR | 1 | AUF_PLKNZ | ||||
| SERIALNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
| SERMAT | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | DEVICEID | ||||
| SCREENTY | Scenario or Subscreen Category | SCRTP | CHAR | 4 | TQBT | SCRTP | |||
| ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40 | ADDCOMPARE_CORE | ADCP | |||
| RSUPG | Upgrade Order Indicator | RSUPG | CHAR | 1 | XFIELD | ||||
| /ISDFPS/OBJNR | Object number | J_OBJNR | CHAR | 22 | J_OBJNR | ONR | |||
| /ISDFPS/MEQUI | Master Equipment | /ISDFPS/MEQUI | CHAR | 18 | ALPHA | EQUNR | |||
| UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII | ||
| ORCOD | PM/CS Order Code Indicating Rotable Process | ADPM_ORDERCODE | CHAR | 1 | ADPM_ORDERCODE | ||||
| PRMAN | CMC: Priority Manually Changed | ADPM_PRMAN | CHAR | 1 | CHAR1 | ||||
| PRVAL | Priority for PM/CS Orders | ADPM_RTPRIO | NUMC | 2 | DOKU_SEQN2 | ||||
| TWTDE | CMC: Use Minimum or Standard TWT from PP Matrix | ADPM_TWTFLAG | CHAR | 1 | CHAR1 | ||||
| MSTCK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| AUART | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
| AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
| REFNR | Reference order number | AUFREFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANV | |
| ERNAM | Entered by | AUFERFNAM | CHAR | 12 | USNAM | ||||
| ERDAT | Created on | AUFERFDAT | DATS | 8 | DATUM | ||||
| AENAM | Last changed by | AUFAENAM | CHAR | 12 | USNAM | ||||
| AEDAT | Change date for Order Master | AUFAEDAT | DATS | 8 | DATUM | ||||
| KTEXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
| LTEXT | Long Text Exists | AUFLTEXT | CHAR | 1 | XFELD | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
| CCKEY | Cost collector key | CCKEY | CHAR | 23 | CCKEY | ||||
| KOSTV | Responsible cost center | AUFKOSTV | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
| SOWRK | Location plant | AUFSOWRK | CHAR | 4 | T001W | WERKS | |||
| ASTKZ | Identifier for statistical order | AUFSTKZ | CHAR | 1 | XFELD | ||||
| WAERS | Order Currency | AUFWAERS | CUKY | 5 | TCURC | WAERS | |||
| ASTNR | Order status | AUFASTNR | NUMC | 2 | AUFSTNR | ||||
| STDAT | Date of last status change | AUFSTDAT | DATS | 8 | DATUM | ||||
| ESTNR | Status reached so far | AUFESTNR | NUMC | 2 | TKO03 | AUFSTNR | |||
| PDAT1 | Planned release date | AUFPDAT1 | DATS | 8 | DATUM | ||||
| PDAT2 | Planned completion date | AUFPDAT2 | DATS | 8 | DATUM | ||||
| PDAT3 | Planned closing date | AUFPDAT3 | DATS | 8 | DATUM | ||||
| IDAT1 | Release date | AUFIDAT1 | DATS | 8 | DATUM | ||||
| IDAT2 | Technical completion date | AUFIDAT2 | DATS | 8 | DATUM | ||||
| IDAT3 | Close date | AUFIDAT3 | DATS | 8 | DATUM | ||||
| OBJID | Object ID | CCOBJID | CHAR | 1 | CHAR1 | ||||
| VOGRP | Group of disallowed transactions | AUFSPSET | CHAR | 4 | TKAVG | VOGRP | |||
| LOEKZ | Deletion flag | AUFLOEKZ | CHAR | 1 | XFELD | ||||
| PLGKZ | Identifier for planning with line items | PLGKZ | CHAR | 1 | XFELD | ||||
| KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | T681V | KVEWE | KVW | ||
| KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
| KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | T683 | KALSM | |||
| ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
| ABKRS | Processing group | AUFABKRS | NUMC | 2 | TKO08 | AKREIS | AKR | ||
| KSTAR | Settlement cost element | AUFKSTAR | CHAR | 10 | CSKB | ALPHA | KSTAR | ||
| SAKNR | G/L account for basic settlement | AUFSAKNR | CHAR | 10 | SKB1 | ALPHA | SAKNR | SAK | |
| SETNM | Allocation set | AUFSETNM | CHAR | 12 | SETNR | GSE | |||
| CYCLE | Cost center to which costs are actually posted | ST_KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
| SDATE | Start Date | SDATE | DATS | 8 | SDATE | GAS | |||
| SEQNR | Sequence number | AUFSEQNR | NUMC | 4 | SQNR | ||||
| USER2 | Person responsible | AUFUSER2 | CHAR | 20 | AUFUSER2 | ||||
| USER4 | Estimated total costs of order | AUFUSER4 | CURR | 11(2) | AUFUSER4 | ||||
| OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| PSPEL | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
| AWSLS | Variance Key | AWSLS | CHAR | 6 | TKV01 | AWSLS | |||
| ABGSL | Results Analysis Key | ABGR_SCHL | CHAR | 6 | TKKAA | ABGR_SCHL | ACS | ||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
| FUNC_AREA | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
| SCOPE | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
| KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
| IVPRO | Investment measure profile | IM_PROFIL | CHAR | 6 | TAPRF | IM_PROFIL | |||
| ABUKR | Requesting company code | IM_ABUKRS | CHAR | 4 | T001 | BUKRS | BUK | ||
| SIZECL | Scale of investment objects | IM_SIZECL | CHAR | 2 | TAIF5 | ALPHA | SIZECL | ||
| IZWEK | Reason for investment | IZWEK | CHAR | 2 | T087I | IZWEK | |||
| UMWKZ | Reason for environmental investment | AM_UMWKZ | CHAR | 5 | T087K | AM_UMWKZ | |||
| RSORD | Refurbishment order indicator (PM) | RSORD | CHAR | 1 | XFELD | ||||
| BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | BEMOT | |||
| ADRNRA | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
| ERFZEIT | Time created | CO_INS_TIME | TIMS | 6 | UZEIT | ||||
| AEZEIT | Changed at | CO_CHG_TIME | TIMS | 6 | UZEIT | ||||
| CSTG_VRNT | Costing Variant | CK_KLVAR | CHAR | 4 | KLVAR | KRT | |||
| COSTESTNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | CK_KALNR | KNR | |||
| VERAA_USER | Person Responsible for CO Internal Order | VERAA_USER | CHAR | 12 | USR02 | XUBNAME | XUS | ||
| DUMMY_CI_AUFK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| VNAME | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
| RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
| ETYPE | Equity type | JV_ETYPE | CHAR | 3 | T8JG | ALPHA | JV_ETYPE | ||
| OTYPE | Joint Venture Object Type | JV_OTYPE | CHAR | 4 | ALPHA | JV_OTYPE | |||
| JV_JIBCL | JIB/JIBE Class | JV_JIBCL | CHAR | 3 | T8J6A | JV_JIBCL | JIB | ||
| JV_JIBSA | JIB/JIBE Subclass A | JV_JIBSA | CHAR | 5 | T8J6C | JV_JIBSA | JBS | ||
| JV_OCO | JV original cost object | JV_OR_CO | CHAR | 1 | JV_OR_COB | ||||
| CPD_UPDAT | Time Stamp | /CPD/PFP_TSTMP | DEC | 15 | TSTLC | /CPD/PFP_TSTMP | |||
| /CUM/INDCU | CU: Order is Used for Compatible Units | /CUM/INDCU | CHAR | 1 | FLAG | ||||
| /CUM/CMNUM | CU: Construction Measure Number | /CUM/CMNUM | CHAR | 12 | ALPHA | /CUM/CMNUM | /CUM/CMNUM | /CUM/V_CMNUM_ALL | |
| /CUM/AUEST | CU: Automatic Copy of Estimated Costs | /CUM/AUEST | CHAR | 1 | FLAG | ||||
| /CUM/DESNUM | CU: Design Number | /CUM/DESNUM | CHAR | 12 | ALPHA | /CUM/DESNUM | /CUM/DESNUM | ||
| /MRSS/PL_STRU_ID | Resource planning nodes | /MRSS/T_PLAN_STRUCT_ID | NUMC | 8 | CR_OBJID | ||||
| /MRSS/PL_MAN_TYP | Assignment to resource planner or contact person | /MRSS/T_MANAGER_TYPE | CHAR | 1 | /MRSS/_MANAGER_TYPE | ||||
| /MRSS/ORDER_PROB | Order probability in percent | /MRSS/T_ORDER_PROB | CHAR | 3 | OPROB | /MRSS/_ORDER_PROB | |||
| /MRSS/ACT_TYPE | Process variant | /MRSS/T_ACTIVITY_TYPE | CHAR | 1 | /MRSS/_ACTIVITY_TYPE | ||||
| /MRSS/INIT_DONE | Internal initialization carried out once | /MRSS/T_INIT_DONE | CHAR | 1 | FLAG | ||||
| /MRSS/DATACHANGE | Data was changed in the controls on the user screen | /MRSS/T_USCREENCTL_DATACHANGED | CHAR | 1 | FLAG | ||||
| /MRSS/SALES_ORG | Sales Organization | VKORG | CHAR | 4 | VKORG | VKO | C_VKORG | ||
| /MRSS/NW_BOOKED | Network Set to 'Booked' | /MRSS/T_NW_BOOKED | CHAR | 1 | FLAG | ||||
| AD01PROFNR | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8 | AD01C_PROF | AD01PROFNR | AD0 | DIP_PROFILE | |
| VAPLZ | Main work center for maintenance tasks | GEWRK | CHAR | 8 | ARBPL | VAP | |||
| WAWRK | Plant associated with main work center | WERGW | CHAR | 4 | WERKS | ||||
| FERC_IND | Regulatory indicator | FE_IND | CHAR | 4 | FERC_C7 | ALPHA | FE_IND | ||
| AUFK_STATUS | Status Combination | ACTCMB_DELE | INT1 | 3 | ACTCMB_TAB | ACTCMB_DOM | |||
| CLAIM_CONTROL | Claim creation control indicator | WTYSC_CLAIM_CONTROL | CHAR | 1 | WTYSCC_CLM_CONT | WTYSC_CLAIM_CONTROL | |||
| UPDATE_NEEDED | Claim inconsistency with order indicator | WTYSC_UPDATE_NEEDED | CHAR | 1 | WTYSC_UPDATE_NEEDED | ||||
| UPDATE_CONTROL | Claim update trigger point from service order | WTYSC_UPDATE_CONTROL | CHAR | 1 | WTYSCC_UPDT_CONT | WTYSC_UPDATE_CONTROL | |||
| GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
| GSTRP | Basic Start Date | PM_ORDGSTRP | DATS | 8 | DATUM | ||||
| FTRMS | Scheduled release date | CO_FTRMS | DATS | 8 | DATUM | ||||
| GLTRS | Scheduled finish | CO_GLTRS | DATS | 8 | DATUM | ||||
| GSTRS | Scheduled start | CO_GSTRS | DATS | 8 | DATUM | ||||
| GSTRI | Actual start date | CO_GSTRI | DATS | 8 | DATUM | ||||
| GETRI | Confirmed Order Finish Date | CO_GETRI | DATS | 8 | DATUM | ||||
| GLTRI | Actual finish date | CO_GLTRI | DATS | 8 | DATUM | ||||
| FTRMI | Actual release date | CO_FTRMI | DATS | 8 | DATUM | ||||
| FTRMP | Planned release date | CO_FTRMP | DATS | 8 | DATUM | ||||
| RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | RSNUM | RES | |||
| GASMG | Total scrap quantity in the order | GASMG | QUAN | 13(3) | MENG13 | ||||
| GAMNG | Total order quantity | GAMNG | QUAN | 13(3) | MENG13 | ||||
| GMEIN | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| PLNBEZ | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| PLNTY | Task List Type | PLNTY | CHAR | 1 | PLNTY | PTY | H_TCA01 | ||
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
| PLNAW | Application of the task list | PLNAW | CHAR | 1 | TCA09 | PLNAW | |||
| PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
| PVERW | Task list usage | PLN_VERWE | CHAR | 3 | T411 | PLN_VERWE | H_T411 | ||
| PLAUF | Date for routing transfer | CO_PLAUF | DATS | 8 | DATUM | ||||
| PLSVB | To lot size | LOSGRBIS | QUAN | 13(3) | MENG13 | ||||
| PLNME | Task list unit of measure | PLNME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| PLSVN | From Lot Size | LOSGRVON | QUAN | 13(3) | MENG13 | ||||
| PDATV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
| PAENR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
| PLGRP | Responsible planner group/department | VAGRP | CHAR | 3 | T024A | VAGRP | H_T024A | ||
| LODIV | Lot size divisor | LOSDIV | QUAN | 13(3) | MENG13 | ||||
| STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
| STLBEZ | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| STLST | BOM status | STLST | NUMC | 2 | T415S | STLST | |||
| STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
| SDATV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
| SBMNG | Base quantity | BASMN | QUAN | 13(3) | MENG13 | ||||
| SBMEH | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| SAENR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
| STLAL | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
| STLAN | BOM Usage | STLAN | CHAR | 1 | T416 | STLAN | CSV | ||
| SLSVN | From Lot Size | LOSVN | QUAN | 13(3) | MENG13 | ||||
| SLSBS | To Lot Size | LOSBS | QUAN | 13(3) | MENG13 | ||||
| AUFLD | Date of BOM Explosion/Routing Transfer | CO_AUFLD | DATS | 8 | DATUM | ||||
| DISPO | MRP controller for the order | CO_DISPO | CHAR | 3 | T024D | DISPO | DGR | ||
| FEVOR | Production Supervisor | FEVOR | CHAR | 3 | T024F | FEVOR | CFV | ||
| FHORI | Scheduling Margin Key for Floats | FHORI | CHAR | 3 | T436A | FHORI | |||
| TERKZ | Scheduling type | TERMKZ | CHAR | 1 | T482 | TERART | |||
| REDKZ | Reduction indicator for scheduling | REDKZ | CHAR | 1 | REDKZ | ||||
| APRIO | Order priority | CO_APRIO | CHAR | 1 | CHAR1 | ||||
| AUFNT | Number of superior network | CO_TEILNET | CHAR | 12 | ALPHA | AUFNR | |||
| AUFPT | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
| APLZT | General counter for order | CO_APLZL | NUMC | 8 | CO_APLZL | ||||
| PROFID | Network profile | PROFIDNZPL | CHAR | 7 | TCN41 | PROFILID | PNW | ||
| VORGZ | Float before production (in days) | VORGZ | NUMC | 3 | NUM3 | ||||
| SICHZ | Float after production (in days) | SICHZ | NUMC | 3 | NUM3 | ||||
| FREIZ | Release period (in days) | FREIZ | NUMC | 3 | NUM3 | ||||
| UPTER | Indicator: Change to Scheduled Dates | CO_UPTER | CHAR | 1 | CHAR1 | ||||
| BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | BEDID | ||||
| PRONR | Project definition | PS_PSP_PRO | NUMC | 8 | PROJ | KONPD | PS_PSPNR | ||
| ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| MZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| ZKRIZ | Counter for additional criteria | DZKRIZ | NUMC | 7 | ZKRIZ | ||||
| PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QPLOS | QLS | QALS | ||
| KLVARP | Costing variant for planned costs | KALKVARPLN | CHAR | 4 | KLVAR | ||||
| KLVARI | Costing variant for actual costs | KALKVARIST | CHAR | 4 | KLVAR | ||||
| RGEKZ | Indicator: Backflushing for order | CO_RGEKZ | CHAR | 1 | CO_RGEKZ | ||||
| PLART | Basis for scheduling | PS_PLART | CHAR | 1 | PS_PLART | ||||
| MAUFNR | Number of superior order | MAUFNR | CHAR | 12 | ALPHA | AUFNR | UAF | ||
| LEAD_AUFNR | Leading order in current processing | CO_LAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
| GLUZP | Basic finish (time) | CO_GLUZP | TIMS | 6 | UHRZT | ||||
| GSUZP | Basic start time | CO_GSUZP | TIMS | 6 | UHRZT | ||||
| GLUZS | Scheduled finish time | CO_GLUZS | TIMS | 6 | UHRZT | ||||
| GSUZS | Scheduled Start (Time) | CO_GSUZS | TIMS | 6 | ATIME | ||||
| GEUZI | Confirmed order finish (time) | CO_GEUZI | TIMS | 6 | UHRZT | ||||
| GSUZI | Actual start time | CO_GSUZI | TIMS | 6 | UHRZT | ||||
| NO_DISP | Effective for Materials Planning | NO_DISP_PLUS | CHAR | 1 | NO_DISP_PLUS | ||||
| STORT | Location of maintenance object | PMLOC | CHAR | 10 | T499S | AP_STAND | |||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | ALPHA | KOSTL | KOS | ||
| ABCKZ | ABC indicator for technical object | ABCKZ | CHAR | 1 | T370C | ABCKZ | |||
| EQFNR | Sort field | EQFNR | CHAR | 30 | CHAR30 | ||||
| SWERK | Maintenance plant | SWERK | CHAR | 4 | T001W | WERKS | SWK | ||
| MSGRP | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
| BEBER | Plant section | BEBER | CHAR | 3 | T357 | BEBER | BBE | ||
| CR_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
| PPSID | Object ID of PP work center | PPSID | NUMC | 8 | CRID | CR_OBJID | |||
| PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
| ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | ALPHA | ANLN1 | AN1 | ||
| ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | ALPHA | ANLN2 | AN2 | ||
| DAUFN | Standing order number | DAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDP | |
| OWNER | Object reference indicator | ILOM_OWNER | CHAR | 1 | ILOM_OWNER | ||||
| VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
| SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
| ADRNR_ILOA | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
| 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 | |||
| V_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 | ||||
| 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 | ||||
| LOGRP | Wage group | LOHNGRP | CHAR | 3 | T421 | LOHNGRP | |||
| SUMNR | Node number of the superior operation | SUMKNTNR | NUMC | 8 | KNTNR | ||||
| 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 | |
| V_WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA | ALPHA | INFNR | INF | MEIN_C |
| EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
| EKGRP | Purchasing group for external processing | VG_EKGRP | CHAR | 3 | T024 | EKGRP | |||
| MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
| ANZZL | Number of capacities required | ANZKAP | INT1 | 3 | INT1 | ||||
| PRZNT | Work percentage | APROZENT | INT1 | 3 | INT1 | ||||
| INDET | Key for calculation | INDET | CHAR | 1 | INDET | ||||
| LARNT | Activity Type | LSTAR | CHAR | 6 | LSTAR | LAR | LART_EMPTY | ||
| RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
| RMZHL | Confirmation counter | CO_RMZHL | NUMC | 8 | CIM_COUNT | RZL | |||
| V_OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
| 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 | |||
| SELKZ | Selection indicator for costing line items | CO_SELKZ | CHAR | 1 | TCK08 | CK_SELKZ | |||
| V_ANLZU | Syst.Condition | ANLZU | CHAR | 1 | T357M | ANLZU | |||
| V_ISTRU | Assembly | ISTRU | CHAR | 18 | MARA | MATN1 | MATNR | ||
| EBORT | Installation Point for Subitem | EBORT | CHAR | 20 | TEXT20 | ||||
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
| WEMPF | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | WEMPF | ||||
| PERNR | Personnel number | CO_PERNR | NUMC | 8 | PERNR | PER | |||
| TXTSP | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
| PHFLG | Indicator: Phase | PHFLG | CHAR | 1 | XFELD | ||||
| MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| DAUNO | Normal duration of the activity | DAUNOR | QUAN | 5(1) | DAUER_4_1 | ||||
| DAUNE | Normal duration/unit | DAUNORE | UNIT | 3 | T006 | CUNIT | MEINS | ||
| DAUMI | Minimum activity duration | DAUMIN | QUAN | 5(1) | DAUER_4_1 | ||||
| DAUME | Unit for the minimum duration | DAUMINE | UNIT | 3 | T006 | CUNIT | MEINS | ||
| EINSA | Constraint on the basic start date for the activity | EINSCHRA | CHAR | 1 | RESTRIKSTR | ||||
| EINSE | Constraint on the finish date of the activity | EINSCHRE | CHAR | 1 | RESTRIKEND | ||||
| ARBEI | Work involved in the activity | ARBEIT | QUAN | 7(1) | ARBEIT | ||||
| ARBEH | Unit for work | ARBEITE | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ISMNW | Actual work | CO_ISMNW | QUAN | 13(3) | MENG13 | ||||
| FSAVD | Earliest scheduled start: Execution (date) | FSAVD | DATS | 8 | DATUM | ||||
| FSAVZ | Earliest scheduled start: Execution (time) | FSAVZ | TIMS | 6 | ATIME | ||||
| FSEDD | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 8 | DATUM | ||||
| FSEDZ | Earliest scheduled finish: Execution (time) | FSEDZ | TIMS | 6 | ATIME | ||||
| SSAVD | Latest scheduled start: Execution (date) | SSAVD | DATS | 8 | DATUM | ||||
| SSAVZ | Latest scheduled start: Execution (time) | SSAVZ | TIMS | 6 | ATIME | ||||
| SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
| SSEDZ | Latest scheduled finish: Execution (time) | SSEDZ | TIMS | 6 | ATIME | ||||
| ISDD | Actual start: Execution (date) | ISDD | DATS | 8 | DATUM | ||||
| ISDZ | Actual start: Execution/setup (time) | ISDZ | TIMS | 6 | ATIME | ||||
| IEDD | Actual finish: Execution (date) | IEDD | DATS | 8 | DATUM | EDR | |||
| IEDZ | Actual finish: Execution (time) | IEDZ | TIMS | 6 | ATIME | EZR | |||
| PUFFR | Free float | PUFFR_FREI | DEC | 3 | PUFFER | ||||
| PUFGS | Total float | PUFFR_GESM | DEC | 3 | PUFFER | ||||
| NTANF | Constraint for activity start (Basic) | VORGABESTD | DATS | 8 | VORGABESTR | ||||
| NTANZ | Constraint for activity start time (Basic) | VORGABESTZ | TIMS | 6 | ATIME | ||||
| NTEND | Constraint for Finish of Activity (Basic) | VORGABEEND2 | DATS | 8 | VORGABEEND | ||||
| NTENZ | Basic finish time of the activity | VORGABEENZ | TIMS | 6 | ATIME | ||||
| OFMNW | Forecasted work (actual + remaining) | OFMNW | QUAN | 7(1) | ARBEIT | ||||
| AUFKT | Execution Factor | AFAKT | DEC | 3 | AFAKT | ||||
| V_TPLNR | Functional Location | TPLNR | CHAR | 30 | TPLNR | TPLNR | IFL | IFLM | |
| V_EQUNR | Equipment Number | EQUNR | CHAR | 18 | ALPHA | EQUNR | EQN | EQUI | |
| PROJN | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
| V_TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
| V_GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| V_PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| V_ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | CHAR6 | ||||
| V_KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | KALSM | ||||
| V_FUNC_AREA | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
| ILART_OP | Maintenance activity type | ILA | CHAR | 3 | ILART | H_T350I |
| Key field | Non-key field |
How do I retrieve data from SAP table VIAUFK_AFVC using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIAUFK_AFVC to SELECT all data from the tableDATA: WA_VIAUFK_AFVC TYPE VIAUFK_AFVC.
SELECT SINGLE *
FROM VIAUFK_AFVC
INTO CORRESPONDING FIELDS OF WA_VIAUFK_AFVC
WHERE...
How to access SAP table VIAUFK_AFVC
Within an ECC or HANA version of SAP you can also view further information about VIAUFK_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