TIVCNCCTADD
Attribute der Vertragsart
TIVCNCCTADD is an SAP database table in S/4HANA. Attribute der Vertragsart. It contains 28 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_REContractType | view | from | BASIC | Real Estate Contract Type |
| I_REContractType_2 | view_entity | from | BASIC | Real Estate Contract Type |
| I_REContrPartcipnProcedure | view_entity | inner | BASIC | Real Estate Contract Participation |
Fields (28)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | smvart | smvart | Contract Type | |||
| gcvarnr | recavarnr | Screen Sequence | ||||
| condgroup | recdcondgroup | Condition Grp | ||||
| nrnroff | nrnr | No. Range No. | ||||
| home_url | recnurlhome | Homepage | ||||
| adjustnumberbeg | rebdadjustnumberbeg | GrpNoStart | ||||
| adjustnumberstep | rebdadjustnumberstep | Grp No.Interval | ||||
| bproletype1 | rebprole | BP Role | ||||
| bproletype2 | rebprole | BP Role | ||||
| bpappl | bp_appl | Application Cat | ||||
| usersupplier | recnusersupplier | Offerer/User | ||||
| category | recncategory | Contract Cat. | ||||
| cfperiod | recdcfperiod | CF Period | ||||
| optmeth | reitoptmeth | OptRate Method | ||||
| taxtype | rerataxtypedflt | Tax Type | ||||
| taxgroup | rerataxgroupdflt | Tax Group | ||||
| cntypedeposit | recntypedeposit | Contr.Type Dep. | ||||
| istaxfree | recnistaxfree | Tax-Exempt | ||||
| nooptmeth | recnnooptmeth | No Opt.RateMeth | ||||
| coseprof | reexcoseprof | Settlmt Profile | ||||
| ntprocdefault | retmntprocdefault | Notice Proced. | ||||
| cntypeusageind | recncntypeusageind | Infl. Holdings | ||||
| cmcflevel | reexcmcflevel | Planning Level | ||||
| currencyassign | recdcurrencyassign | Currency | ||||
| ispossdenabled | rebdispossdateenabled | PossessionDates | ||||
| condgroupsum | recdcondgroupsum | Cond.Grp Total | ||||
| cuexcludeassign | recacuexcludeassign | Obsolete |
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.
-- Attribute der Vertragsart
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TIVCNCCTADD (
MANDT, -- Client [mandt]
SMVART, -- Contract Type [smvart]
GCVARNR, -- Screen Sequence [recavarnr]
CONDGROUP, -- Condition Grp [recdcondgroup]
NRNROFF, -- No. Range No. [nrnr]
HOME_URL, -- Homepage [recnurlhome]
ADJUSTNUMBERBEG, -- GrpNoStart [rebdadjustnumberbeg]
ADJUSTNUMBERSTEP, -- Grp No.Interval [rebdadjustnumberstep]
BPROLETYPE1, -- BP Role [rebprole]
BPROLETYPE2, -- BP Role [rebprole]
BPAPPL, -- Application Cat [bp_appl]
USERSUPPLIER, -- Offerer/User [recnusersupplier]
CATEGORY, -- Contract Cat. [recncategory]
CFPERIOD, -- CF Period [recdcfperiod]
OPTMETH, -- OptRate Method [reitoptmeth]
TAXTYPE, -- Tax Type [rerataxtypedflt]
TAXGROUP, -- Tax Group [rerataxgroupdflt]
CNTYPEDEPOSIT, -- Contr.Type Dep. [recntypedeposit]
ISTAXFREE, -- Tax-Exempt [recnistaxfree]
NOOPTMETH, -- No Opt.RateMeth [recnnooptmeth]
COSEPROF, -- Settlmt Profile [reexcoseprof]
NTPROCDEFAULT, -- Notice Proced. [retmntprocdefault]
CNTYPEUSAGEIND, -- Infl. Holdings [recncntypeusageind]
CMCFLEVEL, -- Planning Level [reexcmcflevel]
CURRENCYASSIGN, -- Currency [recdcurrencyassign]
ISPOSSDENABLED, -- PossessionDates [rebdispossdateenabled]
CONDGROUPSUM, -- Cond.Grp Total [recdcondgroupsum]
CUEXCLUDEASSIGN, -- Obsolete [recacuexcludeassign]
PRIMARY KEY (MANDT, SMVART)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA