VICSSETTLCLFN

Transparent Table Application Table
15 Fields 1 CDS Views

RE Cost Settlement Classification Item

VICSSETTLCLFN is an SAP database table in S/4HANA. RE Cost Settlement Classification Item. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RECostSettlmtClassfctnItem view_entity from BASIC RE Cost Settlement Classification Item

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY classificationuuid recscostsettlmtclfnguid Classification GUID
rbukrs bukrs Company Code
gjahr gjahr Fiscal Year
belnr belnr_d Document Number
docln docln6 G/L Line Item
status recsclassificationstatus Classification Status
ignoreitem recsclassificationitemignored Ignore Item
service_date recsservicedate Service Date
costcategory recscostcategory Cost Category
servicegroup recssgnr Service Group
occupancygroup reipionr Real Estate Object
contract recnnr Contract No.
creationdatetime tzntstmpl Time Stamp
lastchangedatetime tzntstmpl Time Stamp

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.

-- RE Cost Settlement Classification Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICSSETTLCLFN (
    MANDT,               -- Client [mandt]
    CLASSIFICATIONUUID,  -- Classification GUID [recscostsettlmtclfnguid]
    RBUKRS,              -- Company Code [bukrs]
    GJAHR,               -- Fiscal Year [gjahr]
    BELNR,               -- Document Number [belnr_d]
    DOCLN,               -- G/L Line Item [docln6]
    STATUS,              -- Classification Status [recsclassificationstatus]
    IGNOREITEM,          -- Ignore Item [recsclassificationitemignored]
    SERVICE_DATE,        -- Service Date [recsservicedate]
    COSTCATEGORY,        -- Cost Category [recscostcategory]
    SERVICEGROUP,        -- Service Group [recssgnr]
    OCCUPANCYGROUP,      -- Real Estate Object [reipionr]
    CONTRACT,            -- Contract No. [recnnr]
    CREATIONDATETIME,    -- Time Stamp [tzntstmpl]
    LASTCHANGEDATETIME,  -- Time Stamp [tzntstmpl]
    PRIMARY KEY (MANDT, CLASSIFICATIONUUID)
);

Learn More