KNB5

Transparent Table Application Table
11 Fields 3 CDS Views

Customer master (dunning data)

KNB5 is an SAP database table in S/4HANA. Customer master (dunning data). It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FNDEI_KNB5_BLOCKINGINFO view from Filter View for table KNB5
FNDEI_KNB5_FILTER view from Filter View for table KNB5
I_CustomerDunning view from BASIC Customer Company Code Dunning Fields

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
KEY bukrs BUKRS Company Code
KEY maber MABER Dunning Area
mahna MAHNA Dunn.Procedure
mansp MANSP Dunn. Block
madat MADAT Last Dunned
mahns MAHNS_D Dunning Level
knrma KNRMA Dunn.Recipient
gmvdt GMVDT Leg.Dunn.Proc.
busab BUSAB_MA Dunning Clerk

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Customer master (dunning data)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNB5 (
    MANDT,  -- Client [MANDT]
    KUNNR,  -- Customer [KUNNR]
    BUKRS,  -- Company Code [BUKRS]
    MABER,  -- Dunning Area [MABER]
    MAHNA,  -- Dunn.Procedure [MAHNA]
    MANSP,  -- Dunn. Block [MANSP]
    MADAT,  -- Last Dunned [MADAT]
    MAHNS,  -- Dunning Level [MAHNS_D]
    KNRMA,  -- Dunn.Recipient [KNRMA]
    GMVDT,  -- Leg.Dunn.Proc. [GMVDT]
    BUSAB,  -- Dunning Clerk [BUSAB_MA]
    PRIMARY KEY (MANDT, KUNNR, BUKRS, MABER)
);

Learn More