SAP CSAPI_AFVGD CRM-Relevant Part of Structure AFVGD Table data and field list

CSAPI_AFVGD 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 "CRM-Relevant Part of Structure AFVGD" 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_CSAPI_AFVGD TYPE CSAPI_AFVGD.

The CSAPI_AFVGD table consists of various fields, each holding specific information or linking keys about CRM-Relevant Part of Structure AFVGD data available in SAP. These include ARBID (Object ID of the resource), STEUS (Control key), LTXA1 (Operation short text), ARBEI (Work involved in the activity)... 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. .

CSAPI_AFVGD structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CSAPI_AFVGD structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CSAPI_AFVGD table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
ARBIDObject ID of the resource CR_OBJIDNUMC8Assigned to domainCR_OBJID
STEUSControl key STEUSCHAR4Assigned to domainSTEUS
LTXA1Operation short text LTXA1CHAR40TEXT40
ARBEIWork involved in the activity ARBEITQUAN7(1) ARBEIT
ARBEHUnit for work ARBEITEUNIT3Assigned to domainCUNITMEINS
LARNTActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
DAUNONormal duration of the activity DAUNORQUAN5(1) DAUER_4_1
DAUNENormal duration/unit DAUNOREUNIT3Assigned to domainCUNITMEINS
ANZZLNumber of capacities required ANZKAPINT13INT1
INDETKey for calculation INDETCHAR1INDET
EINSAConstraint on the basic start date for the activity EINSCHRACHAR1RESTRIKSTR
EINSEConstraint on the finish date of the activity EINSCHRECHAR1RESTRIKEND
NTANFConstraint for activity start (Basic) VORGABESTDDATS8VORGABESTR
NTANZConstraint for activity start time (Basic) VORGABESTZTIMS6ATIME
NTENDConstraint for finish of activity (Basic) VORGABEENDDATS8VORGABEEND
NTENZBasic finish time of the activity VORGABEENZTIMS6ATIME
PERNRPersonnel number CO_PERNRNUMC8PERNRPER

Key field Non-key field



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

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

How to access SAP table CSAPI_AFVGD

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

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