VICSSG_D

Transparent Table Application Table
34 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 34 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 (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY internalrealestatenumber RECAINTRENO RE Key
KEY draftuuid SDRAFT_UUID Draft Document ID
restatusobject RECAOBJNR Object Number
realestateservicegroupnumber RECSSGNR Service Group
reservicegroupnumberforedit RECSSGNR Service Group
validitystartdate REBDVDMVALIDFROM Validity Start Date
validityenddate REBDVDMVALIDTO Validity End Date
reservicegrouptype RECSSGTYPE Service Group Type
reservicegroupcategory RECSSGCATEGORY Service Group Category
reservicegroupname RECSSGXSTEXT Service Group Name (Short)
reservicegrouplongname RECSSGXLTEXT Service Group Name (Long)
reparentintrealestatenumber RECSPARENTINTRENO Parent Number
reparentintegobjectnumber REIPIONR Real Estate Object
companycode RECSSGBUKRS Company Code
createdbyuser RERF Entered By
creationdate DERF First Enterd On
creationtime TERF Time
resourceofcreation REHER Source.In.Entry
lastchangedbyuser RBEAR Last Changed By
lastchangedate DBEAR Last Edited On
lastchangetime TBEAR Last Edited At
resourceofchange RBHER Editing Source
responsible RECARESPONSIBLE Person Respons.
reauthorizationgroup RECAAUTHGRP Authoriz. Group
creationdatetime VDM_CREATIONDATETIME Created On
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
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.

-- 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]
    INTERNALREALESTATENUMBER,       -- RE Key [RECAINTRENO]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    RESTATUSOBJECT,                 -- Object Number [RECAOBJNR]
    REALESTATESERVICEGROUPNUMBER,   -- Service Group [RECSSGNR]
    RESERVICEGROUPNUMBERFOREDIT,    -- Service Group [RECSSGNR]
    VALIDITYSTARTDATE,              -- Validity Start Date [REBDVDMVALIDFROM]
    VALIDITYENDDATE,                -- Validity End Date [REBDVDMVALIDTO]
    RESERVICEGROUPTYPE,             -- Service Group Type [RECSSGTYPE]
    RESERVICEGROUPCATEGORY,         -- Service Group Category [RECSSGCATEGORY]
    RESERVICEGROUPNAME,             -- Service Group Name (Short) [RECSSGXSTEXT]
    RESERVICEGROUPLONGNAME,         -- Service Group Name (Long) [RECSSGXLTEXT]
    REPARENTINTREALESTATENUMBER,    -- Parent Number [RECSPARENTINTRENO]
    REPARENTINTEGOBJECTNUMBER,      -- Real Estate Object [REIPIONR]
    COMPANYCODE,                    -- Company Code [RECSSGBUKRS]
    CREATEDBYUSER,                  -- Entered By [RERF]
    CREATIONDATE,                   -- First Enterd On [DERF]
    CREATIONTIME,                   -- Time [TERF]
    RESOURCEOFCREATION,             -- Source.In.Entry [REHER]
    LASTCHANGEDBYUSER,              -- Last Changed By [RBEAR]
    LASTCHANGEDATE,                 -- Last Edited On [DBEAR]
    LASTCHANGETIME,                 -- Last Edited At [TBEAR]
    RESOURCEOFCHANGE,               -- Editing Source [RBHER]
    RESPONSIBLE,                    -- Person Respons. [RECARESPONSIBLE]
    REAUTHORIZATIONGROUP,           -- Authoriz. Group [RECAAUTHGRP]
    CREATIONDATETIME,               -- Created On [VDM_CREATIONDATETIME]
    LASTCHANGEDATETIME,             -- Last Changed On [VDM_LASTCHANGEDON]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_REC_PS,                   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, INTERNALREALESTATENUMBER, DRAFTUUID)
);

Learn More