CRTX

Transparent Table Application Table
8 Fields 3 CDS Views

Text for the Work Center or Production Resource/Tool

CRTX is an SAP database table in S/4HANA. Text for the Work Center or Production Resource/Tool. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/merp/pm_workcenter view left_outer CDS View: Workcenter
I_ProductionResourceText view_entity from BASIC Production Resource - Text
I_Qm_Workcenterinfo_T view_entity from BASIC Workcenter description

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY objty cr_objty Object Type
KEY objid cr_objid Object ID
KEY spras spras Language
aedat_text aedtm Changed on
aenam_text usrname User Name
ktext cr_ktext Description
ktext_up cr_ktextup 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.

-- Text for the Work Center or Production Resource/Tool
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRTX (
    MANDT,       -- Client [mandt]
    OBJTY,       -- Object Type [cr_objty]
    OBJID,       -- Object ID [cr_objid]
    SPRAS,       -- Language [spras]
    AEDAT_TEXT,  -- Changed on [aedtm]
    AENAM_TEXT,  -- User Name [usrname]
    KTEXT,       -- Description [cr_ktext]
    KTEXT_UP,    -- Description [cr_ktextup]
    PRIMARY KEY (MANDT, OBJTY, OBJID, SPRAS)
);

Learn More