TTONFTVDARL SAP () Table details
Dictionary Type: Table
Description:
Description:
Table field list including key, data, relationships and ABAP select examples
TTONFTVDARL is a standard SAP Table which is used to store data and is available within R/3 SAP systems depending on the version and release level.
The TTONFTVDARL table consists of various fields, each holding specific information or linking keys about data available in SAP. These include GUID (GUID in 'RAW' format), BUKRS (Company Code), SARCHIV (Archiving Category Indicator), RANL (Contract Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP TTONFTVDARL table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
GUID | GUID in 'RAW' format | GUID_16 | RAW | 16 | SYSUUID | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | SARCHIV | ARC | |||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
FLG_STATE | 0 | ||||||||
IM_SSOLIST | Plan/Actual principle | VVSSOLIST | CHAR | 1 | VVSSOLIST | ||||
IM_SAKTPAS | Indicator: Asset/Liability Transaction | VVSAKTPAS | CHAR | 1 | VVSAKTPAS | ||||
IM_END_DATE | 0 | ||||||||
IM_LOANCHARAC | 0 | ||||||||
BFRATE_OLD | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
BFRATE_NEW | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
DATUM_LFZ_OLD | 0 | ||||||||
DATUM_LFZ_NEW | 0 | ||||||||
DRSALDO_OLD | 0 | ||||||||
DRSALDO_NEW | 0 | ||||||||
RSALDO_OLD | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
RSALDO_NEW | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
SSTATI | Status of data record | SSTATI | NUMC | 2 | Assigned to domain | STATI | |||
SANLF | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
GSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 8 | Assigned to domain | USTRU | KRE | ||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
HKTID | ID for account details | HKTID | CHAR | 5 | Assigned to domain | HKTID | |||
STITEL | Loan Type Indicator | STITEL | NUMC | 3 | Assigned to domain | STITEL | |||
SGLZB | SCB asset group indicator | SGLZB | CHAR | 4 | Assigned to domain | SGLZB | |||
SFIBG | Asset Grouping Indicator | SFIBG | NUMC | 4 | Assigned to domain | SFIBG | |||
SBILK | Balance Sheet Indicator | SBILK | CHAR | 2 | Assigned to domain | SBILK | |||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XALLB | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
XAKT | File Number | XAKT | CHAR | 32 | CHAR32 | ||||
RANLALT1 | Alternative Identification | RANLALT1 | CHAR | 13 | CHAR13 | ||||
RANLALT2 | Alternative identification 2 | RANLALT2 | CHAR | 13 | CHAR13 | ||||
SGR1 | Group Key 1 (Freely Available) | SGRP1 | CHAR | 6 | Assigned to domain | SGRP1 | |||
SGR2 | Group Key 2 (Freely Available) | SGRP2 | CHAR | 6 | Assigned to domain | SGRP2 | |||
RKLAMMER | Classification Number for Finance Projects | RKLAMMER | CHAR | 13 | ALPHA | RANL | |||
RANLKET | Principle loan investment number | RANLHPT | CHAR | 13 | CHAR13 | RAN | |||
RANTRAG | Application number | RANTRAG | CHAR | 13 | CHAR13 | ||||
SSOLIST | Plan/Actual principle | VVSSOLIST | CHAR | 1 | VVSSOLIST | ||||
SFRIST | Loan Term | SFRIST | NUMC | 2 | Assigned to domain | SFRIST | |||
BANTRAG | Capital applied for | BANTRAG | CURR | 13(2) | BWHR | ||||
SANTWHR | Currency | SWHR | CUKY | 5 | Assigned to domain | WAERS | WHR | ||
DANTRAG | Entry Date of Loan Application | DANTRAG | DATS | 8 | DATUM | ||||
BZUSAGE | Commitment capital | BZUSAGE | CURR | 13(2) | WERTV7 | ||||
DZUSAGE | Loan - Date of Commitment by Lender | DZUSAGE | DATS | 8 | DATUM | ||||
DZUSAGE_ORIGIN | Date of the Original Approval from the Lender | DZUSAGE_ORIGIN | DATS | 8 | DATUM | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Loan Term | DENDLFZ | DATS | 8 | DATUM | ||||
DBDIS | Start of distribution of discount | DBDIS | DATS | 8 | DDAT | ||||
SDISMETH | Discount distribution method | SDISMETH | NUMC | 1 | DISMETH | ||||
SSICHER | Primary collateral | SSICHER | CHAR | 4 | Assigned to domain | SSICH | |||
SVZWECK | Purpose of Loan | SVZWECK | CHAR | 2 | Assigned to domain | SVZWK | |||
SSONDER | Special treatment of loan | SSONDER | NUMC | 2 | Assigned to domain | SSONDER | |||
SFIWO | Indicator: Type of Residential Object Financing | SFIWO | CHAR | 2 | Assigned to domain | SFIWO | |||
SDTI | DTI indicator | SDTI | NUMC | 5 | NUMC | ||||
SHOME | Home statement | SHOME | NUMC | 3 | Assigned to domain | SHOME | |||
SLAENDER | Country ID | SLAENDER | CHAR | 3 | Assigned to domain | LAND1 | |||
AABTRET | Number of Assignments Still Possible | AABTRET | NUMC | 2 | NUM02 | ||||
BABTRET | Minimum amount for assignments | BABTRET | CURR | 13(2) | BWHR | ||||
SNICHTAB | Reason for Non-Acceptance | SNICHTAB | NUMC | 2 | Assigned to domain | SNICHTAB | |||
DARCHIV | Date of Rejection/Withdrawal | DARCHIV | DATS | 8 | DATUM | ||||
BGESDAR | Total amount of syndicated loan | BGESDAR | CURR | 13(2) | BWHR | ||||
DKONS | Syndicate loan date | DKONS | DATS | 8 | DATUM | ||||
SKWGKRED | Credit category indicator Para. 75 report (Austria) | SKWGKRED | NUMC | 1 | Assigned to domain | SKWGKRED | |||
SKWGDAR | Credit type indicator for Austrian reporting | SKWGDAR | NUMC | 1 | Assigned to domain | SKWGDAR | |||
JORIG | Posting system indicator for borrower's note loans | BUCHSYS | NUMC | 1 | BUCHSYS | ||||
VVSLOEKZ | Deletion indicator | VVSLOEKZ | NUMC | 1 | VVSLOEKZ | ||||
SDTYP | Loans Class | VVSDTYP | NUMC | 3 | Assigned to domain | VVSDTYP | |||
DBEWI | Approval date | VVDBEWI | DATS | 8 | DATUM | ||||
SABTRANS | Indicator for Possible Foreign Assignment | VVSABTRANS | CHAR | 1 | XFELD | ||||
AKONS | Number of syndicate members | VVAKONS | NUMC | 3 | NUM03 | ||||
SFGKZ | Release Indicator | VVSFGKZ | CHAR | 1 | VVSFGKZ | ||||
SABT | Assignee | VVSABT | CHAR | 4 | Assigned to domain | VVSABT | |||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
MAHNS | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
RPNR | Activity number/rollover number | VVRPNR | NUMC | 8 | NUMC08 | ||||
RSBEAR | Dummy field 12 characters CHAR | DUMMY_12 | CHAR | 12 | CHAR12 | ||||
SONDST | Special posting treatment | VVSONDST | CHAR | 2 | Assigned to domain | VVSONDST | |||
SGRP3 | Group Key 3 (Freely Available) | SGRP3 | CHAR | 6 | Assigned to domain | SGRP3 | |||
SGRP4 | Group Key 4 (Freely Available) | SGRP4 | CHAR | 6 | Assigned to domain | SGRP4 | |||
SZKEY | Indicator for Control of Incoming Payment Distribution | VVSZKEY | NUMC | 2 | Assigned to domain | VVSZKEY | |||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
SVERFU | Type of Restraint on Drawing | VVSVERFU | NUMC | 2 | Assigned to domain | VVSVERFU | |||
STITART | Borrower's Note Loan Security Type | VVSTITART | NUMC | 2 | Assigned to domain | VVSTITART | |||
NABTRV | Contract of assignment number | VVNABTRV | CHAR | 15 | CHAR15 | ||||
NAVAL | Guarantee number | VVNAVAL | CHAR | 15 | CHAR15 | ||||
DABTR | Date of assignment | VVDABTR | DATS | 8 | DATUM | ||||
DVERFU | Date of restraint on disposal upto | VVDVERFU | DATS | 8 | DATUM | ||||
SFGBEW | Transaction data to be released available | VVSFGBEW | NUMC | 2 | VVSFGBEW | ||||
DELSOZ | Date of last special interest payment period | VVDLESOZ | DATS | 8 | DATUM | ||||
RPORTB | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
SREGION | Sales Region | VVSREGION | CHAR | 4 | Assigned to domain | VVSREGION | |||
SGESST | Branch Office | VVSGESST | CHAR | 4 | Assigned to domain | VVSGESST | |||
SBEA | Loan Processing Indicator | VVSBEA | NUMC | 2 | VVSBEA | ||||
SOBEZ | Organizational District | VVSOBEZ | CHAR | 2 | CHAR2 | ||||
SBEZIRK | Agent District | VVSBEZIRK | CHAR | 4 | CHAR4 | ||||
SPLIT | Debit position splitting | VVSPLIT | CHAR | 1 | XFELD | ||||
BNBUERG | Initial capital not guaranteed | VVBNBUERG | CURR | 13(2) | WERTV7 | ||||
SREFZINS | Loan With Reference Interest Rate | VVSREFZINS | CHAR | 1 | XFELD | ||||
SMAHNM | Loan Manual Dunning Level | VVSMAHNM | CHAR | 1 | Assigned to domain | VVSMAHNM | |||
SIHERK | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
RGENUM | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
DRUECK | Date when loan will probably be redeemed | VVDRUECK | DATS | 8 | DATUM | ||||
SABGRENZ | Loan Discount Accrual/Deferral Method | VVSABGRD | CHAR | 1 | VVSABGRD | ||||
SFEST | Indicator for Control of Fixed Contract | VVFESTKZ | CHAR | 1 | VVFESTKZ | ||||
SRATING | Rating | BP_RATING | CHAR | 3 | Assigned to domain | BP_RATING | |||
SRATAGEN | Rating agency | SRATAGEN_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
RDARNEHM | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
OBJNR | Object Number for Financial Transactions | TB_FINOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
SKWG14_NEU | Position grouping acc. Para 14 GBA (Sec. and loans) | VVSKWG14 | CHAR | 2 | VVSKWG14 | ||||
RANLSTAMNR | Master number part of loan number for finding contracts | RANLSTAMNR | CHAR | 13 | ALPHA | RANL | |||
MIGDATE | Migration date | MIGDATE | DATS | 8 | DATUM | ||||
SDUNNCMP | Summarization Level for Dunning Letter | SDUNNCMP | CHAR | 2 | SDUNNCMP | ||||
XNODUNN | Exclude Loan from Dunning Run | XNODUNN | CHAR | 1 | XFELD | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
SDUNCHARG | Post Dunning Charges and Interest to this Contract | SDUNCHARG | CHAR | 1 | XFELD | ||||
SWHRORG | Loan currency before conversion to EURO | SWHRORG | CUKY | 5 | Assigned to domain | WAERS | |||
DCONVERT | Date loan was converted to EURO | DCONVERT | DATS | 8 | DATE | ||||
DCORRECT | Date for adjustment flows resulting from EURO conversion | DCORRECT | DATS | 8 | DATE | ||||
SAKTPAS | Indicator: Asset/Liability Transaction | VVSAKTPAS | CHAR | 1 | VVSAKTPAS | ||||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
JNOREPAY | Payoff Lock | TB_JNOREPAY | CHAR | 1 | XFELD | ||||
JNODOIP | Blocked by Payoff: No Open Item Clearing for Loan | TB_JNODOIP | CHAR | 1 | XFELD | ||||
COM_VAL_CLASS | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | Assigned to domain | TPM_COM_VAL_CLASS | CVC | ||
SARC_EXCL | Documents For The Loan May Not Be Archived | TB_SARC_EXCL | CHAR | 1 | T_SARC_EXCL | ||||
SARC_DOCS | Indicator: Archived Loan Documents Exist | TB_SARC_DOCS | CHAR | 1 | T_SARC_DOCS | ||||
NO_PLAN_DONE | Do Not Transfer Loan to Status 'Completed' | TB_NO_PLAN_DONE | CHAR | 1 | CHECKBOX | ||||
DPLAN_SET | Date of Transfer of Contract into Status Planned Completed | TB_DPLAN_SET | DATS | 8 | DATUM | ||||
DOPEN | Opening Date of a Loan Contract | TB_DOPEN | DATS | 8 | DATUM | ||||
DCLOSE | Closing Date of a Loan Contract | TB_DCLOSE | DATS | 8 | DATUM | ||||
DUNN_BLOCK_TILL | Expiration Date of Dunning Lock | TB_VIEW_DATE_DUNNING_BLOCK_TIL | DATS | 8 | DATUM | ||||
XNOIOA | Lock for Interest on Arrears | TB_XNOIOA | CHAR | 1 | CHAR1 | ||||
NOIOA_TILL | Expiry Date of Lock on Interest on Arrears | TB_NOIOA_TILL | DATS | 8 | DATUM | ||||
ORIGIN | Loan Origin | TB_ORIGIN | CHAR | 2 | Assigned to domain | T_ORIGIN | |||
DCALLEND | Provision Expiry Date | TB_DCALLEND | DATS | 8 | DATUM | ||||
SVER_EXCL | Documents for the loan may not be summarized | TB_SVER_EXCL | CHAR | 1 | T_SVER_EXCL | ||||
LC_DISBURSEMENT | Processing Characteristic: Disbursement Status | TB_LC_CHARAC_DISBURSEMENT | CHAR | 1 | Assigned to domain | T_LC_CHARACVALUE | H_VD_CHARAC_DISBURSEMENT | ||
LC_CAPITALS | Processing Characteristic: Status of Capital Amounts | TB_LC_CHARAC_CAPITALS | CHAR | 1 | Assigned to domain | T_LC_CHARACVALUE | H_VD_CHARAC_CAPITALS | ||
LC_PLANNED_FLOW | Processing Characteristic: Status of Planned Records | TB_LC_CHARAC_PLANNED_FLOW | CHAR | 1 | Assigned to domain | T_LC_CHARACVALUE | H_VD_CHARAC_PLANNED_FLOW | ||
LC_DEBIT | Processing Characteristic: Status of Customer Receivables | TB_LC_CHARAC_DEBIT | CHAR | 1 | Assigned to domain | T_LC_CHARACVALUE | H_VD_CHARAC_DEBIT | ||
LC_CREDIT | Processing Characteristic: Status of Customer Payables | TB_LC_CHARAC_CREDIT | CHAR | 1 | Assigned to domain | T_LC_CHARACVALUE | H_VD_CHARAC_CREDIT | ||
LC_STATUS | Status of Processing Characteristics for Loan | TB_LC_STATUS | CHAR | 1 | T_LC_STATUS | ||||
PAYM_STATUS | Payment Status | TB_PAYM_STATUS | CHAR | 1 | T_PAYM_STATUS | ||||
STOP_INDICATOR | Stop Indicator | TB_STOP_INDICATOR | CHAR | 1 | T_STOP_INDICATOR | ||||
PRODUCT_ID | Internal Product ID | TB_PR_PRODINT | CHAR | 18 | Assigned to domain | T_PR_PRODINT | |||
PRODUCT_VERSION | Product Version | TB_PR_VERSION | NUMC | 4 | Assigned to domain | T_PR_VERSION | TD_PRODVERSION | ||
SCHUFA_MESSAGE | Business Partner Has Signed a Schufa Declaration | TB_VIEW_SCHUFA | CHAR | 1 | XFELD | ||||
DAT_FULL_PAY | Date of Full Disbursement | TB_VIEW_DATE_OF_FULL_PAYMENT | DATS | 8 | DATUM | ||||
DAT_OF_CANCEL | Rescission Date | TB_VIEW_DATE_OF_CANCELATION | DATS | 8 | DATUM | ||||
FLG_CNCL | Rescission Indicator | TB_CNCL | CHAR | 1 | BOOLE | ||||
DINSTR | Date Customer Was Instructed About Rescission Rights | TB_DINSTR | DATS | 8 | DATUM | ||||
ORGUNIT | Organizational Unit | TB_MD_ORGUNIT_CNMGT | CHAR | 12 | Assigned to domain | T_MD_ORGUNIT_CNMGT | |||
DISTRIB_CHANNEL | Sales Channel | TB_MD_DISTRIBUTION_CHANNEL | CHAR | 10 | Assigned to domain | T_MD_DISTRIBUTION_CHANNEL | |||
FLG_CNCL_CLI | Indicator: Rescind Credit Life Insurance | TB_CNCL_CLI | CHAR | 1 | T_CNCL_CLI | ||||
FLG_NO_CHANGE | Only Limited Changes Possible for Contract Indicator | TB_MD_NO_CHANGE | CHAR | 1 | TB_MD_NO_CHANGE | ||||
SCHEME_ID | Calculation Profile for Interest on Arrears Calculation | TB_SCHEME_ID | CHAR | 3 | Assigned to domain | T_SCHEME_ID |
Key field | Non-key field |
How do I retrieve data from SAP table TTONFTVDARL using ABAP code
The following ABAP code Example will allow you to do a basic selection on TTONFTVDARL to SELECT all data from the tableDATA: WA_TTONFTVDARL TYPE TTONFTVDARL.
SELECT SINGLE *
FROM TTONFTVDARL
INTO CORRESPONDING FIELDS OF WA_TTONFTVDARL
WHERE...
How to access SAP table TTONFTVDARL
Within an ECC or HANA version of SAP you can also view further information about TTONFTVDARL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects