M_DEBID

11 Fields 1 CDS Views

Generated Table for View

M_DEBID 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 from 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 MCDD3 City
KEY mcod1 MCDD1 Name
KEY kunnr KUNNR Customer
KEY bukrs BUKRS Company Code
begru BRGRU Authorization
ktokd KTOKD 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_DEBID (
    MANDT,  -- Client [MANDT]
    SORTL,  -- Search term [SORTL]
    LAND1,  -- Country/Region Key [LAND1_GP]
    PSTLZ,  -- Postal Code [PSTLZ]
    MCOD3,  -- City [MCDD3]
    MCOD1,  -- Name [MCDD1]
    KUNNR,  -- Customer [KUNNR]
    BUKRS,  -- Company Code [BUKRS]
    BEGRU,  -- Authorization [BRGRU]
    KTOKD,  -- Account group [KTOKD]
    LOEVM,  -- Co.Cde Deletion Flag [LOEVM_B]
    PRIMARY KEY (MANDT, SORTL, LAND1, PSTLZ, MCOD3, MCOD1, KUNNR, BUKRS)
);

Learn More