RGM_PROMN_TRDSPI

Transparent Table Application Table
16 Fields 1 CDS Views

Promotion Trade Spend Item

RGM_PROMN_TRDSPI is an SAP database table in S/4HANA. Promotion Trade Spend Item. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RevnGrowthPromnTrdSpendItem view_entity from BASIC Trade Spend Items of Promotion

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY item_uuid RGM_PROMN_TRD_SPEND_ITEM_UUID Item UUID
trade_spend_uuid RGM_PROMOTION_TRADE_SPEND_UUID Trade Spend UUID
trade_spend_item_ext_uuid RGM_PROMN_TRADE_ITEM_EXT_UUID Item Ext. UUID
product MATNR Material
product_hier_node PRODH_D Prod. Hierarchy
cal_type_code RGM_CAL_TYPE Calculation Type
cal_method_code RGM_CAL_METHOD Calculation Mode
amount RGM_PROMOTION_ITEM_AMOUNT Item Amount
percentage RGM_PROMOTION_ITEM_PERCENTAGE Promotion Percentage
quantity RGM_PROMOTION_ITEM_QUANTITY Item Quantity
unit_of_measure RGM_PROMOTION_ITEM_UOM Promotion Item UoM
created_by ERNAM Created By
created_on RGM_PROMOTION_CREATE_ON Promotion Created On
changed_by AENAM Changed By
changed_on RGM_PROMOTION_CHANGE_ON Last Changed On

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.

-- Promotion Trade Spend Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RGM_PROMN_TRDSPI (
    MANDT,                      -- Client [MANDT]
    ITEM_UUID,                  -- Item UUID [RGM_PROMN_TRD_SPEND_ITEM_UUID]
    TRADE_SPEND_UUID,           -- Trade Spend UUID [RGM_PROMOTION_TRADE_SPEND_UUID]
    TRADE_SPEND_ITEM_EXT_UUID,  -- Item Ext. UUID [RGM_PROMN_TRADE_ITEM_EXT_UUID]
    PRODUCT,                    -- Material [MATNR]
    PRODUCT_HIER_NODE,          -- Prod. Hierarchy [PRODH_D]
    CAL_TYPE_CODE,              -- Calculation Type [RGM_CAL_TYPE]
    CAL_METHOD_CODE,            -- Calculation Mode [RGM_CAL_METHOD]
    AMOUNT,                     -- Item Amount [RGM_PROMOTION_ITEM_AMOUNT]
    PERCENTAGE,                 -- Promotion Percentage [RGM_PROMOTION_ITEM_PERCENTAGE]
    QUANTITY,                   -- Item Quantity [RGM_PROMOTION_ITEM_QUANTITY]
    UNIT_OF_MEASURE,            -- Promotion Item UoM [RGM_PROMOTION_ITEM_UOM]
    CREATED_BY,                 -- Created By [ERNAM]
    CREATED_ON,                 -- Promotion Created On [RGM_PROMOTION_CREATE_ON]
    CHANGED_BY,                 -- Changed By [AENAM]
    CHANGED_ON,                 -- Last Changed On [RGM_PROMOTION_CHANGE_ON]
    PRIMARY KEY (MANDT, ITEM_UUID)
);

Learn More