SAP ABAP Table LFA1 (Vendor Master (General Section))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBAS (Package) Financial accounting 'Basis'
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBAS (Package) Financial accounting 'Basis'
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | LFA1 | Table Relationship Diagram |
Short Description | Vendor Master (General Section) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | ||
3 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
4 | BAHNS | BAHNS | BAHNH | CHAR | 25 | 0 | Train station | ||
5 | BBBNR | BBBNR | NUM07 | NUMC | 7 | 0 | International location number (part 1) | ||
6 | BBSNR | BBSNR | NUM05 | NUMC | 5 | 0 | International location number (Part 2) | ||
7 | BEGRU | BRGRU | BRGRU | CHAR | 4 | 0 | Authorization Group | * | |
8 | BRSCH | BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | * | |
9 | BUBKZ | BUBKZ | NUM01 | NUMC | 1 | 0 | Check digit for the international location number | ||
10 | DATLT | DATLT | TEXT14 | CHAR | 14 | 0 | Data communication line no. | ||
11 | DTAMS | DTAMS | DTAMS | CHAR | 1 | 0 | Report key for data medium exchange | ||
12 | DTAWS | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | * | |
13 | ERDAT | ERDAT_RF | DATUM | DATS | 8 | 0 | Date on which the Record Was Created | ||
14 | ERNAM | ERNAM_RF | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
15 | ESRNR | ESRNR | ESRNR | CHAR | 11 | 0 | POR subscriber number | ||
16 | KONZS | KONZS | KONZS | CHAR | 10 | 0 | Group key | ||
17 | KTOKK | KTOKK | KTOKK | CHAR | 4 | 0 | Vendor account group | * | |
18 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
19 | LAND1 | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
20 | LNRZA | LNRZA | LIFNR | CHAR | 10 | 0 | Account Number of the Alternative Payee | LFA1 | |
21 | LOEVM | LOEVM_X | XFELD | CHAR | 1 | 0 | Central Deletion Flag for Master Record | ||
22 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
23 | NAME2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
24 | NAME3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
25 | NAME4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
26 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
27 | ORT02 | ORT02_GP | TEXT35 | CHAR | 35 | 0 | District | ||
28 | PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
29 | PSTL2 | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
30 | PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
31 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
32 | SORTL | SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
33 | SPERR | SPERB_X | XFELD | CHAR | 1 | 0 | Central posting block | ||
34 | SPERM | SPERM_X | XFELD | CHAR | 1 | 0 | Centrally imposed purchasing block | ||
35 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
36 | STCD1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
37 | STCD2 | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
38 | STKZA | STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
39 | STKZU | STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
40 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
41 | TELBX | TELBX | TEXT15 | CHAR | 15 | 0 | Telebox number | ||
42 | TELF1 | TELF1 | TEXT16 | CHAR | 16 | 0 | First telephone number | ||
43 | TELF2 | TELF2 | TEXT16 | CHAR | 16 | 0 | Second telephone number | ||
44 | TELFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
45 | TELTX | TELTX | TEXT30 | CHAR | 30 | 0 | Teletex number | ||
46 | TELX1 | TELX1 | TEXT30 | CHAR | 30 | 0 | Telex number | ||
47 | XCPDK | XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
48 | XZEMP | XZEMP | XFELD | CHAR | 1 | 0 | Indicator: Alternative payee in document allowed ? | ||
49 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
50 | FISKN | FISKN_K | LIFNR | CHAR | 10 | 0 | Account number of the master record with fiscal address | LFA1 | |
51 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
52 | STKZN | STKZN | STKZN | CHAR | 1 | 0 | Natural Person | ||
53 | SPERQ | QSPERRFKT | QSPERRFKT | CHAR | 2 | 0 | Function That Will Be Blocked | * | |
54 | ADRNR | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
55 | MCOD1 | MCDK1 | CHAR25 | CHAR | 25 | 0 | Search term for matchcode search | ||
56 | MCOD2 | MCDK2 | CHAR25 | CHAR | 25 | 0 | Search term for matchcode search | ||
57 | MCOD3 | MCDK3 | CHAR25 | CHAR | 25 | 0 | Search term for matchcode search | ||
58 | GBORT | GBORT_Q | TEXT25 | CHAR | 25 | 0 | Place of birth of the person subject to withholding tax | ||
59 | GBDAT | GBDAT_Q | DATUM | DATS | 8 | 0 | Date of birth of the person subject to withholding tax | ||
60 | SEXKZ | SEXKZ | SEXKZ | CHAR | 1 | 0 | Key for the Sex of the Person Subject to Withholding Tax | ||
61 | KRAUS | KRAUS_CM | CHAR11 | CHAR | 11 | 0 | Credit information number | ||
62 | REVDB | REVDB_CM | DATUM | DATS | 8 | 0 | Last review (external) | ||
63 | QSSYS | QSSYS_IST | QSSYSFAM | CHAR | 4 | 0 | Vendor's QM system | * | |
64 | KTOCK | KTOCK | KTOKK | CHAR | 4 | 0 | Reference Account Group for One-Time Account (Vendor) | * | |
65 | PFORT | PFORT_GP | TEXT35 | CHAR | 35 | 0 | PO Box city | ||
66 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
67 | LTSNA | LTSNA | XFELD | CHAR | 1 | 0 | Indicator: vendor sub-range relevant | ||
68 | WERKR | WERKR | XFELD | CHAR | 1 | 0 | Indicator: plant level relevant | ||
69 | PLKAL | FABKL | WFCID | CHAR | 2 | 0 | Factory calendar key | TFACD | |
70 | DUEFL | DUEFL_BKPF | DUEFL_BKPF | CHAR | 1 | 0 | Status of Data Transfer into Subsequent Release | ||
71 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
72 | SPERZ | SPERZ | XFELD | CHAR | 1 | 0 | Payment Block | ||
73 | SCACD | SCACD | SCACD | CHAR | 4 | 0 | Standard carrier access code | ||
74 | SFRGR | SFRGR | SFRGR | CHAR | 4 | 0 | Forwarding Agent Freight Group | * | |
75 | LZONE | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | TZONE | |
76 | XLFZA | XLFZA | XFELD | CHAR | 1 | 0 | Indicator: Alternative payee using account number | ||
77 | DLGRP | DLGRP | DLGRP | CHAR | 4 | 0 | Service agent procedure group | * | |
78 | FITYP | J_1AFITP_D | J_1AFITP | CHAR | 2 | 0 | Tax type | * | |
79 | STCDT | J_1ATOID | J_1ATOID | CHAR | 2 | 0 | Tax Number Type | * | |
80 | REGSS | J_1AREGSS | XFELD | CHAR | 1 | 0 | Registered for Social Insurance | ||
81 | ACTSS | J_1AACTSS | J_1AACTSS | CHAR | 3 | 0 | Activity Code for Social Insurance | * | |
82 | STCD3 | STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
83 | STCD4 | STCD4 | CHAR18 | CHAR | 18 | 0 | Tax Number 4 | ||
84 | IPISP | J_1BINDEQU | XFELD | CHAR | 1 | 0 | Tax Split | ||
85 | TAXBS | TAXBS | TAXBS | NUMC | 1 | 0 | Tax Base in Percentage | ||
86 | PROFS | PROFS | TEXT30 | CHAR | 30 | 0 | Profession | ||
87 | STGDL | STGDL | STGDL | CHAR | 2 | 0 | Shipment: statistics group, transportation service agent | * | |
88 | EMNFR | EMNFR | CHAR10 | CHAR | 10 | 0 | External manufacturer code name or number | ||
89 | LFURL | URL | TEXT132 | CHAR | 132 | 0 | Uniform resource locator | ||
90 | J_1KFREPRE | REPRES | REPRES | CHAR | 10 | 0 | Name of Representative | ||
91 | J_1KFTBUS | GESTYP | GESTYP | CHAR | 30 | 0 | Type of Business | * | |
92 | J_1KFTIND | INDTYP | INDTYP | CHAR | 30 | 0 | Type of Industry | * | |
93 | CONFS | CONFS_X | CHAR1 | CHAR | 1 | 0 | Status of Change Authorization (Central) | ||
94 | UPDAT | UPDAT_RF | DATUM | DATS | 8 | 0 | Date on Which the Changes Were Confirmed | ||
95 | UPTIM | UPTIM_RF | AS4TIME | TIMS | 6 | 0 | Time of Last Change Confirmation | ||
96 | NODEL | NODEL_X | XFELD | CHAR | 1 | 0 | Central deletion block for master record |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | LFA1 | FISKN | LFA1 | LIFNR | REF | C | CN |
2 | LFA1 | LAND1 | T005 | LAND1 | REF | C | CN |
3 | LFA1 | LNRZA | LFA1 | LIFNR | REF | C | CN |
4 | LFA1 | LZONE | TZONE | ZONE1 | REF | C | CN |
5 | LFA1 | MANDT | T000 | MANDT | KEY | 1 | CN |
6 | LFA1 | PLKAL | TFACD | IDENT | REF | C | CN |
7 | LFA1 | REGIO | T005S | BLAND | REF | C | CN |
8 | LFA1 | SPRAS | T002 | SPRAS | REF | 1 | CN |
9 | LFA1 | WERKS | T001W | WERKS | REF | C | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |