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 |