T352R

Transparent Table Application Table
26 Fields 3 CDS Views

Maintenance revisions

T352R is an SAP database table in S/4HANA. Maintenance revisions. It contains 26 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_DFS_MaintRevisionBasic view from BASIC Basic view of Revision
I_MaintenanceEvent view_entity from BASIC Maintenance Event
I_MaintenanceRevision view from BASIC Maintenance Revision

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY iwerk IWERK Planning Plant
KEY revnr REVNI Revision
revbd REVBD Start date
revbz REVBZ RevStrtTime
reved REVED End date
revez REVEZ RevEndTime
revtx REVTX RevDescription
revab REVAB RevCompleted
pm_objty PM_OBJTY Object Type
gewrk GEWRK Main WorkCtr
equnr EQUNR Equipment
tplnr TPLNR Functional loc.
pspel PS_PSP_ELE WBS Element
aufnr NW_AUFNR Network
aenam AENAM Changed By
aedat AEDAT Changed On
ernam ERNAM Created By
erdat ERDAT Created On
objnr J_OBJNR Object number
revty DIWPS_REVTY_CORE Revision Type
objid LGWID Work Center
vaplz GEWRK Main WorkCtr
vawrk WERGW Plnt WorkCenter
extappl DIWPS_EXT_APPL External Appl.
extref DIWPS_REV_EXT_REF Rev. Ext. Ref.

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.

-- Maintenance revisions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T352R (
    MANDT,     -- Client [MANDT]
    IWERK,     -- Planning Plant [IWERK]
    REVNR,     -- Revision [REVNI]
    REVBD,     -- Start date [REVBD]
    REVBZ,     -- RevStrtTime [REVBZ]
    REVED,     -- End date [REVED]
    REVEZ,     -- RevEndTime [REVEZ]
    REVTX,     -- RevDescription [REVTX]
    REVAB,     -- RevCompleted [REVAB]
    PM_OBJTY,  -- Object Type [PM_OBJTY]
    GEWRK,     -- Main WorkCtr [GEWRK]
    EQUNR,     -- Equipment [EQUNR]
    TPLNR,     -- Functional loc. [TPLNR]
    PSPEL,     -- WBS Element [PS_PSP_ELE]
    AUFNR,     -- Network [NW_AUFNR]
    AENAM,     -- Changed By [AENAM]
    AEDAT,     -- Changed On [AEDAT]
    ERNAM,     -- Created By [ERNAM]
    ERDAT,     -- Created On [ERDAT]
    OBJNR,     -- Object number [J_OBJNR]
    REVTY,     -- Revision Type [DIWPS_REVTY_CORE]
    OBJID,     -- Work Center [LGWID]
    VAPLZ,     -- Main WorkCtr [GEWRK]
    VAWRK,     -- Plnt WorkCenter [WERGW]
    EXTAPPL,   -- External Appl. [DIWPS_EXT_APPL]
    EXTREF,    -- Rev. Ext. Ref. [DIWPS_REV_EXT_REF]
    PRIMARY KEY (MANDT, IWERK, REVNR)
);

Learn More