CRTX

Transparent Table Application Table
8 Fields 5 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. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
/merp/pm_workcenter view left_outer CDS View: Workcenter
I_DFS_WorkCenterTextDEX view_entity from BASIC Defense Workcenter Extractor - Text
I_FrcElmntOrgWrkCtrText view from BASIC Work Center Text View
I_ProductionResourceText view_entity from BASIC Production Resource - Text
I_Qm_Workcenterinfo_T view 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