VDORDER - Borrower's note loan order data
Borrower's note loan order data information is stored in SAP table VDORDER.
It is part of development package FVVD in software component FS-CML. This development package consists of objects that can be grouped under "Treasury Loans".
It is part of development package FVVD in software component FS-CML. This development package consists of objects that can be grouped under "Treasury Loans".
Fields for table VDORDER
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
| RANL | Contract Number | X | RANL | CHAR | 26 | |
| NORDER | Order Number | X | NORDER | NUMC | 16 | |
| RERF | Entered By | RERF | CHAR | 24 | ||
| DERF | First Entered On | DERF | DATS | 16 | ||
| TERF | Time of Creation | TERF | TIMS | 12 | ||
| REHER | Source of Initial Entry | REHER | CHAR | 20 | ||
| RBEAR | Employee ID | RBEAR | CHAR | 24 | ||
| DBEAR | Last Edited On | DBEAR | DATS | 16 | ||
| TBEAR | Last Edited At | TBEAR | TIMS | 12 | ||
| RBHER | Editing Source | RBHER | CHAR | 20 | ||
| SABRECH | Status borrower's note order | SSDSTAT | CHAR | 2 | ||
| SBEWART | Flow Type | SBEWART | CHAR | 8 | ||
| SBEWZITI | Flow category | SBEWZITI | CHAR | 8 | TZB03 | |
| SPLANIST | Plan/actual record/record to be released indicator | SPLANIST | CHAR | 2 | ||
| SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 2 | ||
| SANLF | Product Category | SANLF | NUMC | 6 | ||
| SSTATI | Order Status | VVDSTATORD | NUMC | 4 | ||
| GSART | Product Type | VVSART | CHAR | 6 | TZPAB | |
| RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 16 | T037S | |
| DORDER | Order day | DORDER | DATS | 16 | ||
| BNWHR | Nominal amount | BNWHR | CURR | 7 | ||
| SNWHR | Currency of nominal amount | SNWHR | CUKY | 10 | TCURC | |
| BBWHR | Amount in position currency | BBWHR | CURR | 7 | ||
| SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 10 | TCURC | |
| BCWHR | Settlement Amount | BCWHR | CURR | 7 | ||
| SCWHR | Settlement Currency | SCWHR | CUKY | 10 | TCURC | |
| BHWHR | Amount in local currency | BHWHR | CURR | 7 | ||
| KURS1 | Exchange rate | VVKURSF | DEC | 5 | ||
| KURS2 | Exchange rate | VVKURSF | DEC | 5 | ||
| DVALUT | Calculation Date | DVALUT | DATS | 16 | ||
| DFAELL | Due date/calculation date | DFAELLIG | DATS | 16 | ||
| DDISPO | Payment Date | DDISPO | DATS | 16 | ||
| DBESTAND | Position value date | DBESTAND | DATS | 16 | ||
| DBERVON | Start of Calculation Period | DBERVON | DATS | 16 | ||
| DBERBIS | End of Calculation Period | DBERBIS | DATS | 16 | ||
| ATAGE | Number of Days | VVATAGE | NUMC | 12 | ||
| ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 12 | ||
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 2 | ||
| JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 2 | ||
| JZINSBAS | Flow in interest base | JZINSBAS | CHAR | 2 | ||
| JZINSZPT | Interest date | JZINSZPT | CHAR | 2 | ||
| PKOND | Percentage rate for condition items | PKOND | DEC | 6 | ||
| BBASIS | Calculation Base Amount | BBASIS | CURR | 7 | ||
| SSORTZIT | Sort indicator for interest/repayment schedule calculations | SSORTZIT | CHAR | 2 | ||
| SWOHER | Source of flow record | SWOHER | CHAR | 2 | ||
| SSTCKKZ | Accrued interest method | SSTCKKZ | CHAR | 2 | ||
| SSTCKTG | Accrued interest: Daily method | SSTCKTG | CHAR | 2 | ||
| PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 6 | ||
| SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 2 | ||
| PARTNR | Business Partner Number | BU_PARTNER | CHAR | 20 | BUT000 | |
| SROLEXT | Dummy function | DUMMY_3 | CHAR | 6 | ||
| XPART | Name of Contact Person (User-Defined Text) | XPART | CHAR | 60 | ||
| SANRED | Form of Address (Key) | BP_TITLE_NEW | CHAR | 8 | TSAD3 | |
| SWORTL | Wording of order/contract | SWORTL | NUMC | 4 | TD20 | |
| DVKMAX | Value date for preemption at the latest by | DVKMAX | DATS | 16 | ||
| KKASSE | Cash price for repeat purchases | KKASSE | DEC | 6 | ||
| KMARKT | Market price for preemptions | KMARKT | DEC | 6 | ||
| BVTYP | Partner bank type | BVTYP | CHAR | 8 | ||
| RBANKK | Bank account | RBANKK | CHAR | 20 | ||
| PWKURS | Security price for percentage quotation | PWKURS | DEC | 6 | ||
| SGTXT | Item Text | SGTXT | CHAR | 100 | ||
| RDEALER | Trader | RDEALER | CHAR | 24 | TZDEA | |
| DVKMIN | Preemption payment date Poss. as from | DVKMIN | DATS | 16 | ||
| XPORE | Indicator: Individual Payment? | PRQ_XPORE | CHAR | 2 | ||
| SPAYRQ | Generate Payment Request | TB_SPAYRQK | CHAR | 2 | ||
| HBKID | Short Key for a House Bank | HBKID | CHAR | 10 | T012 | |
| HKTID | ID for Account Details | HKTID | CHAR | 10 | T012K | |
| SPRSNG | Individual Payment | TB_SPRSNGK | CHAR | 2 | ||
| UZAWE | Payment method supplement | UZAWE | CHAR | 4 | ||
| SPRGRD | Determine Grouping Definition | TB_SPRGRD | CHAR | 2 | ||
| SCSPAY | Same Direction Necessary for Joint Payment? | TB_SCSPAY | CHAR | 2 | ||
| PAYGR | Grouping Field for Automatic Payments | PAYGR | CHAR | 40 |