VICSSG

Transparent Table Application Table
21 Fields 3 CDS Views

Real Estate Service Group

VICSSG is an SAP database table in S/4HANA. Real Estate Service Group. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_REServiceGroup view_entity from EXTENSION Real Estate Service Group - Extension
I_REServiceGroup view_entity from BASIC Real Estate Service Group
I_REServiceGroupBasicData view_entity from BASIC Real Estate Service Group

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY intreno RECAINTRENO RE Key
sgnr RECSSGNR Service Group
objnr RECAOBJNR Object Number
bukrs RECSSGBUKRS Company Code
sgtype RECSSGTYPE Service Group Type
sgcategory RECSSGCATEGORY Service Group Category
sgxstext RECSSGXSTEXT Service Group Name (Short)
sgxltext RECSSGXLTEXT Service Group Name (Long)
parentintreno RECSPARENTINTRENO Parent Number
authgrp RECAAUTHGRP Authoriz. Group
responsible RECARESPONSIBLE Person Respons.
rerf RERF Entered By
derf DERF First Enterd On
terf TERF Time
reher REHER Source.In.Entry
rbear RBEAR Last Changed By
dbear DBEAR Last Edited On
tbear TBEAR Last Edited At
rbher RBHER Editing Source
dummy_rec_ps CFD_DUMMY Dummy

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.

-- Real Estate Service Group
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICSSG (
    MANDT,          -- Client [MANDT]
    INTRENO,        -- RE Key [RECAINTRENO]
    SGNR,           -- Service Group [RECSSGNR]
    OBJNR,          -- Object Number [RECAOBJNR]
    BUKRS,          -- Company Code [RECSSGBUKRS]
    SGTYPE,         -- Service Group Type [RECSSGTYPE]
    SGCATEGORY,     -- Service Group Category [RECSSGCATEGORY]
    SGXSTEXT,       -- Service Group Name (Short) [RECSSGXSTEXT]
    SGXLTEXT,       -- Service Group Name (Long) [RECSSGXLTEXT]
    PARENTINTRENO,  -- Parent Number [RECSPARENTINTRENO]
    AUTHGRP,        -- Authoriz. Group [RECAAUTHGRP]
    RESPONSIBLE,    -- Person Respons. [RECARESPONSIBLE]
    RERF,           -- Entered By [RERF]
    DERF,           -- First Enterd On [DERF]
    TERF,           -- Time [TERF]
    REHER,          -- Source.In.Entry [REHER]
    RBEAR,          -- Last Changed By [RBEAR]
    DBEAR,          -- Last Edited On [DBEAR]
    TBEAR,          -- Last Edited At [TBEAR]
    RBHER,          -- Editing Source [RBHER]
    DUMMY_REC_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, INTRENO)
);

Learn More