AFVG_CLEAR SAP (AFVGB fiels, that are initialised for orders with reference) Structure details
Description: AFVGB fiels, that are initialised for orders with reference
Structure field list including key, data, relationships and ABAP select examples
AFVG_CLEAR 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 "AFVGB fiels, that are initialised for orders with reference" 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_CLEAR TYPE AFVG_CLEAR.
The AFVG_CLEAR table consists of various fields, each holding specific information or linking keys about AFVGB fiels, that are initialised for orders with reference data available in SAP. These include VBKZ (Update indicator), FLG_SEL (Selection flag), AUFNR_T (Order Number), FLG_CALCUL (Indicator: Order (network etc.) still to be calculated).. 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_CLEAR 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 |
VBKZ | Update indicator | VBKZ | CHAR | 1 | VERBUCHER | ||||
FLG_SEL | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
AUFNR_T | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
FLG_CALCUL | Indicator: Order (network etc.) still to be calculated | FLG_CALC | CHAR | 1 | KREUZ | ||||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | CO_RUECK | RCK | |||
RMZHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
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 | Assigned to domain | BNFPO | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
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 | ||||
ANZLU | Syst.Condition | ANLZU | CHAR | 1 | Assigned to domain | ANLZU | |||
LEKNW | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | XFELD | ||||
LMNGA | Total Yield Confirmed | LMNGA | QUAN | 13(3) | MENG13 | ||||
XMNGA | Total scrap quantity confirmed | XMNGA | QUAN | 13(3) | MENG13 | ||||
GMNGA | Confirmed yield in order unit of measure | GMNGA | QUAN | 13(3) | MENG13 | ||||
ISM01 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM02 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM03 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM04 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM05 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM06 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
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 | ||||
FSSBD | Earliest scheduled start: Processing (date) | FSSBD | DATS | 8 | DATUM | ||||
FSSBZ | Earliest scheduled start: Processing (time) | FSSBZ | TIMS | 6 | ATIME | ||||
FSSAD | Earliest scheduled start: Teardown (date) | FSSAD | DATS | 8 | DATUM | ||||
FSSAZ | Earliest scheduled start: Teardown (time) | FSSAZ | TIMS | 6 | ATIME | ||||
FSEDD | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 8 | DATUM | ||||
FSEDZ | Earliest scheduled finish: Execution (time) | FSEDZ | TIMS | 6 | ATIME | ||||
FSSLD | Earliest scheduled start: Wait (date) | FSSLD | DATS | 8 | DATUM | ||||
FSSLZ | Earliest scheduled start: Wait (time) | FSSLZ | TIMS | 6 | ATIME | ||||
FSELD | Earliest scheduled finish: Wait (date) | FSELD | DATS | 8 | DATUM | ||||
FSELZ | Earliest scheduled finish: Wait (time) | FSELZ | TIMS | 6 | ATIME | ||||
SSAVD | Latest scheduled start: Execution (date) | SSAVD | DATS | 8 | DATUM | ||||
SSAVZ | Latest scheduled start: Execution (time) | SSAVZ | TIMS | 6 | ATIME | ||||
SSSBD | Latest scheduled start: Processing (date) | SSSBD | DATS | 8 | DATUM | ||||
SSSBZ | Latest scheduled start: Processing (time) | SSSBZ | TIMS | 6 | ATIME | ||||
SSSAD | Latest scheduled start: Teardown (date) | SSSAD | DATS | 8 | DATUM | ||||
SSSAZ | Latest scheduled start: Teardown (time) | SSSAZ | TIMS | 6 | ATIME | ||||
SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
SSEDZ | Latest scheduled finish: Execution (time) | SSEDZ | TIMS | 6 | ATIME | ||||
SSSLD | Latest scheduled start: Wait time (date) | SSSLD | DATS | 8 | DATUM | ||||
SSSLZ | Latest scheduled start: Wait time | SSSLZ | TIMS | 6 | ATIME | ||||
SSELD | Latest scheduled finish: Wait time (date) | SSELD | DATS | 8 | DATUM | ||||
SSELZ | Latest scheduled finish: Wait time | SSELZ | TIMS | 6 | ATIME | ||||
ISAVD | Actual operation start (date) | ISAVD | DATS | 8 | DATUM | ||||
IEAVD | Actual finish of operation (date) | IEAVD | DATS | 8 | DATUM | ||||
ISDD | Actual start: Execution (date) | ISDD | DATS | 8 | DATUM | ||||
ISDZ | Actual start: Execution/setup (time) | ISDZ | TIMS | 6 | ATIME | ||||
IERD | Actual finish: Setup (date) | IERD | DATS | 8 | DATUM | ||||
IERZ | Actual finish: Setup (time) | IERZ | TIMS | 6 | ATIME | ||||
ISBD | Actual start: Processing (date) | ISBD | DATS | 8 | DATUM | ||||
ISBZ | Actual start: Processing (time) | ISBZ | TIMS | 6 | ATIME | ||||
IEBD | Actual finish: Processing (date) | IEBD | DATS | 8 | DATUM | ||||
IEBZ | Actual processing finish (time) | IEBZ | TIMS | 6 | ATIME | ||||
ISAD | Actual start: Teardown (date) | ISAD | DATS | 8 | DATUM | ||||
ISAZ | Actual start: Teardown (time) | ISAZ | TIMS | 6 | ATIME | ||||
IEDD | Actual finish: Execution (date) | IEDD | DATS | 8 | DATUM | EDR | |||
IEDZ | Actual finish: Execution (time) | IEDZ | TIMS | 6 | ATIME | EZR | |||
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
PEDZ | Forecast finish time of operation from confirmation | CO_PEDZ | TIMS | 6 | ATIME | ||||
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) | VORGABEEND | DATS | 8 | VORGABEEND | ||||
NTENZ | Basic finish time of the activity | VORGABEENZ | TIMS | 6 | ATIME | ||||
EWSTD | Forecasted start date for the activity | EWSTARTD | DATS | 8 | DATUM | ||||
EWSTZ | Forecast start time of the activity | EWSTARTZ | TIMS | 6 | ATIME | ||||
EWEND | Forecast finish date | EWENDED | DATS | 8 | DATUM | ||||
EWENZ | Forecast finish time for the activity | EWENDEZ | TIMS | 6 | ATIME | ||||
EWSTE | Forecast date constraint on activity finish | PS_RESTE | CHAR | 1 | RESTRIKEND | ||||
EWSTA | Forecast date constraint on activity start | PS_RESTA | CHAR | 1 | RESTRIKSTR | ||||
WARTZ | Queue time used for scheduling | WARTEZEIT | FLTP | 16(16) | CX_ZEIT | ||||
ISERH | Confirmed break time | ISERH | QUAN | 9(3) | VGWRT | ||||
OFM01 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM02 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM03 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM04 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM05 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM06 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFMNW | Forecasted work (actual + remaining) | OFMNW | QUAN | 7(1) | ARBEIT | ||||
FPAVD | Earliest scheduled start date (forecast) | FPAVD | DATS | 8 | DATUM | ||||
FPAVZ | Earliest scheduled start time (forecast) | FPAVZ | TIMS | 6 | ATIME | ||||
FPEDD | Earliest scheduled finish date (forecast) | FPEDD | DATS | 8 | DATUM | ||||
FPEDZ | Earliest scheduled finish time (forecast) | FPEDZ | TIMS | 6 | ATIME | ||||
SPAVD | Latest scheduled start date (forecast) | SPAVD | DATS | 8 | DATUM | ||||
SPAVZ | Latest scheduled start time (forecast) | SPAVZ | TIMS | 6 | ATIME | ||||
SPEDD | Latest scheduled finish date (forecast) | SPEDD | DATS | 8 | DATUM | ||||
SPEDZ | Latest scheduled finish time (forecast) | SPEDZ | TIMS | 6 | ATIME | ||||
PUFGP | Total float (from forecast) | PPUFF_GESM | DEC | 3 | PUFFER | ||||
PUFFP | Free float (from forecast) | PPUFF_FREI | DEC | 3 | PUFFER | ||||
NO_DISP | Ind: Reserv. not applicable to MRP;Purc. req. not created | NODISP | CHAR | 1 | XFELD | ||||
SEQTYPE | Sequence category | FOLGENART | CHAR | 1 | Assigned to domain | FLGAT | |||
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 | ||
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 | |||
FLG_PURS | Indicator: Purchase order exists | FLG_PURS | CHAR | 1 | KREUZ | ||||
INDEXSUMNR | Field defined as in SY-TABIX | TABIX_D | INT4 | 10 | TABIX | ||||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | KTR | |
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | Assigned to domain | EBELP | |||
FLG_VAB | Indicator: Sub-network exists | FLG_VAB | CHAR | 1 | X | ||||
XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | XFELD | ||||
AMGLG | Scrap quantity | AUMNG | QUAN | 13(3) | MENGV13 | ||||
KNTTP_SNET | Account Assignment Category | KNTTP | CHAR | 1 | Assigned to domain | KNTTP | KNT | ||
KZKFG | Configurable Material | KZKFG | CHAR | 1 | XFELD | ||||
TXCHG | Indicator: long text changed | TXCHG | CHAR | 1 | XFELD | ||||
AMGKO | Scrap quantity | AUMNG | QUAN | 13(3) | MENGV13 | ||||
SPLQ | Split Quantity in Order Split | SPLIT_QTY | QUAN | 13(3) | MENG13 | ||||
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 | ||||
DKCHG | Ind. : Document assignment to material component changed | DKCHG | CHAR | 1 | XFELD | ||||
PSTXCHG | Ind.: Changed PS text | PSTXCHG | CHAR | 1 | XFELD | ||||
IDENT | External identification of an item | CS_ITMID | CHAR | 8 | CHAR8 | ||||
SERVCHG | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
SANKA_CHG | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
ASSEMBLY | Material number of higher-level assembly | BAUGR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
MAINBOM | Assembly | BAGRP | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
MAINTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
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 | ||||
EPANF | Dispatched start date for operation | EPANF | DATS | 8 | DATUM | ||||
EPANZ | Dispatched start time for operation | EPANZ | TIMS | 6 | ATIME | ||||
EPEND | Dispatched finish date | EPEND | DATS | 8 | DATUM | ||||
EPENZ | Dispatched finish time | EPENZ | TIMS | 6 | ATIME | ||||
PROJN | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
ARBII | Actual operating resources object identification | CR_OBJID_I | NUMC | 8 | Assigned to domain | CR_OBJID | |||
WERKI | Actual plant | WERKS_I | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
RMNGA | Total confirmed rework quantity | RMNGA | QUAN | 13(3) | MENGV13 | ||||
ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PDAU | Forecasted duration of activity from confirmation | PDAU | QUAN | 5(1) | DAUER_4_1 | ||||
PDAE | Unit of the forecasted duration from the confirmation | PDAE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VSNMR | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
ORGAUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
ORGAPLZL | General counter for order | CO_APLZL | NUMC | 8 | Assigned to domain | CO_APLZL | |||
INACT | Version inactive indicator | VSINACT | CHAR | 1 | XFELD | ||||
AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
BEDNR | Requirement Tracking Number | BEDNR | CHAR | 10 | CHAR10 | ||||
OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1 | OCM_OBJ_TYPE |
Key field | Non-key field |
How do I retrieve data from SAP structure AFVG_CLEAR using ABAP code?
As AFVG_CLEAR 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_CLEAR as there is no data to select.How to access SAP table AFVG_CLEAR
Within an ECC or HANA version of SAP you can also view further information about AFVG_CLEAR 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