SE11 ABAP Dictionary SE11 KNB5

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

KNB5

Customer master (dunning data)
SAP SAP Transparent Table 11 Fields
Primary Key:
MANDT KUNNR 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
KUNNR
KEY Customer CHAR 10 - KNA1 Customer Number 1
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
KNRMA
- 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 KNB5.

Interactive ERD Diagrams
SAP SD - Links to FI Tables →
Standard T-Codes
SE11 SE16
Related Tables
KNA1 T001 KNVP KNVV KNVD KNB1
ANSI SQL Query 
SELECT a.KUNNR,
       a.BUKRS,
       a.MABER,
       a.MAHNA,
       a.MANSP,
       a.MADAT,
       a.MAHNS
FROM KNB5 AS a
WHERE a.KUNNR = '0000100025'
  AND a.BUKRS = '1000';
ABAP OpenSQL (7.40+) 
SELECT a~kunnr,
       a~bukrs,
       a~maber,
       a~mahna,
       a~mansp,
       a~madat,
       a~mahns
  FROM knb5 AS a
  WHERE a~kunnr = '0000100025'
  and a~bukrs = '1000'
  INTO TABLE @DATA(lt_knb5)
  UP TO 100 ROWS.