PRD_TEXT

Transparent Table Application Table
11 Fields 5 CDS Views

Product: Draft Longtext Node (basic, int. comm., inspection)

PRD_TEXT is an SAP database table in S/4HANA. Product: Draft Longtext Node (basic, int. comm., inspection). It contains 11 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_Productplanttext view left_outer BASIC Plant Text Core enttity
I_Productsalestext view left_outer BASIC Product text core entity
I_Producttexts view left_outer BASIC Product text active entity
P_Productsalestextd view from BASIC
P_Producttextsd view from BASIC

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draftuuid /BOBF/CONF_KEY NodeID
parentdraftuuid /BOBF/CONF_KEY NodeID
hasactiveentity BOOLE_D TRUE
product PRODUCTNUMBER Product
longtextid LONGTEXTID Text ID
language SPRAS Language
longtext SYSTRING String
productforedit PRODUCTNUMBER Product
longtextidforedit LONGTEXTID Text ID
languageforedit SPRAS Language

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: Draft Longtext Node (basic, int. comm., inspection)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_TEXT (
    CLIENT,             -- Client [MANDT]
    DRAFTUUID,          -- NodeID [/BOBF/CONF_KEY]
    PARENTDRAFTUUID,    -- NodeID [/BOBF/CONF_KEY]
    HASACTIVEENTITY,    -- TRUE [BOOLE_D]
    PRODUCT,            -- Product [PRODUCTNUMBER]
    LONGTEXTID,         -- Text ID [LONGTEXTID]
    LANGUAGE,           -- Language [SPRAS]
    LONGTEXT,           -- String [SYSTRING]
    PRODUCTFOREDIT,     -- Product [PRODUCTNUMBER]
    LONGTEXTIDFOREDIT,  -- Text ID [LONGTEXTID]
    LANGUAGEFOREDIT,    -- Language [SPRAS]
    PRIMARY KEY (CLIENT, DRAFTUUID)
);

Learn More