CUSTMAT_TXT

Transparent Table Application Table
17 Fields 1 CDS Views

Customer Material: Draft Long Text Node

CUSTMAT_TXT is an SAP database table in S/4HANA. Customer Material: Draft Long Text Node. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CustomerMaterialLongText view left_outer BASIC

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draftuuid /BOBF/CONF_KEY NodeID
parentdraftuuid /BOBF/CONF_KEY NodeID
hasactiveentity BOOLE_D TRUE
material MATNR Material
salesorganization VKORG Sales Org.
distributionchannel VTWEG Distr. Channel
customer KUNNR Customer
longtextid LONGTEXTID Text ID
language SPRAS Language
materialforedit MATNR Material
salesorganizationforedit VKORG Sales Org.
distributionchannelforedit VTWEG Distr. Channel
customerforedit KUNNR Customer
longtextidforedit LONGTEXTID Text ID
languageforedit SPRAS Language
longtext SYSTRING String

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 Material: Draft Long Text Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUSTMAT_TXT (
    CLIENT,                      -- Client [MANDT]
    DRAFTUUID,                   -- NodeID [/BOBF/CONF_KEY]
    PARENTDRAFTUUID,             -- NodeID [/BOBF/CONF_KEY]
    HASACTIVEENTITY,             -- TRUE [BOOLE_D]
    MATERIAL,                    -- Material [MATNR]
    SALESORGANIZATION,           -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNEL,         -- Distr. Channel [VTWEG]
    CUSTOMER,                    -- Customer [KUNNR]
    LONGTEXTID,                  -- Text ID [LONGTEXTID]
    LANGUAGE,                    -- Language [SPRAS]
    MATERIALFOREDIT,             -- Material [MATNR]
    SALESORGANIZATIONFOREDIT,    -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNELFOREDIT,  -- Distr. Channel [VTWEG]
    CUSTOMERFOREDIT,             -- Customer [KUNNR]
    LONGTEXTIDFOREDIT,           -- Text ID [LONGTEXTID]
    LANGUAGEFOREDIT,             -- Language [SPRAS]
    LONGTEXT,                    -- String [SYSTRING]
    PRIMARY KEY (CLIENT, DRAFTUUID)
);

Learn More