VSCAUFV 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
VSCAUFV 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 VSCAUFV table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include VSNMR (Number or description of a version), AUFNR (Order Number), DISPO (MRP controller for the order), PVERW (Task list usage).. 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 VSCAUFV 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 | |||
VSNMR | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | VSAUFK_CN | ALPHA | AUFNR | ANR | |
DISPO | MRP controller for the order | CO_DISPO | CHAR | 3 | T024D | DISPO | DGR | ||
PVERW | Task list usage | PLN_VERWE | CHAR | 3 | T411 | PLN_VERWE | H_T411 | ||
PLNBEZ | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
PLNAW | Application of the task list | PLNAW | CHAR | 1 | TCA09 | PLNAW | |||
PLNTY | Task List Type | PLNTY | CHAR | 1 | PLNTY | PTY | H_TCA01 | ||
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
PLAUF | Date for routing transfer | CO_PLAUF | DATS | 8 | DATUM | ||||
PLGRP | Responsible planner group/department | VAGRP | CHAR | 3 | T024A | VAGRP | H_T024A | ||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | RSNUM | RES | |||
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 | |
STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
STLST | BOM status | STLST | NUMC | 2 | T415S | STLST | |||
STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
STLAN | BOM Usage | STLAN | CHAR | 1 | T416 | STLAN | CSV | ||
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 | |
STLBEZ | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
STLAL | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
AUFLD | Date of BOM Explosion/Routing Transfer | CO_AUFLD | DATS | 8 | DATUM | ||||
PRONR | Project definition | PS_PSP_PRO | NUMC | 8 | VSPROJ_CN | KONPD | PS_PSPNR | ||
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 | ||
ASTKZ | Identifier for statistical order | AUFSTKZ | CHAR | 1 | XFELD | ||||
WAERS | Order Currency | AUFWAERS | CUKY | 5 | TCURC | WAERS | |||
OBJID | Object ID | CCOBJID | CHAR | 1 | CHAR1 | ||||
LOEKZ | Deletion flag | AUFLOEKZ | CHAR | 1 | XFELD | ||||
PLGKZ | Identifier for planning with line items | PLGKZ | CHAR | 1 | XFELD | ||||
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 | ||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
PSPEL | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | VSPRPS_CN | KONPR | PS_POSNR | ||
FTRMS | Scheduled release date | CO_FTRMS | DATS | 8 | DATUM | ||||
FTRMI | Actual release date | CO_FTRMI | DATS | 8 | DATUM | ||||
FTRMP | Planned release date | CO_FTRMP | DATS | 8 | DATUM | ||||
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 | ||||
SLSVN | From Lot Size | LOSVN | QUAN | 13(3) | MENG13 | ||||
SLSBS | To Lot Size | LOSBS | QUAN | 13(3) | MENG13 | ||||
NTZUE | Superior network number | NETZ_UEBER | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
VORUE | Superior activity | VORG_UEBER | CHAR | 4 | NUMCV | VORNR | |||
GLTRP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
GSTRP | Basic Start Date | PM_ORDGSTRP | 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 | ||||
GLTRI | Actual finish date | CO_GLTRI | DATS | 8 | DATUM | ||||
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 | ||
UPTER | Indicator: Change to Scheduled Dates | CO_UPTER | CHAR | 1 | CHAR1 | ||||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | BEDID | ||||
LODIV | Lot size divisor | LOSDIV | QUAN | 13(3) | MENG13 | ||||
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 | ||||
GETRI | Confirmed Order Finish Date | CO_GETRI | DATS | 8 | DATUM | ||||
PROFID | Network profile | PROFIDNZPL | CHAR | 7 | TCN41 | PROFILID | PNW | ||
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 | QALS | QPLOS | QLS | QALS | |
AWSLS | Variance Key | AWSLS | CHAR | 6 | TKV01 | AWSLS | |||
ABGSL | Results Analysis Key | ABGR_SCHL | CHAR | 6 | TKKAA | ABGR_SCHL | ACS | ||
KLVARP | Costing variant for planned costs | KALKVARPLN | CHAR | 4 | TCK03 | KLVAR | |||
KLVARI | Costing variant for actual costs | KALKVARIST | CHAR | 4 | TCK03 | KLVAR | |||
RGEKZ | Indicator: Backflushing for order | CO_RGEKZ | CHAR | 1 | CO_RGEKZ | ||||
PLART | Basis for scheduling | PS_PLART | CHAR | 1 | PS_PLART | ||||
VNAME | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
RECID | Recovery Indicator | JV_RECIND | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
FLG_AOB | Indicator: relationships | FLG_AOB | CHAR | 1 | FLAG | ||||
FLG_ARBEI | Indicator: Default value work is relevant | FLG_ARBEI | CHAR | 1 | FLAG | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
GLTPP | Finish date (forecast) | CO_GLTPP | DATS | 8 | DATUM | ||||
GSTPP | Forecast start date | CO_GSTPP | DATS | 8 | DATUM | ||||
GLTPS | Scheduled forecast finish | CO_GLTPS | DATS | 8 | DATUM | ||||
GSTPS | Scheduled forecast start | CO_GSTPS | DATS | 8 | DATUM | ||||
FTRPS | Scheduled release date (forecast) | CO_FTRPS | DATS | 8 | DATUM | ||||
RDKZP | Reduction indicator for scheduling (forecast) | REDKZP | CHAR | 1 | REDKZ | ||||
TRKZP | Scheduling type (forecast) | TERMKZP | CHAR | 1 | T482 | TERART | |||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
RMZHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | T681V | KVEWE | KVW | ||
IGMNG | Yield confirmed from order confirmation | CO_IGMNG | QUAN | 13(3) | MENG13 | ||||
IASMG | Scrap confirmed for order | CO_IASMG | QUAN | 13(3) | MENG13 | ||||
ABARB | Confirmation: Degree of processing | CO_ABARB | NUMC | 3 | CO_ABARB | ||||
RATID | ID of the capacity requirements record | BEDID | NUMC | 12 | BEDID | ||||
GROID | ID of the capacity requirements record | BEDID | NUMC | 12 | BEDID | ||||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
GLUZS | Scheduled finish time | CO_GLUZS | TIMS | 6 | UHRZT | ||||
GSUZS | Scheduled Start (Time) | CO_GSUZS | TIMS | 6 | ATIME | ||||
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
STUFE | Level (in multi-level BOM explosions) | HISTU | DEC | 2 | DEC2 | ||||
WEGXX | Path (for multi-level BOM explosions) | WEGXX | DEC | 4 | DEC4 | ||||
VWEGX | Path (for multi-level BOM explosions) | WEGXX | DEC | 4 | DEC4 | ||||
ARSNR | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | RSNUM | RES | |||
ARSPS | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
MAUFNR | Number of superior order | MAUFNR | CHAR | 12 | ALPHA | AUFNR | UAF | ||
LKNOT | Left node in collective order | CO_LKNOT | CHAR | 12 | ALPHA | AUFNR | |||
RKNOT | Right node of a collective order | CO_RKNOT | CHAR | 12 | ALPHA | AUFNR | |||
PRODNET | Indicator: Order is part of collective order | CO_PRODNET | CHAR | 1 | KREUZ | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
SCOPE | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
NO_DISP | Effective for Materials Planning | NO_DISP_PLUS | CHAR | 1 | NO_DISP_PLUS | ||||
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 | ||||
CSPLIT | Apportionment Structure | CSPLIT | CHAR | 4 | MAKV | CSPLIT | |||
AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
CY_SEQNR | Seq. number order | CY_SEQNR | NUMC | 14 | CY_SEQNR | ||||
BREAKS | Indicator: Scheduling allowing for breaks | BREAKS | CHAR | 1 | XFELD | ||||
VORGZ_TRM | Scheduled float before production in days | VORGZ_TRM | DEC | 6(3) | PUFFER_TRM | ||||
SICHZ_TRM | Scheduled float after production in days | SICHZ_TRM | DEC | 6(3) | PUFFER_TRM | ||||
TRMDT | Date of the last scheduling | TRMDT | DATS | 8 | DATUM | ||||
CHSCH | Search procedure for batch determination | KALSMA_CH | CHAR | 6 | T683 | KALSM | |||
GLUZP | Basic finish (time) | CO_GLUZP | TIMS | 6 | UHRZT | ||||
GSUZP | Basic start time | CO_GSUZP | TIMS | 6 | UHRZT | ||||
GSUZI | Actual start time | CO_GSUZI | TIMS | 6 | UHRZT | ||||
GEUZI | Confirmed order finish (time) | CO_GEUZI | TIMS | 6 | UHRZT | ||||
GLUPP | Forecast finish (time) | CO_GLUPP | TIMS | 6 | UHRZT | ||||
GSUPP | Forecast start (time) | CO_GSUPP | TIMS | 6 | UHRZT | ||||
GLUPS | Scheduled forecast finish time | CO_GLUPS | TIMS | 6 | UHRZT | ||||
GSUPS | Scheduled start time (Forecast) | CO_GSUPS | TIMS | 6 | UHRZT | ||||
RSNTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
RSNID | Object ID of the resource | CR_OBJID | NUMC | 8 | CRID | CR_OBJID | |||
KAPT_VORGZ | Float (bef. production) remaining after finite scheduling | KAPT_VORGZ | NUMC | 3 | NUM3 | ||||
KAPT_SICHZ | Remaining float after finite scheduling | KAPT_SICHZ | NUMC | 3 | NUM3 | ||||
LEAD_AUFNR | Leading order in current processing | CO_LAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
PNETSTARTD | Outline start of collective network (date) | CO_PSTARTD | DATS | 8 | DATUM | ||||
PNETSTARTT | Start time of a collective order | CO_PSTARTT | TIMS | 6 | ATIME | ||||
PNETENDD | Outline finish of collective order (date) | CO_PENDD | DATS | 8 | DATUM | ||||
PNETENDT | Outline finish time | CO_PENDT | TIMS | 6 | ATIME | ||||
FLG_MLTPS | Order with multiple items | CO_MLTPS | CHAR | 1 | KREUZ | ||||
NAUTERM | Indicator: Do not schedule automatically | CO_NAUTERM | CHAR | 1 | KREUZ | ||||
NAUCOST | Indicator: Do not cost automatically | CO_NAUCOST | CHAR | 1 | KREUZ | ||||
IDAT2 | Technical completion date | AUFIDAT2 | DATS | 8 | DATUM | ||||
KDAUF_AUFK | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS_AUFK | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
KBED | Ind: do not create capacity requirements | KBED_D | CHAR | 1 | XFELD | ||||
CCKEY | Cost collector key | CCKEY | CHAR | 23 | CCKEY | ||||
KKALKR | Indicator: Components will not be costed | COMP_CALC | CHAR | 1 | XFELD | ||||
SFCPF | Production Scheduling Profile | CO_PRODPRF | CHAR | 6 | TCO43 | CO_PRODPRF | |||
KSTAR | Settlement cost element | AUFKSTAR | CHAR | 10 | CSKB | ALPHA | KSTAR | ||
USER4 | Estimated total costs of order | AUFUSER4 | CURR | 11(2) | AUFUSER4 | ||||
RMNGA | Total confirmed rework quantity | RMNGA | QUAN | 13(3) | MENGV13 | ||||
NOPCOST | Do not calculate planned costs for order | CO_NOPCOST | CHAR | 1 | XFELD | ||||
KSTEMPF | Indicator: Direct cost collector | CO_KSTEMPF | CHAR | 1 | CO_KSTEMPF | ||||
NETZKONT | Indicator for the account assignment of a network(hdr/act.) | NETZKONT | CHAR | 1 | NETZKONT | ||||
EXT_AUFNR | Order Number | AUFNR | CHAR | 12 | ALPHA | AUFNR | ANR | ||
ORGKEY | Order Number | AUFNR | CHAR | 12 | ALPHA | AUFNR | ANR | ||
INACT | Version inactive indicator | VSINACT | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table VSCAUFV using ABAP code
The following ABAP code Example will allow you to do a basic selection on VSCAUFV to SELECT all data from the tableDATA: WA_VSCAUFV TYPE VSCAUFV.
SELECT SINGLE *
FROM VSCAUFV
INTO CORRESPONDING FIELDS OF WA_VSCAUFV
WHERE...
How to access SAP table VSCAUFV
Within an ECC or HANA version of SAP you can also view further information about VSCAUFV 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