SAP ABAP Table JBTLOKOND (Loans (Condition Items))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ JBA (Package) Application developmnet IS-B General Development
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ JBA (Package) Application developmnet IS-B General Development
Basic Data
Table Category | INTTAB | Structure |
Structure | JBTLOKOND | Table Relationship Diagram |
Short Description | Loans (Condition 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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
3 | SANLF | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | * | |
4 | RKEY1 | RKEY1 | RKEY1 | CHAR | 13 | 0 | Key part 1 | ||
5 | RKEY2 | RKEY2 | RKEY2 | CHAR | 8 | 0 | Key part 2 | ||
6 | RKEY3 | RKEY3 | RKEY3 | CHAR | 8 | 0 | Key part 3 | ||
7 | DGUEL_KK | DGUEL | DATUM | DATS | 8 | 0 | Date Condition Effective from | ||
8 | NLFD_ANG | NLFD_ANG | LFNR3 | NUMC | 3 | 0 | Offer consecutive number | ||
9 | SKOART | SKOART | SKOART | NUMC | 4 | 0 | Condition Type (Smallest Subdivision of Condition Records) | * | |
10 | DGUEL_KP | DGUEL_KP | DATUM | DATS | 8 | 0 | Condition Item Valid From | ||
11 | NSTUFE | NSTUFE | NUMC2 | NUMC | 2 | 0 | Level number of condition item for recurring payments | ||
12 | XKOARTM | XKOARTM | XBEZ20 | CHAR | 20 | 0 | Condition type text | ||
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 | * | |
17 | SBASIS | VVSBASIS | VVSBASIS | CHAR | 4 | 0 | Calculation base reference | * | |
18 | SZSREF | SZSREF | ZIREFKU | CHAR | 10 | 0 | Reference Interest Rate | * | |
19 | SZSREFVZ | SZSREFVZ | SZSREFVZ | CHAR | 1 | 0 | +/- sign / reference interest rate operator | ||
20 | AMMRHY | AMMRHY | NUMC03 | NUMC | 3 | 0 | Frequency in months | ||
21 | ATTRHY | ATTRHY | NUMC03 | NUMC | 3 | 0 | Frequency in Days | ||
22 | SZAWS | SZAWS | SZAHLDIV | NUMC | 1 | 0 | Payment form (at start of period, mid-period, at period end) | ||
23 | RDIVNR | RDIVNR | NUM03 | NUMC | 3 | 0 | Dividend coupon number | ||
24 | JNULLKON | JNULLKON | SKONDF | CHAR | 1 | 0 | Condition Form | ||
25 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
26 | JBMONAT | JBMONAT | JANEI | CHAR | 1 | 0 | Indicator for calculating amount per month | ||
27 | DVALUT | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
28 | DFAELL | DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
29 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
30 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
31 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
32 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | * | |
33 | SPARTNR | BP_PARTNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
34 | RKONT | RKONT | RKONT | NUMC | 6 | 0 | Quota number | ||
35 | SVULT | VVSBULT | JFLAGG | CHAR | 1 | 0 | Month-end indicator for calculation date | ||
36 | SFULT | SFULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Due Date | ||
37 | SVKALRI | VVSNVER1 | CHAR1 | CHAR | 1 | 0 | Field is no longer used | ||
38 | SFKALRI | VVSNVER1 | CHAR1 | CHAR | 1 | 0 | Field is no longer used | ||
39 | AVGSTAGE | AVGSTAGE | NUMC2 | NUMC | 2 | 0 | Number of working days for value date | ||
40 | AFGSTAGE | AFGSTAGE | NUMC2 | NUMC | 2 | 0 | Number of working days to due date | ||
41 | SVKALZUS | VVSNVER1 | CHAR1 | CHAR | 1 | 0 | Field is no longer used | ||
42 | SFKALZUS | VVSNVER1 | CHAR1 | CHAR | 1 | 0 | Field is no longer used | ||
43 | SKALID | SKALID | WFCID | CHAR | 2 | 0 | Factory calendar | * | |
44 | SZBMETH | SZBMETH | SZBMETH | CHAR | 1 | 0 | Interest Calculation Method | ||
45 | JSOFVERR | JSOFVERR | TFMSOFVERR | CHAR | 1 | 0 | Immediate settlement | ||
46 | DALLGEM | DALLGEM | DATUM | DATS | 8 | 0 | General date | ||
47 | SZEGEN | SZEGEN | SZEGEN | NUMC | 2 | 0 | Generate incoming payment immediately | * | |
48 | SBUST | VVSBUST | VVSBUST | NUMC | 2 | 0 | Posting control key | ||
49 | SKOPO | VVSKOPO | VVSKOPO | NUMC | 2 | 0 | Detailed identification for condition items | * | |
50 | SALTKOND | VVSALTKOND | SKONDGRP | NUMC | 4 | 0 | Bracket condition for alternative conditions | ||
51 | SZINSANP | VVSZINSANP | SKONDGRP | NUMC | 4 | 0 | Cross-referenced condition grp for interest rate adjustment | ||
52 | SINCL | VVSINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for beginning and end of a period | ||
53 | SFORMREF | VVSFORMREF | T_FORMBE | CHAR | 4 | 0 | Formula reference for the cash flow calculator | * | |
54 | SVARNAME | VVSVARNAME | T_XFELD04 | CHAR | 4 | 0 | Description of variables in cash flow calculator | ||
55 | SVWERK | VVSVWERK | T_SWERK | NUMC | 1 | 0 | Shift calculation date to working day | ||
56 | SVMETH | VVSVMETH | T_SVMETH | NUMC | 1 | 0 | Method for determining the next value date | ||
57 | SFWERK | VVSFWERK | T_SWERK | NUMC | 1 | 0 | Shift due date to working day | ||
58 | SFMETH | VVSFMETH | T_SFMETH | NUMC | 1 | 0 | Method for determining the next due date | ||
59 | DPKOND | VVDPKOND | DATUM | DATS | 8 | 0 | Determination date for percentage rate of condition items | ||
60 | AZGSTAGE | AZGSTAGE | NUMC2 | NUMC | 2 | 0 | Number of working days for interest fixing | ||
61 | SZKALRI | SZKALRI | SKALRI | CHAR | 1 | 0 | Calendar direction for interest rate fixing | ||
62 | DZSREF | VVDZSREF | DATUM | DATS | 8 | 0 | Date fixing for benchmark interest rate in cash flow | ||
63 | SKALID2 | VVSKALID2 | WFCID | CHAR | 2 | 0 | Calendar ID 2 (valid in connection with calendar ID 1) | * | |
64 | JGESUCHT | VVJGESUCHT | CHAR1 | CHAR | 1 | 0 | Int. indicator for alternative calculations | ||
65 | KURS1 | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
66 | BBASIS | BBASIS | WERTV7 | CURR | 13 | 2 | Calculation base amount | ||
67 | SZWERK | VVSZWERK | T_SWERK | NUMC | 1 | 0 | Shift to working day for interest fixing date | ||
68 | SFINCL | VVSFINCL | VVSINCL | NUMC | 1 | 0 | Inclusive Indicator for Due Date | ||
69 | SRUNDVORF | VVSRUNDVF | TFMSRUNDVF | NUMC | 1 | 0 | Rounding of interim results for prepayments | ||
70 | SZWKEY | VVSZWKEY | VVSZWKEY | CHAR | 2 | 0 | Payment form with adjustment days | * | |
71 | SFVMETH | TB_SFVMETH | T_SFVMETH | NUMC | 2 | 0 | Update method for calculation date/due date | ||
72 | SDWERK | TB_SDWERK | T_SWERK | NUMC | 1 | 0 | Working Day Shift for Payment Date | ||
73 | SBERECH | SBERECH | XFELD | CHAR | 1 | 0 | Grace Period Interest Method | ||
74 | JPROZR | TB_JPROZR | XFELD | CHAR | 1 | 0 | Percentage Calculation | ||
75 | SZEITANT | VVSZEITANT | VVSZEITANT | NUMC | 1 | 0 | Indicator for Pro Rata Temporis Calculations | ||
76 | SFANT | VVSFANT | VVSFANT | NUMC | 1 | 0 | Indicator for due date-related FiMa calculations | ||
77 | SFRANZ | TFMSFRANZ | TFMSFRANZ | NUMC | 1 | 0 | Shift Due Date | ||
78 | SKOAREF | VVSKOAREF | SKOART | NUMC | 4 | 0 | Reference cond.type which the current cond.type refers to | * | |
79 | SBEWSOLL | VVSBEWART1 | SBEWART | CHAR | 4 | 0 | Flow Type 1 (Debit/Credit) | * | |
80 | SBEWHABEN | VVSBEWART2 | SBEWART | CHAR | 4 | 0 | Flow Type 2 (Debit/Credit) | * | |
81 | SBEWZITI | SBEWZITI | SBEWZITI | CHAR | 4 | 0 | Flow category | * | |
82 | AUSWAHL | FEAUS | TEXT60 | CHAR | 60 | 0 | Field selection | ||
83 | SBERFIMA | SBEWFIMA | SBEWFIMA | CHAR | 4 | 0 | Calculation category for cash flow calculator | * | |
84 | JMUSS | JMUSS | JANE | CHAR | 1 | 0 | Indicator, condition type mandatory | ||
85 | NFOLGE | NFOLGE | VVNFOLGE | NUMC | 4 | 0 | Display sequence of condition types within the group | ||
86 | NHIER | NHIER | NUMC1 | NUMC | 1 | 0 | Display hierarchy for entry of new conditions | ||
87 | KBKOND | VVKBKOND | VVKWKURS | DEC | 15 | 6 | Condition amount independent of currency | ||
88 | SBASFIX | TFMSBASFIX | TFMSBASFIX | NUMC | 1 | 0 | Indicator for fixing calculation base | ||
89 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | * | |
90 | ZAHLS | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | * | |
91 | SZADRI | SZADRI | XFELD | CHAR | 1 | 0 | Payment to third-party | ||
92 | SZART | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
93 | BKONDQM | BKONDQM | WRTV7 | CURR | 13 | 2 | Currency amount per area unit | ||
94 | SFLART | SFLART | SFLART | NUMC | 4 | 0 | Area type | * | |
95 | JAREA | VVJAREA | XFELD | CHAR | 1 | 0 | Rental on basis of area? | ||
96 | PAY_DATA_C | PAY_DATA_C | XFELD | CHAR | 1 | 0 | Change payment method or bank cat. | ||
97 | AVGSTAGEVZ | AVGSTAGEVZ | PLUSM | CHAR | 1 | 0 | +/- sign for number of working days for value date | ||
98 | AFGSTAGEVZ | AFGSTAGEVZ | PLUSM | CHAR | 1 | 0 | +/- sign for number of working days for due date |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |