CMD_PRDSALES_TXT

Transparent Table Application Table
16 Fields 1 CDS Views

Product Sales Delivery texts

CMD_PRDSALES_TXT is an SAP database table in S/4HANA. Product Sales Delivery texts. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProductSalesDeliveryText view_entity from BASIC Product Sales Delivery - Text

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY product matnr Material
KEY product_salesorg vkorg Sales Org.
KEY product_distributionchnl vtweg Distr. Channel
KEY text_id tdid Text ID
KEY language spras Language
text_object tdobject Text object
text_name tdobname Text Name
mimetype nte_mimetype MIME Type
text_content cmd_prd_text_content
created_at cmd_prd_created_at
created_by ernam Created By
changed_at cmd_prd_changed_at
changed_by aenam Changed By
sdm_ver cmd_prd_sdm_vers
compatibility cmd_prd_txt_compatibility

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.

-- Product Sales Delivery texts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMD_PRDSALES_TXT (
    CLIENT,                    -- Client [mandt]
    PRODUCT,                   -- Material [matnr]
    PRODUCT_SALESORG,          -- Sales Org. [vkorg]
    PRODUCT_DISTRIBUTIONCHNL,  -- Distr. Channel [vtweg]
    TEXT_ID,                   -- Text ID [tdid]
    LANGUAGE,                  -- Language [spras]
    TEXT_OBJECT,               -- Text object [tdobject]
    TEXT_NAME,                 -- Text Name [tdobname]
    MIMETYPE,                  -- MIME Type [nte_mimetype]
    TEXT_CONTENT,              -- cmd_prd_text_content
    CREATED_AT,                -- cmd_prd_created_at
    CREATED_BY,                -- Created By [ernam]
    CHANGED_AT,                -- cmd_prd_changed_at
    CHANGED_BY,                -- Changed By [aenam]
    SDM_VER,                   -- cmd_prd_sdm_vers
    COMPATIBILITY,             -- cmd_prd_txt_compatibility
    PRIMARY KEY (CLIENT, PRODUCT, PRODUCT_SALESORG, PRODUCT_DISTRIBUTIONCHNL, TEXT_ID, LANGUAGE)
);

Learn More