CRMS4D_FUTR_PRC

Transparent Table Application Table
16 Fields 1 CDS Views

Future Price

CRMS4D_FUTR_PRC is an SAP database table in S/4HANA. Future Price. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SrvcDocItemFuturePrice view_entity from BASIC Future Prices of Service Trans Item

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY objtype_h CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
KEY object_id CRMT_OBJECT_ID_DB Transaction ID
KEY number_int CRMS4_NUMBER_INT Item Number in Doc.
KEY record_id CRMS4_FUTURE_PRICE_ID Future Price ID
future_price_start CRMS4_FUTURE_PRC_START_TSTMP Start Date
future_price_end CRMS4_FUTURE_PRC_END_TSTMP End Date
condition_type KSCHA Condition Type
base_price CRMS4_BASE_PRICE Base Price
condition_currency WAERS Currency
condition_quantity KPEIN Pricing Unit
condition_quantity_unit CRMS4_CONDITION_QUANTITY_UNIT UoM
price_change_ratio CRMS4_PRICE_CHANGE_RATIO Price Change Ratio
target_price CRMS4_TARGET_PRICE Target Price
notification_date CRMS4_FUTR_PRC_NOTIF_TSTMP Notification Date
price_change_type KRECH_LONG Calculat.Type

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.

-- Future Price
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_FUTR_PRC (
    CLIENT,                   -- Client [MANDT]
    OBJTYPE_H,                -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,                -- Transaction ID [CRMT_OBJECT_ID_DB]
    NUMBER_INT,               -- Item Number in Doc. [CRMS4_NUMBER_INT]
    RECORD_ID,                -- Future Price ID [CRMS4_FUTURE_PRICE_ID]
    FUTURE_PRICE_START,       -- Start Date [CRMS4_FUTURE_PRC_START_TSTMP]
    FUTURE_PRICE_END,         -- End Date [CRMS4_FUTURE_PRC_END_TSTMP]
    CONDITION_TYPE,           -- Condition Type [KSCHA]
    BASE_PRICE,               -- Base Price [CRMS4_BASE_PRICE]
    CONDITION_CURRENCY,       -- Currency [WAERS]
    CONDITION_QUANTITY,       -- Pricing Unit [KPEIN]
    CONDITION_QUANTITY_UNIT,  -- UoM [CRMS4_CONDITION_QUANTITY_UNIT]
    PRICE_CHANGE_RATIO,       -- Price Change Ratio [CRMS4_PRICE_CHANGE_RATIO]
    TARGET_PRICE,             -- Target Price [CRMS4_TARGET_PRICE]
    NOTIFICATION_DATE,        -- Notification Date [CRMS4_FUTR_PRC_NOTIF_TSTMP]
    PRICE_CHANGE_TYPE,        -- Calculat.Type [KRECH_LONG]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, RECORD_ID)
);

Learn More