M_KREDK

11 Fields 1 CDS Views

Generated Table for View

M_KREDK is an SAP database table in S/4HANA. Generated Table for View. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CustomerSupplierGLAccount view union_all BASIC Customer VH, Supplier VH, G/L Account VH

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sortl SORTL Search term
KEY land1 LAND1_GP Country/Region Key
KEY pstlz PSTLZ Postal Code
KEY mcod3 MCDK3 City
KEY mcod1 MCDK1 Name
KEY lifnr LIFNR Supplier
KEY bukrs BUKRS Company Code
begru BRGRU Authorization
ktokk KTOKK Account group
loevm LOEVM_B Co.Cde Deletion Flag

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE M_KREDK (
    MANDT,  -- Client [MANDT]
    SORTL,  -- Search term [SORTL]
    LAND1,  -- Country/Region Key [LAND1_GP]
    PSTLZ,  -- Postal Code [PSTLZ]
    MCOD3,  -- City [MCDK3]
    MCOD1,  -- Name [MCDK1]
    LIFNR,  -- Supplier [LIFNR]
    BUKRS,  -- Company Code [BUKRS]
    BEGRU,  -- Authorization [BRGRU]
    KTOKK,  -- Account group [KTOKK]
    LOEVM,  -- Co.Cde Deletion Flag [LOEVM_B]
    PRIMARY KEY (MANDT, SORTL, LAND1, PSTLZ, MCOD3, MCOD1, LIFNR, BUKRS)
);

Learn More