PRD_UOM_TEXT

Transparent Table Application Table
16 Fields 1 CDS Views

Product :UOM text draft table

PRD_UOM_TEXT is an SAP database table in S/4HANA. Product :UOM text draft table. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_Productunitofmeasuretextd view from BASIC

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY draftkey /BOBF/CONF_KEY NodeID
parentdraftkey /BOBF/CONF_KEY NodeID
hasactiveentity BOOLE_D TRUE
rootdraftkey /BOBF/CONF_KEY NodeID
activeproduct PRODUCTNUMBER Product
activeproductunit ALTERNATIVEUNIT Alternative UoM
activelanguage LANGUAGEKEY Language Key
activeproductunitshorttextcode PRODUCTUNITSHORTTEXTCODE Short Text Code
activeproductunittextseqnum CONSECUTIVENUM Consecutive Number
product PRODUCTNUMBER Product
productunit ALTERNATIVEUNIT Alternative UoM
productunittextseqnum CONSECUTIVENUM Consecutive Number
productunitshorttextcode PRODUCTUNITSHORTTEXTCODE Short Text Code
language LANGUAGEKEY Language Key
productdescription PRODUCTDESCRIPTION Description

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 :UOM text draft table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PRD_UOM_TEXT (
    CLIENT,                          -- Client [MANDT]
    DRAFTKEY,                        -- NodeID [/BOBF/CONF_KEY]
    PARENTDRAFTKEY,                  -- NodeID [/BOBF/CONF_KEY]
    HASACTIVEENTITY,                 -- TRUE [BOOLE_D]
    ROOTDRAFTKEY,                    -- NodeID [/BOBF/CONF_KEY]
    ACTIVEPRODUCT,                   -- Product [PRODUCTNUMBER]
    ACTIVEPRODUCTUNIT,               -- Alternative UoM [ALTERNATIVEUNIT]
    ACTIVELANGUAGE,                  -- Language Key [LANGUAGEKEY]
    ACTIVEPRODUCTUNITSHORTTEXTCODE,  -- Short Text Code [PRODUCTUNITSHORTTEXTCODE]
    ACTIVEPRODUCTUNITTEXTSEQNUM,     -- Consecutive Number [CONSECUTIVENUM]
    PRODUCT,                         -- Product [PRODUCTNUMBER]
    PRODUCTUNIT,                     -- Alternative UoM [ALTERNATIVEUNIT]
    PRODUCTUNITTEXTSEQNUM,           -- Consecutive Number [CONSECUTIVENUM]
    PRODUCTUNITSHORTTEXTCODE,        -- Short Text Code [PRODUCTUNITSHORTTEXTCODE]
    LANGUAGE,                        -- Language Key [LANGUAGEKEY]
    PRODUCTDESCRIPTION,              -- Description [PRODUCTDESCRIPTION]
    PRIMARY KEY (CLIENT, DRAFTKEY)
);

Learn More