VZZKOPO

Transparent Table Application Table
157 Fields 3 CDS Views

Table condition items

VZZKOPO is an SAP database table in S/4HANA. Table condition items. It contains 157 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_LoanConditionItem view_entity from BASIC Condition Item for Loan Contract
I_SecurityClassConditionItem view_entity from BASIC Security Class Condition Item
P_SecClassIntCond view inner COMPOSITE

Fields (157)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY sanlf SANLF Prod. Category
KEY rkey1 RKEY1 Key 1
KEY rkey2 RKEY2 Key 2
KEY rkey3 RKEY3 Key 3
KEY dguel_kk DGUEL Cond. Eff. from
KEY nlfd_ang NLFD_ANG Off.consec.no.
KEY skoart SKOART Condition Type
KEY dguel_kp DGUEL_KP Item Eff. From
KEY nstufe NSTUFE Level Number
sstati SSTATI Status
pkond PKOND Percentage Rate
bkond BKOND Condition Amnt
swhrkond SWHRKOND Currency
sbasis VVSBASIS Base reference
szsref SZSREF Ref. Int. Rate
szsrefvz SZSREFVZ +/- Sign
pfluct TFM_PFLUCT Fluct. Margin
ammrhy AMMRHY Freq. in months
attrhy ATTRHY Freq.in days
szaws SZAWS Pmnt Form
rdivnr RDIVNR Divid.coup. no.
jnullkon JNULLKON Condition Form
mwskz MWSKZ Tax Code
jbmonat JBMONAT Amount/Month
dvalut DVALUT Calculat. date
dfaell DFAELL Due Date
kunnr KUNNR Customer
zlsch DZLSCH Pymt Meth.
bvtyp BVTYP Part.bank type
maber MABER Dunning Area
spartnr BP_PARTNR_NEW BusPartner
rkont RKONT Quota
svult VVSBULT Month-End Calc.
sfult SFULT Month-End DueDt
svkalri VVSNVER1 Not used
sfkalri VVSFKALRI Flexible
avgstage AVGSTAGE Wrk.dys val.dte
afgstage AFGSTAGE Wrk.daysDueDate
svkalzus VVSNVER1 Not used
sfkalzus VVSNVER1 Not used
skalid SKALID Calendar
szbmeth SZBMETH Int.calc.method
jsofverr JSOFVERR Immed.settlemnt
dallgem DALLGEM General Date
szegen SZEGEN Incoming Payt
sbust VVSBUST Posting Control
skopo VVSKOPO Note
saltkond VVSALTKOND AltCond
szinsanp VVSZINSANP Int.rt adj.
sincl VVSINCL Inclusive Ind.
sformref VVSFORMREF Formula
svarname VVSVARNAME Variable
svwerk VVSVWERK Calendar Rule
svmeth VVSVMETH Val.Date Method
sfwerk VVSFWERK Calendar Rule
sfmeth VVSFMETH Due Date Method
dpkond VVDPKOND Perc Fixing Dte
azgstage AZGSTAGE Wrk.dys int.fxg
szkalri SZKALRI Direct.int.determ.
dzsref VVDZSREF Ref.int.date
skalid2 VVSKALID2 Calendar ID 2
skalid3 VVSKALID3 Calendar ID 3
skalid4 VVSKALID4 Calendar ID 4
skalid5 VVSKALID5 Calendar ID 5
jgesucht VVJGESUCHT Intern. indic.
kurs1 KURSF Exchange rate
bbasis BBASIS Base Amount
szwerk VVSZWERK Workday
sfincl VVSFINCL Incl. Due Date
srundvorf VVSRUNDVF RoundPre-pmt
szwkey VVSZWKEY Exact pmnt form
sfvmeth TB_SFVMETH Update Method
sdwerk TB_SDWERK WorkingDayShift
sberech SBERECH Grace int.meth
jprozr TB_JPROZR Percent. Calc.
szeitant VVSZEITANT Pro Rata Temp.
sfant VVSFANT Due Date-Rel.
sfranz TFMSFRANZ Shift due date
kbkond VVKBKOND2 Cond.amnt indep.curr
sbasfix TFMSBASFIX Base fixing
mansp MANSP Dunn. Block
zahls DZLSPR Pmnt block
bkondqm BKONDQM Amount/area unit
jarea VVJAREA Area basis
sflart SFLART Area type
txjcd TXJCD Tax Jur.
avgstagevz AVGSTAGEVZ +/- work.days val.dt
afgstagevz AFGSTAGEVZ +/- Work.Days Due Dt
lifnr LIFNR Supplier
jexpozins TFM_SINTCOMP Exponential
kostl RECNKOSTL Int.cost center
gfzlsch RECNGFZLSCH Pmt Meth.Cred.Memo
zlspr DZLSPR Pmnt block
sround TFM_SROUND Rounding Cat.
skalidwt TFMSKALIDWT Int. Calendar
bmwst BMWST Value-added tax
xcross RECNXCROSS Gross
ppayment TFM_PPAYMENT Payment Rate
ammrhyzv TFM_AMMRHYZV Int.Sttlm.Freq
pkond2 PKOND2 Percentage Rate
factor_type TB_FACTYPE Factor Type
sroundfactor TFM_SROUNDFACTOR Factor RC
rounddecfactor TFM_ROUNDDECFACTOR Dec. Fac. Round
jexpointfactor TFM_JEXPOINTFACTOR Expo Int Factor
sroundbasefactor TFM_SROUNDBASEFACTOR Base Factor RC
rounddecbasefactor TFM_ROUNDDECBASEFACTOR Dec. BF Round.
sroundratefactor TFM_SROUNDRATEFACTOR Int. Factor RC
rounddecratefactor TFM_ROUNDDECRATEFACTOR Dec. Int. Fac.
javgcap TFM_JAVGCAP Upper Limit
pavgcap TFM_PAVGCAP Upper Limit
javgfloor TFM_JAVGFLOOR Lower Limit
pavgfloor TFM_PAVGFLOOR Lower Limit
pavgspread TFM_PAVGSPREAD Spread
sroundavginterest TFM_SROUNDAVGINTEREST RC of AIR
rounddecavginterest TFM_ROUNDDECAVGINTEREST AIR Round. Dec.
savgweight TFM_SWEIGHT Weighting Cat.
sfactorreset TFM_SFACTORRESET Reset
adgstage ADGSTAGE No.Working Days
face_factor_current TFM_FACE_FACTOR_CURRENT Current Face
spayment_method TFM_PAYMENT_METHOD Pay. Calc. Meth.
srounddayfraction TFM_SROUNDDAYFRACTION DayFrac.Round
rounddecdayfraction TFM_ROUNDDECDAYFRACTION Dec. DayFr. Rnd
priceindex_skoartref SKOART Condition Type
index_adj_date_relation TFM_INDEX_RELDATE ReferRelatDate
index_adj_date_dateshift TFM_WORKDAY_SHIFT WorkingDayShift
index_adj_date_shiftdays TB_AVGSTAG Wrk.dys val.dte
index_fix_date_low TFM_INDEX_FIXDATELOW IdxFixDateLow
index_fix_date_high TFM_INDEX_FIXDATEHIGH IdxFixDateHigh
index_fix_date_dateshift TFM_WORKDAY_SHIFT WorkingDayShift
index_fix_date_shiftdays TB_AVGSTAG Wrk.dys val.dte
market_reference TFM_MARKETREF Market Refer.
index_base_date TFM_INDEX_BASEDATE IndexBaseDate
index_base_value TFM_INDEX_BASEVALUE IndexBaseVal
index_interpolate TFM_INDEX_INTERPOLATE IdxInterpolate
priceindex_apply TFM_PRICEINDEX_APPLY PriceIdxApply
priceindex_0100_clear TFM_PRICEINDEX_0100CLEAR ClrPIdxAdjusted
priceindex_compound_frequency TFM_PRICEINDEX_COMPOUNDFREQ CompoundFreq
pkond1stper TFM_PKOND1STPER First Int Rate
update_rule_entry_type VVUPDATE_RULE_ENTRY_TYPE Update Rule
mndid SEPA_MNDID Mandate Ref.
rbo RBO Bus.operat. no.
stech_cond TB_STECH_COND Technical Condition
sexclguel TFMSEXCLKP CondPoStart_Excl.
sultguel TFMSULT_KP CondPoValFrom_MthEnd
a_amtmin TB_FICO_AAMTMIN Min. Cap. Amt
a_amtmax TB_FICO_AAMTMAX Max. Cap. Amt
sschmeth TB_SSCHMETH Calc.Meth.Auto Debit
baudamnt TB_BAUDAMNT Amount
a_payday TB_MODEL_PAYDAY DayInstlPymt
rco TB_MODEL_RCO Bus. Oper. No.
broundunit TB_BROUNDUNIT_A Rounding Unit
bbasisunit TFM_BBASISUNIT Base Unit
gpdays TB_GPDAYS_CMLCHN Tolerance Days
ind_ioagp TB_IOAGP_CMLCHN IOA/GP Ind.
disbrate TB_DISBRATE_CMLCHN Disb. Rate

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 items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VZZKOPO (
    MANDT,                          -- Client [MANDT]
    BUKRS,                          -- Company Code [BUKRS]
    SANLF,                          -- Prod. Category [SANLF]
    RKEY1,                          -- Key 1 [RKEY1]
    RKEY2,                          -- Key 2 [RKEY2]
    RKEY3,                          -- Key 3 [RKEY3]
    DGUEL_KK,                       -- Cond. Eff. from [DGUEL]
    NLFD_ANG,                       -- Off.consec.no. [NLFD_ANG]
    SKOART,                         -- Condition Type [SKOART]
    DGUEL_KP,                       -- Item Eff. From [DGUEL_KP]
    NSTUFE,                         -- Level Number [NSTUFE]
    SSTATI,                         -- Status [SSTATI]
    PKOND,                          -- Percentage Rate [PKOND]
    BKOND,                          -- Condition Amnt [BKOND]
    SWHRKOND,                       -- Currency [SWHRKOND]
    SBASIS,                         -- Base reference [VVSBASIS]
    SZSREF,                         -- Ref. Int. Rate [SZSREF]
    SZSREFVZ,                       -- +/- Sign [SZSREFVZ]
    PFLUCT,                         -- Fluct. Margin [TFM_PFLUCT]
    AMMRHY,                         -- Freq. in months [AMMRHY]
    ATTRHY,                         -- Freq.in days [ATTRHY]
    SZAWS,                          -- Pmnt Form [SZAWS]
    RDIVNR,                         -- Divid.coup. no. [RDIVNR]
    JNULLKON,                       -- Condition Form [JNULLKON]
    MWSKZ,                          -- Tax Code [MWSKZ]
    JBMONAT,                        -- Amount/Month [JBMONAT]
    DVALUT,                         -- Calculat. date [DVALUT]
    DFAELL,                         -- Due Date [DFAELL]
    KUNNR,                          -- Customer [KUNNR]
    ZLSCH,                          -- Pymt Meth. [DZLSCH]
    BVTYP,                          -- Part.bank type [BVTYP]
    MABER,                          -- Dunning Area [MABER]
    SPARTNR,                        -- BusPartner [BP_PARTNR_NEW]
    RKONT,                          -- Quota [RKONT]
    SVULT,                          -- Month-End Calc. [VVSBULT]
    SFULT,                          -- Month-End DueDt [SFULT]
    SVKALRI,                        -- Not used [VVSNVER1]
    SFKALRI,                        -- Flexible [VVSFKALRI]
    AVGSTAGE,                       -- Wrk.dys val.dte [AVGSTAGE]
    AFGSTAGE,                       -- Wrk.daysDueDate [AFGSTAGE]
    SVKALZUS,                       -- Not used [VVSNVER1]
    SFKALZUS,                       -- Not used [VVSNVER1]
    SKALID,                         -- Calendar [SKALID]
    SZBMETH,                        -- Int.calc.method [SZBMETH]
    JSOFVERR,                       -- Immed.settlemnt [JSOFVERR]
    DALLGEM,                        -- General Date [DALLGEM]
    SZEGEN,                         -- Incoming Payt [SZEGEN]
    SBUST,                          -- Posting Control [VVSBUST]
    SKOPO,                          -- Note [VVSKOPO]
    SALTKOND,                       -- AltCond [VVSALTKOND]
    SZINSANP,                       -- Int.rt adj. [VVSZINSANP]
    SINCL,                          -- Inclusive Ind. [VVSINCL]
    SFORMREF,                       -- Formula [VVSFORMREF]
    SVARNAME,                       -- Variable [VVSVARNAME]
    SVWERK,                         -- Calendar Rule [VVSVWERK]
    SVMETH,                         -- Val.Date Method [VVSVMETH]
    SFWERK,                         -- Calendar Rule [VVSFWERK]
    SFMETH,                         -- Due Date Method [VVSFMETH]
    DPKOND,                         -- Perc Fixing Dte [VVDPKOND]
    AZGSTAGE,                       -- Wrk.dys int.fxg [AZGSTAGE]
    SZKALRI,                        -- Direct.int.determ. [SZKALRI]
    DZSREF,                         -- Ref.int.date [VVDZSREF]
    SKALID2,                        -- Calendar ID 2 [VVSKALID2]
    SKALID3,                        -- Calendar ID 3 [VVSKALID3]
    SKALID4,                        -- Calendar ID 4 [VVSKALID4]
    SKALID5,                        -- Calendar ID 5 [VVSKALID5]
    JGESUCHT,                       -- Intern. indic. [VVJGESUCHT]
    KURS1,                          -- Exchange rate [KURSF]
    BBASIS,                         -- Base Amount [BBASIS]
    SZWERK,                         -- Workday [VVSZWERK]
    SFINCL,                         -- Incl. Due Date [VVSFINCL]
    SRUNDVORF,                      -- RoundPre-pmt [VVSRUNDVF]
    SZWKEY,                         -- Exact pmnt form [VVSZWKEY]
    SFVMETH,                        -- Update Method [TB_SFVMETH]
    SDWERK,                         -- WorkingDayShift [TB_SDWERK]
    SBERECH,                        -- Grace int.meth [SBERECH]
    JPROZR,                         -- Percent. Calc. [TB_JPROZR]
    SZEITANT,                       -- Pro Rata Temp. [VVSZEITANT]
    SFANT,                          -- Due Date-Rel. [VVSFANT]
    SFRANZ,                         -- Shift due date [TFMSFRANZ]
    KBKOND,                         -- Cond.amnt indep.curr [VVKBKOND2]
    SBASFIX,                        -- Base fixing [TFMSBASFIX]
    MANSP,                          -- Dunn. Block [MANSP]
    ZAHLS,                          -- Pmnt block [DZLSPR]
    BKONDQM,                        -- Amount/area unit [BKONDQM]
    JAREA,                          -- Area basis [VVJAREA]
    SFLART,                         -- Area type [SFLART]
    TXJCD,                          -- Tax Jur. [TXJCD]
    AVGSTAGEVZ,                     -- +/- work.days val.dt [AVGSTAGEVZ]
    AFGSTAGEVZ,                     -- +/- Work.Days Due Dt [AFGSTAGEVZ]
    LIFNR,                          -- Supplier [LIFNR]
    JEXPOZINS,                      -- Exponential [TFM_SINTCOMP]
    KOSTL,                          -- Int.cost center [RECNKOSTL]
    GFZLSCH,                        -- Pmt Meth.Cred.Memo [RECNGFZLSCH]
    ZLSPR,                          -- Pmnt block [DZLSPR]
    SROUND,                         -- Rounding Cat. [TFM_SROUND]
    SKALIDWT,                       -- Int. Calendar [TFMSKALIDWT]
    BMWST,                          -- Value-added tax [BMWST]
    XCROSS,                         -- Gross [RECNXCROSS]
    PPAYMENT,                       -- Payment Rate [TFM_PPAYMENT]
    AMMRHYZV,                       -- Int.Sttlm.Freq [TFM_AMMRHYZV]
    PKOND2,                         -- Percentage Rate [PKOND2]
    FACTOR_TYPE,                    -- Factor Type [TB_FACTYPE]
    SROUNDFACTOR,                   -- Factor RC [TFM_SROUNDFACTOR]
    ROUNDDECFACTOR,                 -- Dec. Fac. Round [TFM_ROUNDDECFACTOR]
    JEXPOINTFACTOR,                 -- Expo Int Factor [TFM_JEXPOINTFACTOR]
    SROUNDBASEFACTOR,               -- Base Factor RC [TFM_SROUNDBASEFACTOR]
    ROUNDDECBASEFACTOR,             -- Dec. BF Round. [TFM_ROUNDDECBASEFACTOR]
    SROUNDRATEFACTOR,               -- Int. Factor RC [TFM_SROUNDRATEFACTOR]
    ROUNDDECRATEFACTOR,             -- Dec. Int. Fac. [TFM_ROUNDDECRATEFACTOR]
    JAVGCAP,                        -- Upper Limit [TFM_JAVGCAP]
    PAVGCAP,                        -- Upper Limit [TFM_PAVGCAP]
    JAVGFLOOR,                      -- Lower Limit [TFM_JAVGFLOOR]
    PAVGFLOOR,                      -- Lower Limit [TFM_PAVGFLOOR]
    PAVGSPREAD,                     -- Spread [TFM_PAVGSPREAD]
    SROUNDAVGINTEREST,              -- RC of AIR [TFM_SROUNDAVGINTEREST]
    ROUNDDECAVGINTEREST,            -- AIR Round. Dec. [TFM_ROUNDDECAVGINTEREST]
    SAVGWEIGHT,                     -- Weighting Cat. [TFM_SWEIGHT]
    SFACTORRESET,                   -- Reset [TFM_SFACTORRESET]
    ADGSTAGE,                       -- No.Working Days [ADGSTAGE]
    FACE_FACTOR_CURRENT,            -- Current Face [TFM_FACE_FACTOR_CURRENT]
    SPAYMENT_METHOD,                -- Pay. Calc. Meth. [TFM_PAYMENT_METHOD]
    SROUNDDAYFRACTION,              -- DayFrac.Round [TFM_SROUNDDAYFRACTION]
    ROUNDDECDAYFRACTION,            -- Dec. DayFr. Rnd [TFM_ROUNDDECDAYFRACTION]
    PRICEINDEX_SKOARTREF,           -- Condition Type [SKOART]
    INDEX_ADJ_DATE_RELATION,        -- ReferRelatDate [TFM_INDEX_RELDATE]
    INDEX_ADJ_DATE_DATESHIFT,       -- WorkingDayShift [TFM_WORKDAY_SHIFT]
    INDEX_ADJ_DATE_SHIFTDAYS,       -- Wrk.dys val.dte [TB_AVGSTAG]
    INDEX_FIX_DATE_LOW,             -- IdxFixDateLow [TFM_INDEX_FIXDATELOW]
    INDEX_FIX_DATE_HIGH,            -- IdxFixDateHigh [TFM_INDEX_FIXDATEHIGH]
    INDEX_FIX_DATE_DATESHIFT,       -- WorkingDayShift [TFM_WORKDAY_SHIFT]
    INDEX_FIX_DATE_SHIFTDAYS,       -- Wrk.dys val.dte [TB_AVGSTAG]
    MARKET_REFERENCE,               -- Market Refer. [TFM_MARKETREF]
    INDEX_BASE_DATE,                -- IndexBaseDate [TFM_INDEX_BASEDATE]
    INDEX_BASE_VALUE,               -- IndexBaseVal [TFM_INDEX_BASEVALUE]
    INDEX_INTERPOLATE,              -- IdxInterpolate [TFM_INDEX_INTERPOLATE]
    PRICEINDEX_APPLY,               -- PriceIdxApply [TFM_PRICEINDEX_APPLY]
    PRICEINDEX_0100_CLEAR,          -- ClrPIdxAdjusted [TFM_PRICEINDEX_0100CLEAR]
    PRICEINDEX_COMPOUND_FREQUENCY,  -- CompoundFreq [TFM_PRICEINDEX_COMPOUNDFREQ]
    PKOND1STPER,                    -- First Int Rate [TFM_PKOND1STPER]
    UPDATE_RULE_ENTRY_TYPE,         -- Update Rule [VVUPDATE_RULE_ENTRY_TYPE]
    MNDID,                          -- Mandate Ref. [SEPA_MNDID]
    RBO,                            -- Bus.operat. no. [RBO]
    STECH_COND,                     -- Technical Condition [TB_STECH_COND]
    SEXCLGUEL,                      -- CondPoStart_Excl. [TFMSEXCLKP]
    SULTGUEL,                       -- CondPoValFrom_MthEnd [TFMSULT_KP]
    A_AMTMIN,                       -- Min. Cap. Amt [TB_FICO_AAMTMIN]
    A_AMTMAX,                       -- Max. Cap. Amt [TB_FICO_AAMTMAX]
    SSCHMETH,                       -- Calc.Meth.Auto Debit [TB_SSCHMETH]
    BAUDAMNT,                       -- Amount [TB_BAUDAMNT]
    A_PAYDAY,                       -- DayInstlPymt [TB_MODEL_PAYDAY]
    RCO,                            -- Bus. Oper. No. [TB_MODEL_RCO]
    BROUNDUNIT,                     -- Rounding Unit [TB_BROUNDUNIT_A]
    BBASISUNIT,                     -- Base Unit [TFM_BBASISUNIT]
    GPDAYS,                         -- Tolerance Days [TB_GPDAYS_CMLCHN]
    IND_IOAGP,                      -- IOA/GP Ind. [TB_IOAGP_CMLCHN]
    DISBRATE,                       -- Disb. Rate [TB_DISBRATE_CMLCHN]
    PRIMARY KEY (MANDT, BUKRS, SANLF, RKEY1, RKEY2, RKEY3, DGUEL_KK, NLFD_ANG, SKOART, DGUEL_KP, NSTUFE)
);

Learn More