Contract Number (Attribute)
Technical name: 0FS_CTR_NO
Technical Data
DataSource Type |
Attributes (master data) |
Application Component |
Consumer & Mortgage Loans, FS CML |
Available as from OLTP Release |
SAP R/3 Enterprise Financial Services 2.0 (EA-FINSERV 2.0) |
Available as from Plug-In Release |
|
RemoteCube-Capable |
No |
Prerequisites
None
Use
The contract number is the object used to map a loan contract. The extractor transfers the time-dependent and time-independent attributes of a loan contract from the OLTP system to the SAP BW system. The extractor module determines the changes made to a loan contract within an analysis time frame.
The default setting for the analysis time frame for a full update and the initialization of the delta procedure is the 01.01.1900 to the current system time. For delta extraction the default analysis time frame is the day before the day of the last extraction up to the current system date.
You can override these settings for the analysis time frame in both cases using the variables in TVARV.
To change the analysis time frame, the variable yyyxxxx in TVARV must be set to ‘X’. You can then use the variable xxxyyyy to set up an analysis time frame.
The loan history is structured using the change documents. This means that only the fields for which change documents have been written can be set as time-dependent. The extractor module determines all changes made to the tables VDARL, VZZKOKO and VZZKOPO within the analysis time frame. The system structures the loan for the analysis time frame retrospectively, based on the changes and the current status of tables VDARL, VZZKOKO and VZZKOPO. The information from VDARL, VZZKOKO and VZZKOPO is stored in a common, flat structure.
Loaded fields: |
|
Key fields: |
Company code |
|
Contract number |
Data fields: |
See extract structure |
Delta Update
A delta update is implemented based on the change documents. During the delta update the system determines the changes made since the last extractor run from the change documents.
Fields of Origin for the Extract Structure
Fields in the Extract Structure |
Description of the Field in the Extract Structure |
Table of Origin |
Field in the Table of Origin |
BUKRS |
Company code |
VDARL |
BUKRS |
RANL |
Contract number |
VDARL |
RANL |
SANLF |
Product category |
VDARL |
SANLF |
GSART |
Product type |
VDARL |
GSART |
RREFKONT |
Account assignment reference in Financial Assets Management |
VDARL |
RREFKONT |
HBKID |
Short key for a house bank |
VDARL |
HBKID |
HKTID |
ID for account details |
VDARL |
HKTID |
STITEL |
Loan type indicator |
VDARL |
STITEL |
SGLZB |
SCB asset group indicator |
VDARL |
SGLZB |
SFIBG |
Indicator asset grouping |
VDARL |
SFIBG |
SBILK |
Balance sheet indicator |
VDARL |
SBILK |
XAKT |
File number |
VDARL |
XAKT |
RANLALT1 |
Alternative identification |
VDARL |
RANLALT1 |
RANLALT2 |
Alternative identification 2 |
VDARL |
RANLALT2 |
SGR1 |
Group key (Freely definable) |
VDARL |
SGR1 |
SGR2 |
Group key (Freely definable) |
VDARL |
SGR2 |
RKLAMMER |
Reference number for finance project |
VDARL |
RKLAMMER |
RANLKET |
Principle loan investment number |
VDARL |
RANLKET |
RANTRAG |
Application number |
VDARL |
RANTRAG |
SSOLIST |
Planned/actual principle |
VDARL |
SSOLIST |
SFRIST |
Loan maturity |
VDARL |
SFRIST |
BANTRAG |
Application capital |
VDARL |
BANTRAG |
SANTWHR |
Currency |
VDARL |
SANTWHR |
DANTRAG |
Entry date of loan application |
VDARL |
DANTRAG |
DZUSAGE |
Loan - Date of commitment by lender |
VDARL |
DZUSAGE |
SSICHER |
Primary collateral |
VDARL |
SSICHER |
SVZWECK |
Purpose of loan |
VDARL |
SVZWECK |
SSONDER |
Special treatment of loan |
VDARL |
SSONDER |
SLAENDER |
Country ID |
VDARL |
SLAENDER |
SNICHTAB |
Indicator for reason of non-acceptance |
VDARL |
SNICHTAB |
JORIG |
Posting system indicator for borrower’s note loans |
VDARL |
JORIG |
SDTYP |
Loan class indicator |
VDARL |
SDTYP |
DBEWI |
Approval date |
VDARL |
DBEWI |
SABT |
Assignee |
VDARL |
SABT |
MABER |
Dunning area |
VDARL |
MABER |
MAHNS |
Dunning level |
VDARL |
MAHNS |
MADAT |
Last dunned on |
VDARL |
MADAT |
SONDST |
Special posting treatment |
VDARL |
SONDST |
SGRP3 |
Group key (Freely definable) |
VDARL |
SGRP3 |
SGRP4 |
Group key (Freely definable) |
VDARL |
SGRP4 |
SZKEY |
Indicator for control of incoming payment distribution |
VDARL |
SZKEY |
SVERFU |
Type of restraint on drawing |
VDARL |
SVERFU |
STITART |
Borrower’s note loan security type |
VDARL |
STITART |
RPORTB |
Portfolio |
VDARL |
RPORTB |
SREGION |
Regional indicator |
VDARL |
SREGION |
SGESST |
Branch office |
VDARL |
SGESST |
SBEA |
Loan processing indicator |
VDARL |
SBEA |
SOBEZ |
Organizational district of agent |
VDARL |
SOBEZ |
SBEZIRK |
Agent district |
VDARL |
SBEZIRK |
SMAHNM |
Loan - manual dunning level |
VDARL |
SMAHNM |
DRUECK |
Date when loan will probably be redeemed |
VDARL |
DRUECK |
SABGRENZ |
Loan - discount accrual/ deferral method |
VDARL |
SABGRENZ |
SFEST |
Indicator for control of fixed contract |
VDARL |
SFEST |
SRATING |
Rating indicator |
VDARL |
SRATING |
SRATAGEN |
Rating agency |
VDARL |
SRATAGEN |
RDARNEHM |
Business partner number |
VDARL |
RDARNEHM |
OBJNR |
Text string 22 characters |
VDARL |
OBJNR |
HDN_KUNNR |
Main borrower customer number |
VDARL |
HDN_KUNNR |
RANLSTAMNR |
Master number part of the loan number for contract search |
VDARL |
RANLSTAMNR |
SDUNNCMP |
Summarization level for dunning letter |
VDARL |
SDUNNCMP |
XNODUNN |
Loan excluded from dunning run |
VDARL |
XNODUNN |
ZUOND |
Assignment |
VDARL |
ZUOND |
REFER |
Internal reference |
VDARL |
REFER |
MERKM |
Characteristics |
VDARL |
MERKM |
SDUNCHARG |
Post dunning charges and interest to this contract |
VDARL |
SDUNCHARG |
SAKTPAS |
Indicator asset/liability transaction |
VDARL |
SAKTPAS |
RPZAHL |
Payer/payee |
VDARL |
RPZAHL |
GSBER |
Business area |
VDARL |
GSBER |
JNOREPAY |
Payoff lock |
VDARL |
JNOREPAY |
JNODOIP |
Lock by payoff . No open item clearing for loan |
VDARL |
JNODOIP |
COM_VAL_CLASS |
General valuation class |
VDARL |
COM_VAL_CLASS |
DGUEL_KK |
Condition effective from date |
VZZKOKO |
DGUEL_KK |
NLFD_ANG |
Seq. no. offer |
VZZKOKO |
NLFD_ANG |
SSTATI |
Status of data record |
VDARL |
SSTATI |
SKOKOART |
Type of condition header |
VZZKOKO |
SKOKOART |
STILGART |
Indicator repayment type |
VZZKOKO |
STILGART |
KZAHLUNG |
Disbursement rate |
VZZKOKO |
KZAHLUNG |
BZUSAGE |
Commitment capital |
VZZKOKO |
BZUSAGE |
PEFFZINS |
Effective interest rate |
VZZKOKO |
PEFFZINS |
SEFFMETH |
Effective interest method (Financial Mathematics) |
VZZKOKO |
SEFFMETH |
SZBMETH |
Interest calculation method |
VZZKOKO |
SZBMETH |
SDISKO |
Discounted |
VZZKOKO |
SDISKO |
DKUEND |
Notice date |
VZZKOKO |
DKUEND |
SKUEND |
Indicator notice reason |
VZZKOKO |
SKUEND |
DKUENDDG |
Notice date (lender) |
VZZKOKO |
DKUENDDG |
DBLFZ |
Term start |
VZZKOKO |
DBLFZ |
DELFZ |
End of term |
VZZKOKO |
DELFZ |
PMANEFFZ |
Effective interest rate |
VZZKOKO |
PMANEFFZ |
SEFFM2 |
Effective interest method (Financial Mathematics) |
VZZKOKO |
SEFFM2 |
SKUEGL |
Notice arrangement (lender) |
VZZKOKO |
SKUEGL |
DEFSZ |
Date end of fixed period |
VZZKOKO |
DEFSZ |
DABEFFZ |
Start date of effective interest calculation |
VZZKOKO |
DABEFFZ |
DKUENDDN |
Earliest notice date borrower |
VZZKOKO |
DKUENDDN |
SKUEDN |
Notice arrangement borrower |
VZZKOKO |
SKUEDN |
SKUEART |
Indicator notice type for the loan |
VZZKOKO |
SKUEART |
SZSREF |
Reference interest rate |
VZZKOPO |
SZSREF |
INTEB |
Internal level |
TZC37 |
INTEB |
Particular Features of the Extractor
Extractor based on a function module