VICDCOND

Transparent Table Application Table
50 Fields 6 CDS Views

Condition

VICDCOND is an SAP database table in S/4HANA. Condition. It contains 50 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_RECondition view_entity from BASIC Real Estate Conditions
I_REContrCondition view_entity from BASIC Real Estate Conditions
P_RECondition2AdjmtRecord view from P_RECondition2AdjustmentRecord
P_RECondition2AdjmtRecord view union P_RECondition2AdjustmentRecord
P_RECondition2AdjustmentRecord view_entity from P_RECondition2AdjustmentRecord
P_RECondition2AdjustmentRecord view_entity union P_RECondition2AdjustmentRecord

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY condguid RECDCONDGUID Condition
intreno RECAINTRENO RE Key
objnr RECDOBJNRCALC Calc. Obj.
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
condcurr RECDCONDCURR Currency
exduedate RECDEXDUEDATE Due Date
duedateup RECDDUEDATEUP FollPost Due
objnrdist RECDOBJNRDIST Distrib. Obj.
invalidcalc RECDINVALIDCALC Calc. Invalid
invaliddist RECDINVALIDDIST Dist. Invalid
termnopy RECDTERMNOPY Posting Term
termnorh RECDTERMNORH Frequency Term
termnoaj RECDTERMNOAJ Adjust. Term
termnooa RECDTERMNOOA Org. Term
termnosr RECDTERMNOSR Sales Term
termnomr RECDTERMNOMR Peak Sales Term
termnowt RECDTERMNOWT WT Term
termnopyscs RECDTERMNOPYSCS SCS Post.Term
termnopyscsact RECDTERMNOPYSCSACT SCS Term Active
duedatecorr RECDDUEDATECORR Days
duedatecorrday RECDDUEDATECORRDAY4 Days
duedatecorrmonth RECDDUEDATECORRMONTH4 Months
conddelete RECDCONDDELETE Deletion ind.
cfpostingfrom RECDCFPOSTINGFROM 1st Posting Frm
condtype RECDCONDTYPE Condition Type
condvalidfrom RECDVALIDFROM Valid From
condvalidto RECDVALIDTO Valid to
uniquecond RECDUNIQUECOND One-Time Cond.
infocond RECDINFOCOND Stat.Condit.
unitprice RECDUNITPRICE Unit Price
calcrule RECDCALCRULE Calc. Formula
calcrulepara1 RECDCALCRULEPARA Calc.FormParam.
calcrulepara2 RECDCALCRULEPARA Calc.FormParam.
distrule RECDDISTRULE Distrib. Form.
distrulepara1 RECDDISTRULEPARA Dist.Form.Param
distrulepara2 RECDDISTRULEPARA Dist.Form.Param
objtypedistdist RECDOBJTYPEDIST Distrib. Object
objtypedistpost RECDOBJTYPEPOST Posting Object
condpurposeext RECDCONDPURPOSEEXT Ext.Cond.Purp.
chgreason RECDCHGREASON Change Reason
objnrcalcpara RECDOBJNRPARA Parameter Obj.
objnrdistpara RECDOBJNRPARA Parameter Obj.

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.

-- Condition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICDCOND (
    MANDT,             -- Client [MANDT]
    CONDGUID,          -- Condition [RECDCONDGUID]
    INTRENO,           -- RE Key [RECAINTRENO]
    OBJNR,             -- Calc. Obj. [RECDOBJNRCALC]
    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]
    CONDCURR,          -- Currency [RECDCONDCURR]
    EXDUEDATE,         -- Due Date [RECDEXDUEDATE]
    DUEDATEUP,         -- FollPost Due [RECDDUEDATEUP]
    OBJNRDIST,         -- Distrib. Obj. [RECDOBJNRDIST]
    INVALIDCALC,       -- Calc. Invalid [RECDINVALIDCALC]
    INVALIDDIST,       -- Dist. Invalid [RECDINVALIDDIST]
    TERMNOPY,          -- Posting Term [RECDTERMNOPY]
    TERMNORH,          -- Frequency Term [RECDTERMNORH]
    TERMNOAJ,          -- Adjust. Term [RECDTERMNOAJ]
    TERMNOOA,          -- Org. Term [RECDTERMNOOA]
    TERMNOSR,          -- Sales Term [RECDTERMNOSR]
    TERMNOMR,          -- Peak Sales Term [RECDTERMNOMR]
    TERMNOWT,          -- WT Term [RECDTERMNOWT]
    TERMNOPYSCS,       -- SCS Post.Term [RECDTERMNOPYSCS]
    TERMNOPYSCSACT,    -- SCS Term Active [RECDTERMNOPYSCSACT]
    DUEDATECORR,       -- Days [RECDDUEDATECORR]
    DUEDATECORRDAY,    -- Days [RECDDUEDATECORRDAY4]
    DUEDATECORRMONTH,  -- Months [RECDDUEDATECORRMONTH4]
    CONDDELETE,        -- Deletion ind. [RECDCONDDELETE]
    CFPOSTINGFROM,     -- 1st Posting Frm [RECDCFPOSTINGFROM]
    CONDTYPE,          -- Condition Type [RECDCONDTYPE]
    CONDVALIDFROM,     -- Valid From [RECDVALIDFROM]
    CONDVALIDTO,       -- Valid to [RECDVALIDTO]
    UNIQUECOND,        -- One-Time Cond. [RECDUNIQUECOND]
    INFOCOND,          -- Stat.Condit. [RECDINFOCOND]
    UNITPRICE,         -- Unit Price [RECDUNITPRICE]
    CALCRULE,          -- Calc. Formula [RECDCALCRULE]
    CALCRULEPARA1,     -- Calc.FormParam. [RECDCALCRULEPARA]
    CALCRULEPARA2,     -- Calc.FormParam. [RECDCALCRULEPARA]
    DISTRULE,          -- Distrib. Form. [RECDDISTRULE]
    DISTRULEPARA1,     -- Dist.Form.Param [RECDDISTRULEPARA]
    DISTRULEPARA2,     -- Dist.Form.Param [RECDDISTRULEPARA]
    OBJTYPEDISTDIST,   -- Distrib. Object [RECDOBJTYPEDIST]
    OBJTYPEDISTPOST,   -- Posting Object [RECDOBJTYPEPOST]
    CONDPURPOSEEXT,    -- Ext.Cond.Purp. [RECDCONDPURPOSEEXT]
    CHGREASON,         -- Change Reason [RECDCHGREASON]
    OBJNRCALCPARA,     -- Parameter Obj. [RECDOBJNRPARA]
    OBJNRDISTPARA,     -- Parameter Obj. [RECDOBJNRPARA]
    PRIMARY KEY (MANDT, CONDGUID)
);

Learn More