VICSSG_D

Transparent Table Application Table
21 Fields 3 CDS Views

Draft table for entity R_RESERVICEGROUPTP

VICSSG_D is an SAP database table in S/4HANA. Draft table for entity R_RESERVICEGROUPTP. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_REServiceGroupD view_entity from EXTENSION RE ServiceGroup - Extension
I_REServiceGroupDraft view_entity from BASIC RE Service Group - Draft
R_REServiceGroupDraft view_entity from BASIC Real Estate ServiceGroup - Draft

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reservicegroupuuid recssgobjectuuid
internalrealestatenumber recaintreno RE Key
restatusobject recaobjnr Object Number
reservicegroupoid recssgoid
realestateservicegroupnumber recssgnr Service Group
reservicegroupnumberforedit recssgnr Service Group
reservicegroupalternativeid recssgalternativeid
reservicegroupname recsxsg
companycode recssgbukrs Company Code
reservicegroupparentuuid recsparentobjectuuid
rearchtrobjectnumberbldngland reobvdmobnrbuildingland Building/Land Object Number
reservicegrouptype recssgtype Service Group Type
reservicegroupcategory recssgcategory Service Group Category
reauthorizationgroup recaauthgrp Authoriz. Group
validitystartdate recssgvalidfrom
validityenddate recssgvalidto
creationdatetime abp_creation_tstmpl Created On
lastchangedatetime abp_lastchange_tstmpl Changed On
locallastchangedatetime abp_locinst_lastchange_tstmpl Changed On
changedocobject cdobjectv Object Value

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.

-- Draft table for entity R_RESERVICEGROUPTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICSSG_D (
    MANDT,                          -- Client [mandt]
    RESERVICEGROUPUUID,             -- recssgobjectuuid
    INTERNALREALESTATENUMBER,       -- RE Key [recaintreno]
    RESTATUSOBJECT,                 -- Object Number [recaobjnr]
    RESERVICEGROUPOID,              -- recssgoid
    REALESTATESERVICEGROUPNUMBER,   -- Service Group [recssgnr]
    RESERVICEGROUPNUMBERFOREDIT,    -- Service Group [recssgnr]
    RESERVICEGROUPALTERNATIVEID,    -- recssgalternativeid
    RESERVICEGROUPNAME,             -- recsxsg
    COMPANYCODE,                    -- Company Code [recssgbukrs]
    RESERVICEGROUPPARENTUUID,       -- recsparentobjectuuid
    REARCHTROBJECTNUMBERBLDNGLAND,  -- Building/Land Object Number [reobvdmobnrbuildingland]
    RESERVICEGROUPTYPE,             -- Service Group Type [recssgtype]
    RESERVICEGROUPCATEGORY,         -- Service Group Category [recssgcategory]
    REAUTHORIZATIONGROUP,           -- Authoriz. Group [recaauthgrp]
    VALIDITYSTARTDATE,              -- recssgvalidfrom
    VALIDITYENDDATE,                -- recssgvalidto
    CREATIONDATETIME,               -- Created On [abp_creation_tstmpl]
    LASTCHANGEDATETIME,             -- Changed On [abp_lastchange_tstmpl]
    LOCALLASTCHANGEDATETIME,        -- Changed On [abp_locinst_lastchange_tstmpl]
    CHANGEDOCOBJECT,                -- Object Value [cdobjectv]
    PRIMARY KEY (MANDT, RESERVICEGROUPUUID)
);

Learn More