SAP Table LFB5
Vendor master (dunning data)
LFB5 (Vendor master (dunning data)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link LFB5 to other SAP tables.
LFB5 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 | 0 | ||
| BUKRS | Company Code | BUKRS | LFB1 | CHAR | 4 | 0 | ||
| MABER | Dunning Area | MABER | T047M | CHAR | 2 | 0 | ||
| MAHNA | Dunning Procedure | MAHNA | T047A | CHAR | 4 | 0 | ||
| MANSP | Dunning block | MANSP | T040S | CHAR | 1 | 0 | ||
| MADAT | Last dunned on | MADAT | DATS | 8 | 0 | |||
| MAHNS | Dunning level | MAHNS_D | NUMC | 1 | 0 | |||
| LFRMA | Account number of the dunning recipient | LFRMA | LFA1 | CHAR | 10 | 0 | ||
| GMVDT | Date of the legal dunning proceedings | GMVDT | DATS | 8 | 0 | |||
| BUSAB | Dunning clerk | BUSAB_MA | T001S | CHAR | 2 | 0 | ||
LFB5 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| LFB5 | BUKRS | LFB5 | MANDT | LFB1 | Vendor Master (Company Code) | MANDT |
| LFB5 | BUKRS | LFB5 | LIFNR | LFB1 | Vendor Master (Company Code) | LIFNR |
| LFB5 | BUKRS | LFB5 | BUKRS | LFB1 | Vendor Master (Company Code) | BUKRS |
| LFB5 | BUSAB | LFB5 | MANDT | T001S | Accounting Clerks | MANDT |
| LFB5 | BUSAB | LFB5 | BUKRS | T001S | Accounting Clerks | BUKRS |
| LFB5 | BUSAB | LFB5 | BUSAB | T001S | Accounting Clerks | BUSAB |
| LFB5 | LFRMA | LFB5 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| LFB5 | LFRMA | LFB5 | LFRMA | LFA1 | Vendor Master (General Section) | LIFNR |
| LFB5 | LIFNR | LFB5 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| LFB5 | LIFNR | LFB5 | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| LFB5 | MABER | LFB5 | MANDT | T047M | Dunning areas | MANDT |
| LFB5 | MABER | LFB5 | BUKRS | T047M | Dunning areas | BUKRS |
| LFB5 | MABER | LFB5 | MABER | T047M | Dunning areas | MABER |
| LFB5 | MAHNA | LFB5 | MAHNA | T047A | Account Level Dunning Control | MAHNA |
| LFB5 | MAHNA | LFB5 | MANDT | T047A | Account Level Dunning Control | MANDT |
| LFB5 | MANDT | LFB5 | MANDT | T000 | Clients | MANDT |
| LFB5 | MANSP | LFB5 | MANDT | T040S | Blocking reasons for dunning notices | MANDT |
| LFB5 | MANSP | LFB5 | MANSP | T040S | Blocking reasons for dunning notices | MANSP |
