SAP CIFADTEL Location: Address-Telephone-Number Structure Table data and field list

CIFADTEL 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 "Location: Address-Telephone-Number Structure" 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_CIFADTEL TYPE CIFADTEL.

The CIFADTEL table consists of various fields, each holding specific information or linking keys about Location: Address-Telephone-Number Structure data available in SAP. These include LOCTYPE (APO Location Type), CONSNUMBER (Sequence Number), COUNTRY (Country for telephone/fax number), FLGDEFAULT (Standard Sender Address in this Communication Type)... 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. .

CIFADTEL structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP CIFADTEL 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 CIFADTEL 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
EXT_LOCNOLocation CIFLOCNOCHAR20CIFLOCNO
LOCTYPEAPO Location Type CIFLOCTYPECHAR4CIFLOCTYPE
CONSNUMBERSequence Number AD_CONSNUMNUMC3NUMC3
COUNTRYCountry for telephone/fax number AD_COMCTRYCHAR3Assigned to domainLAND1LND
FLGDEFAULTStandard Sender Address in this Communication Type AD_FLGDFNRCHAR1XFELD
HOME_FLAGFlag: This Communication Address Is the Home Address CF_FLGHOMECHAR1XFELD
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
TELNR_LONGComplete number: dialling code+number+extension AD_TELNRLGCHAR30CHAR30
TELNR_CALLTelephone number for determining caller AD_TELNRCLCHAR30CHAR30
DFT_RECEIVFlag: Recipient is standard recipient for this number AD_DFTRCNRCHAR1XFELD
R3_USERFlag: Connected to an SAP System AD_R3_USERCHAR1XFELD
REMARKCommunication link notes AD_REMARK2CHAR50TEXT50

Key field Non-key field



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

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

How to access SAP table CIFADTEL

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

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