SAP FVD_ADDRESS Proxy Struktur (generiert) Table data and field list

FVD_ADDRESS 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 "Proxy Struktur (generiert)" 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_FVD_ADDRESS TYPE FVD_ADDRESS.

The FVD_ADDRESS table consists of various fields, each holding specific information or linking keys about Proxy Struktur (generiert) data available in SAP. These include ORGANISATION_FORM_OF_ADDRESS (), CONTROLLER (), CODE (), CONTROLLER ()... 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. .

FVD_ADDRESS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP FVD_ADDRESS 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 FVD_ADDRESS 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
CONTROLLER 0
ORGANISATION_FORM_OF_ADDRESS 0
CONTROLLER 0
CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENTProxy Data Element (generated) FVD_FORM_OF_ADDRESS_CODE_CONTCHAR4
NAME 0
CONTROLLER 0
LANGUAGE_CODEProxy Datenelement (generiert) FVD_LANGUAGE_CODECHAR9
CONTENTProxy Data Element (generated) FVD_MEDIUM_NAME_CONTENTCHAR40
ORGANISATION_FORMATTED_NAME 0
PERSON_NAME 0
CONTROLLER 0
FORM_OF_ADDRESS_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENTProxy Data Element (generated) FVD_FORM_OF_ADDRESS_CODE_CONTCHAR4
FORM_OF_ADDRESS_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
GIVEN_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
MIDDLE_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
FAMILY_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
ADDITIONAL_FAMILY_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
BIRTH_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
NICK_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
INITIALS_NAMEProxy Data Element (generated) FVD_LANGUAGEINDEPENDENT_SHORT3CHAR10
ACADEMIC_TITLE_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENTProxy Data Element (generated) FVD_ACADEMIC_TITLE_CODE_CONTENCHAR4
ACADEMIC_TITLE_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
ADDITIONAL_ACADEMIC_TITLE_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENTProxy Data Element (generated) FVD_ACADEMIC_TITLE_CODE_CONTENCHAR4
ADDITIONAL_ACADEMIC_TITLE_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
NAME_PREFIX_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENTProxy Data Element (generated) FVD_FAMILY_NAME_PREFIX_CODE_C5CHAR4
NAME_PREFIX_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
ADDITIONAL_NAME_PREFIX_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENTProxy Data Element (generated) FVD_FAMILY_NAME_PREFIX_CODE_C5CHAR4
ADDITIONAL_NAME_PREFIX_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
NAME_SUPPLEMENT_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENTProxy Data Element (generated) FVD_PERSON_NAME_SUPPLEMENT_CODCHAR4
NAME_SUPPLEMENT_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
DEVIATING_FULL_NAMEProxy Data Element (generated) FVD_LANGUAGEINDEPENDENT_LONG_3CHAR80
NAME_FORMAT_COUNTRY_CODEProxy Datenelement (generiert) FVD_COUNTRY_CODECHAR3
NAME_FORMAT_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENTProxy Data Element (generated) FVD_PERSON_NAME_FORMAT_CODE_COCHAR2
FUNCTIONAL_TITLE_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
DEPARTMENT_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
OFFICE 0
CONTROLLER 0
BUILDING_IDProxy Data Element (generated) FVD_BUILDING_IDCHAR10
FLOOR_IDProxy Data Element (generated) FVD_FLOOR_ID3CHAR10
ROOM_IDProxy Data Element (generated) FVD_ROOM_IDCHAR10
INHOUSE_MAIL_IDProxy Data Element (generated) FVD_INHOUSE_MAIL_ID3CHAR10
CORRESPONDENCE_SHORT_NAMEProxy Data Element (generated) FVD_LANGUAGEINDEPENDENT_SHORT3CHAR10
PHYSICAL_ADDRESS 0
CONTROLLER 0
COUNTRY_CODEProxy Datenelement (generiert) FVD_COUNTRY_CODECHAR3
COUNTRY_NAME 0
CONTROLLER 0
LANGUAGE_CODEProxy Datenelement (generiert) FVD_LANGUAGE_CODECHAR9
CONTENTProxy Data Element (generated) FVD_MEDIUM_NAME_CONTENTCHAR40
REGION_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENT 0
REGION_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
STREET_POSTAL_CODEProxy Data Element (generated) FVD_POSTAL_CODECHAR10
POBOX_POSTAL_CODEProxy Data Element (generated) FVD_POSTAL_CODECHAR10
COMPANY_POSTAL_CODEProxy Data Element (generated) FVD_POSTAL_CODECHAR10
CITY_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
ADDITIONAL_CITY_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
DISTRICT_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
POBOX_IDProxy Data Element (generated) FVD_POBOX_IDCHAR10
POBOX_INDICATOR'Indicator' is the binary coded specification of a fact FVD_INDICATORCHAR5
POBOX_COUNTRY_CODEProxy Datenelement (generiert) FVD_COUNTRY_CODECHAR3
POBOX_COUNTRY_NAME 0
CONTROLLER 0
LANGUAGE_CODEProxy Datenelement (generiert) FVD_LANGUAGE_CODECHAR9
CONTENTProxy Data Element (generated) FVD_MEDIUM_NAME_CONTENTCHAR40
POBOX_REGION_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
CONTENT 0
POBOX_REGION_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
POBOX_CITY_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
STREET_NAMEProxy Data Element (generated) FVD_STREET_NAMECHAR60
STREET_PREFIX_NAME 0
STREET_SUFFIX_NAME 0
HOUSE_IDProxy Data Element (generated) FVD_HOUSE_ID3CHAR10
ADDITIONAL_HOUSE_IDProxy Data Element (generated) FVD_HOUSE_ID3CHAR10
BUILDING_IDProxy Data Element (generated) FVD_BUILDING_IDCHAR10
FLOOR_IDProxy Data Element (generated) FVD_FLOOR_ID3CHAR10
ROOM_IDProxy Data Element (generated) FVD_ROOM_IDCHAR10
CARE_OF_NAMEProxy Data Element (generated) FVD_PERSON_NAME_MIDDLE_NAM_TABCHAR40
DESCRIPTION 0
TAX_JURISDICTION_CODE 0
CONTROLLER 0
LIST_ID 0
LIST_VERSION_ID 0
LIST_AGENCY_ID 0
LIST_AGENCY_SCHEME_ID 0
LIST_AGENCY_SCHEME_AGENCY_IDAn AgencyIdentificationCode is a code representation of the FVD_AGENCY_IDENTIFICATION_CODECHAR3
VALUEProxy Data Element (generated) FVD_TAX_JURISDICTION_CODE_CON4CHAR15
TIME_ZONE_DIFFERENCE_VALUEProxy Datenelement (generiert) FVD_TIME_ZONE_DIFFERENCE_VALUEDEC4(2)
GEO_COORDINATES 0
CONTROLLER 0
LATITUDE_MEASURE 0
CONTROLLER 0
UNIT_CODEProxy Data Element (generated) MEASURE_UNIT_CODE11CHAR3
CONTENTMeasure is a physical indication of Measurements including t FVD_MEASURE_CONTENT3DEC31(14)
LONGITUDE_MEASURE 0
CONTROLLER 0
UNIT_CODEProxy Data Element (generated) MEASURE_UNIT_CODE11CHAR3
CONTENTMeasure is a physical indication of Measurements including t FVD_MEASURE_CONTENT3DEC31(14)
COMMUNICATION 0
CONTROLLER 0
CORRESPONDENCE_LANGUAGE_CODEProxy Datenelement (generiert) FVD_LANGUAGE_CODECHAR9
CORRESPONDENCE_LANGUAGE_NAME 0
CONTROLLER 0
LANGUAGE_CODEProxy Datenelement (generiert) FVD_LANGUAGE_CODECHAR9
CONTENTProxy Data Element (generated) FVD_MEDIUM_NAME_CONTENTCHAR40
TELEPHONE 0
MOBILE_PHONE 0
FACSIMILE 0
EMAIL 0
WEB 0

Key field Non-key field



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

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

How to access SAP table FVD_ADDRESS

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

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