SAP ABAP Table TXI_VZZKOPO (Table conditionn items)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   CA-GTF-DRT (Application Component) Data Retention Tool
     FA_ILM (Package) Information Lifecycle Management
Basic Data
Table Category INTTAB    Structure 
Structure TXI_VZZKOPO   Table Relationship Diagram
Short Description Table conditionn items    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   Table condition items  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
4 SANLF SANLF VVSANLF NUMC 3   0   Product Category *
5 RKEY1 RKEY1 RKEY1 CHAR 13   0   Key part 1  
6 RKEY2 RKEY2 RKEY2 CHAR 8   0   Key part 2  
7 RKEY3 RKEY3 RKEY3 CHAR 8   0   Key part 3  
8 DGUEL_KK DGUEL DATUM DATS 8   0   Date Condition Effective from  
9 NLFD_ANG NLFD_ANG LFNR3 NUMC 3   0   Offer consecutive number  
10 SKOART SKOART SKOART NUMC 4   0   Condition Type (Smallest Subdivision of Condition Records) TZK01
11 DGUEL_KP DGUEL_KP DATUM DATS 8   0   Condition Item Valid From  
12 NSTUFE NSTUFE NUMC2 NUMC 2   0   Level number of condition item for recurring payments  
13 SSTATI SSTATI STATI NUMC 2   0   Status of data record *
14 PKOND PKOND DECV3_7 DEC 10   7   Percentage rate for condition items  
15 BKOND BKOND WERTV7 CURR 13   2   Condition item currency amount  
16 SWHRKOND SWHRKOND WAERS CUKY 5   0   Currency of Condition Item TCURC
17 SBASIS VVSBASIS VVSBASIS CHAR 4   0   Calculation base reference TZFB
18 SZSREF SZSREF ZIREFKU CHAR 10   0   Reference Interest Rate T056R
19 SZSREFVZ SZSREFVZ SZSREFVZ CHAR 1   0   +/- sign / reference interest rate operator  
20 PFLUCT TFM_PFLUCT DECV3_7 DEC 10   7   Fluctuation margin  
21 AMMRHY AMMRHY NUMC03 NUMC 3   0   Frequency in months  
22 ATTRHY ATTRHY NUMC03 NUMC 3   0   Frequency in Days  
23 SZAWS SZAWS SZAHLDIV NUMC 1   0   Payment form (at start of period, mid-period, at period end)  
24 RDIVNR RDIVNR NUM03 NUMC 3   0   Dividend coupon number  
25 JNULLKON JNULLKON SKONDF CHAR 1   0   Condition Form  
26 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
27 JBMONAT JBMONAT JANEI CHAR 1   0   Indicator for calculating amount per month  
28 DVALUT DVALUT DATUM DATS 8   0   Calculation Date  
29 DFAELL DFAELL DATUM DATS 8   0   Due date  
30 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
31 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
32 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
33 MABER MABER MABER CHAR 2   0   Dunning Area T047M
34 SPARTNR BP_PARTNR_NEW BU_PARTNER CHAR 10   0   Business Partner Number BUT000
35 RKONT RKONT RKONT NUMC 6   0   Quota number  
36 SVULT VVSBULT JFLAGG CHAR 1   0   Month-end indicator for calculation date  
37 SFULT SFULT VVSULT CHAR 1   0   Month-End Indicator for Due Date  
38 SVKALRI VVSNVER1 CHAR1 CHAR 1   0   Field is no longer used  
39 SFKALRI VVSFKALRI XFELD CHAR 1   0   Calculation of periods with flexible valid-to date?  
40 AVGSTAGE AVGSTAGE NUMC2 NUMC 2   0   Number of working days for value date  
41 AFGSTAGE AFGSTAGE NUMC2 NUMC 2   0   Number of working days to due date  
42 SVKALZUS VVSNVER1 CHAR1 CHAR 1   0   Field is no longer used  
43 SFKALZUS VVSNVER1 CHAR1 CHAR 1   0   Field is no longer used  
44 SKALID SKALID WFCID CHAR 2   0   Factory calendar TFACD
45 SZBMETH SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
46 JSOFVERR JSOFVERR TFMSOFVERR CHAR 1   0   Immediate settlement  
47 DALLGEM DALLGEM DATUM DATS 8   0   General date  
48 SZEGEN SZEGEN SZEGEN NUMC 2   0   Generate incoming payment immediately TD21
49 SBUST VVSBUST VVSBUST NUMC 2   0   Posting control key TZB09
50 SKOPO VVSKOPO VVSKOPO NUMC 2   0   Detailed identification for condition items TZK07
51 SALTKOND VVSALTKOND SKONDGRP NUMC 4   0   Bracket condition for alternative conditions  
52 SZINSANP VVSZINSANP SKONDGRP NUMC 4   0   Cross-referenced condition grp for interest rate adjustment  
53 SINCL VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
54 SFORMREF VVSFORMREF T_FORMBE CHAR 4   0   Formula reference for the cash flow calculator AT30
55 SVARNAME VVSVARNAME T_XFELD04 CHAR 4   0   Description of variables in cash flow calculator  
56 SVWERK VVSVWERK T_SWERK NUMC 1   0   Shift calculation date to working day  
57 SVMETH VVSVMETH T_SVMETH NUMC 1   0   Method for determining the next value date  
58 SFWERK VVSFWERK T_SWERK NUMC 1   0   Shift due date to working day  
59 SFMETH VVSFMETH T_SFMETH NUMC 1   0   Method for determining the next due date  
60 DPKOND VVDPKOND DATUM DATS 8   0   Determination date for percentage rate of condition items  
61 AZGSTAGE AZGSTAGE NUMC2 NUMC 2   0   Number of working days for interest fixing  
62 SZKALRI SZKALRI SKALRI CHAR 1   0   Calendar direction for interest rate fixing  
63 DZSREF VVDZSREF DATUM DATS 8   0   Date fixing for benchmark interest rate in cash flow  
64 SKALID2 VVSKALID2 WFCID CHAR 2   0   Calendar ID 2 (valid in connection with calendar ID 1) TFACD
65 JGESUCHT VVJGESUCHT CHAR1 CHAR 1   0   Int. indicator for alternative calculations  
66 KURS1 KURSF KURSF DEC 9   5   Exchange rate  
67 BBASIS BBASIS WERTV7 CURR 13   2   Calculation base amount  
68 SZWERK VVSZWERK T_SWERK NUMC 1   0   Shift to working day for interest fixing date  
69 SFINCL VVSFINCL VVSINCL NUMC 1   0   Inclusive Indicator for Due Date  
70 SRUNDVORF VVSRUNDVF TFMSRUNDVF NUMC 1   0   Rounding of interim results for prepayments  
71 SZWKEY VVSZWKEY VVSZWKEY CHAR 2   0   Payment form with adjustment days TDZW
72 SFVMETH TB_SFVMETH T_SFVMETH NUMC 2   0   Update method for calculation date/due date  
73 SDWERK TB_SDWERK T_SWERK NUMC 1   0   Working Day Shift for Payment Date  
74 SBERECH SBERECH XFELD CHAR 1   0   Grace Period Interest Method  
75 JPROZR TB_JPROZR XFELD CHAR 1   0   Percentage Calculation  
76 SZEITANT VVSZEITANT VVSZEITANT NUMC 1   0   Indicator for Pro Rata Temporis Calculations  
77 SFANT VVSFANT VVSFANT NUMC 1   0   Indicator for due date-related FiMa calculations  
78 SFRANZ TFMSFRANZ TFMSFRANZ NUMC 1   0   Shift Due Date  
79 KBKOND VVKBKOND VVKWKURS DEC 15   6   Condition amount independent of currency  
80 SBASFIX TFMSBASFIX TFMSBASFIX NUMC 1   0   Indicator for fixing calculation base  
81 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
82 ZAHLS DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
83 BKONDQM BKONDQM WRTV7 CURR 13   2   Currency amount per area unit  
84 JAREA VVJAREA XFELD CHAR 1   0   Rental on basis of area?  
85 SFLART SFLART SFLART NUMC 4   0   Area type TIV08
86 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
87 AVGSTAGEVZ AVGSTAGEVZ PLUSM CHAR 1   0   +/- sign for number of working days for value date  
88 AFGSTAGEVZ AFGSTAGEVZ PLUSM CHAR 1   0   +/- sign for number of working days for due date  
89 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
90 JEXPOZINS TB_JZINSRE XFELD CHAR 1   0   Exponential Interest Calculation  
91 KOSTL RECNKOSTL KOSTL CHAR 10   0   Cost center of internal contract *
92 GFZLSCH RECNGFZLSCH ZLSCH CHAR 1   0   Payment method for credit memos *
93 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
94 SROUND TFM_SROUND TFM_SROUND CHAR 1   0   Rounding Category  
95 SKALIDWT TFMSKALIDWT WFCID CHAR 2   0   Interest Calendar *
96 BMWST BMWST WRTV7 CURR 13   2   Value-added tax amount included  
97 XCROSS RECNXCROSS XFELD CHAR 1   0   Gross amount indicator  
98 PPAYMENT TFM_PPAYMENT TFM_PPAYMENT DEC 11   7   Payment Rate  
99 AMMRHYZV TFM_AMMRHYZV TFM_AMMRHYZV NUMC 2   0   Interest Settlement Frequency for Exponential Interest Calc.  
100 PKOND2 PKOND2 DECV5_10 DEC 15   10   Percentage Rate for Condition Items  
101 .INCLU--AP       0   0   APPEND FOR MANDATE FIELD  
102 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
103 .INCLU--AP       0   0   Append VZZKOPO for Loans  
104 RBO RBO RBO CHAR 15   0   Business Operation Number (Loans)  
105 STECH_COND TB_STECH_COND   CHAR 1   0   Indicator for Technical Program Condition  
106 SEXCLGUEL TFMSEXCLKP VVSEXCLVON NUMC 1   0   Exclusive indicator for start date of condition position  
107 SULTGUEL TFMSULT_KP VVSULT CHAR 1   0   Month-end indicator for start date of condition position  
108 A_AMTMIN TB_FICO_AAMTMIN T_CML_AMOUNT_STANDARD CURR 13   2   Minimum Amount  
109 A_AMTMAX TB_FICO_AAMTMAX T_CML_AMOUNT_STANDARD CURR 13   2   Maximum Amount  
110 SSCHMETH TB_SSCHMETH T_SSCHMETH CHAR 1   0   Calculation Method for Auto Debit Amount  
111 BAUDAMNT TB_BAUDAMNT WERTV7 CURR 13   2   Amount  
112 .INCLU--AP       0   0   APPEND for Consumer Loan  
113 A_PAYDAY TB_MODEL_PAYDAY T_VIEW_DAY_OF_PAYMENT NUMC 2   0   Model Calculation: Day of Installment Payment (1-31)  
114 RCO TB_MODEL_RCO RBO CHAR 15   0   Bus. Operation No. (Installment Plan Change: Consumer Loan)  
115 .INCLU--AP       0   0   Append for Localization  
116 BROUNDUNIT TB_BROUNDUNIT_A TFMSRUNIT DEC 13   7   Rounding Unit for Amounts  
117 BBASISUNIT TFM_BBASISUNIT TFM_WRTV9 CURR 17   2   Base Unit for Rounding  
118 BKOND_CY SYCUKY SYCUKY CUKY 5   0   CUKY for SYST  
119 BBASIS_CY SYCUKY SYCUKY CUKY 5   0   CUKY for SYST  
120 BKONDQM_CY SYCUKY SYCUKY CUKY 5   0   CUKY for SYST  
121 BMWST_CY SYCUKY SYCUKY CUKY 5   0   CUKY for SYST  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 TXI_VZZKOPO BUKRS T001 BUKRS KEY 1 1
2 TXI_VZZKOPO KUNNR KNA1 KUNNR KEY 1 CN
3 TXI_VZZKOPO LIFNR LFA1 LIFNR KEY 1 CN
4 TXI_VZZKOPO MABER T047M MABER KEY 1 CN
5 TXI_VZZKOPO MANDT T000 MANDT KEY 1 1
6 TXI_VZZKOPO MANSP T040S MANSP    
7 TXI_VZZKOPO MWSKZ T007A MWSKZ KEY 1 CN
8 TXI_VZZKOPO SBASIS TZFB SBASIS KEY 1 CN
9 TXI_VZZKOPO SBUST TZB09 SBUST KEY 1 CN
10 TXI_VZZKOPO SFLART TIV08 SFLART 1 CN
11 TXI_VZZKOPO SFORMREF AT30 RFORMBEZ KEY 1 CN
12 TXI_VZZKOPO SKALID TFACD IDENT KEY 1 CN
13 TXI_VZZKOPO SKALID2 TFACD IDENT KEY 1 CN
14 TXI_VZZKOPO SKOART TZK01 SKOART KEY 1 CN
15 TXI_VZZKOPO SKOPO TZK07 SKOPO KEY 1 CN
16 TXI_VZZKOPO SPARTNR BUT000 PARTNER KEY 1 CN
17 TXI_VZZKOPO SWHRKOND TCURC WAERS REF 1 1
18 TXI_VZZKOPO SZEGEN TD21 SZEGEN KEY 1 CN
19 TXI_VZZKOPO SZSREF T056R REFERENZ KEY 1 CN
20 TXI_VZZKOPO SZWKEY TDZW SZWKEY KEY 1 CN
21 TXI_VZZKOPO ZAHLS T008 ZAHLS    
22 TXI_VZZKOPO ZLSCH T042Z ZLSCH KEY 1 CN
23 TXI_VZZKOPO ZLSPR T008 ZAHLS KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in