AFVG_SCHED SAP (Field string: Fields relevant to scheduling) Structure details
Description: Field string: Fields relevant to scheduling
Structure field list including key, data, relationships and ABAP select examples
AFVG_SCHED 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 "Field string: Fields relevant to scheduling" 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_AFVG_SCHED TYPE AFVG_SCHED.
The AFVG_SCHED table consists of various fields, each holding specific information or linking keys about Field string: Fields relevant to scheduling data available in SAP. These include MATKL (Material Group), DDEHN (Indicator: flexible duration), ANZZL (No. of lines per object when list displayed for TJ91), PRZNT (Work percentage).. 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 AFVG_SCHED 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 |
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
DDEHN | Indicator: flexible duration | DAUDEHN | CHAR | 1 | X | ||||
ANZZL | No. of lines per object when list displayed for TJ91 | ANZZL | DEC | 2 | DEC02 | ||||
PRZNT | Work percentage | APROZENT | INT1 | 3 | INT1 | ||||
MLSTN | Usage | MILESTONE | CHAR | 5 | Assigned to domain | MILESTONE | |||
SPANZ | No.of columns | SPANZ | DEC | 3 | PACK2 | ||||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | Assigned to domain | BEDID | |||
BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
PDEST | Printer for shop papers | CR_PDEST | CHAR | 4 | Assigned to domain | SPDEV | RSPOPNAME | ||
KTSCH | Standard text key | KTSCH | CHAR | 7 | Assigned to domain | KTSCH | |||
LTXA1 | Operation short text | LTXA1 | CHAR | 40 | TEXT40 | ||||
TXTSP | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
ZERMA | Type of standard value calculation | DZERMA | CHAR | 5 | Assigned to domain | 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 | Assigned to domain | QUALF | |||
ANZMA | Number of selected materials | ANZMA | NUMC | 6 | NUMC6 | ||||
RFGRP | Setup group category | RUEFAGRP | CHAR | 10 | Assigned to domain | RUEFAGRP | |||
RFSCH | Setup group key | RUEFASCHLU | CHAR | 10 | Assigned to domain | RUEFASCHLU | |||
RASCH | Setup Type Key | RUEARSCHLU | CHAR | 2 | Assigned to domain | RUEARSCHLU | |||
LOGRP | Wage group | LOHNGRP | CHAR | 3 | Assigned to domain | 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 | ||||
ABLIP | Indicator: simultaneous teardown and wait | ABLIPKZ | CHAR | 1 | FLAG | ||||
RSTRA | Reduction strategy per operation/activity | RSTRA | CHAR | 2 | Assigned to domain | RSTRA | |||
SORTL | Sort Term for Non-Stock Info Records | SORTI | CHAR | 10 | CHAR10 | ||||
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 | AFVC | CO_APLZL | |||
SLWID | Key word ID for user-defined fields | SLWID | CHAR | 7 | TCN00 | SLWID | |||
USR00 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR01 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR02 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USR03 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USE04 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
USR05 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USE05 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
USR06 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USE06 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | WAERS | |||
USR07 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USE07 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | WAERS | |||
USR08 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USR09 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USR10 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
USR11 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
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 | ||
JV_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 | ||||
DUMMY_CI_AFVU | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
SPARAMETER1 | Scheduling Parameters for External Scheduling | SPARAMETER | CHAR | 4 | TSCHEDULEPARAM1 | ||||
SPARAMETER2 | Scheduling Parameters for External Scheduling | SPARAMETER | CHAR | 4 | TSCHEDULEPARAM2 | ||||
SPARAMETER3 | Scheduling Parameters for External Scheduling | SPARAMETER | CHAR | 4 | TSCHEDULEPARAM3 | ||||
.INCLU--AP | 0 | ||||||||
/MRSS/ID_PROFILE | Requirements Profile Was Changed Manually | /MRSS/T_REQU_UPD | CHAR | 1 | /MRSS/_HCM_BOOLEAN | ||||
/MRSS/PROF_KEY | Profile Key | /MRSS/T_RSG_REQUID | CHAR | 10 | ALPHA | /MRSS/RSG_REQUID | |||
/MRSS/PROF_GUID | Character field, length 32 | CHAR32 | CHAR | 32 | CHAR32 | ||||
/MRSS/ACT_TYPE | Process variant | /MRSS/T_ACTIVITY_TYPE | CHAR | 1 | /MRSS/_ACTIVITY_TYPE | ||||
/MRSS/ORDER_PROB | Order probability in percent | /MRSS/T_ORDER_PROB | CHAR | 3 | OPROB | /MRSS/_ORDER_PROB | |||
/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/DEM_COUNT | Counter for Demands in Operation | /MRSS/T_DEM_COUNT | NUMC | 4 | NUMC4 | ||||
/MRSS/SUPERV_CNT | Number of Site Supervisors | /MRSS/T_RAP_SUPERVISOR_COUNT | CHAR | 2 | ALPHA | /MRSS/_RAP_SUPERVISOR_COUNT | |||
/MRSS/RULE_ID | Time Rule Id | /MRSS/T_RSG_TIME_RULE_ID | CHAR | 25 | TEXT25 | ||||
/MRSS/SALES_ORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
/MRSS/REFF_RCNT | Determination of Remaining Demand: No. of Resources | /MRSS/T_REM_EFFORT_RES_COUNT | NUMC | 3 | NUMC3 | ||||
/MRSS/REFF_E_BEG | Time stamp: start | /MRSS/T_TIMESTAMP_BEGIN | NUMC | 14 | TSTLC | /MRSS/_TIMESTAMP | |||
/MRSS/REFF_E_END | Time stamp: end | /MRSS/T_TIMESTAMP_END | NUMC | 14 | TSTLC | /MRSS/_TIMESTAMP | |||
/MRSS/REFF_L_BEG | Time stamp: start | /MRSS/T_TIMESTAMP_BEGIN | NUMC | 14 | TSTLC | /MRSS/_TIMESTAMP | |||
/MRSS/REFF_L_END | Time stamp: end | /MRSS/T_TIMESTAMP_END | NUMC | 14 | TSTLC | /MRSS/_TIMESTAMP | |||
/MRSS/RELEVANT | Operation Set as MRS-Relevant | /MRSS/T_RELEVANT_FOR_MRS | CHAR | 1 | FLAG | ||||
/MRSS/TEAM_PLAN | Team Planning flag for Demand | /MRSS/T_RSG_TEAM_PLANNING | CHAR | 1 | /MRSS/_RSG_TEAM_PLANNING | ||||
/MRSS/SINGL_RES | Indicator for Forcing a Single Resource | /MRSS/T_RSG_FORCE_SINGLE_RES | CHAR | 1 | /MRSS/_BOOLEAN | ||||
/MRSS/TO_BEGDAT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/MRSS/TO_BEGTIM | Field of type TIMS | TIMS | TIMS | 6 | TIME | ||||
/MRSS/TO_ENDDAT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/MRSS/TO_ENDTIM | Field of type TIMS | TIMS | TIMS | 6 | TIME | ||||
/MRSS/TO_DURAT | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
/MRSS/TO_DUNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
/MRSS/TO_DISTAN | 19 Characters | CHAR19 | CHAR | 19 | CHAR19 | ||||
/MRSS/TO_MANUAL | Boolean Variable | /MRSS/T_RSG_BOOLEAN | CHAR | 1 | /MRSS/_RSG_BOOLEAN | ||||
/MRSS/FR_BEGDAT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/MRSS/FR_BEGTIM | Field of type TIMS | TIMS | TIMS | 6 | TIME | ||||
/MRSS/FR_ENDDAT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
/MRSS/FR_ENDTIM | Field of type TIMS | TIMS | TIMS | 6 | TIME | ||||
/MRSS/FR_DURAT | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
/MRSS/FR_DUNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
/MRSS/FR_DISTAN | 19 Characters | CHAR19 | CHAR | 19 | CHAR19 | ||||
/MRSS/FR_MANUAL | Boolean Variable | /MRSS/T_RSG_BOOLEAN | CHAR | 1 | /MRSS/_RSG_BOOLEAN | ||||
.INCLU--AP | 0 | ||||||||
ILART_OP | Maintenance activity type | ILA | CHAR | 3 | Assigned to domain | ILART | H_T350I | ||
.INCLU--AP | 0 | ||||||||
FERC_IND | Regulatory indicator | FE_IND | CHAR | 4 | FERC_C7 | ALPHA | FE_IND | ||
FLGAT | Sequence category | FOLGENART | CHAR | 1 | TCA07 | FLGAT | |||
APLFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
LOSVG | Operation quantity in order unit of measure | CX_LOSVG | QUAN | 13(3) | MENG13 | ||||
LOSME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
FLG_KMP | Indicator: Components allocated | FLG_KMP | CHAR | 1 | KREUZ | ||||
FLG_PRM | Indicator: Inspection Characteristics Assigned | FLG_PRM | CHAR | 1 | KREUZ | ||||
FLG_FHM | Indicator: PRTs Assigned | FLG_FHT | CHAR | 1 | KREUZ | ||||
FLG_EVP | Indicator: Trigger points allocated | FLG_EVP | CHAR | 1 | KREUZ | ||||
FLG_PST | Indicator: PS texts exist | FLG_PST | CHAR | 1 | KREUZ | ||||
UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
DAWAR | Queue time | CO_DAUWAR | QUAN | 7(1) | DAUER_6_1 | ||||
DARUE | Setup time | CO_DAURUE | QUAN | 7(1) | DAUER_6_1 | ||||
DABEA | Processing time | CO_DAUBEA | QUAN | 7(1) | DAUER_6_1 | ||||
DAABR | Teardown time | CO_DAUABR | QUAN | 7(1) | DAUER_6_1 | ||||
DALIE | Wait time | CO_DAULIE | QUAN | 7(1) | DAUER_6_1 | ||||
VSTTXT | System Status | CO_STTXT | CHAR | 40 | CHAR40 | ||||
FLG_UVO | Indicator: Suboperation exists | FLG_UVO | CHAR | 1 | XFELD | ||||
FLG_MST | Indicator: Milestone | FLG_MST | CHAR | 1 | XFELD | ||||
FLG_RCK | Indicator: Operation requires confirmation | FLG_RCK | CHAR | 1 | XFELD | ||||
FLG_OFF | Indicator: Open operation (not finally confirmed) | FLG_OFF | CHAR | 1 | XFELD | ||||
FLG_FRE | Indicator: Release operation | FLG_FRE | CHAR | 1 | XFELD | ||||
FLG_LOE | Indicator: Operation is deleted | FLG_LOE | CHAR | 1 | XFELD | ||||
FLG_FRD | Indicator: Operation is processed externally | FLG_FRD | CHAR | 1 | XFELD | ||||
FLG_AWE | Indicator: automatic goods receipt | FLG_AWE | CHAR | 1 | XFELD | ||||
VART | Dummy | CIM_VART | CHAR | 1 | CIM_VART | ||||
INDBT | Field defined as in SY-TABIX | TABIX_D | INT4 | 10 | TABIX | ||||
AUFNRD | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
DAPBE | Duration of processing time (forecast) | CO_DAUBEAP | QUAN | 7(1) | DAUER_6_1 | ||||
WEMNG_OPR | Quantity of Goods Received | WEMNG | QUAN | 13(3) | MENG13 | ||||
WEMEH_OPR | Purchase Order Unit of Measure | BSTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DATRA | Duration of move time | CO_DAUTRA | QUAN | 7(1) | DAUER_6_1 | ||||
DADRF | Duration of execution time (setup + processing + teardown) | CO_DAUDRF | QUAN | 7(1) | DAUER_6_1 | ||||
FSEVD | Earliest finish of operation (date) | FSEVD | DATS | 8 | DATUM | ||||
FSEVZ | Earliest finish of operation (time) | FSEVZ | TIMS | 6 | ATIME | ||||
SSEVD | Latest finish date of operation | SSEVD | DATS | 8 | DATUM | ||||
SSEVZ | Latest operation finish (time) | SSEVZ | TIMS | 6 | ATIME | ||||
BANFN_DEL | Purchase requisition number | CO_BANFN | CHAR | 10 | ALPHA | BANFN | |||
BNFPO_DEL | Item number of the purchase requisition in the order | CO_BNFPO | NUMC | 5 | Assigned to domain | BNFPO | |||
KALTX | Description of the factory calendar | KALTX | CHAR | 20 | TEXT20 | ||||
FLG_PURS | Indicator: Purchase order exists | FLG_PURS | CHAR | 1 | KREUZ | ||||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | EKKO | ALPHA | EBELN | KTR | |
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | EKPO | EBELP | |||
PVZNR | Superordinate Operation | PVZNR | CHAR | 4 | NUMCV | VORNR | |||
PVZIN | Field defined as in SY-TABIX | TABIX_D | INT4 | 10 | TABIX | ||||
FLG_VAB | Indicator: Sub-network exists | FLG_VAB | CHAR | 1 | X | ||||
QLSEARCH | Search term for qualification requirements | QL_SEARCH | CHAR | 12 | TEXT12 | ||||
QLSTEXT | Object Name | STEXT | CHAR | 40 | TEXT40 | ||||
PSTXTAR | Type of PS text to be copied into the purchase requisition | NPTXART | CHAR | 2 | Assigned to domain | TXTAR | |||
PSTXTTI | PS text description | TXTTI | CHAR | 20 | CHAR20 | ||||
INDEXSUMNR | Field defined as in SY-TABIX | TABIX_D | INT4 | 10 | TABIX | ||||
ARBPI | Actual work center | ARBPL_I | CHAR | 8 | ARBPL | AGR | |||
AUDISP | Reservation Relevance/Generation of Purchase Requisition | AUDISP_PLUS | CHAR | 1 | AUDISP | ||||
FLIEF | Fixed Vendor | FLIEF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
TXCHG | Indicator: long text changed | TXCHG | CHAR | 1 | XFELD | ||||
COMP_RES | OCM: Result of comparison of two order objects | OCM_COMP_RES | CHAR | 1 | OCM_COMP_RES | ||||
ASKUM | Cumulative Scrap Qty of Subsequent Reporting Pts (Cur. Per.) | X_KUM_PER | QUAN | 13(3) | MENG13 | ||||
PSTXCHG | Ind.: Changed PS text | PSTXCHG | CHAR | 1 | XFELD | ||||
FLG_DL | Document links exist | FLG_DL | CHAR | 1 | KREUZ | ||||
FLG_CALC | Indicator: Order (network etc.) still to be calculated | FLG_CALC | CHAR | 1 | KREUZ | ||||
SPLQ | Split Quantity in Order Split | SPLIT_QTY | QUAN | 13(3) | MENG13 | ||||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
TPLNR | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
IDENT | Operation ID | OPRID | CHAR | 8 | CHAR8 | ||||
SERVCHG | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
FLG_OBJ | KNOBJ Is Filled, Object Dependencies Exist | CKKNOBJON | CHAR | 1 | XFELD | ||||
QMNUM | Notification No | QMNUM | CHAR | 12 | Assigned to domain | ALPHA | QMNUM | IQM | |
NPLDA | Next planned date | NPLDA | DATS | 8 | DATUM | ||||
EPROFILE | External Procurement Profile | MEPROFILE | CHAR | 2 | EPROFILE | ||||
.INCLU--AP | 0 | ||||||||
/CUM/INTCUNR | CU: Internal CU Number in a Work Order | /CUM/INTCUNR | NUMC | 6 | NUMC6 |
Key field | Non-key field |
How do I retrieve data from SAP structure AFVG_SCHED using ABAP code?
As AFVG_SCHED 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 AFVG_SCHED as there is no data to select.How to access SAP table AFVG_SCHED
Within an ECC or HANA version of SAP you can also view further information about AFVG_SCHED 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