E3LFA1M SAP (Segment for general vendor data) Structure details
Description: Segment for general vendor data
Structure field list including key, data, relationships and ABAP select examples
E3LFA1M 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 "Segment for general vendor data" 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_E3LFA1M TYPE E3LFA1M.
The E3LFA1M table consists of various fields, each holding specific information or linking keys about Segment for general vendor data data available in SAP. These include LIFNR (Account Number of Vendor or Creditor), ANRED (Title), BAHNS (Train station), BBBNR (International location number (part 1)).. 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: Not classified
SAP E3LFA1M 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 |
MSGFN | Function | MSGFN | CHAR | 3 | MSGFN | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
BAHNS | Train station | BAHNS | CHAR | 25 | BAHNH | ||||
BBBNR | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
BBSNR | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
BEGRU | Authorization Group | BRGRU | CHAR | 4 | Assigned to domain | BRGRU | |||
BRSCH | Industry key | BRSCH | CHAR | 4 | Assigned to domain | BRSCH | |||
BUBKZ | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | USNAM | ||||
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
KTOKK | Vendor account group | KTOKK | CHAR | 4 | Assigned to domain | KTOKK | KGK | ||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
LAND1 | Country of company | LAND | CHAR | 3 | Assigned to domain | LAND1 | |||
LNRZA | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | XFELD | ||||
NAME1 | Employee's last name | NAME | CHAR | 35 | NAME | ||||
NAME2 | Employee's last name | NAME | CHAR | 35 | NAME | ||||
NAME3 | Employee's last name | NAME | CHAR | 35 | NAME | ||||
NAME4 | Employee's last name | NAME | CHAR | 35 | NAME | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
SORTL | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | XFELD | ||||
SPERM | Centrally imposed purchasing block | SPERM_X | CHAR | 1 | XFELD | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
XZEMP | Indicator: Alternative payee in document allowed ? | XZEMP | CHAR | 1 | XFELD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
FISKN | Account number of the master record with fiscal address | FISKN_K | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
SPERQ | Function That Will Be Blocked | QSPERRFKT | CHAR | 2 | Assigned to domain | QSPERRFKT | |||
ADRNR | Address | ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
MCOD1 | Search term for matchcode search | MCDK1 | CHAR | 25 | CHAR25 | ||||
MCOD2 | Search term for matchcode search | MCDK2 | CHAR | 25 | CHAR25 | ||||
MCOD3 | Search term for matchcode search | MCDK3 | CHAR | 25 | CHAR25 | ||||
GBORT | Place of birth of the person subject to withholding tax | GBORT_Q | CHAR | 25 | TEXT25 | ||||
GBDAT | Date of Birth | GBDAT | DATS | 8 | PDATE | GBDAT | |||
SEXKZ | Key for the Sex of the Person Subject to Withholding Tax | SEXKZ | CHAR | 1 | SEXKZ | ||||
KRAUS | Credit information number | KRAUS_CM | CHAR | 11 | CHAR11 | ||||
REVDB | Last review (external) | REVDB_CM | DATS | 8 | DATUM | ||||
QSSYS | Vendor's QM system | QSSYS_IST | CHAR | 4 | Assigned to domain | QSSYSFAM | |||
KTOCK | Reference Account Group for One-Time Account (Vendor) | KTOCK | CHAR | 4 | Assigned to domain | KTOKK | |||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LTSNA | Indicator: vendor sub-range relevant | LTSNA | CHAR | 1 | XFELD | ||||
WERKR | Indicator: plant level relevant | WERKR | CHAR | 1 | XFELD | ||||
PLKAL | Factory calendar key | FABKL | CHAR | 2 | Assigned to domain | WFCID | |||
DUEFL | Status of Data Transfer into Subsequent Release | DUEFL_BKPF | CHAR | 1 | DUEFL_BKPF | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ |
Key field | Non-key field |
How do I retrieve data from SAP structure E3LFA1M using ABAP code?
As E3LFA1M 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 E3LFA1M as there is no data to select.How to access SAP table E3LFA1M
Within an ECC or HANA version of SAP you can also view further information about E3LFA1M 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