AFVGDT SAP (Downtime-Related Information on Operations in Orders) Structure details

Dictionary Type: Structure
Description: Downtime-Related Information on Operations in Orders




ABAP Code to SELECT data from AFVGDT
Related tables to AFVGDT
Access table AFVGDT




Structure field list including key, data, relationships and ABAP select examples

AFVGDT 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 "Downtime-Related Information on Operations in Orders" 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_AFVGDT TYPE AFVGDT.

The AFVGDT table consists of various fields, each holding specific information or linking keys about Downtime-Related Information on Operations in Orders data available in SAP. These include AUFPL (Routing number of operations in the order), APLZL (General counter for order), VSNMR (Number or description of a version), VORNR (Operation/Activity Number).. 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 AFVGDT 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZLGeneral counter for order CO_APLZLNUMC8AFVCCO_APLZL
VSNMRNumber or description of a version VSNMRCHAR12VSNMRVS2
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
ARBIDObject ID of the resource CR_OBJIDNUMC8Assigned to domainCR_OBJID
ARBPLWork center ARBPLCHAR8ARBPLAGR
KAPIDCapacity ID KAPIDNUMC8Assigned to domainKAPID
KAPARCapacity category KAPARTCHAR3Assigned to domainKAPARTCAA
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
VGWTSStandard value key VORGSCHLCHAR4TC21VORGSCHL
QLKAPARCapacity category QL_KAPARTCHAR3Assigned to domainKAPARTCAA
BEDIDID of the capacity requirements record BEDIDNUMC12Assigned to domainBEDID
KALIDFactory Calendar WFCIDCHAR2TFACDWFCIDFCI
PHFLGIndicator: Phase PHFLGCHAR1XFELD
BEDNRRequirement Tracking Number BEDNRCHAR10CHAR10
ISAVDActual operation start (date) ISAVDDATS8DATUM
IEAVDActual finish of operation (date) IEAVDDATS8DATUM
ISDDActual start: Execution (date) ISDDDATS8DATUM
ISDZActual start: Execution/setup (time) ISDZTIMS6ATIME
IERDActual finish: Setup (date) IERDDATS8DATUM
IERZActual finish: Setup (time) IERZTIMS6ATIME
ISBDActual start: Processing (date) ISBDDATS8DATUM
ISBZActual start: Processing (time) ISBZTIMS6ATIME
IEBDActual finish: Processing (date) IEBDDATS8DATUM
IEBZActual processing finish (time) IEBZTIMS6ATIME
ISADActual start: Teardown (date) ISADDATS8DATUM
ISAZActual start: Teardown (time) ISAZTIMS6ATIME
IEDDActual finish: Execution (date) IEDDDATS8DATUMEDR
IEDZActual finish: Execution (time) IEDZTIMS6ATIMEEZR
AUFNRDOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
AUARTOrder Type AUFARTCHAR4Assigned to domainAUFARTAAT
AUTYPOrder category AUFTYPNUMC2AUFTYP
LAR01Activity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
LAR02Activity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
LAR03Activity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
LAR04Activity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
LAR05Activity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
LAR06Activity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
ISM01Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM02Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM03Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM04Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM05Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
ISM06Previously confirmed activity CO_RUMNGQUAN13(3) MENGV13
WARTZQueue time used for scheduling WARTEZEITFLTP16(16) CX_ZEIT
WRTZEUnit of measure for queue time WTRZEUNIT3CUNITEINHEIT
RUESTSetup time RUESTFLTP16(16) CX_ZEIT
RSTZEUnit of measure for setup time RSTZEUNIT3CUNITEINHEIT
BEARZProcessing time BEARZEITFLTP16(16) CX_ZEIT
BEAZEUnit of measure for processing time BEAZEUNIT3CUNITEINHEIT
ABRUETeardown ABRUEFLTP16(16) CX_ZEIT
ARUZEUnit of measure for teardown ARUZEUNIT3CUNITEINHEIT
LIEGZWait time used for scheduling LIEGEZEITFLTP16(16) CX_ZEIT
LIGZEUnit of measure for wait time LIGZEUNIT3CUNITEINHEIT
TRANZMove time used for scheduling TRANSZEITFLTP16(16) CX_ZEIT
TRAZEUnit of measure for move time TRAZEUNIT3CUNITEINHEIT
SLWIDKey word ID for user-defined fields SLWIDCHAR7Assigned to domainSLWID
USR00User field with 20 characters USRCHAR20CHAR20USRCHAR20
USR01User field with 20 characters USRCHAR20CHAR20USRCHAR20
USR02User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR03User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR04User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE04User field: Unit for quantity fields USRUNITUNIT3Assigned to domainCUNITMEINS
USR05User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE05User field: Unit for quantity fields USRUNITUNIT3Assigned to domainCUNITMEINS
USR06User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE06User field: Unit for value fields USRCUKYCUKY5Assigned to domainWAERS
USR07User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE07User field: Unit for value fields USRCUKYCUKY5Assigned to domainWAERS
USR08User field for date USRDATEDATS8USRDATE
USR09User field for date USRDATEDATS8USRDATE
USR10User-defined field: Indicator for reports USRFLAGCHAR1FLAG
USR11User-defined field: Indicator for reports USRFLAGCHAR1FLAG
ILE01Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE02Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE03Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE04Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE05Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
ILE06Unit of measure for the activity to be confirmed CO_ISMNGEHUNIT3Assigned to domainCUNITMEINS
FSAVDEarliest scheduled start: Execution (date) FSAVDDATS8DATUM
FSAVZEarliest scheduled start: Execution (time) FSAVZTIMS6ATIME
FSEDDEarliest scheduled finish: Execution (date) FSEDDDATS8DATUM
FSEDZEarliest scheduled finish: Execution (time) FSEDZTIMS6ATIME

Key field Non-key field



How do I retrieve data from SAP structure AFVGDT using ABAP code?

As AFVGDT 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 AFVGDT as there is no data to select.

How to access SAP table AFVGDT

Within an ECC or HANA version of SAP you can also view further information about AFVGDT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!