CRMS4D_REPA_I

Transparent Table Application Table
55 Fields 4 CDS Views

In-House Repair: Items

CRMS4D_REPA_I is an SAP database table in S/4HANA. In-House Repair: Items. It contains 55 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CRMS4_REPA_I_SEARCH view_entity from Search for In-House Service Object
CRMS4V_SDM_CRMS4D_SERV_H_IHRID view left_outer
E_InHouseRepairItem view from EXTENSION In-House Service Object - Extension
I_InHouseRepairItem view from BASIC In-House Service Object

Fields (55)

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.
item_guid CRMT_OBJECT_GUID Object GUID
created_at_i CRMS4_CREATED_AT Created On
created_by_i CRMT_CREATED_BY Created By
changed_at_i CRMS4_CHANGED_AT Changed On
changed_by_i CRMT_CHANGED_BY Changed By
objtype_i CRMT_SWO_OBJTYP_PROCESS_ITM_DB Object Type
header_guid CRMT_OBJECT_GUID Object GUID
parent CRMT_OBJECT_GUID Object GUID
product CRMT_PRODUCT_GUID_DB Product GUID
ordered_prod CRMT_ORDERED_PROD_DB Product
partner_prod CRMT_ITEM_DESCR_PARTNER Partner Product
description_i CRMT_PRSHTEXTX_DB Short Text
itm_language CRMT_ITEM_LANGU Language
itm_type CRMT_ITEM_TYPE_DB Item Category
itm_usage CRMT_ITEM_USAGE Usage HL Item
itm_type_usage CRMT_IT_TYPE_USAGE Item Cat. Usage
product_kind CRMT_PRODUCT_KIND Prod. Tech. Typ
product_id PRODUCTNUMBER Product
objguid_b_sel CRMT_OBJECT_GUID Object GUID
objkey_b_sel SWO_TYPEID Key
objtype_b_sel SWO_OBJTYP Object Type
item_guid_char CRMT_OBJECT_GUID32 Object GUID
stat_lifecycle CRMS4_USER_STAT_LIFECYCLE Unique Custom Status
stat_suppl CRMS4_REPA_SUPPLEM_STATUS Add. Status
stat_error CRMS4_STAT_ERROR Error Status
stat_open CRMS4_STAT_OPEN Open
stat_delivery CRMS4_STAT_DELIVERY Delivery Status
stat_repair_availability CRMS4_STAT_REPAIR_AVAILABILITY Availability
refobj_product_id PRODUCTNUMBER Product
serial_number GERNR Serial Number
equipment_id EQUNR Equipment
functional_location_id TPLNR Functional loc.
process_qty_num CRMT_PROCESS_QTY_NUM Numerator
process_qty_den CRMT_PROCESS_QTY_DEN Denominator
exponent10 CRMT_EXPONENT10 Exponent
process_qty_unit CRMT_PROCESS_QTY_UNIT Sales Unit
base_qty_unit COMT_PRODUCT_BASE_UOM BUoM
order_qty CRMT_QTY_ORDER Order Quantity
process_type CRMT_PROCESS_TYPE_DB Transaction Type
posting_date CRMT_POSTING_DATE Posting Date
description_h CRMT_PROCESS_DESCRIPTION Description
descr_language CRMT_PROCESS_DESCRIPTION_LANGU Language
created_at_h CRMS4_CREATED_AT Created On
created_by_h CRMT_CREATED_BY Created By
changed_at_h CRMS4_CHANGED_AT Changed On
changed_by_h CRMT_CHANGED_BY Changed By
archiving_flag CRMT_ARCHIVING_FLAG Can Be Archived
ref_return_order_item POSNR Item
ref_msr_item MSR_PROCESS_ITEM Item in Process
ref_msr_split_id MSR_SPLIT_ID Split ID
repa_i_dummy_ps CHAR1 Single-Character Flag

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.

