SE11 ABAP Dictionary SE11 LFB5

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

LFB5

Vendor master (dunning data)
SAP SAP Transparent Table 11 Fields
Primary Key:
MANDT LIFNR BUKRS MABER

Dictionary Fields Fields

(11 dari 11 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
LIFNR
KEY Vendor CHAR 10 - LFA1 Account Number of Vendor or Creditor
3
BUKRS
KEY CoCode CHAR 4 - T001 Company Code
4
MABER
KEY Dunn.area CHAR 2 - - Dunning Area
5
MAHNA
- Dunn.Proc. CHAR 4 - - Dunning Procedure
6
MANSP
- Dunn.block CHAR 1 - - Dunning block
7
MADAT
- Last dunn. DATS 8 - - Last dunned on
8
MAHNS
- Dunn.level NUMC 1 - - Dunning level
9
LFRMA
- Dun.recipt CHAR 10 - - Account number of the dunning recipient
10
GMVDT
- Leg.dun.pr DATS 8 - - Date of the legal dunning proceedings
11
BUSAB
- Clerk CHAR 2 - - Dunning clerk

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk LFB5.

Interactive ERD Diagrams
SAP FI/CO - Accounts Payable (Vendor Master Data) →
Standard T-Codes
SE11 SE16
Related Tables
LFA1 T001 LFBK LFM1 LFM2 LFB1
ANSI SQL Query 
SELECT a.LIFNR,
       a.BUKRS,
       a.MABER,
       a.MAHNA,
       a.MANSP,
       a.MADAT,
       a.MAHNS
FROM LFB5 AS a
WHERE a.LIFNR = '0000100001'
  AND a.BUKRS = '1000';
ABAP OpenSQL (7.40+) 
SELECT a~lifnr,
       a~bukrs,
       a~maber,
       a~mahna,
       a~mansp,
       a~madat,
       a~mahns
  FROM lfb5 AS a
  WHERE a~lifnr = '0000100001'
  and a~bukrs = '1000'
  INTO TABLE @DATA(lt_lfb5)
  UP TO 100 ROWS.