CRMS4D_ORDPRP_I

Transparent Table Application Table
7 Fields 1 CDS Views

Table to store the product list

CRMS4D_ORDPRP_I is an SAP database table in S/4HANA. Table to store the product list. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ServiceProductList view from BASIC Service Product List

Fields (7)

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 counter crms4_ordprp_i_counter Counter for ORDPRP_I
product_id matnr Material
prod_hierarchy prodh_d Prod. Hierarchy

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.

-- Table to store the product list
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_ORDPRP_I (
    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]
    COUNTER,         -- Counter for ORDPRP_I [crms4_ordprp_i_counter]
    PRODUCT_ID,      -- Material [matnr]
    PROD_HIERARCHY,  -- Prod. Hierarchy [prodh_d]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, COUNTER)
);

Learn More