-- In-House Repair: Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_REPA_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]
    ITEM_GUID,                 -- Object GUID [CRMT_OBJECT_GUID]
    CREATED_AT_I,              -- Created On [CRMS4_CREATED_AT]
    CREATED_BY_I,              -- Created By [CRMT_CREATED_BY]
    CHANGED_AT_I,              -- Changed On [CRMS4_CHANGED_AT]
    CHANGED_BY_I,              -- Changed By [CRMT_CHANGED_BY]
    OBJTYPE_I,                 -- Object Type [CRMT_SWO_OBJTYP_PROCESS_ITM_DB]
    HEADER_GUID,               -- Object GUID [CRMT_OBJECT_GUID]
    PARENT,                    -- Object GUID [CRMT_OBJECT_GUID]
    PRODUCT,                   -- Product GUID [CRMT_PRODUCT_GUID_DB]
    ORDERED_PROD,              -- Product [CRMT_ORDERED_PROD_DB]
    PARTNER_PROD,              -- Partner Product [CRMT_ITEM_DESCR_PARTNER]
    DESCRIPTION_I,             -- Short Text [CRMT_PRSHTEXTX_DB]
    ITM_LANGUAGE,              -- Language [CRMT_ITEM_LANGU]
    ITM_TYPE,                  -- Item Category [CRMT_ITEM_TYPE_DB]
    ITM_USAGE,                 -- Usage HL Item [CRMT_ITEM_USAGE]
    ITM_TYPE_USAGE,            -- Item Cat. Usage [CRMT_IT_TYPE_USAGE]
    PRODUCT_KIND,              -- Prod. Tech. Typ [CRMT_PRODUCT_KIND]
    PRODUCT_ID,                -- Product [PRODUCTNUMBER]
    OBJGUID_B_SEL,             -- Object GUID [CRMT_OBJECT_GUID]
    OBJKEY_B_SEL,              -- Key [SWO_TYPEID]
    OBJTYPE_B_SEL,             -- Object Type [SWO_OBJTYP]
    ITEM_GUID_CHAR,            -- Object GUID [CRMT_OBJECT_GUID32]
    STAT_LIFECYCLE,            -- Unique Custom Status [CRMS4_USER_STAT_LIFECYCLE]
    STAT_SUPPL,                -- Add. Status [CRMS4_REPA_SUPPLEM_STATUS]
    STAT_ERROR,                -- Error Status [CRMS4_STAT_ERROR]
    STAT_OPEN,                 -- Open [CRMS4_STAT_OPEN]
    STAT_DELIVERY,             -- Delivery Status [CRMS4_STAT_DELIVERY]
    STAT_REPAIR_AVAILABILITY,  -- Availability [CRMS4_STAT_REPAIR_AVAILABILITY]
    REFOBJ_PRODUCT_ID,         -- Product [PRODUCTNUMBER]
    SERIAL_NUMBER,             -- Serial Number [GERNR]
    EQUIPMENT_ID,              -- Equipment [EQUNR]
    FUNCTIONAL_LOCATION_ID,    -- Functional loc. [TPLNR]
    PROCESS_QTY_NUM,           -- Numerator [CRMT_PROCESS_QTY_NUM]
    PROCESS_QTY_DEN,           -- Denominator [CRMT_PROCESS_QTY_DEN]
    EXPONENT10,                -- Exponent [CRMT_EXPONENT10]
    PROCESS_QTY_UNIT,          -- Sales Unit [CRMT_PROCESS_QTY_UNIT]
    BASE_QTY_UNIT,             -- BUoM [COMT_PRODUCT_BASE_UOM]
    ORDER_QTY,                 -- Order Quantity [CRMT_QTY_ORDER]
    PROCESS_TYPE,              -- Transaction Type [CRMT_PROCESS_TYPE_DB]
    POSTING_DATE,              -- Posting Date [CRMT_POSTING_DATE]
    DESCRIPTION_H,             -- Description [CRMT_PROCESS_DESCRIPTION]
    DESCR_LANGUAGE,            -- Language [CRMT_PROCESS_DESCRIPTION_LANGU]
    CREATED_AT_H,              -- Created On [CRMS4_CREATED_AT]
    CREATED_BY_H,              -- Created By [CRMT_CREATED_BY]
    CHANGED_AT_H,              -- Changed On [CRMS4_CHANGED_AT]
    CHANGED_BY_H,              -- Changed By [CRMT_CHANGED_BY]
    ARCHIVING_FLAG,            -- Can Be Archived [CRMT_ARCHIVING_FLAG]
    REF_RETURN_ORDER_ITEM,     -- Item [POSNR]
    REF_MSR_ITEM,              -- Item in Process [MSR_PROCESS_ITEM]
    REF_MSR_SPLIT_ID,          -- Split ID [MSR_SPLIT_ID]
    REPA_I_DUMMY_PS,           -- Single-Character Flag [CHAR1]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT)
);

Learn More