VZZKOKO

Transparent Table Application Table
62 Fields 2 CDS Views

Table condition header

VZZKOKO is an SAP database table in S/4HANA. Table condition header. It contains 62 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LoanContrCndnHdr view from BASIC Conditon Header for Loan Contract
I_LoanContrCndnHdrData view from BASIC Conditon Header for Loan Contract

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY sanlf sanlf Prod. Category
KEY rkey1 rkey1 Key 1
KEY dguel_kk dguel Cond. Eff. from
KEY nlfd_ang nlfd_ang Off.consec.no.
sstati sstati Status
skokoart skokoart ConditHeadType
stilgrhy stilgrhy Repmnt frequen.
stilgart stilgart Repayment Type
sdisein sdisein Disc.determin.
kzahlung kzahlung Pay-in/disb.rt
bzahlung bzahlung Payment amount
swhrzhlg swhrzhlg Currency
bzusage bzusage Commit.capital
swhrzusa swhrzusa Currency
peffzins tb_eff_rate Effect.Int.Rate
seffmeth seffmeth_new Eff.int.meth.
szbmeth szbmeth Int.calc.method
sdisko sdisko Discounted
dkuend dkuend Notice date
skuend skuend Notice Reason
dkuenddg dkuenddg Not.Dte Lender
dblfz dblfz Start of Term
dblfz_origin dblfz_origin Orig. Term Start
delfz delfz End of Term
dresam dresam Reserved On
dresbis dresbis Reserved Until
dangam dangam Offer on
dangbis dangbis Offer until
sangvor sangvor Reservation
jannahme jannahme Acceptance
sannahme sannahme Acceptance type
dannahme dannahme Accepted on
jvertrag jvertrag Contract
dvertram dvertram Contract on
dvertbis dvertbis Return by
pmaneffz tb_eff_rate_int Int. Eff. Rate
seffm2 seffmeth Eff.Int. Method
skuegl vvskuegl Lender.Not.Arrn
rpnr vvrpnr Rollover no.
defsz vvdefsz Fixed until
dges vvdges Legal Notice
sgesaus vvsgesaus LegalRoNExclud.
szkz vvszkz Spec.inter.ID
nangebot nlfd_ang Off.consec.no.
sincl vvsincl Inclusive Ind.
zvrhyeff vvzvrhyeff Int.sttlm.freq
pvgleffz tb_eff_rate_com Comp. Eff. Int.
sultefsz vvsultefsz MEnd ind. EndFP
dabeffz vvdabeffz Eff. int. from
dkuenddn vvdkuenddn Borr.Notic.Date
skuedn vvskuedn Borr.Not.Arrng.
skueart vvskueart Notice Type
dmarktzins dmarktzins Int. Rate Date
skalidwt tfmskalidwt Int. Calendar
edeffzins tb_eff_rate_ed Cl.Def.Eff.Int
edeffmeth effmeth Eff.Int.Method
jahreffzins tb_eff_rate_year Yearly Eff. Int.
jahreffmeth effmeth Eff.Int.Method
peffzins_origin tb_eff_rate_orig Orig. Effect. Int.
peffzins_add tb_eff_rate_add Add. Eff. Int.

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.

-- Table condition header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VZZKOKO (
    MANDT,            -- Client [mandt]
    BUKRS,            -- Company Code [bukrs]
    SANLF,            -- Prod. Category [sanlf]
    RKEY1,            -- Key 1 [rkey1]
    DGUEL_KK,         -- Cond. Eff. from [dguel]
    NLFD_ANG,         -- Off.consec.no. [nlfd_ang]
    SSTATI,           -- Status [sstati]
    SKOKOART,         -- ConditHeadType [skokoart]
    STILGRHY,         -- Repmnt frequen. [stilgrhy]
    STILGART,         -- Repayment Type [stilgart]
    SDISEIN,          -- Disc.determin. [sdisein]
    KZAHLUNG,         -- Pay-in/disb.rt [kzahlung]
    BZAHLUNG,         -- Payment amount [bzahlung]
    SWHRZHLG,         -- Currency [swhrzhlg]
    BZUSAGE,          -- Commit.capital [bzusage]
    SWHRZUSA,         -- Currency [swhrzusa]
    PEFFZINS,         -- Effect.Int.Rate [tb_eff_rate]
    SEFFMETH,         -- Eff.int.meth. [seffmeth_new]
    SZBMETH,          -- Int.calc.method [szbmeth]
    SDISKO,           -- Discounted [sdisko]
    DKUEND,           -- Notice date [dkuend]
    SKUEND,           -- Notice Reason [skuend]
    DKUENDDG,         -- Not.Dte Lender [dkuenddg]
    DBLFZ,            -- Start of Term [dblfz]
    DBLFZ_ORIGIN,     -- Orig. Term Start [dblfz_origin]
    DELFZ,            -- End of Term [delfz]
    DRESAM,           -- Reserved On [dresam]
    DRESBIS,          -- Reserved Until [dresbis]
    DANGAM,           -- Offer on [dangam]
    DANGBIS,          -- Offer until [dangbis]
    SANGVOR,          -- Reservation [sangvor]
    JANNAHME,         -- Acceptance [jannahme]
    SANNAHME,         -- Acceptance type [sannahme]
    DANNAHME,         -- Accepted on [dannahme]
    JVERTRAG,         -- Contract [jvertrag]
    DVERTRAM,         -- Contract on [dvertram]
    DVERTBIS,         -- Return by [dvertbis]
    PMANEFFZ,         -- Int. Eff. Rate [tb_eff_rate_int]
    SEFFM2,           -- Eff.Int. Method [seffmeth]
    SKUEGL,           -- Lender.Not.Arrn [vvskuegl]
    RPNR,             -- Rollover no. [vvrpnr]
    DEFSZ,            -- Fixed until [vvdefsz]
    DGES,             -- Legal Notice [vvdges]
    SGESAUS,          -- LegalRoNExclud. [vvsgesaus]
    SZKZ,             -- Spec.inter.ID [vvszkz]
    NANGEBOT,         -- Off.consec.no. [nlfd_ang]
    SINCL,            -- Inclusive Ind. [vvsincl]
    ZVRHYEFF,         -- Int.sttlm.freq [vvzvrhyeff]
    PVGLEFFZ,         -- Comp. Eff. Int. [tb_eff_rate_com]
    SULTEFSZ,         -- MEnd ind. EndFP [vvsultefsz]
    DABEFFZ,          -- Eff. int. from [vvdabeffz]
    DKUENDDN,         -- Borr.Notic.Date [vvdkuenddn]
    SKUEDN,           -- Borr.Not.Arrng. [vvskuedn]
    SKUEART,          -- Notice Type [vvskueart]
    DMARKTZINS,       -- Int. Rate Date [dmarktzins]
    SKALIDWT,         -- Int. Calendar [tfmskalidwt]
    EDEFFZINS,        -- Cl.Def.Eff.Int [tb_eff_rate_ed]
    EDEFFMETH,        -- Eff.Int.Method [effmeth]
    JAHREFFZINS,      -- Yearly Eff. Int. [tb_eff_rate_year]
    JAHREFFMETH,      -- Eff.Int.Method [effmeth]
    PEFFZINS_ORIGIN,  -- Orig. Effect. Int. [tb_eff_rate_orig]
    PEFFZINS_ADD,     -- Add. Eff. Int. [tb_eff_rate_add]
    PRIMARY KEY (MANDT, BUKRS, SANLF, RKEY1, DGUEL_KK, NLFD_ANG)
);

Learn More